| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Generalsetting`.`id`, `Generalsetting`.`sitename`, `Generalsetting`.`companyslogan`, `Generalsetting`.`welcomemsg`, `Generalsetting`.`logo`, `Generalsetting`.`adminemail`, `Generalsetting`.`member_credit`, `Generalsetting`.`created`, `Generalsetting`.`createdby`, `Generalsetting`.`modified`, `Generalsetting`.`modifiedby`, `Generalsetting`.`delflag` FROM `nrbjobsc_production`.`generalsettings` AS `Generalsetting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TrainingInfo`.`id`, `TrainingInfo`.`name`, `TrainingInfo`.`class_session`, `TrainingInfo`.`course_hour`, `TrainingInfo`.`course_duration`, `TrainingInfo`.`class_schedule`, `TrainingInfo`.`course_fees`, `TrainingInfo`.`course_venue`, `TrainingInfo`.`main_url`, `TrainingInfo`.`created`, `TrainingInfo`.`createdby`, `TrainingInfo`.`modified`, `TrainingInfo`.`modifiedby` FROM `nrbjobsc_production`.`training_infos` AS `TrainingInfo` WHERE 1 = 1 ORDER BY `id` desc LIMIT 12 | 0 | 0 | 0 | |
| SELECT `Country`.`id`, `Country`.`name` FROM `nrbjobsc_production`.`countries` AS `Country` WHERE `Country`.`parent_id` = 0 ORDER BY `Country`.`name` ASC | 196 | 196 | 0 | |
| SELECT `Country`.`id`, `Country`.`name` FROM `nrbjobsc_production`.`countries` AS `Country` WHERE `Country`.`parent_id` = 0 ORDER BY `Country`.`name` ASC | 196 | 196 | 0 | |
| SELECT job_categories.id, job_categories.name,
sum(if(job_post_infos.is_active = 1 AND job_post_infos.job_for_govt = :job_for AND job_post_infos.application_deadline >= curdate() , 1 , 0)) AS number_of_jobs
FROM job_categories
INNER JOIN job_post_infos on FIND_IN_SET(job_categories.id, job_post_infos.job_category_id) > 0
WHERE job_categories.type_id = :type_id AND job_post_infos.is_active = 1 AND job_post_infos.job_for_govt = :job_for2 AND job_post_infos.application_deadline >= curdate()
group by job_categories.id, job_categories.name order by job_categories.name ASC [ job_for => Govt, type_id => 5, job_for2 => Govt ] | 14 | 14 | 3 | maybe slow |
| SELECT industries.id, industries.name,
sum(if(job_post_infos.is_active = 1 AND job_post_infos.job_for_govt = :job_for AND job_post_infos.application_deadline >= curdate() , 1 , 0)) as number_of_jobs
FROM industries
INNER JOIN job_post_infos on FIND_IN_SET(industries.id, job_post_infos.industry_id) > 0
where industries.type_id = :type_id AND job_post_infos.is_active = 1 AND job_post_infos.job_for_govt = :job_for2 AND job_post_infos.application_deadline >= curdate()
group by industries.id, industries.name order by industries.name ASC; [ job_for => Govt, type_id => 5, job_for2 => Govt ] | 4 | 4 | 2 | maybe slow |
| SELECT `JobPostInfo`.`id`, `JobPostInfo`.`user_id`, `JobPostInfo`.`appliercountry`, `JobPostInfo`.`appliercity`, `JobPostInfo`.`order`, `JobPostInfo`.`feature_status`, `JobPostInfo`.`make_feature`, `JobPostInfo`.`ishomepage`, `JobPostInfo`.`read_status`, `JobPostInfo`.`company_name`, `JobPostInfo`.`job_title`, `JobPostInfo`.`no_of_vacancies`, `JobPostInfo`.`some_no_of_vaccancies`, `JobPostInfo`.`job_type`, `JobPostInfo`.`job_level`, `JobPostInfo`.`gender`, `JobPostInfo`.`age_limit_from`, `JobPostInfo`.`age_limit_to`, `JobPostInfo`.`work_location`, `JobPostInfo`.`work_locationthana`, `JobPostInfo`.`country_id`, `JobPostInfo`.`job_for_nrb`, `JobPostInfo`.`job_for_bangladesh`, `JobPostInfo`.`job_for_govt`, `JobPostInfo`.`job_for_international`, `JobPostInfo`.`job_for_skilled`, `JobPostInfo`.`job_for_semiskilled`, `JobPostInfo`.`job_for_intern`, `JobPostInfo`.`job_category_id`, `JobPostInfo`.`industry_id`, `JobPostInfo`.`category_skills`, `JobPostInfo`.`industry_skills`, `JobPostInfo`.`job_descriptions`, `JobPostInfo`.`job_context`, `JobPostInfo`.`job_requirements`, `JobPostInfo`.`job_experience_year_from`, `JobPostInfo`.`job_experience_year_to`, `JobPostInfo`.`job_experience_fresher`, `JobPostInfo`.`job_experience_use_textbox`, `JobPostInfo`.`job_experience_description`, `JobPostInfo`.`educational_requirements`, `JobPostInfo`.`work_location_division`, `JobPostInfo`.`expertise_area`, `JobPostInfo`.`experience_keyword`, `JobPostInfo`.`minimum_education`, `JobPostInfo`.`ominimum_education`, `JobPostInfo`.`degree_name`, `JobPostInfo`.`odegree_name`, `JobPostInfo`.`subject_name`, `JobPostInfo`.`osubject_name`, `JobPostInfo`.`last_result`, `JobPostInfo`.`compensation_benifits_use_textbox`, `JobPostInfo`.`compensation_benifits_minimum`, `JobPostInfo`.`compensation_benifits_maximum`, `JobPostInfo`.`compensation_benifits_negotiable`, `JobPostInfo`.`compensation_benifits_donotdisplay`, `JobPostInfo`.`compensation_benifits_description`, `JobPostInfo`.`apply_instruction_email_attachments`, `JobPostInfo`.`apply_instruction_email`, `JobPostInfo`.`apply_instruction_web`, `JobPostInfo`.`apply_instruction_online_application`, `JobPostInfo`.`apply_instruction_coverletter`, `JobPostInfo`.`apply_instruction_hard_copy`, `JobPostInfo`.`apply_instruction_official_website`, `JobPostInfo`.`apply_instruction_official_email`, `JobPostInfo`.`apply_instruction_description`, `JobPostInfo`.`show_company_address`, `JobPostInfo`.`show_company_address_name_only`, `JobPostInfo`.`show_company_address_address_only`, `JobPostInfo`.`show_company_address_phone_only`, `JobPostInfo`.`show_alternative_name_checkbox`, `JobPostInfo`.`show_alternative_name`, `JobPostInfo`.`is_active`, `JobPostInfo`.`is_live`, `JobPostInfo`.`remarks`, `JobPostInfo`.`created`, `JobPostInfo`.`createdby`, `JobPostInfo`.`modified`, `JobPostInfo`.`modifiedby`, `JobPostInfo`.`delflag`, `JobPostInfo`.`html_page_design`, `JobPostInfo`.`jobsource`, `JobPostInfo`.`jobattachment`, `JobPostInfo`.`ispaperjob`, `JobPostInfo`.`paperlogo`, `JobPostInfo`.`employer_product_package_id`, `JobPostInfo`.`platform`, `JobPostInfo`.`publish_date`, `JobPostInfo`.`company_order_id`, `JobPostInfo`.`company_pin`, `JobPostInfo`.`job_order_id`, `JobPostInfo`.`application_deadline`, `JobPostInfo`.`feature_job_deadline`, `JobPostInfo`.`is_inside_bangladesh`, `User`.`id`, `User`.`email`, `User`.`mobile_no`, `User`.`image_name`, `User`.`picture` FROM `nrbjobsc_production`.`job_post_infos` AS `JobPostInfo` LEFT JOIN `nrbjobsc_production`.`users` AS `User` ON (`JobPostInfo`.`user_id` = `User`.`id`) WHERE `JobPostInfo`.`application_deadline` >= '2026-02-03' AND `JobPostInfo`.`is_active` = 1 AND `JobPostInfo`.`ispaperjob` = 2 ORDER BY `JobPostInfo`.`created` DESC LIMIT 20 | 20 | 20 | 3 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `nrbjobsc_production`.`job_post_infos` AS `JobPostInfo` LEFT JOIN `nrbjobsc_production`.`users` AS `User` ON (`JobPostInfo`.`user_id` = `User`.`id`) WHERE `JobPostInfo`.`application_deadline` >= '2026-02-03' AND `JobPostInfo`.`is_active` = 1 AND `JobPostInfo`.`ispaperjob` = 2 | 1 | 1 | 0 | |
| SELECT `Generalsetting`.`id`, `Generalsetting`.`sitename`, `Generalsetting`.`companyslogan`, `Generalsetting`.`welcomemsg`, `Generalsetting`.`logo`, `Generalsetting`.`adminemail`, `Generalsetting`.`member_credit`, `Generalsetting`.`created`, `Generalsetting`.`createdby`, `Generalsetting`.`modified`, `Generalsetting`.`modifiedby`, `Generalsetting`.`delflag` FROM `nrbjobsc_production`.`generalsettings` AS `Generalsetting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TrainingInfo`.`id`, `TrainingInfo`.`name`, `TrainingInfo`.`class_session`, `TrainingInfo`.`course_hour`, `TrainingInfo`.`course_duration`, `TrainingInfo`.`class_schedule`, `TrainingInfo`.`course_fees`, `TrainingInfo`.`course_venue`, `TrainingInfo`.`main_url`, `TrainingInfo`.`created`, `TrainingInfo`.`createdby`, `TrainingInfo`.`modified`, `TrainingInfo`.`modifiedby` FROM `nrbjobsc_production`.`training_infos` AS `TrainingInfo` WHERE 1 = 1 ORDER BY `id` desc LIMIT 12 | 0 | 0 | 0 | |
| SELECT `Country`.`id`, `Country`.`name` FROM `nrbjobsc_production`.`countries` AS `Country` WHERE `Country`.`parent_id` = 0 ORDER BY `Country`.`name` ASC | 196 | 196 | 1 | |
| SELECT `Country`.`id`, `Country`.`name` FROM `nrbjobsc_production`.`countries` AS `Country` WHERE `Country`.`parent_id` = 0 ORDER BY `Country`.`name` ASC | 196 | 196 | 0 | |
| SELECT `Banner`.`id`, `Banner`.`user_id`, `Banner`.`addsPosition_id`, `Banner`.`starttime`, `Banner`.`endtime`, `Banner`.`order`, `Banner`.`total_num_of_days`, `Banner`.`total_cost`, `Banner`.`title`, `Banner`.`category`, `Banner`.`description`, `Banner`.`link_url`, `Banner`.`link_target`, `Banner`.`image_name`, `Banner`.`published`, `Banner`.`created`, `Banner`.`createdby`, `Banner`.`modified`, `Banner`.`modifiedby`, `Banner`.`delflag`, `Banner`.`page_id`, `Banner`.`click_count` FROM `nrbjobsc_production`.`banners` AS `Banner` WHERE `Banner`.`page_id` = 5 AND `Banner`.`published` = '1' | 7 | 7 | 0 | |
| SELECT `Generalsetting`.`id`, `Generalsetting`.`sitename`, `Generalsetting`.`companyslogan`, `Generalsetting`.`welcomemsg`, `Generalsetting`.`logo`, `Generalsetting`.`adminemail`, `Generalsetting`.`member_credit`, `Generalsetting`.`created`, `Generalsetting`.`createdby`, `Generalsetting`.`modified`, `Generalsetting`.`modifiedby`, `Generalsetting`.`delflag` FROM `nrbjobsc_production`.`generalsettings` AS `Generalsetting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TrainingInfo`.`id`, `TrainingInfo`.`name`, `TrainingInfo`.`class_session`, `TrainingInfo`.`course_hour`, `TrainingInfo`.`course_duration`, `TrainingInfo`.`class_schedule`, `TrainingInfo`.`course_fees`, `TrainingInfo`.`course_venue`, `TrainingInfo`.`main_url`, `TrainingInfo`.`created`, `TrainingInfo`.`createdby`, `TrainingInfo`.`modified`, `TrainingInfo`.`modifiedby` FROM `nrbjobsc_production`.`training_infos` AS `TrainingInfo` WHERE 1 = 1 ORDER BY `id` desc LIMIT 12 | 0 | 0 | 0 | |
| SELECT `Country`.`id`, `Country`.`name` FROM `nrbjobsc_production`.`countries` AS `Country` WHERE `Country`.`parent_id` = 0 ORDER BY `Country`.`name` ASC | 196 | 196 | 1 | |
| SELECT `Country`.`id`, `Country`.`name` FROM `nrbjobsc_production`.`countries` AS `Country` WHERE `Country`.`parent_id` = 0 ORDER BY `Country`.`name` ASC | 196 | 196 | 0 | |
| SELECT `ArticleArchive`.`id`, `ArticleArchive`.`user_id`, `ArticleArchive`.`article_title`, `ArticleArchive`.`order`, `ArticleArchive`.`content`, `ArticleArchive`.`total_view`, `ArticleArchive`.`total_comments`, `ArticleArchive`.`total_report`, `ArticleArchive`.`created`, `ArticleArchive`.`created_by`, `ArticleArchive`.`modified`, `ArticleArchive`.`modified_by`, `ArticleArchive`.`delflag`, `User`.`id`, `User`.`role_id`, `User`.`country_id`, `User`.`pob`, `User`.`sor`, `User`.`emptype`, `User`.`intern_type`, `User`.`full_name`, `User`.`username`, `User`.`password`, `User`.`clear_password`, `User`.`email`, `User`.`mobile_no`, `User`.`image_name`, `User`.`exp_status`, `User`.`is_active`, `User`.`picture`, `User`.`resume`, `User`.`download_resume`, `User`.`last_login_ip`, `User`.`reset`, `User`.`created`, `User`.`modified`, `User`.`delflag`, `User`.`make_exclusive`, `User`.`resume_last_updated`, `User`.`platform`, `User`.`sms_limit`, `User`.`api_key`, `User`.`voucher_status`, `User`.`source_type`, `User`.`migration_id` FROM `nrbjobsc_production`.`article_archives` AS `ArticleArchive` LEFT JOIN `nrbjobsc_production`.`users` AS `User` ON (`ArticleArchive`.`user_id` = `User`.`id`) WHERE `ArticleArchive`.`id` IN(1,2,3) | 3 | 3 | 0 | |
9 duplicate queries run.