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中常用的字符串操作

7年前

一、字符串替换

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才行)


赞赏作者

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

感谢您对作者的支持!

 支付宝 微信支付

辄夜花泽
成功就是妥协与两难的坚持。
你的优秀不需要任何人来证明,要学会欣赏自己。
56 文章 97024 浏览
随机文章
Ajax的正确使用方式
7年前
Thinkphp 5.0中一些常用的语法
7年前
Laravel 5.1 中文文档
7年前
Ajax入门手册,带你走过那些程序员躺过的坑
7年前
TP5中的四表联查语句,简单易懂!
7年前
Ajax的正确使用方式
7年前
特殊漂亮很难找的字体.rar
7年前
bootstrap3.0.3手册
7年前
tags
Laravel 工具 PHP Html Ajax Javascript Linux Mysql 小程序 Api Ecshop Web Jquery ThinkPHP Yii 辄夜花泽 手册 源码 模板
Copyright © 2021 辄夜花泽技术博客. Design of Chasel      粤ICP备18125949号-1
主页
导航
  • 专题
  • 留言
博主
辄夜花泽
阿泽泽 博主
纸上得来终觉浅,绝知此事要躬行~
56 文章 28 评论 97024 浏览
博客详情
博主详情
基本 文件 流程 错误 SQL 调试
  1. 请求信息 : 2026-05-30 01:22:17 HTTP/1.1 GET : blog.johnbin.cn/blog/index/info/code/542188086
  2. 运行时间 : 0.154910s [ 吞吐率:6.46req/s ] 内存消耗:4,380.34kb 文件加载:81
  3. 查询信息 : 105 queries 4 writes
  4. 缓存信息 : 3 reads,2 writes
  5. 配置加载 : 71
  6. 会话信息 : SESSION_ID=qq1085br04upp32u0gvugpmqi4
  1. /www/wwwroot/chasel/public/index.php ( 1.25 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.81 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 ( 98.52 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 ( 14.89 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.28 KB )
  65. /www/wwwroot/chasel/app/admin/model/MessageModel.php ( 5.71 KB )
  66. /www/wwwroot/chasel/app/admin/model/LinkModel.php ( 1.44 KB )
  67. /www/wwwroot/chasel/app/admin/model/AdModel.php ( 1.89 KB )
  68. /www/wwwroot/chasel/simplewind/thinkphp/library/think/model/Collection.php ( 2.27 KB )
  69. /www/wwwroot/chasel/simplewind/thinkphp/library/think/db/Expression.php ( 1.11 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.18 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 ( 77.99 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.000931s ]
  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', 'cache-control' => 'max-age=259200', 'x-forwarded-for' => '10.8.204.48', 'via' => '1.1 squid-proxy-5b96dc6d46-fdfwx (squid/6.13)', 'accept-encoding' => 'gzip, br, zstd, deflate', 'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'accept' => '*/*', 'host' => 'blog.johnbin.cn', '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.000204s ]
  12. [ LANG ] /www/wwwroot/chasel/public/../app/blog/lang/zh-cn.php
  13. [ BEHAVIOR ] Run cmf\behavior\InitAppHookBehavior @module_init [ RunTime:0.000086s ]
  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.000439s ] mysql:host=127.0.0.1;port=8588;dbname=chasel;charset=utf8mb4
  2. [ SQL ] SHOW COLUMNS FROM `az_config` [ RunTime:0.000508s ]
  3. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.002540s ]
  4. [ SQL ] SHOW COLUMNS FROM `az_option` [ RunTime:0.000457s ]
  5. [ SQL ] SELECT `option_value` FROM `az_option` WHERE `option_name` = 'site_info' LIMIT 1 [ RunTime:0.000218s ]
  6. [ SQL ] SHOW COLUMNS FROM `az_article` [ RunTime:0.000657s ]
  7. [ SQL ] SELECT `code`,`author`,`title`,`describe`,`original_img`,`class_id`,`add_time` FROM `az_article` WHERE `is_top` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000325s ]
  8. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000220s ]
  9. [ SQL ] SHOW COLUMNS FROM `az_article_class` [ RunTime:0.000432s ]
  10. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 6 LIMIT 1 [ RunTime:0.000219s ]
  11. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 6 LIMIT 1 [ RunTime:0.000192s ]
  12. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000193s ]
  13. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 5 LIMIT 1 [ RunTime:0.000197s ]
  14. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 5 LIMIT 1 [ RunTime:0.000187s ]
  15. [ SQL ] SELECT COUNT(*) AS tp_count FROM `az_article` LIMIT 1 [ RunTime:0.000190s ]
  16. [ SQL ] SHOW COLUMNS FROM `az_message` [ RunTime:0.000485s ]
  17. [ SQL ] SELECT COUNT(*) AS tp_count FROM `az_message` WHERE `code` > 0 LIMIT 1 [ RunTime:0.000233s ]
  18. [ SQL ] SELECT SUM(read_num) AS tp_sum FROM `az_article` LIMIT 1 [ RunTime:0.000224s ]
  19. [ 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.000412s ]
  20. [ 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.000457s ]
  21. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000212s ]
  22. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 3 LIMIT 1 [ RunTime:0.000179s ]
  23. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 3 LIMIT 1 [ RunTime:0.000179s ]
  24. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000218s ]
  25. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 12 LIMIT 1 [ RunTime:0.000194s ]
  26. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 12 LIMIT 1 [ RunTime:0.000183s ]
  27. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000204s ]
  28. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 16 LIMIT 1 [ RunTime:0.000262s ]
  29. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 16 LIMIT 1 [ RunTime:0.000184s ]
  30. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000195s ]
  31. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 16 LIMIT 1 [ RunTime:0.000189s ]
  32. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 16 LIMIT 1 [ RunTime:0.000284s ]
  33. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000195s ]
  34. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 12 LIMIT 1 [ RunTime:0.000184s ]
  35. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 12 LIMIT 1 [ RunTime:0.000191s ]
  36. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000187s ]
  37. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 3 LIMIT 1 [ RunTime:0.000174s ]
  38. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 3 LIMIT 1 [ RunTime:0.000171s ]
  39. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000213s ]
  40. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 17 LIMIT 1 [ RunTime:0.000190s ]
  41. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 17 LIMIT 1 [ RunTime:0.000181s ]
  42. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000200s ]
  43. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 16 LIMIT 1 [ RunTime:0.000256s ]
  44. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 16 LIMIT 1 [ RunTime:0.000206s ]
  45. [ SQL ] SHOW COLUMNS FROM `az_link` [ RunTime:0.000430s ]
  46. [ SQL ] SELECT * FROM `az_link` WHERE `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000251s ]
  47. [ SQL ] SELECT * FROM `az_article_class` WHERE `status` = 1 ORDER BY `list_order` ASC,`class_id` ASC [ RunTime:0.000302s ]
  48. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000225s ]
  49. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000189s ]
  50. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000213s ]
  51. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000198s ]
  52. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000191s ]
  53. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000201s ]
  54. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000250s ]
  55. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000191s ]
  56. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000187s ]
  57. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000220s ]
  58. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000198s ]
  59. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000189s ]
  60. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000195s ]
  61. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000217s ]
  62. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000202s ]
  63. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000187s ]
  64. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000198s ]
  65. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000202s ]
  66. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000202s ]
  67. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000188s ]
  68. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000203s ]
  69. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000198s ]
  70. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000187s ]
  71. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000185s ]
  72. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000206s ]
  73. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000197s ]
  74. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000190s ]
  75. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000195s ]
  76. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000216s ]
  77. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000219s ]
  78. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000197s ]
  79. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000193s ]
  80. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000194s ]
  81. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000182s ]
  82. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000203s ]
  83. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000219s ]
  84. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000223s ]
  85. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000268s ]
  86. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000269s ]
  87. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000224s ]
  88. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'click_num' LIMIT 1 [ RunTime:0.000242s ]
  89. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'click_code' LIMIT 1 [ RunTime:0.000229s ]
  90. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'blog_read' LIMIT 1 [ RunTime:0.000203s ]
  91. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'blog_message' LIMIT 1 [ RunTime:0.000204s ]
  92. [ SQL ] SELECT COUNT(*) AS tp_count FROM `az_message` WHERE `code` = 542188086 AND `status` = 1 LIMIT 1 [ RunTime:0.000226s ]
  93. [ SQL ] SELECT * FROM `az_message` WHERE `code` = 542188086 AND `status` = 1 ORDER BY `m_id` DESC LIMIT 0,7 [ RunTime:0.000253s ]
  94. [ SQL ] SELECT `image` FROM `az_message` WHERE `status` = 1 AND `code` = 542188086 GROUP BY `image` ORDER BY `m_id` DESC [ RunTime:0.000251s ]
  95. [ SQL ] SELECT * FROM `az_article` WHERE `code` = 542188086 [ RunTime:0.000343s ]
  96. [ SQL ] SELECT `value` FROM `az_config` WHERE `inc_type` = 'blog' AND `name` = 'realm_name' LIMIT 1 [ RunTime:0.000208s ]
  97. [ SQL ] SELECT `class_name` FROM `az_article_class` WHERE `class_id` = 1 LIMIT 1 [ RunTime:0.000191s ]
  98. [ SQL ] SELECT `code` FROM `az_article_class` WHERE `class_id` = 1 LIMIT 1 [ RunTime:0.000191s ]
  99. [ SQL ] SELECT * FROM `az_article` WHERE `code` = 542188086 LIMIT 1 [ RunTime:0.000264s ]
  100. [ SQL ] UPDATE `az_article` SET `read_num`=4733 WHERE `code` = 542188086 [ RunTime:0.007386s ]
  101. [ SQL ] SHOW COLUMNS FROM `az_access` [ RunTime:0.000384s ]
  102. [ SQL ] SELECT * FROM `az_access` WHERE `ip` = '10.8.204.48' LIMIT 1 [ RunTime:0.005910s ]
  103. [ SQL ] INSERT INTO `az_access` (`ip` , `address` , `countrys` , `country` , `province` , `city` , `isp` , `add_time` , `update_time` , `visit_num`) VALUES ('' , '未知地区' , '中国' , '中国' , '' , '' , '' , 1780075337 , 1780075337 , '1') [ RunTime:0.006584s ]
  104. [ SQL ] SHOW COLUMNS FROM `az_access_log` [ RunTime:0.000535s ]
  105. [ SQL ] INSERT INTO `az_access_log` (`address` , `province` , `city` , `isp` , `ip` , `countrys` , `country` , `status` , `add_time`) VALUES ('未知地区' , '' , '' , '' , '' , '中国' , '中国' , 1 , 1780075337) [ RunTime:0.005680s ]
  106. [ SQL ] SHOW COLUMNS FROM `az_theme_file` [ RunTime:0.000397s ]
  107. [ SQL ] SELECT * FROM `az_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000231s ]
  108. [ SQL ] SHOW COLUMNS FROM `az_theme` [ RunTime:0.000380s ]
  109. [ 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.005008s ]
  110. [ SQL ] SELECT `more` FROM `az_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'blog/info' ) [ RunTime:0.000257s ]
0.155429s