交易百科

比较部分交易产品——实时零碎股票交易报价之间的重要区别

通过 特蕾莎·凯里(THERESA W. CAREY)2020年12月4日更新
当年轻的投资者进入股票交易领域并发现自己关注的是每股价格超过1,000美元的受欢迎的股票时,买卖零碎股票的受欢迎程度已大大提高。甲分数份额是公平的库存小于一个完整的份额的一部分。过去,由于进行股息再投资,股票拆分或并购,投资者在投资组合中所占份额很少。您可以在账户中持有或出售一小部分股份,但是直到最近,要购买一部分股份还是非常困难的。

在.com建立期间,有少量股票发行,但它们消失了。几家主要的在线经纪人已开始重新引入零碎股票交易,在将佣金削减至0美元之后,对他们的客户更加友好。盈透证券于2019年11月启动,现在富达(Fidelity),查尔斯·施瓦布(Charles Schwab)和罗宾汉(Robinhood)也启用了部分股票交易。大多数机器人顾问都采用零碎股票交易,这样他们的客户就可以最大限度地利用所持有的资产并将所有现金投入使用。还有其他经纪人致力于向其客户提供部分股票交易;我们将在服务启动时更新本文。

之所以存在这个市场,是因为长期以来在价格稳定在100美元以上时进行股票分割的传统已经烟消云散,一些公司将其极高的股价视为一种自我推动。不幸的是,高股价使一些公司成为个人投资者无法进行的投资,将其从零售市场中撤出,而是提供给机构使用。零碎股份允许一些零售参与。

重要要点
在线经纪人正在推出允许购买部分股票的计划
经纪人产品之间存在关键差异,包括最低购买量和可用库存的总量
零佣金交易使部分股票计划负担得起
与其他年龄段的人群相比,年轻的投资者参与率更高
零碎股份的历史
从1999年11月推出BuyandHold以来,开始有一些零散的零散股票发行,现在已经不复存在了。对于每月1-3美元的订阅,您可以购买少量的股票。该网站鼓励其客户每月定期购买商品,随着时间的推移积累大量资金。1999年,周围有一些免费经纪人,但它们持续的时间并不长。大多数其他在线经纪人每笔交易收取9.99-24.99美元的费用,因此几乎不可能通过一次购买一两个股票来制定有利可图的股票交易策略。那个月费现在听起来实在令人发指,实际上是一笔不小的数目。

大型在线经纪人一旦将股票交易的费用降低到$ 0,便可以进行零碎交易,而不会因小额交易的佣金而对客户造成不利影响。在2019年11月,Interactive Brokers推出了其在纽约证券交易所,美国证券交易所,纳斯达克,ARCA或BATS上市的美国股票以及每日平均交易量超过1000万美元且市值超过4亿美元的场外交易粉红美分股票的部分股票交易能力。其他公司也紧随其后,现在有四个主要经纪人和几个自动交易服务,可以实时交易零碎股票。大多数机器人顾问都启用了分数股票交易来平衡投资组合,尽管这些交易的时机不是由投资者决定的。例如,库存将客户白天要求的所有交易置于收盘时。我们在此表中包括了M1 Finance,因为它们还允许实时交易碎股。

新投资者紧随零散股票
富达证券交易数据分析,他们于2020年1月启动的零星交易计划受到了年轻投资者的欢迎。富达(Fidelity)的部分交易客户中有近一半(45%)在18-35岁之间。到2020年的前三个季度,大约63万个富达账户交易了小数股,其中大部分交易都来自FAANG股票以及微软(MSFT)和特斯拉(TSLA)。


从逻辑上讲,经纪人或其清算公司必须有一种方式持有剩余的零碎股份,因为交易所没有启用零碎股份交易。因此,如果您是嘉信理财的客户,并且购买了0.2股苹果股票,那么其他0.8股股份将由嘉信理财在内部库存帐户中持有。该部分可以用于履行其他客户的订单,也可以在交易日结束时清算。

如果将经纪账户转移到另一家公司,则持有小额股份的另一种复杂性就会出现。只能转让全部股份,因此您持有的任何零碎股份都将被清算,由于资本收益,这可能会给投资者造成应税事件。然后可以将这些交易产生的现金以及您持有的全部股份转移到新的经纪行中。持有零碎股份的另一个弊端是,它们不能被套期保值,也不允许通过编写有担保的认购证来改善基础。

以下是当前可用于实时交易碎股的服务。

查尔斯·施瓦布(Charles Schwab)“ Stock Slices”
Schwab的“股票切片”计划于2020年6月2日启动。该计划使客户能够以至少每只股票$ 5的价格购买任何S&P 500股票。客户可以排队购买一组10只股票并进行一次交易,将其投资平均分配到10个交易品种中。客户可以根据需要持有全部500只标准普尔股票的零碎股份,但一次只能购买10只。如果您要购买四只股票并向该组投资$ 50,那么交易完成后,您将持有每只股票$ 12.50的等价货币。

