-
公众号
-
在线咨询
-
服务热线:
0
2
8
-
8
5
5
2
3
2
3
8
线上互动活动策划管理
发布时间: 2023-07-27 发布者:
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-11-17 17:16:00 HTTP/1.1 GET : https://www.trycheers.com/new_media/2362.html
- 运行时间 : 0.317028s [ 吞吐率:3.15req/s ] 内存消耗:13,486.63kb 文件加载:241
- 查询信息 : 66 queries
- 缓存信息 : 0 reads,3 writes
- 会话信息 : SESSION_ID=e8b31eac0289c8f59bd940ab506e2dfc
- CONNECT:[ UseTime:0.005833s ] mysql:host=rm-2vcls9850j000ausyeo.mysql.cn-chengdu.rds.aliyuncs.com;port=3306;dbname=try-2025db;charset=utf8
- SHOW FULL COLUMNS FROM `try_website` [ RunTime:0.004588s ]
- SELECT `web_id`,`web_parent`,`web_domain`,`web_status` FROM `try_website` WHERE `web_domain` = 'www.trycheers.com' LIMIT 1 [ RunTime:0.003582s ]
- SHOW FULL COLUMNS FROM `try_website_theme` [ RunTime:0.004244s ]
- SELECT * FROM `try_website_theme` WHERE `web_id` = 20 AND `theme_lang` = 'zh' AND `theme_active` = 1 LIMIT 1 [ RunTime:0.003696s ]
- SHOW FULL COLUMNS FROM `try_website_setting` [ RunTime:0.004194s ]
- SELECT * FROM `try_website_setting` WHERE `web_id` = 20 AND `ws_lang` = 'zh' LIMIT 1 [ RunTime:0.003579s ]
- SHOW FULL COLUMNS FROM `try_sys_setting` [ RunTime:0.004127s ]
- SELECT * FROM `try_sys_setting` WHERE `sys_status` = 1 ORDER BY `sys_id` DESC [ RunTime:0.003798s ]
- SHOW FULL COLUMNS FROM `try_nav` [ RunTime:0.004384s ]
- SELECT `a`.`nav_id`,`a`.`nav_parent`,`a`.`nav_title`,`a`.`nav_href`,`a`.`nav_type`,`a`.`cat_id`,`a`.`nav_target`,`a`.`seo_title`,`a`.`seo_keyword`,`a`.`seo_descrition` FROM `try_nav` `a` WHERE `a`.`nav_status` = '1' AND ( a.nav_id in (50,1,6) or a.nav_parent in (50,1,6) ) ORDER BY `a`.`nav_sort` ASC,`a`.`nav_id` ASC [ RunTime:0.003673s ]
- SHOW FULL COLUMNS FROM `try_category` [ RunTime:0.004497s ]
- SELECT * FROM `try_category` WHERE `cat_id` = 79 AND `web_id` = 20 AND `cat_lang` = 'zh' LIMIT 1 [ RunTime:0.003667s ]
- SHOW FULL COLUMNS FROM `try_custom_module` [ RunTime:0.004185s ]
- SELECT * FROM `try_custom_module` WHERE `module_id` = 18 [ RunTime:0.003590s ]
- SHOW FULL COLUMNS FROM `try_custom_module_field` [ RunTime:0.004288s ]
- SELECT * FROM `try_custom_module_field` WHERE `module_id` = 18 [ RunTime:0.003693s ]
- SELECT * FROM `try_nav` WHERE `real_cat_id` = 79 LIMIT 1 [ RunTime:0.003633s ]
- SELECT `cat_id`,`cat_parent`,`cat_parent_map`,`cat_parent_path`,`cat_has_map`,`web_id`,`module_id`,`cat_lang`,`cat_type`,`cat_title`,`cat_sub_title`,`cat_content`,`cat_path`,`cat_desc`,`cat_description`,`cat_sort`,`cat_alias`,`cat_freq_alias`,`cat_address`,`banner_info`,`cat_thumb`,`cat_list_tpl`,`cat_detail_tpl`,`cat_status`,`cat_search`,`cat_check`,`seo_title`,`seo_keywords`,`seo_description` FROM `try_category` WHERE `cat_id` = 78 LIMIT 1 [ RunTime:0.003619s ]
- SELECT * FROM `try_nav` WHERE `real_cat_id` = 78 LIMIT 1 [ RunTime:0.003714s ]
- SHOW FULL COLUMNS FROM `try_slide_cate` [ RunTime:0.004192s ]
- SELECT `sc_id` FROM `try_slide_cate` WHERE `sc_alias` = 'other_article' AND `web_id` = 20 LIMIT 1 [ RunTime:0.003555s ]
- SELECT `a`.`cat_id`,`a`.`cat_parent`,`a`.`cat_type`,`a`.`cat_title`,`a`.`cat_address`,`b`.`nav_href` FROM `try_category` `a` LEFT JOIN `try_nav` `b` ON `a`.`cat_id`=b.real_cat_id and a.web_id=b.web_id WHERE `a`.`cat_parent` = '78' AND `a`.`cat_status` = '1' AND `a`.`web_id` = '20' GROUP BY `a`.`cat_id` ORDER BY `a`.`cat_sort` ASC,`a`.`cat_id` ASC [ RunTime:0.003916s ]
- SELECT * FROM `try_custom_module` WHERE `module_table` = 'article' LIMIT 1 [ RunTime:0.003581s ]
- SHOW FULL COLUMNS FROM `try_sub_content` [ RunTime:0.004406s ]
- SELECT `ext`.*,`s`.* FROM `try_sub_content` `s` LEFT JOIN `cc_article` `ext` ON `s`.`sub_id`=`ext`.`sub_id` WHERE `s`.`sub_id` = '2362' AND `s`.`sub_publish_time` < '2025-11-17 17:16:00' AND `s`.`sub_status` = '1' LIMIT 1 [ RunTime:0.003820s ]
- SELECT sub_id,sub_title,sub_publish_time FROM `try_sub_content` WHERE `sub_id` < 2362 AND `sub_publish_time` < '2025-11-17 17:16:00' AND `sub_status` = 1 AND `delete_time` = 0 AND `cat_id` = 79 ORDER BY `sub_id` DESC LIMIT 1 [ RunTime:0.004001s ]
- SELECT sub_id,sub_title,sub_publish_time FROM `try_sub_content` WHERE `sub_id` > 2362 AND `sub_publish_time` < '2025-11-17 17:16:00' AND `sub_status` = 1 AND `delete_time` = 0 AND `cat_id` = 79 ORDER BY `sub_id` ASC LIMIT 1 [ RunTime:0.003635s ]
- UPDATE `try_sub_content` SET `sub_hits` = 3222 WHERE `sub_id` = 2362 [ RunTime:0.003614s ]
- SHOW FULL COLUMNS FROM `try_tag_sub_content` [ RunTime:0.004125s ]
- SELECT * FROM `try_tag_sub_content` `a` LEFT JOIN `try_tag` `b` ON `a`.`tag_id`=`b`.`tag_id` WHERE `a`.`sub_id` = '2362' [ RunTime:0.005388s ]
- SELECT * FROM `try_website_setting` WHERE `web_id` = 20 LIMIT 1 [ RunTime:0.003536s ]
- SELECT `a`.*,`b`.`cat_title`,`b`.`cat_alias` FROM `try_sub_content` `a` LEFT JOIN `try_category` `b` ON `a`.`cat_id`=`b`.`cat_id` WHERE `a`.`cat_id` = '79' AND `a`.`sub_status` = '1' AND `a`.`sub_id` <> '2362' ORDER BY RAND() LIMIT 0,20 [ RunTime:0.003967s ]
- SELECT * FROM `try_tag_sub_content` `a` LEFT JOIN `try_tag` `b` ON `a`.`tag_id`=`b`.`tag_id` WHERE `a`.`sub_id` = '2372' [ RunTime:0.005721s ]
- SELECT * FROM `try_tag_sub_content` `a` LEFT JOIN `try_tag` `b` ON `a`.`tag_id`=`b`.`tag_id` WHERE `a`.`sub_id` = '2363' [ RunTime:0.005177s ]
- SELECT * FROM `try_tag_sub_content` `a` LEFT JOIN `try_tag` `b` ON `a`.`tag_id`=`b`.`tag_id` WHERE `a`.`sub_id` = '2371' [ RunTime:0.005135s ]
- SELECT * FROM `try_tag_sub_content` `a` LEFT JOIN `try_tag` `b` ON `a`.`tag_id`=`b`.`tag_id` WHERE `a`.`sub_id` = '2370' [ RunTime:0.005163s ]
- SELECT `a`.*,`b`.`nav_href` FROM `try_category` `a` LEFT JOIN `try_nav` `b` ON `a`.`cat_id`=`b`.`real_cat_id` WHERE `a`.`cat_id` = '78' AND `a`.`cat_status` = '1' AND `a`.`web_id` = '20' LIMIT 1 [ RunTime:0.003660s ]
- SELECT `a`.*,`b`.`nav_href` FROM `try_category` `a` LEFT JOIN `try_nav` `b` ON `a`.`cat_id`=`b`.`real_cat_id` WHERE `a`.`cat_parent` = '78' AND `a`.`cat_status` = '1' AND `a`.`web_id` = '20' GROUP BY `a`.`cat_id` ORDER BY `a`.`cat_sort` ASC,`a`.`cat_id` ASC [ RunTime:0.004195s ]
- SHOW FULL COLUMNS FROM `try_link` [ RunTime:0.004200s ]
- SELECT * FROM `try_link` WHERE `web_id` = 20 AND `link_type` = 'index' ORDER BY `create_time` DESC LIMIT 0,20 [ RunTime:0.003690s ]
- SHOW FULL COLUMNS FROM `try_nav_cate` [ RunTime:0.004099s ]
- SELECT * FROM `try_nav_cate` WHERE `nc_alias` = 'top' AND `web_id` = 20 AND `nc_lang` = 'zh' LIMIT 1 [ RunTime:0.003589s ]
- SELECT `nav_id`,`nav_title`,`nav_parent`,`nav_href`,`nav_no_follow`,`nav_target`,`cat_id` FROM `try_nav` WHERE `nc_id` = 1 AND `web_id` = 20 AND `nav_lang` = 'zh' AND `nav_status` = 1 ORDER BY `nav_sort` ASC [ RunTime:0.003663s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 46 LIMIT 1 [ RunTime:0.003498s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 10 LIMIT 1 [ RunTime:0.003478s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 42 LIMIT 1 [ RunTime:0.003534s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 18 LIMIT 1 [ RunTime:0.003539s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 21 LIMIT 1 [ RunTime:0.003473s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 24 LIMIT 1 [ RunTime:0.003459s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 27 LIMIT 1 [ RunTime:0.003457s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 5 LIMIT 1 [ RunTime:0.003486s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 14 LIMIT 1 [ RunTime:0.003524s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 12 LIMIT 1 [ RunTime:0.003466s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 6 LIMIT 1 [ RunTime:0.003532s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 9 LIMIT 1 [ RunTime:0.003464s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 733 LIMIT 1 [ RunTime:0.003457s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 5 LIMIT 1 [ RunTime:0.003540s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 5 LIMIT 1 [ RunTime:0.003513s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 30 LIMIT 1 [ RunTime:0.003471s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 15 LIMIT 1 [ RunTime:0.003517s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 735 LIMIT 1 [ RunTime:0.003520s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 737 LIMIT 1 [ RunTime:0.003535s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 40 LIMIT 1 [ RunTime:0.003529s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 46 LIMIT 1 [ RunTime:0.003545s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 47 LIMIT 1 [ RunTime:0.003469s ]
- SELECT `cat_id`,`cat_parent`,`cat_address`,`cat_thumb`,`cat_title`,`cat_sub_title`,`cat_description` FROM `try_category` WHERE `cat_id` = 745 LIMIT 1 [ RunTime:0.003455s ]

0.317976s