医院_丰胸_花想容网

基本文件流程错误 SQL 调试

SELECT zm_hospital.id FROM `zm_hospital` left join zm_project on FIND_IN_SET(zm_project.id,zm_hospital.expert) WHERE ( zm_hospital.address LIKE '%丰胸%' OR zm_hospital.hname LIKE '%丰胸%' OR zm_hospital.keyword LIKE '%丰胸%' OR zm_project.pname LIKE '%丰胸%' ) AND ( zm_hospital.status = 1 ) GROUP BY zm_hospital.id [ RunTime:1.7299s ]
SELECT * FROM `zm_doctor` left join zm_hospital on zm_hospital.id = zm_doctor.hid INNER JOIN zm_project on FIND_IN_SET(zm_project.id,zm_doctor.expert) WHERE ( zm_doctor.uname LIKE '%丰胸%' OR zm_hospital.hname LIKE '%丰胸%' OR zm_doctor.keyword LIKE '%丰胸%' OR zm_project.pname LIKE '%丰胸%' ) AND ( zm_doctor.status = 1 ) GROUP BY zm_doctor.id [ RunTime:1.7935s ]
SELECT count(*) as ct FROM zm_question q WHERE ( q.title LIKE '%丰胸%' OR q.tags LIKE '%丰胸%' ) AND ( q.status = 1 ) LIMIT 1 [ RunTime:0.0055s ]
SELECT count(*) as ct FROM `zm_diary` left join zm_hospital on zm_hospital.id = zm_diary.hid left join zm_doctor on zm_doctor.id = zm_diary.did left join zm_project on zm_project.id = zm_diary.pid INNER JOIN zm_user on zm_user.userid = zm_diary.uid WHERE ( zm_doctor.hname LIKE '%丰胸%' OR zm_hospital.hname LIKE '%丰胸%' OR zm_project.pname LIKE '%丰胸%' OR zm_diary.tags LIKE '%丰胸%' OR zm_diary.title LIKE '%丰胸%' ) AND zm_diary.status = 1 LIMIT 1 [ RunTime:0.0276s ]
SELECT count(*) ct FROM `zm_encyclopedia` left join zm_enc_type on zm_enc_type.id = zm_encyclopedia.type WHERE ( zm_encyclopedia.title LIKE '%丰胸%' OR zm_encyclopedia.tags LIKE '%丰胸%' OR zm_enc_type.name LIKE '%丰胸%' ) AND `status` = 1 LIMIT 1 [ RunTime:0.0314s ]
SELECT count(*) as ct FROM zm_goods_new g INNER JOIN zm_hospital as h on h.id = g.hid INNER JOIN zm_doctor as d on d.id = g.did WHERE ( g.title LIKE '%丰胸%' OR g.tags LIKE '%丰胸%' OR h.hname LIKE '%丰胸%' OR d.uname LIKE '%丰胸%' ) AND g.status = 1 LIMIT 1 [ RunTime:0.0055s ]
SELECT zm_hospital.id FROM `zm_hospital` left join zm_project on FIND_IN_SET(zm_project.id,zm_hospital.expert) WHERE ( zm_hospital.address LIKE '%丰胸%' OR zm_hospital.hname LIKE '%丰胸%' OR zm_hospital.keyword LIKE '%丰胸%' OR zm_project.pname LIKE '%丰胸%' ) AND ( zm_hospital.status = 1 ) GROUP BY zm_hospital.id [ RunTime:1.7327s ]
SELECT zm_hospital.id,zm_hospital.cid,zm_hospital.hname,zm_hospital.address,zm_hospital.photo,zm_hospital.keyword,zm_hospital.expert,zm_hospital.address,zm_project.pname FROM `zm_hospital` left join zm_project on FIND_IN_SET(zm_project.id,zm_hospital.expert) WHERE ( zm_hospital.address LIKE '%丰胸%' OR zm_hospital.hname LIKE '%丰胸%' OR zm_hospital.keyword LIKE '%丰胸%' OR zm_project.pname LIKE '%丰胸%' ) AND ( zm_hospital.status = 1 ) GROUP BY zm_hospital.id ORDER BY zm_hospital.recommend desc,zm_hospital.likes desc,zm_hospital.collect desc LIMIT 0,24 [ RunTime:1.7310s ]
SELECT * FROM `zm_project` WHERE ( FIND_IN_SET(id,'1,3,4,5,6,7,8,9,10,11,14,15,22,31,34,35,37,38,63,6') ) [ RunTime:0.0006s ]
SELECT count(*) as ct FROM `zm_order` WHERE `hid` = '3871' AND `status` <> 6 LIMIT 1 [ RunTime:0.0004s ]
SELECT * FROM `zm_hos_region` ORDER BY sort desc LIMIT 12 [ RunTime:0.0002s ]
SELECT zm_hospital.id,zm_hospital.hname FROM `zm_hospital` INNER JOIN zm_hos_region on zm_hos_region.id = zm_hospital.rid WHERE zm_hos_region.province = '北京' AND zm_hospital.status = 1 ORDER BY zm_hospital.recommend desc LIMIT 5 [ RunTime:0.0195s ]
SELECT zm_hospital.id,zm_hospital.hname FROM `zm_hospital` INNER JOIN zm_hos_region on zm_hos_region.id = zm_hospital.rid WHERE zm_hos_region.province = '上海' AND zm_hospital.status = 1 ORDER BY zm_hospital.recommend desc LIMIT 5 [ RunTime:0.0132s ]
SELECT zm_hospital.id,zm_hospital.hname FROM `zm_hospital` INNER JOIN zm_hos_region on zm_hos_region.id = zm_hospital.rid WHERE zm_hos_region.province = '天津' AND zm_hospital.status = 1 ORDER BY zm_hospital.recommend desc LIMIT 5 [ RunTime:0.0159s ]
SELECT zm_hospital.id,zm_hospital.hname FROM `zm_hospital` INNER JOIN zm_hos_region on zm_hos_region.id = zm_hospital.rid WHERE zm_hos_region.province = '重庆' AND zm_hospital.status = 1 ORDER BY zm_hospital.recommend desc LIMIT 5 [ RunTime:0.0134s ]
SELECT zm_hospital.id,zm_hospital.hname FROM `zm_hospital` INNER JOIN zm_hos_region on zm_hos_region.id = zm_hospital.rid WHERE zm_hos_region.province = '江苏' AND zm_hospital.status = 1 ORDER BY zm_hospital.recommend desc LIMIT 5 [ RunTime:0.0147s ]
SELECT zm_hospital.id,zm_hospital.hname FROM `zm_hospital` INNER JOIN zm_hos_region on zm_hos_region.id = zm_hospital.rid WHERE zm_hos_region.province = '浙江' AND zm_hospital.status = 1 ORDER BY zm_hospital.recommend desc LIMIT 5 [ RunTime:0.0138s ]
SELECT zm_hospital.id,zm_hospital.hname FROM `zm_hospital` INNER JOIN zm_hos_region on zm_hos_region.id = zm_hospital.rid WHERE zm_hos_region.province = '广东' AND zm_hospital.status = 1 ORDER BY zm_hospital.recommend desc LIMIT 5 [ RunTime:0.0147s ]
SELECT zm_hospital.id,zm_hospital.hname FROM `zm_hospital` INNER JOIN zm_hos_region on zm_hos_region.id = zm_hospital.rid WHERE zm_hos_region.province = '湖北' AND zm_hospital.status = 1 ORDER BY zm_hospital.recommend desc LIMIT 5 [ RunTime:0.0138s ]
SELECT zm_hospital.id,zm_hospital.hname FROM `zm_hospital` INNER JOIN zm_hos_region on zm_hos_region.id = zm_hospital.rid WHERE zm_hos_region.province = '湖南' AND zm_hospital.status = 1 ORDER BY zm_hospital.recommend desc LIMIT 5 [ RunTime:0.0144s ]
SELECT zm_hospital.id,zm_hospital.hname FROM `zm_hospital` INNER JOIN zm_hos_region on zm_hos_region.id = zm_hospital.rid WHERE zm_hos_region.province = '安徽' AND zm_hospital.status = 1 ORDER BY zm_hospital.recommend desc LIMIT 5 [ RunTime:0.0142s ]
SELECT zm_hospital.id,zm_hospital.hname FROM `zm_hospital` INNER JOIN zm_hos_region on zm_hos_region.id = zm_hospital.rid WHERE zm_hos_region.province = '福建' AND zm_hospital.status = 1 ORDER BY zm_hospital.recommend desc LIMIT 5 [ RunTime:0.0137s ]
SELECT zm_hospital.id,zm_hospital.hname FROM `zm_hospital` INNER JOIN zm_hos_region on zm_hos_region.id = zm_hospital.rid WHERE zm_hos_region.province = '江西' AND zm_hospital.status = 1 ORDER BY zm_hospital.recommend desc LIMIT 5 [ RunTime:0.0138s ]

搜索医院

整形项目

整形医院

整形百科

搜索医院

整形项目

整形医院

整形百科

会员登录

短信登录