首板一进二战法操作方法
一、核心逻辑与市场理解
“一进二”策略,即捕捉首个交易日涨停(首板)的个股,并在第二个交易日成功实现二连板的操作。其核心逻辑在于捕捉个股主升浪的启动点,本质是追求“动量惯性”与“资金共识强化”带来的溢价。其优势在于:
1. 启动位置相对明确:首板是强势启动的重要信号,相比高位接力风险更低。
2. 潜在盈亏比高:成功连板往往意味着主升浪开启,后续空间可观;失败则因位置不高,止损相对可控。
3. 资金关注度高:涨停天然吸引市场目光,流动性充裕,便于进出。
4. 市场合力验证:二连板是对首板逻辑和强度的有效确认,过滤“一日游”个股。
二、首板筛选:构筑优质股票池(基础工作)
一进二成功的前提是筛选出具有连板潜质的优质首板。需建立严格的筛选体系:
1. 涨停时间与强度:
时间优先:优先选择上午(尤其是10:30前)封死的涨停板。早盘涨停彰显主力做多决心坚决,日内抛压消化充分,筹码稳定性高。尾盘偷袭板(尤其最后半小时)需高度警惕,多为资金套利或弱势表现。
封板强度:
封单量:封单金额越大越好(需结合流通盘)。理想状态是封单金额显著大于当日成交额(如1.5倍以上),显示资金抢筹意愿强烈,抛压被有效承接。避免封单稀稀拉拉、反复打开的“烂板”(除非是爆量分歧转一致的特殊情况)。
开板次数/时长:首选一次封死且全天未开的“硬板”。盘中短暂开板但能快速回封且放量不明显者次之。多次开板、长时间开板、回封犹豫的板,质量较差。
分时流畅度:拉升过程流畅,量价配合良好,最好伴随大单密集攻击的波形。
2. 成交量与换手率:
适中放量:首板需要放量,突破关键压力位或启动行情需要真金白银推动。但放量需有度:
理想状态:量能放大至近期均量(如5日均量)的1.5-3倍。温和放量显示筹码交换充分但未过度消耗买盘。
警惕异常放量:巨量(如超过5日均量5倍以上)涨停需特别谨慎,可能是强弩之末、老庄出货或潜伏盘集中兑现,次日接力难度陡增。缩量板(尤其非利好刺激的)通常代表筹码锁定好,但需结合位置和逻辑判断其持续性。
3. K线形态与位置:
突破形态:首选涨停板是突破关键阻力位的(如长期平台、颈线位、下降趋势线、重要均线如年线/半年线)。突破有效性是行情延续的关键。
相对位置:优先选择低位(长期横盘或超跌后)、中位启动的首板。
规避:
连续大涨后的高位首板(风险巨大)。
下跌中继反抽板(持续性存疑)。
面临强压未有效突破的首板。
K线组合: 涨停前有企稳、小阳线堆量、揉搓线等积极信号更佳。
4. 题材/概念驱动:
主流热点:首板个股必须依附于当下市场最主流、最具持续性的热点题材或行业板块。孤立的个股涨停,一进二成功率低。需判断该题材的级别(大周期主线?分支轮动?消息刺激一日游?)。
板块效应:观察同板块内是否有批量首板或涨停梯队(如已有2板、3板龙头)。板块联动性好,说明资金认可度高,个股作为跟风或潜在卡位龙更易获得资金支持。
逻辑正宗性:个股在所属题材中逻辑是否够“正”?是龙头、中军还是边缘跟风?核心受益者更受青睐。
5. 流通市值:
偏好中小盘:超短资金更青睐流通市值适中的个股(如10亿-100亿)。盘子太小(10亿)易被操纵且流动性差;盘子太大( 200亿)则需要天量资金推动连板,难度较大(除非是超级大题材的中军角色)。
次新股优势:次新股(尤其近端次新)因筹码干净、无老庄、无历史套牢盘、弹性大,常是一进二的高发地带,但也需注意情绪化和波动大的风险。
三、次日(二板)盘前准备与竞价研判
首板筛选后,形成股票池。次日的核心工作是通过集合竞价和开盘初期的表现,精准捕捉最具二连板潜力的个股。
1. 隔夜消息面复核:
个股有无突发利空(减持、监管、业绩变脸、澄清公告等)?
所属题材是否有利好加持或利空打击?板块龙头表现如何?
隔夜外围市场及A50期指表现?整体市场情绪预判(强/震荡)?
2. 集合竞价(9:15-9:25)深度解析: 竞价是日内多空博弈的第一个关键窗口。
量价关系:
高开幅度:最理想是强势高开(3%-7%)。高开表明资金认可度,接力意愿强。平开或低开需警惕,除非有特殊逻辑(如预期内大分歧转一致)。
匹配量(9:20后): 高开必须伴随高匹配量(成交量柱高)。高开无量是诱多陷阱;高开放巨量则可能潜伏盘或获利盘出逃,抛压沉重。理想情况:高开3%-7%,匹配量接近或略超首板涨停后半小时成交量。
委托单分布:
买一位置是否有大单托举?
卖一位置压单是否沉重?压单大小与买盘承接力的对比。
观察委托队列变化:大买单是否持续进场?大卖单是否被快速吃掉?
分时竞价图:
价格趋势:是否稳步推高?还是高开后跳水?抑或低位抢筹拉高?
量能分布:关键价格点(如涨停价、重要整数位)的成交量。
最后时刻(9:24-9:25)的价格和量能异动:抢筹or砸盘?
板块联动性:同板块其他首板股、龙头股的竞价表现如何?板块整体是加强还是分化?
3. 开盘关键30分钟(9:30-10:00)动态确认:
承接力度:
开盘后瞬间下砸,能否被快速、有力、带量地拉起并创新高?这是检验承接的核心。
分时回踩的低点是否高于开盘价或关键支撑位(如日内均线、0轴)?且回踩时量能是否萎缩?
避免开盘急杀后反弹无力,分时低点不断下移。
攻击性与流畅度:
向涨停板发起攻击时,波形是否陡峭、流畅?伴随大单持续扫货?
量价配合:拉升时放量,回调时缩量,量价关系健康。
冲击涨停的过程是否一气呵成?犹豫、反复的小波拉升动能不足。
时间窗口:10:00前(越早越好) 成功封死二板是强势表现。早盘封板意味着主力志在高远,日内分歧快速转一致。
换手情况:开盘半小时的换手率需重点关注。对比首板:
理想状态:换手充分但不过度(可能达到首板全天换手的50%-70%或更高),将不稳定筹码置换出来,为封板减轻抛压。
换手过低:表明锁仓严重,看似强势,但一旦开板抛压可能集中释放。
换手过高:半小时换手已接近或超过首板全天,则消耗买盘过大,封板后能否扛住抛压存疑(除非是超级大题材核心标的)。
四、核心介入模式与买点选择
基于盘面动态,一进二介入的核心模式与买点如下:
1. 强势确认板(最优模式):
特征:竞价高开(3%-7%)且匹配量良好 → 开盘后短暂下探(或不下探)即被强势拉起 → 分时流畅放量上攻 → 在10:00前快速、坚决封死涨停,封单巨大。
买点:
打板确认(最常用):在股价即将封板或封板瞬间(卖一被吃掉最后一档大卖单时),以涨停价排队买入。核心在于确认强度!牺牲部分成本,换取确定性。务必确保封单充足、气势如虹。
半路(高手向):在开盘后观察到强劲承接和攻击态势,在突破关键位置(如开盘价、前高、日内均线)且伴随放量拉升时介入。要求对盘口、量能、板块联动有极深理解,风险高于打板但成本更低。适用于预判极强、盘口语言清晰的标的。
2. 爆量分歧转一致板(高风险高收益):
特征:可能竞价表现一般(平开、小幅高开或低开)→ 开盘后经历剧烈震荡、大幅放量 → 但在关键位置(如日内均线、0轴、首板涨停价)获得强力支撑 → 随后在巨大成交量推动下回封涨停。常见于龙头股或逻辑极强的个股。
买点:
回封打板:在经历大幅震荡放量后,观察回封涨停瞬间的力度和封单。当卖一被大买单坚决吃掉,且伴随新的大封单涌现时打板介入。必须确认分歧有效消化,转一致成功。
低吸(极高要求):在放量下杀至强支撑位(如首板涨停价、重要均线、筹码密集区上沿),观察到分时企稳、抛压衰竭、大单开始主动承接时低吸。此操作对盘口解读、支撑位判断、市场情绪把握要求极高,风险巨大,非顶级高手慎用。
关键:必须对个股逻辑、市场地位有深刻认知,确认放量是换手而非出货。次日溢价高,但也容易失败大面。
五、仓位管理与风险控制(生存之本)
一进二本质是高风险博弈,严格的仓位管理和止损纪律是长期生存的核心。
1. 单票仓位上限:绝对避免重仓或满仓单一标的。建议单笔交易仓位不超过总资金的10%-20%(根据个人风险承受力和账户规模调整)。分散到2-3个符合条件的标的。
2. 止损策略(刚性执行):
买入当日:
打板介入后若炸板且无法回封,尤其是收盘跌幅较深(如-3%以下),次日必须无条件止损。
盘中若发现买点判断错误(如承接远弱于预期),可在跌破关键支撑位(如买入成本-3%,或日内均线) 时及时止损,不幻想。
买入次日:
成功连板则持有,观察后续强度。
未能连板(无论盈亏):大部分情况应果断离场。一进二失败后,个股往往进入调整期。
止损点设置:若低开低走或冲高回落,有效跌破5日均线或首板涨停价(关键支撑) 应止损;也可设置固定比例止损(如成本-5%至-7%)。
3. 止盈策略:
强更强(缩量加速板):持有,直到出现放巨量、长上影、尾盘封板不稳、板块严重退潮等见顶信号。
分歧板(放量):视个股地位和板块强度决定。若地位核心、板块未退潮,可多观察;若跟风股或强度减弱,及时止盈。
不连板即走:对于纯粹博弈二板溢价的交易,次日不涨停即是卖出信号。
4. 空仓原则: 当市场情绪极端恶劣(如指数暴跌、高位股集体崩盘、连板高度被压制至2-3板、涨停家数锐减、跌停家数大增),或符合模式的优质首板稀缺时,务必管住手,强制空仓。超短交易,空仓是重要的操作。
六、策略总结与进阶要点
1. 系统化思维:一进二不是简单的“数板”,而是一个融合了题材分析、技术择时、盘口解读、情绪感知、仓位管理的系统工程。每个环节都不可或缺。
2. 聚焦核心:永远把精力放在市场最主流热点中形态、量能、盘口最优异的1-2只个股上。杂毛跟风股的成功率天然低下。
3. 动态修正:市场环境(指数、情绪周期)、板块地位、个股盘口瞬息万变。策略是框架,临盘需根据最新信息快速评估和决策。
4. 量能是灵魂:无论是首板筛选、竞价判断、盘中承接、分歧转一致,还是最终的封板强度,量能的大小、分布、变化节奏是解读资金意图的最核心指标。务必深入钻研量价关系。
5. 情绪周期至上:超短交易的核心在于把握市场情绪(赚钱效应)的周期轮回。一进二在情绪启动期、发酵期、高潮初期成功率最高;在高潮末期、退潮期、冰点期强行操作,风险远大于机会。学会判断当前市场所处的情绪阶段。
6. 持续学与复盘: 每日详细复盘涨停个股(尤其首板和二板)的走势、逻辑、盘口细节。总结成功与失败的原因,不断优化模型和盘感。记录交易日志。
首板涨停一进二策略,是超短交易体系中捕捉龙头启动初期、追求高效资金利用率的经典战法。它要求我们具备敏锐的市场嗅觉、严谨的分析框架、果断的执行力和铁血的纪律性。记住:没有完美的策略,只有不断进化的交易者。深刻理解市场本质,持续精进技术,严控风险,方能在残酷的超短博弈中占据一席之地。
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-11-22 06:01:40 HTTP/2.0 GET : https://mengzhubei.com/portal/article/index/cid/3/id/322.html
- 运行时间 : 0.212000s [ 吞吐率:4.72req/s ] 内存消耗:5,958.10kb 文件加载:140
- 查询信息 : 53 queries 8 writes
- 缓存信息 : 7 reads,0 writes
- [ LANG ] /www/wwwroot/yinghuo/vendor/thinkphp/lang/zh-cn.php
- [ DB ] INIT mysql
- [ LANG ] /www/wwwroot/yinghuo/app/portal//lang/zh-cn.php
- [ ROUTE ] array (
)
- [ HEADER ] array (
'accept-encoding' => 'gzip, br, zstd, deflate',
'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'accept' => '*/*',
'host' => 'mengzhubei.com',
'content-length' => '',
'content-type' => '',
)
- [ PARAM ] array (
'cid' => '3',
'id' => '322',
)
- [ LANG ] /www/wwwroot/yinghuo/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php
- [ LANG ] /www/wwwroot/yinghuo/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php
- [ LANG ] /www/wwwroot/yinghuo/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php
- [ LANG ] /www/wwwroot/yinghuo/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
- [ LANG ] /www/wwwroot/yinghuo/app/portal/lang/zh-cn/common.php
- [ LANG ] /www/wwwroot/yinghuo/app/portal/lang/zh-cn/home.php
- [ VIEW ] /www/wwwroot/yinghuo/public/themes/yinghuo/portal/article.html [ array (
0 => 'site_info',
1 => 'category',
2 => 'article',
3 => 'prev_article',
4 => 'next_article',
5 => 'theme_vars',
6 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.000580s ] mysql:host=127.0.0.1;port=3306;dbname=yinghuo;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `cmf_hook` [ RunTime:0.000742s ]
- [ SQL ] SELECT `hook` FROM `cmf_hook` WHERE `type` = 1 OR ( `type` = 3 AND ( `app` = '' or `app` = 'cmf' ) ) [ RunTime:0.000344s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_hook',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 73,
'filtered' => 11.710000038146973,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_hook_plugin` [ RunTime:0.000421s ]
- [ SQL ] SELECT `hook`,`plugin` FROM `cmf_hook_plugin` WHERE `status` = 1 AND `hook` IN ('app_begin','module_init','action_begin','view_filter','app_end','log_write','response_end','admin_init','home_init','send_mobile_verification_code','body_start','before_head_end','footer_start','before_footer','before_footer_end','before_body_end','left_sidebar_start','before_left_sidebar_end','right_sidebar_start','before_right_sidebar_end','comment','guestbook','switch_theme','after_content','before_content','log_write_done','switch_admin_theme','captcha_image') ORDER BY `list_order` ASC [ RunTime:0.000308s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_hook_plugin',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'filtered' => 100.0,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_post` [ RunTime:0.000983s ]
- [ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 3 AND `relation`.`post_id` = 322 AND ( `post`.`published_time` < 1763762500 and `post`.`published_time` > 0 ) LIMIT 1 [ RunTime:0.000803s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY,type_status_date',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 3 AND `relation`.`post_id` < 322 AND ( `post`.`published_time` < 1763762500 and `post`.`published_time` > 0 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000989s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY,type_status_date',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 96,
'filtered' => 1.110888957977295,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `post`.`id`=`relation`.`post_id` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `relation`.`category_id` = 3 AND `relation`.`post_id` > 322 AND ( `post`.`published_time` < 1763762500 and `post`.`published_time` > 0 ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000598s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'range',
'possible_keys' => 'PRIMARY,type_status_date',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 9,
'filtered' => 1.110888957977295,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_category` [ RunTime:0.000688s ]
- [ SQL ] SELECT * FROM `cmf_portal_category` WHERE `id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.000269s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] UPDATE `cmf_portal_post` SET `post_hits` = `post_hits` + 1 WHERE `id` = 322 [ RunTime:0.006324s ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.000464s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'yinghuo' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.000298s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 75,
'filtered' => 1.3333333730697632,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'yinghuo' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '文章页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'yinghuo' AND `file` = 'portal/article' [ RunTime:0.006038s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'yinghuo' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.000344s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 75,
'filtered' => 1.3333333730697632,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'yinghuo' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首页' , `more` = '{\"vars\":{\"name\":{\"title\":\"\\u59d3\\u540d\",\"value\":\"\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u586b\\u5199\\u7528\\u6237\\u59d3\\u540d\",\"tip\":\"\\u8bbe\\u7f6e\\u540e\\u60a8\\u7684\\u59d3\\u540d\\u5c06\\u4f1a\\u663e\\u793a\\u5728\\u9996\\u9875\",\"rule\":{\"require\":true}}}}' , `config_more` = '{\"vars\":{\"name\":{\"title\":\"\\u59d3\\u540d\",\"value\":\"\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u586b\\u5199\\u7528\\u6237\\u59d3\\u540d\",\"tip\":\"\\u8bbe\\u7f6e\\u540e\\u60a8\\u7684\\u59d3\\u540d\\u5c06\\u4f1a\\u663e\\u793a\\u5728\\u9996\\u9875\",\"rule\":{\"require\":true}}}}' , `description` = '首页模板文件' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = 'yinghuo' AND `file` = 'portal/index' [ RunTime:0.007207s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'yinghuo' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.000409s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 75,
'filtered' => 1.3333333730697632,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'yinghuo' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = '文章列表页' , `more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'yinghuo' AND `file` = 'portal/list' [ RunTime:0.007447s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'yinghuo' AND `file` = 'portal/page' LIMIT 1 [ RunTime:0.000396s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 75,
'filtered' => 1.3333333730697632,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'yinghuo' , `action` = 'portal/Page/index' , `file` = 'portal/page' , `name` = '文章页' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'yinghuo' AND `file` = 'portal/page' [ RunTime:0.007046s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'yinghuo' AND `file` = 'portal/search' LIMIT 1 [ RunTime:0.000513s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 75,
'filtered' => 1.3333333730697632,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'yinghuo' , `action` = 'portal/List/index' , `file` = 'portal/search' , `name` = '文章列表页' , `more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'yinghuo' AND `file` = 'portal/search' [ RunTime:0.007058s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'yinghuo' AND `file` = 'portal/tag' LIMIT 1 [ RunTime:0.000331s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 75,
'filtered' => 1.3333333730697632,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `cmf_theme_file` SET `theme` = 'yinghuo' , `action` = 'portal/Tag/index' , `file` = 'portal/tag' , `name` = '文章标签页' , `more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `description` = '文章标签模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'yinghuo' AND `file` = 'portal/tag' [ RunTime:0.007254s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'yinghuo' [ RunTime:0.000442s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 75,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.000560s ]
- [ SQL ] UPDATE `cmf_theme` SET `name` = 'pbootcms' , `version` = '1.0.0' , `demo_url` = 'https://www.yingzia.com/pbootcms177/' , `author` = '老谭' , `lang` = 'zh-cn' , `keywords` = 'pbootcms' , `description` = 'pbootcms' WHERE `theme` = 'yinghuo' [ RunTime:0.000232s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'yinghuo' AND ( `is_public` = 1 OR `file` = 'portal/article' ) [ RunTime:0.000389s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 75,
'filtered' => 1.899999976158142,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav` [ RunTime:0.000453s ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.000240s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 50.0,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_nav_menu` [ RunTime:0.000701s ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000272s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 5,
'filtered' => 20.0,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.000233s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 50.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000263s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 5,
'filtered' => 20.0,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_tag_post` [ RunTime:0.000708s ]
- [ SQL ] SHOW COLUMNS FROM `cmf_portal_tag` [ RunTime:0.000488s ]
- [ SQL ] SELECT `cmf_portal_tag`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`post_id` AS `pivot__post_id`,`pivot`.`status` AS `pivot__status` FROM `cmf_portal_tag` INNER JOIN `cmf_portal_tag_post` `pivot` ON `pivot`.`tag_id`=`cmf_portal_tag`.`id` WHERE `pivot`.`post_id` = 322 [ RunTime:0.000306s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'pivot',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'post_id',
'key' => 'post_id',
'key_len' => '8',
'ref' => 'const',
'rows' => 2,
'filtered' => 100.0,
'extra' => 'Using index condition',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763762500 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,110 [ RunTime:0.033650s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'PRIMARY,type_status_date,parent_id,user_id,create_time',
'key' => 'type_status_date',
'key_len' => '2',
'ref' => 'const,const',
'rows' => 282,
'filtered' => 1.110888957977295,
'extra' => 'Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000569s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000207s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000178s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000196s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000175s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000196s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000174s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000207s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000172s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000222s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = 1 AND `post`.`post_type` = 1 AND `post`.`delete_time` = 0 AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763762500 ) GROUP BY `post`.`id` ORDER BY `post_hits` DESC LIMIT 0,10 [ RunTime:0.032400s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'PRIMARY,type_status_date,parent_id,user_id,create_time',
'key' => 'type_status_date',
'key_len' => '2',
'ref' => 'const,const',
'rows' => 282,
'filtered' => 1.110888957977295,
'extra' => 'Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000263s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000180s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000211s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000175s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000184s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000175s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000173s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000187s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000226s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `name` FROM `cmf_portal_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000442s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_portal_category',
'partitions' => NULL,
'type' => 'const',
'possible_keys' => 'PRIMARY',
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => 'const',
'rows' => 1,
'filtered' => 100.0,
'extra' => NULL,
) ]
- [ SQL ] SELECT `id` FROM `cmf_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.000579s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'filtered' => 50.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000259s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 5,
'filtered' => 20.0,
'extra' => 'Using where; Using filesort',
) ]

0.213045s