商品搜索-博大医药网

热门搜索：

订单查询

购物车0

全部商品分类

药理分类：非药品

药理分类：医疗器械类

北京欣乐佳国际健康科技有限公司

药理分类：

更多

收起

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

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

发布求购

消息

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

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

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

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

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

500包邮全场满500元包邮

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

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

Messages Timeline Exceptions Views13 Route Queries11 Mails Session Request

252.54ms4MBGET search_goods

Booting (117.72ms)
Application (151.61ms)

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 executed79.18ms

select id from ecs_sensitive_words where '' like concat('%', keywords, '%')10.24msys_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` = '683' or `cat_ids` like '683,%' or `cat_ids` like '%,683' or `cat_ids` like '%,683,%') and (`cat_ids` = '685' or `cat_ids` like '685,%' or `cat_ids` like '%,685' or `cat_ids` like '%,685,%') and (`cat_ids` = '686' or `cat_ids` like '686,%' or `cat_ids` like '%,686' or `cat_ids` like '%,686,%') and (`cat_ids` = '687' or `cat_ids` like '687,%' or `cat_ids` like '%,687' or `cat_ids` like '%,687,%') and (`cat_ids` = '688' or `cat_ids` like '688,%' or `cat_ids` like '%,688' or `cat_ids` like '%,688,%') and (`cat_ids` = '691' or `cat_ids` like '691,%' or `cat_ids` like '%,691' or `cat_ids` like '%,691,%') and (`cat_ids` = '692' or `cat_ids` like '692,%' or `cat_ids` like '%,692' or `cat_ids` like '%,692,%') and (`cat_ids` = '694' or `cat_ids` like '694,%' or `cat_ids` like '%,694' or `cat_ids` like '%,694,%') and (`cat_ids` = '1236' or `cat_ids` like '1236,%' or `cat_ids` like '%,1236' or `cat_ids` like '%,1236,%') and (`cat_ids` = '1237' or `cat_ids` like '1237,%' or `cat_ids` like '%,1237' or `cat_ids` like '%,1237,%') and (`cat_ids` = '1238' or `cat_ids` like '1238,%' or `cat_ids` like '%,1238' or `cat_ids` like '%,1238,%') and (`cat_ids` = '1239' or `cat_ids` like '1239,%' or `cat_ids` like '%,1239' or `cat_ids` like '%,1239,%') and (`cat_ids` = '1240' or `cat_ids` like '1240,%' or `cat_ids` like '%,1240' or `cat_ids` like '%,1240,%') and (`cat_ids` = '1241' or `cat_ids` like '1241,%' or `cat_ids` like '%,1241' or `cat_ids` like '%,1241,%') and (`cat_ids` = '1242' or `cat_ids` like '1242,%' or `cat_ids` like '%,1242' or `cat_ids` like '%,1242,%') and (`cat_ids` = '1243' or `cat_ids` like '1243,%' or `cat_ids` like '%,1243' or `cat_ids` like '%,1243,%') and (`cat_ids` = '1089' or `cat_ids` like '1089,%' or `cat_ids` like '%,1089' or `cat_ids` like '%,1089,%') and (`cat_ids` = '1090' or `cat_ids` like '1090,%' or `cat_ids` like '%,1090' or `cat_ids` like '%,1090,%') and (`cat_ids` = '1091' or `cat_ids` like '1091,%' or `cat_ids` like '%,1091' or `cat_ids` like '%,1091,%')) and `ecs_goods`.`product_name` = '北京欣乐佳国际健康科技有限公司'

12.53msys_test

Metadata

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 683 9. 683,% 10. %,683 11. %,683,% 12. 685 13. 685,% 14. %,685 15. %,685,% 16. 686 17. 686,% 18. %,686 19. %,686,% 20. 687 21. 687,% 22. %,687 23. %,687,% 24. 688 25. 688,% 26. %,688 27. %,688,% 28. 691 29. 691,% 30. %,691 31. %,691,% 32. 692 33. 692,% 34. %,692 35. %,692,% 36. 694 37. 694,% 38. %,694 39. %,694,% 40. 1236 41. 1236,% 42. %,1236 43. %,1236,% 44. 1237 45. 1237,% 46. %,1237 47. %,1237,% 48. 1238 49. 1238,% 50. %,1238 51. %,1238,% 52. 1239 53. 1239,% 54. %,1239 55. %,1239,% 56. 1240 57. 1240,% 58. %,1240 59. %,1240,% 60. 1241 61. 1241,% 62. %,1241 63. %,1241,% 64. 1242 65. 1242,% 66. %,1242 67. %,1242,% 68. 1243 69. 1243,% 70. %,1243 71. %,1243,% 72. 1089 73. 1089,% 74. %,1089 75. %,1089,% 76. 1090 77. 1090,% 78. %,1090 79. %,1090,% 80. 1091 81. 1091,% 82. %,1091 83. %,1091,% 84. 北京欣乐佳国际健康科技有限公司
Hints	The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.

Bindings

0. 0
1. 0
2. 1
3. 1,2,5,7,8,9
4. %%
5. %%
6. %%
7. %%
8. 683
9. 683,%
10. %,683
11. %,683,%
12. 685
13. 685,%
14. %,685
15. %,685,%
16. 686
17. 686,%
18. %,686
19. %,686,%
20. 687
21. 687,%
22. %,687
23. %,687,%
24. 688
25. 688,%
26. %,688
27. %,688,%
28. 691
29. 691,%
30. %,691
31. %,691,%
32. 692
33. 692,%
34. %,692
35. %,692,%
36. 694
37. 694,%
38. %,694
39. %,694,%
40. 1236
41. 1236,%
42. %,1236
43. %,1236,%
44. 1237
45. 1237,%
46. %,1237
47. %,1237,%
48. 1238
49. 1238,%
50. %,1238
51. %,1238,%
52. 1239
53. 1239,%
54. %,1239
55. %,1239,%
56. 1240
57. 1240,%
58. %,1240
59. %,1240,%
60. 1241
61. 1241,%
62. %,1241
63. %,1241,%
64. 1242
65. 1242,%
66. %,1242
67. %,1242,%
68. 1243
69. 1243,%
70. %,1243
71. %,1243,%
72. 1089
73. 1089,%
74. %,1089
75. %,1089,%
76. 1090
77. 1090,%
78. %,1090
79. %,1090,%
80. 1091
81. 1091,%
82. %,1091
83. %,1091,%
84. 北京欣乐佳国际健康科技有限公司

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` = '683' or `cat_ids` like '683,%' or `cat_ids` like '%,683' or `cat_ids` like '%,683,%') and (`cat_ids` = '685' or `cat_ids` like '685,%' or `cat_ids` like '%,685' or `cat_ids` like '%,685,%') and (`cat_ids` = '686' or `cat_ids` like '686,%' or `cat_ids` like '%,686' or `cat_ids` like '%,686,%') and (`cat_ids` = '687' or `cat_ids` like '687,%' or `cat_ids` like '%,687' or `cat_ids` like '%,687,%') and (`cat_ids` = '688' or `cat_ids` like '688,%' or `cat_ids` like '%,688' or `cat_ids` like '%,688,%') and (`cat_ids` = '691' or `cat_ids` like '691,%' or `cat_ids` like '%,691' or `cat_ids` like '%,691,%') and (`cat_ids` = '692' or `cat_ids` like '692,%' or `cat_ids` like '%,692' or `cat_ids` like '%,692,%') and (`cat_ids` = '694' or `cat_ids` like '694,%' or `cat_ids` like '%,694' or `cat_ids` like '%,694,%') and (`cat_ids` = '1236' or `cat_ids` like '1236,%' or `cat_ids` like '%,1236' or `cat_ids` like '%,1236,%') and (`cat_ids` = '1237' or `cat_ids` like '1237,%' or `cat_ids` like '%,1237' or `cat_ids` like '%,1237,%') and (`cat_ids` = '1238' or `cat_ids` like '1238,%' or `cat_ids` like '%,1238' or `cat_ids` like '%,1238,%') and (`cat_ids` = '1239' or `cat_ids` like '1239,%' or `cat_ids` like '%,1239' or `cat_ids` like '%,1239,%') and (`cat_ids` = '1240' or `cat_ids` like '1240,%' or `cat_ids` like '%,1240' or `cat_ids` like '%,1240,%') and (`cat_ids` = '1241' or `cat_ids` like '1241,%' or `cat_ids` like '%,1241' or `cat_ids` like '%,1241,%') and (`cat_ids` = '1242' or `cat_ids` like '1242,%' or `cat_ids` like '%,1242' or `cat_ids` like '%,1242,%') and (`cat_ids` = '1243' or `cat_ids` like '1243,%' or `cat_ids` like '%,1243' or `cat_ids` like '%,1243,%') and (`cat_ids` = '1089' or `cat_ids` like '1089,%' or `cat_ids` like '%,1089' or `cat_ids` like '%,1089,%') and (`cat_ids` = '1090' or `cat_ids` like '1090,%' or `cat_ids` like '%,1090' or `cat_ids` like '%,1090,%') and (`cat_ids` = '1091' or `cat_ids` like '1091,%' or `cat_ids` like '%,1091' or `cat_ids` like '%,1091,%')) 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

