甲正王(中兴)
会员价：会员可见 此品种为效期品种
生产厂家：柳州中兴日用化工厂
包装规格：12ml F
包装单位：盒
件装量：400
中包装：1
效期：2021-05-31
批准文号：国妆特字G20080006
药品规格：12ml F
件 装 量：400
消息
page_title
daohang
user
info
img
xl_top
obLevel
__env
app
ad152
rand_num
errors
ad159
middle_nav
select * from `ecs_goods` where `ecs_goods`.`is_delete` = '0' and `online` = '1' and `off_sale_ranks` != '1,2,5,7,8,9' and `goods_id` = '10534' and `is_delete` = '0' limit 1
SELECT *
!=
<>
LIMIT
ORDER BY
select * from `ecs_goods_attr` where `ecs_goods_attr`.`goods_id` in ('10534')
select * from `ecs_goods_attribute` where `ecs_goods_attribute`.`goods_id` in ('10534')
select * from `ecs_member_price` where `ecs_member_price`.`goods_id` in ('10534')
select * from `ecs_goods_sms` where `ecs_goods_sms`.`goods_id` in ('10534')
select * from `ecs_goods_zp_region` where `region_id` = '8'
select * from `ecs_goods_zp` where `ecs_goods_zp`.`goods_id` in ('10534') and `enabled` = '1' and `start` < '1745988379' and `end` > '1745988379' 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') order by `goods_number` desc
select `ecs_zp_goods`.*, `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`.`goods_id` = '10534' and `ecs_goods_zp`.`start` <= '1745988379' and `ecs_goods_zp`.`end` > '1745988379' 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' order by `ecs_goods_zp`.`goods_number` desc
select `ecs_goods`.*, `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`.`goods_id` = '10534' and `ecs_goods_zp`.`start` <= '1745988379' and `ecs_goods_zp`.`end` > '1745988379' and `ecs_goods_zp`.`is_goods` = '1' and `ecs_goods_zp`.`zp_number` <= ecs_goods.goods_number and `ecs_goods_zp`.`enabled` = '1' and `ecs_goods_zp`.`is_delete` = '0' and `ecs_goods`.`goods_number` > '0' order by `ecs_goods_zp`.`goods_number` desc
select * from `ecs_miaosha_group_region` where `region_id` = '8'
select * from `ecs_miaosha_group` where `start_time` <= '2025-04-30 12:46:19' and `end_time` > '2025-04-30 12:46:19' 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
select `goods_id`, `user_price`, `kx_price`, `aba_price` from `ecs_member_price` where `ecs_member_price`.`goods_id` = '10534' and `ecs_member_price`.`goods_id` is not null and `user_rank` = '1' limit 1
select * from `ecs_goods_gallery` where `goods_id` = '10534'
select * from `ecs_goods_statistics` where `goods_id` = '10534' and `is_mtx` = '0' limit 1
update `ecs_goods_statistics` set `click_count` = '20', `update_time` = '2025-04-30 12:46:19' where `id` = '4967'
select * from `ecs_ad` where `start_time` < '1745988379' and `end_time` > '1745988379' and `position_id` = '159' and `enabled` = '1' 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` = '10534' and `ecs_jttj_goods`.`goods_id` is not null and `is_enable` = '1' and `start_time` <= '1745988379' and `end_time` >= '1745988379' 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
