• 重庆嘿巴适餐饮传承百年老工艺,好吃源于好口感;
  • 嘿巴适所有配方绝不保留,核心技术全面传授;
  • 嘿巴适餐饮美味享不到,财富赚不停。

400-882-1633

小吃餐饮创业筹备全攻略:从选址到人力的5大关键测算

来源:重庆嘿巴适餐饮 时间:05-18

小吃餐饮创业筹备全攻略:从选址到人力的5大关键测算

小吃餐饮创业筹备全攻略:从选址到人力的5大关键测算

为何筹备阶段的成本测算至关重要?

进入小吃餐饮赛道前,多数创业者关注的是产品口味或营销创意,却容易忽视筹备阶段的系统性成本测算。事实上,从选址签约到正式开业,每一个环节都需要精确的资金规划——这不仅关系到能否顺利启动,更直接影响后续运营的抗风险能力。有数据显示,60%的餐饮新店在开业半年内陷入资金紧张,根源往往在于筹备期对各项成本的预估偏差。

以重庆某小吃店为例:创业者因未详细测算门面租金递增条款,开业3个月后租金突然上涨30%,导致原本预留的食材采购资金被挪用,最终因产品品质下降被迫闭店。这恰恰印证了"预则立,不预则废"的古训——小吃餐饮创业的筹备,本质上是一场对资金使用效率的精准把控。

环:营业空间的多维成本测算

营业空间的选择是筹备期的首要决策,其成本包含租金/购置费、物业服务费、水电增容费等隐性支出。需要重点关注三个维度:

1. 区位价值评估:黄金地段虽人流量大,但租金可能占总预算的30%-40%。建议采用"人流量×客单价×转化率"公式预判营收,例如目标客单价15元、日均人流量2000人、转化率10%,则日营收3000元,月营收9万。若月租金超过2.7万(即营收的30%),需谨慎考虑。

2. 物业条件核查:需确认房屋性质是否为商业用途(避免无法办理餐饮执照)、消防设施是否达标(部分老城区商铺需额外改造)、排污管道容量(小吃店日均排水量约2-5吨,需匹配管径)。曾有创业者因未核查排污问题,开业后被要求整改,额外支出2万元管道改造费。

3. 合同条款细节:重点关注租金递增比例(常见每年5%-8%)、免租期(一般15-30天装修期)、转让权限制(部分房东禁止转租)。建议要求将"拆迁"等不可抗因素纳入解约条款,降低投资风险。

第二环:设备与设施的采购策略

小吃店的设备成本通常占总预算的25%-35%,合理配置需兼顾实用性与经济性。以下是关键设备的分类测算:

1. 烹饪设备:根据主打品类选择,如米粉店需汤桶(300-800元)、蒸柜(1500-3000元);炸串店需炸炉(800-2000元)、保温柜(1200-2500元)。建议优先选择不锈钢材质(耐腐蚀性强),避免低价铁皮设备(半年后易生锈)。

2. 制冷设备:保鲜柜(存放食材)、展示柜(陈列成品)是标配。双门保鲜柜市场价约2500-4000元,风幕展示柜约3500-6000元。注意能效等级,一级能效比三级能效每年省电约300度。

3. 辅助设备:包括压面机(500-1500元)、绞肉机(300-800元)、灭蝇灯(50-150元)等。建议通过本地厨具市场采购(可现场验货),或选择知名电商平台的"餐饮设备专区"(部分品牌提供免费安装)。

特别提醒:成批采购时可争取5%-10%的折扣,运输费(约设备总价的3%)和安装调试费(如蒸柜接天然气需300-500元)需计入总成本。

第三环:家具与器皿的精准配置

家具器皿的成本易被低估,但实际占比可达10%-15%。配置逻辑需紧扣"服务模式"与"翻台率":

1. 快餐模式:以卡座或吧台为主,单人位宽度建议45-50cm(舒适度),桌间距不小于80cm(避免拥挤)。100㎡店面建议配置20-25个座位,每套餐桌椅成本约300-500元(含椅子)。

2. 简餐模式:需设置部分圆桌(直径1.2米,适合4-6人),搭配木塑材质椅(防水易清洁)。圆桌+6椅的组合成本约800-1200元,需根据目标客群(家庭/朋友聚餐)调整比例。

3. 器皿配置:碗碟按座位数的1.5倍备货(避免高峰期不够用),快餐碗建议选择密胺材质(耐摔),单价3-8元;汤碗可选陶瓷(显档次),单价5-12元。此外需配置公筷架、调味瓶(10-20元/套)等小物件,总成本约为家具的15%-20%。

第四环:装饰设计的性价比之道

小吃店装饰需平衡"视觉吸引力"与"成本控制",建议遵循"重点区域精做,基础区域简做"原则:

1. 门面设计:招牌是核心引流点,建议采用LED发光字(亮度高,夜间可见),字体高度不小于60cm(50米外可识别)。招牌制作成本约800-2000元/㎡(含安装),需提前确认物业是否允许外挑式招牌(部分商场有限高规定)。

