1. Home
    2. ›
  2. Trivia
    3. ›
  3. Guess Their Answer

Guess Their Answer

Trivia
Rating
Version 1.65
Size 62.4 MB
Go Download
Advertisement
Advertisement

Editor's Review

This game is easy: you just have to guess what people think of first.

What makes a lot of noise? A rock band? A baby? A race car?

Give the most popular answer to gather as many audience members behind you as you can. But be faster than your opponent if you want to win bragging rights.

Download it now to enjoy hundreds of funny questions.

Information

Platform: Android
Version: 1.65
Category: Trivia
Price: Free
Size: 62.4 MB
Developer:TapNation

Download

Download APK (62.4 MB) Download on Google Play

Ratings

4.3
Total 1,656
5
4
3
2
1
Click Stars To Rate :

Similar Games

Popular Games

You may also like

com.pocketstory.Philo

Philo

4.6
Trivia
Details
com.JaddZayed.GuessTheDrawing

Guess The Drawing

4.6
Trivia
Details
com.fullfat.textordie

Text or Die

4.6
Trivia
Details
com.qoni.guesstheiranswer

Guess Their Answer

4.6
Trivia
Details
com.trivia.star.android

TRIVIA STAR

4.6
Trivia
Details
se.maginteractive.quizduel2

NEW QuizDuel!

4.6
Trivia
Details
com.unicostudio.whois

Who is? Brain Teaser & Riddles

4.6
Trivia
Details
com.unicostudio.braintest

Brain Test

4.6
Trivia
Details
pixduel

Pixduel

4.6
Trivia
Details
trivia-crack

Trivia Crack

4.6
Trivia
Details
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-06-08 17:52:14 HTTP/1.1 GET : https://game.appurse.com/com.qoni.guesstheiranswer.html
  2. 运行时间 : 0.858886s [ 吞吐率：1.16req/s ] 内存消耗：4,418.32kb 文件加载：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.000287s ] mysql:host=localhost;port=3306;dbname=appr_game;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `app_list` [ RunTime:0.000914s ]
  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.355032s ]
  4. SHOW FULL COLUMNS FROM `app_category` [ RunTime:0.001006s ]
  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.000631s ]
  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.071854s ]
  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.qoni.guesstheiranswer' AND `d`.`lang_id` = '1' AND `d`.`is_dmca` = '0' LIMIT 1 [ RunTime:0.002933s ]
  8. SHOW FULL COLUMNS FROM `app_versions` [ RunTime:0.000871s ]
  9. SELECT `name`,`version`,`filesize` FROM `app_versions` WHERE `app_id` = 11242 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001601s ]
  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.000435s ]
  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.053482s ]
  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.053557s ]
  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` <> '11242' AND `c`.`id` = '38' 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.040981s ]
  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.054469s ]
  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.053483s ]
  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.052969s ]
  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 = 38 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.038318s ]
  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.000496s ]
  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.048042s ]
0.859990s