| 1 | SELECT `Teacher`.`id`, `Teacher`.`name`, `Teacher`.`name_bn`, `Teacher`.`user_id`, `Teacher`.`index_number`, `Teacher`.`salary_scale_code`, `Teacher`.`father_name`, `Teacher`.`mother_name`, `Teacher`.`spouse_name`, `Teacher`.`no_of_son`, `Teacher`.`no_of_daughter`, `Teacher`.`email`, `Teacher`.`present_address`, `Teacher`.`present_address_thana`, `Teacher`.`present_address_district`, `Teacher`.`permanent_address`, `Teacher`.`permanent_address_thana`, `Teacher`.`permanent_address_district`, `Teacher`.`national_id_no`, `Teacher`.`passport_number`, `Teacher`.`date_of_birth`, `Teacher`.`nationality`, `Teacher`.`religion`, `Teacher`.`gender`, `Teacher`.`blood_group`, `Teacher`.`marital_status`, `Teacher`.`contact_number`, `Teacher`.`teaching_designation`, `Teacher`.`teaching_subject`, `Teacher`.`joining_date`, `Teacher`.`mpo_code`, `Teacher`.`mpo_date`, `Teacher`.`current_salary_code`, `Teacher`.`bank_ac`, `Teacher`.`bank_name`, `Teacher`.`bank_branch_name`, `Teacher`.`institute_id`, `Teacher`.`photo_id`, `Teacher`.`is_deleted`, `Teacher`.`is_published`, `Teacher`.`sort_order`, `Teacher`.`created_user_id`, `Teacher`.`modified_user_id`, `Teacher`.`created`, `Teacher`.`modified`, `Media`.`id`, `Media`.`name`, `Media`.`caption`, `Media`.`url`, `Media`.`thumbnail_url`, `Media`.`image_url`, `Media`.`alt`, `User`.`id`, `User`.`name`, `User`.`institute_id`, `User`.`username`, `User`.`password`, `User`.`user_type`, `User`.`group_id`, `User`.`user_status`, `User`.`created`, `User`.`modified` FROM `dumoorco_biddaloy_sandbox`.`teachers` AS `Teacher` LEFT JOIN `dumoorco_biddaloy_sandbox`.`media` AS `Media` ON (`Teacher`.`photo_id` = `Media`.`id`) LEFT JOIN `dumoorco_biddaloy_sandbox`.`users` AS `User` ON (`Teacher`.`user_id` = `User`.`id`) WHERE `Teacher`.`id` = 39 AND `Teacher`.`institute_id` = 6 AND `Teacher`.`is_deleted` = '0' ORDER BY `Teacher`.`sort_order` ASC LIMIT 1 | | 1 | 1 | 9 |
| 2 | SELECT `EduQualification`.`id`, `EduQualification`.`profile_type`, `EduQualification`.`profile_id`, `EduQualification`.`edu_level`, `EduQualification`.`degree_title`, `EduQualification`.`major`, `EduQualification`.`institute`, `EduQualification`.`board`, `EduQualification`.`result`, `EduQualification`.`passing_year`, `EduQualification`.`createdby_user_id`, `EduQualification`.`modifiedby_user_id`, `EduQualification`.`created`, `EduQualification`.`modified` FROM `dumoorco_biddaloy_sandbox`.`edu_qualifications` AS `EduQualification` WHERE `EduQualification`.`profile_type` = 'Teacher' AND `EduQualification`.`profile_id` = 39 ORDER BY `EduQualification`.`edu_level` DESC | | 4 | 4 | 10 |
| 3 | SELECT `Training`.`id`, `Training`.`profile_type`, `Training`.`profile_id`, `Training`.`training_title`, `Training`.`institute_name`, `Training`.`location`, `Training`.`designation`, `Training`.`from_date`, `Training`.`to_date`, `Training`.`createdby_user_id`, `Training`.`modifiedby_user_id`, `Training`.`created`, `Training`.`modified` FROM `dumoorco_biddaloy_sandbox`.`trainings` AS `Training` WHERE `Training`.`profile_type` = 'Teacher' AND `Training`.`profile_id` = 39 ORDER BY `Training`.`from_date` DESC | | 2 | 2 | 10 |
| 4 | SELECT `Term`.`identifier`, `Term`.`name`, `ParentTerm`.`name` FROM `dumoorco_biddaloy_sandbox`.`terms` AS `Term` LEFT JOIN `dumoorco_biddaloy_sandbox`.`control_vocabullaries` AS `ControlVocabullary` ON (`Term`.`control_vocabullary_id` = `ControlVocabullary`.`id`) LEFT JOIN `dumoorco_biddaloy_sandbox`.`terms` AS `ParentTerm` ON (`Term`.`parent_id` = `ParentTerm`.`id`) WHERE `ControlVocabullary`.`handle` = 'teacher_designations' ORDER BY `Term`.`weight` DESC | | 34 | 34 | 4 |
| 5 | SELECT `Experience`.`id`, `Experience`.`profile_type`, `Experience`.`profile_id`, `Experience`.`institute_name`, `Experience`.`designation`, `Experience`.`from_date`, `Experience`.`to_date`, `Experience`.`mpo_code`, `Experience`.`mpo_date`, `Experience`.`createdby_user_id`, `Experience`.`modifiedby_user_id`, `Experience`.`created`, `Experience`.`modified` FROM `dumoorco_biddaloy_sandbox`.`experiences` AS `Experience` WHERE `Experience`.`profile_type` = 'Teacher' AND `Experience`.`profile_id` = 39 | | 0 | 0 | 12 |
| 6 | SELECT `BoardExaminerInfo`.`id`, `BoardExaminerInfo`.`teacher_id`, `BoardExaminerInfo`.`examiner_code`, `BoardExaminerInfo`.`subject_name`, `BoardExaminerInfo`.`subject_code`, `BoardExaminerInfo`.`edu_level`, `BoardExaminerInfo`.`exam_year`, `BoardExaminerInfo`.`head_examiner_code`, `BoardExaminerInfo`.`created`, `BoardExaminerInfo`.`modified`, `Teacher`.`id`, `Teacher`.`name`, `Teacher`.`name_bn`, `Teacher`.`user_id`, `Teacher`.`index_number`, `Teacher`.`salary_scale_code`, `Teacher`.`father_name`, `Teacher`.`mother_name`, `Teacher`.`spouse_name`, `Teacher`.`no_of_son`, `Teacher`.`no_of_daughter`, `Teacher`.`email`, `Teacher`.`present_address`, `Teacher`.`present_address_thana`, `Teacher`.`present_address_district`, `Teacher`.`permanent_address`, `Teacher`.`permanent_address_thana`, `Teacher`.`permanent_address_district`, `Teacher`.`national_id_no`, `Teacher`.`passport_number`, `Teacher`.`date_of_birth`, `Teacher`.`nationality`, `Teacher`.`religion`, `Teacher`.`gender`, `Teacher`.`blood_group`, `Teacher`.`marital_status`, `Teacher`.`contact_number`, `Teacher`.`teaching_designation`, `Teacher`.`teaching_subject`, `Teacher`.`joining_date`, `Teacher`.`mpo_code`, `Teacher`.`mpo_date`, `Teacher`.`current_salary_code`, `Teacher`.`bank_ac`, `Teacher`.`bank_name`, `Teacher`.`bank_branch_name`, `Teacher`.`institute_id`, `Teacher`.`photo_id`, `Teacher`.`is_deleted`, `Teacher`.`is_published`, `Teacher`.`sort_order`, `Teacher`.`created_user_id`, `Teacher`.`modified_user_id`, `Teacher`.`created`, `Teacher`.`modified` FROM `dumoorco_biddaloy_sandbox`.`board_examiner_infos` AS `BoardExaminerInfo` LEFT JOIN `dumoorco_biddaloy_sandbox`.`teachers` AS `Teacher` ON (`BoardExaminerInfo`.`teacher_id` = `Teacher`.`id`) WHERE `BoardExaminerInfo`.`teacher_id` = 39 | | 0 | 0 | 4 |