商品搜索-博大医药网

热门搜索：

订单查询

购物车0

全部商品分类

药品筛选

石家庄四药有限公司

规格：

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

促销标识	产品名称	规格	单位	生产厂家	效期	件装量	中包装	数量	库存	会员价
效期 OTC	银黄胶囊(四药）银黄胶囊(四药）效期：2022-02-04	0.3g*32粒 2	个	石家庄四药有限公司	2022-02-04	300	1	- +	充裕	会员可见
效期 OTC	一清颗粒(四药) 一清颗粒(四药) 效期：2021-08-22	7.5g*9袋	盒	石家庄四药有限公司	2021-08-22	120	1	- +	充裕	会员可见
效期 Rx	头孢氨苄胶囊(四药）头孢氨苄胶囊(四药）效期：2021-08-08	0.125g*50粒	盒	石家庄四药有限公司	2021-08-08	300	1	- +	充裕	会员可见
效期 Rx	阿奇霉素分散片(四药... 阿奇霉素分散片(四药）效期：2022-01-17	0.25g*8片 1	个	石家庄四药有限公司	2022-01-17	400	1	- +	充裕	会员可见
效期 Rx	氟康唑片(四药）氟康唑片(四药）效期：2021-07-02	150mg*6片 1	盒	石家庄四药有限公司	2021-07-02	400	1	- +	充裕	会员可见
效期 Rx	盐酸阿比多尔胶囊（四... 盐酸阿比多尔胶囊（四药）效期：2021-07-12	0.1g*12粒	盒	石家庄四药有限公司	2021-07-12	99999	1	- +	充裕	会员可见

消息

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

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

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

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

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

500包邮全场满500元包邮

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

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

Messages Timeline Exceptions Views20 Route Queries36 Mails Session Request

1.12s4MBGET search_goods

Booting (593.33ms)
Application (570.37ms)

20 templates were rendered

yaoyigou.goods.index (resources/views_new/yaoyigou/goods/index.blade.php)7blade
Params
0
result
1
jx
2
sccj
3
ypgg
4
cxGoods
5
category
6
title
yaoyigou.layouts.header (resources/views_new/yaoyigou/layouts/header.blade.php)14blade
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
title
13
goodsPresenter
yaoyigou.ads.top-ad (resources/views_new/yaoyigou/ads/top-ad.blade.php)15blade
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
title
13
goodsPresenter
14
ad
yaoyigou.layouts.search (resources/views_new/yaoyigou/layouts/search.blade.php)14blade
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
title
13
goodsPresenter
yaoyigou.layouts.logo (resources/views_new/yaoyigou/layouts/logo.blade.php)14blade
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
title
13
goodsPresenter
yaoyigou.ads.hot-search (resources/views_new/yaoyigou/ads/hot-search.blade.php)15blade
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
title
13
goodsPresenter
14
ads
yaoyigou.layouts.nav (resources/views_new/yaoyigou/layouts/nav.blade.php)14blade
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
title
13
goodsPresenter
layouts.nav_top (resources/views_new/layouts/nav_top.blade.php)14blade
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
title
13
goodsPresenter
yaoyigou.goods.shaixuan (resources/views_new/yaoyigou/goods/shaixuan.blade.php)14blade
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
title
13
goodsPresenter
yaoyigou.goods.liebiao (resources/views_new/yaoyigou/goods/liebiao.blade.php)14blade
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
title
13
goodsPresenter
yaoyigou.goods.liebiao-item (resources/views_new/yaoyigou/goods/liebiao-item.blade.php)15blade
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
title
13
goodsPresenter
14
v
yaoyigou.goods.liebiao-item (resources/views_new/yaoyigou/goods/liebiao-item.blade.php)15blade
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
title
13
goodsPresenter
14
v
yaoyigou.goods.liebiao-item (resources/views_new/yaoyigou/goods/liebiao-item.blade.php)15blade
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
title
13
goodsPresenter
14
v
yaoyigou.goods.liebiao-item (resources/views_new/yaoyigou/goods/liebiao-item.blade.php)15blade
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
title
13
goodsPresenter
14
v
yaoyigou.goods.liebiao-item (resources/views_new/yaoyigou/goods/liebiao-item.blade.php)15blade
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
title
13
goodsPresenter
14
v
yaoyigou.goods.liebiao-item (resources/views_new/yaoyigou/goods/liebiao-item.blade.php)15blade
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
title
13
goodsPresenter
14
v
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)14blade
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
title
13
goodsPresenter
yaoyigou.layouts.youce (resources/views_new/yaoyigou/layouts/youce.blade.php)14blade
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
title
13
goodsPresenter
yaoyigou.layouts.app (resources/views_new/yaoyigou/layouts/app.blade.php)14blade
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
title
13
goodsPresenter

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

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	`title`
13	`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	`title`
13	`goodsPresenter`
14	`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	`title`
13	`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	`title`
13	`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	`title`
13	`goodsPresenter`
14	`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	`title`
13	`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	`title`
13	`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	`title`
13	`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	`title`
13	`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	`title`
13	`goodsPresenter`
14	`v`

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	`title`
13	`goodsPresenter`
14	`v`

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	`title`
13	`goodsPresenter`
14	`v`

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	`title`
13	`goodsPresenter`
14	`v`

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	`title`
13	`goodsPresenter`
14	`v`

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	`title`
13	`goodsPresenter`
14	`v`

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	`title`
13	`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	`title`
13	`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	`title`
13	`goodsPresenter`

uri: GET search_goods
as: search_goods
controller: App\Http\Controllers\Yaoyigou\GoodsController@index
namespace: App\Http\Controllers
prefix: null
where
file: app/Http/Controllers/Yaoyigou/GoodsController.php:31-45

36 statements were executed, 14 of which were duplicated, 22 unique226.28ms

select id from ecs_sensitive_words where '' like concat('%', keywords, '%')18.55msys_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`.`product_name` = '石家庄四药有限公司'14.06msys_test
Metadata
Bindings
0. 0
1. 0
2. 1
3. 1,2,5,7,8,9
4. %%
5. %%
6. %%
7. %%
8. 石家庄四药有限公司
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`.`product_name` = '石家庄四药有限公司' order by `ecs_goods_statistics`.`score` desc, `ecs_goods`.`sort_order` asc, `ecs_goods`.`goods_id` asc limit 40 offset 018.19msys_test
Metadata
Bindings
0. 0
1. 0
2. 1
3. 1,2,5,7,8,9
4. %%
5. %%
6. %%
7. %%
8. 石家庄四药有限公司
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 ('135', '695', '1124', '1126', '1406', '6522')3.36msys_test
Metadata
Bindings
0. 135
1. 695
2. 1124
3. 1126
4. 1406
5. 6522
select * from `ecs_goods_attribute` where `ecs_goods_attribute`.`goods_id` in ('135', '695', '1124', '1126', '1406', '6522')6.83msys_test
Metadata
Bindings
0. 135
1. 695
2. 1124
3. 1126
4. 1406
5. 6522
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 ('135', '695', '1124', '1126', '1406', '6522')14.79msys_test
Metadata
Bindings
0. 1
1. 135
2. 695
3. 1124
4. 1126
5. 1406
6. 6522
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` <= '1748507940' and `ecs_goods_zp`.`end` > '1748507940' 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 ('135', '695', '1124', '1126', '1406', '6522') order by `ecs_goods_zp`.`goods_number` desc9.99msys_test
Metadata
Bindings
0. 1748507940
1. 1748507940
2. 0
3. 1
4. 0
5. 0
6. 135
7. 695
8. 1124
9. 1126
10. 1406
11. 6522
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` <= '1748507940' and `ecs_goods_zp`.`end` > '1748507940' 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 ('135', '695', '1124', '1126', '1406', '6522') order by `ecs_goods_zp`.`goods_number` desc5.4msys_test
Metadata
Bindings
0. 1748507940
1. 1748507940
2. 1
3. 1
4. 0
5. 135
6. 695
7. 1124
8. 1126
9. 1406
10. 6522

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 石家庄四药有限公司
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. 石家庄四药有限公司
Hints	The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.

Metadata
Bindings	0. 135 1. 695 2. 1124 3. 1126 4. 1406 5. 6522

Metadata
Bindings	0. 135 1. 695 2. 1124 3. 1126 4. 1406 5. 6522
Hints	Use `SELECT *` only if you need all columns from table

Metadata
Bindings	0. 1 1. 135 2. 695 3. 1124 4. 1126 5. 1406 6. 6522

Metadata
Bindings	0. 1748507940 1. 1748507940 2. 0 3. 1 4. 0 5. 0 6. 135 7. 695 8. 1124 9. 1126 10. 1406 11. 6522

Metadata
Bindings	0. 1748507940 1. 1748507940 2. 1 3. 1 4. 0 5. 135 6. 695 7. 1124 8. 1126 9. 1406 10. 6522

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 ('7BB0CE7077712512E053752512ACAA06', '7BB0CE709E992512E053752512ACAA06', '7BB0CE70E4BB2512E053752512ACAA06', '7BB0CE70E52F2512E053752512ACAA06', '42563862', 'ba49ae96-0932-44fa-aed0-c87c67bf7ab6')

7.17msys_test

Metadata
Bindings	0. 1 1. 0 2. 0 3. 7BB0CE7077712512E053752512ACAA06 4. 7BB0CE709E992512E053752512ACAA06 5. 7BB0CE70E4BB2512E053752512ACAA06 6. 7BB0CE70E52F2512E053752512ACAA06 7. 42563862 8. ba49ae96-0932-44fa-aed0-c87c67bf7ab6

select * from `ecs_goods_zp_region` where `region_id` = '8'2.98msys_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 ('135', '695', '1124', '1126', '1406', '6522') and `enabled` = '1' and `start` < '1748507940' and `end` > '1748507940' 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')

8.57msys_test

Metadata

Metadata
Bindings	0. 135 1. 695 2. 1124 3. 1126 4. 1406 5. 6522 6. 1 7. 1748507940 8. 1748507940 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. 135
1. 695
2. 1124
3. 1126
4. 1406
5. 6522
6. 1
7. 1748507940
8. 1748507940
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'6.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_miaosha_group` where `start_time` <= '2025-05-29 16:39:00' and `end_time` > '2025-05-29 16:39:00' 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.36msys_test

Metadata
Bindings	0. 2025-05-29 16:39:00 1. 2025-05-29 16:39:00 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`.`product_name` = '石家庄四药有限公司' and `ypgg` != '' group by `ypgg` order by `ecs_goods_statistics`.`score` desc, `ecs_goods`.`sort_order` asc, `ecs_goods`.`goods_id` asc10.56msys_test
Metadata
Bindings
0. 0
1. 0
2. 1
3. 1,2,5,7,8,9
4. %%
5. %%
6. %%
7. %%
8. 石家庄四药有限公司
9.
Hints
The != operator is not standard. Use the <> operator to test for inequality instead.
select * from `ecs_ad` where `position_id` = '159' and `enabled` > '0' and `end_time` > '1748507940' order by `sort_order` desc, `ad_id` desc8.48msys_test
Metadata
Bindings
0. 159
1. 0
2. 1748507940
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` asc6.77msys_test
Metadata
Bindings
0. 1
1. middle

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

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

4.37msys_test

Metadata
Bindings	0. 135 1. 1 2. 1748507940 3. 1748507940
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'8.86msys_test
Metadata
Bindings
0. 8
Hints
Use SELECT * only if you need all columns from table

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

select * from `ecs_miaosha_group` where `start_time` <= '2025-05-29 16:39:00' and `end_time` > '2025-05-29 16:39:00' 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.66msys_test

Metadata
Bindings	0. 2025-05-29 16:39:00 1. 2025-05-29 16:39:00 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` = '695' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1748507940' and `end_time` >= '1748507940' limit 1

5.57msys_test

Metadata
Bindings	0. 695 1. 1 2. 1748507940 3. 1748507940
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.55msys_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-05-29 16:39:00' and `end_time` > '2025-05-29 16:39:00' 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.65msys_test

Metadata
Bindings	0. 2025-05-29 16:39:00 1. 2025-05-29 16:39:00 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` = '1124' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1748507940' and `end_time` >= '1748507940' limit 1

5.9msys_test

Metadata
Bindings	0. 1124 1. 1 2. 1748507940 3. 1748507940
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.8msys_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-05-29 16:39:00' and `end_time` > '2025-05-29 16:39:00' 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.27msys_test

Metadata
Bindings	0. 2025-05-29 16:39:00 1. 2025-05-29 16:39:00 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` = '1126' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1748507940' and `end_time` >= '1748507940' limit 1

2.62msys_test

Metadata
Bindings	0. 1126 1. 1 2. 1748507940 3. 1748507940
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.58msys_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-05-29 16:39:00' and `end_time` > '2025-05-29 16:39:00' 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.83msys_test

Metadata
Bindings	0. 2025-05-29 16:39:00 1. 2025-05-29 16:39:00 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` = '1406' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1748507940' and `end_time` >= '1748507940' limit 1

2.6msys_test

Metadata
Bindings	0. 1406 1. 1 2. 1748507940 3. 1748507940
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.69msys_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-05-29 16:39:00' and `end_time` > '2025-05-29 16:39:00' 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.98msys_test

Metadata
Bindings	0. 2025-05-29 16:39:00 1. 2025-05-29 16:39:00 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` = '6522' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1748507940' and `end_time` >= '1748507940' limit 1

2.62msys_test

Metadata
Bindings	0. 6522 1. 1 2. 1748507940 3. 1748507940
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.51msys_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-05-29 16:39:00' and `end_time` > '2025-05-29 16:39:00' 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.83msys_test

Metadata
Bindings	0. 2025-05-29 16:39:00 1. 2025-05-29 16:39:00 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.54msys_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.66msys_test
Metadata
Bindings
0. 5
1. 1

_token: 3pc3dg8zkf4yhssPk8F6ZP4JV0bcbHnMU2KrNvkx
PHPDEBUGBAR_STACK_DATA: []

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: array:3 [ "cat_id" => "555" "product_name" => "石家庄四药有限公司" "style" => "l" ]
request_request: array:3 [ "cat_id" => "555" "product_name" => "石家庄四药有限公司" "style" => "l" ]
request_headers: array:10 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ ...
request_server: array:35 [ "USER" => "apache" "HOME" => "/usr/share/httpd" "HTTP_ACCEPT_ENCODING" => "gzip, de...
request_cookies: []
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "date" => array:1 [ 0 => "Thu...
path_info: /search_goods
session_attributes: array:2 [ "_token" => "3pc3dg8zkf4yhssPk8F6ZP4JV0bcbHnMU2KrNvkx" "PHPDEBUGBAR_STACK_DATA" => [] ...

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