Schwab股票切片可在Schwab的零售经纪,保管和个人退休帐户(IRA)中获得。施瓦布发言人表示:“许多新投资者将这种环境视为进入市场的机会,这是他们这样做的另一种手段。” 该程序足够新,以至于Schwab无法向我们提供参与统计信息。

就可用库存而言,嘉信理财的产品受到最多的限制,最低进货量也最高。

富达的“股票切分”
富达(Fidelity)在2020年1月底推出了分数交易程序“ Stocks By The Slice ”。富达(Fidelity)的本地iOS和Android移动应用程序中添加了新的交易凭单,使客户可以购买一定数量的美元或部分股份任何交易所挂牌的股票(伯克希尔-哈撒韦公司A类股票除外,股票代码BRK.A)。富达于2020年秋季在其网络平台上增加了部分股票交易

截至2020年第三季度末,超过80%的小数份额计划参与者选择了以美元为基础的购买,其余参与者则按份额购买订单。最低购买金额必须为$ 1.00或更多,只要它至少包含一股股份的百分之一(0.001)。交易是实时执行的,客户可以指定市场或限价单。

富达零碎股票订单输入
在富达(Fidelity)的移动应用程序上输入一份零碎股票的订单。
富达在经纪,HSA,IRA和托管账户中提供“按比例划分的股票”。客户也可以在其401(K)计划中拥有一个自营经纪帐户的客户使用该帐户。在输入第一份零碎定单之前,系统会提示您查看客户协议。

盈透证券
IBKR Lite和IBKR Pro客户以及财务顾问客户(除了那些居住在以色列或拥有加拿大RRSP / TFSA帐户的客户)都可以在该公司的所有平台上使用 Interactive Brokers Fractional Trading(可访问美国所有上市股票)。合格的客户必须在进行首次交易之前在客户门户/帐户管理中启用部分股票交易。启用帐户后,可以按美元或股份金额进行零星购买。盈透证券甚至还为具有保证金账户的客户支持卖空零碎股票的功能,这是一项独特功能。

就可用库存的广度和可用的订单类型而言,这是迄今为止所有碎股计划中最灵活的。可在此链接中找到当前可用库存列表,该链接打开一个Excel电子表格。

M1金融
零碎股票购买是M1于2016年推出的Invest产品的内置组件。M1提供大多数NYSE,NASDAQ和BATs交易的股票和ETF,包括6,000多种在交易所上市的证券。对每种可用的证券都启用了部分股票交易。M1会汇总所有客户的交易并在交易窗口中一起执行它们,尽管客户还可以实时进行个别的零碎股票交易,但需支付额外费用。分配给客户帐户后剩下的剩余资金将进入M1拥有的帐户。

首席执行官布莱恩·巴恩斯(Brian Barnes)认为,M1是美国经纪商中最大的零散股票交易者。“每天,我们为客户进行约200,000笔小额股票交易。从这个角度来看,E * TRADE在四月份的所有客户每天进行约44,000笔交易,” Barnes说。巴恩斯说,M1在客户可以交易的全部股票和ETF中拥有0到1的份额。当M1持有的股份数量超过1时,将出售全部股份。

罗宾汉
所有Robinhood客户在2020年期间都可以使用零碎股票交易。市值超过2500万美元的每股价值超过1.00美元的股票和ETF有资格获得零碎股票订单。此外,Robinhood客户可以交易阿里巴巴和任天堂ADR的零碎股票。

如果不支持股票或ETF,Robinhood会在您输入订单时通知您。最小订单量为$ 1和/或份额的1/1000000。罗宾汉发言人估计,有近7,000只股票适合进行小额股票交易


0 个评论

要回复文章请先登录注册

Debug messages:

Template: default


Session:

Session type: db

[dpp__Anwsion] Array ( [permission] => [client_info] => [human_valid] => )


Plugins:


Loaded Class:

core_config: D:\wamp64\www4\system\core/config.php

core_db: D:\wamp64\www4\system\core/db.php

Zend_Db: D:\wamp64\www4\system\Zend/Db.php

Zend_Db_Adapter_Abstract: D:\wamp64\www4\system\Zend/Db/Adapter/Abstract.php

Zend_Db_Adapter_Mysqli: D:\wamp64\www4\system\Zend/Db/Adapter/Mysqli.php

Zend_Db_Profiler: D:\wamp64\www4\system\Zend/Db/Profiler.php

Zend_Db_Statement_Interface: D:\wamp64\www4\system\Zend/Db/Statement/Interface.php

