抱歉!没有找到相关的药品
你可以发布求购意向,博大医药网会尽快补货!
发布求购互联网药品信息服务资格证编号:(黔)-非经营性-2020-0027 ICP备案证书号:黔ICP备20001963号-1 增值电信业务经营许可证:合字B2-20220079 © 2020 贵州博大医药有限公司版权所有
营业执照 统一社会信用代码:91520100770588680F 药品经营许可证:黔AA8510019 医疗器械经营许可证:黔筑 二类医疗器械经营备案:黔筑 食品经营许可证:JY15201020202360
© 2020 贵州博大医药有限公司版权所有
本网站未发布毒性药品、麻醉药品、精神药品、放射性药品、戒毒药品和医疗机构制剂的产品信息
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
select id from ecs_sensitive_words where '' like concat('%', keywords, '%')
9.74msys_testMetadata |
---|
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` = 'm' or `cat_ids` like 'm,%' or `cat_ids` like '%,m' or `cat_ids` like '%,m,%') and (`cat_ids` = '12' or `cat_ids` like '12,%' or `cat_ids` like '%,12' or `cat_ids` like '%,12,%') and (`cat_ids` = '380' or `cat_ids` like '380,%' or `cat_ids` like '%,380' or `cat_ids` like '%,380,%') and (`cat_ids` = '696' or `cat_ids` like '696,%' or `cat_ids` like '%,696' or `cat_ids` like '%,696,%') and (`cat_ids` = '697' or `cat_ids` like '697,%' or `cat_ids` like '%,697' or `cat_ids` like '%,697,%') and (`cat_ids` = '698' or `cat_ids` like '698,%' or `cat_ids` like '%,698' or `cat_ids` like '%,698,%') and (`cat_ids` = '704' or `cat_ids` like '704,%' or `cat_ids` like '%,704' or `cat_ids` like '%,704,%') and (`cat_ids` = '706' or `cat_ids` like '706,%' or `cat_ids` like '%,706' or `cat_ids` like '%,706,%') and (`cat_ids` = '707' or `cat_ids` like '707,%' or `cat_ids` like '%,707' or `cat_ids` like '%,707,%') and (`cat_ids` = '709' or `cat_ids` like '709,%' or `cat_ids` like '%,709' or `cat_ids` like '%,709,%') and (`cat_ids` = '711' or `cat_ids` like '711,%' or `cat_ids` like '%,711' or `cat_ids` like '%,711,%') and (`cat_ids` = '714' or `cat_ids` like '714,%' or `cat_ids` like '%,714' or `cat_ids` like '%,714,%') and (`cat_ids` = '716' or `cat_ids` like '716,%' or `cat_ids` like '%,716' or `cat_ids` like '%,716,%') and (`cat_ids` = '717' or `cat_ids` like '717,%' or `cat_ids` like '%,717' or `cat_ids` like '%,717,%') and (`cat_ids` = '1244' or `cat_ids` like '1244,%' or `cat_ids` like '%,1244' or `cat_ids` like '%,1244,%') and (`cat_ids` = '1245' or `cat_ids` like '1245,%' or `cat_ids` like '%,1245' or `cat_ids` like '%,1245,%') and (`cat_ids` = '1246' or `cat_ids` like '1246,%' or `cat_ids` like '%,1246' or `cat_ids` like '%,1246,%') and (`cat_ids` = '1247' or `cat_ids` like '1247,%' or `cat_ids` like '%,1247' or `cat_ids` like '%,1247,%') and (`cat_ids` = '1248' or `cat_ids` like '1248,%' or `cat_ids` like '%,1248' or `cat_ids` like '%,1248,%') and (`cat_ids` = '1249' or `cat_ids` like '1249,%' or `cat_ids` like '%,1249' or `cat_ids` like '%,1249,%') and (`cat_ids` = '1250' or `cat_ids` like '1250,%' or `cat_ids` like '%,1250' or `cat_ids` like '%,1250,%') and (`cat_ids` = '1251' or `cat_ids` like '1251,%' or `cat_ids` like '%,1251' or `cat_ids` like '%,1251,%') and (`cat_ids` = '1252' or `cat_ids` like '1252,%' or `cat_ids` like '%,1252' or `cat_ids` like '%,1252,%') and (`cat_ids` = '1253' or `cat_ids` like '1253,%' or `cat_ids` like '%,1253' or `cat_ids` like '%,1253,%') and (`cat_ids` = '1254' or `cat_ids` like '1254,%' or `cat_ids` like '%,1254' or `cat_ids` like '%,1254,%') and (`cat_ids` = '1255' or `cat_ids` like '1255,%' or `cat_ids` like '%,1255' or `cat_ids` like '%,1255,%') and (`cat_ids` = '1256' or `cat_ids` like '1256,%' or `cat_ids` like '%,1256' or `cat_ids` like '%,1256,%') and (`cat_ids` = '1257' or `cat_ids` like '1257,%' or `cat_ids` like '%,1257' or `cat_ids` like '%,1257,%') and (`cat_ids` = '1258' or `cat_ids` like '1258,%' or `cat_ids` like '%,1258' or `cat_ids` like '%,1258,%') and (`cat_ids` = '1259' or `cat_ids` like '1259,%' or `cat_ids` like '%,1259' or `cat_ids` like '%,1259,%') and (`cat_ids` = '1260' or `cat_ids` like '1260,%' or `cat_ids` like '%,1260' or `cat_ids` like '%,1260,%') and (`cat_ids` = '1261' or `cat_ids` like '1261,%' or `cat_ids` like '%,1261' or `cat_ids` like '%,1261,%') and (`cat_ids` = '1262' or `cat_ids` like '1262,%' or `cat_ids` like '%,1262' or `cat_ids` like '%,1262,%') and (`cat_ids` = '683' or `cat_ids` like '683,%' or `cat_ids` like '%,683' or `cat_ids` like '%,683,%') and (`cat_ids` = '685' or `cat_ids` like '685,%' or `cat_ids` like '%,685' or `cat_ids` like '%,685,%') and (`cat_ids` = '686' or `cat_ids` like '686,%' or `cat_ids` like '%,686' or `cat_ids` like '%,686,%') and (`cat_ids` = '687' or `cat_ids` like '687,%' or `cat_ids` like '%,687' or `cat_ids` like '%,687,%') and (`cat_ids` = '688' or `cat_ids` like '688,%' or `cat_ids` like '%,688' or `cat_ids` like '%,688,%') and (`cat_ids` = '691' or `cat_ids` like '691,%' or `cat_ids` like '%,691' or `cat_ids` like '%,691,%') and (`cat_ids` = '692' or `cat_ids` like '692,%' or `cat_ids` like '%,692' or `cat_ids` like '%,692,%') and (`cat_ids` = '694' or `cat_ids` like '694,%' or `cat_ids` like '%,694' or `cat_ids` like '%,694,%') and (`cat_ids` = '1236' or `cat_ids` like '1236,%' or `cat_ids` like '%,1236' or `cat_ids` like '%,1236,%') and (`cat_ids` = '1237' or `cat_ids` like '1237,%' or `cat_ids` like '%,1237' or `cat_ids` like '%,1237,%') and (`cat_ids` = '1238' or `cat_ids` like '1238,%' or `cat_ids` like '%,1238' or `cat_ids` like '%,1238,%') and (`cat_ids` = '1239' or `cat_ids` like '1239,%' or `cat_ids` like '%,1239' or `cat_ids` like '%,1239,%') and (`cat_ids` = '1240' or `cat_ids` like '1240,%' or `cat_ids` like '%,1240' or `cat_ids` like '%,1240,%') and (`cat_ids` = '1241' or `cat_ids` like '1241,%' or `cat_ids` like '%,1241' or `cat_ids` like '%,1241,%') and (`cat_ids` = '1242' or `cat_ids` like '1242,%' or `cat_ids` like '%,1242' or `cat_ids` like '%,1242,%') and (`cat_ids` = '1243' or `cat_ids` like '1243,%' or `cat_ids` like '%,1243' or `cat_ids` like '%,1243,%') and (`cat_ids` = '1089' or `cat_ids` like '1089,%' or `cat_ids` like '%,1089' or `cat_ids` like '%,1089,%') and (`cat_ids` = '1090' or `cat_ids` like '1090,%' or `cat_ids` like '%,1090' or `cat_ids` like '%,1090,%') and (`cat_ids` = '1091' or `cat_ids` like '1091,%' or `cat_ids` like '%,1091' or `cat_ids` like '%,1091,%') and (`cat_ids` = '732' or `cat_ids` like '732,%' or `cat_ids` like '%,732' or `cat_ids` like '%,732,%') and (`cat_ids` = '1094' or `cat_ids` like '1094,%' or `cat_ids` like '%,1094' or `cat_ids` like '%,1094,%') and (`cat_ids` = '738' or `cat_ids` like '738,%' or `cat_ids` like '%,738' or `cat_ids` like '%,738,%') and (`cat_ids` = '1263' or `cat_ids` like '1263,%' or `cat_ids` like '%,1263' or `cat_ids` like '%,1263,%') and (`cat_ids` = '1264' or `cat_ids` like '1264,%' or `cat_ids` like '%,1264' or `cat_ids` like '%,1264,%') and (`cat_ids` = '1265' or `cat_ids` like '1265,%' or `cat_ids` like '%,1265' or `cat_ids` like '%,1265,%') and (`cat_ids` = '1266' or `cat_ids` like '1266,%' or `cat_ids` like '%,1266' or `cat_ids` like '%,1266,%') and (`cat_ids` = '922' or `cat_ids` like '922,%' or `cat_ids` like '%,922' or `cat_ids` like '%,922,%') and (`cat_ids` = '923' or `cat_ids` like '923,%' or `cat_ids` like '%,923' or `cat_ids` like '%,923,%')) and `ecs_goods`.`product_name` = '西安利君制药有限责任公司'
13.94msys_testMetadata | |
---|---|
Bindings |
|
Hints |
|
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` = 'm' or `cat_ids` like 'm,%' or `cat_ids` like '%,m' or `cat_ids` like '%,m,%') and (`cat_ids` = '12' or `cat_ids` like '12,%' or `cat_ids` like '%,12' or `cat_ids` like '%,12,%') and (`cat_ids` = '380' or `cat_ids` like '380,%' or `cat_ids` like '%,380' or `cat_ids` like '%,380,%') and (`cat_ids` = '696' or `cat_ids` like '696,%' or `cat_ids` like '%,696' or `cat_ids` like '%,696,%') and (`cat_ids` = '697' or `cat_ids` like '697,%' or `cat_ids` like '%,697' or `cat_ids` like '%,697,%') and (`cat_ids` = '698' or `cat_ids` like '698,%' or `cat_ids` like '%,698' or `cat_ids` like '%,698,%') and (`cat_ids` = '704' or `cat_ids` like '704,%' or `cat_ids` like '%,704' or `cat_ids` like '%,704,%') and (`cat_ids` = '706' or `cat_ids` like '706,%' or `cat_ids` like '%,706' or `cat_ids` like '%,706,%') and (`cat_ids` = '707' or `cat_ids` like '707,%' or `cat_ids` like '%,707' or `cat_ids` like '%,707,%') and (`cat_ids` = '709' or `cat_ids` like '709,%' or `cat_ids` like '%,709' or `cat_ids` like '%,709,%') and (`cat_ids` = '711' or `cat_ids` like '711,%' or `cat_ids` like '%,711' or `cat_ids` like '%,711,%') and (`cat_ids` = '714' or `cat_ids` like '714,%' or `cat_ids` like '%,714' or `cat_ids` like '%,714,%') and (`cat_ids` = '716' or `cat_ids` like '716,%' or `cat_ids` like '%,716' or `cat_ids` like '%,716,%') and (`cat_ids` = '717' or `cat_ids` like '717,%' or `cat_ids` like '%,717' or `cat_ids` like '%,717,%') and (`cat_ids` = '1244' or `cat_ids` like '1244,%' or `cat_ids` like '%,1244' or `cat_ids` like '%,1244,%') and (`cat_ids` = '1245' or `cat_ids` like '1245,%' or `cat_ids` like '%,1245' or `cat_ids` like '%,1245,%') and (`cat_ids` = '1246' or `cat_ids` like '1246,%' or `cat_ids` like '%,1246' or `cat_ids` like '%,1246,%') and (`cat_ids` = '1247' or `cat_ids` like '1247,%' or `cat_ids` like '%,1247' or `cat_ids` like '%,1247,%') and (`cat_ids` = '1248' or `cat_ids` like '1248,%' or `cat_ids` like '%,1248' or `cat_ids` like '%,1248,%') and (`cat_ids` = '1249' or `cat_ids` like '1249,%' or `cat_ids` like '%,1249' or `cat_ids` like '%,1249,%') and (`cat_ids` = '1250' or `cat_ids` like '1250,%' or `cat_ids` like '%,1250' or `cat_ids` like '%,1250,%') and (`cat_ids` = '1251' or `cat_ids` like '1251,%' or `cat_ids` like '%,1251' or `cat_ids` like '%,1251,%') and (`cat_ids` = '1252' or `cat_ids` like '1252,%' or `cat_ids` like '%,1252' or `cat_ids` like '%,1252,%') and (`cat_ids` = '1253' or `cat_ids` like '1253,%' or `cat_ids` like '%,1253' or `cat_ids` like '%,1253,%') and (`cat_ids` = '1254' or `cat_ids` like '1254,%' or `cat_ids` like '%,1254' or `cat_ids` like '%,1254,%') and (`cat_ids` = '1255' or `cat_ids` like '1255,%' or `cat_ids` like '%,1255' or `cat_ids` like '%,1255,%') and (`cat_ids` = '1256' or `cat_ids` like '1256,%' or `cat_ids` like '%,1256' or `cat_ids` like '%,1256,%') and (`cat_ids` = '1257' or `cat_ids` like '1257,%' or `cat_ids` like '%,1257' or `cat_ids` like '%,1257,%') and (`cat_ids` = '1258' or `cat_ids` like '1258,%' or `cat_ids` like '%,1258' or `cat_ids` like '%,1258,%') and (`cat_ids` = '1259' or `cat_ids` like '1259,%' or `cat_ids` like '%,1259' or `cat_ids` like '%,1259,%') and (`cat_ids` = '1260' or `cat_ids` like '1260,%' or `cat_ids` like '%,1260' or `cat_ids` like '%,1260,%') and (`cat_ids` = '1261' or `cat_ids` like '1261,%' or `cat_ids` like '%,1261' or `cat_ids` like '%,1261,%') and (`cat_ids` = '1262' or `cat_ids` like '1262,%' or `cat_ids` like '%,1262' or `cat_ids` like '%,1262,%') and (`cat_ids` = '683' or `cat_ids` like '683,%' or `cat_ids` like '%,683' or `cat_ids` like '%,683,%') and (`cat_ids` = '685' or `cat_ids` like '685,%' or `cat_ids` like '%,685' or `cat_ids` like '%,685,%') and (`cat_ids` = '686' or `cat_ids` like '686,%' or `cat_ids` like '%,686' or `cat_ids` like '%,686,%') and (`cat_ids` = '687' or `cat_ids` like '687,%' or `cat_ids` like '%,687' or `cat_ids` like '%,687,%') and (`cat_ids` = '688' or `cat_ids` like '688,%' or `cat_ids` like '%,688' or `cat_ids` like '%,688,%') and (`cat_ids` = '691' or `cat_ids` like '691,%' or `cat_ids` like '%,691' or `cat_ids` like '%,691,%') and (`cat_ids` = '692' or `cat_ids` like '692,%' or `cat_ids` like '%,692' or `cat_ids` like '%,692,%') and (`cat_ids` = '694' or `cat_ids` like '694,%' or `cat_ids` like '%,694' or `cat_ids` like '%,694,%') and (`cat_ids` = '1236' or `cat_ids` like '1236,%' or `cat_ids` like '%,1236' or `cat_ids` like '%,1236,%') and (`cat_ids` = '1237' or `cat_ids` like '1237,%' or `cat_ids` like '%,1237' or `cat_ids` like '%,1237,%') and (`cat_ids` = '1238' or `cat_ids` like '1238,%' or `cat_ids` like '%,1238' or `cat_ids` like '%,1238,%') and (`cat_ids` = '1239' or `cat_ids` like '1239,%' or `cat_ids` like '%,1239' or `cat_ids` like '%,1239,%') and (`cat_ids` = '1240' or `cat_ids` like '1240,%' or `cat_ids` like '%,1240' or `cat_ids` like '%,1240,%') and (`cat_ids` = '1241' or `cat_ids` like '1241,%' or `cat_ids` like '%,1241' or `cat_ids` like '%,1241,%') and (`cat_ids` = '1242' or `cat_ids` like '1242,%' or `cat_ids` like '%,1242' or `cat_ids` like '%,1242,%') and (`cat_ids` = '1243' or `cat_ids` like '1243,%' or `cat_ids` like '%,1243' or `cat_ids` like '%,1243,%') and (`cat_ids` = '1089' or `cat_ids` like '1089,%' or `cat_ids` like '%,1089' or `cat_ids` like '%,1089,%') and (`cat_ids` = '1090' or `cat_ids` like '1090,%' or `cat_ids` like '%,1090' or `cat_ids` like '%,1090,%') and (`cat_ids` = '1091' or `cat_ids` like '1091,%' or `cat_ids` like '%,1091' or `cat_ids` like '%,1091,%') and (`cat_ids` = '732' or `cat_ids` like '732,%' or `cat_ids` like '%,732' or `cat_ids` like '%,732,%') and (`cat_ids` = '1094' or `cat_ids` like '1094,%' or `cat_ids` like '%,1094' or `cat_ids` like '%,1094,%') and (`cat_ids` = '738' or `cat_ids` like '738,%' or `cat_ids` like '%,738' or `cat_ids` like '%,738,%') and (`cat_ids` = '1263' or `cat_ids` like '1263,%' or `cat_ids` like '%,1263' or `cat_ids` like '%,1263,%') and (`cat_ids` = '1264' or `cat_ids` like '1264,%' or `cat_ids` like '%,1264' or `cat_ids` like '%,1264,%') and (`cat_ids` = '1265' or `cat_ids` like '1265,%' or `cat_ids` like '%,1265' or `cat_ids` like '%,1265,%') and (`cat_ids` = '1266' or `cat_ids` like '1266,%' or `cat_ids` like '%,1266' or `cat_ids` like '%,1266,%') and (`cat_ids` = '922' or `cat_ids` like '922,%' or `cat_ids` like '%,922' or `cat_ids` like '%,922,%') and (`cat_ids` = '923' or `cat_ids` like '923,%' or `cat_ids` like '%,923' or `cat_ids` like '%,923,%')) 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
21.86msys_testMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `ecs_miaosha_group_region` where `region_id` = '8'
2.99msys_testMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `ecs_miaosha_group` where `start_time` <= '2025-04-30 03:13:08' and `end_time` > '2025-04-30 03:13:08' 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
3.28msys_testMetadata | |
---|---|
Bindings |
|
Hints |
|
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` = 'm' or `cat_ids` like 'm,%' or `cat_ids` like '%,m' or `cat_ids` like '%,m,%') and (`cat_ids` = '12' or `cat_ids` like '12,%' or `cat_ids` like '%,12' or `cat_ids` like '%,12,%') and (`cat_ids` = '380' or `cat_ids` like '380,%' or `cat_ids` like '%,380' or `cat_ids` like '%,380,%') and (`cat_ids` = '696' or `cat_ids` like '696,%' or `cat_ids` like '%,696' or `cat_ids` like '%,696,%') and (`cat_ids` = '697' or `cat_ids` like '697,%' or `cat_ids` like '%,697' or `cat_ids` like '%,697,%') and (`cat_ids` = '698' or `cat_ids` like '698,%' or `cat_ids` like '%,698' or `cat_ids` like '%,698,%') and (`cat_ids` = '704' or `cat_ids` like '704,%' or `cat_ids` like '%,704' or `cat_ids` like '%,704,%') and (`cat_ids` = '706' or `cat_ids` like '706,%' or `cat_ids` like '%,706' or `cat_ids` like '%,706,%') and (`cat_ids` = '707' or `cat_ids` like '707,%' or `cat_ids` like '%,707' or `cat_ids` like '%,707,%') and (`cat_ids` = '709' or `cat_ids` like '709,%' or `cat_ids` like '%,709' or `cat_ids` like '%,709,%') and (`cat_ids` = '711' or `cat_ids` like '711,%' or `cat_ids` like '%,711' or `cat_ids` like '%,711,%') and (`cat_ids` = '714' or `cat_ids` like '714,%' or `cat_ids` like '%,714' or `cat_ids` like '%,714,%') and (`cat_ids` = '716' or `cat_ids` like '716,%' or `cat_ids` like '%,716' or `cat_ids` like '%,716,%') and (`cat_ids` = '717' or `cat_ids` like '717,%' or `cat_ids` like '%,717' or `cat_ids` like '%,717,%') and (`cat_ids` = '1244' or `cat_ids` like '1244,%' or `cat_ids` like '%,1244' or `cat_ids` like '%,1244,%') and (`cat_ids` = '1245' or `cat_ids` like '1245,%' or `cat_ids` like '%,1245' or `cat_ids` like '%,1245,%') and (`cat_ids` = '1246' or `cat_ids` like '1246,%' or `cat_ids` like '%,1246' or `cat_ids` like '%,1246,%') and (`cat_ids` = '1247' or `cat_ids` like '1247,%' or `cat_ids` like '%,1247' or `cat_ids` like '%,1247,%') and (`cat_ids` = '1248' or `cat_ids` like '1248,%' or `cat_ids` like '%,1248' or `cat_ids` like '%,1248,%') and (`cat_ids` = '1249' or `cat_ids` like '1249,%' or `cat_ids` like '%,1249' or `cat_ids` like '%,1249,%') and (`cat_ids` = '1250' or `cat_ids` like '1250,%' or `cat_ids` like '%,1250' or `cat_ids` like '%,1250,%') and (`cat_ids` = '1251' or `cat_ids` like '1251,%' or `cat_ids` like '%,1251' or `cat_ids` like '%,1251,%') and (`cat_ids` = '1252' or `cat_ids` like '1252,%' or `cat_ids` like '%,1252' or `cat_ids` like '%,1252,%') and (`cat_ids` = '1253' or `cat_ids` like '1253,%' or `cat_ids` like '%,1253' or `cat_ids` like '%,1253,%') and (`cat_ids` = '1254' or `cat_ids` like '1254,%' or `cat_ids` like '%,1254' or `cat_ids` like '%,1254,%') and (`cat_ids` = '1255' or `cat_ids` like '1255,%' or `cat_ids` like '%,1255' or `cat_ids` like '%,1255,%') and (`cat_ids` = '1256' or `cat_ids` like '1256,%' or `cat_ids` like '%,1256' or `cat_ids` like '%,1256,%') and (`cat_ids` = '1257' or `cat_ids` like '1257,%' or `cat_ids` like '%,1257' or `cat_ids` like '%,1257,%') and (`cat_ids` = '1258' or `cat_ids` like '1258,%' or `cat_ids` like '%,1258' or `cat_ids` like '%,1258,%') and (`cat_ids` = '1259' or `cat_ids` like '1259,%' or `cat_ids` like '%,1259' or `cat_ids` like '%,1259,%') and (`cat_ids` = '1260' or `cat_ids` like '1260,%' or `cat_ids` like '%,1260' or `cat_ids` like '%,1260,%') and (`cat_ids` = '1261' or `cat_ids` like '1261,%' or `cat_ids` like '%,1261' or `cat_ids` like '%,1261,%') and (`cat_ids` = '1262' or `cat_ids` like '1262,%' or `cat_ids` like '%,1262' or `cat_ids` like '%,1262,%') and (`cat_ids` = '683' or `cat_ids` like '683,%' or `cat_ids` like '%,683' or `cat_ids` like '%,683,%') and (`cat_ids` = '685' or `cat_ids` like '685,%' or `cat_ids` like '%,685' or `cat_ids` like '%,685,%') and (`cat_ids` = '686' or `cat_ids` like '686,%' or `cat_ids` like '%,686' or `cat_ids` like '%,686,%') and (`cat_ids` = '687' or `cat_ids` like '687,%' or `cat_ids` like '%,687' or `cat_ids` like '%,687,%') and (`cat_ids` = '688' or `cat_ids` like '688,%' or `cat_ids` like '%,688' or `cat_ids` like '%,688,%') and (`cat_ids` = '691' or `cat_ids` like '691,%' or `cat_ids` like '%,691' or `cat_ids` like '%,691,%') and (`cat_ids` = '692' or `cat_ids` like '692,%' or `cat_ids` like '%,692' or `cat_ids` like '%,692,%') and (`cat_ids` = '694' or `cat_ids` like '694,%' or `cat_ids` like '%,694' or `cat_ids` like '%,694,%') and (`cat_ids` = '1236' or `cat_ids` like '1236,%' or `cat_ids` like '%,1236' or `cat_ids` like '%,1236,%') and (`cat_ids` = '1237' or `cat_ids` like '1237,%' or `cat_ids` like '%,1237' or `cat_ids` like '%,1237,%') and (`cat_ids` = '1238' or `cat_ids` like '1238,%' or `cat_ids` like '%,1238' or `cat_ids` like '%,1238,%') and (`cat_ids` = '1239' or `cat_ids` like '1239,%' or `cat_ids` like '%,1239' or `cat_ids` like '%,1239,%') and (`cat_ids` = '1240' or `cat_ids` like '1240,%' or `cat_ids` like '%,1240' or `cat_ids` like '%,1240,%') and (`cat_ids` = '1241' or `cat_ids` like '1241,%' or `cat_ids` like '%,1241' or `cat_ids` like '%,1241,%') and (`cat_ids` = '1242' or `cat_ids` like '1242,%' or `cat_ids` like '%,1242' or `cat_ids` like '%,1242,%') and (`cat_ids` = '1243' or `cat_ids` like '1243,%' or `cat_ids` like '%,1243' or `cat_ids` like '%,1243,%') and (`cat_ids` = '1089' or `cat_ids` like '1089,%' or `cat_ids` like '%,1089' or `cat_ids` like '%,1089,%') and (`cat_ids` = '1090' or `cat_ids` like '1090,%' or `cat_ids` like '%,1090' or `cat_ids` like '%,1090,%') and (`cat_ids` = '1091' or `cat_ids` like '1091,%' or `cat_ids` like '%,1091' or `cat_ids` like '%,1091,%') and (`cat_ids` = '732' or `cat_ids` like '732,%' or `cat_ids` like '%,732' or `cat_ids` like '%,732,%') and (`cat_ids` = '1094' or `cat_ids` like '1094,%' or `cat_ids` like '%,1094' or `cat_ids` like '%,1094,%') and (`cat_ids` = '738' or `cat_ids` like '738,%' or `cat_ids` like '%,738' or `cat_ids` like '%,738,%') and (`cat_ids` = '1263' or `cat_ids` like '1263,%' or `cat_ids` like '%,1263' or `cat_ids` like '%,1263,%') and (`cat_ids` = '1264' or `cat_ids` like '1264,%' or `cat_ids` like '%,1264' or `cat_ids` like '%,1264,%') and (`cat_ids` = '1265' or `cat_ids` like '1265,%' or `cat_ids` like '%,1265' or `cat_ids` like '%,1265,%') and (`cat_ids` = '1266' or `cat_ids` like '1266,%' or `cat_ids` like '%,1266' or `cat_ids` like '%,1266,%') and (`cat_ids` = '922' or `cat_ids` like '922,%' or `cat_ids` like '%,922' or `cat_ids` like '%,922,%') and (`cat_ids` = '923' or `cat_ids` like '923,%' or `cat_ids` like '%,923' or `cat_ids` like '%,923,%')) 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
14.63msys_testMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `ecs_ad` where `position_id` = '152' and `enabled` > '0' and `end_time` > '1745953988' order by `sort_order` desc, `ad_id` desc
3.08msys_testMetadata | |
---|---|
Bindings |
|
Hints |
|
select * from `ecs_ad` where `position_id` = '159' and `enabled` > '0' and `end_time` > '1745953988' order by `sort_order` desc, `ad_id` desc
3.08msys_testMetadata | |
---|---|
Bindings |
|
Hints |
|
select `name`, `url`, `opennew`, `id` from `ecs_nav` where `ifshow` = '1' and `type` = 'middle' and 1 = 1 order by `type` asc, `vieworder` asc
3.13msys_testMetadata | |
---|---|
Bindings |
|
select `cat_id`, `cat_name`, `sort_order` from `ecs_article_cat` where `cat_id` = '5' limit 1
2.88msys_testMetadata | |
---|---|
Bindings |
|
Hints |
|
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
3.01msys_testMetadata | |
---|---|
Bindings |
|