• 致力于steam教育,创客教育的课程体系开发与创新
  • 自主研发软件scraino将图形编程与scratch编程相结
  • 启蒙百万余中小学生,并为美国加州中小学课堂提供产品

400-060-0105

Python少儿编程入门全攻略:Turtle库从基础图形到创意绘图实战解析

来源:天津动力猫机器人教育 时间:05-19

Python少儿编程入门全攻略:Turtle库从基础图形到创意绘图实战解析

Python少儿编程入门:用Turtle库打开图形世界的扇门

为什么Turtle库是少儿编程的首选工具?

对于刚开始接触编程的孩子来说,抽象的代码往往难以理解。而Python中的Turtle库就像一支“魔法画笔”,通过控制屏幕上的小海龟移动,把代码转化为可视化的图形,让编程学习变得直观有趣。这个诞生于1966年的工具,最初是为Logo语言设计的教学辅助库,如今凭借简单易懂的语法和丰富的图形表现力,成为少儿编程入门的经典选择。

无论是画一条直线,还是创作复杂的动态图案,Turtle库都能用几行代码实现。更重要的是,孩子在调整参数、观察图形变化的过程中,能自然理解循环、条件判断等编程核心逻辑,为后续学习打下坚实基础。

基础图形绘制:从直线到正方形的步

学习Turtle库,首先要掌握两个核心操作:控制画笔的抬起与落下(penup/pendown),以及调整移动方向和距离(forward/backward/left/right)。我们从最简单的直线开始,逐步解锁基础图形。

示例1:绘制一条直线

要画出可见的线条,必须先让画笔落下(pendown)。输入以下代码,小海龟会向前移动100个单位,在屏幕上留下一条直线。

from turtle import*
pendown()  # 落笔准备绘制
forward(100)  # 向前移动100个单位

如果需要移动画笔但不绘制(比如调整起始位置),可以使用penup()函数,这是后续绘制复杂图形的关键操作。

示例2:边长100的正方形

正方形的特点是四条边等长,四个角都是90度。通过循环结构可以简化重复操作,让代码更简洁。

for i in range(4):  # 循环4次绘制四条边
    forward(100)  # 每条边长度100
    right(90)  # 每次右转90度

另一种方法是利用circle函数的特殊参数,通过指定半径、角度和边数,顺时针画出正方形:

circle(-100, 360, 4)  # 半径-100(负号表示顺时针),360度,4条边

进阶图形:从圆到五角星的创意升级

掌握基础图形后,我们可以尝试更具挑战性的图案,比如圆形、半圆填充,甚至象征意义的五角星。这些案例不仅能锻炼代码编写能力,还能培养几何思维。

示例3:顺时针绘制半径100的圆

circle函数是绘制圆弧的利器,调整半径和角度参数即可得到不同形状。绘制完整圆时,只需指定360度:

circle(-100, 360)  # 顺时针绘制半径100的圆

示例4:红色填充半圆

填充颜色需要配合begin_fill()和end_fill()函数,这两个函数之间的绘制区域会被指定颜色填充。

fillcolor('red')  # 设置填充颜色为红色
begin_fill()  # 开始填充
circle(100, 180)  # 绘制半径100的半圆(180度)
end_fill()  # 结束填充

示例5:五角星绘制

五角星的每个尖角为36度,通过右转144度(180-36)可以形成闭合图形。配合颜色填充,能让图案更生动。

color("red")  # 设置画笔颜色为红色
begin_fill()  # 开始填充
for i in range(5):  # 循环5次绘制五条边
    forward(100)  # 每条边长度100
    right(144)  # 右转144度形成尖角
end_fill()  # 结束填充

绘制完成后,使用hideturtle()函数可以隐藏小海龟图标,让画面更整洁。

综合创意:从太极图到动态钟表的编程魅力

当孩子能熟练运用基础函数时,就可以挑战更复杂的综合案例。这些项目不仅需要代码编写能力,还需要观察细节、拆分问题的思维方法。

示例6:经典太极图

太极图由黑白对称的曲线组成,通过调整circle函数的半径和方向,可以精准绘制阴阳鱼的轮廓。

speed(10)  # 设置绘制速度为10(最快)
pendown()
circle(100, 180)  # 绘制上半圆
circle(200, 180)  # 绘制外半圆
circle(100, -180)  # 绘制下半圆
fillcolor('black')  # 设置填充颜色为黑色
begin_fill()  # 开始填充黑色部分
circle(100, 180)
circle(200, 180)
circle(100, -180)
end_fill()  # 结束填充
penup()
goto(0, 100)  # 移动到上顶点
dot(50)  # 绘制白色小圆点
goto(0, -100)  # 移动到下顶点
pencolor('white')  # 设置画笔颜色为白色
dot(50)  # 绘制黑色小圆点
hideturtle()  # 隐藏小海龟

示例7:动态钟表绘制

这个案例结合了时间模块(datetime)和Turtle库的高级功能,能实现钟表的实时走动效果。通过定义表针形状、设置刻度、同步时间数据,让静态图形“活”起来。

import turtle
from datetime import *

def Skip(step):  # 辅助函数:抬起画笔移动指定距离
    turtle.penup()
    turtle.forward(step)
    turtle.pendown()

def mkHand(name, length):  # 定义表针形状
    turtle.reset()
    Skip(-length*0.1)
    turtle.begin_poly()
    turtle.forward(length*1.1)
    turtle.end_poly()
    handForm = turtle.get_poly()
    turtle.register_shape(name, handForm)

def Init():  # 初始化表针和文字输出
    global secHand, minHand, hurHand, printer
    turtle.mode("logo")
    mkHand("secHand", 135)
    mkHand("minHand", 125)
    mkHand("hurHand", 90)
    secHand = turtle.Turtle()
    minHand = turtle.Turtle()
    hurHand = turtle.Turtle()
    for hand in secHand, minHand, hurHand:
        hand.shapesize(1, 1, 3)
        hand.speed(0)
    printer = turtle.Turtle()
    printer.hideturtle()
    printer.penup()

def SetupClock(radius):  # 绘制钟表外框和刻度
    turtle.reset()
    turtle.pensize(7)
    for i in range(60):
        Skip(radius)
        if i % 5 == 0:
            turtle.forward(20)
            Skip(-radius - 20)
            Skip(radius + 20)
            turtle.write(int(i/5) if i != 0 else 12, align="center", font=("Courier", 14, "bold"))
            Skip(-radius - 20)
        else:
            turtle.dot(5)
            Skip(-radius)
        turtle.right(6)

def Tick():  # 实时更新时间
    t = datetime.today()
    second = t.second + t.microsecond * 0.000001
    minute = t.minute + second / 60.0
    hour = t.hour + minute / 60.0
    secHand.setheading(6 * second)
    minHand.setheading(6 * minute)
    hurHand.setheading(30 * hour)
    turtle.tracer(False)
    printer.forward(65)
    printer.write(Week(t), align="center", font=("Courier", 14, "bold"))
    printer.back(130)
    printer.write(Date(t), align="center", font=("Courier", 14, "bold"))
    printer.home()
    turtle.tracer(True)
    turtle.ontimer(Tick, 100)

def main():
    turtle.tracer(False)
    Init()
    SetupClock(160)
    turtle.tracer(True)
    Tick()
    turtle.mainloop()

if __name__ == "__main__":
    main()

运行这段代码,屏幕上会出现一个实时走动的钟表,显示当前时间、日期和星期。孩子通过观察代码如何将时间数据转化为表针角度,能更深入理解编程与现实世界的联系。

给家长和孩子的学习建议

学习Turtle库绘图的过程,本质是培养逻辑思维和创造力的过程。以下建议能帮助孩子更高效地掌握技能:

  • 从模仿到创新:先跟着示例代码练习,理解每一行的作用,再尝试修改参数(如长度、角度、颜色),观察图形变化,逐步培养“试错-调整”的编程思维。
  • 拆解复杂问题:遇到复杂图形(如五星红旗),可以先分解为小部分(旗面、大星、小星),分别绘制后再组合,这是编程解决问题的核心方法。
  • 结合数学知识:图形绘制与几何密切相关,孩子在编程时会自然复习角度、周长、对称等概念,实现“跨学科学习”。
  • 鼓励创意输出:完成基础案例后,引导孩子设计自己的图案(如生日贺卡、家庭图标),让编程从“练习”变为“表达”,提升学习兴趣。