Zend_Db_Statement: D:\wamp64\www4\system\Zend/Db/Statement.php

Zend_Db_Statement_Mysqli: D:\wamp64\www4\system\Zend/Db/Statement/Mysqli.php

Zend_Registry: D:\wamp64\www4\system\Zend/Registry.php

Zend_Db_Table_Abstract: D:\wamp64\www4\system\Zend/Db/Table/Abstract.php

core_plugins: D:\wamp64\www4\system\core/plugins.php

setting_class: D:\wamp64\www4\models/setting.php

Zend_Db_Select: D:\wamp64\www4\system\Zend/Db/Select.php

Zend_Db_Expr: D:\wamp64\www4\system\Zend/Db/Expr.php

Zend_Session_Abstract: D:\wamp64\www4\system\Zend/Session/Abstract.php

Zend_Session: D:\wamp64\www4\system\Zend/Session.php

Zend_Session_SaveHandler_Interface: D:\wamp64\www4\system\Zend/Session/SaveHandler/Interface.php

Zend_Session_SaveHandler_DbTable: D:\wamp64\www4\system\Zend/Session/SaveHandler/DbTable.php

Zend_Exception: D:\wamp64\www4\system\Zend/Exception.php

Zend_Session_Exception: D:\wamp64\www4\system\Zend/Session/Exception.php

Zend_Db_Table_Select: D:\wamp64\www4\system\Zend/Db/Table/Select.php

Zend_Db_Table_Rowset_Abstract: D:\wamp64\www4\system\Zend/Db/Table/Rowset/Abstract.php

Zend_Db_Table_Rowset: D:\wamp64\www4\system\Zend/Db/Table/Rowset.php

Zend_Db_Table_Row_Abstract: D:\wamp64\www4\system\Zend/Db/Table/Row/Abstract.php

Zend_Db_Table_Row: D:\wamp64\www4\system\Zend/Db/Table/Row.php

Zend_Session_Namespace: D:\wamp64\www4\system\Zend/Session/Namespace.php

core_cache: D:\wamp64\www4\system\core/cache.php

Zend_Cache: D:\wamp64\www4\system\Zend/Cache.php

Zend_Cache_Backend: D:\wamp64\www4\system\Zend/Cache/Backend.php

Zend_Cache_Backend_Interface: D:\wamp64\www4\system\Zend/Cache/Backend/Interface.php

Zend_Cache_Backend_ExtendedInterface: D:\wamp64\www4\system\Zend/Cache/Backend/ExtendedInterface.php

core_uri: D:\wamp64\www4\system\core/uri.php

banip_class: D:\wamp64\www4\models/banip.php

Zend_Validate_Interface: D:\wamp64\www4\system\Zend/Validate/Interface.php

Zend_Validate: D:\wamp64\www4\system\Zend/Validate.php

Zend_Loader: D:\wamp64\www4\system\Zend/Loader.php

Zend_Validate_Abstract: D:\wamp64\www4\system\Zend/Validate/Abstract.php

core_user: D:\wamp64\www4\system\core/user.php

admin_class: D:\wamp64\www4\models/admin.php

TPL: D:\wamp64\www4\system\class/cls_template.inc.php

Savant3: D:\wamp64\www4\system\Savant3.php

menu_class: D:\wamp64\www4\models/menu.php

system_class: D:\wamp64\www4\models/system.php

account_class: D:\wamp64\www4\models/account.php

HTTP: D:\wamp64\www4\system\class/cls_http.inc.php

hook_class: D:\wamp64\www4\models/hook.php

plugin_class: D:\wamp64\www4\models/plugin.php

PLUTPL: D:\wamp64\www4\system\class/cls_plugins.inc.php

article_class: D:\wamp64\www4\models/article.php

Zend_Filter_Interface: D:\wamp64\www4\system\Zend/Filter/Interface.php

Zend_Filter_Digits: D:\wamp64\www4\system\Zend/Filter/Digits.php

publish_class: D:\wamp64\www4\models/publish.php

FORMAT: D:\wamp64\www4\system\class/cls_format.inc.php

Services_BBCode: D:\wamp64\www4\system\Services/BBCode.php

topic_class: D:\wamp64\www4\models/topic.php

people_class: D:\wamp64\www4\models/people.php

reputation_class: D:\wamp64\www4\models/reputation.php

module_class: D:\wamp64\www4\models/module.php

question_class: D:\wamp64\www4\models/question.php

Services_Phpanalysis_Phpanalysis: D:\wamp64\www4\system\Services/Phpanalysis/Phpanalysis.php

search_fulltext_class: D:\wamp64\www4\models/search/fulltext.php

core_pagination: D:\wamp64\www4\system\core/pagination.php

