| 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 `Category`.`name`, `Category`.`id` FROM `nrbjobsc_production`.`categories` AS `Category` WHERE `Category`.`id` = 22 AND `Category`.`is_active` = 1 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Categorymapping`.`id`, `Categorymapping`.`parent_category_id`, `Categorymapping`.`child_category_id`, `Categorymapping`.`status`, `Categorymapping`.`created_at`, `Categorymapping`.`updated_at` FROM `nrbjobsc_production`.`categorymappings` AS `Categorymapping` WHERE `Categorymapping`.`parent_category_id` = (22) | 6 | 6 | 0 | |
| SELECT `JobPostInfo`.`id`, `JobPostInfo`.`user_id`, `JobPostInfo`.`country_id`, `JobPostInfo`.`job_for_international`, `JobPostInfo`.`paperlogo`, `JobPostInfo`.`job_title`, `JobPostInfo`.`company_name`, `JobPostInfo`.`work_location`, `JobPostInfo`.`job_experience_year_from`, `JobPostInfo`.`job_experience_year_to`, `JobPostInfo`.`job_experience_fresher`, `JobPostInfo`.`job_type`, `JobPostInfo`.`educational_requirements`, `JobPostInfo`.`application_deadline`, `JobPostInfo`.`show_alternative_name_checkbox`, `JobPostInfo`.`show_alternative_name`, `User`.`id`, `User`.`username`, `User`.`picture` FROM `nrbjobsc_production`.`job_post_infos` AS `JobPostInfo` LEFT JOIN `nrbjobsc_production`.`users` AS `User` ON (`JobPostInfo`.`user_id` = `User`.`id`) WHERE ((FIND_IN_SET('23',`JobPostInfo`.`job_category_id`)) OR (FIND_IN_SET('497',`JobPostInfo`.`job_category_id`)) OR (FIND_IN_SET('521',`JobPostInfo`.`job_category_id`)) OR (FIND_IN_SET('749',`JobPostInfo`.`job_category_id`)) OR (FIND_IN_SET('448',`JobPostInfo`.`job_category_id`)) OR (FIND_IN_SET('477',`JobPostInfo`.`job_category_id`))) AND ((`JobPostInfo`.`application_deadline` >= '2026-02-04') AND (`JobPostInfo`.`is_active` = 1)) AND `JobPostInfo`.`job_for_govt` = 'Govt' ORDER BY `JobPostInfo`.`modified` DESC LIMIT 20 | 2 | 2 | 3 | maybe slow |
| SELECT SUM(CASE WHEN JobPostInfo.job_for_bangladesh = 'Bangladesh' THEN 1 ELSE 0 END) AS bd, SUM(CASE WHEN JobPostInfo.job_for_nrb = 'NRBs' THEN 1 ELSE 0 END) AS nrbs, SUM(CASE WHEN JobPostInfo.job_for_skilled = 'skilled' THEN 1 ELSE 0 END)AS skilled, SUM(CASE WHEN JobPostInfo.job_for_semiskilled = 'semiskilled' THEN 1 ELSE 0 END)AS semiskilled, SUM(CASE WHEN JobPostInfo.job_for_international = 'International' THEN 1 ELSE 0 END) AS international, SUM(CASE WHEN JobPostInfo.job_for_intern = 'Intern' THEN 1 ELSE 0 END) AS intern, SUM(CASE WHEN JobPostInfo.job_for_govt = 'Govt' THEN 1 ELSE 0 END) AS govt, SUM(CASE WHEN JobPostInfo.ispaperjob = 4 THEN 1 ELSE 0 END) AS news FROM `nrbjobsc_production`.`job_post_infos` AS `JobPostInfo` WHERE ((FIND_IN_SET('23',`JobPostInfo`.`job_category_id`)) OR (FIND_IN_SET('497',`JobPostInfo`.`job_category_id`)) OR (FIND_IN_SET('521',`JobPostInfo`.`job_category_id`)) OR (FIND_IN_SET('749',`JobPostInfo`.`job_category_id`)) OR (FIND_IN_SET('448',`JobPostInfo`.`job_category_id`)) OR (FIND_IN_SET('477',`JobPostInfo`.`job_category_id`))) AND ((`JobPostInfo`.`job_for_bangladesh` = 'Bangladesh') OR (`JobPostInfo`.`job_for_nrb` = 'NRBs') OR (`JobPostInfo`.`job_for_skilled` = 'skilled') OR (`JobPostInfo`.`job_for_semiskilled` = 'semiskilled') OR (`JobPostInfo`.`job_for_international` = 'International') OR (`JobPostInfo`.`job_for_intern` = 'Intern') OR (`JobPostInfo`.`job_for_govt` = 'Govt') OR (`JobPostInfo`.`ispaperjob` = 4)) AND ((`JobPostInfo`.`application_deadline` >= '2026-02-04') AND (`JobPostInfo`.`is_active` = 1)) LIMIT 1 | 1 | 1 | 15 | maybe slow |
| SELECT cat.id,cat.name,count(job_post_infos.id) as total FROM (
SELECT c.*,cm.child_category_id FROM categories as c
LEFT JOIN categorymappings AS cm ON c.id = cm.parent_category_id
) cat
left join job_post_infos ON FIND_IN_SET(cat.child_category_id,job_post_infos.job_category_id)
WHERE job_post_infos.is_active = 1 AND job_post_infos.application_deadline >= CURRENT_DATE()
GROUP by cat.id,cat.name | 23 | 23 | 479 | maybe slow |
| 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 | 1 | |
| 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 | 4 | maybe slow |
5 duplicate queries run.
