普药-博大医药网

热门搜索：

订单查询

购物车0

全部商品分类

药品筛选

规格：10ML*6支 F

药理分类：

更多

收起

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

效期

OTC

会员可见

蛇胆川贝液(一力）

广东一力罗定制药有限公司

规格：10ml*6支 F

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

库存：充裕中包装：1

加入购物车

-

+
效期

OTC

会员可见

蓝芩口服液(扬子江)（医）

扬子江药业集团有限公司

规格：10ml*6支 F

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

库存：充裕中包装：1

加入购物车

-

+
效期

OTC

会员可见

化积口服液(诚志永丰)

江西诚志永丰药业有限责任公司

规格：10ml*6支 F

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

库存：充裕中包装：1

加入购物车

-

+
效期

Rx

会员可见

神曲消食口服液(扬子江）

#扬子江药业集团江苏龙凤堂中药有限公司

规格：10ml*6支 F

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

库存：充裕中包装：1

加入购物车

-

+
效期

OTC

会员可见

化积口服液(恩威)

恩威（江西）制药有限公司

规格：10ml*6支 F

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

库存：充裕中包装：1

加入购物车

-

+
效期

OTC

会员可见

小儿肺热咳喘口服液(葵花)

黑龙江葵花药业股份有限公司

规格：10ML*6支 F

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

库存：充裕中包装：1

加入购物车

-

+

消息

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

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

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

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

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

500包邮全场满500元包邮

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

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

Messages Timeline Exceptions Views20 Route Queries36 Mails Session Request

435.05ms4MBGET puyao

Booting (145.3ms)
Application (312.52ms)

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

36 statements were executed, 14 of which were duplicated, 22 unique181.56ms

select id from ecs_sensitive_words where '' like concat('%', keywords, '%')11.43msys_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`.`ypgg` = '10ML*6支 F'10.3msys_test
Metadata
Bindings
0. 0
1. 0
2. 1
3. 1,2,5,7,8,9
4. %%
5. %%
6. %%
7. %%
8. 10ML*6支 F
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`.`ypgg` = '10ML*6支 F' order by `ecs_goods_statistics`.`score` desc, `ecs_goods`.`sort_order` asc, `ecs_goods`.`goods_id` asc limit 40 offset 017msys_test
Metadata
Bindings
0. 0
1. 0
2. 1
3. 1,2,5,7,8,9
4. %%
5. %%
6. %%
7. %%
8. 10ML*6支 F
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 ('85', '208', '401', '1298', '7000', '7114')3.22msys_test
Metadata
Bindings
0. 85
1. 208
2. 401
3. 1298
4. 7000
5. 7114
select * from `ecs_goods_attribute` where `ecs_goods_attribute`.`goods_id` in ('85', '208', '401', '1298', '7000', '7114')2.96msys_test
Metadata
Bindings
0. 85
1. 208
2. 401
3. 1298
4. 7000
5. 7114
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 ('85', '208', '401', '1298', '7000', '7114')11.38msys_test
Metadata
Bindings
0. 1
1. 85
2. 208
3. 401
4. 1298
5. 7000
6. 7114
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` <= '1750277677' and `ecs_goods_zp`.`end` > '1750277677' 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 ('85', '208', '401', '1298', '7000', '7114') order by `ecs_goods_zp`.`goods_number` desc5.75msys_test
Metadata
Bindings
0. 1750277677
1. 1750277677
2. 0
3. 1
4. 0
5. 0
6. 85
7. 208
8. 401
9. 1298
10. 7000
11. 7114
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` <= '1750277677' and `ecs_goods_zp`.`end` > '1750277677' 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 ('85', '208', '401', '1298', '7000', '7114') order by `ecs_goods_zp`.`goods_number` desc3.56msys_test
Metadata
Bindings
0. 1750277677
1. 1750277677
2. 1
3. 1
4. 0
5. 85
6. 208
7. 401
8. 1298
9. 7000
10. 7114

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 10ML*6支 F
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. 10ML*6支 F
Hints	The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.

Metadata
Bindings	0. 85 1. 208 2. 401 3. 1298 4. 7000 5. 7114

Metadata
Bindings	0. 85 1. 208 2. 401 3. 1298 4. 7000 5. 7114
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 1 1. 85 2. 208 3. 401 4. 1298 5. 7000 6. 7114

Metadata
Bindings	0. 1750277677 1. 1750277677 2. 0 3. 1 4. 0 5. 0 6. 85 7. 208 8. 401 9. 1298 10. 7000 11. 7114

Metadata
Bindings	0. 1750277677 1. 1750277677 2. 1 3. 1 4. 0 5. 85 6. 208 7. 401 8. 1298 9. 7000 10. 7114

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 ('7BB0CE7071092512E053752512ACAA06', '7BB0CE70633E2512E053752512ACAA06', '7BB0CE7058D12512E053752512ACAA06', '7BB0CE70C8882512E053752512ACAA06', '7BB0CE7058D22512E053752512ACAA06', '7BB0CE7064342512E053752512ACAA06')

3.05msys_test

Metadata
Bindings	0. 1 1. 0 2. 0 3. 7BB0CE7071092512E053752512ACAA06 4. 7BB0CE70633E2512E053752512ACAA06 5. 7BB0CE7058D12512E053752512ACAA06 6. 7BB0CE70C8882512E053752512ACAA06 7. 7BB0CE7058D22512E053752512ACAA06 8. 7BB0CE7064342512E053752512ACAA06

select * from `ecs_goods_zp_region` where `region_id` = '8'5.13msys_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 ('85', '208', '401', '1298', '7000', '7114') and `enabled` = '1' and `start` < '1750277677' and `end` > '1750277677' 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')

7.82msys_test

Metadata

Metadata
Bindings	0. 85 1. 208 2. 401 3. 1298 4. 7000 5. 7114 6. 1 7. 1750277677 8. 1750277677 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. 85
1. 208
2. 401
3. 1298
4. 7000
5. 7114
6. 1
7. 1750277677
8. 1750277677
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'4.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-06-19 04:14:37' and `end_time` > '2025-06-19 04:14:37' 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.02msys_test

Metadata
Bindings	0. 2025-06-19 04:14:37 1. 2025-06-19 04:14:37 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_ad` where `position_id` = '152' and `enabled` > '0' and `end_time` > '1750277677' order by `sort_order` desc, `ad_id` desc2.97msys_test
Metadata
Bindings
0. 152
1. 0
2. 1750277677
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` > '1750277677' order by `sort_order` desc, `ad_id` desc5.91msys_test
Metadata
Bindings
0. 159
1. 0
2. 1750277677
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` asc5.68msys_test
Metadata
Bindings
0. 1
1. middle

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

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

3.14msys_test

Metadata
Bindings	0. 85 1. 1 2. 1750277677 3. 1750277677
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.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-19 04:14:37' and `end_time` > '2025-06-19 04:14:37' 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.45msys_test

Metadata
Bindings	0. 2025-06-19 04:14:37 1. 2025-06-19 04:14:37 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` = '208' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750277677' and `end_time` >= '1750277677' limit 1

2.81msys_test

Metadata
Bindings	0. 208 1. 1 2. 1750277677 3. 1750277677
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.02msys_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-19 04:14:37' and `end_time` > '2025-06-19 04:14:37' 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

3msys_test

Metadata
Bindings	0. 2025-06-19 04:14:37 1. 2025-06-19 04:14:37 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` = '401' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750277677' and `end_time` >= '1750277677' limit 1

2.82msys_test

Metadata
Bindings	0. 401 1. 1 2. 1750277677 3. 1750277677
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.77msys_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-19 04:14:37' and `end_time` > '2025-06-19 04:14:37' 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-19 04:14:37 1. 2025-06-19 04:14:37 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` = '1298' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750277677' and `end_time` >= '1750277677' limit 1

8.67msys_test

Metadata
Bindings	0. 1298 1. 1 2. 1750277677 3. 1750277677
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.87msys_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-19 04:14:37' and `end_time` > '2025-06-19 04:14:37' 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.14msys_test

Metadata
Bindings	0. 2025-06-19 04:14:37 1. 2025-06-19 04:14:37 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` = '7000' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750277677' and `end_time` >= '1750277677' limit 1

3.81msys_test

Metadata
Bindings	0. 7000 1. 1 2. 1750277677 3. 1750277677
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.76msys_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-19 04:14:37' and `end_time` > '2025-06-19 04:14:37' 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.42msys_test

Metadata
Bindings	0. 2025-06-19 04:14:37 1. 2025-06-19 04:14:37 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` = '7114' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1750277677' and `end_time` >= '1750277677' limit 1

6.03msys_test

Metadata
Bindings	0. 7114 1. 1 2. 1750277677 3. 1750277677
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.47msys_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-19 04:14:37' and `end_time` > '2025-06-19 04:14:37' 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.27msys_test

Metadata
Bindings	0. 2025-06-19 04:14:37 1. 2025-06-19 04:14:37 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 15.25msys_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.6msys_test
Metadata
Bindings
0. 5
1. 1

_token: m53cvI4t6ruurm4ATs0XYPYrwjlR6tebQShXK6Cl
PHPDEBUGBAR_STACK_DATA: []
_previous: array:1 [ "url" => "http://pc-test.bdyyw.com.cn/puyao?cat_id=d&product_name=%E6%8C%AF%E5%BE%B7%E5%...
flash: array:2 [ "old" => [] "new" => [] ]

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: array:2 [ "style" => "g" "ypgg" => "10ML*6支 F" ]
request_request: array:2 [ "style" => "g" "ypgg" => "10ML*6支 F" ]
request_headers: array:13 [ "connection" => array:1 [ 0 => "keep-alive" ] "cache-control" => array:1 [ ...
request_server: array:39 [ "USER" => "apache" "HOME" => "/usr/share/httpd" "ORACLE_HOME" => "/usr/lib/oracle/2...
request_cookies: array:2 [ "XSRF-TOKEN" => "m53cvI4t6ruurm4ATs0XYPYrwjlR6tebQShXK6Cl" "laravel_session_17" => "3a...
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "date" => array:1 [ 0 => "Wed...
path_info: /puyao
session_attributes: array:4 [ "_token" => "m53cvI4t6ruurm4ATs0XYPYrwjlR6tebQShXK6Cl" "PHPDEBUGBAR_STACK_DATA" => [] ...

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