Health medicine Jobs at Columbia University, Kagem Mining Limited, Mary Begg Health Services and other companies


Deadline of this Job: 26 August 2022
JOB DETAILS:
ICAP at Columbia University is an international, non-profit organization situated at the Columbia University in New York. ICAP is Empowering Health Around the World and works in over 30 countries, including Zambia. Together with our partners—Ministries of Health, large multilaterals, health care providers, and patients—we support comprehensive, person-centered HIV/TB services and high-performing health system strengthening initiatives that provide quality and affordable health care. And by enhancing health information systems, improving quality, and developing human resources for health, we build capacity and efficiency in the world’s most challenging, resource-limited settings.
ICAP seeks to recruit for the following positions in Zambia

Position Title: Regional Medical Advisors (05)
Reports to: Provincial Deputy Director
Location: L/stone, Choma, Mazabuka, Mongu & Senanga
Position Summary
Working under the guidance of the Provincial Deputy Director, the Regional Medical Advisor will support activities to strengthen HIV prevention, care and treatment in assigned districts and regions in Southern and Western provinces in Zambia.

Major Responsibilities
• Coordinate the HIV/TB mentorship activities at DHO and assigned region in line with the 95:95:95 targets.
• Lead the district or regional data reviews for each step of the HIV testing and treatment with DHO and Regional/zonal and identify service delivery and stock management gaps and remedial measures
• Monitor achievement of district level targets and discuss results and remediation measures.
• Provide technical assistance to District and Regional/zonal staff to strengthen innovations to improve HIV case finding with a focus on index case strategy implementation including KYCHS
• Mentorship to DHO/Regions/Zones to improve district viral load coverage by supporting providers to request viral load test whenever indicated and real time update in clients’ records and interpretation of results.
• Coordinate the implementation of all related prevention services including cervical cancer screening, VMMC, PrEP etc.
• Perform other related duties as directed by the supervisor.

Qualifications
• Degree in Medicine.
• Master’s degree in public health a plus

Experience And Skills Required
• At least 3 years’ demonstrated experience in HIV/TB clinical management
• Trained in both adult and paediatrics ART
• Supervisory and mentorship experience in HIV/TB services at hospital level.
• Ability to provide mentorship to medical and clinical officers and other HIV/TB service staff
• Proven experience in coordinating HIV community services such as demand creation, HIV case identification and community interventions in support of retention of recipients of care
• A team player with ability to support coordination of HIV/TB services at district, facility and community level.
• Computer skills: Microsoft word, Excel, PowerPoint.
• Experience working in donor funded projects a Plus
• Fluent English oral and written communication skills


Deadline of this Job: 28 August 2022
JOB DETAILS:
Clinical Officer
Reports to: Manager Clinical Services.

Job Purpose: To assist the Manager Clinical Services to run the dayto-day operations of the mine clinic efficiently and effectively.

Principle Accountabilities
• Able to take comprehensive medical history, conduct thorough physical examination and order appropriate complementary investigations.
• Keep medical/general records related to the running of the clinic with confidentiality.
• Diagnose and manage all stages of illness in accordance with relevant standard treatment guidelines and other national protocol’s ability to perform minor surgical procedures.
• Counsel patients on various matters such as HIV/AIDS, excessive beer drinking, smoking and communicable diseases as they relate to good health to ensure highest standard of health at the mine site.
• Ability to plan and implement health promotion activities and carrying out Information, education, and communication (I.E.C) on health matters tor employees.
• Gather, analyse medical data, and timely generate reports to management.
• Prepares and participates in the preparation of work plans to ensure smooth running of the clinic

Qualifications & Experience
• Grade 12 certificate.
• Degree/Diploma in Clinical Services/Medicine
• At least 1-2 years’ nursing experience in a busy mining environment and ability to work under pressure.
• Training in basic life support is an added advantage.
• Practical experience in any medical related software application.
• Must be fully registered with HPCZ and hold a current practicing certificate
• Good computer skills.
• Excellent analytical and evaluation skills.
• Good command of both oral and written English for effective communication.
• Possession of good leadership skills and team player.
• Ability to work with minimum supervision.
• Excellent knowledge of the current labour regulations.
The company provides single status accommodation at the mine site.


Deadline of this Job: 25 August 2022
JOB DETAILS:
Role Description
• At MBHS, an occupational health (OH) Nurse works closely with the occupational health doctors and other occupational health nurses and technicians to provide high quality care to all clients at MBHS. They are often the first point of contact for all clients, visitors and health care professionals accessing MBHS OH services.
• Our occupational health nurse conducts herself/himself in a professional manner and always demonstrates good customer service towards all our clients, visitors, health professionals and MBHS employees.
• All MBHS OH Nurses must provide client-centred, compassionate, competent and quality care. They must adhere to the MBHS’s and General Nursing Council of Zambia’s Code of Conduct and must practice safely and ethically at all times according to the MBHS standards.

