微信点餐小程序-启动移动APP之前要进行的十五个

--------

微信点餐小程序

-------

你的总体目标销售市场早已变得挪动化。挪动客户数最多可将那时候间的12%花销在其机器设备上访问,这非常于每个月花销87个小时,或每一年花销1,044个小时。在其中90%的時间都花在了应用挪动运用上。

这就是为何有着挪动APP对你的业务流程这般有使用价值的缘故。难怪每一个人好像都在追逐潮流。如今,乃至67%的小型公司都有着挪动APP。

难题是,很多APP只是对原本就不太好的网站的可怕拓展。虽然你将会会期盼立即开发设计自身的商品并将其推向销售市场,但这是一个极大的不正确。挪动APP是你网站的门户网。因而,尝试在沒有开展重要的网站优化的状况下执行它们会立即危害建立运用程序所需的時间和钱财。

在考虑到应用挪动APP之前,你需要开展以下15个网站调剂。


速度优化

速度针对客户体验相当关键。这意味着,假如你期待你的网站和挪动APP出示优异的客户体验,那末你要做的第一件事就是优化网站速度。

为此,你需要开展以下调剂:

1.变小

变小可降低网站CSS,JavaScript和HTML內容的尺寸。它能够根据删掉任何无须要的网站编码来工作中,例如:

JavaScript中无须要的编码;

CSS中未应用的空格;

HTML中无须要的换行符。

假如你应用WordPress,则有许多可用的软件能够协助你进行此全过程,包含Fast Velocity Minify和Autoptimize。

2.缩小

文字缩小还能够提升速度,特别是在blog等文字多种多样的网站上。大大部分Content Delivery Network适用推送缩小文档,因而你能够根据诸如Gzip之类的专用工具设定默认设置缩小。

假如你沒有自身的网站,则能够应用Check GZIP Compression查询是不是已设定缩小。假如并不是,最简易的安裝方式是根据软件,例如W3 Total Cache,WP Super Cache或WP Rocket。

3.最大化缓存文件

HTTP缓存文件是访问器储存資源副本时能够更快地再次浏览它们的時间。应用HTTP缓存文件头,能够界定响应的時间,方法和時间。

你能够将服务器配备为额外HTTP Cache-Control标头,并对其开展改动,使其保存数据信息的時间。一种方式是将标头立即加上到编码中。

这是一个PHP标头的示例,在其中Cache-Control设定的max-age等于84,600秒(1天):

header( Cache-Control: max-age=84600 )

根据设定最大合理限期标头,能够保证反复浏览者不会减少浏览她们之前免费下载的資源的速度。旨在尽量安全性地在尽量长的時间内缓存文件尽量多的資源。随后出示认证令牌,以合理地再次认证已升级的資源。

4.降低JAVASCRIPT载入時间

JavaScript将会会致使延迟时间,非常是假如捆缚有很多JavaScript时。在一般手机上上,解决这些捆缚包所花销的時间将会比台式机长5–10倍。你能够根据编码拆分来处理此难题。

编码拆分将你的JavaScript包分为几一部分,以便仅在客户需要时才更快地交货它们。能够应用React,Parcel和Webpack之类的专用工具将其运用于路由器级別或组件级別。

5.优化图象

视觉效果实际效果针对提升客户参加度很关键,可是你最终想要的是让它们减慢客户体验。值得庆幸的是,销售市场上有许多专用工具能够协助你缩小和优化图象。

6.文件格式化动漫內容

GIF文件格式在动漫中很时兴,但具体上几乎沒有将其用作动漫服务平台。根据切换为更适合的视頻文件格式,你能够大大减小文档尺寸并加速网页页面時间。

你能够应用FFmpeg专用工具将动漫GIF变换为mp4文档。你还能够应用合理种类API专用工具来明确较慢的带宽,并全自动将其从出示动漫图象变换为更小的JPEG。虽然的确清除了一些客户体验,但比站点没法载入或运作迟缓不一切正常要好。

7.降低软件

WordPress有超出54,000个软件。虽然它是销售市场上最大的服务平台,但即便市场竞争的选件,依然能够出示不计其数种软件。有软件基本上任何你能想到这些天-merce为WordPress,电子邮件营销软件,像Mailchimp和转换率优化软件,像OptinMonster。在其中很多加上了有使用价值的作用。

