普药-博大医药网

热门搜索：

订单查询

购物车0

全部商品分类

药品筛选

宜昌东阳光长江药业股份有限公司

药理分类：

更多

收起
规格：

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

效期

Rx

会员可见

磷酸奥司他韦颗粒

宜昌东阳光长江药业股份有限公司

规格：15mg*12袋

效期：2021-09-18 件装量：200

库存：充裕中包装：1

加入购物车

-

+
效期

Rx

会员可见

磷酸奥司他韦颗粒

宜昌东阳光长江药业股份有限公司

规格：15mg*10袋

效期：2021-06-02 件装量：200

库存：充裕中包装：1

加入购物车

-

+
效期

Rx

会员可见

盐酸西替利嗪分散片(喜宁)

宜昌东阳光长江药业股份有限公司

规格：10mg*12片

效期：2021-07-01 件装量：300

库存：充裕中包装：1

加入购物车

-

+
效期

Rx

会员可见

磷酸奥司他韦颗粒(可威)

宜昌东阳光长江药业股份有限公司

规格：25mg*10袋

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

库存：充裕中包装：1

加入购物车

-

+
效期

Rx

会员可见

磷酸奥司他韦胶囊(可威)（医）

宜昌东阳光长江药业股份有限公司

规格：75mg*10粒

效期：2021-09-19 件装量：200

库存：充裕中包装：1

加入购物车

-

+
效期

Rx

会员可见

苯溴马隆片（医）

宜昌东阳光长江药业股份有限公司

规格：50mg*30片

效期：2021-07-11 件装量：200

库存：充裕中包装：1

加入购物车

-

+

消息

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

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

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

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

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

500包邮全场满500元包邮

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

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

Messages Timeline Exceptions Views20 Route Queries37 Mails Session Request

498.72ms4MBGET puyao

Booting (235.83ms)
Application (308.04ms)

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, 14 of which were duplicated, 23 unique148.94ms

select id from ecs_sensitive_words where '' like concat('%', keywords, '%')10.2msys_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` = '宜昌东阳光长江药业股份有限公司'

13.1msys_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 0

18.58msys_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 ('1531', '2933', '6962', '1313', '3728', '9143')3.9msys_test
Metadata
Bindings
0. 1531
1. 2933
2. 6962
3. 1313
4. 3728
5. 9143
select * from `ecs_goods_attribute` where `ecs_goods_attribute`.`goods_id` in ('1531', '2933', '6962', '1313', '3728', '9143')2.79msys_test
Metadata
Bindings
0. 1531
1. 2933
2. 6962
3. 1313
4. 3728
5. 9143
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 ('1531', '2933', '6962', '1313', '3728', '9143')2.67msys_test
Metadata
Bindings
0. 1
1. 1531
2. 2933
3. 6962
4. 1313
5. 3728
6. 9143
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` <= '1750642914' and `ecs_goods_zp`.`end` > '1750642914' 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 ('1531', '2933', '6962', '1313', '3728', '9143') order by `ecs_goods_zp`.`goods_number` desc3.12msys_test
Metadata
Bindings
0. 1750642914
1. 1750642914
2. 0
3. 1
4. 0
5. 0
6. 1531
7. 2933
8. 6962
9. 1313
10. 3728
11. 9143
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` <= '1750642914' and `ecs_goods_zp`.`end` > '1750642914' 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 ('1531', '2933', '6962', '1313', '3728', '9143') order by `ecs_goods_zp`.`goods_number` desc2.99msys_test
Metadata
Bindings
0. 1750642914
1. 1750642914
2. 1
3. 1
4. 0
5. 1531
6. 2933
7. 6962
8. 1313
9. 3728
10. 9143

Metadata
Bindings	0. 1531 1. 2933 2. 6962 3. 1313 4. 3728 5. 9143

Metadata
Bindings	0. 1531 1. 2933 2. 6962 3. 1313 4. 3728 5. 9143
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 1 1. 1531 2. 2933 3. 6962 4. 1313 5. 3728 6. 9143

Metadata
Bindings	0. 1750642914 1. 1750642914 2. 0 3. 1 4. 0 5. 0 6. 1531 7. 2933 8. 6962 9. 1313 10. 3728 11. 9143

Metadata
Bindings	0. 1750642914 1. 1750642914 2. 1 3. 1 4. 0 5. 1531 6. 2933 7. 6962 8. 1313 9. 3728 10. 9143

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 ('487cc0b6-118f-4559-94c4-216f57f7a67f', '949DC9CB47970740E053752512ACD1C4', '7BB0CE7066342512E053752512ACAA06', '7BB0CE70C9AD2512E053752512ACAA06', '84F7DC0468FC326DE053752512AC623C', '7BB0CE70E7B52512E053752512ACAA06')

4.48msys_test

Metadata
Bindings	0. 1 1. 0 2. 0 3. 487cc0b6-118f-4559-94c4-216f57f7a67f 4. 949DC9CB47970740E053752512ACD1C4 5. 7BB0CE7066342512E053752512ACAA06 6. 7BB0CE70C9AD2512E053752512ACAA06 7. 84F7DC0468FC326DE053752512AC623C 8. 7BB0CE70E7B52512E053752512ACAA06

select * from `ecs_goods_zp_region` where `region_id` = '8'2.79msys_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 ('1531', '2933', '6962', '1313', '3728', '9143') and `enabled` = '1' and `start` < '1750642914' and `end` > '1750642914' 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')

2.91msys_test

Metadata

Metadata
Bindings	0. 1531 1. 2933 2. 6962 3. 1313 4. 3728 5. 9143 6. 1 7. 1750642914 8. 1750642914 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. 1531
1. 2933
2. 6962
3. 1313
4. 3728
5. 9143
6. 1
7. 1750642914
8. 1750642914
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.67msys_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-06-23 09:41:54' and `end_time` > '2025-06-23 09:41: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.04msys_test

Metadata
Bindings	0. 2025-06-23 09:41:54 1. 2025-06-23 09:41: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 `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

10.59msys_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` > '1750642914' order by `sort_order` desc, `ad_id` desc3.01msys_test
Metadata
Bindings
0. 152
1. 0
2. 1750642914
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` > '1750642914' order by `sort_order` desc, `ad_id` desc2.67msys_test
Metadata
Bindings
0. 159
1. 0
2. 1750642914
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` asc3.02msys_test
Metadata
Bindings
0. 1
1. middle

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

Metadata
Bindings	0. 159 1. 0 2. 1750642914
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` = '1531' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750642914' and `end_time` >= '1750642914' limit 1

2.55msys_test

Metadata
Bindings	0. 1531 1. 1 2. 1750642914 3. 1750642914
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.62msys_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-06-23 09:41:54' and `end_time` > '2025-06-23 09:41: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

2.88msys_test

Metadata
Bindings	0. 2025-06-23 09:41:54 1. 2025-06-23 09:41: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` = '2933' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750642914' and `end_time` >= '1750642914' limit 1

2.58msys_test

Metadata
Bindings	0. 2933 1. 1 2. 1750642914 3. 1750642914
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'3.04msys_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-06-23 09:41:54' and `end_time` > '2025-06-23 09:41: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

2.78msys_test

Metadata
Bindings	0. 2025-06-23 09:41:54 1. 2025-06-23 09:41: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` = '6962' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750642914' and `end_time` >= '1750642914' limit 1

2.55msys_test

Metadata
Bindings	0. 6962 1. 1 2. 1750642914 3. 1750642914
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'4.6msys_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-06-23 09:41:54' and `end_time` > '2025-06-23 09:41: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

2.9msys_test

Metadata
Bindings	0. 2025-06-23 09:41:54 1. 2025-06-23 09:41: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` = '1313' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750642914' and `end_time` >= '1750642914' limit 1

2.54msys_test

Metadata
Bindings	0. 1313 1. 1 2. 1750642914 3. 1750642914
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.78msys_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-06-23 09:41:54' and `end_time` > '2025-06-23 09:41: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

2.79msys_test

Metadata
Bindings	0. 2025-06-23 09:41:54 1. 2025-06-23 09:41: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` = '3728' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750642914' and `end_time` >= '1750642914' limit 1

2.51msys_test

Metadata
Bindings	0. 3728 1. 1 2. 1750642914 3. 1750642914
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.55msys_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-06-23 09:41:54' and `end_time` > '2025-06-23 09:41: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

2.81msys_test

Metadata
Bindings	0. 2025-06-23 09:41:54 1. 2025-06-23 09:41: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` = '9143' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750642914' and `end_time` >= '1750642914' limit 1

2.79msys_test

Metadata
Bindings	0. 9143 1. 1 2. 1750642914 3. 1750642914
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.63msys_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-06-23 09:41:54' and `end_time` > '2025-06-23 09:41: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

2.95msys_test

Metadata
Bindings	0. 2025-06-23 09:41:54 1. 2025-06-23 09:41: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.58msys_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 62.98msys_test
Metadata
Bindings
0. 5
1. 1

_token: O9Cab2qFzmQ6ZnYQG69OhTfQAhpwlQvFe9yzqFnq
PHPDEBUGBAR_STACK_DATA: []
_previous: array:1 [ "url" => "http://pc-test.bdyyw.com.cn/puyao?cat_id=1189&product_name=%E5%8F%8C%E9%B9%A4%...
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" => "O9Cab2qFzmQ6ZnYQG69OhTfQAhpwlQvFe9yzqFnq" "laravel_session_17" => "15...
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "date" => array:1 [ 0 => "Mon...
path_info: /puyao
session_attributes: array:4 [ "_token" => "O9Cab2qFzmQ6ZnYQG69OhTfQAhpwlQvFe9yzqFnq" "PHPDEBUGBAR_STACK_DATA" => [] ...

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