商品搜索-博大医药网

热门搜索：

订单查询

购物车0

全部商品分类

药理分类：妇、儿科

国药集团武汉中联四药药业有限公司

药理分类：

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

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

发布求购

消息

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

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

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

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

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

500包邮全场满500元包邮

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

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

Messages Timeline Exceptions Views13 Route Queries11 Mails Session Request

338.51ms4MBGET search_goods

Booting (166.33ms)
Application (193.92ms)

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 executed92.22ms

select id from ecs_sensitive_words where '' like concat('%', keywords, '%')12.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` = 'g' or `cat_ids` like 'g,%' or `cat_ids` like '%,g' or `cat_ids` like '%,g,%') and (`cat_ids` = '536' or `cat_ids` like '536,%' or `cat_ids` like '%,536' or `cat_ids` like '%,536,%') and (`cat_ids` = '560' or `cat_ids` like '560,%' or `cat_ids` like '%,560' or `cat_ids` like '%,560,%') and (`cat_ids` = '561' or `cat_ids` like '561,%' or `cat_ids` like '%,561' or `cat_ids` like '%,561,%') and (`cat_ids` = '562' or `cat_ids` like '562,%' or `cat_ids` like '%,562' or `cat_ids` like '%,562,%') and (`cat_ids` = '563' or `cat_ids` like '563,%' or `cat_ids` like '%,563' or `cat_ids` like '%,563,%') and (`cat_ids` = '564' or `cat_ids` like '564,%' or `cat_ids` like '%,564' or `cat_ids` like '%,564,%') and (`cat_ids` = '1175' or `cat_ids` like '1175,%' or `cat_ids` like '%,1175' or `cat_ids` like '%,1175,%') and (`cat_ids` = '569' or `cat_ids` like '569,%' or `cat_ids` like '%,569' or `cat_ids` like '%,569,%') and (`cat_ids` = '578' or `cat_ids` like '578,%' or `cat_ids` like '%,578' or `cat_ids` like '%,578,%') and (`cat_ids` = '579' or `cat_ids` like '579,%' or `cat_ids` like '%,579' or `cat_ids` like '%,579,%') and (`cat_ids` = '580' or `cat_ids` like '580,%' or `cat_ids` like '%,580' or `cat_ids` like '%,580,%') and (`cat_ids` = '583' or `cat_ids` like '583,%' or `cat_ids` like '%,583' or `cat_ids` like '%,583,%') and (`cat_ids` = '843' or `cat_ids` like '843,%' or `cat_ids` like '%,843' or `cat_ids` like '%,843,%') and (`cat_ids` = '845' or `cat_ids` like '845,%' or `cat_ids` like '%,845' or `cat_ids` like '%,845,%') and (`cat_ids` = '1176' or `cat_ids` like '1176,%' or `cat_ids` like '%,1176' or `cat_ids` like '%,1176,%') and (`cat_ids` = '1177' or `cat_ids` like '1177,%' or `cat_ids` like '%,1177' or `cat_ids` like '%,1177,%') and (`cat_ids` = '1178' or `cat_ids` like '1178,%' or `cat_ids` like '%,1178' or `cat_ids` like '%,1178,%') and (`cat_ids` = '1179' or `cat_ids` like '1179,%' or `cat_ids` like '%,1179' or `cat_ids` like '%,1179,%') and (`cat_ids` = '1180' or `cat_ids` like '1180,%' or `cat_ids` like '%,1180' or `cat_ids` like '%,1180,%') and (`cat_ids` = '584' or `cat_ids` like '584,%' or `cat_ids` like '%,584' or `cat_ids` like '%,584,%') and (`cat_ids` = '810' or `cat_ids` like '810,%' or `cat_ids` like '%,810' or `cat_ids` like '%,810,%') and (`cat_ids` = '592' or `cat_ids` like '592,%' or `cat_ids` like '%,592' or `cat_ids` like '%,592,%') and (`cat_ids` = '596' or `cat_ids` like '596,%' or `cat_ids` like '%,596' or `cat_ids` like '%,596,%') and (`cat_ids` = '599' or `cat_ids` like '599,%' or `cat_ids` like '%,599' or `cat_ids` like '%,599,%') and (`cat_ids` = '1181' or `cat_ids` like '1181,%' or `cat_ids` like '%,1181' or `cat_ids` like '%,1181,%') and (`cat_ids` = '1182' or `cat_ids` like '1182,%' or `cat_ids` like '%,1182' or `cat_ids` like '%,1182,%') and (`cat_ids` = '1183' or `cat_ids` like '1183,%' or `cat_ids` like '%,1183' or `cat_ids` like '%,1183,%') and (`cat_ids` = '720' or `cat_ids` like '720,%' or `cat_ids` like '%,720' or `cat_ids` like '%,720,%') and (`cat_ids` = '723' or `cat_ids` like '723,%' or `cat_ids` like '%,723' or `cat_ids` like '%,723,%') and (`cat_ids` = '728' or `cat_ids` like '728,%' or `cat_ids` like '%,728' or `cat_ids` like '%,728,%') and (`cat_ids` = '729' or `cat_ids` like '729,%' or `cat_ids` like '%,729' or `cat_ids` like '%,729,%') and (`cat_ids` = '730' or `cat_ids` like '730,%' or `cat_ids` like '%,730' or `cat_ids` like '%,730,%') and (`cat_ids` = '731' or `cat_ids` like '731,%' or `cat_ids` like '%,731' or `cat_ids` like '%,731,%')) and `ecs_goods`.`product_name` = '国药集团武汉中联四药药业有限公司'

17.74msys_test

Metadata

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. g 9. g,% 10. %,g 11. %,g,% 12. 536 13. 536,% 14. %,536 15. %,536,% 16. 560 17. 560,% 18. %,560 19. %,560,% 20. 561 21. 561,% 22. %,561 23. %,561,% 24. 562 25. 562,% 26. %,562 27. %,562,% 28. 563 29. 563,% 30. %,563 31. %,563,% 32. 564 33. 564,% 34. %,564 35. %,564,% 36. 1175 37. 1175,% 38. %,1175 39. %,1175,% 40. 569 41. 569,% 42. %,569 43. %,569,% 44. 578 45. 578,% 46. %,578 47. %,578,% 48. 579 49. 579,% 50. %,579 51. %,579,% 52. 580 53. 580,% 54. %,580 55. %,580,% 56. 583 57. 583,% 58. %,583 59. %,583,% 60. 843 61. 843,% 62. %,843 63. %,843,% 64. 845 65. 845,% 66. %,845 67. %,845,% 68. 1176 69. 1176,% 70. %,1176 71. %,1176,% 72. 1177 73. 1177,% 74. %,1177 75. %,1177,% 76. 1178 77. 1178,% 78. %,1178 79. %,1178,% 80. 1179 81. 1179,% 82. %,1179 83. %,1179,% 84. 1180 85. 1180,% 86. %,1180 87. %,1180,% 88. 584 89. 584,% 90. %,584 91. %,584,% 92. 810 93. 810,% 94. %,810 95. %,810,% 96. 592 97. 592,% 98. %,592 99. %,592,% 100. 596 101. 596,% 102. %,596 103. %,596,% 104. 599 105. 599,% 106. %,599 107. %,599,% 108. 1181 109. 1181,% 110. %,1181 111. %,1181,% 112. 1182 113. 1182,% 114. %,1182 115. %,1182,% 116. 1183 117. 1183,% 118. %,1183 119. %,1183,% 120. 720 121. 720,% 122. %,720 123. %,720,% 124. 723 125. 723,% 126. %,723 127. %,723,% 128. 728 129. 728,% 130. %,728 131. %,728,% 132. 729 133. 729,% 134. %,729 135. %,729,% 136. 730 137. 730,% 138. %,730 139. %,730,% 140. 731 141. 731,% 142. %,731 143. %,731,% 144. 国药集团武汉中联四药药业有限公司
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. g
9. g,%
10. %,g
11. %,g,%
12. 536
13. 536,%
14. %,536
15. %,536,%
16. 560
17. 560,%
18. %,560
19. %,560,%
20. 561
21. 561,%
22. %,561
23. %,561,%
24. 562
25. 562,%
26. %,562
27. %,562,%
28. 563
29. 563,%
30. %,563
31. %,563,%
32. 564
33. 564,%
34. %,564
35. %,564,%
36. 1175
37. 1175,%
38. %,1175
39. %,1175,%
40. 569
41. 569,%
42. %,569
43. %,569,%
44. 578
45. 578,%
46. %,578
47. %,578,%
48. 579
49. 579,%
50. %,579
51. %,579,%
52. 580
53. 580,%
54. %,580
55. %,580,%
56. 583
57. 583,%
58. %,583
59. %,583,%
60. 843
61. 843,%
62. %,843
63. %,843,%
64. 845
65. 845,%
66. %,845
67. %,845,%
68. 1176
69. 1176,%
70. %,1176
71. %,1176,%
72. 1177
73. 1177,%
74. %,1177
75. %,1177,%
76. 1178
77. 1178,%
78. %,1178
79. %,1178,%
80. 1179
81. 1179,%
82. %,1179
83. %,1179,%
84. 1180
85. 1180,%
86. %,1180
87. %,1180,%
88. 584
89. 584,%
90. %,584
91. %,584,%
92. 810
93. 810,%
94. %,810
95. %,810,%
96. 592
97. 592,%
98. %,592
99. %,592,%
100. 596
101. 596,%
102. %,596
103. %,596,%
104. 599
105. 599,%
106. %,599
107. %,599,%
108. 1181
109. 1181,%
110. %,1181
111. %,1181,%
112. 1182
113. 1182,%
114. %,1182
115. %,1182,%
116. 1183
117. 1183,%
118. %,1183
119. %,1183,%
120. 720
121. 720,%
122. %,720
123. %,720,%
124. 723
125. 723,%
126. %,723
127. %,723,%
128. 728
129. 728,%
130. %,728
131. %,728,%
132. 729
133. 729,%
134. %,729
135. %,729,%
136. 730
137. 730,%
138. %,730
139. %,730,%
140. 731
141. 731,%
142. %,731
143. %,731,%
144. 国药集团武汉中联四药药业有限公司

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` = 'g' or `cat_ids` like 'g,%' or `cat_ids` like '%,g' or `cat_ids` like '%,g,%') and (`cat_ids` = '536' or `cat_ids` like '536,%' or `cat_ids` like '%,536' or `cat_ids` like '%,536,%') and (`cat_ids` = '560' or `cat_ids` like '560,%' or `cat_ids` like '%,560' or `cat_ids` like '%,560,%') and (`cat_ids` = '561' or `cat_ids` like '561,%' or `cat_ids` like '%,561' or `cat_ids` like '%,561,%') and (`cat_ids` = '562' or `cat_ids` like '562,%' or `cat_ids` like '%,562' or `cat_ids` like '%,562,%') and (`cat_ids` = '563' or `cat_ids` like '563,%' or `cat_ids` like '%,563' or `cat_ids` like '%,563,%') and (`cat_ids` = '564' or `cat_ids` like '564,%' or `cat_ids` like '%,564' or `cat_ids` like '%,564,%') and (`cat_ids` = '1175' or `cat_ids` like '1175,%' or `cat_ids` like '%,1175' or `cat_ids` like '%,1175,%') and (`cat_ids` = '569' or `cat_ids` like '569,%' or `cat_ids` like '%,569' or `cat_ids` like '%,569,%') and (`cat_ids` = '578' or `cat_ids` like '578,%' or `cat_ids` like '%,578' or `cat_ids` like '%,578,%') and (`cat_ids` = '579' or `cat_ids` like '579,%' or `cat_ids` like '%,579' or `cat_ids` like '%,579,%') and (`cat_ids` = '580' or `cat_ids` like '580,%' or `cat_ids` like '%,580' or `cat_ids` like '%,580,%') and (`cat_ids` = '583' or `cat_ids` like '583,%' or `cat_ids` like '%,583' or `cat_ids` like '%,583,%') and (`cat_ids` = '843' or `cat_ids` like '843,%' or `cat_ids` like '%,843' or `cat_ids` like '%,843,%') and (`cat_ids` = '845' or `cat_ids` like '845,%' or `cat_ids` like '%,845' or `cat_ids` like '%,845,%') and (`cat_ids` = '1176' or `cat_ids` like '1176,%' or `cat_ids` like '%,1176' or `cat_ids` like '%,1176,%') and (`cat_ids` = '1177' or `cat_ids` like '1177,%' or `cat_ids` like '%,1177' or `cat_ids` like '%,1177,%') and (`cat_ids` = '1178' or `cat_ids` like '1178,%' or `cat_ids` like '%,1178' or `cat_ids` like '%,1178,%') and (`cat_ids` = '1179' or `cat_ids` like '1179,%' or `cat_ids` like '%,1179' or `cat_ids` like '%,1179,%') and (`cat_ids` = '1180' or `cat_ids` like '1180,%' or `cat_ids` like '%,1180' or `cat_ids` like '%,1180,%') and (`cat_ids` = '584' or `cat_ids` like '584,%' or `cat_ids` like '%,584' or `cat_ids` like '%,584,%') and (`cat_ids` = '810' or `cat_ids` like '810,%' or `cat_ids` like '%,810' or `cat_ids` like '%,810,%') and (`cat_ids` = '592' or `cat_ids` like '592,%' or `cat_ids` like '%,592' or `cat_ids` like '%,592,%') and (`cat_ids` = '596' or `cat_ids` like '596,%' or `cat_ids` like '%,596' or `cat_ids` like '%,596,%') and (`cat_ids` = '599' or `cat_ids` like '599,%' or `cat_ids` like '%,599' or `cat_ids` like '%,599,%') and (`cat_ids` = '1181' or `cat_ids` like '1181,%' or `cat_ids` like '%,1181' or `cat_ids` like '%,1181,%') and (`cat_ids` = '1182' or `cat_ids` like '1182,%' or `cat_ids` like '%,1182' or `cat_ids` like '%,1182,%') and (`cat_ids` = '1183' or `cat_ids` like '1183,%' or `cat_ids` like '%,1183' or `cat_ids` like '%,1183,%') and (`cat_ids` = '720' or `cat_ids` like '720,%' or `cat_ids` like '%,720' or `cat_ids` like '%,720,%') and (`cat_ids` = '723' or `cat_ids` like '723,%' or `cat_ids` like '%,723' or `cat_ids` like '%,723,%') and (`cat_ids` = '728' or `cat_ids` like '728,%' or `cat_ids` like '%,728' or `cat_ids` like '%,728,%') and (`cat_ids` = '729' or `cat_ids` like '729,%' or `cat_ids` like '%,729' or `cat_ids` like '%,729,%') and (`cat_ids` = '730' or `cat_ids` like '730,%' or `cat_ids` like '%,730' or `cat_ids` like '%,730,%') and (`cat_ids` = '731' or `cat_ids` like '731,%' or `cat_ids` like '%,731' or `cat_ids` like '%,731,%')) 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