20.76msys_test

Metadata

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 683 9. 683,% 10. %,683 11. %,683,% 12. 685 13. 685,% 14. %,685 15. %,685,% 16. 686 17. 686,% 18. %,686 19. %,686,% 20. 687 21. 687,% 22. %,687 23. %,687,% 24. 688 25. 688,% 26. %,688 27. %,688,% 28. 691 29. 691,% 30. %,691 31. %,691,% 32. 692 33. 692,% 34. %,692 35. %,692,% 36. 694 37. 694,% 38. %,694 39. %,694,% 40. 1236 41. 1236,% 42. %,1236 43. %,1236,% 44. 1237 45. 1237,% 46. %,1237 47. %,1237,% 48. 1238 49. 1238,% 50. %,1238 51. %,1238,% 52. 1239 53. 1239,% 54. %,1239 55. %,1239,% 56. 1240 57. 1240,% 58. %,1240 59. %,1240,% 60. 1241 61. 1241,% 62. %,1241 63. %,1241,% 64. 1242 65. 1242,% 66. %,1242 67. %,1242,% 68. 1243 69. 1243,% 70. %,1243 71. %,1243,% 72. 1089 73. 1089,% 74. %,1089 75. %,1089,% 76. 1090 77. 1090,% 78. %,1090 79. %,1090,% 80. 1091 81. 1091,% 82. %,1091 83. %,1091,% 84. 北京欣乐佳国际健康科技有限公司
Hints	The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.

