打开mysql日志,检测添加属性时候的msyql语句如下。
121126 22:41:55 158 Connect root@localhost on
158 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
158 Query SET sql_mode=''
158 Init DB kuuqii
158 Query SELECT userid, adminid, user_name, user_rank, discount, email, data, expiry FROM `kuuqii`.`ecs_sessions` WHERE sesskey = 'a59d4eef20b25ff76be1013b66b05bb0'
158 Query SELECT attr_group FROM `kuuqii`.`ecs_goods_type` WHERE cat_id='5'
158 Query SELECT cat_id, cat_name FROM `kuuqii`.`ecs_goods_type` WHERE enabled = 1
158 Query UPDATE `kuuqii`.`ecs_sessions` SET expiry = '1353940915', ip = '127.0.0.1', userid = '0', adminid = '1', user_name='0', user_rank='0', discount='0', email='0', data = 'a:5:{s:12:\"captcha_word\";s:16:\"ZDM3ZThmNzdjYg==\";s:10:\"admin_name\";s:5:\"qceek\";s:11:\"action_list\";s:3:\"all\";s:10:\"last_check\";i:1353940814;s:12:\"suppliers_id\";s:1:\"0\";}' WHERE sesskey = 'a59d4eef20b25ff76be1013b66b05bb0' LIMIT 1
158 Quit
159 Connect root@localhost on
159 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
159 Query SET sql_mode=''
159 Init DB kuuqii
159 Query SELECT userid, adminid, user_name, user_rank, discount, email, data, expiry FROM `kuuqii`.`ecs_sessions` WHERE sesskey = 'a59d4eef20b25ff76be1013b66b05bb0'
159 Query SELECT attr_group FROM `kuuqii`.`ecs_goods_type` WHERE cat_id='5'
159 Quit
121126 22:42:42 160 Connect root@localhost on
160 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
160 Query SET sql_mode=''
160 Query SHOW VARIABLES LIKE 'basedir'
160 Query SELECT UNIX_TIMESTAMP() AS timeline, UNIX_TIMESTAMP('2012-11-26 14:42:42') AS timezone
160 Init DB kuuqii
160 Query SELECT userid, adminid, user_name, user_rank, discount, email, data, expiry FROM `kuuqii`.`ecs_sessions` WHERE sesskey = 'a59d4eef20b25ff76be1013b66b05bb0'
160 Query SELECT COUNT(*) FROM `kuuqii`.`ecs_attribute` WHERE attr_name = 'ss' AND cat_id = '5'
160 Query DESC `kuuqii`.`ecs_attribute`
160 Query INSERT INTO `kuuqii`.`ecs_attribute` (cat_id, attr_name, attr_input_type, attr_type, attr_values, attr_index, is_linked, attr_group) VALUES ('5', 'ss', '0', '0', '', '0', '0', '0')
160 Query INSERT INTO `kuuqii`.`ecs_admin_log` (log_time, user_id, log_info, ip_address) VALUES ('1353940962', 1, '添加属性: ss', '127.0.0.1')
160 Query UPDATE `kuuqii`.`ecs_sessions` SET expiry = '1353940962', ip = '127.0.0.1', userid = '0', adminid = '1', user_name='0', user_rank='0', discount='0', email='0', data = 'a:5:{s:12:\"captcha_word\";s:16:\"ZDM3ZThmNzdjYg==\";s:10:\"admin_name\";s:5:\"qceek\";s:11:\"action_list\";s:3:\"all\";s:10:\"last_check\";i:1353940814;s:12:\"suppliers_id\";s:1:\"0\";}' WHERE sesskey = 'a59d4eef20b25ff76be1013b66b05bb0' LIMIT 1
160 Query DELETE FROM `kuuqii`.`ecs_sessions_data` WHERE expiry < 1353939162
160 Query DELETE FROM `kuuqii`.`ecs_sessions` WHERE expiry < 1353939162
160 Quit
121126 22:42:46 161 Connect root@localhost on
161 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
161 Query SET sql_mode=''
161 Init DB kuuqii
161 Query SELECT userid, adminid, user_name, user_rank, discount, email, data, expiry FROM `kuuqii`.`ecs_sessions` WHERE sesskey = 'a59d4eef20b25ff76be1013b66b05bb0'
161 Query SELECT attr_group FROM `kuuqii`.`ecs_goods_type` WHERE cat_id='5'
161 Query SELECT cat_id, cat_name FROM `kuuqii`.`ecs_goods_type` WHERE enabled = 1
161 Query DELETE FROM `kuuqii`.`ecs_sessions` WHERE expiry < 1353939166
161 Quit
162 Connect root@localhost on
162 Query SET character_set_connection=utf8, character_set_results=utf8, character_set_client=binary
162 Query SET sql_mode=''
162 Init DB kuuqii
162 Query SELECT userid, adminid, user_name, user_rank, discount, email, data, expiry FROM `kuuqii`.`ecs_sessions` WHERE sesskey = 'a59d4eef20b25ff76be1013b66b05bb0'
162 Query SELECT attr_group FROM `kuuqii`.`ecs_goods_type` WHERE cat_id='5'
162 Query DELETE FROM `kuuqii`.`ecs_sessions_data` WHERE expiry < 1353939166
162 Query DELETE FROM `kuuqii`.`ecs_sessions` WHERE expiry < 1353939166
162 Quit
attr_id | cat_id | attr_name | attr_input_type | attr_type | attr_values | attr_index | sort_order | is_linked | attr_group | |||
---|---|---|---|---|---|---|---|---|---|---|---|---|
181 | 9 | 内存容量 | 0 | 0 | 2 | 0 | 0 | 0 | ||||
182 | 9 | 操作系统 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
183 | 9 | K-JAVA | 0 | 0 | 0 | 0 | 0 | 0 | ||||
184 | 9 | 尺寸体积 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
185 | 9 | 颜色 | 1 | 1 | 黑色 白色 蓝色 金色 粉色 银色 灰色 深李色 黑红色 黑蓝色 白紫色 | 1 | 0 | 0 |
假如我现在 快客 店铺里 添加一个 笔记本
通用信息详细描述其他信息商品属性商品相册关联商品配件关联文章
ecs_goods_attr
goods_attr_id | goods_id | attr_id | attr_value | attr_price | |||
---|---|---|---|---|---|---|---|
1 | 1 | 82 | 1026 | 0 | |||
2 | 1 | 84 | 14 | 0 |
表 ecs_goods_attr 记录这种映射关系。
关于手工输入 和自动选择的区别 如下 在ecs_attribute是否存放结构清晰的数据
ecs_goods_attr
goods_attr_id | goods_id | attr_id | attr_value | attr_price | |||
---|---|---|---|---|---|---|---|
1 | 1 | 82 | 1026 | 0 | |||
2 | 1 | 84 | 14 | 0 | |||
3 | 2 | 168 | 彩妆 | 0 | |||
4 | 2 | 170 | 中性 | 0 | |||
5 | 2 | 171 | 女性 | 0 |