PHP中常用的字符串操作 辄夜花泽个人博客
User-Profile-Image
辄夜花泽
  • 5
  • 首页
  • 仓库
  • 留言
  • 专题
  • 图标
  • 分类
    • 视频
    • Laravel
    • 工具
    • PHP
    • Html
    • Ajax
    • Javascript
    • Linux
    • Mysql
    • 小程序
    • Api
    • Ecshop
    • Web
    • Jquery
    • ThinkPHP
    • Yii
    • 辄夜花泽
    • 手册
    • 源码
    • 模板
  • 友链
    • 悠悠吧
    • 小灰灰
    • 洋辣椒
    • 鹏仔博客
    • 旧博客地址
    • 华安自媒体博客
    • 电脑系统城
  • 在线工具
    • 抖音视频去水印
    • 在线JSON格式化
    • 正则表达式
Help?

Please contact us on our email for need any support

Support
    首页   ›   PHP   ›   正文
PHP

PHP中常用的字符串操作

3年前
119 0 5

一、字符串替换

str_replace("iwind", "kiki", "i love iwind, iwind said");

将输出 "i love kiki, kiki said"

str_replace(find,replace,string,count)参数 描述 

find 必需。规定要查找的值。 

replace 必需。规定替换 find 中的值的值。 

string 必需。规定被搜索的字符串。 

count 可选。一个变量,对替换数进行计数。

二、字符串删除

方法一

$string = 'fdjborsnabcdtghrjosthabcrgrjtabc';

$string = preg_replace('/[abc]+/i','',$string);

方法二

把字符串转化成数组

$arr = str_split($string);

foreach($arr as $key => $value){

   if(in_array($value,array('a','b','c'))){

       unset($arr[$key]);

   }

}

$string = implode('',$arr);

 

三、字符串截取

 //构造字符串  

 $str = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";  

 echo "原字符串:'.$str.'";  //按各种方式进行截取

 $str1 = substr($str,5);  

 echo "从第5个字符开始取至最后:'.$str1.'";  

 $str2 = substr($str,9,4);  

 echo "从第9个字符开始取4个字符:'.$str2.'";  

 $str3 = substr($str,-5);  

 echo "取倒数5个字符:'.$str3.'";  

 $str4 = substr($str,-8,4);  

 echo "从倒数第8个字符开始向后取4个字符:'.$str4.'";  

 $str5 = substr($str,-8,-2);  

 echo "从倒数第8个字符开始取到倒数第2个字符为止:'.$str5.'";

?>

支持中英文混合截取。

参数:

$str_cut    需要截断的字符串

$length     允许字符串显示的最大长度

程序功能:截取全角和半角(汉字和英文)混合的字符串以避免乱码

function substr_cut($str_cut,$length)

{    

   if(strlen($str_cut)>$length)

   {for($i=0;$i<$length;$i++)

      if(ord($str_cut[$i])>128)

          $i++;        

          $str_cut = substr($str_cut,0,$i)."..";

   }      

   return $str_cut;

}

?>

 

四、字符串比较

在PHP中,可以用==(双等号)或者 ===(三等号)来比较字符串。两者的区别是双等号不比较类型,三等号会比较类型,它不转换类型;用双等号进行比较时,如果等号左右两边有数字类型的值,刚会把另一个值转化为数字,然后进行比较。这样的话,如果是纯字符串或者NULL时,会转化为0进行比较。同样,大小于号也和等号一样,比较时可能出现不正确的结果。 

所以,比较字符串可以用PHP的自带函数strcmp和strcasecmp。其中strcasecmp是strcmp的变种,它会先把字符串转化为小写再进行比较。 如下代码: 

var_dump(0 == 'Test');

var_dump(0 == '');

var_dump(5 > 'T');

var_dump(strcmp(5, 'T'));

 

结果为(第1~3结果是不对的,只有第4个是对的): 

bool(true)

bool(true)

bool(true)

int(-1)

 

五、字符串查找

strstr()函数用于获取一个指定字符串在另一个字符串中首次出现的位置到后者末尾的子字符串,如果执行成功,则返回剩余字符串(存在相匹配的字符);如果没有找到相匹配的字符,则返回false。

语法:string strstr(string haystack,string needle)

参数:haystack:必要参数,指定从哪个字符串中进行搜索。

参数:needle:必要参数,指定搜索的对象,如果该参数是一个数值,那么将搜索与这个数值的ASCII值相匹配的字符。

