商品搜索-博大医药网

热门搜索：

订单查询

购物车0

全部商品分类

药理分类：非药品

药理分类：保健食品

北京御生堂保健食品有限公司

药理分类：

更多

收起

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

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

发布求购

消息

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

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

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

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

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

500包邮全场满500元包邮

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

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

Messages Timeline Exceptions Views13 Route Queries11 Mails Session Request

493.52ms4MBGET search_goods

Booting (133.78ms)
Application (377.93ms)

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 executed84.36ms

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` = '12' or `cat_ids` like '12,%' or `cat_ids` like '%,12' or `cat_ids` like '%,12,%') and (`cat_ids` = '380' or `cat_ids` like '380,%' or `cat_ids` like '%,380' or `cat_ids` like '%,380,%') and (`cat_ids` = '696' or `cat_ids` like '696,%' or `cat_ids` like '%,696' or `cat_ids` like '%,696,%') and (`cat_ids` = '697' or `cat_ids` like '697,%' or `cat_ids` like '%,697' or `cat_ids` like '%,697,%') and (`cat_ids` = '698' or `cat_ids` like '698,%' or `cat_ids` like '%,698' or `cat_ids` like '%,698,%') and (`cat_ids` = '704' or `cat_ids` like '704,%' or `cat_ids` like '%,704' or `cat_ids` like '%,704,%') and (`cat_ids` = '706' or `cat_ids` like '706,%' or `cat_ids` like '%,706' or `cat_ids` like '%,706,%') and (`cat_ids` = '707' or `cat_ids` like '707,%' or `cat_ids` like '%,707' or `cat_ids` like '%,707,%') and (`cat_ids` = '709' or `cat_ids` like '709,%' or `cat_ids` like '%,709' or `cat_ids` like '%,709,%') and (`cat_ids` = '711' or `cat_ids` like '711,%' or `cat_ids` like '%,711' or `cat_ids` like '%,711,%') and (`cat_ids` = '714' or `cat_ids` like '714,%' or `cat_ids` like '%,714' or `cat_ids` like '%,714,%') and (`cat_ids` = '716' or `cat_ids` like '716,%' or `cat_ids` like '%,716' or `cat_ids` like '%,716,%') and (`cat_ids` = '717' or `cat_ids` like '717,%' or `cat_ids` like '%,717' or `cat_ids` like '%,717,%') and (`cat_ids` = '1244' or `cat_ids` like '1244,%' or `cat_ids` like '%,1244' or `cat_ids` like '%,1244,%') and (`cat_ids` = '1245' or `cat_ids` like '1245,%' or `cat_ids` like '%,1245' or `cat_ids` like '%,1245,%') and (`cat_ids` = '1246' or `cat_ids` like '1246,%' or `cat_ids` like '%,1246' or `cat_ids` like '%,1246,%') and (`cat_ids` = '1247' or `cat_ids` like '1247,%' or `cat_ids` like '%,1247' or `cat_ids` like '%,1247,%') and (`cat_ids` = '1248' or `cat_ids` like '1248,%' or `cat_ids` like '%,1248' or `cat_ids` like '%,1248,%') and (`cat_ids` = '1249' or `cat_ids` like '1249,%' or `cat_ids` like '%,1249' or `cat_ids` like '%,1249,%') and (`cat_ids` = '1250' or `cat_ids` like '1250,%' or `cat_ids` like '%,1250' or `cat_ids` like '%,1250,%') and (`cat_ids` = '1251' or `cat_ids` like '1251,%' or `cat_ids` like '%,1251' or `cat_ids` like '%,1251,%') and (`cat_ids` = '1252' or `cat_ids` like '1252,%' or `cat_ids` like '%,1252' or `cat_ids` like '%,1252,%') and (`cat_ids` = '1253' or `cat_ids` like '1253,%' or `cat_ids` like '%,1253' or `cat_ids` like '%,1253,%') and (`cat_ids` = '1254' or `cat_ids` like '1254,%' or `cat_ids` like '%,1254' or `cat_ids` like '%,1254,%') and (`cat_ids` = '1255' or `cat_ids` like '1255,%' or `cat_ids` like '%,1255' or `cat_ids` like '%,1255,%') and (`cat_ids` = '1256' or `cat_ids` like '1256,%' or `cat_ids` like '%,1256' or `cat_ids` like '%,1256,%') and (`cat_ids` = '1257' or `cat_ids` like '1257,%' or `cat_ids` like '%,1257' or `cat_ids` like '%,1257,%') and (`cat_ids` = '1258' or `cat_ids` like '1258,%' or `cat_ids` like '%,1258' or `cat_ids` like '%,1258,%') and (`cat_ids` = '1259' or `cat_ids` like '1259,%' or `cat_ids` like '%,1259' or `cat_ids` like '%,1259,%') and (`cat_ids` = '1260' or `cat_ids` like '1260,%' or `cat_ids` like '%,1260' or `cat_ids` like '%,1260,%') and (`cat_ids` = '1261' or `cat_ids` like '1261,%' or `cat_ids` like '%,1261' or `cat_ids` like '%,1261,%') and (`cat_ids` = '1262' or `cat_ids` like '1262,%' or `cat_ids` like '%,1262' or `cat_ids` like '%,1262,%')) and `ecs_goods`.`product_name` = '北京御生堂保健食品有限公司'

13.82msys_test

Metadata

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 12 9. 12,% 10. %,12 11. %,12,% 12. 380 13. 380,% 14. %,380 15. %,380,% 16. 696 17. 696,% 18. %,696 19. %,696,% 20. 697 21. 697,% 22. %,697 23. %,697,% 24. 698 25. 698,% 26. %,698 27. %,698,% 28. 704 29. 704,% 30. %,704 31. %,704,% 32. 706 33. 706,% 34. %,706 35. %,706,% 36. 707 37. 707,% 38. %,707 39. %,707,% 40. 709 41. 709,% 42. %,709 43. %,709,% 44. 711 45. 711,% 46. %,711 47. %,711,% 48. 714 49. 714,% 50. %,714 51. %,714,% 52. 716 53. 716,% 54. %,716 55. %,716,% 56. 717 57. 717,% 58. %,717 59. %,717,% 60. 1244 61. 1244,% 62. %,1244 63. %,1244,% 64. 1245 65. 1245,% 66. %,1245 67. %,1245,% 68. 1246 69. 1246,% 70. %,1246 71. %,1246,% 72. 1247 73. 1247,% 74. %,1247 75. %,1247,% 76. 1248 77. 1248,% 78. %,1248 79. %,1248,% 80. 1249 81. 1249,% 82. %,1249 83. %,1249,% 84. 1250 85. 1250,% 86. %,1250 87. %,1250,% 88. 1251 89. 1251,% 90. %,1251 91. %,1251,% 92. 1252 93. 1252,% 94. %,1252 95. %,1252,% 96. 1253 97. 1253,% 98. %,1253 99. %,1253,% 100. 1254 101. 1254,% 102. %,1254 103. %,1254,% 104. 1255 105. 1255,% 106. %,1255 107. %,1255,% 108. 1256 109. 1256,% 110. %,1256 111. %,1256,% 112. 1257 113. 1257,% 114. %,1257 115. %,1257,% 116. 1258 117. 1258,% 118. %,1258 119. %,1258,% 120. 1259 121. 1259,% 122. %,1259 123. %,1259,% 124. 1260 125. 1260,% 126. %,1260 127. %,1260,% 128. 1261 129. 1261,% 130. %,1261 131. %,1261,% 132. 1262 133. 1262,% 134. %,1262 135. %,1262,% 136. 北京御生堂保健食品有限公司
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. 12
9. 12,%
10. %,12
11. %,12,%
12. 380
13. 380,%
14. %,380
15. %,380,%
16. 696
17. 696,%
18. %,696
19. %,696,%
20. 697
21. 697,%
22. %,697
23. %,697,%
24. 698
25. 698,%
26. %,698
27. %,698,%
28. 704
29. 704,%
30. %,704
31. %,704,%
32. 706
33. 706,%
34. %,706
35. %,706,%
36. 707
37. 707,%
38. %,707
39. %,707,%
40. 709
41. 709,%
42. %,709
43. %,709,%
44. 711
45. 711,%
46. %,711
47. %,711,%
48. 714
49. 714,%
50. %,714
51. %,714,%
52. 716
53. 716,%
54. %,716
55. %,716,%
56. 717
57. 717,%
58. %,717
59. %,717,%
60. 1244
61. 1244,%
62. %,1244
63. %,1244,%
64. 1245
65. 1245,%
66. %,1245
67. %,1245,%
68. 1246
69. 1246,%
70. %,1246
71. %,1246,%
72. 1247
73. 1247,%
74. %,1247
75. %,1247,%
76. 1248
77. 1248,%
78. %,1248
79. %,1248,%
80. 1249
81. 1249,%
82. %,1249
83. %,1249,%
84. 1250
85. 1250,%
86. %,1250
87. %,1250,%
88. 1251
89. 1251,%
90. %,1251
91. %,1251,%
92. 1252
93. 1252,%
94. %,1252
95. %,1252,%
96. 1253
97. 1253,%
98. %,1253
99. %,1253,%
100. 1254
101. 1254,%
102. %,1254
103. %,1254,%
104. 1255
105. 1255,%
106. %,1255
107. %,1255,%
108. 1256
109. 1256,%
110. %,1256
111. %,1256,%
112. 1257
113. 1257,%
114. %,1257
115. %,1257,%
116. 1258
117. 1258,%
118. %,1258
119. %,1258,%
120. 1259
121. 1259,%
122. %,1259
123. %,1259,%
124. 1260
125. 1260,%
126. %,1260
127. %,1260,%
128. 1261
129. 1261,%
130. %,1261
131. %,1261,%
132. 1262
133. 1262,%
134. %,1262
135. %,1262,%
136. 北京御生堂保健食品有限公司

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` = '12' or `cat_ids` like '12,%' or `cat_ids` like '%,12' or `cat_ids` like '%,12,%') and (`cat_ids` = '380' or `cat_ids` like '380,%' or `cat_ids` like '%,380' or `cat_ids` like '%,380,%') and (`cat_ids` = '696' or `cat_ids` like '696,%' or `cat_ids` like '%,696' or `cat_ids` like '%,696,%') and (`cat_ids` = '697' or `cat_ids` like '697,%' or `cat_ids` like '%,697' or `cat_ids` like '%,697,%') and (`cat_ids` = '698' or `cat_ids` like '698,%' or `cat_ids` like '%,698' or `cat_ids` like '%,698,%') and (`cat_ids` = '704' or `cat_ids` like '704,%' or `cat_ids` like '%,704' or `cat_ids` like '%,704,%') and (`cat_ids` = '706' or `cat_ids` like '706,%' or `cat_ids` like '%,706' or `cat_ids` like '%,706,%') and (`cat_ids` = '707' or `cat_ids` like '707,%' or `cat_ids` like '%,707' or `cat_ids` like '%,707,%') and (`cat_ids` = '709' or `cat_ids` like '709,%' or `cat_ids` like '%,709' or `cat_ids` like '%,709,%') and (`cat_ids` = '711' or `cat_ids` like '711,%' or `cat_ids` like '%,711' or `cat_ids` like '%,711,%') and (`cat_ids` = '714' or `cat_ids` like '714,%' or `cat_ids` like '%,714' or `cat_ids` like '%,714,%') and (`cat_ids` = '716' or `cat_ids` like '716,%' or `cat_ids` like '%,716' or `cat_ids` like '%,716,%') and (`cat_ids` = '717' or `cat_ids` like '717,%' or `cat_ids` like '%,717' or `cat_ids` like '%,717,%') and (`cat_ids` = '1244' or `cat_ids` like '1244,%' or `cat_ids` like '%,1244' or `cat_ids` like '%,1244,%') and (`cat_ids` = '1245' or `cat_ids` like '1245,%' or `cat_ids` like '%,1245' or `cat_ids` like '%,1245,%') and (`cat_ids` = '1246' or `cat_ids` like '1246,%' or `cat_ids` like '%,1246' or `cat_ids` like '%,1246,%') and (`cat_ids` = '1247' or `cat_ids` like '1247,%' or `cat_ids` like '%,1247' or `cat_ids` like '%,1247,%') and (`cat_ids` = '1248' or `cat_ids` like '1248,%' or `cat_ids` like '%,1248' or `cat_ids` like '%,1248,%') and (`cat_ids` = '1249' or `cat_ids` like '1249,%' or `cat_ids` like '%,1249' or `cat_ids` like '%,1249,%') and (`cat_ids` = '1250' or `cat_ids` like '1250,%' or `cat_ids` like '%,1250' or `cat_ids` like '%,1250,%') and (`cat_ids` = '1251' or `cat_ids` like '1251,%' or `cat_ids` like '%,1251' or `cat_ids` like '%,1251,%') and (`cat_ids` = '1252' or `cat_ids` like '1252,%' or `cat_ids` like '%,1252' or `cat_ids` like '%,1252,%') and (`cat_ids` = '1253' or `cat_ids` like '1253,%' or `cat_ids` like '%,1253' or `cat_ids` like '%,1253,%') and (`cat_ids` = '1254' or `cat_ids` like '1254,%' or `cat_ids` like '%,1254' or `cat_ids` like '%,1254,%') and (`cat_ids` = '1255' or `cat_ids` like '1255,%' or `cat_ids` like '%,1255' or `cat_ids` like '%,1255,%') and (`cat_ids` = '1256' or `cat_ids` like '1256,%' or `cat_ids` like '%,1256' or `cat_ids` like '%,1256,%') and (`cat_ids` = '1257' or `cat_ids` like '1257,%' or `cat_ids` like '%,1257' or `cat_ids` like '%,1257,%') and (`cat_ids` = '1258' or `cat_ids` like '1258,%' or `cat_ids` like '%,1258' or `cat_ids` like '%,1258,%') and (`cat_ids` = '1259' or `cat_ids` like '1259,%' or `cat_ids` like '%,1259' or `cat_ids` like '%,1259,%') and (`cat_ids` = '1260' or `cat_ids` like '1260,%' or `cat_ids` like '%,1260' or `cat_ids` like '%,1260,%') and (`cat_ids` = '1261' or `cat_ids` like '1261,%' or `cat_ids` like '%,1261' or `cat_ids` like '%,1261,%') and (`cat_ids` = '1262' or `cat_ids` like '1262,%' or `cat_ids` like '%,1262' or `cat_ids` like '%,1262,%')) 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

