酯香香

7倍灵敏度荧光显身手显微技术迎来新跨越

阅读量：47

发布时间：2021-08-25

来源：酯香香化学采购网

　　【化工仪器网科技前沿】日本东京大学研究人员开发了一种方法，可以提高现有定量相位成像的灵敏度，同时看到活细胞内从微小颗粒到大型结构的所有结构。

　　2021年伊始，显微镜技术也迎来新的跨越。

　　光物理学家开发出一种新方法，利用现有显微镜技术，无需添加染色剂或荧光染料，就能更详细地观察活细胞内部。

　　一种荧光寿命显微镜技术，能够使用频率梳而不是机械部件来观察动态生物现象。

　　“我认为无标签技术将是一个重要的研究方向。特别是以无标签的方式对细胞内外病毒和外来体等小颗粒进行测量的技术将是未来成像设备的一个趋势。”其中一项研究的领导者、日本东京大学光子科学与技术研究所副教授Takuro Ideguchi在接受《中国科学报》采访时表示。

　　更大范围更小相位变化

　　由于单个细胞几乎是半透明的，因此显微镜照相机必须能探测到穿过部分细胞的光线的极其细微的差异。这些差异被称为光的相位。相机图像传感器则受到它们能检测到的光相位差的限制，即动态范围。

　　“为了使用同一图像传感器看到更详细的信息，我们必须扩大动态范围，这样就可以探测到更小的光相位变化。”Ideguchi说，“更大的动态范围允许我们测量小型和大型的相位图像。例如，如果测量一个细胞，细胞的主干会产生大的相位变化，而细胞内的小颗粒/分子会产生小的相位变化。为了使两者可视化，我们必须扩大测量的动态范围。”

　　该研究小组开发了一种技术，通过两次曝光分别测量光相位的大小变化，然后将它们无缝连接起来，制造出详细的终图像。他们将这种方法命名为自适应动态范围偏移定量相位成像(ADRIFT-QPI)。相关论文近日发表于《光：科学与应用》。

　　一直以来，定量相位成像是观察单个细胞的有力工具，它允许研究人员进行详细的测量，比如根据光波的位移跟踪细胞的生长速度。然而，由于图像传感器的饱和容量较低，该方法无法跟踪细胞内及周围的纳米颗粒。

　　而新方法克服了定量相位成像的动态范围限制。在ADRIFT-QPI中，相机需要两次曝光，并产生一个终图像，其灵敏度是传统定量相显微镜的7倍。

　　两次曝光告别光毒

　　第一次曝光是用常规的定量相位成像产生的——平的光脉冲指向样品，并在它通过样品后测量光的相移。计算机图像分析程序基于第一次曝光的图像，快速设计一个反射样品图像。然后，研究人员用一个叫做波前整形装置的独立组件，用更高强度的光产生一种“光雕塑”，以获得更强的照明，并向样品发出脉冲，进行第二次曝光。

　　如果第一次曝光产生的图像是样品的完美代表，第二次曝光的雕刻光波将以不同的相位进入并穿过样品，终只能看到一个黑暗的图像。

　　“有趣的是，我们在某种程度上抹去了样本的图像。实际上，我们几乎什么都不想看到。我们去掉了大的结构，这样就能看到小的细节。”Ideguchi解释道，由于第一次测量中存在较大的相位对象，受动态范围的限制，无法对较小的相位对象进行可视化，研究人员称之为“洗掉”。他们需要第二次测量观察动态范围移位的小相位物体的细节。

　　此外，该方法不需要特殊的激光、显微镜或图像传感器，研究人员可以使用活细胞，而且不需要任何染色或荧光，出现光毒性的可能性很小。光毒性是指用光杀死细胞，这也是其他成像技术如荧光成像面临的一个问题。