难题是,太多的软件会减少你的网站速度。最先,请保证沒有安裝任何未应用的物品。接下来,卸载可根据别的方法与你的网站集成化的服务的全部软件。当你能够应用API密匙开展集成化时,沒有理由应用软件。

最终,假如你依然有许多软件,请找寻一些能够取代极少数独特商品的多合一处理计划方案。例如,当全部三个处理计划方案都有一个时,请不要应用独立的软件开展变小,缩小缓和存。可是,请实行敬业调研,由于诸如Jetpack之类的多合一软件会使你的网站变慢的速度比别的任何网站都要慢。

多少个软件算太多?这是一般的工作经验规律:

假如你有着共享资源或费用预算的云代管,则不可超出五个;

假如你应用云代管,V凡科抠图代管或专用服务器,则不超出20个。

8.应用AMP

加快挪动网页页面(AMP)是指一种开源系统Web程序编写語言,可将静态数据內容马上传送到挪动机器设备。它基本上是精简,精简的HTML版本号,专业用于加快挪动机器设备上的非互动式网页页面。

因为它是精简版,因而你需要权衡一些作用以完成这类迅速的速度。有两个潜伏的缺陷需要留意:

JavaScript仅限于现成的AMP库;

启用了延迟时间载入作用(向下翻转图象时会载入图象);

潜伏顾客的造成将会会遭受危害,由于AMP常常删掉挑选添加的表格。

另外一方面,最大的优点(除提升的速度)是检索模块的挪动优先选择数据库索引作用能够在检索結果中提高AMP网页页面。有很多用于启用AMP的软件可供挑选,包含AMP,用于WP的AMP –加快的挪动网页页面和AMP WP – WordPress的Google AMP。

9.详细地址重定项和连接断开

重定项和断开的连接将会会破坏你的客户体验,并减慢你的网站速度。

再次导向

你将要尽量降低重定项,由于它们会危害网页页面速度,乃至会危害网站的总体载入時间。当客户应用挪动机器设备时,延迟时间常常会变得更为显著。

你能够应用完全免费的专用工具来查验你的网站是不是有任何重定项。找到某些內容后,请删掉全部不需要的內容,并对需要升级的內容开展变更。

假如你有一个安全性的站点,则还能够应用HSTS删掉SSL重定项。

因为重定项和断开的连接会伴随着時间的流逝再度出現,因而这两项查验都应做为网站后台管理的基本一部分。

10.不断检测

在详细介绍挪动APP之前,大家早已详细介绍了九种关键的方式来优化你的网页页面速度。虽然这能够显著提升网站特性,但你仍有更多的改善机遇。

了解百种专用工具可用于检测你的网站网页页面速度和挪动提前准备状况,可是最好的起始点是Google的PageSpeed Insights专用工具。

它将为你出示网站的桌面上版和挪动版确当前网页页面速度得分,并就怎样改善提出实际提议。

下一步是应用“ 检测我的网站”进一步剖析挪动网页页面的速度和友善程度。

你需要做的就是键入你的网站URL,它将扫描仪你的网站并开展评定。你还能够得到包括优化提议的完全免费汇报,以换取递交你的电子器件电子邮件。

网站速度还出示了极大的SEO收益。除编写高品质的长文件格式內容并得到反方向连接外,网站速度对提升网站总流量也有重大危害。

在2019今年初,我开展了本人实例科学研究,在15天内我写了尽量多的佳宾帖子。在这段時间内,我收到了247个反方向连接,当然总流量提升了372%。

可是,与网站速度对我的挪动总流量的危害相比,这显得无足轻重。依据Google Analytics(剖析)数据信息,根据将我的挪动机器设备速度从33提高到75+,我的挪动机器设备排名提升了1775%。


UI优化

速度将会是UX层级构造中的最高级别别,但这并不是唯一的因素。也有别的要考虑到的组件,例如:

找到你想要的物品很非常容易;

该网站合适你的挪动屏幕的程度;

应用起来很简易;

它看起来有多吸引住人。

你能够应用以下站点调剂来简化和最大化客户页面。

