id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE kd_item_variations ALL iv_ebay_item_id NULL NULL NULL 627558 Using where
1 SIMPLE kd_item ref ebay_item_id ebay_item_id 138 ebay_kd.kd_item_variations.iv_ebay_item_id 1 Using where; Using index
1 SIMPLE kd_item_variations ALL iv_ebay_item_id NULL NULL NULL 627558 Using where
1 SIMPLE kd_item ref ebay_item_id ebay_item_id 138 ebay_kd.kd_item_variations.iv_ebay_item_id 1 Using where; Using index
from kd_item_variations join kd_item on kd_item_variations.iv_ebay_item_id=kd_item.i_ebay_item_id
where iv_py_bb>0 and iv_price>0 limit 1;的结果,及
show index from kd_item_variations;
show index from kd_item;以供分析。
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
kd_item_variations 0 PRIMARY 1 iv_id A 618856 NULL NULL BTREE
kd_item_variations 1 iv_ebay_item_id 1 iv_ebay_item_id A 88408 NULL NULL BTREE
kd_item_variations 1 iv_sku_no_qz 1 iv_sku_no_qz A 68761 NULL NULL YES BTREE
kd_item_variations 1 iv_sku 1 iv_sku A 309428 NULL NULL YES BTREE
kd_item_variations 1 iv_sku_main 1 iv_sku_main A 16725 NULL NULL YESshow index from kd_item;
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
kd_item 0 PRIMARY 1 i_id A 186604 NULL NULL BTREE
kd_item 1 ebay_item_id 1 i_ebay_item_id A 186604 NULL NULL YES BTREE
kd_item 1 i_product_sku_main 1 i_product_sku_main A 10976 NULL NULL YES BTREE