抱歉!没有找到相关的药品
你可以发布求购意向,博大医药网会尽快补货!
消息
result
jx
sccj
ypgg
cxGoods
category
title
obLevel
__env
app
ad152
rand_num
errors
goodsPresenter
ad
ads
select id from ecs_sensitive_words where '' like concat('%', keywords, '%')
select count(*) as aggregate from `ecs_goods` inner join `ecs_goods_statistics` on `ecs_goods`.`goods_id` = `ecs_goods_statistics`.`goods_id` and `is_mtx` = '0' where `ecs_goods`.`is_delete` = '0' and `online` = '1' and `off_sale_ranks` != '1,2,5,7,8,9' and (`ecs_goods`.`goods_name` like '%%' or `ecs_goods`.`goods_name1` like '%%' or `ecs_goods_statistics`.`brand_name` like '%%' or `ecs_goods_statistics`.`cate_name` like '%%') and ((`cat_ids` = '1164' or `cat_ids` like '1164,%' or `cat_ids` like '%,1164' or `cat_ids` like '%,1164,%') and (`cat_ids` = '1164' or `cat_ids` like '1164,%' or `cat_ids` like '%,1164' or `cat_ids` like '%,1164,%')) and `ecs_goods`.`product_name` = '湖北诺得胜制药有限公司'
!=
<>
select `ecs_goods`.`goods_id`, `ecs_goods`.`goods_name`, `ecs_goods`.`shop_price`, `ecs_goods`.`qyhy_price`, `ecs_goods`.`is_kxpz`, `ecs_goods`.`is_promote`, `ecs_goods`.`promote_price`, `ecs_goods`.`promote_start_date`, `ecs_goods`.`promote_end_date`, `ecs_goods`.`is_xkh_tj`, `ecs_goods`.`xg_type`, `ecs_goods`.`xg_start_date`, `ecs_goods`.`xg_end_date`, `ecs_goods`.`xrtj_xg_num`, `ecs_goods`.`ls_ggg`, `ecs_goods`.`cat_ids`, `ecs_goods`.`show_area`, `ecs_goods`.`mtx_show_area`, `ecs_goods`.`ERPID`, `ecs_goods`.`xq`, `ecs_goods`.`ckid`, `ecs_goods`.`goods_number`, `ecs_goods`.`ls_gg`, `ecs_goods`.`goods_img`, `ecs_goods`.`goods_thumb`, `ecs_goods`.`zyzk`, `ecs_goods`.`tsbz`, `ecs_goods`.`is_show`, `ecs_goods`.`is_zbz`, `ecs_goods`.`g_ranks`, `ecs_goods`.`is_otc`, case when is_promote = 1 and promote_end_date > UNIX_TIMESTAMP() then 1 else 0 end as is_promote_tag, `ecs_goods`.`ls_min_count` from `ecs_goods` inner join `ecs_goods_statistics` on `ecs_goods`.`goods_id` = `ecs_goods_statistics`.`goods_id` and `is_mtx` = '0' where `ecs_goods`.`is_delete` = '0' and `online` = '1' and `off_sale_ranks` != '1,2,5,7,8,9' and (`ecs_goods`.`goods_name` like '%%' or `ecs_goods`.`goods_name1` like '%%' or `ecs_goods_statistics`.`brand_name` like '%%' or `ecs_goods_statistics`.`cate_name` like '%%') and ((`cat_ids` = '1164' or `cat_ids` like '1164,%' or `cat_ids` like '%,1164' or `cat_ids` like '%,1164,%') and (`cat_ids` = '1164' or `cat_ids` like '1164,%' or `cat_ids` like '%,1164' or `cat_ids` like '%,1164,%')) and `ecs_goods`.`product_name` = '湖北诺得胜制药有限公司' order by `ecs_goods_statistics`.`score` desc, `ecs_goods`.`sort_order` asc, `ecs_goods`.`goods_id` asc limit 40 offset 0
select * from `ecs_miaosha_group_region` where `region_id` = '8'
SELECT *
select * from `ecs_miaosha_group` where `start_time` <= '2025-04-29 10:33:49' and `end_time` > '2025-04-29 10:33:49' and `is_enabled` = '1' and isnull(delete_time) and `id` in ('2', '39', '1', '3', '4', '5', '7', '12', '15', '16', '17', '21', '24', '25', '33', '35', '40', '42', '43', '44', '45', '41', '48', '50', '54') limit 1
LIMIT
ORDER BY
select `ypgg` from `ecs_goods` inner join `ecs_goods_statistics` on `ecs_goods`.`goods_id` = `ecs_goods_statistics`.`goods_id` and `is_mtx` = '0' where `ecs_goods`.`is_delete` = '0' and `online` = '1' and `off_sale_ranks` != '1,2,5,7,8,9' and (`ecs_goods`.`goods_name` like '%%' or `ecs_goods`.`goods_name1` like '%%' or `ecs_goods_statistics`.`brand_name` like '%%' or `ecs_goods_statistics`.`cate_name` like '%%') and ((`cat_ids` = '1164' or `cat_ids` like '1164,%' or `cat_ids` like '%,1164' or `cat_ids` like '%,1164,%') and (`cat_ids` = '1164' or `cat_ids` like '1164,%' or `cat_ids` like '%,1164' or `cat_ids` like '%,1164,%')) and `ecs_goods`.`product_name` = '湖北诺得胜制药有限公司' and `ypgg` != '' group by `ypgg` order by `ecs_goods_statistics`.`score` desc, `ecs_goods`.`sort_order` asc, `ecs_goods`.`goods_id` asc
select * from `ecs_ad` where `position_id` = '152' and `enabled` > '0' and `end_time` > '1745894029' order by `sort_order` desc, `ad_id` desc
select * from `ecs_ad` where `position_id` = '159' and `enabled` > '0' and `end_time` > '1745894029' order by `sort_order` desc, `ad_id` desc
select `name`, `url`, `opennew`, `id` from `ecs_nav` where `ifshow` = '1' and `type` = 'middle' and 1 = 1 order by `type` asc, `vieworder` asc
select `cat_id`, `cat_name`, `sort_order` from `ecs_article_cat` where `cat_id` = '5' limit 1
select `cat_id`, `title`, `article_id`, `file_url`, `open_type`, `add_time`, `keywords` from `ecs_article` where `ecs_article`.`cat_id` in ('5') and `is_open` = '1' order by `article_type` desc, `article_id` desc limit 6