Terms of reference for a Feasibiity Study – Vision Zambia: Strengthening Eye Health Services for Sustainable Community Wellbeing tender at Christian Blind Mission
Website :
327 Days Ago
Linkedid Twitter Share on facebook

Project Summary

Planned Project: Vision Zambia: Strengthening Eye Health Services for Sustainable Community Wellbeing
Country/Region: Zambia
Partner Organisation: Lusaka Eye Hospital
Planned Project start date: 01.06.2025 – 31.12.2029
Study Purpose: The aim of the requested consultancy is to assess the feasibility of a proposed project of SDL and Lusaka Eye Hospital and to systematically check the extent to which the project approach can plausibly achieve the planned changes under the existing framework conditions.
Commissioning organisation/contact person: Christian Blind Mission (CBM) Zambia/ SDL – German Lions Foundation.
Contact Person: Slinganiso Homela (Country Program Manager)
Study duration: 30 days

1. Description of the project

The project in Zambia aims to enhance eye health services through capacity building, outreach, and sustainable planning. Activities include training healthcare personnel, strengthening referral systems, and implementing telemedicine for remote consultations. Regular screenings in schools and communities will be supported by awareness campaigns and advocacy efforts. Emphasis is placed on preventive measures and healthcare-seeking behavior, with a focus on sustainability through rigorous planning and monitoring. CBM will provide technical guidance and oversee project implementation.

2. Purpose of the feasibility study

The project is currently in its development phase and SDL is seeking to recruit a consultant to conduct a feasibility study to assess the feasibility of the proposed project and systematically check the extent to which the project approach can plausibly achieve the planned changes under the existing framework conditions.
It should provide SDL and its partners with sufficient information on the project opportunities and risks as well as concrete recommendations for improving the project concept. The study will be submitted to BMZ together with the project proposal.

The study should provide an assessment on the following:

  • Situation and problem analysis at macro, meso, micro level
  • Assessment of the local project executing agency in the partner country
  • Analysis of target groups and other actors at macro, meso and micro level
    Based on this, the study should assess:
  • The feasibility of the project concept against the OECD/DAC criteria of relevance, coherence, efficiency, effectiveness, potential impact, and sustainability prospects.
  • In addition, the study will assess the inclusiveness of the project, i.e. the active participation of persons with disabilities and their representative organisations in all aspects of the project.

This assessment will be made based on a first draft effect chain and indicators, description of activities and a draft budget to be made available by SDL in cooperation with CBM and the partner organization.

3. Lead questions of the feasibility study

The feasibility study aims to assess the eye health project’s viability across macro, meso, and micro levels:

  • At the macro level, it evaluates national policies, budget allocation, and social protection measures.
  • Meso-level analysis focuses on the readiness of district health systems and collaboration with regional authorities.
  • Micro-level assessment delves into community eye health issues, cultural beliefs, logistical challenges, and stakeholder engagement. Organizational capacity, coordination strategies, target group engagement, and project design are thoroughly examined for relevance, coherence, effectiveness, efficiency, impact, and sustainability.
  • Finally, the study addresses DAC criteria, ensuring alignment with developmental objectives, human rights principles, effectiveness of intervention methods, economic use of resources, and long-term sustainability of outcomes.

4. Recommendations

Based on the main findings and the assessment according to the DAC criteria, the consultant should provide concrete recommendations for the project concept. These recommendations should be within the thematic and financial scope of what the project aims to achieve. They should be practical and implementable.

In particular, the following should be addressed:

  • Recommendations on any components, measures, approaches that might be missing in the project concept.
  • Recommendations regarding any components or measures where potential negative effects have been identified.
  • Recommendations on how to strengthen / increase viability of the cause-effect relationship of the project.
  • Recommendations on the impact matrix of the project:
    – Anything that can strengthen the effect chain of the project.
    – Recommendations on indicators demonstrating progress.

5. Geographical Scope

The project is in the Southern and Lusaka Provinces of Zambia, focusing on enhancing eye health care services in these regions.

6 Methodology

Independent of the methods to be used, there are mandatory mechanisms that must be adhered to during the entire process:

  • Participatory and inclusive
  • Safeguarding of children and adults at risk
  • Data Disaggregation (gender/age/disability)
  • Data Security and privacy (informed consent)
  • Cultural sensitivity

7. Application and selection procedure

7.1 Skills and Experience of Study Team

The consultant should have the following attributes among others:

  • Academic Degree and extensive expertise and experience in eye health work, project management, disability inclusive development.
  • Proven record of carrying out similar studies in Zambia and/or the region
  • Track record in designing and conducting quantitative and qualitative studies.
  • Experience in undertaking research with remote and marginalized communities.
  • Knowledge of international instruments and national statutes for persons with disabilities.
  • Excellent interpersonal and communication skills including ability to facilitate and work in a multidisciplinary team.
  • Strong analytical skills and ability to clearly synthesise and present findings.
  • Ability to draw practical conclusions and to prepare well‐written reports in a timely manner and availability during the proposed period.

Safeguarding Policy: As a condition of entering into a consultancy agreement the evaluators must sign the CBM’s or the partner organisation’s Safeguarding Policy and abide by the terms and conditions thereof.

7.2 Expression of Interest

The consultant is expected to submit both the technical and financial proposal including a description of the consultancy firm, CV of suggested team members, an outline of the understanding of these TORs and suggested methodology, and a detailed work plan for the entire assignment. A detailed budget for the expected assignment shall include all costs expected to conduct a disability inclusive and participatory study, and taxes according to the rules and regulations of the consultants’ local tax authorities.
SDL reserves the right to terminate the contract in case the agreed consultant/s are unavailable at the start or during the assignment.

All expressions of interest should be submitted by the 14th of June, 2024 via E-mail to: procurement.zambia@cbm.org.

Job Info
Job Category: Tenders in Zambia
Job Type: Full-time
Deadline of this Job: Wednesday, June 19 2024
Duty Station: Lusaka
Posted: 05-06-2024
No of Jobs: 1
Start Publishing: 05-06-2024
Stop Publishing (Put date of 2030): 05-06-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
59.935MBMemory Usage392msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.28-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:63 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1745861091 "last" => 1745861091...
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) (20.68ms)
  • afterInitialise (11.09MB) (61.26ms)
  • afterRoute (5.03MB) (24.61ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (155μs)
  • afterRenderComponent com_jsjobs (3.14MB) (27.52ms)
  • Before Access::preloadComponents (all components) (239.64KB) (5.94ms)
  • After Access::preloadComponents (all components) (132.72KB) (953μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (17μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (250μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.62MB) (64.46ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (52.9ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (4μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (277μs)
  • afterDispatch (79.29KB) (100μs)
  • afterRender (13.77MB) (132ms)
  • 1 x afterRender (13.77MB) (33.68%)
    132.14ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.62MB) (16.43%)
    64.46ms
    1 x afterInitialise (11.09MB) (15.61%)
    61.26ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (13.48%)
    52.90ms
    1 x afterRenderComponent com_jsjobs (3.14MB) (7.01%)
    27.52ms
    1 x afterRoute (5.03MB) (6.27%)
    24.61ms
    1 x afterLoad (4.12MB) (5.27%)
    20.68ms
    1 x Before Access::preloadComponents (all components) (239.64KB) (1.51%)
    5.94ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.24%)
    953μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.07%)
    277μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    250μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    155μs
    1 x afterDispatch (79.29KB) (0.03%)
    100μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    17μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    4μs
90 statements were executed, 23 of which were duplicates, 67 unique15.38ms304.2KB
  • SELECT @@SESSION.sql_mode;43μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?74μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 173μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `icop0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)231μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`73μs1.59KB/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` = :guest89μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'53μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`82μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'171μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config123μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'98μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'59μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'59μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'57μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-reference-for-a-Feasibiity-Study-%25e2%2580%2593-Vision-Zambia%3A-Strengthening-Eye-Health-Services-for-Sustainable-Community-Wellbeing-tender-at-Christian-Blind-Mission-61022%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Terms-of-reference-for-a-Feasibiity-Study-%25e2%2580%2593-Vision-Zambia%3A-Strengthening-Eye-Health-Services-for-Sustainable-Community-Wellbeing-tender-at-Christian-Blind-Mission-61022%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-reference-for-a-Feasibiity-Study-%25e2%2580%2593-Vision-Zambia%3A-Strengthening-Eye-Health-Services-for-Sustainable-Community-Wellbeing-tender-at-Christian-Blind-Mission-61022%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC195μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-reference-for-a-Feasibiity-Study-%25e2%2580%2593-Vision-Zambia%3A-Strengthening-Eye-Health-Services-for-Sustainable-Community-Wellbeing-tender-at-Christian-Blind-Mission-61022%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Terms-of-reference-for-a-Feasibiity-Study-%25e2%2580%2593-Vision-Zambia%3A-Strengthening-Eye-Health-Services-for-Sustainable-Community-Wellbeing-tender-at-Christian-Blind-Mission-61022%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-reference-for-a-Feasibiity-Study-%25e2%2580%2593-Vision-Zambia%3A-Strengthening-Eye-Health-Services-for-Sustainable-Community-Wellbeing-tender-at-Christian-Blind-Mission-61022%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC249μs4.25KB/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.id150μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'284μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'236μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'215μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'160μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'114μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'121μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'110μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'203μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT job.params,job.id,job.title,job.city,job.metakeywords,job.metadescription,job.description,job.created,job.isgoldjob,job.isfeaturedjob,job.gender , job.jobcategory,job.duration,job.hidesalaryrange,job.zipcode,job.iseducationminimax,job.degreetitle,job.isexperienceminimax , job.startpublishing,job.requiredtravel,job.noofjobs,job.hits,job.stoppublishing,job.video,job.prefferdskills,job.qualifications,job.agreement,job.experiencetext,job.longitude,job.latitude , cat.cat_title, subcat.title as subcategory, company.name as companyname, jobtype.title AS jobtypetitle , jobstatus.title AS jobstatustitle, shift.title as shifttitle, company.url as companywebsite, company.contactname AS companycontactname, company.contactemail AS companycontactemail,company.since AS companysince,company.logofilename AS companylogo , department.name AS departmentname, company.id companyid,job.educationminimax,job.experienceminimax , salaryfrom.rangestart AS salaryfrom, salaryto.rangestart AS salaryto, salarytype.title AS salarytype , education.title AS educationtitle ,mineducation.title AS mineducationtitle, maxeducation.title AS maxeducationtitle , experience.title AS experiencetitle ,minexperience.title AS minexperiencetitle, maxexperience.title AS maxexperiencetitle , currency.symbol,CONCAT(job.alias,'-',job.id) AS jobaliasid, agefrom.title AS agefromtitle, ageto.title AS agetotitle ,company.isgoldcompany,company.isfeaturedcompany ,CONCAT(company.alias,'-',company.id) AS companyaliasid, workpermit.name as workpermitcountry ,company.endgolddate,company.endfeatureddate, job.jobapplylink,job.joblink, careerlevel.title AS careerleveltitle ,(SELECT COUNT(id) FROM `icop0_js_job_jobapply` WHERE jobid = job.id) AS totalapply FROM `icop0_js_job_jobs` AS job JOIN `icop0_js_job_categories` AS cat ON job.jobcategory = cat.id JOIN `icop0_js_job_companies` AS company ON job.companyid = company.id JOIN `icop0_js_job_jobtypes` AS jobtype ON job.jobtype = jobtype.id LEFT JOIN `icop0_js_job_ages` AS agefrom ON agefrom.id = job.agefrom LEFT JOIN `icop0_js_job_ages` AS ageto ON ageto.id = job.ageto LEFT JOIN `icop0_js_job_subcategories` AS subcat ON job.subcategoryid = subcat.id LEFT JOIN `icop0_js_job_jobstatus` AS jobstatus ON job.jobstatus = jobstatus.id LEFT JOIN `icop0_js_job_departments` AS department ON job.departmentid = department.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryfrom ON job.salaryrangefrom = salaryfrom.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryto ON job.salaryrangeto = salaryto.id LEFT JOIN `icop0_js_job_salaryrangetypes` AS salarytype ON job.salaryrangetype = salarytype.id LEFT JOIN `icop0_js_job_heighesteducation` AS education ON job.educationid = education.id LEFT JOIN `icop0_js_job_heighesteducation` AS mineducation ON job.mineducationrange = mineducation.id LEFT JOIN `icop0_js_job_heighesteducation` AS maxeducation ON job.maxeducationrange = maxeducation.id LEFT JOIN `icop0_js_job_experiences` AS experience ON job.experienceid = experience.id LEFT JOIN `icop0_js_job_experiences` AS minexperience ON job.minexperiencerange = minexperience.id LEFT JOIN `icop0_js_job_experiences` AS maxexperience ON job.maxexperiencerange = maxexperience.id LEFT JOIN `icop0_js_job_shifts` AS shift ON job.shift = shift.id LEFT JOIN `icop0_js_job_currencies` AS currency ON currency.id = job.currencyid LEFT JOIN `icop0_js_job_countries` AS workpermit ON workpermit.id = job.workpermit LEFT JOIN `icop0_js_job_careerlevels` AS careerlevel ON job.careerlevel = careerlevel.id WHERE job.id = 61022650μs36.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'225μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 61022273μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'192μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering280μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'221μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'129μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering173μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'217μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'178μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'65μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'50μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'240μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'219μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'70μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'67μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2140μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2143μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'541μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield918' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'283μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2129μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2138μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 298μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'162μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'207μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'133μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering132μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • 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)480μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0130μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22106μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2497μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28188μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38143μs81.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39114μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 4078μ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` = 091μ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.lft370μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'distribution-channels' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft228μs1.17KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'categories-list' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft460μs2.3KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Terms-of-reference-for-a-Feasibiity-Study-–-Vision-Zambia:-Strengthening-Eye-Health-Services-for-Sustainable-Community-Wellbeing-tender-at-Christian-Blind-Mission-61022' AND `published` = 1135μs9.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Terms-of-reference-for-a-Feasibiity-Study-–-Vision-Zambia:-Strengthening-Eye-Health-Services-for-Sustainable-Community-Wellbeing-tender-at-Christian-Blind-Mission-61022'56μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration247μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'90μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field77μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'110μ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` = 1125μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'153μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`232μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'54μs912B/libraries/src/Table/Table.php:755Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc201μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`388μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid100μs4.41KBParams/libraries/src/Table/User.php:104Copy
  • SELECT `g`.`id`,`g`.`title` FROM `icop0_usergroups` AS `g` INNER JOIN `icop0_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid134μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Terms-of-reference-for-a-Feasibiity-Study-–-Vision-Zambia:-Strengthening-Eye-Health-Services-for-Sustainable-Community-Wellbeing-tender-at-Christian-Blind-Mission-61022'92μ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` = 146μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"226μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES708μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin65μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin50μ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`144μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'71μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'219μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 404256μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?89μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?354μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy