<tr><td>产品名称</td><td>枸橼酸西地那非片</td></tr><tr><td>商品名/商标</td><td>金戈</td></tr><tr><td>规格</td><td>50mg*10片</td></tr><tr><td>主要成份</td><td>枸橼酸西地那非。<tr><td>性状</td><td>本品为薄膜衣片，除去包衣后显白色至类白色。</td></tr><tr><td>适应症</td><td>适用于治疗勃起功能障碍。</td></tr><tr><td>用法用量</td><td>对大多数患者，推荐剂量为50毫克，在性活动前约1小时按需服用；但在性活动前0.5~4小时内的任何时候服用均可。基于药效和受耐性，剂量可增加至100毫克（最大推荐剂量）或降低至25毫克，每日最多服用1次。</td></tr><tr><td>不良反应</td><td>服用任何剂型硝酸酯类药物的患者，无论是规律或间断服用，均为禁忌症。对西地那非中任何成分过敏的患者禁用。</td></tr><tr><td>注意事项</td><td>西地那非-硝酸酯类影响血压的相互作用，可从给药开始持续到整个6小时的观察期内。所以，在任何情况下，联合给予西地那非和有机硝酸酯类或提供NO类药物（如硝普钠）均属禁忌。以下患者慎用西地那非：阴茎解剖畸形（如阴茎偏曲、海绵体纤维化、Peyronie氏病），易引起阴茎异常勃起的疾病（如镰状细胞性贫血、多发性骨髓瘤、白血病）。其他治疗勃起功能障碍的方法与本品合用的安全性和有效性尚未研究，不推荐联合使用。在已有心血管危险因素存在时，用药后性活动有发生非致命性/致命性心脏事件的危险。在性活动开始时如出现心绞痛、头晕、恶心等症状，须终止性活动。国外批准本品上市后，有少量勃起时间延长（超过4小时）和异常勃起（痛性勃起超过6小时）的报告。如持续勃起超过4小时，患者应立即就诊。如异常勃起未得到即刻处理，阴茎组织将可能受到损害并可能导致永久性勃起功能丧失。西地那非对性传播疾病无保护作用。</td></tr><tr><td>药物相互作用</td><td>其他药物对西地那非的作用：体外实验：本品代谢主要通过细胞色素P4503A4（主要途径）和2C9（次要途径）,故这些同功酶的抑制剂会降低西地那非的清除。体内实验：健康志愿者同时服用本品50mg和西咪替丁（一种非特异性细胞色素P450抑制剂）800mg，导致血浆内西地那非浓度增高56%。单剂西地那非100mg与细胞色素P4503A4的特异性抑制剂红霉素（500mg，一日两次，共5天达到稳态）合用时，西地那非的药时曲线下面积（AUC）升高182%；单剂西地那非100mg与另一种CYP4503A4抑制剂HIV蛋白酶抑制剂saquinavir合用，达到稳态时（1200mg，一日三次），则后者的Cmax提高140%，AUC增加210%，西地那非不影响后者的药代动力学；酮康唑、伊曲康唑等更强效的CYP4503A4抑制剂，上述作用可能更大；当与CYP4503A4抑制剂（如酮康唑、红霉素、西咪替丁）合用时，西地那非的清除率降低。可预测同时服用CYP4503A4的诱导剂（如利福平）将降低血浆西地那非水平。单剂抗酸药（氢氧化铝/氢氧化镁）对本品生物利用度没有影响；CYP4502C9抑制剂（如甲苯磺丁脲、华法令）、CYP4502D6抑制剂（如选择性5－羟色胺再摄取抑制剂、三环抗抑郁药）、噻嗪类药物及噻嗪类利尿剂、血管紧张素转换酶抑制剂、钙通道阻滞剂等，对西地那非的药代动力学没有影响。襻利尿剂和保钾利尿剂可使西地那非活性代谢产物（N－去甲基西地那非）的AUC增加62%，而非选择性?－受体阻滞剂使其增加102%。这些对西地那非代谢产物的影响不会引起临床变化。西地那非对其他药物的作用：体外实验：本品是一种细胞色素P4501A2、2C9、2C19、2D6、2E1和3A4（IC50＞150μM）的弱抑制剂。由于服用推荐剂量西地那非后其血浆峰浓度约为1μM，故西地那非不会改变这些同功酶作用底物的清除。体内试验：高血压患者同时服用西地那非（100mg）和氨氯地平5mg或10mg，仰卧位收缩压平均进一步降低8mmHg，舒张压平均进一步降低7mmHg。未发现经CYP4502C9代谢的甲苯磺丁脲（250mg）和华法令（40mg）与西地那非有明显的相互作用。西地那非（50mg）不增加阿司匹林（150mg）所致的出血时间延长。健康志愿者平均最大血浆酒精浓度为0.08%时，西地那非（50mg）不增强酒精的降压作用。西地那非（100mg）不影响HIV蛋白酶抑制剂saquinavir、ritonavir稳态时的药代动力学，后二者都是CYP4503A4的底物。</td></tr><tr><td>贮藏</td><td>遮光，密封保存。</td></tr><tr><td>有效期</td><td>18个月。</td></tr><tr><td>生产厂家</td><td>广州白云山制药股份有限公司广州白云山制药总厂</td></tr><tr><td>批准文号</td><td>国药准字H20143255</td></tr><tr><td>生产地址</td><td>广州市白云区同和街云祥路88号</td></tr><tr><td>条形码</td><td>6902401045076</td></tr>
去制表符函数
DROP FUNCTION IF EXISTS fnStripTags;
DELIMITER $
CREATE DEFINER=`beiyaozhongtai`@`%` FUNCTION `fnStripTags`(Dirty MEDIUMTEXT) RETURNS mediumtext CHARSET utf8mb4
DETERMINISTIC
BEGIN
#Routine body goes here...
DECLARE iStart, iEnd, iLength int;
WHILE Locate( '<', Dirty ) > 0 And Locate( '>', Dirty, Locate( '<', Dirty )) > 0 DO
BEGIN
SET iStart = Locate( '<', Dirty ), iEnd = Locate( '>', Dirty, Locate('<', Dirty ));
SET iLength = ( iEnd - iStart) + 1;
IF iLength > 0 THEN
BEGIN
SET Dirty = Insert( Dirty, iStart, iLength, '');
END;
END IF;
END;
END WHILE;
RETURN Dirty;
END;
$;
DELIMITER;
匹配出商标字段
SELECT substring_index(substring_index(substring_index(medicine_instruction, '商标', -1),"</td>",2),"<td>",-1),medicine_instruction FROM medicine_info_22w WHERE medicine_instruction is not null and medicine_instruction like "%商标%" LIMIT 100
配合函数匹配商标【商品名/商标】字段
SELECT id, brand_name,REPLACE(REPLACE(REPLACE(substring_index(substring_index(fnStripTags(instruction_book),"【商品名/商标】",-1),"【",1), ' ',""),"
","")," ","") as brand_name2,upc,fnStripTags(instruction_book) content,instruction_book FROM zt_product_base WHERE instruction_book is not null and instruction_book like "%【商品名/商标】%" and brand_name != REPLACE(REPLACE(REPLACE(substring_index(substring_index(fnStripTags(instruction_book),"【商品名/商标】",-1),"【",1), ' ',""),"
","")," ","") LIMIT 100;
UPDATE zt_product_base set brand_name = REPLACE(REPLACE(REPLACE(substring_index(substring_index(fnStripTags(instruction_book),"【商品名/商标】",-1),"【",1), ' ',""),"
","")," ","") WHERE instruction_book is not null and instruction_book like "%【商品名/商标】%" and brand_name != REPLACE(REPLACE(REPLACE(substring_index(substring_index(fnStripTags(instruction_book),"【商品名/商标】",-1),"【",1), ' ',""),"
","")," ","")
快速匹配
set @barCode="【条形码】";
set @commonName="【产品名称】";
set @approvalNumber="【批准文号】";
SELECT common_name,REPLACE(substring_index(regexp_replace(REPLACE(REPLACE(REPLACE(substring_index(substring_index(substring_index(instruction_book ,@barCode,-1),"【",1)," ",1), ' ',""),"
-- ","")," ",""),'<.+?>',''),"<",1)," ","") as codes,REPLACE(substring_index(regexp_replace(REPLACE(REPLACE(REPLACE(substring_index(substring_index(substring_index(instruction_book ,@commonName,-1),"【",1)," ",1), ' ',""),"
-- ","")," ",""),'<.+?>',''),"<",1)," ","") as common_name2,approval_number,REPLACE(substring_index(regexp_replace(REPLACE(REPLACE(REPLACE(substring_index(substring_index(substring_index(instruction_book ,"【批准文号】",-1),"【",1)," ",1), ' ',""),"
-- ","")," ",""),'<.+?>',''),"<",1)," ","") as approval_number2 FROM zt_product_base WHERE instruction_book not like CONCAT("%",approval_number ,"%") and instruction_book not like CONCAT("%",common_name,"%") and instruction_book like CONCAT("%",@approvalNumber,"%");
网友评论