http://yamaria-ec-demo.testman.biz/block/search_product

id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE t0 index_merge IDX_AF4946FC6ACBC331, IDX_AF4946FC21B06187 IDX_AF4946FC21B06187, IDX_AF4946FC6ACBC331 5, 5 1 10 Using intersect(IDX_AF4946FC21B06187, IDX_AF4946FC6ACBC331); Using where