Bindings

0. 0
1. 0
2. 1
3. 1,2,5,7,8,9
4. %%
5. %%
6. %%
7. %%
8. 683
9. 683,%
10. %,683
11. %,683,%
12. 685
13. 685,%
14. %,685
15. %,685,%
16. 686
17. 686,%
18. %,686
19. %,686,%
20. 687
21. 687,%
22. %,687
23. %,687,%
24. 688
25. 688,%
26. %,688
27. %,688,%
28. 691
29. 691,%
30. %,691
31. %,691,%
32. 692
33. 692,%
34. %,692
35. %,692,%
36. 694
37. 694,%
38. %,694
39. %,694,%
40. 1236
41. 1236,%
42. %,1236
43. %,1236,%
44. 1237
45. 1237,%
46. %,1237
47. %,1237,%
48. 1238
49. 1238,%
50. %,1238
51. %,1238,%
52. 1239
53. 1239,%
54. %,1239
55. %,1239,%
56. 1240
57. 1240,%
58. %,1240
59. %,1240,%
60. 1241
61. 1241,%
62. %,1241
63. %,1241,%
64. 1242
65. 1242,%
66. %,1242
67. %,1242,%
68. 1243
69. 1243,%
70. %,1243
71. %,1243,%
72. 1089
73. 1089,%
74. %,1089
75. %,1089,%
76. 1090
77. 1090,%
78. %,1090
79. %,1090,%
80. 1091
81. 1091,%
82. %,1091
83. %,1091,%
84. 北京欣乐佳国际健康科技有限公司

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.14msys_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-02 17:17:58' and `end_time` > '2025-05-02 17:17:58' 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.41msys_test

