codeigniter active record and mysql
Run the $this->db->last_query() and check the difference. It's a very useful debugging tool.
Of course the limit will have an effect, but I'm ignoring that.
It seems in your query in phpmyadmin, your 'ON' doesn't have a second part. I think your query in phpmyadmin should be:
SELECT *FROM (`job_listing`)LEFT JOIN `job_listing_has_employer_details` ON `job_listing_has_employer_details`.`employer_details_id` = = `job_listing`.`id`
You should be using result_array, despite what the other person said.