　　另一篇论文的通讯作者、日本德岛大学Post-LED光子学研究所教授Takeshi Yasui指出，在传统的激光扫描共焦显微镜中，强激发光聚焦在一个焦点上，并对焦点进行二维机械扫描，使光毒性的影响较强。 Yasui等人的荧光成像新方法中，激发光被聚焦为一个二维焦点，因此每个焦点的光强度变得非常弱。“光毒性高度依赖于入射光的强度，我们的方法也可以显著降低。”

　　改造荧光成像

　　实际上，荧光显微镜广泛用于生物化学和生命科学，因为它允许科学家直接观察细胞及其内部和周围的某些化合物。荧光分子能吸收特定波长范围内的光，然后在较长的波长范围内重新发射。

　　然而，传统荧光显微技术的主要局限性是其结果难以定量评价，而且荧光强度受实验条件和荧光物质浓度的显著影响。现在，一项新研究将彻底改变荧光显微镜领域。

　　当荧光物质被一束短脉冲光照射时，产生的荧光不会立即消失，而是随着时间的推移“衰减”。但荧光衰减非常快，普通相机无法捕捉到它。虽然可以使用单点光电探测器，但必须在整个样本区域进行扫描，才能从每个测量点重建出完整的二维图像。这个过程涉及到机械部件的运动，这极大限制了图像捕捉的速度。

　　幸运的是，在近发表于《科学进展》的一项研究中，科学家开发了一种不需要机械扫描就能获得荧光寿命图像的新方法。领导这项研究的日本德岛大学Post-LED光子学研究所教授Takeshi Yasui说，“我们能在2D空间上同时映射44400个‘光秒表’来测量荧光寿命——所有这些都在一次拍摄中，不需要扫描。”

　　“到目前为止，光频率梳被广泛地用作测量光频率的标尺，但我们一直在考虑其他的用途。”Yasui在接受《中国科学报》采访时说，“我们意识到，如果将光学频率梳视为具有超离散多光谱结构的光，通过维数转换将被测物理量叠加在光谱上，可以从双梳光谱获得的模式分辨光谱中共同获得被测物理量。”

　　研究人员使用光学频率梳作为样品的激发光。一个光学频率梳本质上是一个光信号，它们之间的间隔是恒定的。研究人员将一对激发频率梳信号分解为具有不同强度调制频率的单个光拍信号(双梳光拍)，每个光拍携带单个调制频率，辐照到目标样品上。而且，每束光束都在一个不同的空间位置击中样本，在样本二维表面的每个点和双梳光拍的每个调制频率之间形成一一对应的关系。

　　研究人员用数学方法将测量信号转换为频域信号，根据调制频率处的激发信号与测量信号之间存在的相位延迟，计算出每个像素处的荧光寿命。

　　Yasui表示，这将有助于动态观察活细胞，还可以用于多个样本的同时成像和抗原检测——这种方法已经被用于新冠肺炎的诊断。该技术还有助于开发出新的顽固性疾病疗法，提高预期寿命。

　　同样，Ideguchi也提到，ADRIFT-QPI能够在整个活细胞的背景下看到微小颗粒，而不需要任何标签或染色。“该技术可以检测到来自纳米级粒子的细小信号，比如病毒或在细胞内外移动的粒子，这样就可以同时观察它们的行为和细胞的状态。”

内容来源于酯香香化学采购网

下一篇：大连化物所发展出纤维素合成甲基环戊二烯新方法

上一篇：天津工业生物所等开发出基于宏基因组的亚胺还原酶工具箱

版权申明：

1.凡本网注明“来源：酯香香化学采购网”的所有文字、图片、音频和视频文件，版权均为有料网所有。如需转载请与客服电话：4008-938-935联系。任何媒体、网站或个人转载使用时须注明来源“有料网”，违反者本网将追究法律责任。
2.本网转载并注明其他来源的稿件，均来自互联网或业内投稿人士，版权属于原版权人。转载请保留稿件来源及作者，禁止擅自篡改违者自负版权法律责任。
3.本网评论版权中各网友的评论只代表网友个人观点，不代表本站的观点或立场。