2. 厅面装修:墙面可选用耐擦洗的乳胶漆(立邦/多乐士,单价40-60元/㎡),地面推荐防滑地砖(800×800mm,单价50-80元/片)。灯光以暖白光为主(色温3000-4000K),每㎡配置15-20W照明(如60cm吸顶灯,约80-150元/盏)。

3. 厨房改造:墙面贴300×600mm瓷砖(防水易清洁,单价30-50元/片),地面做防滑处理(防滑剂涂刷,约15元/㎡)。排烟系统需匹配灶头数量(1个灶头对应1500m³/h风量),风管长度每增加1米,成本增加200-300元。

经验之谈:避免使用大理石等高价材料,墙面装饰画(30-50元/幅)、绿植(绿萝/多肉,10-30元/盆)即可提升氛围,总装饰成本建议控制在200-400元/㎡。

第五环:劳动力成本的动态规划

人力成本是持续支出项,筹备期需预判人员配置与薪资结构:

1. 基础岗位配置:100㎡以内的小吃店,建议配置1名店长(统筹管理)、2名收银员(轮班制)、3名服务员(负责点单/收台)、2名厨师(1主灶+1帮厨)。具体人数需根据日均客流量调整(如日接待500人,服务员需增至4名)。

2. 薪资标准参考:以二线城市为例,店长月薪4500-6000元,收银员3000-4000元,服务员2800-3800元,主灶厨师5000-8000元(视技术水平),帮厨3500-5000元。需额外考虑社保成本(约工资总额的30%)、员工餐(日均15-20元/人)等隐性支出。

3. 弹性用工策略:高峰期(如午餐11:30-13:30)可雇佣兼职人员(时薪15-20元),降低固定人力成本。建议与附近高校勤工俭学中心合作,确保人员稳定性。

特别注意:筹备期需预留1-2个月的工资备用金(约总人力成本的2倍),避免因开业初期营收不稳定导致员工流失。

总结:筹备期的"三不原则"

小吃餐饮创业筹备,本质是对资金的精细化管理。建议遵循"三不原则":不盲目追求黄金地段(匹配自身资金实力)、不超预算采购设备(实用优先)、不忽视隐性成本(如物业改造费、员工社保)。通过系统的成本测算,既能确保顺利开业,更能为后期运营预留足够的调整空间。

最后提醒:筹备期可制作《成本测算表》,将各项支出按"必选"(如租金、设备)和"可选"(如装饰画、绿植)分类,优先保障必选项目,灵活调整可选项目,让每一分钱都花在刀刃上。

校区导航
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-04-05 14:04:56 HTTP/1.1 GET : http://www.edujk.com/s/1363/n/9636.html
  2. 运行时间 : 0.013158s [ 吞吐率:76.00req/s ] 内存消耗:396.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.000314s ] mysql:host=127.0.0.1;port=3306;dbname=baijiao_branch_collect;charset=utf8
  2. SHOW FULL COLUMNS FROM `fqi_school` [ RunTime:0.000983s ]
  3. SELECT * FROM `fqi_school` WHERE `school_id` = '1363' AND `site_id` = 4 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000280s ]
  4. SHOW FULL COLUMNS FROM `fqi_school_class` [ RunTime:0.000575s ]
  5. SELECT * FROM `fqi_school_class` WHERE `school_id` = 1363 [ RunTime:0.000200s ]
  6. SHOW FULL COLUMNS FROM `fqi_school_campus` [ RunTime:0.000673s ]
  7. SELECT * FROM `fqi_school_campus` WHERE `school_id` = 1363 [ RunTime:0.000240s ]
  8. SHOW FULL COLUMNS FROM `fqi_school_news` [ RunTime:0.000630s ]
  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` = 1363 AND `a`.`content_id` = '9636' AND `news_status` = 1 AND `school_status` = 1 LIMIT 1 [ RunTime:0.000940s ]
  10. (select content_id,news_name,school_id from fqi_school_news where school_id = '1363' and content_id < '9636' and site_id <= '4' order by content_id desc limit 1) union all(select content_id,news_name,school_id from fqi_school_news where school_id = '1363' and content_id > '9636' and site_id <= '4' order by content_id asc limit 1) [ RunTime:0.000479s ]
  11. SHOW FULL COLUMNS FROM `fqi_school_course` [ RunTime:0.000704s ]
  12. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1363 AND `site_id` = 4 AND `course_status` = 1 AND `school_status` = 1 ORDER BY `course_id` DESC LIMIT 4 [ RunTime:0.000740s ]
  13. SELECT * FROM `fqi_school_course` WHERE `school_id` = 1363 AND `school_status` = 1 AND `course_status` = 1 ORDER BY `course_id` DESC LIMIT 8 [ RunTime:0.000363s ]
  14. SELECT * FROM `fqi_school_news` WHERE `school_id` = 1363 ORDER BY `click` DESC,`news_id` DESC LIMIT 5 [ RunTime:0.000172s ]
  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` = '4' AND `b`.`school_status` = '1' AND `news_status` = 1 AND `content_id` < 9636 ORDER BY `content_id` DESC LIMIT 20 [ RunTime:0.002097s ]
0.013442s