21.16msys_test

Metadata

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 12 9. 12,% 10. %,12 11. %,12,% 12. 380 13. 380,% 14. %,380 15. %,380,% 16. 696 17. 696,% 18. %,696 19. %,696,% 20. 697 21. 697,% 22. %,697 23. %,697,% 24. 698 25. 698,% 26. %,698 27. %,698,% 28. 704 29. 704,% 30. %,704 31. %,704,% 32. 706 33. 706,% 34. %,706 35. %,706,% 36. 707 37. 707,% 38. %,707 39. %,707,% 40. 709 41. 709,% 42. %,709 43. %,709,% 44. 711 45. 711,% 46. %,711 47. %,711,% 48. 714 49. 714,% 50. %,714 51. %,714,% 52. 716 53. 716,% 54. %,716 55. %,716,% 56. 717 57. 717,% 58. %,717 59. %,717,% 60. 1244 61. 1244,% 62. %,1244 63. %,1244,% 64. 1245 65. 1245,% 66. %,1245 67. %,1245,% 68. 1246 69. 1246,% 70. %,1246 71. %,1246,% 72. 1247 73. 1247,% 74. %,1247 75. %,1247,% 76. 1248 77. 1248,% 78. %,1248 79. %,1248,% 80. 1249 81. 1249,% 82. %,1249 83. %,1249,% 84. 1250 85. 1250,% 86. %,1250 87. %,1250,% 88. 1251 89. 1251,% 90. %,1251 91. %,1251,% 92. 1252 93. 1252,% 94. %,1252 95. %,1252,% 96. 1253 97. 1253,% 98. %,1253 99. %,1253,% 100. 1254 101. 1254,% 102. %,1254 103. %,1254,% 104. 1255 105. 1255,% 106. %,1255 107. %,1255,% 108. 1256 109. 1256,% 110. %,1256 111. %,1256,% 112. 1257 113. 1257,% 114. %,1257 115. %,1257,% 116. 1258 117. 1258,% 118. %,1258 119. %,1258,% 120. 1259 121. 1259,% 122. %,1259 123. %,1259,% 124. 1260 125. 1260,% 126. %,1260 127. %,1260,% 128. 1261 129. 1261,% 130. %,1261 131. %,1261,% 132. 1262 133. 1262,% 134. %,1262 135. %,1262,% 136. 北京御生堂保健食品有限公司
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. 12
9. 12,%
10. %,12
11. %,12,%
12. 380
13. 380,%
14. %,380
15. %,380,%
16. 696
17. 696,%
18. %,696
19. %,696,%
20. 697
21. 697,%
22. %,697
23. %,697,%
24. 698
25. 698,%
26. %,698
27. %,698,%
28. 704
29. 704,%
30. %,704
31. %,704,%
32. 706
33. 706,%
34. %,706
35. %,706,%
36. 707
37. 707,%
38. %,707
39. %,707,%
40. 709
41. 709,%
42. %,709
43. %,709,%
44. 711
45. 711,%
46. %,711
47. %,711,%
48. 714
49. 714,%
50. %,714
51. %,714,%
52. 716
53. 716,%
54. %,716
55. %,716,%
56. 717
57. 717,%
58. %,717
59. %,717,%
60. 1244
61. 1244,%
62. %,1244
63. %,1244,%
64. 1245
65. 1245,%
66. %,1245
67. %,1245,%
68. 1246
69. 1246,%
70. %,1246
71. %,1246,%
72. 1247
73. 1247,%
74. %,1247
75. %,1247,%
76. 1248
77. 1248,%
78. %,1248
79. %,1248,%
80. 1249
81. 1249,%
82. %,1249
83. %,1249,%
84. 1250
85. 1250,%
86. %,1250
87. %,1250,%
88. 1251
89. 1251,%
90. %,1251
91. %,1251,%
92. 1252
93. 1252,%
94. %,1252
95. %,1252,%
96. 1253
97. 1253,%
98. %,1253
99. %,1253,%
100. 1254
101. 1254,%
102. %,1254
103. %,1254,%
104. 1255
105. 1255,%
106. %,1255
107. %,1255,%
108. 1256
109. 1256,%
110. %,1256
111. %,1256,%
112. 1257
113. 1257,%
114. %,1257
115. %,1257,%
116. 1258
117. 1258,%
118. %,1258
119. %,1258,%
120. 1259
121. 1259,%
122. %,1259
123. %,1259,%
124. 1260
125. 1260,%
126. %,1260
127. %,1260,%
128. 1261
129. 1261,%
130. %,1261
131. %,1261,%
132. 1262
133. 1262,%
134. %,1262
135. %,1262,%
136. 北京御生堂保健食品有限公司

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.56msys_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-05 09:01:53' and `end_time` > '2025-05-05 09:01:53' and `is_enabled` = '1' and isnull(delete_time) and `id` in ('2', '39', '1', '3', '4', '5', '7', '12', '15', '16', '17', '21', '24', '25', '33', '35', '40', '42', '43', '44', '45', '41', '48', '50', '54') limit 1