产品品鉴

生物医用酯

酯类增塑剂

基础油脂

化工资讯

我国天然气产量连续3年增产超100亿立方米 2020中国（河北）国际橡胶塑料产业博览会火热启动 2020上海国际金属加工液、润滑油展览会火热启动 OPEC迎十年最大减产明年油价或继续承压 “智能+绿色”成化工教育重要方向污水处理迎来快速增长期化工人才需求上涨11.5%

行业新闻

加拿大油菜籽压榨步伐强劲同比增长近5个百分点 Nornickel将污染严重的铜冶炼厂关闭以推动环保财务省：日本11月精炼铜量同比增长37.4 中国主要铜冶炼厂下调2021年一季度的TC/RC 托管太钢集团，宝武系A股方阵扩容至10家中国进口澳大利亚铜精矿数量降至2016年以来最低水平

基本文件流程错误 SQL 调试

/www/dev/zhihuagong/public/index.php ( 1.51 KB )
/www/dev/zhihuagong/thinkphp/base.php ( 1.71 KB )
/www/dev/zhihuagong/thinkphp/library/think/Loader.php ( 12.70 KB )
/www/dev/zhihuagong/vendor/composer/autoload_static.php ( 21.91 KB )
/www/dev/zhihuagong/thinkphp/library/think/Error.php ( 4.00 KB )
/www/dev/zhihuagong/vendor/psr/log/Psr/Log/LoggerInterface.php ( 3.04 KB )
/www/dev/zhihuagong/thinkphp/library/think/Container.php ( 17.20 KB )
/www/dev/zhihuagong/thinkphp/library/think/App.php ( 27.58 KB )
/www/dev/zhihuagong/thinkphp/library/think/Env.php ( 2.85 KB )
/www/dev/zhihuagong/thinkphp/library/think/Config.php ( 9.71 KB )
/www/dev/zhihuagong/thinkphp/convention.php ( 11.74 KB )
/www/dev/zhihuagong/application/tags.php ( 1.08 KB )
/www/dev/zhihuagong/thinkphp/library/think/Hook.php ( 5.58 KB )
/www/dev/zhihuagong/application/common/behavior/Config.php ( 1.68 KB )
/www/dev/zhihuagong/application/common.php ( 32.83 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Request.php ( 6.32 KB )
/www/dev/zhihuagong/thinkphp/library/think/Facade.php ( 3.44 KB )
/www/dev/zhihuagong/thinkphp/library/think/Request.php ( 57.54 KB )
/www/dev/zhihuagong/application/function.php ( 0.68 KB )
/www/dev/zhihuagong/thinkphp/helper.php ( 20.40 KB )
/www/dev/zhihuagong/config/addons.php ( 1.33 KB )
/www/dev/zhihuagong/config/app.php ( 6.17 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Env.php ( 1.17 KB )
/www/dev/zhihuagong/config/cache.php ( 1.59 KB )
/www/dev/zhihuagong/config/captcha.php ( 0.96 KB )
/www/dev/zhihuagong/config/constant.php ( 1.33 KB )
/www/dev/zhihuagong/config/cookie.php ( 1.12 KB )
/www/dev/zhihuagong/config/database.php ( 2.36 KB )
/www/dev/zhihuagong/config/info.php ( 0.82 KB )
/www/dev/zhihuagong/config/log.php ( 1.01 KB )
/www/dev/zhihuagong/config/session.php ( 1.06 KB )
/www/dev/zhihuagong/config/template.php ( 2.24 KB )
/www/dev/zhihuagong/config/token.php ( 1.43 KB )
/www/dev/zhihuagong/config/trace.php ( 0.84 KB )
/www/dev/zhihuagong/config/version.php ( 0.92 KB )
/www/dev/zhihuagong/vendor/symfony/polyfill-php80/bootstrap.php ( 1.46 KB )
/www/dev/zhihuagong/vendor/symfony/polyfill-mbstring/bootstrap.php ( 7.07 KB )
/www/dev/zhihuagong/vendor/symfony/var-dumper/Resources/functions/dump.php ( 0.79 KB )
/www/dev/zhihuagong/vendor/symfony/deprecation-contracts/function.php ( 0.98 KB )
/www/dev/zhihuagong/vendor/ralouphie/getallheaders/src/getallheaders.php ( 1.60 KB )
/www/dev/zhihuagong/vendor/guzzlehttp/psr7/src/functions_include.php ( 0.15 KB )
/www/dev/zhihuagong/vendor/guzzlehttp/psr7/src/functions.php ( 13.09 KB )
/www/dev/zhihuagong/vendor/symfony/polyfill-intl-normalizer/bootstrap.php ( 0.71 KB )
/www/dev/zhihuagong/vendor/symfony/polyfill-php72/bootstrap.php ( 1.89 KB )
/www/dev/zhihuagong/vendor/guzzlehttp/promises/src/functions_include.php ( 0.16 KB )
/www/dev/zhihuagong/vendor/guzzlehttp/promises/src/functions.php ( 9.89 KB )
/www/dev/zhihuagong/vendor/symfony/polyfill-intl-idn/bootstrap.php ( 4.52 KB )
/www/dev/zhihuagong/vendor/guzzlehttp/guzzle/src/functions_include.php ( 0.16 KB )
/www/dev/zhihuagong/vendor/guzzlehttp/guzzle/src/functions.php ( 9.70 KB )
/www/dev/zhihuagong/vendor/symfony/polyfill-ctype/bootstrap.php ( 1.56 KB )
/www/dev/zhihuagong/vendor/khanamiryan/qrcode-detector-decoder/lib/common/customFunctions.php ( 1.75 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/helpers.php ( 3.61 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/alias.php ( 1.21 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Contracts/Support/Arrayable.php ( 0.19 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Contracts/Support/Jsonable.php ( 0.24 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Contracts/Support/Htmlable.php ( 0.19 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/Arr.php ( 16.36 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/Traits/Macroable.php ( 2.63 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/Collection.php ( 33.51 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/Traits/EnumeratesValues.php ( 26.07 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/Enumerable.php ( 23.81 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/HigherOrderCollectionProxy.php ( 1.40 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/HigherOrderWhenProxy.php ( 1.30 KB )
/www/dev/zhihuagong/vendor/tightenco/collect/src/Collect/Support/LazyCollection.php ( 33.64 KB )
/www/dev/zhihuagong/vendor/overtrue/pinyin/src/const.php ( 0.49 KB )
/www/dev/zhihuagong/vendor/topthink/think-captcha/src/helper.php ( 1.54 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Route.php ( 3.84 KB )
/www/dev/zhihuagong/thinkphp/library/think/Route.php ( 25.84 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/Domain.php ( 7.08 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/RuleGroup.php ( 16.45 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/Rule.php ( 28.92 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/RuleItem.php ( 8.84 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/RuleName.php ( 3.92 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Validate.php ( 4.83 KB )
/www/dev/zhihuagong/thinkphp/library/think/Validate.php ( 43.93 KB )
/www/dev/zhihuagong/vendor/topthink/think-helper/src/helper.php ( 7.35 KB )
/www/dev/zhihuagong/vendor/overtrue/wechat/src/Kernel/Support/Helpers.php ( 2.54 KB )
/www/dev/zhihuagong/vendor/overtrue/wechat/src/Kernel/Helpers.php ( 1.89 KB )
/www/dev/zhihuagong/thinkphp/library/think/Db.php ( 7.67 KB )
/www/dev/zhihuagong/thinkphp/library/think/Lang.php ( 7.38 KB )
/www/dev/zhihuagong/thinkphp/library/think/Log.php ( 8.92 KB )
/www/dev/zhihuagong/thinkphp/library/think/log/driver/File.php ( 8.97 KB )
/www/dev/zhihuagong/thinkphp/lang/zh-cn.php ( 12.58 KB )
/www/dev/zhihuagong/route/route.php ( 0.67 KB )
/www/dev/zhihuagong/route/route_cms.php ( 2.89 KB )
/www/dev/zhihuagong/route/router_api.php ( 0.84 KB )
/www/dev/zhihuagong/route/router_h5.php ( 0.92 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Config.php ( 1.52 KB )
/www/dev/zhihuagong/extend/libs/Cache_factory.php ( 2.92 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Cache.php ( 2.06 KB )
/www/dev/zhihuagong/thinkphp/library/think/Cache.php ( 3.27 KB )
/www/dev/zhihuagong/thinkphp/library/think/cache/driver/File.php ( 7.99 KB )
/www/dev/zhihuagong/thinkphp/library/think/cache/Driver.php ( 8.64 KB )
/www/dev/zhihuagong/application/common/behavior/InitHook.php ( 1.47 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Hook.php ( 1.46 KB )
/www/dev/zhihuagong/addons/phpmailer/Phpmailer.php ( 2.00 KB )
/www/dev/zhihuagong/extend/sys/Addons.php ( 6.49 KB )
/www/dev/zhihuagong/thinkphp/library/think/View.php ( 5.74 KB )
/www/dev/zhihuagong/thinkphp/library/think/view/driver/Think.php ( 6.12 KB )
/www/dev/zhihuagong/thinkphp/library/think/Template.php ( 47.31 KB )
/www/dev/zhihuagong/thinkphp/library/think/template/driver/File.php ( 2.29 KB )
/www/dev/zhihuagong/application/cms/behavior/Hooks.php ( 1.10 KB )
/www/dev/zhihuagong/extend/sys/Hooks.php ( 2.48 KB )
/www/dev/zhihuagong/application/cms/function.php ( 10.81 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/dispatch/Module.php ( 5.19 KB )
/www/dev/zhihuagong/thinkphp/library/think/route/Dispatch.php ( 9.26 KB )
/www/dev/zhihuagong/application/cms/config/paginate.php ( 0.85 KB )
/www/dev/zhihuagong/thinkphp/library/think/Middleware.php ( 5.34 KB )
/www/dev/zhihuagong/thinkphp/library/think/Cookie.php ( 7.35 KB )
/www/dev/zhihuagong/thinkphp/library/think/Session.php ( 14.13 KB )
/www/dev/zhihuagong/thinkphp/library/think/Debug.php ( 7.57 KB )
/www/dev/zhihuagong/application/cms/controller/Article.php ( 3.50 KB )
/www/dev/zhihuagong/application/cms/controller/Cmsbase.php ( 11.29 KB )
/www/dev/zhihuagong/application/member/controller/MemberBase.php ( 2.70 KB )
/www/dev/zhihuagong/application/common/controller/Homebase.php ( 2.38 KB )
/www/dev/zhihuagong/application/common/controller/Base.php ( 0.87 KB )
/www/dev/zhihuagong/thinkphp/library/think/Controller.php ( 7.53 KB )
/www/dev/zhihuagong/thinkphp/library/traits/controller/Jump.php ( 4.76 KB )
/www/dev/zhihuagong/application/member/service/User.php ( 13.62 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Cookie.php ( 1.58 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Url.php ( 1.13 KB )
/www/dev/zhihuagong/thinkphp/library/think/Url.php ( 13.22 KB )
/www/dev/zhihuagong/thinkphp/library/think/cache/driver/Redis.php ( 7.24 KB )
/www/dev/zhihuagong/thinkphp/library/think/db/Connection.php ( 58.93 KB )
/www/dev/zhihuagong/thinkphp/library/think/db/connector/Mysql.php ( 6.22 KB )
/www/dev/zhihuagong/thinkphp/library/think/db/builder/Mysql.php ( 5.85 KB )
/www/dev/zhihuagong/thinkphp/library/think/db/Builder.php ( 36.76 KB )
/www/dev/zhihuagong/thinkphp/library/think/db/Query.php ( 105.00 KB )
/www/dev/zhihuagong/application/cms/service/GoodsService.php ( 14.62 KB )
/www/dev/zhihuagong/application/cms/service/Base.php ( 0.62 KB )
/www/dev/zhihuagong/application/common/model/Goods.php ( 0.08 KB )
/www/dev/zhihuagong/thinkphp/library/think/Model.php ( 28.52 KB )
/www/dev/zhihuagong/thinkphp/library/think/model/concern/Attribute.php ( 17.64 KB )
/www/dev/zhihuagong/thinkphp/library/think/model/concern/RelationShip.php ( 20.60 KB )
/www/dev/zhihuagong/thinkphp/library/think/model/concern/ModelEvent.php ( 6.04 KB )
/www/dev/zhihuagong/thinkphp/library/think/model/concern/TimeStamp.php ( 2.58 KB )
/www/dev/zhihuagong/thinkphp/library/think/model/concern/Conversion.php ( 7.84 KB )
/www/dev/zhihuagong/application/cms/service/ComponentsService.php ( 12.91 KB )
/www/dev/zhihuagong/application/admin/model/Config.php ( 3.34 KB )
/www/dev/zhihuagong/application/links/model/Links.php ( 0.84 KB )
/www/dev/zhihuagong/application/admin/model/Poster.php ( 0.07 KB )
/www/dev/zhihuagong/application/admin/model/Base.php ( 4.15 KB )
/www/dev/zhihuagong/thinkphp/library/think/facade/Session.php ( 2.05 KB )
/www/dev/zhihuagong/application/admin/model/GoodsCategory.php ( 0.09 KB )
/www/dev/zhihuagong/thinkphp/library/think/exception/ErrorException.php ( 1.68 KB )
/www/dev/zhihuagong/thinkphp/library/think/Exception.php ( 1.61 KB )
/www/dev/zhihuagong/thinkphp/library/think/exception/Handle.php ( 8.96 KB )
/www/dev/zhihuagong/thinkphp/library/think/db/Expression.php ( 1.11 KB )
/www/dev/zhihuagong/thinkphp/library/think/model/Collection.php ( 3.23 KB )
/www/dev/zhihuagong/thinkphp/library/think/Collection.php ( 13.60 KB )
/www/dev/zhihuagong/runtime/temp/b275df7f7078649353258fc8c4a5003e.php ( 37.86 KB )
/www/dev/zhihuagong/thinkphp/library/think/Response.php ( 9.68 KB )
/www/dev/zhihuagong/thinkphp/library/think/debug/Html.php ( 4.02 KB )

[ DB ] CONNECT:[ UseTime:0.000392s ] mysql:host=127.0.0.1;port=3306;dbname=yzncms;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yzn_poster` [ RunTime:0.000885s ]
[ SQL ] SELECT * FROM `yzn_poster` WHERE `cate_id` = 99 AND `p_c_id` = 52 AND `status` = 1 LIMIT 1 [ RunTime:0.000394s ]
[ SQL ] SELECT * FROM `yzn_poster` WHERE `cate_id` = 99 AND `p_c_id` = 55 AND `status` = 1 LIMIT 1 [ RunTime:0.000312s ]
[ SQL ] SHOW COLUMNS FROM `yzn_goods_property` [ RunTime:0.000774s ]
[ SQL ] SELECT `g`.`name`,`p`.`price`,`p`.`unit`,`p`.`type`,`p`.`thumb`,p.id as p_id,`p`.`value`,`p`.`is_where`,`p`.`sku_unit`,`p`.`repeat_type`,`p`.`goods_id` FROM `yzn_goods_property` `p` LEFT JOIN `yzn_goods` `g` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%1%' AND `p`.`recommend` = 1 GROUP BY `p`.`goods_id`,`p`.`repeat_type` ORDER BY `p`.`sort` DESC,`g`.`id` DESC LIMIT 0,15 [ RunTime:0.000986s ]
[ SQL ] SHOW COLUMNS FROM `yzn_goods_category` [ RunTime:0.000647s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `hot_search` = 1 AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000316s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `is_show` > 0 AND `status` = 1 ORDER BY `listorder` ASC [ RunTime:0.000309s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `id` IN (1,2,7,16,17,34,92,95,38) [ RunTime:0.000310s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 1 AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000228s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 2 AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000209s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 7 AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000221s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 16 AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000206s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 17 AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000204s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` IN (34,92) AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000223s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` IN (95,38) AND `status` = 1 ORDER BY `listorder` ASC,`id` DESC [ RunTime:0.000215s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 1 AND `status` = 1 [ RunTime:0.000184s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` = 1 [ RunTime:0.000229s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,1,%' ) [ RunTime:0.000211s ]
[ SQL ] SHOW COLUMNS FROM `yzn_goods` [ RunTime:0.000656s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%1%' AND `g`.`cate_id` IN (25,26,29,30,48,1) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.001041s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 2 AND `status` = 1 [ RunTime:0.000221s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` = 2 [ RunTime:0.000201s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,2,%' ) [ RunTime:0.000203s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%1%' AND `g`.`cate_id` IN (42,43,2) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.000975s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 7 AND `status` = 1 [ RunTime:0.000207s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` = 7 [ RunTime:0.000238s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,7,%' ) [ RunTime:0.000200s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%1%' AND `g`.`cate_id` IN (10,14,32,33,49,50,51,52,53,54,55,56,57,58,96,97,7) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.000990s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 16 AND `status` = 1 [ RunTime:0.000208s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` = 16 [ RunTime:0.000213s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,16,%' ) [ RunTime:0.000200s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%1%' AND `g`.`cate_id` IN (59,60,61,62,63,16) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.000950s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 17 AND `status` = 1 [ RunTime:0.000239s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` = 17 [ RunTime:0.000208s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,17,%' ) [ RunTime:0.000200s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%1%' AND `g`.`cate_id` IN (40,64,65,66,67,68,100,17) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.000941s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 34 AND `status` = 1 [ RunTime:0.000248s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 92 AND `status` = 1 [ RunTime:0.000202s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` IN (34,92) [ RunTime:0.000247s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,34,%' or arrparentid like '0,92,%' ) [ RunTime:0.000251s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%1%' AND `g`.`cate_id` IN (35,70,71,93,94,34,92) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.000945s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 95 AND `status` = 1 [ RunTime:0.000221s ]
[ SQL ] SELECT `id`,`catname` FROM `yzn_goods_category` WHERE `pid` = 38 AND `status` = 1 [ RunTime:0.000222s ]
[ SQL ] SELECT * FROM `yzn_goods_category` WHERE `status` = 1 AND `id` IN (95,38) [ RunTime:0.000267s ]
[ SQL ] SELECT `id` FROM `yzn_goods_category` WHERE `status` = 1 AND ( arrparentid like '0,38,%' or arrparentid like '0,95,%' ) [ RunTime:0.000222s ]
[ SQL ] SELECT `g`.`name`,p.id as p_id,`p`.`price`,`p`.`type`,`p`.`thumb`,`p`.`unit`,`p`.`is_where`,`p`.`goods_id`,`p`.`repeat_type` FROM `yzn_goods` `g` LEFT JOIN `yzn_goods_property` `p` ON `p`.`goods_id`=`g`.`id` WHERE `p`.`status` = 1 AND `p`.`is_del` = 0 AND `g`.`is_del` = 0 AND `p`.`is_where` LIKE '%1%' AND `g`.`cate_id` IN (47,74,75,76,77,78,79,80,81,82,83,99,95,38) AND `p`.`hot_sale` = '1' GROUP BY `p`.`repeat_type`,`p`.`goods_id` ORDER BY `p`.`sort` DESC,`p`.`id` DESC LIMIT 0,10 [ RunTime:0.000957s ]
[ SQL ] SHOW COLUMNS FROM `yzn_article` [ RunTime:0.001073s ]
[ SQL ] SELECT `A`.*,`AD`.*,`C`.`catname` FROM `yzn_article` `A` INNER JOIN `yzn_article_data` `AD` ON `A`.`id`=`AD`.`did` INNER JOIN `yzn_category` `C` ON `C`.`id`=`A`.`catid` WHERE `A`.`id` = 5593 AND `A`.`status` = 1 LIMIT 1 [ RunTime:0.000790s ]
[ SQL ] SHOW COLUMNS FROM `yzn_category` [ RunTime:0.000593s ]
[ SQL ] SELECT `id` FROM `yzn_category` WHERE `parentid` = 35 AND `status` = 1 [ RunTime:0.000223s ]
[ SQL ] SELECT `id` FROM `yzn_category` WHERE `parentid` IN (36,37,38,39,40,41,42) AND `status` = 1 [ RunTime:0.000197s ]
[ SQL ] SELECT `id` FROM `yzn_category` WHERE `parentid` = 43 AND `status` = 1 [ RunTime:0.000181s ]
[ SQL ] SELECT `id` FROM `yzn_category` WHERE `parentid` IN (44,45,46,47,48,49,50) AND `status` = 1 [ RunTime:0.000223s ]
[ SQL ] SELECT `id` FROM `yzn_category` WHERE `parentid` = 6 AND `status` = 1 [ RunTime:0.000178s ]
[ DB ] CONNECT:[ UseTime:0.000257s ] mysql:host=127.0.0.1;port=3306;dbname=yzncms;charset=utf8
[ SQL ] SELECT `A`.`id`,`A`.`title` FROM `yzn_article` `A` INNER JOIN `yzn_category` `C` ON `C`.`id`=`A`.`catid` WHERE `A`.`status` = 1 AND `A`.`catid` IN (35,36,37,38,39,40,41,42) ORDER BY `A`.`flag` DESC,`A`.`listorder` ASC,`A`.`updatetime` DESC [ RunTime:0.020940s ]
[ SQL ] UPDATE `yzn_article` SET `hits` = `hits` + 1 WHERE `id` = 5593 [ RunTime:0.000358s ]
[ SQL ] SELECT * FROM `yzn_poster` WHERE `cate_id` = 10 AND `p_c_id` = 41 ORDER BY `listorder` ASC LIMIT 4 [ RunTime:0.000449s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_article` `a` INNER JOIN `yzn_category` `c` ON `a`.`catid`=`c`.`id` WHERE `catid` = 38 AND `a`.`status` = 1 [ RunTime:0.002779s ]
[ SQL ] SELECT `a`.*,`c`.`catname` FROM `yzn_article` `a` INNER JOIN `yzn_category` `c` ON `a`.`catid`=`c`.`id` WHERE `catid` = 38 AND `a`.`status` = 1 ORDER BY `flag` DESC,`listorder` ASC,`updatetime` DESC LIMIT 0,6 [ RunTime:0.005334s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `yzn_article` `a` INNER JOIN `yzn_category` `c` ON `a`.`catid`=`c`.`id` WHERE `catid` = 37 AND `a`.`status` = 1 [ RunTime:0.002670s ]
[ SQL ] SELECT `a`.*,`c`.`catname` FROM `yzn_article` `a` INNER JOIN `yzn_category` `c` ON `a`.`catid`=`c`.`id` WHERE `catid` = 37 AND `a`.`status` = 1 ORDER BY `flag` DESC,`listorder` ASC,`updatetime` DESC LIMIT 0,6 [ RunTime:0.005055s ]