For Job Seeker and Employee

  • Job by Categories
  • Job by Location
  • Job by Company
  • Job by Qualification
  • YELP Vacancies
  • Oversea Vacancies
  • Skills Development Plan(SDP)
  • Institute Certificate
  • National Certificate
  • Entrepreneurship
  • Critical Capability Development
# Training Provider/Institution Course Funding Source Course Fee Application Date Course Date Mininum Qualification Training Location Course Description Apply
1 Technical Training Institute Samthang Auto Electrician Skills Development Plan(SDP) 0 15th-Jul-2025 to 27th-Jul-2025 4th-Aug-2025 to 31st-Mar-2026 ( 7 months ) Wangdue Phodrang Course Includes Applying Fundamentals of electricity Maintaining automobile batteries, charging and lighting system Maintaining ignition and starting system Maintaining electrical accessories
2 Jigme Wangchuck Power Training Institute Industry Electrical Technician Skills Development Plan(SDP) 1600 3rd-Jul-2025 to 20th-Jul-2025 21st-Jul-2025 to 31st-Jul-2025 ( 0 month ) Sarpang Unpon graduation they will be able to carry out all industrial wiring and control system wirn
3 Technical Training Institute Thimphu Graphic Designer Skills Development Plan(SDP) 0 1st-Jul-2025 to 21st-Jul-2025 1st-Aug-2025 to 30th-Jun-2027 ( 22 months ) Thimphu Learners will be able to create graphic content using adobe package.
4 Technical Training Institute Thimphu HVAC Technician Skills Development Plan(SDP) 0 1st-Jul-2025 to 21st-Jul-2025 1st-Aug-2025 to 31st-May-2026 ( 9 months ) Thimphu Learners will be able to perform installation of commercial refrigeration Plant, Chiller System and VRV.
5 Technical Training Institute Thimphu EV Technician Skills Development Plan(SDP) 0 1st-Jul-2025 to 31st-Jul-2025 1st-Aug-2025 to 28th-Feb-2026 ( 6 months ) Thimphu Learners will be able to perform basic maintenance of EV motors, Battery and charging system.
6 Technical Training Institute Thimphu Refrigeration and Air Conditioning Technician Skills Development Plan(SDP) 0 1st-Jul-2025 to 21st-Jul-2025 1st-Aug-2025 to 30th-Jun-2026 ( 10 months ) Thimphu Learners will be able to install the Split refrigeration system, domestic refrigeration system and Mobile Air condition.
7 Technical Training Institute Thimphu Automotive Technician Skills Development Plan(SDP) 0 1st-Jul-2025 to 21st-Jul-2025 1st-Aug-2025 to 31st-Mar-2026 ( 7 months ) Thimphu Learners will be able to perform Engine setup and Engine Overhauling
8 Technical Training Institute Thimphu Panel Beater Skills Development Plan(SDP) 0 1st-Jul-2025 to 21st-Jul-2025 1st-Aug-2025 to 31st-Dec-2025 ( 4 months ) Thimphu Learners will be able to perform basic welding and denting the vehicle body.
9 Technical Training Institute Thimphu Automotive Technician Skills Development Plan(SDP) 0 1st-Jul-2025 to 21st-Jul-2025 1st-Aug-2025 to 30th-Jun-2026 ( 10 months ) Thimphu Learners will be able to perform basic vehicle maintenance.
10 Technical Training Institute Thimphu Digital Marketing Skills Development Plan(SDP) 0 1st-Jul-2025 to 21st-Jul-2025 1st-Aug-2025 to 31st-Aug-2025 ( 0 month ) Class XII Thimphu Learners will be able to perform Digital content development, Project Plan development and Digital Content Creation.
11 National Institute for Zorig Chusum Jimzo Skills Development Plan(SDP) 0 1st-Jul-2025 to 28th-Jul-2025 1st-Aug-2025 to 31st-Oct-2025 ( 2 months ) Below Class X Thimphu མེ་ཏོག་དང་པ་ཏྲའི་རིགས་བཟོ་ཚུགས། གཟུགས་བརྙན་རིགས་བཟོ་ཚུགས། ཤེལ་སྐུད་ཀྱི་ཚུགས། རྩི་སའི་པ་ཏྲ་བརྐོ་ཚུགས། མཆོད་རྫས་བཀྲ་ཤིས་རྟགས་བརྒྱད་བརྐོ་ཚུགས། གཟུགས་བརྙན་རླུང་རྟ་སྡེ་ལྔ་བརྐོ་ཚུགས།
12 National Institute for Zorig Chusum Patrap Skills Development Plan(SDP) 0 1st-Jul-2025 to 28th-Jul-2025 1st-Aug-2025 to 31st-Oct-2025 ( 2 months ) Below Class X Thimphu ནཕམཐཏབགཆཅོ
13 National Institute for Zorig Chusum Tshemdrup Skills Development Plan(SDP) 0 1st-Jul-2025 to 28th-Jul-2025 1st-Aug-2025 to 31st-Oct-2025 ( 2 months ) Below Class X Thimphu མེ་ཏོག་གུ་རིགས། བཀྲིས་རྟགས་བརྒྱད། མཐུན་པ་སྤུན་བཞི། བྱ་ཚེ་རིང། གྲྭ་ལྟམ་ཚུ་འཐུ་ཚུགས།
14 National Institute for Zorig Chusum Machine Embroidery Skills Development Plan(SDP) 0 1st-Jul-2025 to 28th-Jul-2025 1st-Aug-2025 to 31st-Oct-2025 ( 2 months ) Below Class X Thimphu མེ་ཏོག། བཀྲིས་རྟགས་བརྒྱད། བྱ་ཚེ་རིང། མཐུན་པ་སྤྱན་བཞི་ཚུ་བཟོ་ཚུགས།
15 National Institute for Zorig Chusum Parzo- Shingzo Skills Development Plan(SDP) 0 1st-Jul-2025 to 28th-Jul-2025 1st-Aug-2025 to 31st-Oct-2025 ( 2 months ) Below Class X Thimphu ཅོག་སྒྲོམ་ཡོངས་རྫོགས་སྒྲིག་ཚུགས།
16 Technical Training Institute Samthang Sound Technician Skills Development Plan(SDP) 0 24th-Jun-2025 to 27th-Jul-2025 4th-Aug-2025 to 31st-Aug-2026 ( 12 months ) Wangdue Phodrang This course is designed to provide trainees with the knowledge, skills and attitudes required to be competent in Sound technician work. This course will prepare the trainees to exhibit professionalism, teamwork, adaptability, and safety practices as per the requirement of workplace. To obtain certification of this course, all learning outcomes prescribed must be achieved.
17 Technical Training Institute Samthang Video Maker Skills Development Plan(SDP) 0 24th-Jun-2025 to 27th-Jul-2025 4th-Aug-2025 to 31st-Aug-2026 ( 12 months ) Wangdue Phodrang This course is designed to provide trainees with the knowledge, skills and attitudes required to be competent in video maker work. This course will prepare the trainees to exhibit professionalism, teamwork, adaptability, and safety practices as per the requirement of workplace. To obtain certification of this course, all learning outcomes prescribed must be achieved.
18 Wangsel Institute for the Deaf Tshemzop Skills Development Plan(SDP) 150 23rd-Jun-2025 to 31st-Jul-2025 31st-Jul-2025 to 28th-Nov-2025 ( 3 months ) Paro Eligibility: Deaf students who have passed Class X from Wangsel Institute for the Deaf or equivalent. Duration: 2–3 years (includes practical training and assessments).
19 College of Zorig Chusum Shingtshen (Traditional Painting) Skills Development Plan(SDP) 0 16th-Jun-2025 to 20th-Jul-2025 1st-Jul-2025 to 30th-Sep-2025 ( 2 months ) No Education Trashiyangtse The Shingtshoen (Traditional Painting) is a short course program and the course duration is for 3 months. The training slots is 24.
20 College of Zorig Chusum Tailoring Skills Development Plan(SDP) 0 16th-Jun-2025 to 21st-Jul-2025 21st-Jul-2025 to 30th-Sep-2025 ( 2 months ) No Education Trashiyangtse The tailoring course is a short course and the training duration is for 3 months. We have 30 slots in this course.
# Training Provider/Institution Course Funding Source Course Fee Application Date Course Date Mininum Qualification Training Location Course Description Apply
1 Ghadyen Driving Training Institute Light Vehicle Driving Self Funded 13500 16-Jul-2025 to 30-Jul-2025 01-Sep-2025 to 30-Nov-2025 ( 2 months ) No Education Wangdue Phodrang Three months driving training
2 Sompal Driving Training Institute Refresher Training for Profesional Drivers RPL Certification Self Funded 8000 08-Jul-2025 to 26-Jul-2025 27-Jul-2025 to 01-Aug-2025 ( 0 month ) No Education Paro Refresher
3 Sacho Driving Training Institute Light Vehicle Driving Self Funded 12000 01-Jul-2025 to 31-Jul-2025 01-Aug-2025 to 31-Oct-2025 ( 2 months ) No Education Chukha Light vehicle driving training course
4 Sacho Driving Training Institute One Day Introductory Course Self Funded 500 01-Jul-2025 to 31-Jul-2025 01-Aug-2025 to 31-Aug-2025 ( 0 month ) No Education Chukha One day refresher course
5 Sacho Driving Training Institute Light Vehicle Driving Self Funded 12000 01-Jul-2025 to 31-Jul-2025 01-Aug-2025 to 31-Oct-2025 ( 2 months ) No Education Samtse Light vehicle driving training course
6 Sacho Driving Training Institute One Day Introductory Course Self Funded 500 01-Jul-2025 to 31-Jul-2025 01-Aug-2025 to 31-Aug-2025 ( 0 month ) No Education Samtse One day refresher course
# Training Provider/Institution Course Funding Source Course Fee Application Date Course Date Training Location Course Description Apply
1 Bhutan Institute of Tourism and Hospitality Culture Tour Guide Self Funded 38000 17-Jul-2025 to 20-Jul-2025 20-Jul-2025 to 08-Nov-2025 ( 3 months ) Thimphu This course is designed to provide the knowledge, skills and attitudes of an individual to become competent as Cultural Tourist Guide in accordance with industry standards. Upon completion of this course, the graduates will be able to work in tourism sectors where they can provide guest arrival services, carryout sightseeing, provide guest departure and handle emergencies.
2 Technical Training Institute Samthang Auto Electrician Skills Development Plan(SDP) 0 15-Jul-2025 to 27-Jul-2025 04-Aug-2025 to 31-Mar-2026 ( 7 months ) Wangdue Phodrang Course Includes Applying Fundamentals of electricity Maintaining automobile batteries, charging and lighting system Maintaining ignition and starting system Maintaining electrical accessories
3 Ugyen International Language and Culture Training Institute Culture Tour Guide Self Funded 35000 12-Jul-2025 to 20-Jul-2025 21-Jul-2025 to 04-Dec-2025 ( 4 months ) Thimphu Culture guide course
4 IMSL-Tourism Training Institute Culture Tour Guide Self Funded 35000 08-Jul-2025 to 25-Aug-2025 02-Sep-2025 to 02-Jan-2026 ( 4 months ) Thimphu Cultural Guide Training, BQF -II
5 Jigme Wangchuck Power Training Institute Industry Electrical Technician Skills Development Plan(SDP) 1600 03-Jul-2025 to 20-Jul-2025 21-Jul-2025 to 31-Jul-2025 ( 0 month ) Sarpang Unpon graduation they will be able to carry out all industrial wiring and control system wirn
6 Technical Training Institute Thimphu Automotive Technician Skills Development Plan(SDP) 0 01-Jul-2025 to 21-Jul-2025 01-Aug-2025 to 30-Jun-2026 ( 10 months ) Thimphu Learners will be able to perform basic vehicle maintenance.
7 Technical Training Institute Thimphu Panel Beater Skills Development Plan(SDP) 0 01-Jul-2025 to 21-Jul-2025 01-Aug-2025 to 31-Dec-2025 ( 4 months ) Thimphu Learners will be able to perform basic welding and denting the vehicle body.
8 Technical Training Institute Thimphu Automotive Technician Skills Development Plan(SDP) 0 01-Jul-2025 to 21-Jul-2025 01-Aug-2025 to 31-Mar-2026 ( 7 months ) Thimphu Learners will be able to perform Engine setup and Engine Overhauling
9 Technical Training Institute Thimphu Refrigeration and Air Conditioning Technician Skills Development Plan(SDP) 0 01-Jul-2025 to 21-Jul-2025 01-Aug-2025 to 30-Jun-2026 ( 10 months ) Thimphu Learners will be able to install the Split refrigeration system, domestic refrigeration system and Mobile Air condition.
10 Technical Training Institute Thimphu EV Technician Skills Development Plan(SDP) 0 01-Jul-2025 to 31-Jul-2025 01-Aug-2025 to 28-Feb-2026 ( 6 months ) Thimphu Learners will be able to perform basic maintenance of EV motors, Battery and charging system.
11 Technical Training Institute Thimphu HVAC Technician Skills Development Plan(SDP) 0 01-Jul-2025 to 21-Jul-2025 01-Aug-2025 to 31-May-2026 ( 9 months ) Thimphu Learners will be able to perform installation of commercial refrigeration Plant, Chiller System and VRV.
12 Technical Training Institute Thimphu Graphic Designer Skills Development Plan(SDP) 0 01-Jul-2025 to 21-Jul-2025 01-Aug-2025 to 30-Jun-2027 ( 22 months ) Thimphu Learners will be able to create graphic content using adobe package.
13 College of Zorig Chusum Tshemzop RGoB 850 01-Jul-2025 to 25-Jul-2025 06-Aug-2025 to 30-Aug-2026 ( 12 months ) Trashiyangtse Tailoring BQFC2 is a regular course and the training duration is for 13months.
14 College of Zorig Chusum Tshemdrup RGoB 850 01-Jul-2025 to 25-Jul-2025 06-Aug-2025 to 30-Nov-2026 ( 15 months ) Trashiyangtse Embroidery BQFC2 is a regular course and the training duration is for 16 months.
15 College of Zorig Chusum Shagzop RGoB 850 01-Jul-2025 to 25-Jul-2025 06-Aug-2025 to 30-Aug-2026 ( 12 months ) Trashiyangtse Wood Turning BQFC2 is a regular course and the training duration is for 13 months.
16 College of Zorig Chusum Troezop RGoB 850 01-Jul-2025 to 25-Jul-2025 06-Aug-2025 to 28-Feb-2027 ( 18 months ) Trashiyangtse Gold and Silver Smith BQFC2 is a regular course and the training duration is for 19 months.
17 College of Zorig Chusum Patrap RGoB 850 01-Jul-2025 to 25-Jul-2025 06-Aug-2025 to 30-Apr-2027 ( 20 months ) Trashiyangtse Wood Carving BQFC 2 is a regular course and the training duration is for 21 months.
18 College of Zorig Chusum Lhadrip RGoB 850 01-Jul-2025 to 25-Jul-2025 06-Aug-2025 to 30-Sep-2026 ( 13 months ) Trashiyangtse Painting BQFC2 is a regular course and the training duration is for 14 months.
19 College of Zorig Chusum Troezop RGoB 850 01-Jul-2025 to 25-Jul-2025 06-Aug-2025 to 30-Nov-2026 ( 15 months ) Trashiyangtse Gold and Silver Smith BQFC3 is a regular course and the training duration is for 16 months.
20 College of Zorig Chusum Shagzop RGoB 850 01-Jul-2025 to 25-Jul-2025 06-Aug-2025 to 30-Aug-2025 ( 0 month ) Trashiyangtse Wood Turning BQF Certificate 3 is a regular course and the training duration is for 13 months.
21 College of Zorig Chusum Tshemzop RGoB 850 01-Jul-2025 to 25-Jul-2025 06-Aug-2025 to 30-Jun-2026 ( 10 months ) Trashiyangtse Tailoring BQF Certificate 3 is a regular course and the training duration is for 11 months.
22 Technical Training Institute Samthang Video Maker Skills Development Plan(SDP) 0 24-Jun-2025 to 27-Jul-2025 04-Aug-2025 to 31-Aug-2026 ( 12 months ) Wangdue Phodrang This course is designed to provide trainees with the knowledge, skills and attitudes required to be competent in video maker work. This course will prepare the trainees to exhibit professionalism, teamwork, adaptability, and safety practices as per the requirement of workplace. To obtain certification of this course, all learning outcomes prescribed must be achieved.
23 Technical Training Institute Samthang Sound Technician Skills Development Plan(SDP) 0 24-Jun-2025 to 27-Jul-2025 04-Aug-2025 to 31-Aug-2026 ( 12 months ) Wangdue Phodrang This course is designed to provide trainees with the knowledge, skills and attitudes required to be competent in Sound technician work. This course will prepare the trainees to exhibit professionalism, teamwork, adaptability, and safety practices as per the requirement of workplace. To obtain certification of this course, all learning outcomes prescribed must be achieved.
24 Wangsel Institute for the Deaf Tshemzop Skills Development Plan(SDP) 150 23-Jun-2025 to 31-Jul-2025 31-Jul-2025 to 28-Nov-2025 ( 3 months ) Paro Eligibility: Deaf students who have passed Class X from Wangsel Institute for the Deaf or equivalent. Duration: 2–3 years (includes practical training and assessments).
25 Kuendrup Institute of Innovation and Technology (KIIT) Construction Supervisor Self Funded 398000 15-Apr-2025 to 30-Jul-2025 03-Aug-2025 to 03-Aug-2027 ( 24 months ) Sarpang The Diploma in Construction Supervision is a comprehensive program designed to equip students with essential skills for a successful career in construction. The course covers both horizontal and vertical skills. The horizontal skills focus on practical and theoretical knowledge in masonry, electrical work, carpentry, and plumbing during the first semester. The vertical skills include core engineering modules, such as Engineering Drawing and Design, Quality Control, Project Management, Occupational Health and Safety (OHS), Estimation, Contract Documents & Work Plans, and Supervision of Construction Works, with a hands-on approach to ensure real-world applicability. Students will also learn to prepare resource plans and manage construction projects effectively. Additionally, the course integrates soft skills, including professional English, Applied ICT, Applied Dzongkha, leadership and management, entrepreneurship, Green TVET, and Applied Mathematics to foster well-rounded personal and professional growth. On-the-job training (OJT) provides valuable practical experience. Upon completion, graduates can pursue careers as Site Engineers, Project Managers, OHS Focal Points, or entrepreneurs in the construction industry. Admission criteria Class X with NC 3 or Class XII passed

How to apply for Job?

1

Register as Job Seeker

After successful registration, you will receive email and SMS notification with login details.

Job Seeker Registration form

2

Update Profile

After logging in, you have to complete your profile to apply for jobs and receive notifications about jobs relevant to you.

3

Apply Job

You can apply for jobs that you are interested in.

Office

Ministry of Industry, Commerce & Employment
P.O Box #1036, Thongsel Lam
Lower Motithang, Thimphu, Bhutan.

Contacts

© Copyright 2023. All right reserved, Ministry of Industry, Commerce and Employment.

7.4.33PHP Version5.34sRequest Duration17MBMemory UsageGET jobseeker_page/{type}/{trainingTypeId?}Route
    • Booting (17.47ms)
    • Application (5.32s)
    • 1 x Application (99.67%)
      5.32s
      1 x Booting (0.33%)
      17.47ms
      7 templates were rendered
      • /var/www/html/mis/vendor/livewire/livewire/src/Macros/livewire-view-component.blade.php (vendor/livewire/livewire/src/Macros/livewire-view-component.blade.php)4blade
        Params
        0
        view
        1
        params
        2
        slotOrSection
        3
        manager
      • livewire.frontpage.jobseeker (resources/views/livewire/frontpage/jobseeker.blade.php)42blade
        Params
        0
        livewireLayout
        1
        errors
        2
        _instance
        3
        is_findjob
        4
        is_jobdetails
        5
        category_list
        6
        category_id
        7
        location_list
        8
        location_id
        9
        qualification_list
        10
        qualification_id
        11
        search_job_list
        12
        job_application_no
        13
        job_details
        14
        job_by_categories
        15
        job_by_location
        16
        job_by_company
        17
        job_by_qualification
        18
        job_by_yelp
        19
        job_by_oversea
        20
        is_click
        21
        click_id
        22
        tab_id
        23
        search_id
        24
        training_by_sdp
        25
        training_by_institute
        26
        training_by_national
        27
        training_by_entrepreneurship
        28
        entrepreneurships
        29
        list_of_trainings
        30
        showtab
        31
        tabIndex
        32
        type
        33
        trainingTypeId
        34
        trainingLists
        35
        courseLists
        36
        dzongkhagLists
        37
        instituteLists
        38
        courseId
        39
        trainingCategory
        40
        dzongkhagId
        41
        instituteId
      • layouts.frontpage (resources/views/layouts/frontpage.blade.php)3blade
        Params
        0
        attributes
        1
        slot
        2
        __laravel_slots
      • partials.frontpage.header (resources/views/partials/frontpage/header.blade.php)7blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        attributes
        5
        slot
        6
        __laravel_slots
      • partials.frontpage.desktop-header (resources/views/partials/frontpage/desktop-header.blade.php)7blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        attributes
        5
        slot
        6
        __laravel_slots
      • partials.frontpage.mobile-header (resources/views/partials/frontpage/mobile-header.blade.php)7blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        attributes
        5
        slot
        6
        __laravel_slots
      • partials.frontpage.footer (resources/views/partials/frontpage/footer.blade.php)7blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        _instance
        4
        attributes
        5
        slot
        6
        __laravel_slots
      uri
      GET jobseeker_page/{type}/{trainingTypeId?}
      middleware
      web
      controller
      App\Http\Livewire\Frontpage\Jobseeker@__invoke
      namespace
      prefix
      where
      as
      jobseeker_page
      file
      vendor/livewire/livewire/src/Component.php:46-88
      21 statements were executed, 3 of which were duplicated, 18 unique5.26s
      • select * from `sessions` where `id` = 'UALqzuZWvTbCUWeMjZ54Pil4rGzEqnXQndmXwhAy' limit 1
        5.12ms/vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:100db_molhr_mis
        Metadata
        Bindings
        • 0. UALqzuZWvTbCUWeMjZ54Pil4rGzEqnXQndmXwhAy
        Backtrace
        • 14. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:100
        • 15. /vendor/laravel/framework/src/Illuminate/Session/Store.php:97
        • 16. /vendor/laravel/framework/src/Illuminate/Session/Store.php:87
        • 17. /vendor/laravel/framework/src/Illuminate/Session/Store.php:71
        • 18. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:147
      • SELECT a.*, COUNT(DISTINCT(a.application_no)) count_no, b.dropdown_name qualification, a.qualification_id, b1.dropdown_name employment_type, c.occupation_name job_category, d.gewog_name, e.dzongkhag_name, d.dzongkhag_id, f.application_no company_id, w.dropdown_name country, CASE WHEN f.employer_type_id =2 THEN f.business_name WHEN f.employer_type_id =3 THEN k.dropdown_name WHEN f.employer_type_id =4 THEN f.business_name WHEN f.employer_type_id =5 THEN i.dropdown_name WHEN f.employer_type_id =6 THEN f.name WHEN f.employer_type_id =7 THEN f.business_name ELSE f.business_name END AS business_name FROM tbl_employer_vacancy_dtls a LEFT JOIN tbl_dropdown_masters b ON (a.qualification_id = b.id) LEFT JOIN tbl_dropdown_masters b1 ON (a.employment_type = b1.id) LEFT JOIN tbl_occupation_master c ON (a.job_category_id = c.occupation_id) LEFT JOIN tbl_gewog_master d ON (a.gewog_id = d.gewog_id) LEFT JOIN tbl_dzongkhag_master e ON (d.dzongkhag_id = e.dzongkhag_id) LEFT JOIN tbl_employer_registration_app f ON (a.employer_app_id = f.application_no) LEFT JOIN tbl_workflow_dtls g ON a.application_no=g.application_no LEFT JOIN tbl_dropdown_masters i ON f.organization_id=i.id LEFT JOIN tbl_dropdown_masters j ON f.department_id=j.id LEFT JOIN tbl_dropdown_masters k ON f.ministry_agency=k.id LEFT JOIN tbl_dropdown_masters w ON a.country_id=w.id WHERE a.last_date_registration >= CURRENT_DATE() AND g.status_id=159 GROUP BY a.job_category_id ORDER BY c.occupation_name
        588ms/app/Models/Common.php:22db_molhr_mis
        Metadata
        Backtrace
        • 10. /app/Models/Common.php:22
        • 11. /app/Http/Livewire/Frontpage/Jobseeker.php:106
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 13. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT a.*, COUNT(DISTINCT(a.application_no)) count_no, b.dropdown_name qualification, a.qualification_id, b1.dropdown_name employment_type, c.occupation_name job_category, d.gewog_name, e.dzongkhag_name, d.dzongkhag_id, f.application_no company_id, w.dropdown_name country, CASE WHEN f.employer_type_id =2 THEN f.business_name WHEN f.employer_type_id =3 THEN k.dropdown_name WHEN f.employer_type_id =4 THEN f.business_name WHEN f.employer_type_id =5 THEN i.dropdown_name WHEN f.employer_type_id =6 THEN f.name WHEN f.employer_type_id =7 THEN f.business_name ELSE f.business_name END AS business_name FROM tbl_employer_vacancy_dtls a LEFT JOIN tbl_dropdown_masters b ON (a.qualification_id = b.id) LEFT JOIN tbl_dropdown_masters b1 ON (a.employment_type = b1.id) LEFT JOIN tbl_occupation_master c ON (a.job_category_id = c.occupation_id) LEFT JOIN tbl_gewog_master d ON (a.gewog_id = d.gewog_id) LEFT JOIN tbl_dzongkhag_master e ON (d.dzongkhag_id = e.dzongkhag_id) LEFT JOIN tbl_employer_registration_app f ON (a.employer_app_id = f.application_no) LEFT JOIN tbl_workflow_dtls g ON a.application_no=g.application_no LEFT JOIN tbl_dropdown_masters i ON f.organization_id=i.id LEFT JOIN tbl_dropdown_masters j ON f.department_id=j.id LEFT JOIN tbl_dropdown_masters k ON f.ministry_agency=k.id LEFT JOIN tbl_dropdown_masters w ON a.country_id=w.id WHERE a.last_date_registration >= CURRENT_DATE() AND g.status_id=159 GROUP BY d.dzongkhag_id ORDER BY e.dzongkhag_name
        585ms/app/Models/Common.php:22db_molhr_mis
        Metadata
        Backtrace
        • 10. /app/Models/Common.php:22
        • 11. /app/Http/Livewire/Frontpage/Jobseeker.php:107
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 13. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT a.*, COUNT(DISTINCT(a.application_no)) count_no, b.dropdown_name qualification, a.qualification_id, b1.dropdown_name employment_type, c.occupation_name job_category, d.gewog_name, e.dzongkhag_name, d.dzongkhag_id, f.application_no company_id, w.dropdown_name country, CASE WHEN f.employer_type_id =2 THEN f.business_name WHEN f.employer_type_id =3 THEN k.dropdown_name WHEN f.employer_type_id =4 THEN f.business_name WHEN f.employer_type_id =5 THEN i.dropdown_name WHEN f.employer_type_id =6 THEN f.name WHEN f.employer_type_id =7 THEN f.business_name ELSE f.business_name END AS business_name FROM tbl_employer_vacancy_dtls a LEFT JOIN tbl_dropdown_masters b ON (a.qualification_id = b.id) LEFT JOIN tbl_dropdown_masters b1 ON (a.employment_type = b1.id) LEFT JOIN tbl_occupation_master c ON (a.job_category_id = c.occupation_id) LEFT JOIN tbl_gewog_master d ON (a.gewog_id = d.gewog_id) LEFT JOIN tbl_dzongkhag_master e ON (d.dzongkhag_id = e.dzongkhag_id) LEFT JOIN tbl_employer_registration_app f ON (a.employer_app_id = f.application_no) LEFT JOIN tbl_workflow_dtls g ON a.application_no=g.application_no LEFT JOIN tbl_dropdown_masters i ON f.organization_id=i.id LEFT JOIN tbl_dropdown_masters j ON f.department_id=j.id LEFT JOIN tbl_dropdown_masters k ON f.ministry_agency=k.id LEFT JOIN tbl_dropdown_masters w ON a.country_id=w.id WHERE a.last_date_registration >= CURRENT_DATE() AND g.status_id=159 GROUP BY f.application_no
        586ms/app/Models/Common.php:22db_molhr_mis
        Metadata
        Backtrace
        • 10. /app/Models/Common.php:22
        • 11. /app/Http/Livewire/Frontpage/Jobseeker.php:108
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 13. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT a.*, COUNT(DISTINCT(a.application_no)) count_no, b.dropdown_name qualification, a.qualification_id, b1.dropdown_name employment_type, c.occupation_name job_category, d.gewog_name, e.dzongkhag_name, d.dzongkhag_id, f.application_no company_id, w.dropdown_name country, CASE WHEN f.employer_type_id =2 THEN f.business_name WHEN f.employer_type_id =3 THEN k.dropdown_name WHEN f.employer_type_id =4 THEN f.business_name WHEN f.employer_type_id =5 THEN i.dropdown_name WHEN f.employer_type_id =6 THEN f.name WHEN f.employer_type_id =7 THEN f.business_name ELSE f.business_name END AS business_name FROM tbl_employer_vacancy_dtls a LEFT JOIN tbl_dropdown_masters b ON (a.qualification_id = b.id) LEFT JOIN tbl_dropdown_masters b1 ON (a.employment_type = b1.id) LEFT JOIN tbl_occupation_master c ON (a.job_category_id = c.occupation_id) LEFT JOIN tbl_gewog_master d ON (a.gewog_id = d.gewog_id) LEFT JOIN tbl_dzongkhag_master e ON (d.dzongkhag_id = e.dzongkhag_id) LEFT JOIN tbl_employer_registration_app f ON (a.employer_app_id = f.application_no) LEFT JOIN tbl_workflow_dtls g ON a.application_no=g.application_no LEFT JOIN tbl_dropdown_masters i ON f.organization_id=i.id LEFT JOIN tbl_dropdown_masters j ON f.department_id=j.id LEFT JOIN tbl_dropdown_masters k ON f.ministry_agency=k.id LEFT JOIN tbl_dropdown_masters w ON a.country_id=w.id WHERE a.last_date_registration >= CURRENT_DATE() AND g.status_id=159 GROUP BY a.qualification_id ORDER BY b.dropdown_name
        580ms/app/Models/Common.php:22db_molhr_mis
        Metadata
        Backtrace
        • 10. /app/Models/Common.php:22
        • 11. /app/Http/Livewire/Frontpage/Jobseeker.php:109
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 13. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT a.*, COUNT(DISTINCT(a.application_no)) count_no, b.dropdown_name qualification, a.qualification_id, b1.dropdown_name employment_type, c.occupation_name job_category, d.gewog_name, e.dzongkhag_name, d.dzongkhag_id, f.application_no company_id, w.dropdown_name country, CASE WHEN f.employer_type_id =2 THEN f.business_name WHEN f.employer_type_id =3 THEN k.dropdown_name WHEN f.employer_type_id =4 THEN f.business_name WHEN f.employer_type_id =5 THEN i.dropdown_name WHEN f.employer_type_id =6 THEN f.name WHEN f.employer_type_id =7 THEN f.business_name ELSE f.business_name END AS business_name FROM tbl_employer_vacancy_dtls a LEFT JOIN tbl_dropdown_masters b ON (a.qualification_id = b.id) LEFT JOIN tbl_dropdown_masters b1 ON (a.employment_type = b1.id) LEFT JOIN tbl_occupation_master c ON (a.job_category_id = c.occupation_id) LEFT JOIN tbl_gewog_master d ON (a.gewog_id = d.gewog_id) LEFT JOIN tbl_dzongkhag_master e ON (d.dzongkhag_id = e.dzongkhag_id) LEFT JOIN tbl_employer_registration_app f ON (a.employer_app_id = f.application_no) LEFT JOIN tbl_workflow_dtls g ON a.application_no=g.application_no LEFT JOIN tbl_dropdown_masters i ON f.organization_id=i.id LEFT JOIN tbl_dropdown_masters j ON f.department_id=j.id LEFT JOIN tbl_dropdown_masters k ON f.ministry_agency=k.id LEFT JOIN tbl_dropdown_masters w ON a.country_id=w.id WHERE a.last_date_registration >= CURRENT_DATE() AND g.status_id=159 AND a.vacancy_type_id=185 GROUP BY a.job_category_id ORDER BY c.occupation_name
        582ms/app/Models/Common.php:22db_molhr_mis
        Metadata
        Backtrace
        • 10. /app/Models/Common.php:22
        • 11. /app/Http/Livewire/Frontpage/Jobseeker.php:110
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 13. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT a.*, COUNT(DISTINCT(a.application_no)) count_no, b.dropdown_name qualification, a.qualification_id, b1.dropdown_name employment_type, c.occupation_name job_category, d.gewog_name, e.dzongkhag_name, d.dzongkhag_id, f.application_no company_id, w.dropdown_name country, CASE WHEN f.employer_type_id =2 THEN f.business_name WHEN f.employer_type_id =3 THEN k.dropdown_name WHEN f.employer_type_id =4 THEN f.business_name WHEN f.employer_type_id =5 THEN i.dropdown_name WHEN f.employer_type_id =6 THEN f.name WHEN f.employer_type_id =7 THEN f.business_name ELSE f.business_name END AS business_name FROM tbl_employer_vacancy_dtls a LEFT JOIN tbl_dropdown_masters b ON (a.qualification_id = b.id) LEFT JOIN tbl_dropdown_masters b1 ON (a.employment_type = b1.id) LEFT JOIN tbl_occupation_master c ON (a.job_category_id = c.occupation_id) LEFT JOIN tbl_gewog_master d ON (a.gewog_id = d.gewog_id) LEFT JOIN tbl_dzongkhag_master e ON (d.dzongkhag_id = e.dzongkhag_id) LEFT JOIN tbl_employer_registration_app f ON (a.employer_app_id = f.application_no) LEFT JOIN tbl_workflow_dtls g ON a.application_no=g.application_no LEFT JOIN tbl_dropdown_masters i ON f.organization_id=i.id LEFT JOIN tbl_dropdown_masters j ON f.department_id=j.id LEFT JOIN tbl_dropdown_masters k ON f.ministry_agency=k.id LEFT JOIN tbl_dropdown_masters w ON a.country_id=w.id WHERE a.last_date_registration >= CURRENT_DATE() AND g.status_id=159 AND a.vacancy_type_id=516 GROUP BY a.job_category_id ORDER BY c.occupation_name
        579ms/app/Models/Common.php:22db_molhr_mis
        Metadata
        Backtrace
        • 10. /app/Models/Common.php:22
        • 11. /app/Http/Livewire/Frontpage/Jobseeker.php:111
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 13. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT a.*, b.dzongkhag_name, c.dropdown_name AS course_name, CONCAT(DATE_FORMAT(a.application_start_date,'%d-%b-%Y'),' to ',DATE_FORMAT(a.application_end_date,'%d-%b-%Y')) AS application_date, CONCAT(DATE_FORMAT(a.course_start_date,'%d-%b-%Y'),' to ',DATE_FORMAT(a.course_end_date,'%d-%b-%Y')) AS course_date FROM tbl_entrepreneurship_training_dtls a LEFT JOIN tbl_dzongkhag_master b ON a.dzongkhag_id = b.dzongkhag_id LEFT JOIN tbl_dropdown_masters c ON a.course_id = c.id WHERE a.is_deleted='N' AND a.application_end_date >= CURRENT_DATE() ORDER BY a.application_no DESC
        1.62ms/app/Models/Common.php:22db_molhr_mis
        Metadata
        Backtrace
        • 10. /app/Models/Common.php:22
        • 11. /app/Http/Livewire/Frontpage/Jobseeker.php:112
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 13. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT a.application_no, a.job_category_id,b.occupation_name FROM tbl_employer_vacancy_dtls a LEFT JOIN tbl_occupation_master b ON (a.job_category_id=b.occupation_id) LEFT JOIN tbl_workflow_dtls c ON (a.application_no=c.application_no) WHERE a.last_date_registration >= CURRENT_DATE() AND c.status_id=159 GROUP BY a.job_category_id ORDER BY b.occupation_name
        576ms/app/Models/Common.php:22db_molhr_mis
        Metadata
        Backtrace
        • 10. /app/Models/Common.php:22
        • 11. /app/Http/Livewire/Frontpage/Jobseeker.php:114
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 13. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT a.application_no, a.gewog_id, e.dzongkhag_name location_name FROM tbl_employer_vacancy_dtls a LEFT JOIN tbl_gewog_master d ON (a.gewog_id=d.gewog_id) LEFT JOIN tbl_dzongkhag_master e ON (d.dzongkhag_id=e.dzongkhag_id) LEFT JOIN tbl_workflow_dtls f ON (a.application_no=f.application_no) WHERE a.last_date_registration >= CURRENT_DATE() AND f.status_id=159 GROUP BY d.dzongkhag_id ORDER BY e.dzongkhag_name
        573ms/app/Models/Common.php:22db_molhr_mis
        Metadata
        Backtrace
        • 10. /app/Models/Common.php:22
        • 11. /app/Http/Livewire/Frontpage/Jobseeker.php:115
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 13. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT a.application_no, a.qualification_id, b.dropdown_name FROM tbl_employer_vacancy_dtls a LEFT JOIN tbl_dropdown_masters b ON (a.qualification_id=b.id) LEFT JOIN tbl_workflow_dtls c ON (a.application_no=c.application_no) WHERE a.last_date_registration >= CURRENT_DATE() AND c.status_id=159 GROUP BY a.qualification_id ORDER BY b.dropdown_name
        578ms/app/Models/Common.php:22db_molhr_mis
        Metadata
        Backtrace
        • 10. /app/Models/Common.php:22
        • 11. /app/Http/Livewire/Frontpage/Jobseeker.php:116
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 13. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT a.*, b.dropdown_name AS country, c.dropdown_name AS training_level, d.dropdown_name AS training_type, f.dropdown_name AS donor_name, IF ( a.end_date < CURRENT_DATE (), '1', '0' ) AS application_status, CONCAT( DATE_FORMAT(a.start_date, '%b %d %Y'), ' ', 'to', ' ', DATE_FORMAT(a.end_date, '%b %d %Y') ) AS training_date, IF ( DATEDIFF(a.end_date, a.start_date) > 1, CONCAT( DATEDIFF(a.end_date, a.start_date), ' Days' ), CONCAT( DATEDIFF(a.end_date, a.start_date), ' Day' ) ) AS duration, IF ( a.dzongkhag_id IS NOT NULL, e.dzongkhag_name, a.city ) AS training_location FROM tbl_inservice_hrd_training_dtls a LEFT JOIN tbl_dropdown_masters b ON a.country_id = b.id LEFT JOIN tbl_dropdown_masters c ON a.training_level_id = c.id LEFT JOIN tbl_dropdown_masters d ON a.training_type_id = d.id LEFT JOIN tbl_dzongkhag_master e ON a.dzongkhag_id = e.dzongkhag_id LEFT JOIN tbl_dropdown_masters f ON a.donor_id = f.id WHERE a.is_active = 'Y'
        1.69ms/app/Models/Common.php:22db_molhr_mis
        Metadata
        Backtrace
        • 10. /app/Models/Common.php:22
        • 11. /app/Http/Livewire/Frontpage/Jobseeker.php:117
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 13. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select * from `tbl_dropdown_masters` where `parent_id` = 1791 order by `dropdown_name` asc
        830μs/app/Models/Common.php:116db_molhr_mis
        Metadata
        Bindings
        • 0. 1791
        Backtrace
        • 12. /app/Models/Common.php:116
        • 13. /app/Http/Livewire/Frontpage/Jobseeker.php:123
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 15. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select * from `tbl_dzongkhag_master` order by `dzongkhag_name` asc
        790μs/app/Models/Common.php:116db_molhr_mis
        Metadata
        Backtrace
        • 12. /app/Models/Common.php:116
        • 13. /app/Http/Livewire/Frontpage/Jobseeker.php:124
        • 14. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 15. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 16. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT tbl.institute_id, CONCAT(b.institute_name,'(',c.dzongkhag_name,')') institute_name FROM (SELECT a.institute_id FROM tvet_nac_app a WHERE a.application_end_date >= DATE_FORMAT(NOW(),'%Y-%m-%d') AND a.funding_source_id=3 UNION SELECT a.institute_id FROM tvet_other_courses_app a WHERE a.application_end_date >= DATE_FORMAT(NOW(),'%Y-%m-%d') AND a.funding_source_id=3 )tbl LEFT JOIN tvet_institute_dtls b ON (tbl.institute_id=b.institute_id) LEFT JOIN tbl_dzongkhag_master c ON b.dzongkhag_id=c.dzongkhag_id GROUP BY b.institute_id
        6.68ms/app/Models/TVETCommon.php:25db_molhr_tvet
        Metadata
        Backtrace
        • 8. /app/Models/TVETCommon.php:25
        • 9. /app/Http/Livewire/Frontpage/Jobseeker.php:139
        • 10. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 11. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT tbl.*, b.institute_name, c.dzongkhag_name, b.mobile_no FROM (SELECT a.application_no, a.institute_id, a.course_id, a.application_start_date app_start_date, DATE_FORMAT(a.application_start_date,'%D-%b-%Y')application_start_date, DATE_FORMAT(a.application_end_date,'%D-%b-%Y') application_end_date, DATE_FORMAT(a.course_start_date, '%D-%b-%Y') course_start_date, DATE_FORMAT(a.course_end_date, '%D-%b-%Y') course_end_date, a.course_fee, 'nc' c_type, b.occupation_name, a.funding_source_id, a.course_description, '' AS qualification_name, TIMESTAMPDIFF(MONTH,a.course_start_date,a.course_end_date) AS total_month, f.dropdown_name AS funding_source, IF(CURDATE() BETWEEN a.application_start_date AND a.application_start_date,1,0) AS duration, a.training_dzo_location_id FROM tvet_nac_app a LEFT JOIN tvet_occupation_master b ON a.course_id=b.occupation_id LEFT JOIN tbl_dropdown_masters f ON (a.funding_source_id=f.reference_id AND f.parent_id=27) WHERE a.application_end_date >= DATE_FORMAT(NOW(),'%Y-%m-%d') AND a.funding_source_id=3 UNION SELECT a.application_no, a.institute_id, a.course_type_id course_id, a.application_start_date app_start_date, DATE_FORMAT(a.application_start_date,'%D-%b-%Y')application_start_date, DATE_FORMAT(a.application_end_date,'%D-%b-%Y') application_end_date, DATE_FORMAT(a.course_start_date, '%D-%b-%Y') course_start_date, DATE_FORMAT(a.course_end_date, '%D-%b-%Y') course_end_date, a.course_fee, 'oc' c_type, c.course_title AS occupation_name, a.funding_source_id, a.course_description, d.qualification_name, TIMESTAMPDIFF(MONTH,a.course_start_date,a.course_end_date) AS total_month, f.dropdown_name AS funding_source, IF(CURDATE() BETWEEN a.application_start_date AND a.application_start_date,1,0) AS duration, a.training_dzo_location_id FROM tvet_other_courses_app a LEFT JOIN tvet_institute_course_dtls c ON a.course_type_id=c.course_id LEFT JOIN tbl_qualification_master d ON a.qualification_id=d.qualification_id LEFT JOIN tbl_dropdown_masters f ON (a.funding_source_id=f.reference_id AND f.parent_id=27) WHERE a.application_end_date >= DATE_FORMAT(NOW(),'%Y-%m-%d') AND a.funding_source_id=3 ) tbl LEFT JOIN tvet_institute_dtls b ON (tbl.institute_id=b.institute_id) LEFT JOIN tbl_dzongkhag_master c ON (IF(tbl.training_dzo_location_id IS NULL,b.dzongkhag_id=c.dzongkhag_id,tbl.training_dzo_location_id=c.dzongkhag_id)) WHERE IF(''='',1=1,tbl.institute_id='') AND IF(''='',1=1,tbl.course_id='') AND IF(''='',1=1,(IF(tbl.training_dzo_location_id IS NULL,b.dzongkhag_id,tbl.training_dzo_location_id))='') ORDER BY tbl.app_start_date DESC
        8.04ms/app/Models/TVETCommon.php:23db_molhr_tvet
        Metadata
        Bindings
        • 0. 
        • 1. 
        • 2. 
        • 3. 
        • 4. 
        • 5. 
        Backtrace
        • 8. /app/Models/TVETCommon.php:23
        • 9. /app/Http/Livewire/Frontpage/Jobseeker.php:179
        • 10. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 11. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT a.*, 0 c_type, b.registration_no, b.institute_name, a.course_type_id course_id, c.course_title AS occupation_name, a.application_start_date app_start_date, DATE_FORMAT(a.application_start_date,'%d-%b-%Y') application_start_date, DATE_FORMAT(a.application_end_date,'%d-%b-%Y') application_end_date, DATE_FORMAT(a.course_start_date, '%d-%b-%Y') course_start_date, DATE_FORMAT(a.course_end_date, '%d-%b-%Y') course_end_date, IF(CURDATE() BETWEEN a.application_start_date AND a.application_start_date,1,0) AS duration, d.dzongkhag_name, e.qualification_name, f.dropdown_name AS funding_source, TIMESTAMPDIFF(MONTH,a.course_start_date,a.course_end_date) AS total_month, b.mobile_no FROM tvet_other_courses_app a LEFT JOIN tvet_institute_dtls b ON a.institute_id=b.institute_id LEFT JOIN tvet_institute_course_dtls c ON a.course_type_id=c.course_id LEFT JOIN tbl_dzongkhag_master d ON (IF(a.training_dzo_location_id IS NULL,b.dzongkhag_id=d.dzongkhag_id,a.training_dzo_location_id=d.dzongkhag_id)) LEFT JOIN tbl_qualification_master e ON a.qualification_id=e.qualification_id LEFT JOIN tbl_dropdown_masters f ON (a.funding_source_id=f.reference_id AND f.parent_id=27) WHERE a.application_end_date >= DATE_FORMAT(NOW(),'%Y-%m-%d') AND a.is_deleted='N' AND a.funding_source_id <> 3 AND IF(''='',1=1,a.institute_id='') AND IF(''='',1=1,a.course_type_id='') AND IF(''='',1=1,(IF(a.training_dzo_location_id IS NULL,b.dzongkhag_id,a.training_dzo_location_id))='') ORDER BY a.application_no DESC
        5.35ms/app/Models/TVETCommon.php:23db_molhr_tvet
        Metadata
        Bindings
        • 0. 
        • 1. 
        • 2. 
        • 3. 
        • 4. 
        • 5. 
        Backtrace
        • 8. /app/Models/TVETCommon.php:23
        • 9. /app/Http/Livewire/Frontpage/Jobseeker.php:180
        • 10. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 11. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • SELECT a.*, 'nc' c_type, b.registration_no, b.institute_name, c.certificate_level_name, d.occupation_name, e.nac_button_name, f.dropdown_name AS funding_source, dzo.dzongkhag_name, '' AS qualification_name, a.application_start_date app_start_date, DATE_FORMAT(a.application_start_date,'%d-%b-%Y') application_start_date, DATE_FORMAT(a.application_end_date,'%d-%b-%Y') application_end_date, DATE_FORMAT(a.course_start_date, '%d-%b-%Y') course_start_date, DATE_FORMAT(a.course_end_date, '%d-%b-%Y') course_end_date, IF(CURDATE() BETWEEN a.application_start_date AND a.application_start_date,1,0) AS duration, TIMESTAMPDIFF(MONTH,a.course_start_date,a.course_end_date) AS total_month, b.mobile_no FROM tvet_nac_app a LEFT JOIN tvet_institute_dtls b ON (a.institute_id=b.institute_id) LEFT JOIN tbl_certificate_level_master c ON (a.certification_level_id=c.certificate_level_id) LEFT JOIN tvet_occupation_master d ON (a.course_id=d.occupation_id) LEFT JOIN tvet_nac_status_button_type e ON (a.nac_button_id=e.nac_button_id) LEFT JOIN tbl_dropdown_masters f ON (a.funding_source_id=f.reference_id AND f.parent_id=27) LEFT JOIN tbl_dzongkhag_master dzo ON (IF(a.training_dzo_location_id IS NULL,b.dzongkhag_id=dzo.dzongkhag_id,a.training_dzo_location_id=dzo.dzongkhag_id)) WHERE a.application_end_date >= DATE_FORMAT(NOW(),'%Y-%m-%d') AND a.is_deleted='N' AND SUBSTR(a.application_no,1,2)=17 AND IF(''='',1=1,a.institute_id='') AND IF(''='',1=1,a.course_id='') AND IF(''='',1=1,(IF(a.training_dzo_location_id IS NULL,b.dzongkhag_id,a.training_dzo_location_id))='') ORDER BY a.application_no DESC
        4.3ms/app/Models/TVETCommon.php:23db_molhr_tvet
        Metadata
        Bindings
        • 0. 
        • 1. 
        • 2. 
        • 3. 
        • 4. 
        • 5. 
        Backtrace
        • 8. /app/Models/TVETCommon.php:23
        • 9. /app/Http/Livewire/Frontpage/Jobseeker.php:181
        • 10. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
        • 11. /vendor/laravel/framework/src/Illuminate/Container/Util.php:40
        • 12. /vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:93
      • select * from `sessions` where `id` = 'UALqzuZWvTbCUWeMjZ54Pil4rGzEqnXQndmXwhAy' limit 1
        1.14ms/vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:100db_molhr_mis
        Metadata
        Bindings
        • 0. UALqzuZWvTbCUWeMjZ54Pil4rGzEqnXQndmXwhAy
        Backtrace
        • 14. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:100
        • 15. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:140
        • 16. /vendor/laravel/framework/src/Illuminate/Session/Store.php:129
        • 17. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:236
        • 18. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:130
      • insert into `sessions` (`payload`, `last_activity`, `user_id`, `ip_address`, `user_agent`, `id`) values ('YTozOntzOjY6Il90b2tlbiI7czo0MDoiZmE0YjZ2YVJYYmRnSU5EYllLWFQxTFZXMTYwQ1VKNmFmTWFxVEFTcyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDc6Imh0dHBzOi8vd3d3LmJsbWlzLmdvdi5idC9qb2JzZWVrZXJfcGFnZS9taXNwYWdlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1752993385, '', '216.73.216.121', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'UALqzuZWvTbCUWeMjZ54Pil4rGzEqnXQndmXwhAy')
        830μs/vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:162db_molhr_mis
        Metadata
        Bindings
        • 0. YTozOntzOjY6Il90b2tlbiI7czo0MDoiZmE0YjZ2YVJYYmRnSU5EYllLWFQxTFZXMTYwQ1VKNmFmTWFxVEFTcyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDc6Imh0dHBzOi8vd3d3LmJsbWlzLmdvdi5idC9qb2JzZWVrZXJfcGFnZS9taXNwYWdlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==
        • 1. 1752993385
        • 2. 
        • 3. 216.73.216.121
        • 4. Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
        • 5. UALqzuZWvTbCUWeMjZ54Pil4rGzEqnXQndmXwhAy
        Backtrace
        • 10. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:162
        • 11. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:146
        • 12. /vendor/laravel/framework/src/Illuminate/Session/Store.php:129
        • 13. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:236
        • 14. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:130
      • select * from `sessions` where `id` = 'UALqzuZWvTbCUWeMjZ54Pil4rGzEqnXQndmXwhAy' limit 1
        950μs/vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:100db_molhr_mis
        Metadata
        Bindings
        • 0. UALqzuZWvTbCUWeMjZ54Pil4rGzEqnXQndmXwhAy
        Backtrace
        • 14. /vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php:100
        • 15. /vendor/laravel/framework/src/Illuminate/Session/Store.php:97
        • 16. /vendor/laravel/framework/src/Illuminate/Session/Store.php:87
        • 17. /vendor/laravel/framework/src/Illuminate/Session/Store.php:71
        • 20. /vendor/maximebf/debugbar/src/DebugBar/DebugBar.php:446
      frontpage.jobseeker #aZZJsSPJjs2FqEktOSpF
      array:5 [ "data" => array:39 [ "is_findjob" => false "is_jobdetails" => false "categor...
          _token
          fa4b6vaRXbdgINDbYKXT1LVW160CUJ6afMaqTASs
          _previous
          array:1 [ "url" => "https://www.blmis.gov.bt/jobseeker_page/mispage" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /jobseeker_page/mispage
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:17 [ "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "keep-alive" ] "host" => array:1 [ 0 => "www.blmis.gov.bt" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
          request_server
          0 of 0
          array:41 [ "USER" => "apache" "HOME" => "/usr/share/httpd" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CONNECTION" => "keep-alive" "HTTP_HOST" => "www.blmis.gov.bt" "SCRIPT_FILENAME" => "/var/www/html/mis/public/index.php" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "blmis.gov.bt" "SERVER_PORT" => "443" "SERVER_ADDR" => "172.30.80.4" "REMOTE_PORT" => "28719" "REMOTE_ADDR" => "216.73.216.121" "SERVER_SOFTWARE" => "nginx/1.24.0" "GATEWAY_INTERFACE" => "CGI/1.1" "HTTPS" => "on" "REQUEST_SCHEME" => "https" "SERVER_PROTOCOL" => "HTTP/1.1" "DOCUMENT_ROOT" => "/var/www/html/mis/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/jobseeker_page/mispage" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1752993380.4034 "REQUEST_TIME" => 1752993380 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "max-age=0, must-revalidate, no-cache, no-store, private" ] "date" => array:1 [ 0 => "Sun, 20 Jul 2025 06:36:25 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "Fri, 01 Jan 1990 00:00:00 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJ4WTJiOTdUYXg2N0k5QWk0eDI0Smc9PSIsInZhbHVlIjoib1JvN0Nmc2RtRDkycFhPcHV1M1JWU0hjRGpVNWU3VTc5TG90T0hpU3NOdk94YVBDZUhJVEtDT1BtbTAvbmpzUUFmVVRzT1UyWHZKRnRUbk5BcnU5c2tVa3l5QnZMRHdaUEI0NXdLRldPTkVqNWw0L3VTZXorelpSY3ExVnFhUzEiLCJtYWMiOiI1NWFkZDQzYzA3OTY1Y2E0NWNmZDhlZWViNzk2YmI5Y2E0M2EzYjAyMGY5NWZiNDg3MDcxYTc4OWJkMWEwZTAwIiwidGFnIjoiIn0%3D; expires=Sun, 20-Jul-2025 08:36:25 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6IlJ4WTJiOTdUYXg2N0k5QWk0eDI0Smc9PSIsInZhbHVlIjoib1JvN0Nmc2RtRDkycFhPcHV1M1JWU0hjRGpVNWU3VTc5TG90T0hpU3NOdk94YVBDZUhJVEtDT1BtbTAvbmpzUUFmVVRzT" 1 => "blmis_session=eyJpdiI6InJsbG5rdjluQkNyZGtEbC9SeG5RcFE9PSIsInZhbHVlIjoiRXBXZVhwMHRYYmpuemd1N0V4TlVFckFWRzUyZUI0ckR6NkNXVDYvOW5kWTV2SCt0UVpNNHVuVWhvaXJ0MGlhMngxTTFUcGxHUExTQmx1Q1Q1RUxhZHJWb09hWVNrTUtJa2RxMG9hRXhWK2RUc2psYTdNQXJYWm13WnQ3aG9GdmciLCJtYWMiOiI2NDFhMGQ4ZjkzNjYyNzYyNzdjZjhmY2RkZTcwZWYzYmNiZmQ2Y2U1ODQ5ZDQyMDIxNTgyYThhYWIxOTBjNDJjIiwidGFnIjoiIn0%3D; expires=Sun, 20-Jul-2025 08:36:25 GMT; Max-Age=7200; path=/; httponly; samesite=laxblmis_session=eyJpdiI6InJsbG5rdjluQkNyZGtEbC9SeG5RcFE9PSIsInZhbHVlIjoiRXBXZVhwMHRYYmpuemd1N0V4TlVFckFWRzUyZUI0ckR6NkNXVDYvOW5kWTV2SCt0UVpNNHVuVWhvaXJ0MGlhMngxTT" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlJ4WTJiOTdUYXg2N0k5QWk0eDI0Smc9PSIsInZhbHVlIjoib1JvN0Nmc2RtRDkycFhPcHV1M1JWU0hjRGpVNWU3VTc5TG90T0hpU3NOdk94YVBDZUhJVEtDT1BtbTAvbmpzUUFmVVRzT1UyWHZKRnRUbk5BcnU5c2tVa3l5QnZMRHdaUEI0NXdLRldPTkVqNWw0L3VTZXorelpSY3ExVnFhUzEiLCJtYWMiOiI1NWFkZDQzYzA3OTY1Y2E0NWNmZDhlZWViNzk2YmI5Y2E0M2EzYjAyMGY5NWZiNDg3MDcxYTc4OWJkMWEwZTAwIiwidGFnIjoiIn0%3D; expires=Sun, 20-Jul-2025 08:36:25 GMT; path=/XSRF-TOKEN=eyJpdiI6IlJ4WTJiOTdUYXg2N0k5QWk0eDI0Smc9PSIsInZhbHVlIjoib1JvN0Nmc2RtRDkycFhPcHV1M1JWU0hjRGpVNWU3VTc5TG90T0hpU3NOdk94YVBDZUhJVEtDT1BtbTAvbmpzUUFmVVRzT" 1 => "blmis_session=eyJpdiI6InJsbG5rdjluQkNyZGtEbC9SeG5RcFE9PSIsInZhbHVlIjoiRXBXZVhwMHRYYmpuemd1N0V4TlVFckFWRzUyZUI0ckR6NkNXVDYvOW5kWTV2SCt0UVpNNHVuVWhvaXJ0MGlhMngxTTFUcGxHUExTQmx1Q1Q1RUxhZHJWb09hWVNrTUtJa2RxMG9hRXhWK2RUc2psYTdNQXJYWm13WnQ3aG9GdmciLCJtYWMiOiI2NDFhMGQ4ZjkzNjYyNzYyNzdjZjhmY2RkZTcwZWYzYmNiZmQ2Y2U1ODQ5ZDQyMDIxNTgyYThhYWIxOTBjNDJjIiwidGFnIjoiIn0%3D; expires=Sun, 20-Jul-2025 08:36:25 GMT; path=/; httponlyblmis_session=eyJpdiI6InJsbG5rdjluQkNyZGtEbC9SeG5RcFE9PSIsInZhbHVlIjoiRXBXZVhwMHRYYmpuemd1N0V4TlVFckFWRzUyZUI0ckR6NkNXVDYvOW5kWTV2SCt0UVpNNHVuVWhvaXJ0MGlhMngxTT" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "fa4b6vaRXbdgINDbYKXT1LVW160CUJ6afMaqTASs" "_previous" => array:1 [ "url" => "https://www.blmis.gov.bt/jobseeker_page/mispage" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]