22.4msys_test

Metadata

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. g 9. g,% 10. %,g 11. %,g,% 12. 536 13. 536,% 14. %,536 15. %,536,% 16. 560 17. 560,% 18. %,560 19. %,560,% 20. 561 21. 561,% 22. %,561 23. %,561,% 24. 562 25. 562,% 26. %,562 27. %,562,% 28. 563 29. 563,% 30. %,563 31. %,563,% 32. 564 33. 564,% 34. %,564 35. %,564,% 36. 1175 37. 1175,% 38. %,1175 39. %,1175,% 40. 569 41. 569,% 42. %,569 43. %,569,% 44. 578 45. 578,% 46. %,578 47. %,578,% 48. 579 49. 579,% 50. %,579 51. %,579,% 52. 580 53. 580,% 54. %,580 55. %,580,% 56. 583 57. 583,% 58. %,583 59. %,583,% 60. 843 61. 843,% 62. %,843 63. %,843,% 64. 845 65. 845,% 66. %,845 67. %,845,% 68. 1176 69. 1176,% 70. %,1176 71. %,1176,% 72. 1177 73. 1177,% 74. %,1177 75. %,1177,% 76. 1178 77. 1178,% 78. %,1178 79. %,1178,% 80. 1179 81. 1179,% 82. %,1179 83. %,1179,% 84. 1180 85. 1180,% 86. %,1180 87. %,1180,% 88. 584 89. 584,% 90. %,584 91. %,584,% 92. 810 93. 810,% 94. %,810 95. %,810,% 96. 592 97. 592,% 98. %,592 99. %,592,% 100. 596 101. 596,% 102. %,596 103. %,596,% 104. 599 105. 599,% 106. %,599 107. %,599,% 108. 1181 109. 1181,% 110. %,1181 111. %,1181,% 112. 1182 113. 1182,% 114. %,1182 115. %,1182,% 116. 1183 117. 1183,% 118. %,1183 119. %,1183,% 120. 720 121. 720,% 122. %,720 123. %,720,% 124. 723 125. 723,% 126. %,723 127. %,723,% 128. 728 129. 728,% 130. %,728 131. %,728,% 132. 729 133. 729,% 134. %,729 135. %,729,% 136. 730 137. 730,% 138. %,730 139. %,730,% 140. 731 141. 731,% 142. %,731 143. %,731,% 144. 国药集团武汉中联四药药业有限公司
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. g
9. g,%
10. %,g
11. %,g,%
12. 536
13. 536,%
14. %,536
15. %,536,%
16. 560
17. 560,%
18. %,560
19. %,560,%
20. 561
21. 561,%
22. %,561
23. %,561,%
24. 562
25. 562,%
26. %,562
27. %,562,%
28. 563
29. 563,%
30. %,563
31. %,563,%
32. 564
33. 564,%
34. %,564
35. %,564,%
36. 1175
37. 1175,%
38. %,1175
39. %,1175,%
40. 569
41. 569,%
42. %,569
43. %,569,%
44. 578
45. 578,%
46. %,578
47. %,578,%
48. 579
49. 579,%
50. %,579
51. %,579,%
52. 580
53. 580,%
54. %,580
55. %,580,%
56. 583
57. 583,%
58. %,583
59. %,583,%
60. 843
61. 843,%
62. %,843
63. %,843,%
64. 845
65. 845,%
66. %,845
67. %,845,%
68. 1176
69. 1176,%
70. %,1176
71. %,1176,%
72. 1177
73. 1177,%
74. %,1177
75. %,1177,%
76. 1178
77. 1178,%
78. %,1178
79. %,1178,%
80. 1179
81. 1179,%
82. %,1179
83. %,1179,%
84. 1180
85. 1180,%
86. %,1180
87. %,1180,%
88. 584
89. 584,%
90. %,584
91. %,584,%
92. 810
93. 810,%
94. %,810
95. %,810,%
96. 592
97. 592,%
98. %,592
99. %,592,%
100. 596
101. 596,%
102. %,596
103. %,596,%
104. 599
105. 599,%
106. %,599
107. %,599,%
108. 1181
109. 1181,%
110. %,1181
111. %,1181,%
112. 1182
113. 1182,%
114. %,1182
115. %,1182,%
116. 1183
117. 1183,%
118. %,1183
119. %,1183,%
120. 720
121. 720,%
122. %,720
123. %,720,%
124. 723
125. 723,%
126. %,723
127. %,723,%
128. 728
129. 728,%
130. %,728
131. %,728,%
132. 729
133. 729,%
134. %,729
135. %,729,%
136. 730
137. 730,%
138. %,730
139. %,730,%
140. 731
141. 731,%
142. %,731
143. %,731,%
144. 国药集团武汉中联四药药业有限公司

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.38msys_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-03 01:26:49' and `end_time` > '2025-05-03 01:26:49' 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.4msys_test

Metadata
Bindings	0. 2025-05-03 01:26:49 1. 2025-05-03 01:26:49 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` = 'g' or `cat_ids` like 'g,%' or `cat_ids` like '%,g' or `cat_ids` like '%,g,%') and (`cat_ids` = '536' or `cat_ids` like '536,%' or `cat_ids` like '%,536' or `cat_ids` like '%,536,%') and (`cat_ids` = '560' or `cat_ids` like '560,%' or `cat_ids` like '%,560' or `cat_ids` like '%,560,%') and (`cat_ids` = '561' or `cat_ids` like '561,%' or `cat_ids` like '%,561' or `cat_ids` like '%,561,%') and (`cat_ids` = '562' or `cat_ids` like '562,%' or `cat_ids` like '%,562' or `cat_ids` like '%,562,%') and (`cat_ids` = '563' or `cat_ids` like '563,%' or `cat_ids` like '%,563' or `cat_ids` like '%,563,%') and (`cat_ids` = '564' or `cat_ids` like '564,%' or `cat_ids` like '%,564' or `cat_ids` like '%,564,%') and (`cat_ids` = '1175' or `cat_ids` like '1175,%' or `cat_ids` like '%,1175' or `cat_ids` like '%,1175,%') and (`cat_ids` = '569' or `cat_ids` like '569,%' or `cat_ids` like '%,569' or `cat_ids` like '%,569,%') and (`cat_ids` = '578' or `cat_ids` like '578,%' or `cat_ids` like '%,578' or `cat_ids` like '%,578,%') and (`cat_ids` = '579' or `cat_ids` like '579,%' or `cat_ids` like '%,579' or `cat_ids` like '%,579,%') and (`cat_ids` = '580' or `cat_ids` like '580,%' or `cat_ids` like '%,580' or `cat_ids` like '%,580,%') and (`cat_ids` = '583' or `cat_ids` like '583,%' or `cat_ids` like '%,583' or `cat_ids` like '%,583,%') and (`cat_ids` = '843' or `cat_ids` like '843,%' or `cat_ids` like '%,843' or `cat_ids` like '%,843,%') and (`cat_ids` = '845' or `cat_ids` like '845,%' or `cat_ids` like '%,845' or `cat_ids` like '%,845,%') and (`cat_ids` = '1176' or `cat_ids` like '1176,%' or `cat_ids` like '%,1176' or `cat_ids` like '%,1176,%') and (`cat_ids` = '1177' or `cat_ids` like '1177,%' or `cat_ids` like '%,1177' or `cat_ids` like '%,1177,%') and (`cat_ids` = '1178' or `cat_ids` like '1178,%' or `cat_ids` like '%,1178' or `cat_ids` like '%,1178,%') and (`cat_ids` = '1179' or `cat_ids` like '1179,%' or `cat_ids` like '%,1179' or `cat_ids` like '%,1179,%') and (`cat_ids` = '1180' or `cat_ids` like '1180,%' or `cat_ids` like '%,1180' or `cat_ids` like '%,1180,%') and (`cat_ids` = '584' or `cat_ids` like '584,%' or `cat_ids` like '%,584' or `cat_ids` like '%,584,%') and (`cat_ids` = '810' or `cat_ids` like '810,%' or `cat_ids` like '%,810' or `cat_ids` like '%,810,%') and (`cat_ids` = '592' or `cat_ids` like '592,%' or `cat_ids` like '%,592' or `cat_ids` like '%,592,%') and (`cat_ids` = '596' or `cat_ids` like '596,%' or `cat_ids` like '%,596' or `cat_ids` like '%,596,%') and (`cat_ids` = '599' or `cat_ids` like '599,%' or `cat_ids` like '%,599' or `cat_ids` like '%,599,%') and (`cat_ids` = '1181' or `cat_ids` like '1181,%' or `cat_ids` like '%,1181' or `cat_ids` like '%,1181,%') and (`cat_ids` = '1182' or `cat_ids` like '1182,%' or `cat_ids` like '%,1182' or `cat_ids` like '%,1182,%') and (`cat_ids` = '1183' or `cat_ids` like '1183,%' or `cat_ids` like '%,1183' or `cat_ids` like '%,1183,%') and (`cat_ids` = '720' or `cat_ids` like '720,%' or `cat_ids` like '%,720' or `cat_ids` like '%,720,%') and (`cat_ids` = '723' or `cat_ids` like '723,%' or `cat_ids` like '%,723' or `cat_ids` like '%,723,%') and (`cat_ids` = '728' or `cat_ids` like '728,%' or `cat_ids` like '%,728' or `cat_ids` like '%,728,%') and (`cat_ids` = '729' or `cat_ids` like '729,%' or `cat_ids` like '%,729' or `cat_ids` like '%,729,%') and (`cat_ids` = '730' or `cat_ids` like '730,%' or `cat_ids` like '%,730' or `cat_ids` like '%,730,%') and (`cat_ids` = '731' or `cat_ids` like '731,%' or `cat_ids` like '%,731' or `cat_ids` like '%,731,%')) 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

16.15msys_test

Metadata

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. g 9. g,% 10. %,g 11. %,g,% 12. 536 13. 536,% 14. %,536 15. %,536,% 16. 560 17. 560,% 18. %,560 19. %,560,% 20. 561 21. 561,% 22. %,561 23. %,561,% 24. 562 25. 562,% 26. %,562 27. %,562,% 28. 563 29. 563,% 30. %,563 31. %,563,% 32. 564 33. 564,% 34. %,564 35. %,564,% 36. 1175 37. 1175,% 38. %,1175 39. %,1175,% 40. 569 41. 569,% 42. %,569 43. %,569,% 44. 578 45. 578,% 46. %,578 47. %,578,% 48. 579 49. 579,% 50. %,579 51. %,579,% 52. 580 53. 580,% 54. %,580 55. %,580,% 56. 583 57. 583,% 58. %,583 59. %,583,% 60. 843 61. 843,% 62. %,843 63. %,843,% 64. 845 65. 845,% 66. %,845 67. %,845,% 68. 1176 69. 1176,% 70. %,1176 71. %,1176,% 72. 1177 73. 1177,% 74. %,1177 75. %,1177,% 76. 1178 77. 1178,% 78. %,1178 79. %,1178,% 80. 1179 81. 1179,% 82. %,1179 83. %,1179,% 84. 1180 85. 1180,% 86. %,1180 87. %,1180,% 88. 584 89. 584,% 90. %,584 91. %,584,% 92. 810 93. 810,% 94. %,810 95. %,810,% 96. 592 97. 592,% 98. %,592 99. %,592,% 100. 596 101. 596,% 102. %,596 103. %,596,% 104. 599 105. 599,% 106. %,599 107. %,599,% 108. 1181 109. 1181,% 110. %,1181 111. %,1181,% 112. 1182 113. 1182,% 114. %,1182 115. %,1182,% 116. 1183 117. 1183,% 118. %,1183 119. %,1183,% 120. 720 121. 720,% 122. %,720 123. %,720,% 124. 723 125. 723,% 126. %,723 127. %,723,% 128. 728 129. 728,% 130. %,728 131. %,728,% 132. 729 133. 729,% 134. %,729 135. %,729,% 136. 730 137. 730,% 138. %,730 139. %,730,% 140. 731 141. 731,% 142. %,731 143. %,731,% 144. 国药集团武汉中联四药药业有限公司 145.
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. g
9. g,%
10. %,g
11. %,g,%
12. 536
13. 536,%
14. %,536
15. %,536,%
16. 560
17. 560,%
18. %,560
19. %,560,%
20. 561
21. 561,%
22. %,561
23. %,561,%
24. 562
25. 562,%
26. %,562
27. %,562,%
28. 563
29. 563,%
30. %,563
31. %,563,%
32. 564
33. 564,%
34. %,564
35. %,564,%
36. 1175
37. 1175,%
38. %,1175
39. %,1175,%
40. 569
41. 569,%
42. %,569
43. %,569,%
44. 578
45. 578,%
46. %,578
47. %,578,%
48. 579
49. 579,%
50. %,579
51. %,579,%
52. 580
53. 580,%
54. %,580
55. %,580,%
56. 583
57. 583,%
58. %,583
59. %,583,%
60. 843
61. 843,%
62. %,843
63. %,843,%
64. 845
65. 845,%
66. %,845
67. %,845,%
68. 1176
69. 1176,%
70. %,1176
71. %,1176,%
72. 1177
73. 1177,%
74. %,1177
75. %,1177,%
76. 1178
77. 1178,%
78. %,1178
79. %,1178,%
80. 1179
81. 1179,%
82. %,1179
83. %,1179,%
84. 1180
85. 1180,%
86. %,1180
87. %,1180,%
88. 584
89. 584,%
90. %,584
91. %,584,%
92. 810
93. 810,%
94. %,810
95. %,810,%
96. 592
97. 592,%
98. %,592
99. %,592,%
100. 596
101. 596,%
102. %,596
103. %,596,%
104. 599
105. 599,%
106. %,599
107. %,599,%
108. 1181
109. 1181,%
110. %,1181
111. %,1181,%
112. 1182
113. 1182,%
114. %,1182
115. %,1182,%
116. 1183
117. 1183,%
118. %,1183
119. %,1183,%
120. 720
121. 720,%
122. %,720
123. %,720,%
124. 723
125. 723,%
126. %,723
127. %,723,%
128. 728
129. 728,%
130. %,728
131. %,728,%
132. 729
133. 729,%
134. %,729
135. %,729,%
136. 730
137. 730,%
138. %,730
139. %,730,%
140. 731
141. 731,%
142. %,731
143. %,731,%
144. 国药集团武汉中联四药药业有限公司
145.

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` > '1746206809' order by `sort_order` desc, `ad_id` desc4.05msys_test
Metadata
Bindings
0. 152
1. 0
2. 1746206809
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` > '1746206809' order by `sort_order` desc, `ad_id` desc3.08msys_test
Metadata
Bindings
0. 159
1. 0
2. 1746206809
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.08msys_test
Metadata
Bindings
0. 1
1. middle
select `cat_id`, `cat_name`, `sort_order` from `ecs_article_cat` where `cat_id` = '5' limit 12.89msys_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.27msys_test
Metadata
Bindings
0. 5
1. 1

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

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

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: array:3 [ "cat_id" => "g" "product_name" => "国药集团武汉中联四药药业有限公司" "style" => "g" ]
request_request: array:3 [ "cat_id" => "g" "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" => "XC0dX9efV7aLDbvYNPOiSj4SH9jQPxOjkYVDc2PL" "PHPDEBUGBAR_STACK_DATA" => [] ...