如何增加mysql查询执行时间

Question

I am using mysql database with codeigniter framework.
In that join more then 5 tables at a time. MySql query is fine and it produce result correctly, but it's taking too much time to produce result approx 9-12 sec. How can I increase the execution time of query.

SELECT `questions`.* FROM `questions` LEFT JOIN `universities_questions` ON `questions`.`id` = `universities_questions`.`question_id` LEFT JOIN `courses_questions` ON `questions`.`id` = `courses_questions`.`question_id` LEFT JOIN `branches_questions` ON `questions`.`id` = `branches_questions`.`question_id` LEFT JOIN `subjects_questions` ON `questions`.`id` = `subjects_questions`.`question_id` LEFT JOIN `question_types_questions` ON `questions`.`id` = `question_types_questions`.`question_id` LEFT JOIN `questions_year` ON `questions`.`id` = `questions_year`.`question_id` WHERE `questions`.`status` = '1' GROUP BY `questions`.`id` ORDER BY `questions`.`id` DESC LIMIT 1

Answer 1

You can use php sleep function if you don't want to mess with your sql...

sleep(10);

Above line will delay execution of any code bellow of this line for 10 seconds. Here is the php documentation