Terms of Reference – Clearing Agent Training Provider – Zambia tender at Center for International Private Enterprise / Global Alliance for Trade Facilitation
Website :
524 Days Ago
Linkedid Twitter Share on facebook

Terms of Reference – Clearing Agent Training Provider – Zambia

Center for International Private Enterprise / Global Alliance for Trade Facilitation

1. Background

The Global Alliance for Trade Facilitation is a public private partnership for trade-led growth, supporting governments in developing and least-developed countries in implementing the World Trade Organization’s Trade Facilitation Agreement. Alliance projects cut through red tape and end costly delays at borders by bringing together governments and businesses of all sizes as equal partners to deliver targeted trade reforms. The Alliance is led by the Center for International Private Enterprise, the International Chamber of Commerce, and the World Economic Forum, in cooperation with Gesellschaft für Internationale Zusammenarbeit (GIZ). It is funded by the governments of the United States, Canada, and Germany.

CIPE, on behalf of the Alliance, is implementing a project to modernize the framework for the licensing of customs clearing agents (customs brokers) in Zambia. Customs brokers serve as the intermediary between the Customs administration and traders; a well-functioning border relies heavily upon brokers’ knowledge, professionalism, and integrity. Both the private sector and the Government of Zambia have underscored substantial concerns about the current licensing system and its negative impacts on trade.

Under current practices, some brokers can obtain licenses without proper training, proof of knowledge of applicable customs laws and requirements, demonstrated compliance with customs requirements, or even demonstrating a physical address for their business. The private sector believes that brokers often lack sufficient knowledge and expertise in clearing goods because there is no proper customs brokers framework, training, and examination in place. The Government of Zambia has expressed concern about the lack of knowledge and understanding of importers’ and customs brokers’ duties and responsibilities.

The project is being implemented over three phases:

Improving the framework – During this phase, all elements of a modern customs broker framework have been assessed to create a clear roadmap for the creation of a licensing system that incorporates a training course and an examination.
Development of exam and training – It is anticipated that two major parts of the newly envisioned framework will be a training course and subsequent compulsory examination for existing and prospective brokers. This phase of the project has developed a training program in association with the Zambia Revenue Authority (ZRA), and the customs broker associations.
Implementation of training and examination – To ensure that all brokers can objectively demonstrate their ability to compliantly perform “Customs Business” on behalf of their clients. The ZRA, GATF and the 4 associations have introduced a Certified Customs Clearance Agent licensing process. As part of the process, it is a requirement that brokers/agents pass a specialized examination that will enable them to qualify for a license, hence the introduction of the Certified Customs Clearing (CCC) Agent Training Program. The program’s development is in line with the recommendations of various stakeholders including the ZRA, and the four Clearing and Forwarding Agents’ Associations. The training and examination will be new and compulsory activities introduced into an already established industry. Therefore, they will need to be gradually phased in. It is envisaged that the training will be partly based on E-learning but also have a practical, hands-on training component. To maximize accessibility, both training and examinations will need to be offered in various locations across Zambia. The examinations will be designed and set at the national level and qualified trainers and training institutions will be encouraged to offer the courses both through the e-learning platform and practical training
2. Assignment description

Recognizing the importance of well-trained custom clearing agents, the Zambian Government through ZRA and its allied partners including the four Clearing and Forwarding Agents’ Associations composed of the Zambia Customs and Forwarding Agents Association (ZCFAA), Zambia Freight Forwarders Association (ZAFFA), Customs Clearing and Freight Forwarding Agents Association (CCFFAA) and Southern Freight Forwarders Association (SFFA), aim to establish a training program that equips brokers with the necessary skills and knowledge to excel in this field. The purpose of the Certified Customs Clearing Agent (CCCA) Training Course is to enable prospective Customs Clearing Certified Agents (CCCAs) to successfully pass the Certified Custom Clearing Agents’ Examination. The course will build and refine skills in topics such as Classification, Valuation, and Rules of Origin so that industry professionals can objectively demonstrate their knowledge and expertise in customs clearance. This course is designed to teach complex information in a way that is simple and easy to learn. It is extremely user-focused and will give the student/brokers/customs agents the skills necessary to successfully pass the ZRA CCCA examination.

This training will build and enhance prospective Certified Customs Clearing Agent’s knowledge of Customs and related laws, regulations, and procedures, compulsory to render trustworthy and esteemed service to importers, exporters, and those in transit. The students will learn the fundamentals, principles, and application of ZRA law and regulations in a sensible, easy-to-understand presentation that makes learning easy. The training covers 85 – 90 percent of what will be on the examination. Despite at-home studying and preparation (Self Study) constituting most of the training program, this program includes a full blended in-person physical lessons Course at the beginning of the program integrated with an e-learning portal to provide support for this activity, and an In-person training (Practical Seminar) that will be four weeks in duration and delivered prior to examination. In addition, the training materials will be reflective of examination content.

The Global Alliance for Trade Facilitation in conjunction with the Zambia Revenue Authority and the Clearing and Forwarding Agents’ Associations invites qualified and suitable training institutions/organizations to submit a proposal to administer a Certified Custom Clearing Agent Training Program. We are seeking a qualified organization with experience in conducting professional training programs to synthesize and deliver this specialized training.

3. Scope of work

Eligible training institutions must allocate human resources to the development and delivery of CCCA training to undertake the following tasks:

Based on developed course modules, develop a comprehensive training curriculum that covers all relevant aspects of course modules, and best practices.
Design the training materials, including presentations, handouts, case studies, and assessments.
Deliver the training sessions in accordance with the agreed-upon schedule and format (e.g., in-person, online, or a combination).
Ensure active engagement and participation of trainees through interactive teaching methods, group discussions, and practical exercises.
In collaboration with ZRA and the 4 customs clearing, and freight forwarders associations conduct assessments and administer the examinations to measure trainees’ progress and knowledge acquisition.
Issue certificates to participants who successfully complete the training program and meet the specified requirements.
Provide post-training support, including access to additional resources or a helpline to address participant inquiries specific to Zambia’s customs regulations.
4. Deliverables

The program has targeted about 700 trainees. Selected training institution(s) should have the capacity to use the following modes of delivery to train trainees:

Mode of Delivery                                    Venue

Face-to-face meetings                                   On-campus

Assignments/Assessments.                          Off campus

Online support                                                Off campus

Self-study                                                          Off campus

5. Proposal requirements

Interested training institutions based in Zambia shall submit a comprehensive proposal addressing the following points:

Organization Profile: Provide an overview of your organization, including its background, experience in conducting training programs, and relevant certifications or accreditations.
Training Methodology/ technical proposal: Describe your approach to training delivery, including instructional techniques, training materials, and any interactive or practical components of the program.
Training Faculty: Introduce the trainers who will be responsible for delivering the program. Include their qualifications, experience in customs and trade, and any relevant certifications or industry affiliations.
Training Facilities and Resources: Detail the facilities and resources your organization can provide to support the training program, including classrooms, audiovisual equipment, and access to relevant reference materials.
Participant Evaluation: Describe the methodology you will employ to assess participants’ progress and knowledge acquisition throughout the program. Explain how you plan to issue the certification upon successful completion.
Budget/financial proposal: detailed cost of tuition per trainee and location.
6. Selection criteria

An accredited training institution either under TEVETA or the Higher Education Authority.
Demonstrated experience and knowledge in conducting professional training programs, particularly in the customs and trade field.
Qualifications and expertise of the trainers assigned to the program.
Adequacy and suitability of the training facilities and resources.
Competitiveness of the proposed budget.
CIPE may choose to partner with one or more institutions to undertake the assignment after a pre-award due diligence assessment.

7. Submission of proposals

Interested institutions shall send a technical and financial proposal to tradejobs@cipe.org with the subject: Training institution Zambia [Acronym of the training institution]. Deadline for submission: December 15, 2023.
Questions regarding this ToR may be sent to tradejobs@cipe.org no later November 30, 2023.

8. Pre- and post-proposal conference

Pre-proposal submission videoconference will be held with all interested training institutions to address any questions related to the assignment on December 08, 2023 at 9:00am EST or 3pm CAT. Those interested may request access link to the conference at tradejobs@cipe.org.

A summary of the topics discussed during the pre-proposal video conference and an anonymous compilation of questions (non-specific) raised by email along with responses will be distributed to all interested parties.

Pre-selected institutions meeting minimum qualification requirements will be contacted individually to present proposals in a post-proposal videoconference.

