商品搜索-博大医药网

热门搜索：

订单查询

购物车0

全部商品分类

药理分类：呼吸系统用药

药理分类：解热镇痛类

贵州神奇药业股份有限公司

抱歉！没有找到相关的药品

你可以发布求购意向，博大医药网会尽快补货！

发布求购

消息

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

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

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

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

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

500包邮全场满500元包邮

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

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

Messages Timeline Exceptions Views13 Route Queries11 Mails Session Request

309.49ms4MBGET search_goods

Booting (158.23ms)
Application (173.08ms)

13 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.ads.wntj (resources/views_new/yaoyigou/ads/wntj.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.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`

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

11 statements were executed76.34ms

select id from ecs_sensitive_words where '' like concat('%', keywords, '%')9.78msys_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 ((`cat_ids` = '493' or `cat_ids` like '493,%' or `cat_ids` like '%,493' or `cat_ids` like '%,493,%') and (`cat_ids` = '493' or `cat_ids` like '493,%' or `cat_ids` like '%,493' or `cat_ids` like '%,493,%')) and `ecs_goods`.`product_name` = '贵州神奇药业股份有限公司'

12.18msys_test

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 493 9. 493,% 10. %,493 11. %,493,% 12. 493 13. 493,% 14. %,493 15. %,493,% 16. 贵州神奇药业股份有限公司
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 ((`cat_ids` = '493' or `cat_ids` like '493,%' or `cat_ids` like '%,493' or `cat_ids` like '%,493,%') and (`cat_ids` = '493' or `cat_ids` like '493,%' or `cat_ids` like '%,493' or `cat_ids` like '%,493,%')) and `ecs_goods`.`product_name` = '贵州神奇药业股份有限公司' order by `ecs_goods_statistics`.`score` desc, `ecs_goods`.`sort_order` asc, `ecs_goods`.`goods_id` asc limit 40 offset 0

19.5msys_test

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 493 9. 493,% 10. %,493 11. %,493,% 12. 493 13. 493,% 14. %,493 15. %,493,% 16. 贵州神奇药业股份有限公司
Hints	The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.

select * from `ecs_miaosha_group_region` where `region_id` = '8'3.27msys_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-04-29 19:48:19' and `end_time` > '2025-04-29 19:48: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.62msys_test

Metadata
Bindings	0. 2025-04-29 19:48:19 1. 2025-04-29 19:48: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 `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 ((`cat_ids` = '493' or `cat_ids` like '493,%' or `cat_ids` like '%,493' or `cat_ids` like '%,493,%') and (`cat_ids` = '493' or `cat_ids` like '493,%' or `cat_ids` like '%,493' or `cat_ids` like '%,493,%')) and `ecs_goods`.`product_name` = '贵州神奇药业股份有限公司' and `ypgg` != '' group by `ypgg` order by `ecs_goods_statistics`.`score` desc, `ecs_goods`.`sort_order` asc, `ecs_goods`.`goods_id` asc

12.6msys_test

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 493 9. 493,% 10. %,493 11. %,493,% 12. 493 13. 493,% 14. %,493 15. %,493,% 16. 贵州神奇药业股份有限公司 17.
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` > '1745927299' order by `sort_order` desc, `ad_id` desc2.92msys_test
Metadata
Bindings
0. 152
1. 0
2. 1745927299
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` > '1745927299' order by `sort_order` desc, `ad_id` desc2.98msys_test
Metadata
Bindings
0. 159
1. 0
2. 1745927299
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` asc2.94msys_test
Metadata
Bindings
0. 1
1. middle
select `cat_id`, `cat_name`, `sort_order` from `ecs_article_cat` where `cat_id` = '5' limit 12.69msys_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.86msys_test
Metadata
Bindings
0. 5
1. 1

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

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

Metadata
Bindings	0. 1 1. middle

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

Metadata
Bindings	0. 5 1. 1

_token: pGqZbMfxA5cXnJxq9VeVL9b95PDbUNJP5rBVx47c
PHPDEBUGBAR_STACK_DATA: []

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: array:3 [ "cat_id" => "493" "product_name" => "贵州神奇药业股份有限公司" "style" => "g" ]
request_request: array:3 [ "cat_id" => "493" "product_name" => "贵州神奇药业股份有限公司" "style" => "g" ]
request_headers: array:10 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate" ] "accept" => array:1 [ ...
request_server: array:36 [ "USER" => "apache" "HOME" => "/usr/share/httpd" "ORACLE_HOME" => "/usr/lib/oracle/2...
request_cookies: []
response_headers: array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "date" => array:1 [ 0 => "Tue...
path_info: /search_goods
session_attributes: array:2 [ "_token" => "pGqZbMfxA5cXnJxq9VeVL9b95PDbUNJP5rBVx47c" "PHPDEBUGBAR_STACK_DATA" => [] ...