10.4.18-analyzed $ mysql barsy_mercari -e 'explain extended SELECT SQL_CALC_FOUND_ROWS BA.ARTICLE_ID,BA.ARTICLE_NAME,BA.ACTUAL_PRICE,"" PRICE_RECALC,BA.AMOUNT_UNIT,AMOUNT_TYPE_NAME_SHORT amount_type_name_short,BA.AMOUNT_TYPE_ID,get_stream_name(STREAM_ID) STREAM_NAME,BA.STREAM_ID,BA.COMPOSITE,BA.IS_FOR_SALE IS_FOR_SALE_MASS,BA.IS_FOR_LOAD IS_FOR_LOAD_MASS,BA.DELETE_FLAG DELETE_FLAG FROM b_articles BA INNER JOIN b_amount_types USING (AMOUNT_TYPE_ID) WHERE BA.MENU_ID = 1 AND BA.PARENT_ID IS NULL AND BA.ARTICLE_TYPE = 1 AND BA.DELETE_FLAG = 0 ORDER BY ARTICLE_NAME LIMIT 0,100\G' *************************** 1. row *************************** id: 1 select_type: SIMPLE table: BA type: index_merge possible_keys: B_ARTICLES_UNQ01,B_ARTICLES_UNQ03,B_ARTICLES_UNQ02,B_ARTICLES_UNQ05,BARSY_ID,BARSY_ID_TYPE_REF_ID,b_articles_fk5,PARENT_ID,b_articles_fk8 key: BARSY_ID,b_articles_fk8,PARENT_ID key_len: 4,4,5 ref: NULL rows: 59388 filtered: 100.00 Extra: Using intersect(BARSY_ID,b_articles_fk8,PARENT_ID); Using where; Using filesort *************************** 2. row *************************** id: 1 select_type: SIMPLE table: b_amount_types type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: barsy_mercari.BA.AMOUNT_TYPE_ID rows: 1 filtered: 100.00 Extra: $ mysql barsy_mercari -e 'ANALYZE SELECT SQL_CALC_FOUND_ROWS BA.ARTICLE_ID,BA.ARTICLE_NAME,BA.ACTUAL_PRICE,"" PRICE_RECALC,BA.AMOUNT_UNIT,AMOUNT_TYPE_NAME_SHORT amount_type_name_short,BA.AMOUNT_TYPE_ID,get_stream_name(STREAM_ID) STREAM_NAME,BA.STREAM_ID,BA.COMPOSITE,BA.IS_FOR_SALE IS_FOR_SALE_MASS,BA.IS_FOR_LOAD IS_FOR_LOAD_MASS,BA.DELETE_FLAG DELETE_FLAG FROM b_articles BA INNER JOIN b_amount_types USING (AMOUNT_TYPE_ID) WHERE BA.MENU_ID = 1 AND BA.PARENT_ID IS NULL AND BA.ARTICLE_TYPE = 1 AND BA.DELETE_FLAG = 0 ORDER BY ARTICLE_NAME LIMIT 0,100\G' *************************** 1. row *************************** id: 1 select_type: SIMPLE table: BA type: index_merge possible_keys: B_ARTICLES_UNQ01,B_ARTICLES_UNQ03,B_ARTICLES_UNQ02,B_ARTICLES_UNQ05,BARSY_ID,BARSY_ID_TYPE_REF_ID,b_articles_fk5,PARENT_ID,b_articles_fk8 key: BARSY_ID,b_articles_fk8,PARENT_ID key_len: 4,4,5 ref: NULL rows: 59388 r_rows: 481610.00 filtered: 100.00 r_filtered: 100.00 Extra: Using intersect(BARSY_ID,b_articles_fk8,PARENT_ID); Using where; Using filesort *************************** 2. row *************************** id: 1 select_type: SIMPLE table: b_amount_types type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: barsy_mercari.BA.AMOUNT_TYPE_ID rows: 1 r_rows: 1.00 filtered: 100.00 r_filtered: 100.00 Extra: