City Constructor-Free online casual games

afgame logo
Account
ID: 1201962
switch icon Switch Account
Social Linkage
google icon Google
Link
facebook icon Facebook
Unlink
Link
apple icon Apple
Unlink
Link
Delete Account
facebook icon
copy
Switch Account
google login icon
Google
facebook login icon
Facebook
apple login icon
Apple
  • Favourites icon Favourites
  • Recently Played icon Recently Played
  • Home icon Home
  • Top Charts icon Top Charts
  • Collection icon Collection
  • Privacy Policy icon Privacy Policy
  • Terms of Service icon Terms of Service
  • Cookie Policy icon Cookie Policy
  • Contact Us icon Contact Us
  • Instagram icon Instagram
  • Facebook icon Facebook
  • YouTube icon YouTube
  • Tiktok icon TikTok
  • X icon X

City Constructor

City Constructor
City Constructor
Rate
5.0
Top Charts
No. 579
Category
Puzzle
yes 1 Like
yes 0 Dislike
Add to favorites Add to favorites
Share Share
Fullscreen Fullscreen
Similar Game
Screw Master 3D:Pin Puzzle
Screw Master 3D:Pin Puzzle
Tetris Hint
Tetris Hint
Traffic Jam Hop On
Traffic Jam Hop On
2048 X2 Legends
2048 X2 Legends
Jam puzzle Collection
Jam puzzle Collection
Coin Sort Puzzle
Coin Sort Puzzle
Hexa Stack Sort
Hexa Stack Sort
Solitaire Winter
Solitaire Winter
Color Yarn Sort
Color Yarn Sort
left icon
left icon
banner banner banner

Game Info

Game name: City Constructor Rating:
5.0
Developer: English Category: Puzzle Languages: FPDA

About game City Constructor

Step into the boots of a heavy machinery operator! Take control of powerful excavators, towering cranes, rugged trucks, and more to tackle physics-based puzzles, transport cargo, and complete exciting construction tasks. With realistic mechanics, diverse levels, and gradually increasing difficulty, the game offers a satisfying blend of challenge and fun. Use your precision and logic to master construction sites, build bridges, and navigate mountain terrains. Perfect for all ages—whether you're a vehicle enthusiast or a simulation fan!
Read more

How to play City Constructor

Desktop Controls: A/D to move left/right, W/S to move up/down. Arrow keys control the arm. Spacebar grabs, releases, or performs actions. TAB switches vehicles. ESC pauses. Mobile: Use on-screen controls.
Read more

Comments