11.简化你的网站构造

你的网站务必直观易用,以便客户访问,特别是当她们尝试在挪动机器设备的小屏幕上访问时。

保证简化了层级构造,而且嵌套循环的內容级別不超出一个。你理想化的网站构造应以下所示:

种别(或一部分)

子种别(仅可用于较大的网站)

某些网页页面和帖子

关心客户一般会找寻的內容,并整体规划出她们将采用的普遍相对路径。随后,你能够按层级构造排序种别,这将对你的受众人群最成心义。

你还应当应用专业知识库手机软件为寻找普遍难题答案的任何客户建立中间資源或专业知识库。

这是有关你能够开展的最简易的设计方案调剂,它将对台式机和挪动机器设备的应用造成长久危害。

12.潜心于內容设计方案

围绕挪动机器设备设计方案內容将会会有些繁杂,但这针对取得成功的挪动体验相当关键。一个不尽人意的网站制作能够杀死你的运用內容。

最关键的是,你需要让你的內容发光,并尽量降低影响。为此,你将会需要删掉表格,图型和别的不可用于小屏幕的沉重元素。

你还需要精简页眉,页脚,菜单和侧栏之类的作用,以即可以在较小的屏幕上掩藏或折叠它们。因为很多挪动机器设备不具备此作用,因而请对其內容禁用任何悬停实际效果。

你也不想应用太多文本。你能够应用英语的语法总体目标和受众等专用工具来降低文字,以协助你建立更简约的文字。乃至更好的是,集中化活力用更多的视頻內容更换文字,以最大程度地提升挪动体验。

13.降低banner和翻转条

翻转条早已时兴了一段時间,可是人们一般会向翻转条加上5-6张高品质的图象,这会提升网站的总体载入時间。另外,科学研究说明,翻转条会惹恼客户并减少可见度,特别是在挪动机器设备上。

宣传语将会会致使相近的难题,非常是假如宣传语在图象中有任何嵌入的文字。假如当今有带有文本的banner,则应应用HTML和CSS展现文本,而并不是将其嵌入图象中。这将使其更灵便,更容易于在较小的屏幕上查询。

14.优化表格和触碰点

假如你的网站上有表格,请留意字段种类,长度和标识。在任何机器设备上,一切都应当清楚可见。启用作用,以便假如客户点一下某个字段以键入信息内容,则该主视图会变大到正确的部位。

查验是不是有需要别的电脑键盘或触碰屏的字段种类,例如邮编,电話号码或电子器件签字。假如是这样,则应将其设定为在点一下时开启正确的电脑键盘,因而客户无须手动式切换。

保证全部触碰点和按钮都可见而且充足大,以即可以用手指在小屏幕上轻按。规范提议是它们的尺寸应约为48 x 48 dp。将文字放在按钮内而并不是上方或正下方,以便于鉴别。

15.简化下单步骤

假如你运营一个电子器件商务网站,那末最终的调剂提议是给你的。

大概一半的电子器件商务总流量来自挪动机器设备,但要购买更多的人,依然能够在台式机勤奋行。这极可能是由于针对挪动机器设备未正确优化购买,结帐和支付的全部步骤。

要明确你的全过程需要改善的地区,请跨多个机器设备和显示屏尺寸进行全部流程,并明确全部难点。难题将会是大家早已处理的难题,例如表单导航栏艰难或触碰点太小。

可是,即便开展了优化,但假如你需要很多数据信息,从挪动机器设备上键入全部数据信息依然很麻烦。

你能够根据以正下方式之一对此开展补救:

容许客户建立配备文档,该配备文档将储存并预先填充其结帐信息内容,包含送货详细地址和个人信用卡号

与别的支付网关集成化,后者不需要它们再次键入信息内容。


结果

手机上屏幕愈来愈大,平板电脑上也愈来愈繁杂,因而难怪更多的观众正在根据挪动机器设备登陆并开展互动。

挪动APP将会是与客户进一步互动的好方式。可是,仅有先优化你的网站才可以保证顺畅的客户体验。



恳求信息内容 : 2020⑿-19 HTTP/1.1 GET : /news/运作時间 : 0.304217s [ 吞吐量率:3.29req/s ] 运行内存耗费:4,512.66kb 文档载入:73查寻信息内容 : 167 queries 1 writes 缓存文件信息内容 : 109 reads,0 writes配备载入 : 99对话信息内容 : SESSION_ID=plbhptfn9r91loij65l2du5oc6
/home/wwwroot/ ( 0.74 KB )/home/wwwroot//start.php ( 0.72 KB )/home/wwwroot//base.php ( 2.60 KB )/home/wwwroot//library/ ( 21.07 KB )/home/wwwroot/wldev/vendor/ ( 3.51 KB )/home/wwwroot/wldev/vendor/topthink/think-helper/ ( 2.88 KB )/home/wwwroot/wldev/vendor/topthink/think-captcha/ ( 1.59 KB )/home/wwwroot//library/ ( 60.23 KB )/home/wwwroot//library/ ( 6.38 KB )/home/wwwroot//library/ ( 41.63 KB )/home/wwwroot/wldev/vendor/topthink/think-migration/ ( 0.83 KB )/home/wwwroot//library/ ( 23.13 KB )/home/wwwroot/wldev/vendor/topthink/think-queue/ ( 1.19 KB )/home/wwwroot//library/ ( 3.75 KB )/home/wwwroot//convention.php ( 10.37 KB )/home/wwwroot//library/ ( 21.51 KB )/home/wwwroot//library/ ( 49.78 KB )/home/wwwroot/wldev/ ( 8.86 KB )/home/wwwroot//library/ ( 1.21 KB )/home/wwwroot/wldev/ ( 1.88 KB )/home/wwwroot/wldev/application/ ( 0.15 KB )/home/wwwroot/wldev/application/ ( 0.20 KB )/home/wwwroot/wldev/application/ ( 0.35 KB )/home/wwwroot/wldev/application/ ( 0.14 KB )/home/wwwroot/wldev/application/ ( 0.08 KB )/home/wwwroot/wldev/application/ ( 0.18 KB )/home/wwwroot/wldev/application/ ( 0.78 KB )/home/wwwroot/wldev/application/ ( 1.41 KB )/home/wwwroot/wldev/application/ ( 0.62 KB )/home/wwwroot//library/ ( 4.71 KB )/home/wwwroot/wldev/ ( 0.96 KB )/home/wwwroot/wldev/ ( 31.18 KB )/home/wwwroot//helper.php ( 17.30 KB )/home/wwwroot//library/ ( 7.23 KB )/home/wwwroot//library/ ( 6.05 KB )/home/wwwroot//lang/.php ( 11.81 KB )/home/wwwroot/wldev/ ( 3.50 KB )/home/wwwroot//library/ ( 10.86 KB )/home/wwwroot//library/ ( 6.67 KB )/home/wwwroot//library/think/db/ ( 3.89 KB )/home/wwwroot//library/think/ ( 29.97 KB )/home/wwwroot//library/think/ ( 93.74 KB )/home/wwwroot//library/think/db/ ( 4.53 KB )/home/wwwroot//library/think/ ( 31.55 KB )/home/wwwroot//library/ ( 7.13 KB )/home/wwwroot/mon/ ( 3.88 KB )/home/wwwroot//library/ ( 69.14 KB )/home/wwwroot//library/think/model/ ( 7.37 KB )/home/wwwroot//library/think/model/ ( 10.03 KB )/home/wwwroot//library/think/ ( 3.61 KB )/home/wwwroot/mon/ ( 2.88 KB )/home/wwwroot//library/think/model/ ( 9.97 KB )/home/wwwroot//library/think/ ( 2.27 KB )/home/wwwroot//library/ ( 10.91 KB )/home/wwwroot//library/ ( 6.10 KB )/home/wwwroot//library/think/cache/ ( 7.27 KB )/home/wwwroot//library/think/ ( 5.98 KB )/home/wwwroot/wldev/application/ ( 1.82 KB )/home/wwwroot/wldev/application/index/ ( 6.08 KB )/home/wwwroot/mon/ ( 0.61 KB )/home/wwwroot/mon/ ( 3.76 KB )/home/wwwroot//library/ ( 6.07 KB )/home/wwwroot//library/traits/ ( 4.90 KB )/home/wwwroot//library/ ( 6.77 KB )/home/wwwroot//library/think/view/ ( 5.64 KB )/home/wwwroot//library/ ( 44.90 KB )/home/wwwroot//library/think/template/ ( 2.24 KB )/home/wwwroot/wldev/runtime/ ( 44.45 KB )/home/wwwroot//library/think/ ( 1.11 KB )/home/wwwroot//library/think/paginator/ ( 5.23 KB )/home/wwwroot//library/ ( 9.75 KB )/home/wwwroot//library/ ( 8.28 KB )/home/wwwroot//library/think/ ( 4.17 KB )
[ LANG ] /home/wwwroot//lang/.php[ SESSION ] INIT array ( 'id' = '', 'var_session_id' = '', 'prefix' = 'think', 'type' = '', 'auto_start' = true, )[ DB ] INIT mysql[ CACHE ] INIT File[ ROUTE ] array ( 'type' = 'module', 'module' = array ( 0 = 'index', 1 = 'index', 2 = 'index', 'convert' = false, )[ HEADER ] array ( 'connection' = 'Keep-Alive', 'host' = '', 'applvkey' = '2020⑿-18 17,e21f6aa6a55a581ee03e01a88e01c6f4', 'accept-language' = ',zh;', 'accept-encoding' = '', 'referer' = 'news/', 'user-agent' = 'Mozilla/5.0+(compatible;+Baiduspider/2.0;++)', 'accept' = '*/*', 'content-type' = '', 'content-length' = '', )[ PARAM ] array ( 'cid' = '17', 'id' = '310', )[ RUN ] app\index\controller\Index- index[ /home/wwwroot/wldev/application/index/ ][ VIEW ] tpl/ [ array ( 0 = 'id', 1 = 'cid', 2 = 'pid', 3 = 'info', 4 = 'data', 5 = 'title', 6 = 'keywords', 7 = 'description', 8 = 'tpl',
[ DB ] CONNECT:[ UseTime:0.000487s ] mysql:host=127.0.0.1;dbname=wldev;charset=utf8[ SQL ] SHOW COLUMNS FROM `wl_system` [ RunTime:0.001264s ][ SQL ] SELECT `value` FROM `wl_system` WHERE `name` = 'default_lang' LIMIT 1 [ RunTime:0.000416s ][ SQL ] SHOW COLUMNS FROM `wl_lang` [ RunTime:0.001109s ][ SQL ] SELECT * FROM `wl_lang` WHERE `lang` = 'cn' LIMIT 1 [ RunTime:0.000379s ][ SQL ] SHOW COLUMNS FROM `wl_column` [ RunTime:0.001409s ][ SQL ] SELECT * FROM `wl_column` WHERE `lang` = 'cn' ORDER BY `sort_order` ASC [ RunTime:0.000508s ][ SQL ] SHOW COLUMNS FROM `wl_article` [ RunTime:0.001206s ][ SQL ] SELECT * FROM `wl_article` WHERE `cid` IN (1,3,2,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,27,28,30,31,32,33,34,35,36,37,38) ORDER BY `id` DESC [ RunTime:0.006513s ][ SQL ] SELECT `id`,`cid`,`custom_url` FROM `wl_article` WHERE `status` = 1 AND `cid` IN (1,3,2,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,21,27,28,30,31,32,33,34,35,36,37,38) ORDER BY `is_top` DESC,`sort_order` ASC,`time` DESC,`id` DESC [ RunTime:0.000858s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000511s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000331s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000456s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000318s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000358s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000317s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000486s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000359s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000317s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000429s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000316s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000400s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000313s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000316s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000312s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000316s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000328s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000353s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000390s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000314s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000394s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000313s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000390s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000310s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000344s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000314s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000335s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000358s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000332s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000348s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000323s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000379s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000359s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000319s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000411s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000315s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000328s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000308s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000334s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000310s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000311s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000338s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000313s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000325s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000310s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000354s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000311s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000348s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000312s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000341s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000310s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000342s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000311s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000358s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000316s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000311s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000312s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000336s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000310s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000324s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000424s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000315s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000359s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000331s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000344s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000395s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000316s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000345s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000308s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000393s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000319s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000353s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000308s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000363s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000307s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000311s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000325s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000308s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000347s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000357s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000311s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000436s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000312s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000422s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000311s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000507s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000461s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000398s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000406s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000517s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000469s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000351s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000411s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000384s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000480s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000360s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000371s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000356s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000420s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000347s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000374s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000358s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000372s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000317s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000384s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000312s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000364s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000313s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000334s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000350s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000375s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000346s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000359s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000322s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000361s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000351s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000345s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000403s ][ SQL ] SELECT * FROM `wl_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000351s ][ SQL ] SELECT * FROM `wl_article` WHERE `id` = 310 AND `status` = 1 AND `lang` = 'cn' LIMIT 1 [ RunTime:0.000886s ][ SQL ] SHOW COLUMNS FROM `wl_tags` [ RunTime:0.001144s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 62 LIMIT 1 [ RunTime:0.000282s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 63 LIMIT 1 [ RunTime:0.000308s ][ SQL ] UPDATE `wl_article` SET `view`=`view`+1 WHERE `id` = 310 [ RunTime:0.011359s ][ SQL ] SELECT * FROM `wl_article` WHERE ( status = 1 and id 310 and cid in (17) ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001296s ][ SQL ] SELECT * FROM `wl_article` WHERE ( status = 1 and id 310 and cid = 17 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000649s ][ SQL ] SELECT * FROM `wl_article` WHERE ( status = 1 and id 310 and cid in (17) ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000676s ][ SQL ] SELECT * FROM `wl_article` WHERE ( status = 1 and id 310 and cid = 17 ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000657s ][ SQL ] SELECT COUNT(*) AS tp_count FROM `wl_article` WHERE ( status = 1 and cid in (5,14,15,16,17) ) LIMIT 1 [ RunTime:0.000850s ][ SQL ] SELECT * FROM `wl_article` WHERE ( status = 1 and cid in (5,14,15,16,17) ) ORDER BY rand() LIMIT 0,6 [ RunTime:0.004127s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000390s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000277s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 94 LIMIT 1 [ RunTime:0.000289s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 89 LIMIT 1 [ RunTime:0.000320s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 95 LIMIT 1 [ RunTime:0.000270s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 92 LIMIT 1 [ RunTime:0.000299s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000328s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 48 LIMIT 1 [ RunTime:0.000271s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 68 LIMIT 1 [ RunTime:0.000295s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 89 LIMIT 1 [ RunTime:0.000342s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 90 LIMIT 1 [ RunTime:0.000262s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 91 LIMIT 1 [ RunTime:0.000335s ][ SQL ] SELECT COUNT(*) AS tp_count FROM `wl_article` WHERE ( status = 1 and cid in (5,14,15,16,17) ) LIMIT 1 [ RunTime:0.000341s ][ SQL ] SELECT * FROM `wl_article` WHERE ( status = 1 and cid in (5,14,15,16,17) ) ORDER BY `view` DESC LIMIT 0,5 [ RunTime:0.001123s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 48 LIMIT 1 [ RunTime:0.000327s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 68 LIMIT 1 [ RunTime:0.000261s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 116 LIMIT 1 [ RunTime:0.000271s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 117 LIMIT 1 [ RunTime:0.000270s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 118 LIMIT 1 [ RunTime:0.000304s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 76 LIMIT 1 [ RunTime:0.000268s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 77 LIMIT 1 [ RunTime:0.000263s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 86 LIMIT 1 [ RunTime:0.000267s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000261s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 110 LIMIT 1 [ RunTime:0.000324s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 111 LIMIT 1 [ RunTime:0.000264s ][ SQL ] SELECT `name` FROM `wl_tags` WHERE `id` = 39 LIMIT 1 [ RunTime:0.000271s ][ SQL ] SELECT * FROM `wl_tags` WHERE ( status=1 and lang='cn' ) ORDER BY rand() LIMIT 10 [ RunTime:0.000592s ][ SQL ] SHOW COLUMNS FROM `wl_link` [ RunTime:0.001277s ][ SQL ] SELECT * FROM `wl_link` WHERE ( status=1 and lang='cn' ) ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000315s ] ---------

微信点餐小程序

------------