Key Responsibilities
• Ensure administrative duties such as registering clients, entering information on the electronic health record system are done timely and correctly.
• Assist clients with completing documentation as required for the occupational health examinations.
• Triage clients by checking vital signs (pulse, blood pressure, temperature and oxygen saturation) and conducting weight and height checks and assisting in conducting musculoskeletal screening tests.
• Prepare and tidy doctor’s consultation room before/after clients as required.
• Must demonstrate competence in effectively using the spirometer, audiometer and vision equipment and ability to understand the parameters of abnormal readings.
• Inform the OH doctor immediately of any abnormal test results.
• Ensure all OH screening results are signed, dated and filed in the correct client’s medical folder.
• Promote high quality screening by following respective procedures as directed by the OH doctor.
• Act as a chaperone for female clients when requested.
• Maintain hygienic and safe work environments in compliance with the department’s Standard Operating Procedures (SOPs).
• Attend clinic and department meetings when scheduled and raise any issues with regards to improvement in OH service or client care
• Ensure that OH client files are complete and have necessary documentation present – like consent forms, pre-employment, periodic and exit screening & examination, laboratory results, and any diagnostic testing, any fitness to work certificates and injury on duty reports and follow-up assessments – before being presented to the OH doctor.
• Ensure that all follow up visits for client assessments are carried out in a timely manner.
• Conduct daily calibration of spirometers and sign and file appropriately when required and trained to do so.
• Carry out weekly biological calibration of audiometers, and sign and file appropriately when required and trained to do.
• Carry out daily listening checks of audiometers and the background noise checks in the booths when required and trained accordingly.
• Carry out otoscopic examinations prior to audiometry testing.
• Continually demonstrate adherence to the Infection Control Policy, especially maintaining proper hand washing technique. Use and maintain correct personal protective equipment (PPE) where appropriate.
• Support and/or mentor new members of staff as directed by the Unit Leader/OHNP/CMO.
• Promote good health and client-centred care through patient education on recognising occupational hazards.
• Attend mandatory role specific in-house training, as directed by the unit leader or training coordinator.
• Comply with MBHS sickness and absenteeism policy.
• Comply with the MBHS uniform policy.
• Comply with all legal regulations set out by NMCZ or Health Professional Council of Zambia

Educational Requirements
• Must have a current RN qualification (essential) following completion of Diploma in Nursing (essential)
• Must have a current practice license from the NMCZ.
• Training in occupational health nursing with certification would be an asset.
• Training in Audiometry, Spirometry and Vision testing with appropriate certification will be an asset
• Compute literacy a must
• 4 year General Nursing experience

Other Jobs
Deadline of this Job: 16 September 2022

Deadline of this Job: 31 August 2022

Deadline of this Job: 26 August 2022

Deadline of this Job: 28 August 2022

Deadline of this Job: 26 August 2022
60.606MBMemory Usage463msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.29-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "fd7ee823cc461b61d02831b477cfa13a" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1747131108 "last" => 1747131108...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
jsjobcur_usr
0
jsjobconfig_dft
array:171 [ "actk" => "0" "applybuttonredirecturl" => "http://www.greatzambiajobs.com/how-to-app...
JSItemid
"190"
  • afterLoad (4.12MB) (27.9ms)
  • afterInitialise (11.13MB) (87.75ms)
  • afterRoute (4.61MB) (35.42ms)
  • beforeRenderComponent com_content (29.19KB) (308μs)
  • Before Access::preloadComponents (all components) (371.44KB) (4.08ms)
  • After Access::preloadComponents (all components) (134.4KB) (1.24ms)
  • Before Access::preloadPermissions (com_content) (4.26KB) (21μs)
  • After Access::preloadPermissions (com_content) (1.16MB) (4.62ms)
  • Before Access::getAssetRules (id:1474 name:com_content.article.1029) (66.8KB) (102μs)
  • After Access::getAssetRules (id:1474 name:com_content.article.1029) (26.84KB) (413μs)
  • afterRenderComponent com_content (2.32MB) (34.02ms)
  • Before Access::getAssetRules (id:1 name:root.1) (1MB) (8.92ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.95KB) (30μs)
  • afterDispatch (1.73MB) (17.9ms)
  • afterRender (29.41MB) (240ms)
  • 1 x afterRender (29.41MB) (51.77%)
    239.92ms
    1 x afterInitialise (11.13MB) (18.94%)
    87.75ms
    1 x afterRoute (4.61MB) (7.64%)
    35.42ms
    1 x afterRenderComponent com_content (2.32MB) (7.34%)
    34.02ms
    1 x afterLoad (4.12MB) (6.02%)
    27.90ms
    1 x afterDispatch (1.73MB) (3.86%)
    17.90ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (1MB) (1.93%)
    8.92ms
    1 x After Access::preloadPermissions (com_content) (1.16MB) (1%)
    4.62ms
    1 x Before Access::preloadComponents (all components) (371.44KB) (0.88%)
    4.08ms
    1 x After Access::preloadComponents (all components) (134.4KB) (0.27%)
    1.24ms
    1 x After Access::getAssetRules (id:1474 name:com_content.article.1029) (26.84KB) (0.09%)
    413μs
    1 x beforeRenderComponent com_content (29.19KB) (0.07%)
    308μs
    1 x Before Access::getAssetRules (id:1474 name:com_content.article.1029) (66.8KB) (0.02%)
    102μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.95KB) (0.01%)
    30μs
    1 x Before Access::preloadPermissions (com_content) (4.26KB) (0%)
    21μs