实例代码如下:

   echo strstr(“明日编程词典”,”编”); //输出查询的字符串

   echo “
”;         //执行回车

   echo strstr(“www.phpfensi.com”,”111”);  //输出查询的字符串(从第一个m取值)

   echo “
”;         //执行回车

   echo strstr(“0431-84972266″,”8″);    //输出查询的字符串

?>

 

定义和用法:strpos() 函数返回字符串在另一个字符串中第一次出现的位置,如果没有找到该字符串,则返回 false。

语法:strpos(string,find,start)

参数:string 必需,规定被搜索的字符串。

参数:find 必需,规定要查找的字符。

参数:start 可选,规定开始搜索的位置。

注释:该函数对大小写敏感,如需进行对大小写不敏感的搜索,请使用 stripos() 函数。

实例代码如下:

   echo strpos("Hello world!","wo");

?>

//输出:6

 

六、字符串大小写转换

$foo = 'hello world!';

$foo = ucwords($foo);

// Hello World!

$bar = 'HELLO WORLD!';

$bar = ucwords($bar);

//HELLO WORLD!$bar = ucwords(strtolower($bar));

// Hello World!

?>

第一个词首字母变大写:ucfirst()

$foo = 'hello world!';

$foo = ucfirst($foo);

//Hello world!$bar = 'HELLO WORLD!';

$bar = ucfirst($bar);

//HELLO WORLD!

$bar = ucfirst(strtolower($bar));

//Hello world!

?>

第一个词首字母小写lcfirst()

$foo = 'HelloWorld';

$foo = lcfirst($foo);

//helloWorld

$bar = 'HELLO WORLD!';

$bar = lcfirst($bar);

//hELLO WORLD!

$bar = lcfirst(strtoupper($bar));

//hELLO WORLD!

?>

字母变大写:strtoupper()

字母变小写:strtolower()

 

七、字符串切割

   $str="1|2|3|4|5|";

   $var=explode("|",$str);

   print_r($var);

?>

把$str按|进行分割,php还有其他的把字符串指定字符分割成数组

str_split(string,length)参数 描述 

string 必需。规定要分割的字符串。 

length 可选。规定每个数组元素的长度。默认是 1。 

json_decode()这个函数也可以把字符串分割成数组 (第二个参数为true才行)




分享给朋友吧:
微信扫一扫:分享
微信里点“发现”,扫一下
二维码便可将文本分享至朋友圈

声明:

1,如果您发现本文件已经失效不能下载,请 联系站长 修正或 留言!
2,本站提供的资源多数为百度网盘下载,对于大文件,你需要安装百度云客户端才能下载!
3,部分文件引用的官方或者非网盘类他站下载链接,你可能需要使用迅雷、BT等下载工具下载!
4,本站推荐的资源均经由站长检测或者个人发布,不包含恶意软件病毒代码等,如果你发现此类问题,请向站长举报!
5,本站仅提供文件的免费下载服务,如果你对代码程序软件的使用有任何疑惑,请留言。
6,本网站在文章内容仅供于学习参考使用,请勿作为商业通途使用,版权归原作者所有。如您对内容、版权等问题存在异议请与本站联系,我们会及时进行处理解决。

如果本文对您有帮助,欢迎随意打赏作者,让作者坚持创作!

5 打赏
评论 (0)

点击这里取消回复。

欢迎您 游客  

你还可以输入200个字
发布评论
赞赏作者

请通过微信、支付宝 APP 扫一扫

感谢您对作者的支持!

 支付宝 微信支付

辄夜花泽
成功就是妥协与两难的坚持。
你的优秀不需要任何人来证明,要学会欣赏自己。
56 文章 27 评论 2424 点赞 44603 浏览
加QQ群697360424
随机文章
点缀DIV,加上边框阴影,以及背景透明
3年前
TP上传文件以及验证
3年前
Ajax入门手册,带你走过那些程序员躺过的坑
3年前
哪有那么多天才,都是千锤百炼出来的。
3年前
关于TP5中request的请求方法
4年前
一款简约的去水印工具
3年前
成功是妥协与两难的坚持。
3年前
TP5中的四表联查语句,简单易懂!
3年前
tags
视频 Laravel 工具 PHP Html Ajax Javascript Linux Mysql 小程序 Api Ecshop Web Jquery ThinkPHP Yii 辄夜花泽 手册 源码 模板
Copyright © 2021 辄夜花泽技术博客. Design of Chasel
主页
导航
  • 专题
  • 留言