3.86msys_test

Metadata
Bindings	0. 2025-05-05 09:01:53 1. 2025-05-05 09:01:53 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` = '12' or `cat_ids` like '12,%' or `cat_ids` like '%,12' or `cat_ids` like '%,12,%') and (`cat_ids` = '380' or `cat_ids` like '380,%' or `cat_ids` like '%,380' or `cat_ids` like '%,380,%') and (`cat_ids` = '696' or `cat_ids` like '696,%' or `cat_ids` like '%,696' or `cat_ids` like '%,696,%') and (`cat_ids` = '697' or `cat_ids` like '697,%' or `cat_ids` like '%,697' or `cat_ids` like '%,697,%') and (`cat_ids` = '698' or `cat_ids` like '698,%' or `cat_ids` like '%,698' or `cat_ids` like '%,698,%') and (`cat_ids` = '704' or `cat_ids` like '704,%' or `cat_ids` like '%,704' or `cat_ids` like '%,704,%') and (`cat_ids` = '706' or `cat_ids` like '706,%' or `cat_ids` like '%,706' or `cat_ids` like '%,706,%') and (`cat_ids` = '707' or `cat_ids` like '707,%' or `cat_ids` like '%,707' or `cat_ids` like '%,707,%') and (`cat_ids` = '709' or `cat_ids` like '709,%' or `cat_ids` like '%,709' or `cat_ids` like '%,709,%') and (`cat_ids` = '711' or `cat_ids` like '711,%' or `cat_ids` like '%,711' or `cat_ids` like '%,711,%') and (`cat_ids` = '714' or `cat_ids` like '714,%' or `cat_ids` like '%,714' or `cat_ids` like '%,714,%') and (`cat_ids` = '716' or `cat_ids` like '716,%' or `cat_ids` like '%,716' or `cat_ids` like '%,716,%') and (`cat_ids` = '717' or `cat_ids` like '717,%' or `cat_ids` like '%,717' or `cat_ids` like '%,717,%') and (`cat_ids` = '1244' or `cat_ids` like '1244,%' or `cat_ids` like '%,1244' or `cat_ids` like '%,1244,%') and (`cat_ids` = '1245' or `cat_ids` like '1245,%' or `cat_ids` like '%,1245' or `cat_ids` like '%,1245,%') and (`cat_ids` = '1246' or `cat_ids` like '1246,%' or `cat_ids` like '%,1246' or `cat_ids` like '%,1246,%') and (`cat_ids` = '1247' or `cat_ids` like '1247,%' or `cat_ids` like '%,1247' or `cat_ids` like '%,1247,%') and (`cat_ids` = '1248' or `cat_ids` like '1248,%' or `cat_ids` like '%,1248' or `cat_ids` like '%,1248,%') and (`cat_ids` = '1249' or `cat_ids` like '1249,%' or `cat_ids` like '%,1249' or `cat_ids` like '%,1249,%') and (`cat_ids` = '1250' or `cat_ids` like '1250,%' or `cat_ids` like '%,1250' or `cat_ids` like '%,1250,%') and (`cat_ids` = '1251' or `cat_ids` like '1251,%' or `cat_ids` like '%,1251' or `cat_ids` like '%,1251,%') and (`cat_ids` = '1252' or `cat_ids` like '1252,%' or `cat_ids` like '%,1252' or `cat_ids` like '%,1252,%') and (`cat_ids` = '1253' or `cat_ids` like '1253,%' or `cat_ids` like '%,1253' or `cat_ids` like '%,1253,%') and (`cat_ids` = '1254' or `cat_ids` like '1254,%' or `cat_ids` like '%,1254' or `cat_ids` like '%,1254,%') and (`cat_ids` = '1255' or `cat_ids` like '1255,%' or `cat_ids` like '%,1255' or `cat_ids` like '%,1255,%') and (`cat_ids` = '1256' or `cat_ids` like '1256,%' or `cat_ids` like '%,1256' or `cat_ids` like '%,1256,%') and (`cat_ids` = '1257' or `cat_ids` like '1257,%' or `cat_ids` like '%,1257' or `cat_ids` like '%,1257,%') and (`cat_ids` = '1258' or `cat_ids` like '1258,%' or `cat_ids` like '%,1258' or `cat_ids` like '%,1258,%') and (`cat_ids` = '1259' or `cat_ids` like '1259,%' or `cat_ids` like '%,1259' or `cat_ids` like '%,1259,%') and (`cat_ids` = '1260' or `cat_ids` like '1260,%' or `cat_ids` like '%,1260' or `cat_ids` like '%,1260,%') and (`cat_ids` = '1261' or `cat_ids` like '1261,%' or `cat_ids` like '%,1261' or `cat_ids` like '%,1261,%') and (`cat_ids` = '1262' or `cat_ids` like '1262,%' or `cat_ids` like '%,1262' or `cat_ids` like '%,1262,%')) 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

13.68msys_test

Metadata

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. 12 9. 12,% 10. %,12 11. %,12,% 12. 380 13. 380,% 14. %,380 15. %,380,% 16. 696 17. 696,% 18. %,696 19. %,696,% 20. 697 21. 697,% 22. %,697 23. %,697,% 24. 698 25. 698,% 26. %,698 27. %,698,% 28. 704 29. 704,% 30. %,704 31. %,704,% 32. 706 33. 706,% 34. %,706 35. %,706,% 36. 707 37. 707,% 38. %,707 39. %,707,% 40. 709 41. 709,% 42. %,709 43. %,709,% 44. 711 45. 711,% 46. %,711 47. %,711,% 48. 714 49. 714,% 50. %,714 51. %,714,% 52. 716 53. 716,% 54. %,716 55. %,716,% 56. 717 57. 717,% 58. %,717 59. %,717,% 60. 1244 61. 1244,% 62. %,1244 63. %,1244,% 64. 1245 65. 1245,% 66. %,1245 67. %,1245,% 68. 1246 69. 1246,% 70. %,1246 71. %,1246,% 72. 1247 73. 1247,% 74. %,1247 75. %,1247,% 76. 1248 77. 1248,% 78. %,1248 79. %,1248,% 80. 1249 81. 1249,% 82. %,1249 83. %,1249,% 84. 1250 85. 1250,% 86. %,1250 87. %,1250,% 88. 1251 89. 1251,% 90. %,1251 91. %,1251,% 92. 1252 93. 1252,% 94. %,1252 95. %,1252,% 96. 1253 97. 1253,% 98. %,1253 99. %,1253,% 100. 1254 101. 1254,% 102. %,1254 103. %,1254,% 104. 1255 105. 1255,% 106. %,1255 107. %,1255,% 108. 1256 109. 1256,% 110. %,1256 111. %,1256,% 112. 1257 113. 1257,% 114. %,1257 115. %,1257,% 116. 1258 117. 1258,% 118. %,1258 119. %,1258,% 120. 1259 121. 1259,% 122. %,1259 123. %,1259,% 124. 1260 125. 1260,% 126. %,1260 127. %,1260,% 128. 1261 129. 1261,% 130. %,1261 131. %,1261,% 132. 1262 133. 1262,% 134. %,1262 135. %,1262,% 136. 北京御生堂保健食品有限公司 137.
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. 12
9. 12,%
10. %,12
11. %,12,%
12. 380
13. 380,%
14. %,380
15. %,380,%
16. 696
17. 696,%
18. %,696
19. %,696,%
20. 697
21. 697,%
22. %,697
23. %,697,%
24. 698
25. 698,%
26. %,698
27. %,698,%
28. 704
29. 704,%
30. %,704
31. %,704,%
32. 706
33. 706,%
34. %,706
35. %,706,%
36. 707
37. 707,%
38. %,707
39. %,707,%
40. 709
41. 709,%
42. %,709
43. %,709,%
44. 711
45. 711,%
46. %,711
47. %,711,%
48. 714
49. 714,%
50. %,714
51. %,714,%
52. 716
53. 716,%
54. %,716
55. %,716,%
56. 717
57. 717,%
58. %,717
59. %,717,%
60. 1244
61. 1244,%
62. %,1244
63. %,1244,%
64. 1245
65. 1245,%
66. %,1245
67. %,1245,%
68. 1246
69. 1246,%
70. %,1246
71. %,1246,%
72. 1247
73. 1247,%
74. %,1247
75. %,1247,%
76. 1248
77. 1248,%
78. %,1248
79. %,1248,%
80. 1249
81. 1249,%
82. %,1249
83. %,1249,%
84. 1250
85. 1250,%
86. %,1250
87. %,1250,%
88. 1251
89. 1251,%
90. %,1251
91. %,1251,%
92. 1252
93. 1252,%
94. %,1252
95. %,1252,%
96. 1253
97. 1253,%
98. %,1253
99. %,1253,%
100. 1254
101. 1254,%
102. %,1254
103. %,1254,%
104. 1255
105. 1255,%
106. %,1255
107. %,1255,%
108. 1256
109. 1256,%
110. %,1256
111. %,1256,%
112. 1257
113. 1257,%
114. %,1257
115. %,1257,%
116. 1258
117. 1258,%
118. %,1258
119. %,1258,%
120. 1259
121. 1259,%
122. %,1259
123. %,1259,%
124. 1260
125. 1260,%
126. %,1260
127. %,1260,%
128. 1261
129. 1261,%
130. %,1261
131. %,1261,%
132. 1262
133. 1262,%
134. %,1262
135. %,1262,%
136. 北京御生堂保健食品有限公司
137.

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` > '1746406913' order by `sort_order` desc, `ad_id` desc3.67msys_test
Metadata
Bindings
0. 152
1. 0
2. 1746406913
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` > '1746406913' order by `sort_order` desc, `ad_id` desc3.7msys_test
Metadata
Bindings
0. 159
1. 0
2. 1746406913
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.66msys_test
Metadata
Bindings
0. 1
1. middle
select `cat_id`, `cat_name`, `sort_order` from `ecs_article_cat` where `cat_id` = '5' limit 13.45msys_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.56msys_test
Metadata
Bindings
0. 5
1. 1

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

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

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: array:3 [ "cat_id" => "12" "product_name" => "北京御生堂保健食品有限公司" "style" => "g" ]
request_request: array:3 [ "cat_id" => "12" "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 => "Mon...
path_info: /search_goods
session_attributes: array:2 [ "_token" => "gWptQcZnO05JxJwTxGVwEKDWe9kfd3CDmqbvcNaP" "PHPDEBUGBAR_STACK_DATA" => [] ...