-
最小化
-
在线咨询
-
微信咨询
立即扫码
联系您的在线客服
-
公众号
关注“源码庄”
速享新动态
-
回顶部
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2025-06-02 22:43:43 HTTP/1.1 GET : http://cms.canoenet.cn/reso/list/marketing_cases/?demo=1
- 运行时间 : 0.422061s [ 吞吐率：2.37req/s ] 内存消耗：5,365.56kb 文件加载：155
- 查询信息 : 48 queries
- 缓存信息 : 2 reads,1 writes
- 会话信息 : SESSION_ID=5a9e9fc824b8c48fe73b97aeb09989e4
- CONNECT:[ UseTime:0.007809s ] mysql:host=127.0.0.1;port=3306;dbname=cms_canoenet_cn;charset=utf8mb4
- SHOW FULL COLUMNS FROM `cms_site` [ RunTime:0.005277s ]
- SELECT * FROM `cms_site` WHERE `domain` LIKE '%cms.canoenet.cn%' LIMIT 1 [ RunTime:0.001454s ]
- SELECT * FROM `cms_site` WHERE `domain` LIKE '%cms.canoenet.cn%' LIMIT 1 [ RunTime:0.020142s ]
- SHOW FULL COLUMNS FROM `cms_user` [ RunTime:0.005725s ]
- SELECT `a`.*,b.substation as substation FROM `cms_user` `a` LEFT JOIN `cms_user_level` `b` ON `a`.`level`=`b`.`id` WHERE `a`.`id` = '1' LIMIT 1 [ RunTime:0.008725s ]
- SHOW FULL COLUMNS FROM `cms_slide_info` [ RunTime:0.019882s ]
- UPDATE `cms_slide_info` SET `status` = 3 WHERE `status` = 1 AND `term_time` < 1748875423 AND `life` <> 1 [ RunTime:0.026875s ]
- SHOW FULL COLUMNS FROM `cms_commission` [ RunTime:0.005782s ]
- SELECT * FROM `cms_commission` WHERE `status` = 2 AND `create_time` < 1748616223 [ RunTime:0.004855s ]
- SHOW FULL COLUMNS FROM `cms_menu` [ RunTime:0.025866s ]
- SELECT * FROM `cms_menu` WHERE `status` = 1 ORDER BY `sort` [ RunTime:0.009602s ]
- SHOW FULL COLUMNS FROM `cms_notice` [ RunTime:0.014925s ]
- SELECT * FROM `cms_notice` WHERE `popup` = 1 AND `status` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.010991s ]
- SHOW FULL COLUMNS FROM `cms_reso` [ RunTime:0.010356s ]
- SELECT `a`.*,b.mcode as mcode,b.name as catname FROM `cms_reso` `a` LEFT JOIN `cms_menu` `b` ON `a`.`pid`=`b`.`id` WHERE `a`.`status` = '1' AND `a`.`ishot` = '1' AND `b`.`mcode` = 'reso' AND `b`.`status` = '1' AND `b`.`mcode` = 'reso' ORDER BY `istop` ASC,`sort` DESC,`update_time` DESC,`id` DESC LIMIT 6 [ RunTime:0.005034s ]
- SHOW FULL COLUMNS FROM `cms_article` [ RunTime:0.010134s ]
- SELECT `a`.*,b.mcode as mcode,b.name as catname FROM `cms_article` `a` LEFT JOIN `cms_menu` `b` ON `a`.`pid`=`b`.`id` WHERE `a`.`status` = '1' AND `b`.`status` = '1' AND `b`.`mcode` = 'article' ORDER BY `istop` ASC,`id` DESC LIMIT 10 [ RunTime:0.005781s ]
- SHOW FULL COLUMNS FROM `cms_project` [ RunTime:0.003667s ]
- SELECT `a`.*,b.mcode as mcode,b.name as catname FROM `cms_project` `a` LEFT JOIN `cms_menu` `b` ON `a`.`pid`=`b`.`id` WHERE `a`.`status` = '1' AND `b`.`status` = '1' AND `b`.`mcode` = 'project' ORDER BY `istop` ASC,`id` DESC LIMIT 10 [ RunTime:0.002025s ]
- SELECT COUNT(*) AS think_count FROM `cms_reso` WHERE `status` = 1 LIMIT 1 [ RunTime:0.001220s ]
- SELECT COUNT(*) AS think_count FROM `cms_user` LIMIT 1 [ RunTime:0.001484s ]
- SHOW FULL COLUMNS FROM `cms_data` [ RunTime:0.001758s ]
- SELECT SUM(`count`) AS think_sum FROM `cms_data` LIMIT 1 [ RunTime:0.001345s ]
- SELECT COUNT(*) AS think_count FROM `cms_reso` WHERE `status` = 1 AND `create_time` BETWEEN 1748793600 AND 1749312000 LIMIT 1 [ RunTime:0.001350s ]
- SELECT * FROM `cms_data` WHERE `create_time` BETWEEN 1748793600 AND 1748879999 AND `siteid` = 1 AND `client` = 'pc' AND `sysid` = 'other' LIMIT 1 [ RunTime:0.001428s ]
- UPDATE `cms_data` SET `count` = 62 , `siteid` = 1 , `client` = 'pc' , `sysid` = 'other' , `update_time` = 1748875423 WHERE `id` = 368 [ RunTime:0.053696s ]
- SELECT * FROM `cms_slide_info` WHERE `pid` = 3 AND `status` = 1 ORDER BY `istop` ASC,`sort` DESC,`create_time` DESC,`id` DESC [ RunTime:0.000541s ]
- SELECT * FROM `cms_menu` WHERE `urlname` = 'marketing_cases' LIMIT 1 [ RunTime:0.000320s ]
- SELECT `id` FROM `cms_menu` WHERE `pid` = 9 [ RunTime:0.000255s ]
- SELECT COUNT(*) AS think_count FROM `cms_reso` `a` LEFT JOIN `cms_menu` `b` ON `a`.`pid`=`b`.`id` WHERE `a`.`demo` <> '' AND `b`.`mcode` = 'reso' AND `b`.`status` = '1' AND `a`.`status` IN ('1','2') AND `a`.`demo` = '1' AND `a`.`pid` IN ('79','80','81','82','83','84','85','86','87','88','89','90','91','92') LIMIT 1 [ RunTime:0.000398s ]
- SHOW FULL COLUMNS FROM `cms_user_level` [ RunTime:0.001589s ]
- SELECT * FROM `cms_user_level` WHERE `id` = 1 OR `status` = 1 [ RunTime:0.001083s ]
- SELECT `a`.*,b.mcode as mcode,b.name as catname FROM `cms_reso` `a` LEFT JOIN `cms_menu` `b` ON `a`.`pid`=`b`.`id` WHERE `a`.`status` = '1' AND `a`.`ishot` = '1' AND `b`.`mcode` = 'reso' AND `b`.`status` = '1' AND `a`.`pid` = '9' AND `b`.`mcode` = 'reso' ORDER BY `istop` ASC,`sort` DESC,`update_time` DESC,`id` DESC LIMIT 6 [ RunTime:0.000990s ]
- SELECT * FROM `cms_site` WHERE `domain` LIKE '%cms.canoenet.cn%' LIMIT 1 [ RunTime:0.001410s ]
- SELECT * FROM `cms_menu` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000645s ]
- SHOW FULL COLUMNS FROM `cms_module` [ RunTime:0.000825s ]
- SELECT * FROM `cms_module` WHERE `urlname` = 'reso' LIMIT 1 [ RunTime:0.000611s ]
- SELECT * FROM `cms_site` WHERE `domain` LIKE '%cms.canoenet.cn%' LIMIT 1 [ RunTime:0.000706s ]
- SHOW FULL COLUMNS FROM `cms_slide` [ RunTime:0.000821s ]
- SELECT * FROM `cms_slide` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000689s ]
- SELECT * FROM `cms_slide_info` WHERE `status` = 1 AND `pid` = 4 ORDER BY `istop` ASC,`sort` DESC,`update_time` DESC,`id` DESC LIMIT 3 [ RunTime:0.000731s ]
- SELECT * FROM `cms_site` WHERE `domain` LIKE '%cms.canoenet.cn%' LIMIT 1 [ RunTime:0.000705s ]
- SHOW FULL COLUMNS FROM `cms_file` [ RunTime:0.001201s ]
- SELECT * FROM `cms_file` WHERE `id` = 7955 LIMIT 1 [ RunTime:0.002746s ]
- SELECT * FROM `cms_menu` WHERE `status` IN (1,2) AND `id` = 28 LIMIT 1 [ RunTime:0.007726s ]
- SELECT * FROM `cms_menu` WHERE `status` IN (1,2) AND `id` = 29 LIMIT 1 [ RunTime:0.018534s ]
- SELECT * FROM `cms_menu` WHERE `status` IN (1,2) AND `id` = 40 LIMIT 1 [ RunTime:0.001646s ]
- SELECT * FROM `cms_menu` WHERE `status` IN (1,2) AND `id` = 30 LIMIT 1 [ RunTime:0.001330s ]
0.423770s
