Assistant Procurement Officer job at UNHCR
Website :
523 Days Ago
Linkedid Twitter Share on facebook

Vacancy title:
Assistant Procurement Officer

[ Type: FULL TIME , Industry: Nonprofit, and NGO , Category: Transportation & Logistics ]

Jobs at:

UNHCR

Deadline of this Job:
Monday, November 27 2023 

Duty Station:
Within Zambia , Lusaka, South - Central Africa

Summary
Date Posted: Monday, November 13 2023, Base Salary: Not Disclosed

Similar Jobs in Zambia
Learn more about UNHCR
UNHCR jobs in Zambia

JOB DETAILS:
Organizational Setting and Work Relationships
The position may be located at Headquarters (within DESS), in a Regional Bureau or in a Country Office. The incumbent normally reports to the Supply Officer or Procurement Officer. In the Country Operation s/he normally reports to the Head of Office, to the Representative or the Deputy Representative (Operations) at the same level as the Programme and Administration functions. S/he directly supervises general service staff.
The Assistant Procurement Officer conducts and/or support the procurement activities in a timely and cost-effective manner in conformity with UN/UNHCR¿s procurement rules and regulations. In Bureaus and Country Operations, s/he maintains regular contact with other UN agencies, NGOs, government partners and commercial contractors in the area of responsibility to facilitate all procurement activities. As and when required, the incumbent will provide procurement functional advice to other units under the respective area of responsibility and assist in drafting (frame) agreements.
The incumbent will assist in the development of complex goods and services contracts, will manage vendors, define clear terms and conditions and ensure best value for money. S/he will also assist the Head of Unit, Field Procurement in identifying and managing associated risks. S/he takes part in the development of effective procurement strategy, in cooperation with requesting units, leveraging sustainability, social, economic, environmental and/or climate considerations in support of SDG12. S/he reviews and/or drafts procurement cases to be presented to the HQ's Committee on Contracts and takes part in the development of effective procurement strategy, in cooperation with requesting units.
As and when required, the incumbent will provide procurement functional advice to UNHCR organizational units under the respective area of responsibility and assist in drafting frame agreements, some of them of complex nature, and in providing inputs to the upgrade of operating systems/tools as well as on procurement policies and procedures.
The Assistant Procurement Officer maintains impartial, ethical and customer-oriented relations with suppliers and Partner organizations; exchanges information with counterparts in other UN agencies, and International Organisations within the limits established by UN /UNHCR Procurements Rules and assists with joint procurement actions if, as and whenever necessary.

All UNHCR staff members are accountable to perform their duties as reflected in their job description. They do so within their delegated authorities, in line with the regulatory framework of UNHCR which includes the UN Charter, UN Staff Regulations and Rules, UNHCR Policies and Administrative Instructions as well as relevant accountability frameworks. In addition, staff members are required to discharge their responsibilities in a manner consistent with the core, functional, cross-functional and managerial competencies and UNHCR¿s core values of professionalism, integrity and respect for diversity.

Duties
- Support the procurement process to ensure timely, cost-effective and adequate delivery of commodities and services to support operational needs.
- Conduct market surveys, identify, assess and select potential vendors.
- Ensure high quality standards for goods and services procured by UNHCR by developing and maintaining specific internal control and self-evaluation criteria/procedures.
- Apply UNHCR's sourcing and procurement strategy when planning for purchase of important commodities and services.
- Review the requisitions, specifications and required delivery.
- Prepare the tendering documents (Request for Proposals, terms of references) ensuring that the bidding process is in line with the established UN/UNHCR Financial Rules and Procedures and procurement regulations and guidelines.
- Analyse bids, prepare/review financial evaluation and coordinate the entire evaluation process.
- Manage negotiations with suppliers, develop and prepare contracts for procurement of goods and services by defining terms and conditions, ensuring best quality/delivery terms and pro-active management of associated risks.
- Develop relevant contacts and build constructive relations with UN agencies, UNHCR Partners, government authorities and other partners as applicable.
- Manage the vendor related processes including identification, assessment and selection of vendors based on their capability for delivering commodities and services. Ensure vendor and item master databases are up to date.
- Support tender processes and manage the preparation of proposals for award of contracts to the relevant Committee on Contracts.
- Conduct periodic contract performance reviews in conjunction with requesting units and provide feedback to requestors and vendors.
- Guide the offices should they need additional office space or extensions to their office leases, lease hold improvements or other construction. Carry out the procurement aspect of the establishment of office leases or extensions.
- Coordinate with CBI stakeholders the design and implementation of the market assessment and market monitoring to determine if CBI is option. Carry out the procurement action to contract Financial Service Providers (FSP).
- Advise operations and colleagues on partner procurement multifunctional team role and Partner Procurement Qualification processes and requirements.
- Identify partners for supply chain projects based on objectives, priorities, strengths and resources of the UNHCR Partner and/or contractor, according to criteria consistent with UNHCR rules and regulations.
- Ensure accurate and comprehensive records on supply activities and provide timely reports and updates both periodically and on request.
- Provide guidance to Field Operation on a variety of procurement matters.
- Liaise, as appropriate, with the requesting units at HQ and in the field, to provide procurement advice on relevant policies and procedures and clarify terms of reference/specifications.
- Ensure effective information flow in the supply chain.
- Disseminate and monitor compliance with UNHCR's global policies, standards and guidance on supply chain management.
- Implement practical projects to improve supply performance that has clear objectives, timescales, tasks and resources defined and monitors the project execution against the plans and takes action when actual implementation deviates from plans.
- Manage staff performance and coordinate procurement activities ensuring broad understanding and adherence to the relevant and prevailing procurement rules and procedures.
- Perform any other responsibility relevant for this function.

