关键
zip文件
步骤流程
不正确的
SQL
调校
- 请求信息 : 2025-06-18 01:13:33 HTTP/1.1 GET : //zhyylz.com/htmls/visa/cunbao2017.html
- 运行时间 : 0.074321s [ 吞吐率:13.46req/s ] 内存消耗:1,226.61kb 文件加载:135
- 查询信息 : 0 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=32b53092c616d1d31ac6bb8b707423c3
- CONNECT:[ UseTime:0.000407s ] mysql:host=mysql57;port=3306;dbname=mcdvisa2024_pro;charset=utf8
- SHOW FULL COLUMNS FROM `site` [ RunTime:0.000771s ]
- SELECT * FROM `site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000394s ]
- SHOW FULL COLUMNS FROM `h_nav` [ RunTime:0.000562s ]
- SELECT * FROM `h_nav` WHERE `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000794s ]
- SELECT * FROM `h_nav` WHERE `pid` = 2 AND `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000495s ]
- SELECT * FROM `h_nav` WHERE `pid` = 5 AND `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000428s ]
- SELECT * FROM `h_nav` WHERE `pid` = 51 AND `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000416s ]
- SHOW FULL COLUMNS FROM `home` [ RunTime:0.000517s ]
- SELECT * FROM `home` ORDER BY `id` [ RunTime:0.000579s ]
- SHOW FULL COLUMNS FROM `home_content` [ RunTime:0.000463s ]
- SELECT * FROM `home_content` WHERE `home_id` = 1 ORDER BY `sort` DESC,`id` LIMIT 6 [ RunTime:0.000305s ]
- SELECT * FROM `home_content` WHERE `home_id` = 2 ORDER BY `sort` DESC,`id` LIMIT 6 [ RunTime:0.000271s ]
- SELECT * FROM `home_content` WHERE `home_id` = 3 ORDER BY `sort` DESC,`id` LIMIT 6 [ RunTime:0.000265s ]
- SELECT * FROM `home_content` WHERE `home_id` = 4 ORDER BY `sort` DESC,`id` LIMIT 6 [ RunTime:0.000262s ]
- SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000501s ]
- SELECT * FROM `ad` WHERE `pos` = 'banner' AND `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000356s ]
- SHOW FULL COLUMNS FROM `service` [ RunTime:0.000623s ]
- 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.000714s ]
- SHOW FULL COLUMNS FROM `service_country` [ RunTime:0.000548s ]
- SELECT * FROM `service_country` WHERE `is_best` = 2 AND `status` = 1 ORDER BY `sort` DESC,`id` LIMIT 12 [ RunTime:0.000584s ]
- SHOW FULL COLUMNS FROM `outlink` [ RunTime:0.000444s ]
- SELECT * FROM `outlink` ORDER BY `sort` DESC,`id` [ RunTime:0.000233s ]
- SHOW FULL COLUMNS FROM `eb5_content` [ RunTime:0.000480s ]
- SELECT * FROM `eb5_content` WHERE `status` = 1 AND `protype` = 'eb5' ORDER BY `sort` DESC,`id` LIMIT 4 [ RunTime:0.000311s ]
- SHOW FULL COLUMNS FROM `cases` [ RunTime:0.000574s ]
- 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.000688s ]
- 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.000512s ]
- SHOW FULL COLUMNS FROM `news` [ RunTime:0.000570s ]
- 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.011139s ]
- 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.010301s ]
- 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.011469s ]
- SELECT * FROM `news` WHERE `strid` = 'cunbao2017' AND `status` = 1 LIMIT 1 [ RunTime:0.004242s ]
- SELECT MAX(`id`) AS think_max FROM `news` WHERE `status` = 1 AND `site_id` = 1 AND `id` < 16556 LIMIT 1 [ RunTime:0.001337s ]
- SELECT MIN(`id`) AS think_min FROM `news` WHERE `status` = 1 AND `site_id` = 1 AND `id` > 16556 LIMIT 1 [ RunTime:0.008223s ]
- SELECT `a`.`id`,`a`.`strid`,`a`.`name`,c.strid as c_strid,c.name as c_name FROM `news` `a` INNER JOIN `news_cate` `c` ON `a`.`cid`=`c`.`id` WHERE `a`.`id` = '16555' LIMIT 1 [ RunTime:0.000292s ]
- SELECT `a`.`id`,`a`.`strid`,`a`.`name`,c.strid as c_strid,c.name as c_name FROM `news` `a` INNER JOIN `news_cate` `c` ON `a`.`cid`=`c`.`id` WHERE `a`.`id` = '16557' LIMIT 1 [ RunTime:0.000280s ]
- UPDATE `news` SET `views` = `views` + 1 WHERE `id` = 16556 [ RunTime:0.002856s ]