Metadata
Bindings	0. 2025-05-02 17:17:58 1. 2025-05-02 17:17:58 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` = '683' or `cat_ids` like '683,%' or `cat_ids` like '%,683' or `cat_ids` like '%,683,%') and (`cat_ids` = '685' or `cat_ids` like '685,%' or `cat_ids` like '%,685' or `cat_ids` like '%,685,%') and (`cat_ids` = '686' or `cat_ids` like '686,%' or `cat_ids` like '%,686' or `cat_ids` like '%,686,%') and (`cat_ids` = '687' or `cat_ids` like '687,%' or `cat_ids` like '%,687' or `cat_ids` like '%,687,%') and (`cat_ids` = '688' or `cat_ids` like '688,%' or `cat_ids` like '%,688' or `cat_ids` like '%,688,%') and (`cat_ids` = '691' or `cat_ids` like '691,%' or `cat_ids` like '%,691' or `cat_ids` like '%,691,%') and (`cat_ids` = '692' or `cat_ids` like '692,%' or `cat_ids` like '%,692' or `cat_ids` like '%,692,%') and (`cat_ids` = '694' or `cat_ids` like '694,%' or `cat_ids` like '%,694' or `cat_ids` like '%,694,%') and (`cat_ids` = '1236' or `cat_ids` like '1236,%' or `cat_ids` like '%,1236' or `cat_ids` like '%,1236,%') and (`cat_ids` = '1237' or `cat_ids` like '1237,%' or `cat_ids` like '%,1237' or `cat_ids` like '%,1237,%') and (`cat_ids` = '1238' or `cat_ids` like '1238,%' or `cat_ids` like '%,1238' or `cat_ids` like '%,1238,%') and (`cat_ids` = '1239' or `cat_ids` like '1239,%' or `cat_ids` like '%,1239' or `cat_ids` like '%,1239,%') and (`cat_ids` = '1240' or `cat_ids` like '1240,%' or `cat_ids` like '%,1240' or `cat_ids` like '%,1240,%') and (`cat_ids` = '1241' or `cat_ids` like '1241,%' or `cat_ids` like '%,1241' or `cat_ids` like '%,1241,%') and (`cat_ids` = '1242' or `cat_ids` like '1242,%' or `cat_ids` like '%,1242' or `cat_ids` like '%,1242,%') and (`cat_ids` = '1243' or `cat_ids` like '1243,%' or `cat_ids` like '%,1243' or `cat_ids` like '%,1243,%') and (`cat_ids` = '1089' or `cat_ids` like '1089,%' or `cat_ids` like '%,1089' or `cat_ids` like '%,1089,%') and (`cat_ids` = '1090' or `cat_ids` like '1090,%' or `cat_ids` like '%,1090' or `cat_ids` like '%,1090,%') and (`cat_ids` = '1091' or `cat_ids` like '1091,%' or `cat_ids` like '%,1091' or `cat_ids` like '%,1091,%')) 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.91msys_test

Metadata

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 683 9. 683,% 10. %,683 11. %,683,% 12. 685 13. 685,% 14. %,685 15. %,685,% 16. 686 17. 686,% 18. %,686 19. %,686,% 20. 687 21. 687,% 22. %,687 23. %,687,% 24. 688 25. 688,% 26. %,688 27. %,688,% 28. 691 29. 691,% 30. %,691 31. %,691,% 32. 692 33. 692,% 34. %,692 35. %,692,% 36. 694 37. 694,% 38. %,694 39. %,694,% 40. 1236 41. 1236,% 42. %,1236 43. %,1236,% 44. 1237 45. 1237,% 46. %,1237 47. %,1237,% 48. 1238 49. 1238,% 50. %,1238 51. %,1238,% 52. 1239 53. 1239,% 54. %,1239 55. %,1239,% 56. 1240 57. 1240,% 58. %,1240 59. %,1240,% 60. 1241 61. 1241,% 62. %,1241 63. %,1241,% 64. 1242 65. 1242,% 66. %,1242 67. %,1242,% 68. 1243 69. 1243,% 70. %,1243 71. %,1243,% 72. 1089 73. 1089,% 74. %,1089 75. %,1089,% 76. 1090 77. 1090,% 78. %,1090 79. %,1090,% 80. 1091 81. 1091,% 82. %,1091 83. %,1091,% 84. 北京欣乐佳国际健康科技有限公司 85.
Hints	The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.

Bindings

0. 0
1. 0
2. 1
3. 1,2,5,7,8,9
4. %%
5. %%
6. %%
7. %%
8. 683
9. 683,%
10. %,683
11. %,683,%
12. 685
13. 685,%
14. %,685
15. %,685,%
16. 686
17. 686,%
18. %,686
19. %,686,%
20. 687
21. 687,%
22. %,687
23. %,687,%
24. 688
25. 688,%
26. %,688
27. %,688,%
28. 691
29. 691,%
30. %,691
31. %,691,%
32. 692
33. 692,%
34. %,692
35. %,692,%
36. 694
37. 694,%
38. %,694
39. %,694,%
40. 1236
41. 1236,%
42. %,1236
43. %,1236,%
44. 1237
45. 1237,%
46. %,1237
47. %,1237,%
48. 1238
49. 1238,%
50. %,1238
51. %,1238,%
52. 1239
53. 1239,%
54. %,1239
55. %,1239,%
56. 1240
57. 1240,%
58. %,1240
59. %,1240,%
60. 1241
61. 1241,%
62. %,1241
63. %,1241,%
64. 1242
65. 1242,%
66. %,1242
67. %,1242,%
68. 1243
69. 1243,%
70. %,1243
71. %,1243,%
72. 1089
73. 1089,%
74. %,1089
75. %,1089,%
76. 1090
77. 1090,%
78. %,1090
79. %,1090,%
80. 1091
81. 1091,%
82. %,1091
83. %,1091,%
84. 北京欣乐佳国际健康科技有限公司
85.

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` > '1746177478' order by `sort_order` desc, `ad_id` desc3.27msys_test
Metadata
Bindings
0. 152
1. 0
2. 1746177478
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` > '1746177478' order by `sort_order` desc, `ad_id` desc3.33msys_test
Metadata
Bindings
0. 159
1. 0
2. 1746177478
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.44msys_test
Metadata
Bindings
0. 1
1. middle
select `cat_id`, `cat_name`, `sort_order` from `ecs_article_cat` where `cat_id` = '5' limit 13.01msys_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.14msys_test
Metadata
Bindings
0. 5
1. 1

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

Metadata
Bindings	0. 159 1. 0 2. 1746177478
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: AicWSIV3bHdBAMb4anQBuRzqRJ80QGtvScnBzil0
PHPDEBUGBAR_STACK_DATA: []

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: array:3 [ "cat_id" => "683" "product_name" => "北京欣乐佳国际健康科技有限公司" "style" => "g" ]
request_request: array:3 [ "cat_id" => "683" "product_name" => "北京欣乐佳国际健康科技有限公司" "style" => "g" ]
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 => "Fri...
path_info: /search_goods
session_attributes: array:2 [ "_token" => "AicWSIV3bHdBAMb4anQBuRzqRJ80QGtvScnBzil0" "PHPDEBUGBAR_STACK_DATA" => [] ...