Total Comments: 0
Be the first to comment.
ad image
logo
We use cookies for content recommendations, traffic measurement, and personalized ads. By using this website, you agree to the Privacy Policy and Cookie Policy.
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-03-06 07:48:02 HTTP/1.1 GET : https://api-test.afgame.com/games/city-constructor
  2. 运行时间 : 0.101821s [ 吞吐率：9.82req/s ] 内存消耗：6,197.48kb 文件加载：203
  3. 查询信息 : 0 queries
  4. 缓存信息 : 0 reads,0 writes
  5. 会话信息 : SESSION_ID=0aa1e813c114d621ede39525b7a7e4fb
  1. /data/test/box_game_api/public/index.php ( 0.97 KB )
  2. /data/test/box_game_api/config/constant.php ( 0.39 KB )
  3. /data/test/box_game_api/vendor/autoload.php ( 0.17 KB )
  4. /data/test/box_game_api/vendor/composer/autoload_real.php ( 2.57 KB )
  5. /data/test/box_game_api/vendor/composer/platform_check.php ( 0.90 KB )
  6. /data/test/box_game_api/vendor/composer/ClassLoader.php ( 15.69 KB )
  7. /data/test/box_game_api/vendor/composer/autoload_static.php ( 14.89 KB )
  8. /data/test/box_game_api/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
  9. /data/test/box_game_api/vendor/symfony/deprecation-contracts/function.php ( 0.98 KB )
  10. /data/test/box_game_api/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
  11. /data/test/box_game_api/vendor/guzzlehttp/guzzle/src/functions.php ( 5.54 KB )
  12. /data/test/box_game_api/vendor/symfony/polyfill-php80/bootstrap.php ( 1.50 KB )
  13. /data/test/box_game_api/vendor/symfony/polyfill-mbstring/bootstrap.php ( 8.26 KB )
  14. /data/test/box_game_api/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
  15. /data/test/box_game_api/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
  16. /data/test/box_game_api/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
  17. /data/test/box_game_api/vendor/topthink/framework/src/think/Facade.php ( 2.71 KB )
  18. /data/test/box_game_api/vendor/adbario/php-dot-notation/src/helpers.php ( 0.57 KB )
  19. /data/test/box_game_api/vendor/mtdowling/jmespath.php/src/JmesPath.php ( 0.36 KB )
  20. /data/test/box_game_api/vendor/symfony/translation/Resources/functions.php ( 0.55 KB )
  21. /data/test/box_game_api/vendor/alibabacloud/client/src/Functions.php ( 5.33 KB )
  22. /data/test/box_game_api/vendor/google/apiclient-services/autoload.php ( 1.28 KB )
  23. /data/test/box_game_api/vendor/phpseclib/phpseclib/phpseclib/bootstrap.php ( 0.72 KB )
  24. /data/test/box_game_api/vendor/google/apiclient/src/aliases.php ( 3.05 KB )
  25. /data/test/box_game_api/vendor/google/apiclient/src/Client.php ( 43.87 KB )
  26. /data/test/box_game_api/vendor/google/apiclient/src/Service.php ( 1.91 KB )
  27. /data/test/box_game_api/vendor/google/apiclient/src/AccessToken/Revoke.php ( 2.29 KB )
  28. /data/test/box_game_api/vendor/google/apiclient/src/AccessToken/Verify.php ( 7.94 KB )
  29. /data/test/box_game_api/vendor/google/apiclient/src/Model.php ( 10.00 KB )
  30. /data/test/box_game_api/vendor/google/apiclient/src/Utils/UriTemplate.php ( 10.74 KB )
  31. /data/test/box_game_api/vendor/google/apiclient/src/AuthHandler/Guzzle6AuthHandler.php ( 3.12 KB )
  32. /data/test/box_game_api/vendor/google/apiclient/src/AuthHandler/Guzzle7AuthHandler.php ( 0.71 KB )
  33. /data/test/box_game_api/vendor/google/apiclient/src/AuthHandler/AuthHandlerFactory.php ( 1.58 KB )
  34. /data/test/box_game_api/vendor/google/apiclient/src/Http/Batch.php ( 7.97 KB )
  35. /data/test/box_game_api/vendor/google/apiclient/src/Http/MediaFileUpload.php ( 9.87 KB )
  36. /data/test/box_game_api/vendor/google/apiclient/src/Http/REST.php ( 6.28 KB )
  37. /data/test/box_game_api/vendor/google/apiclient/src/Task/Retryable.php ( 0.73 KB )
  38. /data/test/box_game_api/vendor/google/apiclient/src/Task/Exception.php ( 0.70 KB )
  39. /data/test/box_game_api/vendor/google/apiclient/src/Exception.php ( 0.68 KB )
  40. /data/test/box_game_api/vendor/google/apiclient/src/Task/Runner.php ( 8.03 KB )
  41. /data/test/box_game_api/vendor/google/apiclient/src/Collection.php ( 3.04 KB )
  42. /data/test/box_game_api/vendor/google/apiclient/src/Service/Exception.php ( 1.99 KB )
  43. /data/test/box_game_api/vendor/google/apiclient/src/Service/Resource.php ( 11.17 KB )
  44. /data/test/box_game_api/vendor/google/apiclient/src/Task/Composer.php ( 3.69 KB )
  45. /data/test/box_game_api/vendor/overtrue/pinyin/src/const.php ( 0.49 KB )
  46. /data/test/box_game_api/vendor/qcloud/cos-sdk-v5/src/Common.php ( 2.40 KB )
  47. /data/test/box_game_api/vendor/symfony/var-dumper/Resources/functions/dump.php ( 0.79 KB )
  48. /data/test/box_game_api/vendor/topthink/think-queue/src/common.php ( 1.01 KB )
  49. /data/test/box_game_api/vendor/topthink/framework/src/think/App.php ( 14.26 KB )
  50. /data/test/box_game_api/vendor/topthink/framework/src/think/Container.php ( 15.38 KB )
  51. /data/test/box_game_api/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
  52. /data/test/box_game_api/app/provider.php ( 0.19 KB )
  53. /data/test/box_game_api/vendor/topthink/framework/src/think/Http.php ( 6.12 KB )
  54. /data/test/box_game_api/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
  55. /data/test/box_game_api/vendor/topthink/framework/src/think/Env.php ( 4.64 KB )
  56. /data/test/box_game_api/app/common.php ( 18.03 KB )
  57. /data/test/box_game_api/vendor/topthink/framework/src/helper.php ( 18.44 KB )
  58. /data/test/box_game_api/vendor/topthink/framework/src/think/Config.php ( 5.03 KB )
  59. /data/test/box_game_api/config/aliSms.php ( 0.52 KB )
  60. /data/test/box_game_api/config/alibabaConfig.php ( 0.40 KB )
  61. /data/test/box_game_api/config/apiConfig.php ( 0.27 KB )
  62. /data/test/box_game_api/config/app.php ( 1.05 KB )
  63. /data/test/box_game_api/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  64. /data/test/box_game_api/config/cache.php ( 3.00 KB )
  65. /data/test/box_game_api/config/clickhouse.php ( 0.61 KB )
  66. /data/test/box_game_api/config/console.php ( 0.60 KB )
  67. /data/test/box_game_api/config/cookie.php ( 0.56 KB )
  68. /data/test/box_game_api/config/database.php ( 8.96 KB )
  69. /data/test/box_game_api/config/filesystem.php ( 1.37 KB )
  70. /data/test/box_game_api/config/jrttApiConfig.php ( 25.11 KB )
  71. /data/test/box_game_api/config/lang.php ( 0.81 KB )
  72. /data/test/box_game_api/config/log.php ( 4.49 KB )
  73. /data/test/box_game_api/config/middleware.php ( 0.19 KB )
  74. /data/test/box_game_api/config/payConfig.php ( 8.51 KB )
  75. /data/test/box_game_api/config/queue.php ( 1.42 KB )
  76. /data/test/box_game_api/config/route.php ( 1.54 KB )
  77. /data/test/box_game_api/config/session.php ( 0.57 KB )
  78. /data/test/box_game_api/config/sms.php ( 1.41 KB )
  79. /data/test/box_game_api/config/smsWhiteList.php ( 0.10 KB )
  80. /data/test/box_game_api/config/sourceUrlConfig.php ( 0.09 KB )
  81. /data/test/box_game_api/config/trace.php ( 0.34 KB )
  82. /data/test/box_game_api/config/view.php ( 0.82 KB )
  83. /data/test/box_game_api/config/wechatConfig.php ( 4.49 KB )
  84. /data/test/box_game_api/config/xsolla.php ( 1.14 KB )
  85. /data/test/box_game_api/app/event.php ( 0.25 KB )
  86. /data/test/box_game_api/vendor/topthink/framework/src/think/Event.php ( 6.96 KB )
  87. /data/test/box_game_api/app/service.php ( 0.13 KB )
  88. /data/test/box_game_api/app/AppService.php ( 0.26 KB )
  89. /data/test/box_game_api/vendor/topthink/framework/src/think/Service.php ( 1.67 KB )
  90. /data/test/box_game_api/vendor/topthink/framework/src/think/Lang.php ( 7.60 KB )
  91. /data/test/box_game_api/app/lang/en-us.php ( 4.21 KB )
  92. /data/test/box_game_api/vendor/topthink/framework/src/think/initializer/Error.php ( 3.19 KB )
  93. /data/test/box_game_api/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  94. /data/test/box_game_api/vendor/services.php ( 0.17 KB )
  95. /data/test/box_game_api/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  96. /data/test/box_game_api/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  97. /data/test/box_game_api/vendor/topthink/framework/src/think/service/ModelService.php ( 1.76 KB )
  98. /data/test/box_game_api/vendor/topthink/think-queue/src/queue/Service.php ( 1.24 KB )
  99. /data/test/box_game_api/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  100. /data/test/box_game_api/vendor/topthink/framework/src/think/Middleware.php ( 6.78 KB )
  101. /data/test/box_game_api/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  102. /data/test/box_game_api/vendor/topthink/think-orm/src/Paginator.php ( 11.80 KB )
  103. /data/test/box_game_api/vendor/topthink/framework/src/think/Validate.php ( 46.10 KB )
  104. /data/test/box_game_api/vendor/topthink/think-orm/src/Model.php ( 25.67 KB )
  105. /data/test/box_game_api/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  106. /data/test/box_game_api/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  107. /data/test/box_game_api/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 17.61 KB )
  108. /data/test/box_game_api/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 26.12 KB )
  109. /data/test/box_game_api/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.27 KB )
  110. /data/test/box_game_api/vendor/topthink/think-orm/src/model/concern/TimeStamp.php ( 5.70 KB )
  111. /data/test/box_game_api/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 10.41 KB )
  112. /data/test/box_game_api/vendor/topthink/framework/src/think/Db.php ( 2.87 KB )
  113. /data/test/box_game_api/vendor/topthink/think-orm/src/DbManager.php ( 8.28 KB )
  114. /data/test/box_game_api/vendor/topthink/framework/src/think/Log.php ( 8.50 KB )
  115. /data/test/box_game_api/vendor/topthink/framework/src/think/Manager.php ( 3.98 KB )
  116. /data/test/box_game_api/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.04 KB )
  117. /data/test/box_game_api/vendor/topthink/framework/src/think/Cache.php ( 4.79 KB )
  118. /data/test/box_game_api/vendor/psr/simple-cache/src/CacheInterface.php ( 4.50 KB )
  119. /data/test/box_game_api/vendor/topthink/think-helper/src/helper/Arr.php ( 16.63 KB )
  120. /data/test/box_game_api/vendor/topthink/framework/src/think/cache/driver/File.php ( 7.42 KB )
  121. /data/test/box_game_api/vendor/topthink/framework/src/think/cache/Driver.php ( 8.06 KB )
  122. /data/test/box_game_api/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 2.25 KB )
  123. /data/test/box_game_api/vendor/topthink/framework/src/think/Console.php ( 22.65 KB )
  124. /data/test/box_game_api/app/Request.php ( 0.09 KB )
  125. /data/test/box_game_api/vendor/topthink/framework/src/think/Request.php ( 54.04 KB )
  126. /data/test/box_game_api/app/middleware.php ( 0.25 KB )
  127. /data/test/box_game_api/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  128. /data/test/box_game_api/vendor/topthink/think-trace/src/TraceDebug.php ( 2.94 KB )
  129. /data/test/box_game_api/vendor/topthink/framework/src/think/middleware/SessionInit.php ( 2.06 KB )
  130. /data/test/box_game_api/vendor/topthink/framework/src/think/Session.php ( 1.80 KB )
  131. /data/test/box_game_api/vendor/topthink/framework/src/think/session/driver/File.php ( 6.28 KB )
  132. /data/test/box_game_api/vendor/topthink/framework/src/think/contract/SessionHandlerInterface.php ( 0.87 KB )
  133. /data/test/box_game_api/vendor/topthink/framework/src/think/session/Store.php ( 7.26 KB )
  134. /data/test/box_game_api/vendor/topthink/framework/src/think/Route.php ( 23.74 KB )
  135. /data/test/box_game_api/vendor/topthink/framework/src/think/route/RuleName.php ( 5.30 KB )
  136. /data/test/box_game_api/vendor/topthink/framework/src/think/route/Domain.php ( 5.41 KB )
  137. /data/test/box_game_api/vendor/topthink/framework/src/think/route/RuleGroup.php ( 13.91 KB )
  138. /data/test/box_game_api/vendor/topthink/framework/src/think/route/Rule.php ( 22.98 KB )
  139. /data/test/box_game_api/route/android.php ( 3.38 KB )
  140. /data/test/box_game_api/vendor/topthink/framework/src/think/facade/Route.php ( 4.84 KB )
  141. /data/test/box_game_api/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.23 KB )
  142. /data/test/box_game_api/route/apis.php ( 7.50 KB )
  143. /data/test/box_game_api/route/app.php ( 1.56 KB )
  144. /data/test/box_game_api/route/pay.php ( 1.45 KB )
  145. /data/test/box_game_api/route/sdkApi.php ( 2.71 KB )
  146. /data/test/box_game_api/route/view.php ( 2.81 KB )
  147. /data/test/box_game_api/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 6.61 KB )
  148. /data/test/box_game_api/vendor/topthink/framework/src/think/route/Dispatch.php ( 6.93 KB )
  149. /data/test/box_game_api/vendor/topthink/framework/src/think/middleware/AllowCrossDomain.php ( 2.08 KB )
  150. /data/test/box_game_api/app/controller/view/Game.php ( 12.98 KB )
  151. /data/test/box_game_api/app/controller/view/ViewBaseController.php ( 9.34 KB )
  152. /data/test/box_game_api/vendor/topthink/framework/src/think/facade/Log.php ( 2.94 KB )
  153. /data/test/box_game_api/vendor/topthink/framework/src/think/log/driver/File.php ( 6.17 KB )
  154. /data/test/box_game_api/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  155. /data/test/box_game_api/vendor/topthink/framework/src/think/log/Channel.php ( 6.54 KB )
  156. /data/test/box_game_api/vendor/topthink/framework/src/think/event/LogRecord.php ( 0.86 KB )
  157. /data/test/box_game_api/vendor/topthink/framework/src/think/event/LogWrite.php ( 0.88 KB )
  158. /data/test/box_game_api/app/service/CacheService.php ( 8.39 KB )
  159. /data/test/box_game_api/vendor/topthink/framework/src/think/facade/Cache.php ( 2.02 KB )
  160. /data/test/box_game_api/vendor/topthink/framework/src/think/cache/driver/Redis.php ( 6.72 KB )
  161. /data/test/box_game_api/app/model/user/UserModel.php ( 0.47 KB )
  162. /data/test/box_game_api/app/model/BaseModel.php ( 3.90 KB )
  163. /data/test/box_game_api/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 4.39 KB )
  164. /data/test/box_game_api/vendor/topthink/think-orm/src/db/PDOConnection.php ( 52.45 KB )
  165. /data/test/box_game_api/vendor/topthink/think-orm/src/db/Connection.php ( 7.67 KB )
  166. /data/test/box_game_api/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.56 KB )
  167. /data/test/box_game_api/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 15.93 KB )
  168. /data/test/box_game_api/vendor/topthink/think-orm/src/db/Builder.php ( 41.58 KB )
  169. /data/test/box_game_api/vendor/topthink/think-orm/src/db/Query.php ( 10.64 KB )
  170. /data/test/box_game_api/vendor/topthink/think-orm/src/db/BaseQuery.php ( 36.47 KB )
  171. /data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.50 KB )
  172. /data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  173. /data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 16.06 KB )
  174. /data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 6.29 KB )
  175. /data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.85 KB )
  176. /data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 16.22 KB )
  177. /data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 6.86 KB )
  178. /data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.36 KB )
  179. /data/test/box_game_api/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.51 KB )
  180. /data/test/box_game_api/app/model/common/GameModel.php ( 5.13 KB )
  181. /data/test/box_game_api/vendor/topthink/framework/src/think/facade/Config.php ( 1.37 KB )
  182. /data/test/box_game_api/app/model/common/GameCategoryModel.php ( 2.67 KB )
  183. /data/test/box_game_api/vendor/topthink/think-orm/src/model/Collection.php ( 6.78 KB )
  184. /data/test/box_game_api/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  185. /data/test/box_game_api/app/model/user/UserCollectGameModel.php ( 2.65 KB )
  186. /data/test/box_game_api/app/model/common/GameRateRecordModel.php ( 0.85 KB )
  187. /data/test/box_game_api/vendor/topthink/think-orm/src/facade/Db.php ( 0.94 KB )
  188. /data/test/box_game_api/app/model/user/UserRecentlyPlayModel.php ( 2.39 KB )
  189. /data/test/box_game_api/app/model/game/GameTopChartsModel.php ( 1.83 KB )
  190. /data/test/box_game_api/app/model/common/GameDetailModel.php ( 4.10 KB )
  191. /data/test/box_game_api/app/model/common/GameCategoryMapModel.php ( 3.00 KB )
  192. /data/test/box_game_api/vendor/topthink/think-orm/src/db/Raw.php ( 1.39 KB )
  193. /data/test/box_game_api/vendor/topthink/think-orm/src/db/Fetch.php ( 12.82 KB )
  194. /data/test/box_game_api/app/model/common/CommentModel.php ( 1.75 KB )
  195. /data/test/box_game_api/vendor/topthink/think-template/src/Template.php ( 47.01 KB )
  196. /data/test/box_game_api/vendor/topthink/think-template/src/template/driver/File.php ( 2.33 KB )
  197. /data/test/box_game_api/vendor/topthink/think-template/src/template/taglib/Cx.php ( 24.23 KB )
  198. /data/test/box_game_api/vendor/topthink/think-template/src/template/TagLib.php ( 12.25 KB )
  199. /data/test/box_game_api/public/cache/13ad905de834cee487fc547bbbcf59f4.php ( 215.03 KB )
  200. /data/test/box_game_api/vendor/topthink/framework/src/think/Response.php ( 8.60 KB )
  201. /data/test/box_game_api/vendor/topthink/framework/src/think/response/Html.php ( 0.98 KB )
  202. /data/test/box_game_api/vendor/topthink/framework/src/think/Cookie.php ( 6.28 KB )
  203. /data/test/box_game_api/vendor/topthink/think-trace/src/Html.php ( 4.49 KB )
  1. CONNECT:[ UseTime:0.001230s ] mysql:host=192.168.0.4;port=3306;dbname=box_game;charset=utf8mb4
  2. SHOW FULL COLUMNS FROM `common_user` [ RunTime:0.001480s ]
  3. SELECT * FROM `common_user` WHERE `uid` = 1201962 LIMIT 1 [ RunTime:0.000722s ]
  4. SHOW FULL COLUMNS FROM `common_game` [ RunTime:0.001349s ]
  5. SELECT * FROM `common_game` WHERE `url_name` = 'city-constructor' AND `game_status` = 1 LIMIT 1 [ RunTime:0.000982s ]
  6. SHOW FULL COLUMNS FROM `common_game_category` [ RunTime:0.001508s ]
  7. SELECT * FROM `common_game_category` WHERE `game_category_id` = 12 [ RunTime:0.000723s ]
  8. SHOW FULL COLUMNS FROM `user_collect_game` [ RunTime:0.001173s ]
  9. SELECT * FROM `user_collect_game` WHERE `game_id` = 1087 AND `uid` = 1201962 AND `channel_id` = 10001 AND `app_id` = 3052 LIMIT 1 [ RunTime:0.000698s ]
  10. SHOW FULL COLUMNS FROM `common_game_rate_record` [ RunTime:0.001120s ]
  11. SELECT * FROM `common_game_rate_record` WHERE `uid` = 1201962 AND `game_id` = 1087 LIMIT 1 [ RunTime:0.000878s ]
  12. SELECT * FROM `common_game_rate_record` WHERE `game_id` = 1087 AND `rate_status` = 1 [ RunTime:0.000840s ]
  13. SELECT * FROM `common_game_rate_record` WHERE `game_id` = 1087 AND `rate_status` = 2 [ RunTime:0.000833s ]
  14. UPDATE `common_game` SET `game_play_num` = `game_play_num` + 1 WHERE `game_id` = 1087 [ RunTime:0.001307s ]
  15. SHOW FULL COLUMNS FROM `user_recently_play` [ RunTime:0.001164s ]
  16. SELECT * FROM `user_recently_play` WHERE `game_id` = 1087 AND `uid` = 1201962 AND `channel_id` = 10001 AND `app_id` = 3052 LIMIT 1 [ RunTime:0.000700s ]
  17. SELECT * FROM `common_game` WHERE `game_id` = 1087 AND `game_status` = 1 LIMIT 1 [ RunTime:0.000722s ]
  18. INSERT INTO `user_recently_play` SET `uid` = 1201962 , `game_id` = 1087 , `game_name` = 'City Constructor' , `game_icon` = '/public/20250726/7337faa171bf17f48d509250ab98c439.jpg' , `game_main_img` = '/public/20250726/268e833bf1714e9d82ea05da8e10a459.jpg' , `game_title` = 'City Constructor' , `play_time` = '2026-03-06 07:48:02' , `channel_id` = 10001 , `app_id` = 3052 [ RunTime:0.001016s ]
  19. SELECT * FROM `common_game_category` WHERE `game_category_id` = 12 [ RunTime:0.000703s ]
  20. SHOW FULL COLUMNS FROM `game_top_charts` [ RunTime:0.001094s ]
  21. SELECT * FROM `game_top_charts` WHERE `game_id` = 1087 ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.000702s ]
  22. SHOW FULL COLUMNS FROM `common_game_detail` [ RunTime:0.001149s ]
  23. SELECT COUNT(*) AS think_count FROM `common_game_detail` WHERE `game_id` = 1087 AND `status` = 1 LIMIT 1 [ RunTime:0.000682s ]
  24. SELECT `detail_id`,`game_id`,`detail_type`,`detail_main_img`,`detail_main_h_img`,`detail_title`,`detail_label`,`detail_url_name`,`content` FROM `common_game_detail` WHERE `game_id` = 1087 AND `status` = 1 ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.000706s ]
  25. SHOW FULL COLUMNS FROM `common_game_category_map` [ RunTime:0.001082s ]
  26. SELECT COUNT(*) AS think_count FROM ( SELECT `cm`.*,count(*) AS think_count FROM `common_game_category_map` `gcm` LEFT JOIN `common_game` `cm` ON `gcm`.`game_id`=`cm`.`game_id` WHERE `cm`.`game_status` = '1' AND `gcm`.`category_id` = '12' GROUP BY `cm`.`game_id` ) `_group_count_` LIMIT 1 [ RunTime:0.006421s ]
  27. SELECT `cm`.*,count(*) AS think_count FROM `common_game_category_map` `gcm` LEFT JOIN `common_game` `cm` ON `gcm`.`game_id`=`cm`.`game_id` WHERE `cm`.`game_status` = '1' AND `gcm`.`category_id` = '12' GROUP BY `cm`.`game_id` ORDER BY `cm`.`game_play_num` DESC LIMIT 0,9 [ RunTime:0.006099s ]
  28. SELECT * FROM `common_game_category` WHERE `game_category_id` = 12 [ RunTime:0.000743s ]
  29. SELECT * FROM `common_game_category` WHERE `game_category_id` = 12 [ RunTime:0.000698s ]
  30. SELECT * FROM `common_game_category` WHERE `game_category_id` = 12 [ RunTime:0.000658s ]
  31. SELECT * FROM `common_game_category` WHERE `game_category_id` = 12 [ RunTime:0.000651s ]
  32. SELECT * FROM `common_game_category` WHERE `game_category_id` = 12 [ RunTime:0.000731s ]
  33. SELECT * FROM `common_game_category` WHERE `game_category_id` = 12 [ RunTime:0.000685s ]
  34. SELECT * FROM `common_game_category` WHERE `game_category_id` = 12 [ RunTime:0.000689s ]
  35. SELECT * FROM `common_game_category` WHERE `game_category_id` = 12 [ RunTime:0.000663s ]
  36. SELECT * FROM `common_game_category` WHERE `game_category_id` = 12 [ RunTime:0.000664s ]
  37. SHOW FULL COLUMNS FROM `common_comment` [ RunTime:0.001205s ]
  38. SELECT COUNT(*) AS think_count FROM `common_comment` WHERE ( `game_id` = 1087 AND `root_id` = 0 AND `status` = 1 ) OR ( `game_id` = 1087 AND `root_id` = 0 AND `status` = 0 AND `user_id` = 1201962 ) LIMIT 1 [ RunTime:0.000729s ]
  39. SELECT * FROM `common_comment` WHERE ( `game_id` = 1087 AND `root_id` = 0 AND `status` = 1 ) OR ( `game_id` = 1087 AND `root_id` = 0 AND `status` = 0 AND `user_id` = 1201962 ) ORDER BY `comment_id` ASC LIMIT 0,10 [ RunTime:0.000718s ]
0.108465s