In the Regional Bureaux
- Support Country Operations in implementing procurement strategies based on requirements, risks and emergency context.
- Assist country operations in achieving full compliance with rules & regulations in all Procurement activities.
- Track global Procurement KPIs for the region and assist in preparation of regional ones, as required.
- Track the progress of specific operations and provide guidance that ensures timely implementation.
- Monitor all periodic and ad-hoc procurement exercises set by Regional Bureau or HQ and provide relevant reports to senior managers.
- Assist Country Operations in MSRP management within the AoR.
- Coach and advise clients and procurement colleagues as/if requested.
- Act as first case clearer for RCC submissions by interacting with the CO whilst preparing a first draft of Statement of Recommendation for secondary review purpose.
- Ensure timely green light processing and customs clearance of consignments.
- Facilitate training of procurement staff and assist in coaching and advising individuals on procurement matters as requested.
- Support the analysis of country financial reports and work with the senior staff to address areas relating to procurement aspects of operations.
- Support the country needs assessment plans and assist in combining them into regional procurement plans and monitor their timely implementation and changes based on operational needs.
- Support the work of the Regional Contracts Committee (RCC) through compiling and reviewing documents for RCC meetings, taking minutes, communicating decisions.

In the Country Operations
- Ensure effective support to procurement activities.
- Procure goods and services in accordance with UNHCR rules and regulations as well as country-specific SOPs.
- Coordinate procurement activities of UNHCR Partners and/or contractors within the AoR, ensure that they understand and adhere to relevant UNHCR rules and procedures.
- Take part in vendor evaluation and preparation of submissions to relevant CoCs.
- Organize training sessions and workshops.
- Ensure timely green light processing and customs clearance of consignments.
- Resolve difficulties in the local supply chain by finding solutions to problems and bottlenecks, and provide regular reports on supply chain activities, the status of requests and the availability of items in the supply chain.
- Depending on the size of the Operations, review and clear procurement cases for the relevant procurement authority.
- Perform other Supply related duties as required.

Minimum Qualifications
Education & Professional Work Experience
Years of Experience / Degree Level
For P1/NOA - 1 year relevant experience with Undergraduate degree; or no experience with Graduate degree; or no experience with Doctorate degree

Field(s) of Education
Business Administration, Engineering, Logistics,
Supply Chain Management, International Commerce or other relevant field.
(Field(s) of Education marked with an asterisk* are essential)

Certificates and/or Licenses
Certificate from Chartered Institute of Purchasing & Supplies, e.g. CFIPS, CMIPS, MCIPS;
(Certificates and Licenses marked with an asterisk* are essential)

Relevant Job Experience
Essential
Proficient knowledge in effective and efficient procurement of goods and services, with proven experience at previous work positions, preferably UN. Good working knowledge and experience in handling contract issues in the context of UN policies and standards. Experience in contract negotiations; ability to provide technical guidance to subordinate staff; ability to plan and organise work assignments, often under close deadlines. Proven ability to deal with multiple tasks with speed, in a courteous and service-oriented manner. A combination of good technical and effective soft management skills including the ability to effectively negotiate and communicate is a requirement. Good understanding on applying International Commercial Terms (INCOTERMS), experience in international transport arrangements by air, sea and land including basic understanding on customs clearance formalities, cargo specific requirements (i.e. dangerous goods, temperature-controlled goods, etc) and basic packaging / palletization requirements.
Desirable
Experience and working knowledge of ERP systems, ideally of UNHCR¿s MSRP Supply Chain Module would be an advantage. Strong interpersonal and negotiation skills to deal with persons of different cultural and educational backgrounds. Technical knowledge of types of services, supplies and goods purchased by UNHCR for Headquarters, Regional and Field Offices would be an advantage. Relevant training, such as CIPS, or other public procurement trainings. Knowledge of UN and UNHCR Financial Regulations and Rules relating to procurement and UNHCR Chapter 8.
Other UN procurement and logistics training ¿ such as IAPSO and UNPD.

Functional Skills
SC-UN/UNHCR Procurement Rules and Procedures
IT-Computer Literacy
SC-PeopleSoft Supply Chain Management
SC-Supply Planning
SC-Customs clearance
SC-Logistics
SC-Warehouse Management
(Functional Skills marked with an asterisk* are essential)

Language Requirements
For International Professional and Field Service jobs: Knowledge of English and UN working language of the duty station if not English.
For National Professional jobs: Knowledge of English and UN working language of the duty station if not English and local language.
For General Service jobs: Knowledge of English and/or UN working language of the duty station if not English.

Education Requirement: No Requirements

Job Experience: No Requirements

Work Hours: 8


Experience in Months:

Level of Education:

Job application procedure
• Interested and qualified? Click here to apply

All Jobs

QUICK ALERT SUBSCRIPTION

Job Info
Job Category: Logistics/ Transportation/ Procurement jobs in Zambia
Job Type: Full-time
Deadline of this Job: Monday, November 27 2023
Duty Station: Lusaka
Posted: 13-11-2023
No of Jobs: 1
Start Publishing: 13-11-2023
Stop Publishing (Put date of 2030): 13-11-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60.041MBMemory Usage556msRequest 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
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "2b85d7294164406a2231ed90d50889d7" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 3 "timer" => array:3 [ "start" => 1745099533 "last" => 1745099534...
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.13ms)
  • afterInitialise (11.13MB) (86.42ms)
  • afterRoute (5.06MB) (36.84ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (271μs)
  • afterRenderComponent com_jsjobs (3.14MB) (35.94ms)
  • Before Access::preloadComponents (all components) (243.64KB) (4.75ms)
  • After Access::preloadComponents (all components) (132.72KB) (996μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (17μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (290μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.59MB) (112ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (101ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (9μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (357μs)
  • afterDispatch (83.54KB) (138μs)
  • afterRender (13.81MB) (156ms)
  • 1 x afterRender (13.81MB) (27.96%)
    155.52ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.59MB) (20.18%)
    112.25ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (18.13%)
    100.83ms
    1 x afterInitialise (11.13MB) (15.54%)
    86.42ms
    1 x afterRoute (5.06MB) (6.62%)
    36.84ms
    1 x afterRenderComponent com_jsjobs (3.14MB) (6.46%)
    35.94ms
    1 x afterLoad (4.12MB) (3.62%)
    20.13ms
    1 x Before Access::preloadComponents (all components) (243.64KB) (0.85%)
    4.75ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.18%)
    996μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.06%)
    357μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.05%)
    290μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.05%)
    271μs
    1 x afterDispatch (83.54KB) (0.02%)
    138μ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%)
    9μs
90 statements were executed, 23 of which were duplicates, 67 unique17.34ms328.23KB
  • SELECT @@SESSION.sql_mode;53μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?98μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 194μ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_id93μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`125μ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` = :guest114μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'115μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`88μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'183μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config137μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'94μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'64μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'60μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'54μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Assistant-Procurement-Officer-job-at-UNHCR-52729%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Assistant-Procurement-Officer-job-at-UNHCR-52729%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Assistant-Procurement-Officer-job-at-UNHCR-52729%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC241μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Assistant-Procurement-Officer-job-at-UNHCR-52729%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Assistant-Procurement-Officer-job-at-UNHCR-52729%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Assistant-Procurement-Officer-job-at-UNHCR-52729%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC257μ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.id123μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'287μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'202μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'234μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'253μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'222μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'69μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'67μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'267μ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 = 52729599μs60.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'217μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 52729331μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'184μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering282μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'210μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'207μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering240μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'207μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'226μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'69μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'64μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'272μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'206μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'63μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'54μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2153μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2128μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'502μ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'526μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2181μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2147μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2126μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'233μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'335μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'125μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering168μ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)661μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0106μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2292μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24103μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2890μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38127μs81.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39158μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40163μ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` = 095μ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.lft399μ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.lft215μ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.lft443μ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-Assistant-Procurement-Officer-job-at-UNHCR-52729' AND `published` = 1252μs9.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Assistant-Procurement-Officer-job-at-UNHCR-52729'73μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration291μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'106μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field97μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'83μ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` = 1159μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'172μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`277μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'66μ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 desc214μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`399μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid110μ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` = :muserid220μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Assistant-Procurement-Officer-job-at-UNHCR-52729'79μ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` = 177μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"380μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin143μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin95μ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`102μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'77μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'244μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 176962μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?106μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?150μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy