关键
文档文件
的流程
不正确的
SQL
调试程序
- 请求信息 : 2025-06-18 02:46:58 HTTP/1.1 GET : //zhyylz.com/news/1.html?page=12
- 运行时间 : 0.046940s [ 吞吐率:21.30req/s ] 内存消耗:1,358.56kb 文件加载:136
- 查询信息 : 0 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=d8009a34b94a22c8bfa5070fc389900d
- CONNECT:[ UseTime:0.000410s ] mysql:host=mysql57;port=3306;dbname=mcdvisa2024_pro;charset=utf8
- SHOW FULL COLUMNS FROM `site` [ RunTime:0.000779s ]
- SELECT * FROM `site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000367s ]
- SHOW FULL COLUMNS FROM `h_nav` [ RunTime:0.000588s ]
- SELECT * FROM `h_nav` WHERE `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000835s ]
- SELECT * FROM `h_nav` WHERE `pid` = 2 AND `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000506s ]
- SELECT * FROM `h_nav` WHERE `pid` = 5 AND `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000449s ]
- SELECT * FROM `h_nav` WHERE `pid` = 51 AND `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000338s ]
- SHOW FULL COLUMNS FROM `home` [ RunTime:0.000371s ]
- SELECT * FROM `home` ORDER BY `id` [ RunTime:0.000163s ]
- SHOW FULL COLUMNS FROM `home_content` [ RunTime:0.000344s ]
- SELECT * FROM `home_content` WHERE `home_id` = 1 ORDER BY `sort` DESC,`id` LIMIT 6 [ RunTime:0.000250s ]
- SELECT * FROM `home_content` WHERE `home_id` = 2 ORDER BY `sort` DESC,`id` LIMIT 6 [ RunTime:0.000210s ]
- SELECT * FROM `home_content` WHERE `home_id` = 3 ORDER BY `sort` DESC,`id` LIMIT 6 [ RunTime:0.000196s ]
- SELECT * FROM `home_content` WHERE `home_id` = 4 ORDER BY `sort` DESC,`id` LIMIT 6 [ RunTime:0.000197s ]
- SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000330s ]
- SELECT * FROM `ad` WHERE `pos` = 'banner' AND `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000253s ]
- SHOW FULL COLUMNS FROM `service` [ RunTime:0.000412s ]
- SELECT * FROM `service` WHERE `is_best` = 2 AND `status` = 1 AND `service_type` IN ('eur','imm') ORDER BY `sort` DESC,`id` LIMIT 12 [ RunTime:0.000512s ]
- SHOW FULL COLUMNS FROM `service_country` [ RunTime:0.000363s ]
- SELECT * FROM `service_country` WHERE `is_best` = 2 AND `status` = 1 ORDER BY `sort` DESC,`id` LIMIT 12 [ RunTime:0.000402s ]
- SHOW FULL COLUMNS FROM `outlink` [ RunTime:0.000314s ]
- SELECT * FROM `outlink` ORDER BY `sort` DESC,`id` [ RunTime:0.000172s ]
- SHOW FULL COLUMNS FROM `eb5_content` [ RunTime:0.000348s ]
- SELECT * FROM `eb5_content` WHERE `status` = 1 AND `protype` = 'eb5' ORDER BY `sort` DESC,`id` LIMIT 4 [ RunTime:0.000235s ]
- SHOW FULL COLUMNS FROM `cases` [ RunTime:0.000375s ]
- SELECT `a`.`id`,`a`.`strid`,`a`.`name`,`a`.`img`,`a`.`add_time`,`a`.`note`,`a`.`cid`,c.strid as c_strid,c.name as c_name FROM `cases` `a` INNER JOIN `cases_cate` `c` ON `a`.`cid`=`c`.`id` WHERE `a`.`site_id` = '1' AND `a`.`status` = '1' AND `a`.`is_best` = '2' ORDER BY `a`.`sort` DESC,`a`.`id` LIMIT 8 [ RunTime:0.000446s ]
- SELECT `s`.`id`,`s`.`strid`,`s`.`name`,`s`.`img`,`s`.`cate_id`,`s`.`service_type`,`s`.`s_advantage`,`s`.`intro`,`s`.`advantage`,`s`.`process_cycle`,`s`.`Identity_type`,`s`.`investment_fee`,`s`.`live_require`,c.strid as c_strid,c.name as c_name FROM `service` `s` INNER JOIN `service_cate` `c` ON `s`.`cate_id`=`c`.`id` WHERE `s`.`status` = '1' AND `s`.`is_best` = '2' ORDER BY `s`.`sort` DESC,`s`.`id` LIMIT 4 [ RunTime:0.000373s ]
- SHOW FULL COLUMNS FROM `news` [ RunTime:0.000385s ]
- SELECT `n`.`id`,`n`.`cid`,`n`.`strid`,`n`.`name`,`n`.`img`,`n`.`add_time`,`n`.`note`,c.strid as c_strid,c.name as c_name FROM `news` `n` INNER JOIN `news_cate` `c` ON `n`.`cid`=`c`.`id` WHERE `n`.`status` = '1' AND `n`.`site_id` = '1' AND `n`.`is_best` = '2' AND `n`.`img` IS NOT NULL ORDER BY `n`.`is_best` DESC,`n`.`add_time` DESC,`n`.`id` LIMIT 3 [ RunTime:0.006323s ]
- SELECT `n`.`id`,`n`.`cid`,`n`.`strid`,`n`.`name`,`n`.`img`,`n`.`add_time`,`n`.`note`,c.strid as c_strid,c.name as c_name FROM `news` `n` INNER JOIN `news_cate` `c` ON `n`.`cid`=`c`.`id` WHERE `n`.`status` = '1' AND `n`.`site_id` = '1' ORDER BY `n`.`add_time` DESC,`n`.`id` LIMIT 7 [ RunTime:0.006022s ]
- SELECT `n`.`id`,`n`.`cid`,`n`.`strid`,`n`.`name`,`n`.`img`,`n`.`add_time`,`n`.`note`,c.strid as c_strid,c.name as c_name FROM `news` `n` INNER JOIN `news_cate` `c` ON `n`.`cid`=`c`.`id` WHERE `n`.`status` = '1' AND `n`.`site_id` = '1' ORDER BY `n`.`add_time` DESC,`n`.`id` LIMIT 7,7 [ RunTime:0.005512s ]
- SHOW FULL COLUMNS FROM `news_cate` [ RunTime:0.000385s ]
- SELECT * FROM `news_cate` WHERE `site_id` = 1 LIMIT 1 [ RunTime:0.000194s ]
- SELECT * FROM `news_cate` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000203s ]
- SELECT * FROM `news_cate` WHERE `site_id` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000247s ]
- SELECT COUNT(*) AS think_count FROM `news` `n` INNER JOIN `news_cate` `c` ON `n`.`cid`=`c`.`id` WHERE `n`.`status` = '1' AND `n`.`site_id` = '1' AND `n`.`cid` = '1' LIMIT 1 [ RunTime:0.003846s ]
- SELECT `n`.`id`,`n`.`name`,`n`.`strid`,`n`.`add_time`,`n`.`cid`,`n`.`note`,`n`.`img`,`n`.`views`,c.strid c_strid,c.name c_name FROM `news` `n` INNER JOIN `news_cate` `c` ON `n`.`cid`=`c`.`id` WHERE `n`.`status` = '1' AND `n`.`site_id` = '1' AND `n`.`cid` = '1' ORDER BY `n`.`sort` DESC,`n`.`add_time` DESC,`n`.`id` DESC LIMIT 99,9 [ RunTime:0.004656s ]