普药-博大医药网

热门搜索：

订单查询

购物车0

全部商品分类

药理分类：五官、皮肤及外用

药理分类：皮肤及外用药

药理分类：烧烫伤类

厂家首字母：
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
- Z

福州屏山制药有限公司

马应龙药业集团股份有限公司

汕头市美宝制药有限公司

天津达仁堂京万红药业有限公司

威海人生药业有限公司

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

效期

OTC

会员可见

龙珠软膏(马应龙)

马应龙药业集团股份有限公司

规格：10g

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

库存：充裕中包装：1

加入购物车

-

+
效期

Rx

会员可见

湿润烧伤膏(美宝）

汕头市美宝制药有限公司

规格：10g*3支 3

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

库存：充裕中包装：1

加入购物车

-

+
效期

OTC

会员可见

三黄膏

福州屏山制药有限公司

规格：20g 2

效期：2021-07-30 件装量：240

库存：充裕中包装：1

加入购物车

-

+
效期

OTC

会员可见

龙珠软膏

马应龙药业集团股份有限公司

规格：15g

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

库存：充裕中包装：1

加入购物车

-

+
效期

OTC

会员可见

京万红软膏(达仁堂)

天津达仁堂京万红药业有限公司

规格：20g F

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

库存：充裕中包装：1

加入购物车

-

+
效期

OTC

会员可见

丹芎瘢痕涂膜

威海人生药业有限公司

规格：40g

效期：2022-08-30 件装量：1

库存：充裕中包装：1

加入购物车

-

+

消息

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

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

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

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

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

500包邮全场满500元包邮

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

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

Messages Timeline Exceptions Views20 Route Queries37 Mails Session Request

431.82ms4MBGET puyao

Booting (115.32ms)
Application (333.15ms)

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 unique229.91ms

select id from ecs_sensitive_words where '' like concat('%', keywords, '%')10.35msys_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 ((`cat_ids` = '572' or `cat_ids` like '572,%' or `cat_ids` like '%,572' or `cat_ids` like '%,572,%'))

11.98msys_test

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 0 9. 572 10. 572,% 11. %,572 12. %,572,%
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 ((`cat_ids` = '572' or `cat_ids` like '572,%' or `cat_ids` like '%,572' or `cat_ids` like '%,572,%')) order by `ecs_goods_statistics`.`score` desc, `ecs_goods`.`sort_order` asc, `ecs_goods`.`goods_id` asc limit 40 offset 0

22.05msys_test

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 0 9. 572 10. 572,% 11. %,572 12. %,572,%
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 ('242', '1417', '1822', '8196', '8395', '9554')3.85msys_test
Metadata
Bindings
0. 242
1. 1417
2. 1822
3. 8196
4. 8395
5. 9554
select * from `ecs_goods_attribute` where `ecs_goods_attribute`.`goods_id` in ('242', '1417', '1822', '8196', '8395', '9554')3.59msys_test
Metadata
Bindings
0. 242
1. 1417
2. 1822
3. 8196
4. 8395
5. 9554
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 ('242', '1417', '1822', '8196', '8395', '9554')3.67msys_test
Metadata
Bindings
0. 1
1. 242
2. 1417
3. 1822
4. 8196
5. 8395
6. 9554
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` <= '1748807899' and `ecs_goods_zp`.`end` > '1748807899' 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 ('242', '1417', '1822', '8196', '8395', '9554') order by `ecs_goods_zp`.`goods_number` desc4.2msys_test
Metadata
Bindings
0. 1748807899
1. 1748807899
2. 0
3. 1
4. 0
5. 0
6. 242
7. 1417
8. 1822
9. 8196
10. 8395
11. 9554
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` <= '1748807899' and `ecs_goods_zp`.`end` > '1748807899' 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 ('242', '1417', '1822', '8196', '8395', '9554') order by `ecs_goods_zp`.`goods_number` desc3.91msys_test
Metadata
Bindings
0. 1748807899
1. 1748807899
2. 1
3. 1
4. 0
5. 242
6. 1417
7. 1822
8. 8196
9. 8395
10. 9554

Metadata
Bindings	0. 242 1. 1417 2. 1822 3. 8196 4. 8395 5. 9554

Metadata
Bindings	0. 242 1. 1417 2. 1822 3. 8196 4. 8395 5. 9554
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 1 1. 242 2. 1417 3. 1822 4. 8196 5. 8395 6. 9554

Metadata
Bindings	0. 1748807899 1. 1748807899 2. 0 3. 1 4. 0 5. 0 6. 242 7. 1417 8. 1822 9. 8196 10. 8395 11. 9554

Metadata
Bindings	0. 1748807899 1. 1748807899 2. 1 3. 1 4. 0 5. 242 6. 1417 7. 1822 8. 8196 9. 8395 10. 9554

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 ('7BB0CE706E302512E053752512ACAA06', '873E3470EA835A84E053752512AC465D', 'bd2c328f-103c-4d97-b7e3-b62f18e9e49a', '7BB0CE708AED2512E053752512ACAA06', '7BB0CE7065502512E053752512ACAA06', '7BB0CE70DDB12512E053752512ACAA06')

4.75msys_test

Metadata
Bindings	0. 1 1. 0 2. 0 3. 7BB0CE706E302512E053752512ACAA06 4. 873E3470EA835A84E053752512AC465D 5. bd2c328f-103c-4d97-b7e3-b62f18e9e49a 6. 7BB0CE708AED2512E053752512ACAA06 7. 7BB0CE7065502512E053752512ACAA06 8. 7BB0CE70DDB12512E053752512ACAA06

select * from `ecs_goods_zp_region` where `region_id` = '8'3.71msys_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 ('242', '1417', '1822', '8196', '8395', '9554') and `enabled` = '1' and `start` < '1748807899' and `end` > '1748807899' 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.97msys_test

Metadata

Metadata
Bindings	0. 242 1. 1417 2. 1822 3. 8196 4. 8395 5. 9554 6. 1 7. 1748807899 8. 1748807899 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. 242
1. 1417
2. 1822
3. 8196
4. 8395
5. 9554
6. 1
7. 1748807899
8. 1748807899
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'3.5msys_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-02 03:58:19' and `end_time` > '2025-06-02 03:58:19' 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.8msys_test

Metadata
Bindings	0. 2025-06-02 03:58:19 1. 2025-06-02 03:58:19 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 `product_name` 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 ((`cat_ids` = '572' or `cat_ids` like '572,%' or `cat_ids` like '%,572' or `cat_ids` like '%,572,%')) and `product_name` != '' group by `product_name` order by `ecs_goods_statistics`.`score` desc, `ecs_goods`.`sort_order` asc, `ecs_goods`.`goods_id` asc

13.21msys_test

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 0 9. 572 10. 572,% 11. %,572 12. %,572,% 13.
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` > '1748807899' order by `sort_order` desc, `ad_id` desc3.67msys_test
Metadata
Bindings
0. 152
1. 0
2. 1748807899
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` > '1748807899' order by `sort_order` desc, `ad_id` desc4.54msys_test
Metadata
Bindings
0. 159
1. 0
2. 1748807899
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.63msys_test
Metadata
Bindings
0. 1
1. middle

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

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

3.69msys_test

Metadata
Bindings	0. 242 1. 1 2. 1748807899 3. 1748807899
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.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-02 03:58:19' and `end_time` > '2025-06-02 03:58:19' 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.85msys_test

Metadata
Bindings	0. 2025-06-02 03:58:19 1. 2025-06-02 03:58:19 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` = '1417' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1748807899' and `end_time` >= '1748807899' limit 1

21.17msys_test

Metadata
Bindings	0. 1417 1. 1 2. 1748807899 3. 1748807899
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.22msys_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-02 03:58:19' and `end_time` > '2025-06-02 03:58:19' 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

7.62msys_test

Metadata
Bindings	0. 2025-06-02 03:58:19 1. 2025-06-02 03:58:19 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` = '1822' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1748807899' and `end_time` >= '1748807899' limit 1

5.54msys_test

Metadata
Bindings	0. 1822 1. 1 2. 1748807899 3. 1748807899
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.2msys_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-02 03:58:19' and `end_time` > '2025-06-02 03:58:19' 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.65msys_test

Metadata
Bindings	0. 2025-06-02 03:58:19 1. 2025-06-02 03:58:19 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` = '8196' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1748807899' and `end_time` >= '1748807899' limit 1

5.31msys_test

Metadata
Bindings	0. 8196 1. 1 2. 1748807899 3. 1748807899
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.53msys_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-02 03:58:19' and `end_time` > '2025-06-02 03:58:19' 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.53msys_test

Metadata
Bindings	0. 2025-06-02 03:58:19 1. 2025-06-02 03:58:19 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` = '8395' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1748807899' and `end_time` >= '1748807899' limit 1

6.41msys_test

Metadata
Bindings	0. 8395 1. 1 2. 1748807899 3. 1748807899
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'9.15msys_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-02 03:58:19' and `end_time` > '2025-06-02 03:58:19' 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.89msys_test

Metadata
Bindings	0. 2025-06-02 03:58:19 1. 2025-06-02 03:58:19 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` = '9554' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1748807899' and `end_time` >= '1748807899' limit 1

6.83msys_test

Metadata
Bindings	0. 9554 1. 1 2. 1748807899 3. 1748807899
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.45msys_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-02 03:58:19' and `end_time` > '2025-06-02 03:58:19' 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.86msys_test

Metadata
Bindings	0. 2025-06-02 03:58:19 1. 2025-06-02 03:58:19 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 13.42msys_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 63.54msys_test
Metadata
Bindings
0. 5
1. 1

_token: yndCiv47ojz3hafCuNKBN8ueLGCMHM4iH4dE4iZS
PHPDEBUGBAR_STACK_DATA: []
_previous: array:1 [ "url" => "http://pc-test.bdyyw.com.cn/search_goods?cat_id=1140&product_name=H.Lundbeck%2...
flash: array:2 [ "old" => [] "new" => [] ]

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: array:3 [ "cat_id" => "572" "kc" => "1" "style" => "g" ]
request_request: array:3 [ "cat_id" => "572" "kc" => "1" "style" => "g" ]
request_headers: array:11 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IllSN3Q5M2lubzRybFREY3FKVjFlU0E9PSIs...
request_server: array:36 [ "USER" => "apache" "HOME" => "/usr/share/httpd" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdi...
request_cookies: array:2 [ "XSRF-TOKEN" => "yndCiv47ojz3hafCuNKBN8ueLGCMHM4iH4dE4iZS" "laravel_session_17" => "5b...
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "date" => array:1 [ 0 => "Sun...
path_info: /puyao
session_attributes: array:4 [ "_token" => "yndCiv47ojz3hafCuNKBN8ueLGCMHM4iH4dE4iZS" "PHPDEBUGBAR_STACK_DATA" => [] ...

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