10.4.18
$ 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: ref
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: B_ARTICLES_UNQ03
      key_len: 4
          ref: const
         rows: 240825
     filtered: 50.00
        Extra: Using where
*************************** 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: ref
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: B_ARTICLES_UNQ03
      key_len: 4
          ref: const
         rows: 240825
       r_rows: 481651.00
     filtered: 50.00
   r_filtered: 99.99
        Extra: Using where
*************************** 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: