您的当前位置:
首页>全部文章
>搜索词 官网 关联的文章
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-01-23 01:02:49 HTTP/1.1 GET : https://weixinshop.cn/home/article/search?k=%E5%AE%98%E7%BD%91
- 运行时间 : 0.166256s [ 吞吐率:6.01req/s ] 内存消耗:825.01kb 文件加载:287
- 查询信息 : 0 queries
- 缓存信息 : 17 reads,0 writes
- 会话信息 : SESSION_ID=35acf7d9bfc72dbe100ff9e35ec3de2c
- CONNECT:[ UseTime:0.000850s ] mysql:host=127.0.0.1;port=3306;dbname=anjinshop_com;charset=utf8mb4
- SHOW FULL COLUMNS FROM `blog_nav` [ RunTime:0.003381s ]
- SELECT `id` FROM `blog_nav` WHERE `name` = 'NAV_WEBSITE' AND `status` = 1 LIMIT 1 [ RunTime:0.000327s ]
- SHOW FULL COLUMNS FROM `blog_article` [ RunTime:0.002775s ]
- SHOW FULL COLUMNS FROM `blog_search_keywords` [ RunTime:0.001749s ]
- SELECT * FROM `blog_search_keywords` WHERE `title` = '官网' LIMIT 1 [ RunTime:0.000497s ]
- UPDATE `blog_search_keywords` SET `times` = `times` + 1 WHERE `id` = 20 [ RunTime:0.002821s ]
- SELECT COUNT(*) AS think_count FROM `blog_article` `a` LEFT JOIN `blog_file` `f` ON `a`.`thumb`=`f`.`id` WHERE `a`.`status` = '1' AND ( `a`.`title` LIKE '%官网%' OR `a`.`desc` LIKE '%官网%' OR `a`.`content` LIKE '%官网%' ) LIMIT 1 [ RunTime:0.014560s ]
- SELECT `a`.`id`,`a`.`title`,`a`.`thumb`,`a`.`create_time`,`a`.`read`,`a`.`desc`,`f`.`filepath` FROM `blog_article` `a` LEFT JOIN `blog_file` `f` ON `a`.`thumb`=`f`.`id` WHERE `a`.`status` = '1' AND ( `a`.`title` LIKE '%官网%' OR `a`.`desc` LIKE '%官网%' OR `a`.`content` LIKE '%官网%' ) ORDER BY `a`.`id` DESC LIMIT 0,10 [ RunTime:0.012505s ]
- SHOW FULL COLUMNS FROM `blog_article_keywords` [ RunTime:0.003020s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '615' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000315s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '609' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000237s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '598' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.001898s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '595' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000199s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '583' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000211s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '514' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000162s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '491' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000223s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '464' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000226s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '316' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000189s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '281' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000216s ]
- SHOW FULL COLUMNS FROM `blog_article_cate` [ RunTime:0.003065s ]
- SELECT * FROM `blog_article_cate` ORDER BY `sort` DESC [ RunTime:0.000293s ]
- SELECT COUNT(*) AS think_count FROM `blog_article` WHERE `article_cate_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000264s ]
- SELECT COUNT(*) AS think_count FROM `blog_article` WHERE `article_cate_id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.000226s ]
- SELECT COUNT(*) AS think_count FROM `blog_article` WHERE `article_cate_id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.000284s ]
- SELECT COUNT(*) AS think_count FROM `blog_article` WHERE `article_cate_id` = 4 AND `status` = 1 LIMIT 1 [ RunTime:0.000280s ]
- SELECT COUNT(*) AS think_count FROM `blog_article` WHERE `article_cate_id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.000633s ]
- SELECT COUNT(*) AS think_count FROM `blog_article` WHERE `article_cate_id` = 6 AND `status` = 1 LIMIT 1 [ RunTime:0.000273s ]
- SELECT COUNT(*) AS think_count FROM `blog_article` WHERE `article_cate_id` = 7 AND `status` = 1 LIMIT 1 [ RunTime:0.000232s ]
- SELECT COUNT(*) AS think_count FROM `blog_article` WHERE `article_cate_id` = 8 AND `status` = 1 LIMIT 1 [ RunTime:0.000273s ]
- SELECT COUNT(*) AS think_count FROM `blog_article` WHERE `article_cate_id` = 9 AND `status` = 1 LIMIT 1 [ RunTime:0.000286s ]
- SELECT COUNT(*) AS think_count FROM `blog_article` WHERE `article_cate_id` = 10 AND `status` = 1 LIMIT 1 [ RunTime:0.000227s ]
- SHOW FULL COLUMNS FROM `blog_keywords` [ RunTime:0.002543s ]
- SELECT * FROM `blog_keywords` WHERE `status` = 1 ORDER BY rand() , id desc LIMIT 20 [ RunTime:0.000472s ]
- SELECT `a`.`id`,`a`.`title`,`a`.`thumb`,`a`.`create_time`,`a`.`read`,`a`.`desc`,`f`.`filepath` FROM `blog_article` `a` LEFT JOIN `blog_file` `f` ON `a`.`thumb`=`f`.`id` WHERE `a`.`status` = '1' ORDER BY rand() , a.id desc LIMIT 10 [ RunTime:0.006202s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '727' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000451s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '647' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000315s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '368' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000284s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '609' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000275s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '157' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000297s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '449' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000316s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '174' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000270s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '917' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000306s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '85' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000282s ]
- SELECT `k`.`id`,`k`.`title` FROM `blog_article_keywords` `a` LEFT JOIN `blog_keywords` `k` ON `k`.`id`=`a`.`keywords_id` WHERE `a`.`aid` = '528' AND `k`.`status` = '1' LIMIT 4 [ RunTime:0.000281s ]
- SHOW FULL COLUMNS FROM `blog_user_log` [ RunTime:0.002728s ]
- INSERT INTO `blog_user_log` SET `uid` = 0 , `nickname` = '游客' , `type` = 'search' , `title` = '搜索' , `content` = '游客在2025-01-23 01:02:49搜索了官网关联的文章关联的文章' , `param_id` = 0 , `param` = '[]' , `module` = 'home' , `controller` = 'article' , `function` = 'search' , `ip` = '3.147.63.222' , `create_time` = 1737565369 [ RunTime:0.003604s ]
0.177106s