| 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 | 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 COUNT(*) AS `count` FROM `nrbjobsc_production`.`job_post_infos` AS `JobPostInfo` WHERE `JobPostInfo`.`application_deadline` >= '2026-02-04' AND `JobPostInfo`.`is_active` = 1 | 1 | 1 | 43 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `nrbjobsc_production`.`job_post_infos` AS `JobPostInfo` WHERE `JobPostInfo`.`application_deadline` >= '2026-02-04' AND `JobPostInfo`.`is_active` = 1 AND `JobPostInfo`.`ispaperjob` = 4 | 1 | 1 | 3 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `nrbjobsc_production`.`job_post_infos` AS `JobPostInfo` WHERE `JobPostInfo`.`application_deadline` >= '2026-02-04' AND `JobPostInfo`.`is_active` = 1 AND `JobPostInfo`.`ispaperjob` = 2 | 1 | 1 | 2 | maybe slow |
| SELECT
cat.id,
cat.name,
COUNT(jpi.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 AS jpi ON FIND_IN_SET(cat.child_category_id,jpi.job_category_id)
AND jpi.is_active = 1 AND jpi.application_deadline >= CURRENT_DATE()
GROUP BY cat.id, cat.name
ORDER BY cat.name | 27 | 27 | 361 | maybe slow |
| SELECT cat.id,cat.name,count(job_post_infos.id) as total FROM (
SELECT c.*,cm.child_industry_id FROM parent_industries as c LEFT JOIN industrymappings AS cm ON c.id = cm.parent_industry_id) cat
left join job_post_infos ON FIND_IN_SET(cat.child_industry_id,job_post_infos.industry_id) AND job_post_infos.is_active = 1 AND job_post_infos.application_deadline >= CURRENT_DATE()
GROUP by cat.id,cat.name | 31 | 31 | 408 | maybe slow |
| SELECT `User`.`id`, `User`.`picture`, `JobPostInfo`.`id`, `JobPostInfo`.`educational_requirements`, `JobPostInfo`.`application_deadline`, `JobPostInfo`.`show_alternative_name_checkbox`, `JobPostInfo`.`show_alternative_name`, `JobPostInfo`.`company_name`, `JobPostInfo`.`paperlogo`, `JobPostInfo`.`job_title`, `JobPostInfo`.`work_location`, `JobPostInfo`.`job_experience_year_from`, `JobPostInfo`.`job_experience_year_to`, `JobPostInfo`.`job_experience_fresher`, `JobPostInfo`.`job_type`, `JobPostInfo`.`job_descriptions` FROM `nrbjobsc_production`.`job_post_infos` AS `JobPostInfo` LEFT JOIN `nrbjobsc_production`.`users` AS `User` ON (`User`.`id` = `JobPostInfo`.`user_id`) LEFT JOIN `nrbjobsc_production`.`academic_requirements` AS `AcademicRequirement` ON (`AcademicRequirement`.`job_post_info_id` = `JobPostInfo`.`id`) WHERE ((`JobPostInfo`.`application_deadline` >= '2026-02-04') AND (`JobPostInfo`.`is_active` = 1)) ORDER BY `JobPostInfo`.`id` DESC LIMIT 25 | 25 | 25 | 1 | |
| SELECT COUNT(*) AS `count` FROM `nrbjobsc_production`.`job_post_infos` AS `JobPostInfo` LEFT JOIN `nrbjobsc_production`.`users` AS `User` ON (`User`.`id` = `JobPostInfo`.`user_id`) LEFT JOIN `nrbjobsc_production`.`academic_requirements` AS `AcademicRequirement` ON (`AcademicRequirement`.`job_post_info_id` = `JobPostInfo`.`id`) WHERE ((`JobPostInfo`.`application_deadline` >= '2026-02-04') AND (`JobPostInfo`.`is_active` = 1)) | 1 | 1 | 368 | 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 | 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 `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 | 1 | maybe slow |
5 duplicate queries run.
