商品搜索-博大医药网

热门搜索：

订单查询

购物车0

全部商品分类

药理分类：补益安神及维矿类

贵州神奇药业有限公司

药理分类：

更多

收起

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

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

发布求购

消息

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

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

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

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

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

500包邮全场满500元包邮

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

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

Messages Timeline Exceptions Views13 Route Queries11 Mails Session Request

421.14ms4MBGET search_goods

Booting (187.93ms)
Application (258.39ms)

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 executed104.29ms

select id from ecs_sensitive_words where '' like concat('%', keywords, '%')14.33msys_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` = 'f' or `cat_ids` like 'f,%' or `cat_ids` like '%,f' or `cat_ids` like '%,f,%') and (`cat_ids` = '628' or `cat_ids` like '628,%' or `cat_ids` like '%,628' or `cat_ids` like '%,628,%') and (`cat_ids` = '634' or `cat_ids` like '634,%' or `cat_ids` like '%,634' or `cat_ids` like '%,634,%') and (`cat_ids` = '637' or `cat_ids` like '637,%' or `cat_ids` like '%,637' or `cat_ids` like '%,637,%') and (`cat_ids` = '639' or `cat_ids` like '639,%' or `cat_ids` like '%,639' or `cat_ids` like '%,639,%') and (`cat_ids` = '640' or `cat_ids` like '640,%' or `cat_ids` like '%,640' or `cat_ids` like '%,640,%') and (`cat_ids` = '641' or `cat_ids` like '641,%' or `cat_ids` like '%,641' or `cat_ids` like '%,641,%') and (`cat_ids` = '642' or `cat_ids` like '642,%' or `cat_ids` like '%,642' or `cat_ids` like '%,642,%') and (`cat_ids` = '1157' or `cat_ids` like '1157,%' or `cat_ids` like '%,1157' or `cat_ids` like '%,1157,%') and (`cat_ids` = '1158' or `cat_ids` like '1158,%' or `cat_ids` like '%,1158' or `cat_ids` like '%,1158,%') and (`cat_ids` = '646' or `cat_ids` like '646,%' or `cat_ids` like '%,646' or `cat_ids` like '%,646,%') and (`cat_ids` = '1159' or `cat_ids` like '1159,%' or `cat_ids` like '%,1159' or `cat_ids` like '%,1159,%') and (`cat_ids` = '1160' or `cat_ids` like '1160,%' or `cat_ids` like '%,1160' or `cat_ids` like '%,1160,%') and (`cat_ids` = '649' or `cat_ids` like '649,%' or `cat_ids` like '%,649' or `cat_ids` like '%,649,%') and (`cat_ids` = '1161' or `cat_ids` like '1161,%' or `cat_ids` like '%,1161' or `cat_ids` like '%,1161,%') and (`cat_ids` = '1162' or `cat_ids` like '1162,%' or `cat_ids` like '%,1162' or `cat_ids` like '%,1162,%') and (`cat_ids` = '651' or `cat_ids` like '651,%' or `cat_ids` like '%,651' or `cat_ids` like '%,651,%') and (`cat_ids` = '1163' or `cat_ids` like '1163,%' or `cat_ids` like '%,1163' or `cat_ids` like '%,1163,%') and (`cat_ids` = '652' or `cat_ids` like '652,%' or `cat_ids` like '%,652' or `cat_ids` like '%,652,%') and (`cat_ids` = '1164' or `cat_ids` like '1164,%' or `cat_ids` like '%,1164' or `cat_ids` like '%,1164,%') and (`cat_ids` = '1165' or `cat_ids` like '1165,%' or `cat_ids` like '%,1165' or `cat_ids` like '%,1165,%') and (`cat_ids` = '1166' or `cat_ids` like '1166,%' or `cat_ids` like '%,1166' or `cat_ids` like '%,1166,%') and (`cat_ids` = '1167' or `cat_ids` like '1167,%' or `cat_ids` like '%,1167' or `cat_ids` like '%,1167,%') and (`cat_ids` = '1168' or `cat_ids` like '1168,%' or `cat_ids` like '%,1168' or `cat_ids` like '%,1168,%') and (`cat_ids` = '1169' or `cat_ids` like '1169,%' or `cat_ids` like '%,1169' or `cat_ids` like '%,1169,%') and (`cat_ids` = '1170' or `cat_ids` like '1170,%' or `cat_ids` like '%,1170' or `cat_ids` like '%,1170,%') and (`cat_ids` = '1171' or `cat_ids` like '1171,%' or `cat_ids` like '%,1171' or `cat_ids` like '%,1171,%') and (`cat_ids` = '1172' or `cat_ids` like '1172,%' or `cat_ids` like '%,1172' or `cat_ids` like '%,1172,%') and (`cat_ids` = '1173' or `cat_ids` like '1173,%' or `cat_ids` like '%,1173' or `cat_ids` like '%,1173,%') and (`cat_ids` = '1174' or `cat_ids` like '1174,%' or `cat_ids` like '%,1174' or `cat_ids` like '%,1174,%')) and `ecs_goods`.`product_name` = '贵州神奇药业有限公司'

24.17msys_test

Metadata

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. f 9. f,% 10. %,f 11. %,f,% 12. 628 13. 628,% 14. %,628 15. %,628,% 16. 634 17. 634,% 18. %,634 19. %,634,% 20. 637 21. 637,% 22. %,637 23. %,637,% 24. 639 25. 639,% 26. %,639 27. %,639,% 28. 640 29. 640,% 30. %,640 31. %,640,% 32. 641 33. 641,% 34. %,641 35. %,641,% 36. 642 37. 642,% 38. %,642 39. %,642,% 40. 1157 41. 1157,% 42. %,1157 43. %,1157,% 44. 1158 45. 1158,% 46. %,1158 47. %,1158,% 48. 646 49. 646,% 50. %,646 51. %,646,% 52. 1159 53. 1159,% 54. %,1159 55. %,1159,% 56. 1160 57. 1160,% 58. %,1160 59. %,1160,% 60. 649 61. 649,% 62. %,649 63. %,649,% 64. 1161 65. 1161,% 66. %,1161 67. %,1161,% 68. 1162 69. 1162,% 70. %,1162 71. %,1162,% 72. 651 73. 651,% 74. %,651 75. %,651,% 76. 1163 77. 1163,% 78. %,1163 79. %,1163,% 80. 652 81. 652,% 82. %,652 83. %,652,% 84. 1164 85. 1164,% 86. %,1164 87. %,1164,% 88. 1165 89. 1165,% 90. %,1165 91. %,1165,% 92. 1166 93. 1166,% 94. %,1166 95. %,1166,% 96. 1167 97. 1167,% 98. %,1167 99. %,1167,% 100. 1168 101. 1168,% 102. %,1168 103. %,1168,% 104. 1169 105. 1169,% 106. %,1169 107. %,1169,% 108. 1170 109. 1170,% 110. %,1170 111. %,1170,% 112. 1171 113. 1171,% 114. %,1171 115. %,1171,% 116. 1172 117. 1172,% 118. %,1172 119. %,1172,% 120. 1173 121. 1173,% 122. %,1173 123. %,1173,% 124. 1174 125. 1174,% 126. %,1174 127. %,1174,% 128. 贵州神奇药业有限公司
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. f
9. f,%
10. %,f
11. %,f,%
12. 628
13. 628,%
14. %,628
15. %,628,%
16. 634
17. 634,%
18. %,634
19. %,634,%
20. 637
21. 637,%
22. %,637
23. %,637,%
24. 639
25. 639,%
26. %,639
27. %,639,%
28. 640
29. 640,%
30. %,640
31. %,640,%
32. 641
33. 641,%
34. %,641
35. %,641,%
36. 642
37. 642,%
38. %,642
39. %,642,%
40. 1157
41. 1157,%
42. %,1157
43. %,1157,%
44. 1158
45. 1158,%
46. %,1158
47. %,1158,%
48. 646
49. 646,%
50. %,646
51. %,646,%
52. 1159
53. 1159,%
54. %,1159
55. %,1159,%
56. 1160
57. 1160,%
58. %,1160
59. %,1160,%
60. 649
61. 649,%
62. %,649
63. %,649,%
64. 1161
65. 1161,%
66. %,1161
67. %,1161,%
68. 1162
69. 1162,%
70. %,1162
71. %,1162,%
72. 651
73. 651,%
74. %,651
75. %,651,%
76. 1163
77. 1163,%
78. %,1163
79. %,1163,%
80. 652
81. 652,%
82. %,652
83. %,652,%
84. 1164
85. 1164,%
86. %,1164
87. %,1164,%
88. 1165
89. 1165,%
90. %,1165
91. %,1165,%
92. 1166
93. 1166,%
94. %,1166
95. %,1166,%
96. 1167
97. 1167,%
98. %,1167
99. %,1167,%
100. 1168
101. 1168,%
102. %,1168
103. %,1168,%
104. 1169
105. 1169,%
106. %,1169
107. %,1169,%
108. 1170
109. 1170,%
110. %,1170
111. %,1170,%
112. 1171
113. 1171,%
114. %,1171
115. %,1171,%
116. 1172
117. 1172,%
118. %,1172
119. %,1172,%
120. 1173
121. 1173,%
122. %,1173
123. %,1173,%
124. 1174
125. 1174,%
126. %,1174
127. %,1174,%
128. 贵州神奇药业有限公司

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` = 'f' or `cat_ids` like 'f,%' or `cat_ids` like '%,f' or `cat_ids` like '%,f,%') and (`cat_ids` = '628' or `cat_ids` like '628,%' or `cat_ids` like '%,628' or `cat_ids` like '%,628,%') and (`cat_ids` = '634' or `cat_ids` like '634,%' or `cat_ids` like '%,634' or `cat_ids` like '%,634,%') and (`cat_ids` = '637' or `cat_ids` like '637,%' or `cat_ids` like '%,637' or `cat_ids` like '%,637,%') and (`cat_ids` = '639' or `cat_ids` like '639,%' or `cat_ids` like '%,639' or `cat_ids` like '%,639,%') and (`cat_ids` = '640' or `cat_ids` like '640,%' or `cat_ids` like '%,640' or `cat_ids` like '%,640,%') and (`cat_ids` = '641' or `cat_ids` like '641,%' or `cat_ids` like '%,641' or `cat_ids` like '%,641,%') and (`cat_ids` = '642' or `cat_ids` like '642,%' or `cat_ids` like '%,642' or `cat_ids` like '%,642,%') and (`cat_ids` = '1157' or `cat_ids` like '1157,%' or `cat_ids` like '%,1157' or `cat_ids` like '%,1157,%') and (`cat_ids` = '1158' or `cat_ids` like '1158,%' or `cat_ids` like '%,1158' or `cat_ids` like '%,1158,%') and (`cat_ids` = '646' or `cat_ids` like '646,%' or `cat_ids` like '%,646' or `cat_ids` like '%,646,%') and (`cat_ids` = '1159' or `cat_ids` like '1159,%' or `cat_ids` like '%,1159' or `cat_ids` like '%,1159,%') and (`cat_ids` = '1160' or `cat_ids` like '1160,%' or `cat_ids` like '%,1160' or `cat_ids` like '%,1160,%') and (`cat_ids` = '649' or `cat_ids` like '649,%' or `cat_ids` like '%,649' or `cat_ids` like '%,649,%') and (`cat_ids` = '1161' or `cat_ids` like '1161,%' or `cat_ids` like '%,1161' or `cat_ids` like '%,1161,%') and (`cat_ids` = '1162' or `cat_ids` like '1162,%' or `cat_ids` like '%,1162' or `cat_ids` like '%,1162,%') and (`cat_ids` = '651' or `cat_ids` like '651,%' or `cat_ids` like '%,651' or `cat_ids` like '%,651,%') and (`cat_ids` = '1163' or `cat_ids` like '1163,%' or `cat_ids` like '%,1163' or `cat_ids` like '%,1163,%') and (`cat_ids` = '652' or `cat_ids` like '652,%' or `cat_ids` like '%,652' or `cat_ids` like '%,652,%') and (`cat_ids` = '1164' or `cat_ids` like '1164,%' or `cat_ids` like '%,1164' or `cat_ids` like '%,1164,%') and (`cat_ids` = '1165' or `cat_ids` like '1165,%' or `cat_ids` like '%,1165' or `cat_ids` like '%,1165,%') and (`cat_ids` = '1166' or `cat_ids` like '1166,%' or `cat_ids` like '%,1166' or `cat_ids` like '%,1166,%') and (`cat_ids` = '1167' or `cat_ids` like '1167,%' or `cat_ids` like '%,1167' or `cat_ids` like '%,1167,%') and (`cat_ids` = '1168' or `cat_ids` like '1168,%' or `cat_ids` like '%,1168' or `cat_ids` like '%,1168,%') and (`cat_ids` = '1169' or `cat_ids` like '1169,%' or `cat_ids` like '%,1169' or `cat_ids` like '%,1169,%') and (`cat_ids` = '1170' or `cat_ids` like '1170,%' or `cat_ids` like '%,1170' or `cat_ids` like '%,1170,%') and (`cat_ids` = '1171' or `cat_ids` like '1171,%' or `cat_ids` like '%,1171' or `cat_ids` like '%,1171,%') and (`cat_ids` = '1172' or `cat_ids` like '1172,%' or `cat_ids` like '%,1172' or `cat_ids` like '%,1172,%') and (`cat_ids` = '1173' or `cat_ids` like '1173,%' or `cat_ids` like '%,1173' or `cat_ids` like '%,1173,%') and (`cat_ids` = '1174' or `cat_ids` like '1174,%' or `cat_ids` like '%,1174' or `cat_ids` like '%,1174,%')) 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

24.79msys_test

Metadata

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. f 9. f,% 10. %,f 11. %,f,% 12. 628 13. 628,% 14. %,628 15. %,628,% 16. 634 17. 634,% 18. %,634 19. %,634,% 20. 637 21. 637,% 22. %,637 23. %,637,% 24. 639 25. 639,% 26. %,639 27. %,639,% 28. 640 29. 640,% 30. %,640 31. %,640,% 32. 641 33. 641,% 34. %,641 35. %,641,% 36. 642 37. 642,% 38. %,642 39. %,642,% 40. 1157 41. 1157,% 42. %,1157 43. %,1157,% 44. 1158 45. 1158,% 46. %,1158 47. %,1158,% 48. 646 49. 646,% 50. %,646 51. %,646,% 52. 1159 53. 1159,% 54. %,1159 55. %,1159,% 56. 1160 57. 1160,% 58. %,1160 59. %,1160,% 60. 649 61. 649,% 62. %,649 63. %,649,% 64. 1161 65. 1161,% 66. %,1161 67. %,1161,% 68. 1162 69. 1162,% 70. %,1162 71. %,1162,% 72. 651 73. 651,% 74. %,651 75. %,651,% 76. 1163 77. 1163,% 78. %,1163 79. %,1163,% 80. 652 81. 652,% 82. %,652 83. %,652,% 84. 1164 85. 1164,% 86. %,1164 87. %,1164,% 88. 1165 89. 1165,% 90. %,1165 91. %,1165,% 92. 1166 93. 1166,% 94. %,1166 95. %,1166,% 96. 1167 97. 1167,% 98. %,1167 99. %,1167,% 100. 1168 101. 1168,% 102. %,1168 103. %,1168,% 104. 1169 105. 1169,% 106. %,1169 107. %,1169,% 108. 1170 109. 1170,% 110. %,1170 111. %,1170,% 112. 1171 113. 1171,% 114. %,1171 115. %,1171,% 116. 1172 117. 1172,% 118. %,1172 119. %,1172,% 120. 1173 121. 1173,% 122. %,1173 123. %,1173,% 124. 1174 125. 1174,% 126. %,1174 127. %,1174,% 128. 贵州神奇药业有限公司
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. f
9. f,%
10. %,f
11. %,f,%
12. 628
13. 628,%
14. %,628
15. %,628,%
16. 634
17. 634,%
18. %,634
19. %,634,%
20. 637
21. 637,%
22. %,637
23. %,637,%
24. 639
25. 639,%
26. %,639
27. %,639,%
28. 640
29. 640,%
30. %,640
31. %,640,%
32. 641
33. 641,%
34. %,641
35. %,641,%
36. 642
37. 642,%
38. %,642
39. %,642,%
40. 1157
41. 1157,%
42. %,1157
43. %,1157,%
44. 1158
45. 1158,%
46. %,1158
47. %,1158,%
48. 646
49. 646,%
50. %,646
51. %,646,%
52. 1159
53. 1159,%
54. %,1159
55. %,1159,%
56. 1160
57. 1160,%
58. %,1160
59. %,1160,%
60. 649
61. 649,%
62. %,649
63. %,649,%
64. 1161
65. 1161,%
66. %,1161
67. %,1161,%
68. 1162
69. 1162,%
70. %,1162
71. %,1162,%
72. 651
73. 651,%
74. %,651
75. %,651,%
76. 1163
77. 1163,%
78. %,1163
79. %,1163,%
80. 652
81. 652,%
82. %,652
83. %,652,%
84. 1164
85. 1164,%
86. %,1164
87. %,1164,%
88. 1165
89. 1165,%
90. %,1165
91. %,1165,%
92. 1166
93. 1166,%
94. %,1166
95. %,1166,%
96. 1167
97. 1167,%
98. %,1167
99. %,1167,%
100. 1168
101. 1168,%
102. %,1168
103. %,1168,%
104. 1169
105. 1169,%
106. %,1169
107. %,1169,%
108. 1170
109. 1170,%
110. %,1170
111. %,1170,%
112. 1171
113. 1171,%
114. %,1171
115. %,1171,%
116. 1172
117. 1172,%
118. %,1172
119. %,1172,%
120. 1173
121. 1173,%
122. %,1173
123. %,1173,%
124. 1174
125. 1174,%
126. %,1174
127. %,1174,%
128. 贵州神奇药业有限公司

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.53msys_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 15:48:33' and `end_time` > '2025-04-29 15:48:33' 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.63msys_test

Metadata
Bindings	0. 2025-04-29 15:48:33 1. 2025-04-29 15:48:33 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` = 'f' or `cat_ids` like 'f,%' or `cat_ids` like '%,f' or `cat_ids` like '%,f,%') and (`cat_ids` = '628' or `cat_ids` like '628,%' or `cat_ids` like '%,628' or `cat_ids` like '%,628,%') and (`cat_ids` = '634' or `cat_ids` like '634,%' or `cat_ids` like '%,634' or `cat_ids` like '%,634,%') and (`cat_ids` = '637' or `cat_ids` like '637,%' or `cat_ids` like '%,637' or `cat_ids` like '%,637,%') and (`cat_ids` = '639' or `cat_ids` like '639,%' or `cat_ids` like '%,639' or `cat_ids` like '%,639,%') and (`cat_ids` = '640' or `cat_ids` like '640,%' or `cat_ids` like '%,640' or `cat_ids` like '%,640,%') and (`cat_ids` = '641' or `cat_ids` like '641,%' or `cat_ids` like '%,641' or `cat_ids` like '%,641,%') and (`cat_ids` = '642' or `cat_ids` like '642,%' or `cat_ids` like '%,642' or `cat_ids` like '%,642,%') and (`cat_ids` = '1157' or `cat_ids` like '1157,%' or `cat_ids` like '%,1157' or `cat_ids` like '%,1157,%') and (`cat_ids` = '1158' or `cat_ids` like '1158,%' or `cat_ids` like '%,1158' or `cat_ids` like '%,1158,%') and (`cat_ids` = '646' or `cat_ids` like '646,%' or `cat_ids` like '%,646' or `cat_ids` like '%,646,%') and (`cat_ids` = '1159' or `cat_ids` like '1159,%' or `cat_ids` like '%,1159' or `cat_ids` like '%,1159,%') and (`cat_ids` = '1160' or `cat_ids` like '1160,%' or `cat_ids` like '%,1160' or `cat_ids` like '%,1160,%') and (`cat_ids` = '649' or `cat_ids` like '649,%' or `cat_ids` like '%,649' or `cat_ids` like '%,649,%') and (`cat_ids` = '1161' or `cat_ids` like '1161,%' or `cat_ids` like '%,1161' or `cat_ids` like '%,1161,%') and (`cat_ids` = '1162' or `cat_ids` like '1162,%' or `cat_ids` like '%,1162' or `cat_ids` like '%,1162,%') and (`cat_ids` = '651' or `cat_ids` like '651,%' or `cat_ids` like '%,651' or `cat_ids` like '%,651,%') and (`cat_ids` = '1163' or `cat_ids` like '1163,%' or `cat_ids` like '%,1163' or `cat_ids` like '%,1163,%') and (`cat_ids` = '652' or `cat_ids` like '652,%' or `cat_ids` like '%,652' or `cat_ids` like '%,652,%') and (`cat_ids` = '1164' or `cat_ids` like '1164,%' or `cat_ids` like '%,1164' or `cat_ids` like '%,1164,%') and (`cat_ids` = '1165' or `cat_ids` like '1165,%' or `cat_ids` like '%,1165' or `cat_ids` like '%,1165,%') and (`cat_ids` = '1166' or `cat_ids` like '1166,%' or `cat_ids` like '%,1166' or `cat_ids` like '%,1166,%') and (`cat_ids` = '1167' or `cat_ids` like '1167,%' or `cat_ids` like '%,1167' or `cat_ids` like '%,1167,%') and (`cat_ids` = '1168' or `cat_ids` like '1168,%' or `cat_ids` like '%,1168' or `cat_ids` like '%,1168,%') and (`cat_ids` = '1169' or `cat_ids` like '1169,%' or `cat_ids` like '%,1169' or `cat_ids` like '%,1169,%') and (`cat_ids` = '1170' or `cat_ids` like '1170,%' or `cat_ids` like '%,1170' or `cat_ids` like '%,1170,%') and (`cat_ids` = '1171' or `cat_ids` like '1171,%' or `cat_ids` like '%,1171' or `cat_ids` like '%,1171,%') and (`cat_ids` = '1172' or `cat_ids` like '1172,%' or `cat_ids` like '%,1172' or `cat_ids` like '%,1172,%') and (`cat_ids` = '1173' or `cat_ids` like '1173,%' or `cat_ids` like '%,1173' or `cat_ids` like '%,1173,%') and (`cat_ids` = '1174' or `cat_ids` like '1174,%' or `cat_ids` like '%,1174' or `cat_ids` like '%,1174,%')) 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.02msys_test

Metadata

Metadata
Bindings	0. 0 1. 0 2. 1 3. 1,2,5,7,8,9 4. %% 5. %% 6. %% 7. %% 8. f 9. f,% 10. %,f 11. %,f,% 12. 628 13. 628,% 14. %,628 15. %,628,% 16. 634 17. 634,% 18. %,634 19. %,634,% 20. 637 21. 637,% 22. %,637 23. %,637,% 24. 639 25. 639,% 26. %,639 27. %,639,% 28. 640 29. 640,% 30. %,640 31. %,640,% 32. 641 33. 641,% 34. %,641 35. %,641,% 36. 642 37. 642,% 38. %,642 39. %,642,% 40. 1157 41. 1157,% 42. %,1157 43. %,1157,% 44. 1158 45. 1158,% 46. %,1158 47. %,1158,% 48. 646 49. 646,% 50. %,646 51. %,646,% 52. 1159 53. 1159,% 54. %,1159 55. %,1159,% 56. 1160 57. 1160,% 58. %,1160 59. %,1160,% 60. 649 61. 649,% 62. %,649 63. %,649,% 64. 1161 65. 1161,% 66. %,1161 67. %,1161,% 68. 1162 69. 1162,% 70. %,1162 71. %,1162,% 72. 651 73. 651,% 74. %,651 75. %,651,% 76. 1163 77. 1163,% 78. %,1163 79. %,1163,% 80. 652 81. 652,% 82. %,652 83. %,652,% 84. 1164 85. 1164,% 86. %,1164 87. %,1164,% 88. 1165 89. 1165,% 90. %,1165 91. %,1165,% 92. 1166 93. 1166,% 94. %,1166 95. %,1166,% 96. 1167 97. 1167,% 98. %,1167 99. %,1167,% 100. 1168 101. 1168,% 102. %,1168 103. %,1168,% 104. 1169 105. 1169,% 106. %,1169 107. %,1169,% 108. 1170 109. 1170,% 110. %,1170 111. %,1170,% 112. 1171 113. 1171,% 114. %,1171 115. %,1171,% 116. 1172 117. 1172,% 118. %,1172 119. %,1172,% 120. 1173 121. 1173,% 122. %,1173 123. %,1173,% 124. 1174 125. 1174,% 126. %,1174 127. %,1174,% 128. 贵州神奇药业有限公司 129.
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. f
9. f,%
10. %,f
11. %,f,%
12. 628
13. 628,%
14. %,628
15. %,628,%
16. 634
17. 634,%
18. %,634
19. %,634,%
20. 637
21. 637,%
22. %,637
23. %,637,%
24. 639
25. 639,%
26. %,639
27. %,639,%
28. 640
29. 640,%
30. %,640
31. %,640,%
32. 641
33. 641,%
34. %,641
35. %,641,%
36. 642
37. 642,%
38. %,642
39. %,642,%
40. 1157
41. 1157,%
42. %,1157
43. %,1157,%
44. 1158
45. 1158,%
46. %,1158
47. %,1158,%
48. 646
49. 646,%
50. %,646
51. %,646,%
52. 1159
53. 1159,%
54. %,1159
55. %,1159,%
56. 1160
57. 1160,%
58. %,1160
59. %,1160,%
60. 649
61. 649,%
62. %,649
63. %,649,%
64. 1161
65. 1161,%
66. %,1161
67. %,1161,%
68. 1162
69. 1162,%
70. %,1162
71. %,1162,%
72. 651
73. 651,%
74. %,651
75. %,651,%
76. 1163
77. 1163,%
78. %,1163
79. %,1163,%
80. 652
81. 652,%
82. %,652
83. %,652,%
84. 1164
85. 1164,%
86. %,1164
87. %,1164,%
88. 1165
89. 1165,%
90. %,1165
91. %,1165,%
92. 1166
93. 1166,%
94. %,1166
95. %,1166,%
96. 1167
97. 1167,%
98. %,1167
99. %,1167,%
100. 1168
101. 1168,%
102. %,1168
103. %,1168,%
104. 1169
105. 1169,%
106. %,1169
107. %,1169,%
108. 1170
109. 1170,%
110. %,1170
111. %,1170,%
112. 1171
113. 1171,%
114. %,1171
115. %,1171,%
116. 1172
117. 1172,%
118. %,1172
119. %,1172,%
120. 1173
121. 1173,%
122. %,1173
123. %,1173,%
124. 1174
125. 1174,%
126. %,1174
127. %,1174,%
128. 贵州神奇药业有限公司
129.

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` > '1745912913' order by `sort_order` desc, `ad_id` desc2.08msys_test
Metadata
Bindings
0. 152
1. 0
2. 1745912913
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` > '1745912913' order by `sort_order` desc, `ad_id` desc6.88msys_test
Metadata
Bindings
0. 159
1. 0
2. 1745912913
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` asc5.04msys_test
Metadata
Bindings
0. 1
1. middle
select `cat_id`, `cat_name`, `sort_order` from `ecs_article_cat` where `cat_id` = '5' limit 11.83msys_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 61.99msys_test
Metadata
Bindings
0. 5
1. 1

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

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

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: array:3 [ "cat_id" => "f" "product_name" => "贵州神奇药业有限公司" "style" => "g" ]
request_request: array:3 [ "cat_id" => "f" "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" => "EBzxmZQp6aiak729Xw8WOiMGCvXHRgKBzCvjC8Xg" "PHPDEBUGBAR_STACK_DATA" => [] ...