消息
result
jx
sccj
ypgg
cxGoods
category
title
obLevel
__env
app
ad152
rand_num
errors
goodsPresenter
ad
ads
v
k
paginator
elements
select id from ecs_sensitive_words where '' like concat('%', keywords, '%')
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` = '1139' or `cat_ids` like '1139,%' or `cat_ids` like '%,1139' or `cat_ids` like '%,1139,%') and (`cat_ids` = '1139' or `cat_ids` like '1139,%' or `cat_ids` like '%,1139' or `cat_ids` like '%,1139,%')) and `ecs_goods`.`product_name` = '广东星昊药业有限公司'
!=
<>
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` = '1139' or `cat_ids` like '1139,%' or `cat_ids` like '%,1139' or `cat_ids` like '%,1139,%') and (`cat_ids` = '1139' or `cat_ids` like '1139,%' or `cat_ids` like '%,1139' or `cat_ids` like '%,1139,%')) 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
select `goods_id`, `attr_id`, `attr_value` from `ecs_goods_attr` where `ecs_goods_attr`.`goods_id` in ('304')
select * from `ecs_goods_attribute` where `ecs_goods_attribute`.`goods_id` in ('304')
SELECT *
select `goods_id`, `user_price`, `kx_price`, `aba_price` from `ecs_member_price` where `user_rank` = '1' and `ecs_member_price`.`goods_id` in ('304')
select `ecs_zp_goods`.`goods_id`, `ecs_zp_goods`.`goods_name`, `ecs_zp_goods`.`shop_price`, `ecs_zp_goods`.`qyhy_price`, `ecs_zp_goods`.`is_kxpz`, `ecs_zp_goods`.`product_name`, `ecs_zp_goods`.`is_promote`, `ecs_zp_goods`.`promote_price`, `ecs_zp_goods`.`promote_start_date`, `ecs_zp_goods`.`promote_end_date`, `ecs_zp_goods`.`is_xkh_tj`, `ecs_zp_goods`.`xg_type`, `ecs_zp_goods`.`xg_start_date`, `ecs_zp_goods`.`xg_end_date`, `ecs_zp_goods`.`xrtj_xg_num`, `ecs_zp_goods`.`ls_ggg`, `ecs_zp_goods`.`is_on_sale`, `ecs_zp_goods`.`cat_ids`, `ecs_zp_goods`.`show_area`, `ecs_zp_goods`.`ERPID`, `ecs_zp_goods`.`xq`, `ecs_zp_goods`.`ckid`, `ecs_zp_goods`.`goods_number`, `ecs_zp_goods`.`ls_gg`, `ecs_zp_goods`.`goods_img`, `ecs_zp_goods`.`goods_thumb`, `ecs_zp_goods`.`zyzk`, `ecs_zp_goods`.`tsbz`, `ecs_zp_goods`.`erp_shangplx`, `ecs_zp_goods`.`is_alone_sale`, `ecs_zp_goods`.`is_delete`, `ecs_zp_goods`.`ls_buy_user_id`, `ecs_zp_goods`.`ls_regions`, `ecs_zp_goods`.`zs_regions`, `ecs_zp_goods`.`yy_regions`, `ecs_zp_goods`.`zs_user_ids`, `ecs_zp_goods`.`yy_user_ids`, `ecs_zp_goods`.`ls_ranks`, `ecs_zp_goods`.`ls_user_ids`, `ecs_goods_zp`.`goods_id` as `pivot_goods_id`, `ecs_goods_zp`.`zp_id` as `pivot_zp_id`, `ecs_goods_zp`.`goods_number` as `pivot_goods_number`, `ecs_goods_zp`.`zp_number` as `pivot_zp_number`, `ecs_goods_zp`.`message` as `pivot_message`, `ecs_goods_zp`.`type` as `pivot_type`, `ecs_goods_zp`.`is_erp` as `pivot_is_erp`, `ecs_goods_zp`.`is_goods` as `pivot_is_goods`, `ecs_goods_zp`.`is_give` as `pivot_is_give` from `ecs_zp_goods` inner join `ecs_goods_zp` on `ecs_zp_goods`.`goods_id` = `ecs_goods_zp`.`zp_id` where `ecs_goods_zp`.`start` <= '1745932468' and `ecs_goods_zp`.`end` > '1745932468' and `ecs_goods_zp`.`is_goods` = '0' and `ecs_goods_zp`.`zp_number` <= ecs_zp_goods.goods_number and `ecs_goods_zp`.`enabled` = '1' and `ecs_goods_zp`.`is_delete` = '0' and `ecs_zp_goods`.`goods_number` > '0' and `ecs_goods_zp`.`goods_id` in ('304') order by `ecs_goods_zp`.`goods_number` desc
select `ecs_goods`.`goods_sn`, `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`.`erp_shangplx`, `ecs_goods`.`is_delete`, `ecs_goods`.`ls_buy_user_id`, `ecs_goods`.`ls_regions`, `ecs_goods`.`zs_regions`, `ecs_goods`.`yy_regions`, `ecs_goods`.`zs_user_ids`, `ecs_goods`.`yy_user_ids`, `ecs_goods`.`ls_ranks`, `ecs_goods`.`ls_user_ids`, `ecs_goods_zp`.`goods_id` as `pivot_goods_id`, `ecs_goods_zp`.`zp_id` as `pivot_zp_id`, `ecs_goods_zp`.`goods_number` as `pivot_goods_number`, `ecs_goods_zp`.`zp_number` as `pivot_zp_number`, `ecs_goods_zp`.`message` as `pivot_message`, `ecs_goods_zp`.`type` as `pivot_type`, `ecs_goods_zp`.`is_erp` as `pivot_is_erp`, `ecs_goods_zp`.`is_goods` as `pivot_is_goods`, `ecs_goods_zp`.`is_give` as `pivot_is_give` from `ecs_goods` inner join `ecs_goods_zp` on `ecs_goods`.`goods_id` = `ecs_goods_zp`.`zp_id` where `ecs_goods_zp`.`start` <= '1745932468' and `ecs_goods_zp`.`end` > '1745932468' and `ecs_goods_zp`.`is_goods` = '1' and `ecs_goods_zp`.`enabled` = '1' and `ecs_goods_zp`.`is_delete` = '0' and `ecs_goods_zp`.`goods_id` in ('304') order by `ecs_goods_zp`.`goods_number` desc
select `ERPID`, `ckid`, `goods_number`, `goods_price`, `xq` from `ecs_spkc_tj` where `is_on_sale` = '1' and `goods_number` > '0' and `goods_price` > '0' and `ecs_spkc_tj`.`ERPID` in ('7BB0CE706AEF2512E053752512ACAA06')
select * from `ecs_goods_zp_region` where `region_id` = '8'
select * from `ecs_goods_zp` where `ecs_goods_zp`.`goods_id` in ('304') and `enabled` = '1' and `start` < '1745932468' and `end` > '1745932468' and `is_delete` = '0' and `id` in ('1', '2', '3', '4', '5', '6', '7', '8', '9', '11', '12', '13', '14', '15', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '50', '51', '53', '54', '55', '58', '59', '62', '60', '61', '69', '72', '73', '75', '77', '76', '79', '80', '86', '85', '87')
select * from `ecs_miaosha_group_region` where `region_id` = '8'
select * from `ecs_miaosha_group` where `start_time` <= '2025-04-29 21:14:28' and `end_time` > '2025-04-29 21:14:28' 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
LIMIT
ORDER BY
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` = '1139' or `cat_ids` like '1139,%' or `cat_ids` like '%,1139' or `cat_ids` like '%,1139,%') and (`cat_ids` = '1139' or `cat_ids` like '1139,%' or `cat_ids` like '%,1139' or `cat_ids` like '%,1139,%')) 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
select * from `ecs_ad` where `position_id` = '152' and `enabled` > '0' and `end_time` > '1745932468' order by `sort_order` desc, `ad_id` desc
select * from `ecs_ad` where `position_id` = '159' and `enabled` > '0' and `end_time` > '1745932468' order by `sort_order` desc, `ad_id` desc
select `name`, `url`, `opennew`, `id` from `ecs_nav` where `ifshow` = '1' and `type` = 'middle' and 1 = 1 order by `type` asc, `vieworder` asc
select * from `ecs_jttj_goods` where `ecs_jttj_goods`.`goods_id` = '304' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1745932468' and `end_time` >= '1745932468' limit 1
select `cat_id`, `cat_name`, `sort_order` from `ecs_article_cat` where `cat_id` = '5' limit 1
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 6