posts_class: D:\wamp64\www4\models/posts.php

core_lang: D:\wamp64\www4\system\core/lang.php


Database

[ Log time: 1618124755.3064 ] [ Expend time: 0.018144130706787 ] Connect Master DB

[ Log time: 1618124755.3163 ] [ Expend time: 0.0032908916473389 ] SELECT `mt_system_setting`.* FROM `mt_system_setting`

[ Log time: 1618124755.3453 ] [ Expend time: 0.0010991096496582 ] SELECT `mt_nav`.`url` FROM `mt_nav` WHERE (is_index=1 AND status='Y') LIMIT 1

[ Log time: 1618124755.3551 ] [ Expend time: 0.001190185546875 ] SELECT `mt_ban_ip`.`id` FROM `mt_ban_ip` WHERE (ip='100.24.122.117') LIMIT 1

[ Log time: 1618124755.3587 ] [ Expend time: 0.0013730525970459 ] SELECT `mt_nav`.* FROM `mt_nav` WHERE (status='Y') ORDER BY `sort` desc

[ Log time: 1618124755.3675 ] [ Expend time: 0.001878023147583 ] SELECT `mt_category`.* FROM `mt_category` WHERE (`type` = 'question') ORDER BY `id` ASC

[ Log time: 1618124755.3697 ] [ Expend time: 0.0016679763793945 ] SELECT `mt_category`.* FROM `mt_category` WHERE (`type` = 'question') ORDER BY `sort` ASC, `id` ASC

[ Log time: 1618124755.3719 ] [ Expend time: 0.0016541481018066 ] SELECT `mt_category`.* FROM `mt_category` ORDER BY `sort` ASC, `id` ASC

[ Log time: 1618124755.3809 ] [ Expend time: 0.0011351108551025 ] SELECT `mt_hook_plugins`.`hook`, `mt_hook_plugins`.`plugins` FROM `mt_hook_plugins` WHERE (status = 1) ORDER BY `sort` DESC

[ Log time: 1618124755.3845 ] [ Expend time: 0.0010600090026855 ] SELECT `mt_plugins`.* FROM `mt_plugins` WHERE (state = 1)

[ Log time: 1618124755.3968 ] [ Expend time: 0.0012669563293457 ] SELECT `mt_article`.* FROM `mt_article` WHERE (id = 234) LIMIT 1

[ Log time: 1618124755.3984 ] [ Expend time: 0.0013461112976074 ] SELECT `mt_category`.* FROM `mt_category`

[ Log time: 1618124755.4028 ] [ Expend time: 0.0012240409851074 ] SELECT `mt_attach`.* FROM `mt_attach` WHERE (item_type = 'article' AND item_id = 234) ORDER BY `is_image` DESC, `id` ASC

[ Log time: 1618124755.4075 ] [ Expend time: 0.0015788078308105 ] SELECT `mt_users`.* FROM `mt_users` WHERE (is_del = 0 AND uid = 6) LIMIT 1

[ Log time: 1618124755.4087 ] [ Expend time: 0.00081706047058105 ] SELECT `mt_users_attrib`.* FROM `mt_users_attrib` WHERE (uid = 6) LIMIT 1

[ Log time: 1618124755.412 ] [ Expend time: 0.0015349388122559 ] SELECT `mt_article_vote`.* FROM `mt_article_vote` WHERE (`type` = 'article' AND item_id = 234 AND rating = 1)

[ Log time: 1618124755.4159 ] [ Expend time: 0.0032889842987061 ] SELECT `mt_users`.* FROM `mt_users` WHERE (is_del = 0 and uid IN(15,47,36,26,27,5,33,17,45,35,34,18,10,11,32,4,19,42,44,29,25,8,20,21,49,7,51,1))

[ Log time: 1618124755.4212 ] [ Expend time: 0.0014288425445557 ] SELECT `mt_topic_relation`.* FROM `mt_topic_relation` WHERE (item_id IN(234) AND `type` = 'article')

[ Log time: 1618124755.4228 ] [ Expend time: 0.0012121200561523 ] SELECT `mt_topic`.* FROM `mt_topic` WHERE (topic_id IN(196,56,14,309))

[ Log time: 1618124755.4276 ] [ Expend time: 0.0020520687103271 ] SELECT `mt_reputation_topic`.* FROM `mt_reputation_topic` WHERE (uid IN(6)) ORDER BY `topic_count` DESC

[ Log time: 1618124755.4293 ] [ Expend time: 0.0012860298156738 ] SELECT `mt_topic`.* FROM `mt_topic` WHERE (topic_id IN(123,268,323,11,10))

[ Log time: 1618124755.431 ] [ Expend time: 0.0010919570922852 ] SELECT `mt_article_comments`.* FROM `mt_article_comments` WHERE (is_del = 0 and article_id = 234) ORDER BY `add_time` ASC LIMIT 100