Job Info
Job Category: Tenders in Zambia
Job Type: Full-time
Deadline of this Job: Tuesday, December 05 2023
Duty Station: Lusaka
Posted: 21-11-2023
No of Jobs: 1
Start Publishing: 21-11-2023
Stop Publishing (Put date of 2030): 21-11-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60.025MBMemory Usage529msRequest 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" => "d1f5fdfd9f513dd4747baadbb34e289e" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1745862029 "last" => 1745862029...
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) (17.51ms)
  • afterInitialise (11.13MB) (78.34ms)
  • afterRoute (5.03MB) (32.97ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (212μs)
  • afterRenderComponent com_jsjobs (3.13MB) (37.63ms)
  • Before Access::preloadComponents (all components) (239.64KB) (8.17ms)
  • After Access::preloadComponents (all components) (132.72KB) (1.11ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (25μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (367μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.62MB) (117ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (84.54ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (7μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (340μs)
  • afterDispatch (79.29KB) (188μs)
  • afterRender (13.8MB) (150ms)
  • 1 x afterRender (13.8MB) (28.3%)
    149.62ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.62MB) (22.06%)
    116.64ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (15.99%)
    84.54ms
    1 x afterInitialise (11.13MB) (14.82%)
    78.34ms
    1 x afterRenderComponent com_jsjobs (3.13MB) (7.12%)
    37.63ms
    1 x afterRoute (5.03MB) (6.24%)
    32.97ms
    1 x afterLoad (4.12MB) (3.31%)
    17.51ms
    1 x Before Access::preloadComponents (all components) (239.64KB) (1.55%)
    8.17ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.21%)
    1.11ms
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.07%)
    367μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.06%)
    340μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    212μs
    1 x afterDispatch (79.29KB) (0.04%)
    188μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    25μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    7μs
90 statements were executed, 23 of which were duplicates, 67 unique19.92ms328.23KB
  • SELECT @@SESSION.sql_mode;76μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?145μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1111μ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_id87μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`106μ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` = :guest132μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'69μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`62μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'129μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config127μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'74μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'69μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'61μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'62μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-%25e2%2580%2593-Clearing-Agent-Training-Provider-%25e2%2580%2593-Zambia-tender-at-Center-for-International-Private-Enterprise-Global-Alliance-for-Trade-Facilitation-53133%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-%25e2%2580%2593-Clearing-Agent-Training-Provider-%25e2%2580%2593-Zambia-tender-at-Center-for-International-Private-Enterprise-Global-Alliance-for-Trade-Facilitation-53133%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-%25e2%2580%2593-Clearing-Agent-Training-Provider-%25e2%2580%2593-Zambia-tender-at-Center-for-International-Private-Enterprise-Global-Alliance-for-Trade-Facilitation-53133%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC223μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-%25e2%2580%2593-Clearing-Agent-Training-Provider-%25e2%2580%2593-Zambia-tender-at-Center-for-International-Private-Enterprise-Global-Alliance-for-Trade-Facilitation-53133%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-%25e2%2580%2593-Clearing-Agent-Training-Provider-%25e2%2580%2593-Zambia-tender-at-Center-for-International-Private-Enterprise-Global-Alliance-for-Trade-Facilitation-53133%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Terms-of-Reference-%25e2%2580%2593-Clearing-Agent-Training-Provider-%25e2%2580%2593-Zambia-tender-at-Center-for-International-Private-Enterprise-Global-Alliance-for-Trade-Facilitation-53133%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC246μ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.id154μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'220μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'195μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'228μs1.13KB/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:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'161μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'57μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'69μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'223μ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 = 53133635μs60.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'236μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 531333.27ms48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'261μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering300μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'201μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'199μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering271μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'243μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'213μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'68μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'61μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'226μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • 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 = 'companydefaultlogopath'67μ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 fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2162μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2135μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'497μ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'487μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2155μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2134μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2139μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'293μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'272μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'222μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering201μ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)701μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0127μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22159μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24125μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28103μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38170μs81.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39182μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40123μ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` = 0102μ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.lft381μ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.lft219μ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.lft444μ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-–-Clearing-Agent-Training-Provider-–-Zambia-tender-at-Center-for-International-Private-Enterprise-Global-Alliance-for-Trade-Facilitation-53133' AND `published` = 1149μ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-–-Clearing-Agent-Training-Provider-–-Zambia-tender-at-Center-for-International-Private-Enterprise-Global-Alliance-for-Trade-Facilitation-53133'114μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration214μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'141μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field115μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'133μ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` = 1110μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'180μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`236μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'70μ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 desc181μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`258μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid112μ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` = :muserid124μ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-–-Clearing-Agent-Training-Provider-–-Zambia-tender-at-Center-for-International-Private-Enterprise-Global-Alliance-for-Trade-Facilitation-53133'102μ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` = 161μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"290μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES987μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin93μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin82μ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`129μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'122μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'222μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 664485μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?97μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?157μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy