点击此处---> 群内免费提供SAP练习系统(在群公告中)
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
我们发现桌子carts43sn非常大。 它包含的行数比购物车表多16倍。
它在哪里使用,如何清除?
在此处输入代码mysql> desc carts43sn;
+ ------------------ + -------------- + ------ + ----- +- ------- + ---------------- +
| 领域 类型 空| 关键 默认值| 额外|
+ ------------------ + -------------- + ------ + ----- +- ------- + ---------------- +
| ID | bigint(20)| 否| PRI | NULL | auto_increment |
| ITEMPK | bigint(20)| 是的 MUL | NULL | |
| ITEMTYPEPK | bigint(20)| 是的 | NULL | |
| 时间戳| datetime(6)| 是的 | NULL | |
| 当前时间戳记| datetime(6)| 是的 | NULL | |
| 更改用户| varchar(255)| 是的 | NULL | |
| 上下文| 长文本| 是的 | NULL | |
| 有效载荷 长文本| 是的 | NULL | |
| 有效载荷后| 长文本| 是的 | NULL | |
| 操作类型| bigint(20)| 是的 | NULL | |
+ ------------------ + -------------- + ------ + ----- +- ------- + ---------------- +
mysql> select * from carts43sn限制1 \ G
*************************** 1.行******************** *******
编号:1
宜必思:8806939263019
产品类型PK:8796094038098
时间戳:2018-03-21 13:47:03.711000
当前时间戳:2018-03-21 13:47:03.770000
更改用户:testkuser+_20171222131724@gmail.com
上下文:{}
之前的有效负载:{" mapBasedAttributes":{}," attributes":{}," locAttributes":{}}
payloadafter:{" mapBasedAttributes":{}," attributes":{" date":{" type":{" type":" java.util.Date"," collection":""}," value":[ " 1521636423546"]},"代码":{"类型":{"类型":" java.lang.String","集合":""},"值":[" 200449000"]}},"支付成本" :{" type":{" type":" java.lang.Double"," collection":""}," value":[" 0.0"]}," totalprice":{" type":{" type ":" java.lang.Double","集合":""},"值":[" 0.0"]}," totaltaxvaluesinternal":{" type":{" type":" java.lang.String" ," collection":""}," value":[" []"]}," discountsincludepaymentcost":{" type":{" type":" java.lang.Boolean"," collection":""} ," value":[" false"]}," deliverycost":{" type":{" type":" java.lang.Double"," collection":""}," value":[" 0.0" ]}," discountsincludedeliverycost":{" type":{" type":" java.lang.Boolean"," collection":""}," value":[" false"]}," totaltax":{" type":{" type":" java.lang.Double"," collection":""}," value":[" 0.0"]}," modifiedtime":{" type":{" type":" java.util.Date"," collection":""}," value":[" 1521636423711"]}," itemtype":{" type":{" type":" de.hybris.platform.core.PK "," colle ction":""}," value":[" 8796094038098"]},"小计":{" type":{" type":" java.lang.Double"," collection":""}," value ":[" 0.0"]}," guid":{" type":{" type":" java.lang.String"," collection":""}," value":[" 83f8e42b-d7e9-420d -bde0-e5b223ac7c88"]},"总折扣":{" type":{" type":" java.lang.Double"," collection":""}," value":[" 0.0"]}," 货币":{"类型":{"类型":" de.hybris.platform.core.PK","集合":""},"值":[" 8800746242081"]},"创建时间":{" type":{" type":" java.util.Date"," collection":""}," value":[" 1521636423546"]}," pk":{" type":{" type":" de.hybris.platform.core.PK"," collection":""}," value":[" 8806939263019"]}," net":{" type":{" type":" java.lang.Boolean "," collection":""}," value":[" false"]}," calculated":{" type":{" type":" java.lang.Boolean"," collection":""} ," value":[" false"]}," user":{" type":{" type":" de.hybris.platform.core.PK"," collection":""}," value": [" 8797043884036"]}}," locAttributes":{}}
操作类型:1
设置1行(0.00秒)
找到了。 这是通用的审计逻辑。 并且可以在配置中将其关闭。 https://help.hybris.com/6.6.0/hcd/3e2b8491449d43b391eb1ce9c73cbb7f.html
一周热门 更多>