[ Log time: 1618124755.4325 ] [ Expend time: 0.00084185600280762 ] SELECT COUNT(*) AS `n` FROM `mt_article_comments` WHERE (is_del = 0 and article_id = 234)

[ Log time: 1618124755.4359 ] [ Expend time: 0.0015020370483398 ] SELECT `mt_topic`.* FROM `mt_topic` WHERE (discuss_count_update > 1617519954) ORDER BY `discuss_count_last_week` DESC LIMIT 10

[ Log time: 1618124755.457 ] [ Expend time: 0.0017650127410889 ] SELECT *, MATCH(question_content_fulltext) AGAINST('2760436739 3709620998 2013226131 2013521697 2345426102 3864630862 3292931080 2525320215 3732535201 2130621035' IN BOOLEAN MODE) AS score FROM mt_question WHERE MATCH(question_content_fulltext) AGAINST('2760436739 3709620998 2013226131 2013521697 2345426102 3864630862 3292931080 2525320215 3732535201 2130621035' IN BOOLEAN MODE) LIMIT 2000

[ Log time: 1618124755.473 ] [ Expend time: 0.0017890930175781 ] SELECT `mt_category`.* FROM `mt_category`

[ Log time: 1618124755.4764 ] [ Expend time: 0.0012388229370117 ] SELECT `mt_topic`.* FROM `mt_topic` WHERE (topic_id = 196) LIMIT 1

[ Log time: 1618124755.4775 ] [ Expend time: 0.00091314315795898 ] SELECT item_id FROM mt_topic_relation WHERE topic_id IN(196) AND `type` = '10'

[ Log time: 1618124755.4784 ] [ Expend time: 0.00077986717224121 ] SELECT topic_id FROM mt_topic WHERE parent_id = 196

[ Log time: 1618124755.4797 ] [ Expend time: 0.0009610652923584 ] SELECT `mt_topic_merge`.* FROM `mt_topic_merge` WHERE (target_id = 196)

[ Log time: 1618124755.4811 ] [ Expend time: 0.00098490715026855 ] SELECT `mt_topic`.* FROM `mt_topic` WHERE (topic_id = 56) LIMIT 1

[ Log time: 1618124755.482 ] [ Expend time: 0.00080084800720215 ] SELECT item_id FROM mt_topic_relation WHERE topic_id IN(56) AND `type` = '10'

[ Log time: 1618124755.4829 ] [ Expend time: 0.00081205368041992 ] SELECT topic_id FROM mt_topic WHERE parent_id = 56

[ Log time: 1618124755.4842 ] [ Expend time: 0.0010058879852295 ] SELECT `mt_topic_merge`.* FROM `mt_topic_merge` WHERE (target_id = 56)

[ Log time: 1618124755.4857 ] [ Expend time: 0.0010700225830078 ] SELECT `mt_topic`.* FROM `mt_topic` WHERE (topic_id = 14) LIMIT 1

[ Log time: 1618124755.4868 ] [ Expend time: 0.00089693069458008 ] SELECT item_id FROM mt_topic_relation WHERE topic_id IN(14) AND `type` = '10'

[ Log time: 1618124755.4876 ] [ Expend time: 0.00075411796569824 ] SELECT topic_id FROM mt_topic WHERE parent_id = 14

[ Log time: 1618124755.489 ] [ Expend time: 0.00097799301147461 ] SELECT `mt_topic_merge`.* FROM `mt_topic_merge` WHERE (target_id = 14)

[ Log time: 1618124755.4904 ] [ Expend time: 0.0010108947753906 ] SELECT `mt_topic`.* FROM `mt_topic` WHERE (topic_id = 309) LIMIT 1

[ Log time: 1618124755.4913 ] [ Expend time: 0.00080108642578125 ] SELECT item_id FROM mt_topic_relation WHERE topic_id IN(309) AND `type` = '10'

[ Log time: 1618124755.4921 ] [ Expend time: 0.00072693824768066 ] SELECT topic_id FROM mt_topic WHERE parent_id = 309

[ Log time: 1618124755.4934 ] [ Expend time: 0.00089812278747559 ] SELECT `mt_topic_merge`.* FROM `mt_topic_merge` WHERE (target_id = 309)

[ Log time: 1618124755.5053 ] [ Expend time: 0.011822938919067 ] SELECT `item_id`, `type` FROM mt_topic_relation WHERE `topic_id` IN(196,56,14,309)

