title: accelerate MySQL query
body: <p>This is the shortversion of my query:</p>
  
  <pre><code>SELECT product.* FROM product_list product
  LEFT JOIN language_item language ON (product.title=language.languageVariable)
  WHERE language.languageID = 1
  ORDER BY language.languageValue ASC
  </code></pre>
  
  <p>When I use it, the query has 3 seconds. When I remove the order by the query has 0.3 seconds. Can you recommend a change to accelerate it?</p>
  
  <p><code>product.title</code> and <code>language.languageVariable</code> is a language variable like global.product.title1, and <code>languageValue</code> is the title like car, doll or something else.</p>
  
  <pre><code>CREATE TABLE `language_item` (
    `languageItemID` int(10) UNSIGNED NOT NULL,
    `languageID` int(10) UNSIGNED NOT NULL DEFAULT '0',
    `languageVariable` varchar(255) NOT NULL DEFAULT '',
    `languageValue` mediumtext NOT NULL,
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  ALTER TABLE `language_item`
    ADD PRIMARY KEY (`languageItemID`),
    ADD UNIQUE KEY `languageVariable` (`languageVariable`,`languageID`),
    ADD KEY `languageValue` (`languageValue`(300));
  
  id | select_type | table    | partitions | type | possible_keys                              | key              | key_len | ref              | rows | filtered | Extra 
   1 | SIMPLE      | product  | NULL       | ALL  | PRIMARY,inactive,archive,productCategoryID | NULL             | NULL    | NULL             | 1475 |    88.27 | Using where; Using temporary; Using filesort 
   1 | SIMPLE      | language | NULL       | ref  | languageVariable                           | languageVariable | 767     | db.product.title |  136 |     1.00 | Using index condition
  </code></pre>