• 课程与伦敦完美衔接,为亚洲学⽣提供更多⼊学途径与⽅式
  • 拥有大量的先进设备和科技资源,为学生创造了最为优越的学习环境
  • 课程原版引进,师资为全球统一标准

400-689-2779

时尚买手核心能力全解析:从客群定位到数据应用的实战指南

来源:上海马兰戈尼学校 时间:10-26

时尚买手核心能力全解析:从客群定位到数据应用的实战指南

时尚买手核心能力全解析:从客群定位到数据应用的实战指南

客群定位:买手工作的块试金石

在时尚零售领域,客群定位偏差是许多品牌面临的隐形危机。不少品牌习惯用"20-35岁都市女性"这样宽泛的描述定义客群,但实际销售中常出现"定位20岁客群却卖着35岁客群能接受的价格"的矛盾场景。这种错位直接导致潜在客户流失——20岁群体觉得价格偏高,35岁群体又认为风格不符,最终产品陷入"叫好不叫座"的尴尬。

某快时尚品牌曾做过一组对比实验:A系列按"18-25岁学生党"定位设计,定价199-399元;B系列沿用旧有"20-30岁职场新人"定位,定价399-599元。实际销售数据显示,A系列首月售罄率达87%,而B系列因价格超出学生党承受范围、风格又不够职场化,售罄率仅42%。这印证了精准客群定位的核心——不仅要明确年龄层,更要结合消费能力、生活场景、审美偏好等多维标签。

真正的客群定位需要买手深入市场一线:通过会员系统分析消费频次与客单价,观察线下门店的试穿人群特征,甚至参与用户社群倾听真实反馈。某轻奢品牌买手团队曾发现,其定位的"25-30岁白领"中,实际消费主力是"27-29岁准备婚育的女性",这一发现促使他们调整产品线,增加通勤与约会场景兼容的款式,当月销售额提升23%。

产品差异化:Z世代的"购物开关"如何开启

当Z世代成为消费主力,"千篇一律"已成为产品滞销的代名词。这代人成长于信息爆炸时代,对"独特性"的追求远超以往——他们不仅购买商品,更在购买"自我表达的符号"。数据显示,68%的Z世代消费者表示"会为有独特设计的产品支付溢价",这为买手的选品策略指明了方向。

中国李宁的"国潮复兴"是差异化策略的经典范本。当运动品牌还在模仿欧美设计时,其买手团队敏锐捕捉到"文化自信"的上升趋势,将"中国李宁"定位为"运动潮流文化输出者"。从"行"系列的汉字刺绣,到"盘古"系列的青铜器纹样,每一季新品都在传递"东方美学"的独特语言,成功吸引了对传统文化有认同感的年轻群体,2023年其潮流产品线销售额占比已超45%。

彩妆领域的花西子更是将差异化做到了极致。面对国际品牌的强势竞争,其买手团队选择"东方彩妆"作为突破口:从"百鸟朝凤"眼影盘的浮雕工艺,到"同心锁"口红的古典造型,每个产品都融入《千里江山图》《簪花仕女图》等传统元素;产品命名如"月桂引"腮红、"玉养蜜粉"则自带文化联想。配合100-300元的亲民定价,花西子用三年时间实现从0到年销10亿+的跨越,证明了"差异化+文化赋能"的强大市场穿透力。

值得注意的是,差异化并非盲目求新。太平鸟曾推出过一款"赛博朋克"风格的联名系列,虽设计前卫但与品牌核心客群(20-28岁都市青年)的日常穿搭场景脱节,最终库存积压。这提醒买手:差异化必须建立在对目标客群审美偏好的深度理解上,是"精准独特"而非"为不同而不同"。

数据分析:贯穿买手全流程的"隐形操盘手"

在"经验主导"的传统买手时代,"看款靠眼光、下单凭感觉"是常见操作。但在如今的数字化零售环境中,这种模式已难以适应市场变化。某知名买手店的调研显示:仅依赖经验选品的买手,其订货准确率约为62%;而掌握数据分析能力的买手,准确率可提升至85%以上。

订货前的数据分析是基础功课。买手需要调取过去3-5个季度的销售数据,分析各品类的销存比、TOP10款式的共同特征、不同商圈门店的热销差异。例如,某女装品牌通过分析发现,北方门店的长款大衣销量是南方的2.3倍,而南方门店的连衣裙售罄率高出北方40%,这直接指导了当季的区域分货策略。同时,竞品分析也不可或缺——从同类品牌的爆款价格带(如299-499元占比67%),到消费者在社交平台的讨论热点(如"无尺码内衣"搜索量月增120%),都是订货的重要参考。

订货后的数据分析更具挑战性。某快时尚品牌买手团队曾分享:他们会为每批新货建立"7-15-30天"监控机制——新品上架7天内观察试穿率与连带率,15天分析动销速度,30天评估是否需要调货或打折。更关键的是结合节点营销:双十一前1个月,需根据历史同期各品类的销售占比(如美妆占35%、服饰占50%)预留库存;618大促则要考虑"预售定金"数据,调整现货比例。某运动品牌曾因忽略"618预售中跑步鞋定金增长200%"的信号,导致活动期间断码率达30%,直接损失约800万销售额。

库存管理是数据分析的终极考验。通过"ABC分类法",买手可将商品分为高周转(A类)、中周转(B类)、低周转(C类)。A类商品需保持安全库存,避免断货;B类商品动态补货;C类商品则通过组合销售、限时折扣等方式快速清仓。某轻奢品牌运用此方法后,库存周转率从1.8次/年提升至2.5次/年,资金使用效率显著提高。

新饰觉《时尚买手》课程:系统培养专业买手的成长路径

面对行业对专业买手的迫切需求,新饰觉推出的《时尚买手》课程,聚焦"流程-技能-经验"三大维度,为从业者提供体系化成长方案。课程涵盖买手工作全流程:从前期市场调研与客群分析,到中期选品订货与数据分析,再到后期库存管理与盈利优化,每个环节都配备真实案例拆解。

在技能培养方面,课程不仅教授基础的OTB(采购预算计划)制定、销存比计算等工具使用,更注重培养"数据敏感度"与"市场预判力"。例如,通过模拟不同品牌的买手实战项目,学员需独立完成"客群定位-选品策略-订货计划-销售复盘"的全流程操作,导师会根据实际市场数据给予针对性指导。

值得关注的是课程中的"行业经验传承"模块。授课导师均为拥有10年以上买手经验的从业者,会分享"如何识别伪需求""大促期间的库存预留技巧""小众品牌的差异化选品策略"等实战干货。某往期学员反馈:"导师分享的'3:5:2订货法则'(30%经典款、50%潮流款、20%实验款),让我在实际工作中避免了盲目追新导致的库存风险。"

通过系统学习,学员将掌握如何通过合理控制预算(如设置品类预算占比)提升资金使用效率,如何通过优化选品结构(如增加高毛利的配饰类商品)提高转化率,如何通过动态库存管理(如季中调货、跨区补货)降低滞销风险,最终实现从"经验型买手"到"数据驱动型买手"的升级,为品牌创造更高盈利价值。

课程导航
校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-04 06:32:01 HTTP/1.1 GET : http://www.aabqy.com/s/6301/n/35427.html
  2. 运行时间 : 0.018833s [ 吞吐率:53.10req/s ] 内存消耗:391.59kb 文件加载: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.000354s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.001050s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '6301' AND `site_id` = 23 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000274s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000579s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 6301 [ RunTime:0.000225s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000614s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 6301 [ RunTime:0.000248s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000661s ]
  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` = 6301 AND `a`.`content_id` = '35427' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000611s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '6301' and content_id < '35427' and site_id <= '23' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '6301' and content_id > '35427' and site_id <= '23' order by content_id asc limit 1) [ RunTime:0.000576s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000716s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 6301 AND `site_id` = 23 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000332s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 6301 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000223s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 6301 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000150s ]
  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` = '23' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 35427 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.008703s ]
0.019145s