[ Log time: 1618124755.5099 ] [ Expend time: 0.0029861927032471 ] SELECT `mt_posts_index`.* FROM `mt_posts_index` WHERE (((post_id IN (22,21,65,66,67,69,75,88,89,90,91,92,93,107,108,109,111,121,127,141,142,143,149,150,154,168,169,172,173,174,175,176,177,178,179,180,181,182,189,190,191,192,193,197,218,220,222,223,224,225,226,228,229,230,231,232,234,236,239,241,242,243,244,245,246,247,248,249,252,253,255,258,259,260,261,106,68,110,237,273,270,279,280,278,281,290,283,284,285,286,287,262,288,289,291,292,294,295,297,299,300,301,233,304,306,307,313,314,315,327,333,335,336,339,338,337,340,343,344,346,347,351,355,356,357,365,368,369,370,376,377,379,380,381,382,384,386,387,388,389,390,391,392,395,396,397,402,403,404,408,415,416,417,418,419,420,422,424,427,431,434,436,438,439,440,447,449,450,451,452,456,457,459,460,461,466,467,468,469,471,475,478,498,499,501,502,503,504,506,507,508,510,511,514,516,517,518,519,520,521,522,523,525,527,528,529,533,534,537,542,543,544,545,546,548,556,557,558,559,560,561,565,567,568,574,575,576,577,580,581,582,583,587,590,591,593,596,600,602,603,604,605,607,608,609,611,613,614,615,616,617,618,619,621,626,627,628,629,630,631,632,634,635,637,639,641,643,645,646,647,651,653,655,657,659,660,663,664,665,666,674,676,678,679,680,681,682,685,686,687,692,694,695,696,698,699,701,705,706,707,708,709,710,713,715,716,717,719,720,722,724,725,726,727,728,731,735,737,738,740,741,742,743,744,745,749,751,752,753,755,757,758,759,760,761,762,764,765,769,770,771,773,774,775,778,779,780,781,782,783,784,785,786,790,792,795,798,801,802,804,806,807,808,809,810,811,812,813,814,818,819,820,821,822,824,825,828,829,830,832,835,839,840,842,843,844,846,848,849,850,851,852,853,855,858,859,863,867,868,873,874,875,876,878,879,880,881,882,884,885,886,888,890,891,897,899,902,903,907,908,910,911,915,916,917,918,919,922,923,926,929,930,931,932,934,935,936,938,939,946,947,948,950,954,955,956,958,961,962,963,964,965,966,967,969,970,971,975,976,977,981,982,984,985,986,989,992,993,994,996,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1012,1014,1015,1016,1017,1019,1020,1021,1022,1024,1025,1026,1027,1030,1031,1032,1033,1034,1035,1036,1037,1039,1041,1042,1044,1046,1047,1048,1049,1051,1052,1053,1055,1056,1059,1060,1061,1065,1069,1071,1072,1074,1075,1078,1079,1082,1084,1085,1086,1087,1088,1091,1094,1095,1098,1099,1102,1104,1105,1106,1112,1113,1115,1117,1119,1121,1123,1124,1125,1126,1127,1128,1130,1131,1132,1134,1135,1141,1142,1143,1145,1147,1149,1150,1152,1153,1154,1155,1156,1158,1160,1161,1162,1163,1164,1165,1167,1168,1169,1170,1171,1173,1174,1175,1177,1180,1182,1184,1186,1188,1190,1191,1192,1194,1195,1196,1197,1198,1199,1200,1201,1202,1204,1205,1206,1207,1208,1210,1211,1212,1214,1215,1216,1219,1220,1221,1223,1225,1228,1229,1231,1233,1234,1235,1238,1240,1241,1243,1244,1248,1249,1254,1255,1258,1259,1260,1262,1264,1265,1266,1267,1268,1269,1270,1272,1273,1274,1276,1277,1278,1279,1280,1281,1282,1285,1286,1287,1288,1290,1291,1293,1295,1296,1297,1300,1301,1304,1306,1307,1308,1309,1310,1311,1312,1313,1314,1317,1318,1319,1321,1324,1325,1327,1328,1329,1334,1336,1341,1342,1343,1352,1355) AND post_type = 'article') OR (post_id IN (17,16) AND post_type = 'question')) AND is_recommend = 1 AND is_del = 0) ORDER BY `add_time` DESC LIMIT 10

