普药-博大医药网

热门搜索：

订单查询

购物车0

全部商品分类

药品筛选

北京诺华制药有限公司

药理分类：

更多

收起
规格：

共6个商品每页显示40 个商品 1 / 1

效期

Rx

会员可见

缬沙坦胶囊(代文)（医）

北京诺华制药有限公司

规格：80mg*7粒

效期：2021-05-31 件装量：320

库存：充裕中包装：1

加入购物车

-

+
效期

Rx

会员可见

盐酸贝那普利片(洛汀新)（医）

北京诺华制药有限公司

规格：10mg*14片

效期：2021-06-01 件装量：240

库存：充裕中包装：1

加入购物车

-

+
效期

Rx

会员可见

缬沙坦胶囊

北京诺华制药有限公司

规格：80mg*28粒

效期：2022-01-31 件装量：128

库存：充裕中包装：1

加入购物车

-

+
效期

Rx

会员可见

缬沙坦氨氯地平片（I) （倍博特）

北京诺华制药有限公司

规格：28片 E

效期：2022-02-28 件装量：192

库存：充裕中包装：1

加入购物车

-

+
效期

Rx

会员可见

盐酸贝那普利片(洛汀新)（医）

北京诺华制药有限公司

规格：5mg*14片

效期：2021-05-31 件装量：300

库存：充裕中包装：1

加入购物车

-

+
效期

Rx

会员可见

缬沙坦氨氯地平片(倍博特)（医）

北京诺华制药有限公司

规格：80mg/5mg*7片

效期：2021-08-01 件装量：320

库存：充裕中包装：1

加入购物车

-

+

消息

正品保障国家认证，正规合法

45家一级供应商实力厂家，品质保证

首营资质一键查询，方便快捷

无忧售后售后保障，追求品质

百强企业多仓发货，极速配送

500包邮全场满500元包邮

营业执照统一社会信用代码：91520100770588680F 药品经营许可证：黔AA8510019 医疗器械经营许可证：黔筑二类医疗器械经营备案：黔筑食品经营许可证：JY15201020202360

本网站未发布毒性药品、麻醉药品、精神药品、放射性药品、戒毒药品和医疗机构制剂的产品信息

Messages Timeline Exceptions Views20 Route Queries37 Mails Session Request

487.35ms4MBGET puyao

Booting (161.52ms)
Application (347.93ms)

20 templates were rendered

yaoyigou.goods.index (resources/views_new/yaoyigou/goods/index.blade.php)9blade
Params
0
result
1
jx
2
sccj
3
ypgg
4
cxGoods
5
category
6
navName
7
title
8
dh_check
yaoyigou.layouts.header (resources/views_new/yaoyigou/layouts/header.blade.php)16blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
yaoyigou.ads.top-ad (resources/views_new/yaoyigou/ads/top-ad.blade.php)17blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
16
ad
yaoyigou.layouts.search (resources/views_new/yaoyigou/layouts/search.blade.php)16blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
yaoyigou.layouts.logo (resources/views_new/yaoyigou/layouts/logo.blade.php)16blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
yaoyigou.ads.hot-search (resources/views_new/yaoyigou/ads/hot-search.blade.php)17blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
16
ads
yaoyigou.layouts.nav (resources/views_new/yaoyigou/layouts/nav.blade.php)16blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter

Params
0	`result`
1	`jx`
2	`sccj`
3	`ypgg`
4	`cxGoods`
5	`category`
6	`navName`
7	`title`
8	`dh_check`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`
16	`ad`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`
16	`ads`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`

layouts.nav_top (resources/views_new/layouts/nav_top.blade.php)16blade


obLevel
__env
app
ad152
rand_num
errors
result
jx
sccj
ypgg
cxGoods
category
navName
title
dh_check
goodsPresenter

yaoyigou.goods.shaixuan (resources/views_new/yaoyigou/goods/shaixuan.blade.php)16blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
yaoyigou.goods.datu (resources/views_new/yaoyigou/goods/datu.blade.php)16blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
16
v
17
k
yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
16
v
17
k
yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
16
v
17
k
yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
16
v
17
k
yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
16
v
17
k
yaoyigou.goods.datu-item (resources/views_new/yaoyigou/goods/datu-item.blade.php)18blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
16
v
17
k
yaoyigou.vendor.pagination.default (resources/views_new/yaoyigou/vendor/pagination/default.blade.php)2blade
Params
0
paginator
1
elements
yaoyigou.layouts.footer (resources/views_new/yaoyigou/layouts/footer.blade.php)16blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
yaoyigou.layouts.youce (resources/views_new/yaoyigou/layouts/youce.blade.php)16blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter
yaoyigou.layouts.app (resources/views_new/yaoyigou/layouts/app.blade.php)16blade
Params
0
obLevel
1
__env
2
app
3
ad152
4
rand_num
5
errors
6
result
7
jx
8
sccj
9
ypgg
10
cxGoods
11
category
12
navName
13
title
14
dh_check
15
goodsPresenter

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`
16	`v`
17	`k`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`
16	`v`
17	`k`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`
16	`v`
17	`k`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`
16	`v`
17	`k`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`
16	`v`
17	`k`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`
16	`v`
17	`k`

Params
0	`paginator`
1	`elements`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`ad152`
4	`rand_num`
5	`errors`
6	`result`
7	`jx`
8	`sccj`
9	`ypgg`
10	`cxGoods`
11	`category`
12	`navName`
13	`title`
14	`dh_check`
15	`goodsPresenter`

uri: GET puyao
as: puyao
controller: App\Http\Controllers\Yaoyigou\GoodsController@puyao
namespace: App\Http\Controllers
prefix: null
where
file: app/Http/Controllers/Yaoyigou/GoodsController.php:67-87

37 statements were executed, 13 of which were duplicated, 24 unique198.79ms

select id from ecs_sensitive_words where '' like concat('%', keywords, '%')9.73msys_test
Metadata
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 `ecs_goods`.`goods_number` > '0' and `ecs_goods`.`product_name` = '北京诺华制药有限公司'10.72msys_test
Metadata
Bindings
0. 0
1. 0
2. 1
3. 1,2,5,7,8,9
4. %%
5. %%
6. %%
7. %%
8. 0
9. 北京诺华制药有限公司
Hints
The != operator is not standard. Use the <> operator to test for inequality instead.
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 `ecs_goods`.`goods_number` > '0' 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 018.74msys_test
Metadata
Bindings
0. 0
1. 0
2. 1
3. 1,2,5,7,8,9
4. %%
5. %%
6. %%
7. %%
8. 0
9. 北京诺华制药有限公司
Hints
The != operator is not standard. Use the <> operator to test for inequality instead.
select `goods_id`, `attr_id`, `attr_value` from `ecs_goods_attr` where `ecs_goods_attr`.`goods_id` in ('581', '579', '2771', '3181', '9155', '9437')3.09msys_test
Metadata
Bindings
0. 581
1. 579
2. 2771
3. 3181
4. 9155
5. 9437
select * from `ecs_goods_attribute` where `ecs_goods_attribute`.`goods_id` in ('581', '579', '2771', '3181', '9155', '9437')6.54msys_test
Metadata
Bindings
0. 581
1. 579
2. 2771
3. 3181
4. 9155
5. 9437
Hints
Use SELECT * only if you need all columns from table
select `goods_id`, `user_price`, `kx_price`, `aba_price` from `ecs_member_price` where `user_rank` = '1' and `ecs_member_price`.`goods_id` in ('581', '579', '2771', '3181', '9155', '9437')2.97msys_test
Metadata
Bindings
0. 1
1. 581
2. 579
3. 2771
4. 3181
5. 9155
6. 9437
select `ecs_zp_goods`.`goods_id`, `ecs_zp_goods`.`goods_name`, `ecs_zp_goods`.`shop_price`, `ecs_zp_goods`.`qyhy_price`, `ecs_zp_goods`.`is_kxpz`, `ecs_zp_goods`.`product_name`, `ecs_zp_goods`.`is_promote`, `ecs_zp_goods`.`promote_price`, `ecs_zp_goods`.`promote_start_date`, `ecs_zp_goods`.`promote_end_date`, `ecs_zp_goods`.`is_xkh_tj`, `ecs_zp_goods`.`xg_type`, `ecs_zp_goods`.`xg_start_date`, `ecs_zp_goods`.`xg_end_date`, `ecs_zp_goods`.`xrtj_xg_num`, `ecs_zp_goods`.`ls_ggg`, `ecs_zp_goods`.`is_on_sale`, `ecs_zp_goods`.`cat_ids`, `ecs_zp_goods`.`show_area`, `ecs_zp_goods`.`ERPID`, `ecs_zp_goods`.`xq`, `ecs_zp_goods`.`ckid`, `ecs_zp_goods`.`goods_number`, `ecs_zp_goods`.`ls_gg`, `ecs_zp_goods`.`goods_img`, `ecs_zp_goods`.`goods_thumb`, `ecs_zp_goods`.`zyzk`, `ecs_zp_goods`.`tsbz`, `ecs_zp_goods`.`erp_shangplx`, `ecs_zp_goods`.`is_alone_sale`, `ecs_zp_goods`.`is_delete`, `ecs_zp_goods`.`ls_buy_user_id`, `ecs_zp_goods`.`ls_regions`, `ecs_zp_goods`.`zs_regions`, `ecs_zp_goods`.`yy_regions`, `ecs_zp_goods`.`zs_user_ids`, `ecs_zp_goods`.`yy_user_ids`, `ecs_zp_goods`.`ls_ranks`, `ecs_zp_goods`.`ls_user_ids`, `ecs_goods_zp`.`goods_id` as `pivot_goods_id`, `ecs_goods_zp`.`zp_id` as `pivot_zp_id`, `ecs_goods_zp`.`goods_number` as `pivot_goods_number`, `ecs_goods_zp`.`zp_number` as `pivot_zp_number`, `ecs_goods_zp`.`message` as `pivot_message`, `ecs_goods_zp`.`type` as `pivot_type`, `ecs_goods_zp`.`is_erp` as `pivot_is_erp`, `ecs_goods_zp`.`is_goods` as `pivot_is_goods`, `ecs_goods_zp`.`is_give` as `pivot_is_give` from `ecs_zp_goods` inner join `ecs_goods_zp` on `ecs_zp_goods`.`goods_id` = `ecs_goods_zp`.`zp_id` where `ecs_goods_zp`.`start` <= '1755137513' and `ecs_goods_zp`.`end` > '1755137513' and `ecs_goods_zp`.`is_goods` = '0' and `ecs_goods_zp`.`zp_number` <= ecs_zp_goods.goods_number and `ecs_goods_zp`.`enabled` = '1' and `ecs_goods_zp`.`is_delete` = '0' and `ecs_zp_goods`.`goods_number` > '0' and `ecs_goods_zp`.`goods_id` in ('581', '579', '2771', '3181', '9155', '9437') order by `ecs_goods_zp`.`goods_number` desc3.32msys_test
Metadata
Bindings
0. 1755137513
1. 1755137513
2. 0
3. 1
4. 0
5. 0
6. 581
7. 579
8. 2771
9. 3181
10. 9155
11. 9437
select `ecs_goods`.`goods_sn`, `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`.`erp_shangplx`, `ecs_goods`.`is_delete`, `ecs_goods`.`ls_buy_user_id`, `ecs_goods`.`ls_regions`, `ecs_goods`.`zs_regions`, `ecs_goods`.`yy_regions`, `ecs_goods`.`zs_user_ids`, `ecs_goods`.`yy_user_ids`, `ecs_goods`.`ls_ranks`, `ecs_goods`.`ls_user_ids`, `ecs_goods_zp`.`goods_id` as `pivot_goods_id`, `ecs_goods_zp`.`zp_id` as `pivot_zp_id`, `ecs_goods_zp`.`goods_number` as `pivot_goods_number`, `ecs_goods_zp`.`zp_number` as `pivot_zp_number`, `ecs_goods_zp`.`message` as `pivot_message`, `ecs_goods_zp`.`type` as `pivot_type`, `ecs_goods_zp`.`is_erp` as `pivot_is_erp`, `ecs_goods_zp`.`is_goods` as `pivot_is_goods`, `ecs_goods_zp`.`is_give` as `pivot_is_give` from `ecs_goods` inner join `ecs_goods_zp` on `ecs_goods`.`goods_id` = `ecs_goods_zp`.`zp_id` where `ecs_goods_zp`.`start` <= '1755137513' and `ecs_goods_zp`.`end` > '1755137513' and `ecs_goods_zp`.`is_goods` = '1' and `ecs_goods_zp`.`enabled` = '1' and `ecs_goods_zp`.`is_delete` = '0' and `ecs_goods_zp`.`goods_id` in ('581', '579', '2771', '3181', '9155', '9437') order by `ecs_goods_zp`.`goods_number` desc3.14msys_test
Metadata
Bindings
0. 1755137513
1. 1755137513
2. 1
3. 1
4. 0
5. 581
6. 579
7. 2771
8. 3181
9. 9155
10. 9437

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 0 9. 北京诺华制药有限公司
Hints	The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 0 9. 北京诺华制药有限公司
Hints	The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.

Metadata
Bindings	0. 581 1. 579 2. 2771 3. 3181 4. 9155 5. 9437

Metadata
Bindings	0. 581 1. 579 2. 2771 3. 3181 4. 9155 5. 9437
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 1 1. 581 2. 579 3. 2771 4. 3181 5. 9155 6. 9437

Metadata
Bindings	0. 1755137513 1. 1755137513 2. 0 3. 1 4. 0 5. 0 6. 581 7. 579 8. 2771 9. 3181 10. 9155 11. 9437

Metadata
Bindings	0. 1755137513 1. 1755137513 2. 1 3. 1 4. 0 5. 581 6. 579 7. 2771 8. 3181 9. 9155 10. 9437

select `ERPID`, `ckid`, `goods_number`, `goods_price`, `xq` from `ecs_spkc_tj` where `is_on_sale` = '1' and `goods_number` > '0' and `goods_price` > '0' and `ecs_spkc_tj`.`ERPID` in ('7BB0CE70A7C52512E053752512ACAA06', '7BB0CE70AF4E2512E053752512ACAA06', '3eead2aa-8717-4107-8fd9-d9dfe5b4da31', '4baafef9-5afb-4113-bebc-a312c1718286', '7BB0CE70AB172512E053752512ACAA06', '7BB0CE70C0C72512E053752512ACAA06')

2.87msys_test

Metadata
Bindings	0. 1 1. 0 2. 0 3. 7BB0CE70A7C52512E053752512ACAA06 4. 7BB0CE70AF4E2512E053752512ACAA06 5. 3eead2aa-8717-4107-8fd9-d9dfe5b4da31 6. 4baafef9-5afb-4113-bebc-a312c1718286 7. 7BB0CE70AB172512E053752512ACAA06 8. 7BB0CE70C0C72512E053752512ACAA06

select * from `ecs_goods_zp_region` where `region_id` = '8'3.01msys_test
Metadata
Bindings
0. 8
Hints
Use SELECT * only if you need all columns from table

Metadata
Bindings	0. 8
Hints	Use `SELECT *` only if you need all columns from table

select * from `ecs_goods_zp` where `ecs_goods_zp`.`goods_id` in ('581', '579', '2771', '3181', '9155', '9437') and `enabled` = '1' and `start` < '1755137513' and `end` > '1755137513' and `is_delete` = '0' and `id` in ('1', '2', '3', '4', '5', '6', '7', '8', '9', '11', '12', '13', '14', '15', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '50', '51', '53', '54', '55', '58', '59', '62', '60', '61', '69', '72', '73', '75', '77', '76', '79', '80', '86', '85', '87')

3.32msys_test

Metadata

Metadata
Bindings	0. 581 1. 579 2. 2771 3. 3181 4. 9155 5. 9437 6. 1 7. 1755137513 8. 1755137513 9. 0 10. 1 11. 2 12. 3 13. 4 14. 5 15. 6 16. 7 17. 8 18. 9 19. 11 20. 12 21. 13 22. 14 23. 15 24. 17 25. 18 26. 19 27. 20 28. 21 29. 22 30. 23 31. 24 32. 25 33. 26 34. 27 35. 28 36. 29 37. 30 38. 31 39. 32 40. 33 41. 34 42. 35 43. 36 44. 37 45. 38 46. 39 47. 40 48. 41 49. 42 50. 43 51. 44 52. 45 53. 46 54. 47 55. 48 56. 49 57. 50 58. 51 59. 53 60. 54 61. 55 62. 58 63. 59 64. 62 65. 60 66. 61 67. 69 68. 72 69. 73 70. 75 71. 77 72. 76 73. 79 74. 80 75. 86 76. 85 77. 87
Hints	Use `SELECT *` only if you need all columns from table

Bindings

0. 581
1. 579
2. 2771
3. 3181
4. 9155
5. 9437
6. 1
7. 1755137513
8. 1755137513
9. 0
10. 1
11. 2
12. 3
13. 4
14. 5
15. 6
16. 7
17. 8
18. 9
19. 11
20. 12
21. 13
22. 14
23. 15
24. 17
25. 18
26. 19
27. 20
28. 21
29. 22
30. 23
31. 24
32. 25
33. 26
34. 27
35. 28
36. 29
37. 30
38. 31
39. 32
40. 33
41. 34
42. 35
43. 36
44. 37
45. 38
46. 39
47. 40
48. 41
49. 42
50. 43
51. 44
52. 45
53. 46
54. 47
55. 48
56. 49
57. 50
58. 51
59. 53
60. 54
61. 55
62. 58
63. 59
64. 62
65. 60
66. 61
67. 69
68. 72
69. 73
70. 75
71. 77
72. 76
73. 79
74. 80
75. 86
76. 85
77. 87

Hints

Use SELECT * only if you need all columns from table

select * from `ecs_miaosha_group_region` where `region_id` = '8'2.84msys_test
Metadata
Bindings
0. 8
Hints
Use SELECT * only if you need all columns from table

Metadata
Bindings	0. 8
Hints	Use `SELECT *` only if you need all columns from table

select * from `ecs_miaosha_group` where `start_time` <= '2025-08-14 10:11:53' and `end_time` > '2025-08-14 10:11:53' 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.09msys_test

Metadata
Bindings	0. 2025-08-14 10:11:53 1. 2025-08-14 10:11:53 2. 1 3. 2 4. 39 5. 1 6. 3 7. 4 8. 5 9. 7 10. 12 11. 15 12. 16 13. 17 14. 21 15. 24 16. 25 17. 33 18. 35 19. 40 20. 42 21. 43 22. 44 23. 45 24. 41 25. 48 26. 50 27. 54
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

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 `ecs_goods`.`goods_number` > '0' 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

11.78msys_test

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 0 9. 北京诺华制药有限公司 10.
Hints	The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.

select * from `ecs_ad` where `position_id` = '152' and `enabled` > '0' and `end_time` > '1755137514' order by `sort_order` desc, `ad_id` desc2.98msys_test
Metadata
Bindings
0. 152
1. 0
2. 1755137514
Hints
Use SELECT * only if you need all columns from table
select * from `ecs_ad` where `position_id` = '159' and `enabled` > '0' and `end_time` > '1755137514' order by `sort_order` desc, `ad_id` desc5.41msys_test
Metadata
Bindings
0. 159
1. 0
2. 1755137514
Hints
Use SELECT * only if you need all columns from table
select `name`, `url`, `opennew`, `id` from `ecs_nav` where `ifshow` = '1' and `type` = 'middle' and 1 = 1 order by `type` asc, `vieworder` asc8.34msys_test
Metadata
Bindings
0. 1
1. middle

Metadata
Bindings	0. 152 1. 0 2. 1755137514
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 159 1. 0 2. 1755137514
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 1 1. middle

select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '581' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1755137514' and `end_time` >= '1755137514' limit 1

8.49msys_test

Metadata
Bindings	0. 581 1. 1 2. 1755137514 3. 1755137514
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

select * from `ecs_miaosha_group_region` where `region_id` = '8'17.26msys_test
Metadata
Bindings
0. 8
Hints
Use SELECT * only if you need all columns from table

Metadata
Bindings	0. 8
Hints	Use `SELECT *` only if you need all columns from table

select * from `ecs_miaosha_group` where `start_time` <= '2025-08-14 10:11:54' and `end_time` > '2025-08-14 10:11:54' 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

4.79msys_test

Metadata
Bindings	0. 2025-08-14 10:11:54 1. 2025-08-14 10:11:54 2. 1 3. 2 4. 39 5. 1 6. 3 7. 4 8. 5 9. 7 10. 12 11. 15 12. 16 13. 17 14. 21 15. 24 16. 25 17. 33 18. 35 19. 40 20. 42 21. 43 22. 44 23. 45 24. 41 25. 48 26. 50 27. 54
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '579' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1755137514' and `end_time` >= '1755137514' limit 1

2.88msys_test

Metadata
Bindings	0. 579 1. 1 2. 1755137514 3. 1755137514
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

select * from `ecs_miaosha_group_region` where `region_id` = '8'2.86msys_test
Metadata
Bindings
0. 8
Hints
Use SELECT * only if you need all columns from table

Metadata
Bindings	0. 8
Hints	Use `SELECT *` only if you need all columns from table

select * from `ecs_miaosha_group` where `start_time` <= '2025-08-14 10:11:54' and `end_time` > '2025-08-14 10:11:54' 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

4.8msys_test

Metadata
Bindings	0. 2025-08-14 10:11:54 1. 2025-08-14 10:11:54 2. 1 3. 2 4. 39 5. 1 6. 3 7. 4 8. 5 9. 7 10. 12 11. 15 12. 16 13. 17 14. 21 15. 24 16. 25 17. 33 18. 35 19. 40 20. 42 21. 43 22. 44 23. 45 24. 41 25. 48 26. 50 27. 54
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '2771' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1755137514' and `end_time` >= '1755137514' limit 1

7.58msys_test

Metadata
Bindings	0. 2771 1. 1 2. 1755137514 3. 1755137514
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

select * from `ecs_miaosha_group_region` where `region_id` = '8'5.03msys_test
Metadata
Bindings
0. 8
Hints
Use SELECT * only if you need all columns from table

Metadata
Bindings	0. 8
Hints	Use `SELECT *` only if you need all columns from table

select * from `ecs_miaosha_group` where `start_time` <= '2025-08-14 10:11:54' and `end_time` > '2025-08-14 10:11:54' 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

4.31msys_test

Metadata
Bindings	0. 2025-08-14 10:11:54 1. 2025-08-14 10:11:54 2. 1 3. 2 4. 39 5. 1 6. 3 7. 4 8. 5 9. 7 10. 12 11. 15 12. 16 13. 17 14. 21 15. 24 16. 25 17. 33 18. 35 19. 40 20. 42 21. 43 22. 44 23. 45 24. 41 25. 48 26. 50 27. 54
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '3181' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1755137514' and `end_time` >= '1755137514' limit 1

2.86msys_test

Metadata
Bindings	0. 3181 1. 1 2. 1755137514 3. 1755137514
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

select * from `ecs_miaosha_group_region` where `region_id` = '8'5.88msys_test
Metadata
Bindings
0. 8
Hints
Use SELECT * only if you need all columns from table

Metadata
Bindings	0. 8
Hints	Use `SELECT *` only if you need all columns from table

select * from `ecs_miaosha_group` where `start_time` <= '2025-08-14 10:11:54' and `end_time` > '2025-08-14 10:11:54' 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

6.25msys_test

Metadata
Bindings	0. 2025-08-14 10:11:54 1. 2025-08-14 10:11:54 2. 1 3. 2 4. 39 5. 1 6. 3 7. 4 8. 5 9. 7 10. 12 11. 15 12. 16 13. 17 14. 21 15. 24 16. 25 17. 33 18. 35 19. 40 20. 42 21. 43 22. 44 23. 45 24. 41 25. 48 26. 50 27. 54
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '9155' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1755137514' and `end_time` >= '1755137514' limit 1

3.11msys_test

Metadata
Bindings	0. 9155 1. 1 2. 1755137514 3. 1755137514
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

select * from `ecs_miaosha_group_region` where `region_id` = '8'2.89msys_test
Metadata
Bindings
0. 8
Hints
Use SELECT * only if you need all columns from table

select * from `ecs_miaosha_group` where `start_time` <= '2025-08-14 10:11:54' and `end_time` > '2025-08-14 10:11:54' 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.16msys_test

Metadata
Bindings	0. 2025-08-14 10:11:54 1. 2025-08-14 10:11:54 2. 1 3. 2 4. 39 5. 1 6. 3 7. 4 8. 5 9. 7 10. 12 11. 15 12. 16 13. 17 14. 21 15. 24 16. 25 17. 33 18. 35 19. 40 20. 42 21. 43 22. 44 23. 45 24. 41 25. 48 26. 50 27. 54
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '9437' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1755137514' and `end_time` >= '1755137514' limit 1

2.84msys_test

Metadata
Bindings	0. 9437 1. 1 2. 1755137514 3. 1755137514
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

select * from `ecs_miaosha_group_region` where `region_id` = '8'2.97msys_test
Metadata
Bindings
0. 8
Hints
Use SELECT * only if you need all columns from table

select * from `ecs_miaosha_group` where `start_time` <= '2025-08-14 10:11:54' and `end_time` > '2025-08-14 10:11:54' 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.13msys_test

Metadata
Bindings	0. 2025-08-14 10:11:54 1. 2025-08-14 10:11:54 2. 1 3. 2 4. 39 5. 1 6. 3 7. 4 8. 5 9. 7 10. 12 11. 15 12. 16 13. 17 14. 21 15. 24 16. 25 17. 33 18. 35 19. 40 20. 42 21. 43 22. 44 23. 45 24. 41 25. 48 26. 50 27. 54
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan

select `cat_id`, `cat_name`, `sort_order` from `ecs_article_cat` where `cat_id` = '5' limit 12.81msys_test
Metadata
Bindings
0. 5
Hints
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
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 63msys_test
Metadata
Bindings
0. 5
1. 1

_token: x7maoVDHAigQg2YFWBGhoAoCQnij28caYivUcllk
PHPDEBUGBAR_STACK_DATA: []
_previous: array:1 [ "url" => "http://pc-test.bdyyw.com.cn/search_goods?cat_id=506&product_name=%E5%8C%97%E4%...
flash: array:2 [ "old" => [] "new" => [] ]

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: array:3 [ "kc" => "1" "product_name" => "北京诺华制药有限公司" "style" => "g" ]
request_request: array:3 [ "kc" => "1" "product_name" => "北京诺华制药有限公司" "style" => "g" ]
request_headers: array:13 [ "connection" => array:1 [ 0 => "keep-alive" ] "cache-control" => array:1 [ ...
request_server: array:38 [ "USER" => "apache" "HOME" => "/usr/share/httpd" "HTTP_CONNECTION" => "keep-alive" ...
request_cookies: array:2 [ "XSRF-TOKEN" => "x7maoVDHAigQg2YFWBGhoAoCQnij28caYivUcllk" "laravel_session_17" => "51...
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "date" => array:1 [ 0 => "Thu...
path_info: /puyao
session_attributes: array:4 [ "_token" => "x7maoVDHAigQg2YFWBGhoAoCQnij28caYivUcllk" "PHPDEBUGBAR_STACK_DATA" => [] ...

Metadata
Bindings	0. 5
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan