title: My data fetching too slow. Is there anything wrong with my sql?
body: <p>I'm current facing a issue in my project. When i search a product, it take too much time to fetch data.
  This is sql code.</p>
  <pre><code>SELECT * FROM product_info 
      LEFT JOIN (
          SELECT bulk_stock_info.bulk_unit_buy_price,bulk_stock_info.general_unit_sale_price,bulk_stock_info.bulk_unit_sale_price,bulk_stock_info.product_id as pid 
          FROM bulk_stock_info 
          ORDER BY bulk_id DESC
          ) bulk_stock_info 
      ON bulk_stock_info.pid = product_info.product_id 
  WHERE (`product_name` RLIKE ' +$query') OR `product_name` LIKE '$query%';&quot;
  </code></pre>