[ Log time: 1618124755.5128 ] [ Expend time: 0.0022079944610596 ] SELECT COUNT(*) AS `n` FROM `mt_posts_index` WHERE (((post_id IN (22,21,65,66,67,69,75,88,89,90,91,92,93,107,108,109,111,121,127,141,142,143,149,150,154,168,169,172,173,174,175,176,177,178,179,180,181,182,189,190,191,192,193,197,218,220,222,223,224,225,226,228,229,230,231,232,234,236,239,241,242,243,244,245,246,247,248,249,252,253,255,258,259,260,261,106,68,110,237,273,270,279,280,278,281,290,283,284,285,286,287,262,288,289,291,292,294,295,297,299,300,301,233,304,306,307,313,314,315,327,333,335,336,339,338,337,340,343,344,346,347,351,355,356,357,365,368,369,370,376,377,379,380,381,382,384,386,387,388,389,390,391,392,395,396,397,402,403,404,408,415,416,417,418,419,420,422,424,427,431,434,436,438,439,440,447,449,450,451,452,456,457,459,460,461,466,467,468,469,471,475,478,498,499,501,502,503,504,506,507,508,510,511,514,516,517,518,519,520,521,522,523,525,527,528,529,533,534,537,542,543,544,545,546,548,556,557,558,559,560,561,565,567,568,574,575,576,577,580,581,582,583,587,590,591,593,596,600,602,603,604,605,607,608,609,611,613,614,615,616,617,618,619,621,626,627,628,629,630,631,632,634,635,637,639,641,643,645,646,647,651,653,655,657,659,660,663,664,665,666,674,676,678,679,680,681,682,685,686,687,692,694,695,696,698,699,701,705,706,707,708,709,710,713,715,716,717,719,720,722,724,725,726,727,728,731,735,737,738,740,741,742,743,744,745,749,751,752,753,755,757,758,759,760,761,762,764,765,769,770,771,773,774,775,778,779,780,781,782,783,784,785,786,790,792,795,798,801,802,804,806,807,808,809,810,811,812,813,814,818,819,820,821,822,824,825,828,829,830,832,835,839,840,842,843,844,846,848,849,850,851,852,853,855,858,859,863,867,868,873,874,875,876,878,879,880,881,882,884,885,886,888,890,891,897,899,902,903,907,908,910,911,915,916,917,918,919,922,923,926,929,930,931,932,934,935,936,938,939,946,947,948,950,954,955,956,958,961,962,963,964,965,966,967,969,970,971,975,976,977,981,982,984,985,986,989,992,993,994,996,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1012,1014,1015,1016,1017,1019,1020,1021,1022,1024,1025,1026,1027,1030,1031,1032,1033,1034,1035,1036,1037,1039,1041,1042,1044,1046,1047,1048,1049,1051,1052,1053,1055,1056,1059,1060,1061,1065,1069,1071,1072,1074,1075,1078,1079,1082,1084,1085,1086,1087,1088,1091,1094,1095,1098,1099,1102,1104,1105,1106,1112,1113,1115,1117,1119,1121,1123,1124,1125,1126,1127,1128,1130,1131,1132,1134,1135,1141,1142,1143,1145,1147,1149,1150,1152,1153,1154,1155,1156,1158,1160,1161,1162,1163,1164,1165,1167,1168,1169,1170,1171,1173,1174,1175,1177,1180,1182,1184,1186,1188,1190,1191,1192,1194,1195,1196,1197,1198,1199,1200,1201,1202,1204,1205,1206,1207,1208,1210,1211,1212,1214,1215,1216,1219,1220,1221,1223,1225,1228,1229,1231,1233,1234,1235,1238,1240,1241,1243,1244,1248,1249,1254,1255,1258,1259,1260,1262,1264,1265,1266,1267,1268,1269,1270,1272,1273,1274,1276,1277,1278,1279,1280,1281,1282,1285,1286,1287,1288,1290,1291,1293,1295,1296,1297,1300,1301,1304,1306,1307,1308,1309,1310,1311,1312,1313,1314,1317,1318,1319,1321,1324,1325,1327,1328,1329,1334,1336,1341,1342,1343,1352,1355) AND post_type = 'article') OR (post_id IN (17,16) AND post_type = 'question')) AND is_recommend = 1 AND is_del = 0)

[ Log time: 1618124755.5285 ] [ Expend time: 0.0020160675048828 ] SELECT `mt_topic_relation`.* FROM `mt_topic_relation` WHERE (item_id IN(306,304,301,300,93,92,91,89,75,69) AND `type` = 'article')

[ Log time: 1618124755.5309 ] [ Expend time: 0.0017991065979004 ] SELECT `mt_topic`.* FROM `mt_topic` WHERE (topic_id IN(21,56,62,56,16,21,319,78,79,56,12,318,154,80,56,80,80,56,12,83,84,85,63,21,12,56,309,14,306,268,249,14,56,306,196,104,306,56,18))

[ Log time: 1618124755.5336 ] [ Expend time: 0.0021779537200928 ] SELECT `mt_article`.* FROM `mt_article` WHERE (is_del = 0 and id IN(306,304,301,300,93,92,91,89,75,69))