博主
辄夜花泽
阿泽泽 博主
纸上得来终觉浅,绝知此事要躬行~
56 文章 27 评论 44603 浏览
博客详情
博主详情
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2022-07-02 10:05:27 HTTP/1.1 GET : blog.johnbin.cn/blog/index/info/code/542188086
  2. 运行时间 : 0.093666s [ 吞吐率:10.68req/s ] 内存消耗:4,361.23kb 文件加载:81
  3. 查询信息 : 58 queries 4 writes
  4. 缓存信息 : 3 reads,0 writes
  5. 配置加载 : 71
  6. 会话信息 : SESSION_ID=nlm622e43imnuiighkcuohms50
  1. /www/wwwroot/chasel/public/index.php ( 1.21 KB )
  2. /www/wwwroot/chasel/simplewind/thinkphp/base.php ( 2.60 KB )
  3. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Loader.php ( 21.07 KB )
  4. /www/wwwroot/chasel/simplewind/vendor/composer/autoload_static.php ( 7.29 KB )
  5. /www/wwwroot/chasel/simplewind/vendor/topthink/think-helper/src/helper.php ( 2.88 KB )
  6. /www/wwwroot/chasel/simplewind/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php ( 0.10 KB )
  7. /www/wwwroot/chasel/simplewind/vendor/qiniu/php-sdk/src/Qiniu/functions.php ( 8.20 KB )
  8. /www/wwwroot/chasel/simplewind/vendor/qiniu/php-sdk/src/Qiniu/Config.php ( 3.77 KB )
  9. /www/wwwroot/chasel/simplewind/vendor/topthink/think-captcha/src/helper.php ( 1.94 KB )
  10. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Route.php ( 60.23 KB )
  11. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Config.php ( 6.38 KB )
  12. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Validate.php ( 41.50 KB )
  13. /www/wwwroot/chasel/simplewind/vendor/topthink/think-queue/src/common.php ( 1.19 KB )
  14. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Console.php ( 23.13 KB )
  15. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Error.php ( 3.75 KB )
  16. /www/wwwroot/chasel/simplewind/thinkphp/convention.php ( 10.37 KB )
  17. /www/wwwroot/chasel/simplewind/thinkphp/library/think/App.php ( 21.54 KB )
  18. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Request.php ( 49.48 KB )
  19. /www/wwwroot/chasel/app/config.php ( 9.62 KB )
  20. /www/wwwroot/chasel/app/database.php ( 0.74 KB )
  21. /www/wwwroot/chasel/data/conf/database.php ( 0.71 KB )
  22. /www/wwwroot/chasel/app/debug.php ( 0.80 KB )
  23. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Hook.php ( 4.71 KB )
  24. /www/wwwroot/chasel/app/tags.php ( 1.33 KB )
  25. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Env.php ( 1.21 KB )
  26. /www/wwwroot/chasel/simplewind/cmf/common.php ( 99.31 KB )
  27. /www/wwwroot/chasel/simplewind/thinkphp/helper.php ( 21.75 KB )
  28. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Debug.php ( 7.13 KB )
  29. /www/wwwroot/chasel/simplewind/cmf/behavior/InitHookBehavior.php ( 1.71 KB )
  30. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Cache.php ( 6.10 KB )
  31. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Log.php ( 6.05 KB )
  32. /www/wwwroot/chasel/simplewind/thinkphp/library/think/cache/driver/File.php ( 7.27 KB )
  33. /www/wwwroot/chasel/simplewind/thinkphp/library/think/cache/Driver.php ( 5.98 KB )
  34. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Collection.php ( 10.69 KB )
  35. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Lang.php ( 7.23 KB )
  36. /www/wwwroot/chasel/simplewind/thinkphp/lang/zh-cn.php ( 11.81 KB )
  37. /www/wwwroot/chasel/app/route.php ( 0.76 KB )
  38. /www/wwwroot/chasel/data/conf/route.php ( 0.35 KB )
  39. /www/wwwroot/chasel/simplewind/cmf/behavior/LangBehavior.php ( 1.17 KB )
  40. /www/wwwroot/chasel/simplewind/cmf/lang/zh-cn.php ( 3.08 KB )
  41. /www/wwwroot/chasel/app/admin/lang/zh-cn/common.php ( 0.60 KB )
  42. /www/wwwroot/chasel/app/blog/lang/zh-cn/common.php ( 0.76 KB )
  43. /www/wwwroot/chasel/app/portal/lang/zh-cn/common.php ( 0.76 KB )
  44. /www/wwwroot/chasel/app/blog/lang/zh-cn.php ( 0.93 KB )
  45. /www/wwwroot/chasel/simplewind/cmf/behavior/InitAppHookBehavior.php ( 1.65 KB )
  46. /www/wwwroot/chasel/app/blog/controller/IndexController.php ( 12.96 KB )
  47. /www/wwwroot/chasel/simplewind/cmf/controller/HomeBaseController.php ( 8.63 KB )
  48. /www/wwwroot/chasel/simplewind/cmf/controller/BaseController.php ( 2.32 KB )
  49. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Controller.php ( 6.07 KB )
  50. /www/wwwroot/chasel/simplewind/thinkphp/library/traits/controller/Jump.php ( 4.90 KB )
  51. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Cookie.php ( 7.54 KB )
  52. /www/wwwroot/chasel/simplewind/thinkphp/library/think/View.php ( 6.77 KB )
  53. /www/wwwroot/chasel/simplewind/thinkphp/library/think/view/driver/Think.php ( 5.64 KB )
  54. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Template.php ( 44.90 KB )
  55. /www/wwwroot/chasel/simplewind/thinkphp/library/think/template/driver/File.php ( 2.24 KB )
  56. /www/wwwroot/chasel/app/admin/model/ArticleModel.php ( 9.74 KB )
  57. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Model.php ( 69.95 KB )
  58. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Db.php ( 6.67 KB )
  59. /www/wwwroot/chasel/simplewind/thinkphp/library/think/db/connector/Mysql.php ( 3.89 KB )
  60. /www/wwwroot/chasel/simplewind/thinkphp/library/think/db/Connection.php ( 29.97 KB )
  61. /www/wwwroot/chasel/simplewind/thinkphp/library/think/db/Query.php ( 93.74 KB )
  62. /www/wwwroot/chasel/simplewind/thinkphp/library/think/db/builder/Mysql.php ( 4.53 KB )
  63. /www/wwwroot/chasel/simplewind/thinkphp/library/think/db/Builder.php ( 31.55 KB )
  64. /www/wwwroot/chasel/app/admin/model/ArticleClassModel.php ( 3.24 KB )
  65. /www/wwwroot/chasel/app/admin/model/MessageModel.php ( 5.71 KB )
  66. /www/wwwroot/chasel/app/admin/model/LinkModel.php ( 1.42 KB )
  67. /www/wwwroot/chasel/app/admin/model/AdModel.php ( 1.89 KB )
  68. /www/wwwroot/chasel/simplewind/thinkphp/library/think/db/Expression.php ( 1.11 KB )
  69. /www/wwwroot/chasel/simplewind/thinkphp/library/think/model/Collection.php ( 2.27 KB )
  70. /www/wwwroot/chasel/simplewind/cmf/paginator/Bootstrap.php ( 7.63 KB )
  71. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Paginator.php ( 9.75 KB )
  72. /www/wwwroot/chasel/app/admin/model/AccessLogModel.php ( 3.09 KB )
  73. /www/wwwroot/chasel/app/admin/model/AccessModel.php ( 1.28 KB )
  74. /www/wwwroot/chasel/app/admin/model/ThemeModel.php ( 7.94 KB )
  75. /www/wwwroot/chasel/simplewind/cmf/lib/taglib/Cmf.php ( 11.49 KB )
  76. /www/wwwroot/chasel/simplewind/thinkphp/library/think/template/TagLib.php ( 12.30 KB )
  77. /www/wwwroot/chasel/simplewind/thinkphp/library/think/template/taglib/Cx.php ( 23.82 KB )
  78. /www/wwwroot/chasel/data/runtime/temp/ba3782aff2ddd4b3eca7e4de6567ed72.php ( 75.24 KB )
  79. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Session.php ( 10.86 KB )
  80. /www/wwwroot/chasel/simplewind/thinkphp/library/think/Response.php ( 8.28 KB )
  81. /www/wwwroot/chasel/simplewind/thinkphp/library/think/debug/Html.php ( 4.17 KB )
  1. [ CACHE ] INIT File
  2. [ BEHAVIOR ] Run cmf\behavior\InitHookBehavior @app_init [ RunTime:0.001248s ]
  3. [ LANG ] /www/wwwroot/chasel/simplewind/thinkphp/lang/zh-cn.php
  4. [ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'blog', 1 => 'index', 2 => 'info', ), )
  5. [ HEADER ] array ( 'connection' => 'Keep-Alive', 'host' => 'blog.johnbin.cn', 'accept-encoding' => 'br,gzip', 'if-modified-since' => 'Wed, 01 Dec 2021 12:44:28 GMT', 'accept-language' => 'en-US,en;q=0.5', 'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', 'user-agent' => 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'content-type' => '', 'content-length' => '', )
  6. [ PARAM ] array ( 'code' => '542188086', )
  7. [ LANG ] /www/wwwroot/chasel/public/../simplewind/cmf/lang/zh-cn.php
  8. [ LANG ] /www/wwwroot/chasel/public/../app/admin/lang/zh-cn/common.php
  9. [ LANG ] /www/wwwroot/chasel/public/../app/blog/lang/zh-cn/common.php
  10. [ LANG ] /www/wwwroot/chasel/public/../app/portal/lang/zh-cn/common.php
  11. [ BEHAVIOR ] Run cmf\behavior\LangBehavior @app_begin [ RunTime:0.000330s ]
  12. [ LANG ] /www/wwwroot/chasel/public/../app/blog/lang/zh-cn.php
  13. [ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.000116s ]
  14. [ DB ] INIT mysql
  15. [ RUN ] app\blog\controller\IndexController->info[ /www/wwwroot/chasel/app/blog/controller/IndexController.php ]
  16. [ VIEW ] themes/simpleboot3/blog/info.html [ array ( 0 => 'sysSetting', 1 => 'music_settings', 2 => 'style', 3 => 'article_top', 4 => 'bloginfo', 5 => 'randarticle', 6 => 'link', 7 => 'class', 8 => 'route', 9 => 'config', 10 => 'adlist', 11 => 'page', 12 => 'msglist', 13 => 'avatarlist', 14 => 'data', 15 => 'theme_vars', 16 => 'theme_widgets', ) ]
  17. [ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, )
  1. [ DB ] CONNECT:[ UseTime:0.000363s ] mysql:host=127.0.0.1;port=3306;dbname=chasel;charset=utf8mb4
  2. [ SQL ] SHOW COLUMNS FROM `az_config` [ RunTime:0.000805s ]
  3. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000313s ]
  4. [ SQL ] SHOW COLUMNS FROM `az_option` [ RunTime:0.000575s ]
  5. [ SQL ] SELECT `option_value` FROM `az_option` WHERE `option_name` = 'site_info' LIMIT 1 [ RunTime:0.000237s ]
  6. [ SQL ] SHOW COLUMNS FROM `az_article` [ RunTime:0.000741s ]
  7. [ SQL ] SELECT COUNT(*) AS tp_count FROM `az_article` LIMIT 1 [ RunTime:0.000225s ]
  8. [ SQL ] SHOW COLUMNS FROM `az_message` [ RunTime:0.000643s ]
  9. [ SQL ] SELECT COUNT(*) AS tp_count FROM `az_message` WHERE `code` > 0 LIMIT 1 [ RunTime:0.000276s ]
  10. [ SQL ] SELECT SUM(read_num) AS tp_sum FROM `az_article` LIMIT 1 [ RunTime:0.000199s ]
  11. [ SQL ] SELECT `code`,`author`,`title`,`describe`,`original_img`,`class_id`,`add_time` FROM `az_article` WHERE `is_file` = 0 AND `status` = 1 ORDER BY rand() LIMIT 1 [ RunTime:0.000573s ]
  12. [ SQL ] SELECT `code`,`author`,`title`,`describe`,`original_img`,`class_id`,`add_time` FROM `az_article` WHERE `status` = 1 ORDER BY rand() LIMIT 7 [ RunTime:0.000608s ]
  13. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000195s ]
  14. [ SQL ] SHOW COLUMNS FROM `az_article_class` [ RunTime:0.000586s ]
  15. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 10 LIMIT 1 [ RunTime:0.000225s ]
  16. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 10 LIMIT 1 [ RunTime:0.000158s ]
  17. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000211s ]
  18. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 1 LIMIT 1 [ RunTime:0.000195s ]
  19. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 1 LIMIT 1 [ RunTime:0.000167s ]
  20. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000176s ]
  21. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 16 LIMIT 1 [ RunTime:0.000186s ]
  22. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 16 LIMIT 1 [ RunTime:0.000157s ]
  23. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000222s ]
  24. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 15 LIMIT 1 [ RunTime:0.000190s ]
  25. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 15 LIMIT 1 [ RunTime:0.000148s ]
  26. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000185s ]
  27. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 12 LIMIT 1 [ RunTime:0.000163s ]
  28. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 12 LIMIT 1 [ RunTime:0.000157s ]
  29. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000165s ]
  30. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 17 LIMIT 1 [ RunTime:0.000174s ]
  31. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 17 LIMIT 1 [ RunTime:0.000153s ]
  32. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000173s ]
  33. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 15 LIMIT 1 [ RunTime:0.000159s ]
  34. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 15 LIMIT 1 [ RunTime:0.000170s ]
  35. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000189s ]
  36. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 12 LIMIT 1 [ RunTime:0.000156s ]
  37. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 12 LIMIT 1 [ RunTime:0.000165s ]
  38. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000215s ]
  39. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000185s ]
  40. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'click_num' LIMIT 1 [ RunTime:0.000208s ]
  41. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'click_code' LIMIT 1 [ RunTime:0.000181s ]
  42. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'blog_read' LIMIT 1 [ RunTime:0.000194s ]
  43. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'blog_message' LIMIT 1 [ RunTime:0.000188s ]
  44. [ SQL ] SELECT COUNT(*) AS tp_count FROM `az_message` WHERE `code` = 542188086 AND `status` = 1 LIMIT 1 [ RunTime:0.000243s ]
  45. [ SQL ] SELECT * FROM `az_message` WHERE `code` = 542188086 AND `status` = 1 ORDER BY `m_id` DESC LIMIT 0,7 [ RunTime:0.000285s ]
  46. [ SQL ] SELECT `image` FROM `az_message` WHERE `status` = 1 AND `code` = 542188086 GROUP BY `image` ORDER BY `m_id` DESC [ RunTime:0.000285s ]
  47. [ SQL ] SELECT * FROM `az_article` WHERE `code` = 542188086 [ RunTime:0.000929s ]
  48. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000215s ]
  49. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 1 LIMIT 1 [ RunTime:0.000202s ]
  50. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 1 LIMIT 1 [ RunTime:0.000150s ]
  51. [ SQL ] SELECT * FROM `az_article` WHERE `code` = 542188086 LIMIT 1 [ RunTime:0.000308s ]
  52. [ SQL ] UPDATE `az_article` SET `read_num`=120 WHERE `code` = 542188086 [ RunTime:0.002298s ]
  53. [ SQL ] SHOW COLUMNS FROM `az_access` [ RunTime:0.000636s ]
  54. [ SQL ] SELECT * FROM `az_access` WHERE `ip` = '3.238.125.76' LIMIT 1 [ RunTime:0.003515s ]
  55. [ SQL ] UPDATE `az_access` SET `visit_num`='23',`update_time`=1656727527 WHERE `ip` = '3.238.125.76' [ RunTime:0.004631s ]
  56. [ SQL ] SHOW COLUMNS FROM `az_access_log` [ RunTime:0.000601s ]
  57. [ SQL ] SELECT * FROM `az_access_log` WHERE `ip` = '3.238.125.76' LIMIT 1 [ RunTime:0.014287s ]
  58. [ SQL ] INSERT INTO `az_access_log` (`ip` , `address` , `countrys` , `isp` , `status` , `province` , `city` , `country` , `add_time`) VALUES ('3.238.125.76' , '弗吉尼亚,阿什本' , '美国' , '亚马逊' , 1 , '弗吉尼亚' , '阿什本' , '美国' , 1656727527) [ RunTime:0.001752s ]
  59. [ SQL ] SHOW COLUMNS FROM `az_theme_file` [ RunTime:0.000708s ]
  60. [ SQL ] SELECT * FROM `az_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000228s ]
  61. [ SQL ] SHOW COLUMNS FROM `az_theme` [ RunTime:0.000605s ]
  62. [ SQL ] UPDATE `az_theme` SET `name`='simpleboot3',`version`='1.0.2',`demo_url`='http://demo.thinkcmf.com',`author`='ThinkCMF',`lang`='zh-cn',`author_url`='http://www.thinkcmf.com',`keywords`='ThinkCMF模板',`description`='ThinkCMF默认模板' WHERE `theme` = 'simpleboot3' [ RunTime:0.001704s ]
  63. [ SQL ] SELECT `more` FROM `az_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'blog/info' ) [ RunTime:0.000218s ]
0.094280s