通过Turtle库的学习,孩子不仅能掌握Python编程的基础知识,更能在动手实践中建立“代码=工具=创造力”的认知,为未来的科技学习埋下兴趣的种子。

校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 11:17:29 HTTP/1.1 GET : http://www.aabqu.com/s/1213/n/9686.html
  2. 运行时间 : 0.013783s [ 吞吐率:72.55req/s ] 内存消耗:393.30kb 文件加载:137
  3. 缓存信息 : 0 reads,0 writes
  1. /data/web/baijiao_branch_collect/public/index.php ( 0.79 KB )
  2. /data/web/baijiao_branch_collect/vendor/autoload.php ( 0.75 KB )
  3. /data/web/baijiao_branch_collect/vendor/composer/autoload_real.php ( 1.63 KB )
  4. /data/web/baijiao_branch_collect/vendor/composer/platform_check.php ( 0.90 KB )
  5. /data/web/baijiao_branch_collect/vendor/composer/ClassLoader.php ( 15.99 KB )
  6. /data/web/baijiao_branch_collect/vendor/composer/autoload_static.php ( 4.26 KB )
  7. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/helper.php ( 8.34 KB )
  8. /data/web/baijiao_branch_collect/vendor/topthink/think-validate/src/helper.php ( 2.19 KB )
  9. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/helper.php ( 1.47 KB )
  10. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/stubs/load_stubs.php ( 0.16 KB )
  11. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Exception.php ( 1.69 KB )
  12. /data/web/baijiao_branch_collect/vendor/topthink/think-container/src/Facade.php ( 2.71 KB )
  13. /data/web/baijiao_branch_collect/vendor/symfony/deprecation-contracts/function.php ( 0.99 KB )
  14. /data/web/baijiao_branch_collect/vendor/symfony/polyfill-mbstring/bootstrap.php ( 8.26 KB )
  15. /data/web/baijiao_branch_collect/vendor/symfony/polyfill-mbstring/bootstrap80.php ( 9.78 KB )
  16. /data/web/baijiao_branch_collect/vendor/symfony/var-dumper/Resources/functions/dump.php ( 1.49 KB )
  17. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/App.php ( 15.30 KB )
  18. /data/web/baijiao_branch_collect/vendor/topthink/think-container/src/Container.php ( 15.76 KB )
  19. /data/web/baijiao_branch_collect/vendor/psr/container/src/ContainerInterface.php ( 1.02 KB )
  20. /data/web/baijiao_branch_collect/app/provider.php ( 0.19 KB )
  21. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Http.php ( 6.04 KB )
  22. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/helper/Str.php ( 7.29 KB )
  23. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Env.php ( 4.68 KB )
  24. /data/web/baijiao_branch_collect/app/common.php ( 10.83 KB )
  25. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/helper.php ( 18.78 KB )
  26. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Config.php ( 5.54 KB )
  27. /data/web/baijiao_branch_collect/config/app.php ( 1.29 KB )
  28. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Env.php ( 1.67 KB )
  29. /data/web/baijiao_branch_collect/config/cache.php ( 1.22 KB )
  30. /data/web/baijiao_branch_collect/config/config.php ( 0.26 KB )
  31. /data/web/baijiao_branch_collect/config/console.php ( 0.29 KB )
  32. /data/web/baijiao_branch_collect/config/cookie.php ( 0.56 KB )
  33. /data/web/baijiao_branch_collect/config/database.php ( 2.29 KB )
  34. /data/web/baijiao_branch_collect/config/filesystem.php ( 0.63 KB )
  35. /data/web/baijiao_branch_collect/config/lang.php ( 0.81 KB )
  36. /data/web/baijiao_branch_collect/config/log.php ( 1.37 KB )
  37. /data/web/baijiao_branch_collect/config/middleware.php ( 0.19 KB )
  38. /data/web/baijiao_branch_collect/config/route.php ( 1.54 KB )
  39. /data/web/baijiao_branch_collect/config/session.php ( 0.57 KB )
  40. /data/web/baijiao_branch_collect/config/trace.php ( 0.34 KB )
  41. /data/web/baijiao_branch_collect/config/view.php ( 0.81 KB )
  42. /data/web/baijiao_branch_collect/app/event.php ( 0.25 KB )
  43. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Event.php ( 7.67 KB )
  44. /data/web/baijiao_branch_collect/app/service.php ( 0.13 KB )
  45. /data/web/baijiao_branch_collect/app/AppService.php ( 0.26 KB )
  46. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Service.php ( 1.64 KB )
  47. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Lang.php ( 7.35 KB )
  48. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/lang/zh-cn.php ( 13.70 KB )
  49. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/initializer/Error.php ( 3.31 KB )
  50. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/initializer/RegisterService.php ( 1.33 KB )
  51. /data/web/baijiao_branch_collect/vendor/services.php ( 0.14 KB )
  52. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/service/PaginatorService.php ( 1.52 KB )
  53. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/service/ValidateService.php ( 0.99 KB )
  54. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/service/ModelService.php ( 2.04 KB )
  55. /data/web/baijiao_branch_collect/vendor/topthink/think-trace/src/Service.php ( 0.77 KB )
  56. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Middleware.php ( 6.72 KB )
  57. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/initializer/BootService.php ( 0.77 KB )
  58. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/Paginator.php ( 11.86 KB )
  59. /data/web/baijiao_branch_collect/vendor/topthink/think-validate/src/Validate.php ( 63.20 KB )
  60. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/Model.php ( 23.55 KB )
  61. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/Attribute.php ( 21.05 KB )
  62. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/AutoWriteData.php ( 4.20 KB )
  63. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/Conversion.php ( 6.75 KB )
  64. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/DbConnect.php ( 5.16 KB )
  65. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/ModelEvent.php ( 2.33 KB )
  66. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/concern/RelationShip.php ( 28.30 KB )
  67. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/contract/Arrayable.php ( 0.09 KB )
  68. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/contract/Jsonable.php ( 0.13 KB )
  69. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/model/contract/Modelable.php ( 0.09 KB )
  70. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Db.php ( 2.88 KB )
  71. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/DbManager.php ( 8.52 KB )
  72. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Log.php ( 6.28 KB )
  73. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Manager.php ( 3.92 KB )
  74. /data/web/baijiao_branch_collect/vendor/psr/log/src/LoggerTrait.php ( 2.69 KB )
  75. /data/web/baijiao_branch_collect/vendor/psr/log/src/LoggerInterface.php ( 2.71 KB )
  76. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Cache.php ( 4.92 KB )
  77. /data/web/baijiao_branch_collect/vendor/psr/simple-cache/src/CacheInterface.php ( 4.71 KB )
  78. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/helper/Arr.php ( 17.45 KB )
  79. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/cache/driver/Redis.php ( 6.94 KB )
  80. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/cache/Driver.php ( 9.03 KB )
  81. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/contract/CacheHandlerInterface.php ( 1.99 KB )
  82. /data/web/baijiao_branch_collect/app/Request.php ( 0.09 KB )
  83. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Request.php ( 55.78 KB )
  84. /data/web/baijiao_branch_collect/app/middleware.php ( 0.26 KB )
  85. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Pipeline.php ( 2.61 KB )
  86. /data/web/baijiao_branch_collect/vendor/topthink/think-trace/src/TraceDebug.php ( 3.40 KB )
  87. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Route.php ( 23.73 KB )
  88. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/RuleName.php ( 5.75 KB )
  89. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/Domain.php ( 2.53 KB )
  90. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/RuleGroup.php ( 22.43 KB )
  91. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/Rule.php ( 26.95 KB )
  92. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/RuleItem.php ( 9.78 KB )
  93. /data/web/baijiao_branch_collect/route/app.php ( 3.05 KB )
  94. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Route.php ( 4.70 KB )
  95. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/dispatch/Controller.php ( 4.74 KB )
  96. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/Dispatch.php ( 10.44 KB )
  97. /data/web/baijiao_branch_collect/app/controller/Index.php ( 33.26 KB )
  98. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Request.php ( 9.20 KB )
  99. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/route/Url.php ( 14.07 KB )
  100. /data/web/baijiao_branch_collect/app/model/IndexModel.php ( 19.95 KB )
  101. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Config.php ( 1.37 KB )
  102. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/facade/Cache.php ( 2.06 KB )
  103. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/facade/Db.php ( 0.93 KB )
  104. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/connector/Mysql.php ( 5.73 KB )
  105. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/PDOConnection.php ( 53.74 KB )
  106. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/Connection.php ( 8.39 KB )
  107. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/ConnectionInterface.php ( 4.57 KB )
  108. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/builder/Mysql.php ( 16.58 KB )
  109. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/Builder.php ( 24.07 KB )
  110. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/BaseBuilder.php ( 27.50 KB )
  111. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/Query.php ( 15.97 KB )
  112. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/BaseQuery.php ( 45.13 KB )
  113. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/TimeFieldQuery.php ( 7.43 KB )
  114. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/AggregateQuery.php ( 3.26 KB )
  115. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/ModelRelationQuery.php ( 20.07 KB )
  116. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/ParamsBind.php ( 3.66 KB )
  117. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/ResultOperation.php ( 7.01 KB )
  118. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/WhereQuery.php ( 19.37 KB )
  119. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/JoinAndViewQuery.php ( 7.11 KB )
  120. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/TableFieldInfo.php ( 2.63 KB )
  121. /data/web/baijiao_branch_collect/vendor/topthink/think-orm/src/db/concern/Transaction.php ( 2.77 KB )
  122. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/log/driver/File.php ( 5.96 KB )
  123. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/contract/LogHandlerInterface.php ( 0.86 KB )
  124. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/log/Channel.php ( 3.89 KB )
  125. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/event/LogRecord.php ( 1.02 KB )
  126. /data/web/baijiao_branch_collect/vendor/topthink/think-helper/src/Collection.php ( 16.47 KB )
  127. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Response.php ( 8.81 KB )
  128. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/response/View.php ( 3.29 KB )
  129. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/Cookie.php ( 6.06 KB )
  130. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/View.php ( 4.39 KB )
  131. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/view/driver/Php.php ( 6.44 KB )
  132. /data/web/baijiao_branch_collect/vendor/topthink/framework/src/think/contract/TemplateHandlerInterface.php ( 1.60 KB )
  133. /data/web/baijiao_branch_collect/view/index/pc/school_news_details.php ( 2.39 KB )
  134. /data/web/baijiao_branch_collect/view/index/pc/school_top.php ( 5.76 KB )
  135. /data/web/baijiao_branch_collect/view/index/pc/school_right.php ( 2.17 KB )
  136. /data/web/baijiao_branch_collect/view/index/pc/school_bottom.php ( 1.16 KB )
  137. /data/web/baijiao_branch_collect/vendor/topthink/think-trace/src/Html.php ( 4.42 KB )
  1. CONNECT:[ UseTime:0.000285s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000897s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '1213' AND `site_id` = 15 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000267s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000603s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 1213 [ RunTime:0.000270s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000620s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 1213 [ RunTime:0.000231s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000620s ]
  9. SELECT `a`.*,`content` FROM `fqi_school_news` `a` LEFT JOIN `fqi_school_news_content` `b` ON `b`.`content_id`=`a`.`content_id` WHERE `school_id` = 1213 AND `a`.`content_id` = '9686' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000942s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '1213' and content_id < '9686' and site_id <= '15' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '1213' and content_id > '9686' and site_id <= '15' order by content_id asc limit 1) [ RunTime:0.000821s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000816s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1213 AND `site_id` = 15 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000535s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1213 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000250s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 1213 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000237s ]
  15. SELECT `content_id`,`news_name`,`a`.`school_id`,`b`.`school_name` FROM `fqi_school_news` `a` LEFT JOIN `fqi_school` `b` ON `b`.`school_id`=`a`.`school_id` WHERE `a`.`site_id` = '15' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 9686 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.002656s ]
0.014069s