[ Log time: 1618124755.5366 ] [ Expend time: 0.0023448467254639 ] SELECT `mt_users`.* FROM `mt_users` WHERE (is_del = 0 and uid IN(37,34,30,29,12,1,17,22))

[ Log time: 1618124755.5382 ] [ Expend time: 0.0011589527130127 ] SELECT `mt_users_attrib`.* FROM `mt_users_attrib` WHERE (uid IN(1,12,17,22,29,30,34,37))


Cache

[ Log time: 1618124755.3351 ] Backend: File

[ Log time: 1618124755.3363 ] [ Expend time: 0.001146 ] Get Cache: crond, result type: array

[ Log time: 1618124755.3365 ] [ Expend time: 0.000148 ] Get Cache: crond_timer_half_minute, result type: boolean

[ Log time: 1618124755.3374 ] [ Expend time: 0.000928 ] Get Cache: crond_timer_minute, result type: integer

[ Log time: 1618124755.3385 ] [ Expend time: 0.000981 ] Get Cache: crond_timer_five_minutes, result type: integer

[ Log time: 1618124755.3396 ] [ Expend time: 0.001031 ] Get Cache: crond_timer_ten_minutes, result type: integer

[ Log time: 1618124755.3406 ] [ Expend time: 0.000939 ] Get Cache: crond_timer_half_hour, result type: integer

[ Log time: 1618124755.3415 ] [ Expend time: 0.000888 ] Get Cache: crond_timer_hour, result type: integer

[ Log time: 1618124755.3425 ] [ Expend time: 0.000882 ] Get Cache: crond_timer_day, result type: integer

[ Log time: 1618124755.363 ] [ Expend time: 0.001110 ] Get Cache: nav_menu_list, result type: array

[ Log time: 1618124755.377 ] [ Expend time: 0.001193 ] Get Cache: user_group_99, result type: array

[ Log time: 1618124755.4313 ] [ Expend time: 0.000262 ] Get Cache: db_rows_cache_f509299002e1032748d80f61057e5f2d, result type: boolean

[ Log time: 1618124755.4397 ] [ Expend time: 0.000245 ] Get Cache: question_related_list_355bcb1efdaeffaa979f9a6f1891dec2_10, result type: boolean

[ Log time: 1618124755.4602 ] [ Expend time: 0.003045 ] Save Cache: question_related_list_355bcb1efdaeffaa979f9a6f1891dec2_10, result type: array

[ Log time: 1618124755.4604 ] [ Expend time: 0.000157 ] Get Cache: update_views_article_3b17fd62fb81f2cd8de3bbeea7fe29db_234, result type: boolean

[ Log time: 1618124755.464 ] [ Expend time: 0.003499 ] Save Cache: update_views_article_3b17fd62fb81f2cd8de3bbeea7fe29db_234, result type: integer

[ Log time: 1618124755.5064 ] [ Expend time: 0.000323 ] Get Cache: posts_list_by_topic_ids_2e92d0dfa47dd0f0e171632f3198e50e, result type: boolean

[ Log time: 1618124755.5102 ] [ Expend time: 0.000265 ] Get Cache: db_rows_cache_b636669e67dfc2fc42210a0f5e32918f, result type: boolean

[ Log time: 1618124755.517 ] [ Expend time: 0.004073 ] Save Cache: db_rows_cache_b636669e67dfc2fc42210a0f5e32918f, result type: integer

[ Log time: 1618124755.5217 ] [ Expend time: 0.004623 ] Save Cache: posts_list_by_topic_ids_2e92d0dfa47dd0f0e171632f3198e50e, result type: array

[ Log time: 1618124755.5219 ] [ Expend time: 0.000162 ] Get Cache: posts_list_by_topic_ids_found_rows_acffc7257f0e872a7199b0026f03c1d0, result type: boolean

[ Log time: 1618124755.5257 ] [ Expend time: 0.003734 ] Save Cache: posts_list_by_topic_ids_found_rows_acffc7257f0e872a7199b0026f03c1d0, result type: integer


Crond

[ Log time: 1618124755.3375 ] Tag: minute, Last run time: 2021-04-11 15:04:55

[ Log time: 1618124755.3385 ] Tag: five_minutes, Last run time: 2021-04-11 15:02:18

[ Log time: 1618124755.3396 ] Tag: ten_minutes, Last run time: 2021-04-11 14:56:51

[ Log time: 1618124755.3406 ] Tag: half_hour, Last run time: 2021-04-11 14:48:54

[ Log time: 1618124755.3415 ] Tag: hour, Last run time: 2021-04-11 14:46:33

[ Log time: 1618124755.3425 ] Tag: day, Last run time: 2021-04-11 08:08:04


Escape time: 0.30026292800903, 50 queries, PHP Memory usage: 9519.5546875 KB, Server time: 2021-04-11 15:05:55