Get Images of an Article

If you use IDs or slugs that match product, you don't actually have to join it with product table, because you already got product details with singleproduct() method.

Depending how much data you have in product table, with your original query, for every image you also get all the product details.

You could do something like this and only get image data:

PHP Code:

$bringimages = $this->db->select('*')
    ->where('imageproductslug', $productslug);
    ->db->get('gallery');