最基本
文档文件
具体步骤
严重错误
SQL
调整
- 请求信息 : 2025-06-10 12:47:57 HTTP/1.1 GET : //zhyylz.com/services/eur/greecefof
- 运行时间 : 0.499631s [ 吞吐率:2.00req/s ] 内存消耗:1,294.26kb 文件加载:135
- 查询信息 : 0 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=3b29ab9b54ec7a2fae44847826a2ed75
- CONNECT:[ UseTime:0.009931s ] mysql:host=mysql57;port=3306;dbname=mcdvisa2024_pro;charset=utf8
- SHOW FULL COLUMNS FROM `site` [ RunTime:0.000555s ]
- SELECT * FROM `site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000309s ]
- SHOW FULL COLUMNS FROM `h_nav` [ RunTime:0.000526s ]
- SELECT * FROM `h_nav` WHERE `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000816s ]
- SELECT * FROM `h_nav` WHERE `pid` = 2 AND `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000470s ]
- SELECT * FROM `h_nav` WHERE `pid` = 5 AND `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000389s ]
- SELECT * FROM `h_nav` WHERE `pid` = 51 AND `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000412s ]
- SHOW FULL COLUMNS FROM `home` [ RunTime:0.000456s ]
- SELECT * FROM `home` ORDER BY `id` [ RunTime:0.000246s ]
- SHOW FULL COLUMNS FROM `home_content` [ RunTime:0.000491s ]
- SELECT * FROM `home_content` WHERE `home_id` = 1 ORDER BY `sort` DESC,`id` LIMIT 6 [ RunTime:0.000342s ]
- SELECT * FROM `home_content` WHERE `home_id` = 2 ORDER BY `sort` DESC,`id` LIMIT 6 [ RunTime:0.000766s ]
- SELECT * FROM `home_content` WHERE `home_id` = 3 ORDER BY `sort` DESC,`id` LIMIT 6 [ RunTime:0.000273s ]
- SELECT * FROM `home_content` WHERE `home_id` = 4 ORDER BY `sort` DESC,`id` LIMIT 6 [ RunTime:0.000275s ]
- SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003081s ]
- SELECT * FROM `ad` WHERE `pos` = 'banner' AND `status` = 1 AND `site_id` = 1 ORDER BY `sort` DESC,`id` [ RunTime:0.000659s ]
- SHOW FULL COLUMNS FROM `service` [ RunTime:0.000990s ]
- 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.007554s ]
- SHOW FULL COLUMNS FROM `service_country` [ RunTime:0.000742s ]
- SELECT * FROM `service_country` WHERE `is_best` = 2 AND `status` = 1 ORDER BY `sort` DESC,`id` LIMIT 12 [ RunTime:0.002109s ]
- SHOW FULL COLUMNS FROM `outlink` [ RunTime:0.000657s ]
- SELECT * FROM `outlink` ORDER BY `sort` DESC,`id` [ RunTime:0.000546s ]
- SHOW FULL COLUMNS FROM `eb5_content` [ RunTime:0.001516s ]
- SELECT * FROM `eb5_content` WHERE `status` = 1 AND `protype` = 'eb5' ORDER BY `sort` DESC,`id` LIMIT 4 [ RunTime:0.007511s ]
- SHOW FULL COLUMNS FROM `cases` [ RunTime:0.007323s ]
- 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.001885s ]
- 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.000694s ]
- SHOW FULL COLUMNS FROM `news` [ RunTime:0.006667s ]
- 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.112381s ]
- 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.100814s ]
- 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.160889s ]
- SELECT * FROM `service` WHERE `strid` = 'greecefof' AND `status` = 1 LIMIT 1 [ RunTime:0.018511s ]
- SELECT * FROM `service_country` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000774s ]
- SHOW FULL COLUMNS FROM `service_country_info` [ RunTime:0.000913s ]
- SELECT * FROM `service_country_info` WHERE `country_id` = 3 ORDER BY `sort` DESC,`id` [ RunTime:0.001856s ]
- SELECT * FROM `service` WHERE `country_id` = 3 AND `status` = 1 ORDER BY `sort` DESC,`id` LIMIT 5 [ RunTime:0.000480s ]
- SHOW FULL COLUMNS FROM `service_info` [ RunTime:0.000493s ]
- SELECT * FROM `service_info` WHERE `service_id` = 144 ORDER BY `sort` DESC,`id` LIMIT 4 [ RunTime:0.001908s ]
- SHOW FULL COLUMNS FROM `service_qa` [ RunTime:0.000450s ]
- SELECT * FROM `service_qa` WHERE `service_id` = 144 ORDER BY `sort` DESC,`id` LIMIT 4 [ RunTime:0.000378s ]
- SELECT * FROM `ad` WHERE `site_id` = 1 AND `pos` = 'ad-news' AND `status` = 1 ORDER BY `sort` DESC,`id` LIMIT 3 [ RunTime:0.000300s ]
- UPDATE `service` SET `views` = `views` + 1 WHERE `strid` = 'greecefof' [ RunTime:0.020751s ]