title: Mysql & codeigniter load very slow
body: <p>I've developed webshop project but I have issue with slow query response.
  I'm using codeigniter framework and I am using <code>$this-&gt;output-&gt;enable_profiler(TRUE);</code></p>
  
  <p>This is what I get as a query:</p>
  
  <pre><code>SELECT `products`.`id`, `products`.`image`, `products`.`onsale`, `products`.`folder`, `products`.`productRating`, `products`.`pro_vat`, `products`.`pro_code`, `products`.`quantity`, `products`.`shop_categorie`, `products_translations`.`title`, `products_translations`.`price`, `products_translations`.`pdv`, `products_translations`.`old_price`, `products_translations`.`description`, `products_translations`.`shortdescription`, `products`.`url`, `brands`.`image` as `bimage`
  FROM `products`
  LEFT JOIN `products_translations` ON `products_translations`.`for_id` = `products`.`id`
  LEFT JOIN `brands` ON `brands`.`id` = `products`.`brand_id`
  ORDER BY `position` ASC
  LIMIT 20 
  </code></pre>
  
  <p>and it takes more than 6 seconds to load it.
  Just to mention, I have around 2.500 items in product table.</p>
  
  <p>Is it possible to reduce loading time somehow?</p>