64 statements were executed, 9 of which were duplicates, 55 unique30.6ms470.95KB
  • SELECT @@SESSION.sql_mode;46μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?182μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1125μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `icop0_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id100μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`102μs1.55KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `icop0_usergroups` AS `a` LEFT JOIN `icop0_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest152μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'84μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`240μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'135μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config140μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'113μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'82μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'79μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'77μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1029-health-medicine-jobs-at-columbia-university-kagem-mining-limited-mary-begg-health-services-and-other-companies%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F1029-health-medicine-jobs-at-columbia-university-kagem-mining-limited-mary-begg-health-services-and-other-companies%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1029-health-medicine-jobs-at-columbia-university-kagem-mining-limited-mary-begg-health-services-and-other-companies%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC229μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`339μs5.11KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1029-health-medicine-jobs-at-columbia-university-kagem-mining-limited-mary-begg-health-services-and-other-companies%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F1029-health-medicine-jobs-at-columbia-university-kagem-mining-limited-mary-begg-health-services-and-other-companies%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F1029-health-medicine-jobs-at-columbia-university-kagem-mining-limited-mary-begg-health-services-and-other-companies%2F')=1) OR `list_var` LIKE '%com_content%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC321μs6.8KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM icop0_template_styles AS s WHERE s.client_id = 0 AND s.template = 'jl_education_pro' ORDER BY s.id239μs1.2KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `icop0_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50)745μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `icop0_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 02.18ms129.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `icop0_content`1.28ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `icop0_content` SET `hits` = (`hits` + 1) WHERE `id` = '1029'380μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `icop0_content` AS `a` INNER JOIN `icop0_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `icop0_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `icop0_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `icop0_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `icop0_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)474μs56.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`344μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `icop0_contentitem_tag_map` AS `m` INNER JOIN `icop0_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3)414μs5.27KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id129μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id93μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`399μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'250μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'369μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'266μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering199μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0104μs11.9KB/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22115μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24135μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2891μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38168μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 4091μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `icop0_menu_types` AS `a` WHERE `a`.`client_id` = 0134μs1.19KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft417μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/related-jobs/1029-health-medicine-jobs-at-columbia-university-kagem-mining-limited-mary-begg-health-services-and-other-companies' AND `published` = 1194μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/related-jobs/1029-health-medicine-jobs-at-columbia-university-kagem-mining-limited-mary-begg-health-services-and-other-companies'85μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration341μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'149μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field177μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'131μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `icop0_scheduler_tasks` AS `a` WHERE `a`.`state` = 1154μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'213μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`323μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'108μs912B/libraries/src/Table/Table.php:755Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `icop0_content` AS `a` INNER JOIN `icop0_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `icop0_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `icop0_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `icop0_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `icop0_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)438μs56.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`401μs5.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM icop0_fields AS a LEFT JOIN `icop0_languages` AS l ON l.lang_code = a.language LEFT JOIN icop0_users AS uc ON uc.id=a.checked_out LEFT JOIN icop0_viewlevels AS ag ON ag.id = a.access LEFT JOIN icop0_users AS ua ON ua.id = a.created_user_id LEFT JOIN icop0_fields_groups AS g ON g.id = a.group_id LEFT JOIN `icop0_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7,:preparedArray8)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC772μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'content' AND a.appview IN ('article','*') ORDER BY a.id desc178μs2.05KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc175μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/related-jobs/1029-health-medicine-jobs-at-columbia-university-kagem-mining-limited-mary-begg-health-services-and-other-companies'174μs1.05KB/plugins/system/jmap/jmap.php:1135Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `icop0_jmap_text_replacements` WHERE `published` = 1145μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"446μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.13ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin132μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin126μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM icop0_usergroups AS `groups`228μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?171μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?12.65ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy