Request for Proposal (RFP) for the Development of an Investment Management System (IMS) tender at Kwacha Pension Trust Fund
Website :
99 Days Ago
Linkedid Twitter Share on facebook

About the client:
Kwacha Pension Trust Fund (the “Fund” or “KPFT”) is a self-managed pension scheme regulated by the Pensions and Insurance Authority. Its main objective is to provide pension benefits to its members on retirement or death. The Fund holds various asset classes as part of its investment portfolio.

TENDER DESCRIPTION: REQUEST FOR PROPOSAL (RFP) FOR THE DEVELOPMENT OF AN INVESTMENT MANAGEMENT SYSTEM (IMS)

To enhance operational efficiency and decision-making processes, KPTF seeks to develop a robust and customised Investment Management System. This system will streamline investment operations, enhance portfolio management, and improve reporting and compliance.

PURCHASER’S CONTACT DETAILS:

Kwacha Pension Trust Fund
Plot No. 5534 Corner Libala/Kakola Roads
Kalundu
Lusaka

User Department: Investments

Tender Date: 3rd February 2025
Tender Closing Date: 17th February 2025
Tender Closing Time: 14:30 hours

Proposal Validity Period: 90 days from tender closing date

Pre-Bid Meeting: 7th February 2025 at 10:00 hours

All clarifications should be in writing and addressed to:

The Director
Kwacha Pension Trust Fund
Plot 5534 Corner Libala/Kakola Road
Kalundu
Lusaka
Zambia

NB: (Kindly read and refer to relevant terms and conditions for further details. Do ensure to quote tender description and closing date and time in your request for proposal and related correspondences)

INSTRUCTION TO BIDDERS

RFP FOR THE DEVELOPMENT OF AN INVESTMENT MANAGEMENT SYSTEM (IMS)

1. You are invited to submit proposals for the aforementioned tender.
2. Kwacha Pension Fund has set aside funds in the 2025 budget to develop a robust and customised Investment Management System (IMS). This system will streamline investment operations, enhance portfolio management, and improve reporting and compliance.
3. Information on detailed terms of reference is contained below.
4. Your proposal in the required format must be addressed to:

The Director
Kwacha Pension Trust Fund
Plot 5534 Corner Libala/Kakola Road
Kalundu
Lusaka, Zambia

5. Sealed proposals shall, clearly be labelled “DEVELOPMENT OF AN INVESTMENT MANAGEMENT SYSTEM FOR KPTF”;
6. Bids should be deposited in the Tender Box, at the reception of Plot 5534 Corner Libala/Kakola Road, Kwacha Pension Trust Fund, Lusaka by 17th February 2025 at 14:30 hours;
7. Bidders are encouraged to attend the tender closing and opening ceremony to be held on 17th February 2025 at 14:30 hours. This will be held at Plot 5534 Corner Libala/Kakola Road, Kwacha Pension Trust Fund, Lusaka;
8. Kindly note that electronic proposals will not be accepted, and late bids will be rejected;
9. Any further clarifications should be submitted in writing and addressed to:

The Director
Kwacha Pension Trust Fund
Plot 5534 Corner Libala/Kakola Road
Kalundu
Lusaka
Zambia

EVALUATION CRITERIA
Selection Criteria: bids that do not provide any of the documents below will not proceed to the technical evaluation stage:

Preliminary Evaluation requirements:

1. Written Power of Attorney from Management or Board of Directors, clearly stating the appointed Representative, his/her specimen signature and designation in the firm. The names and designation(s) and signatures of the appointing authority must be also clearly indicated;
2. Company profile describing the core business of the firm/company and a list of current and previous clients;
3. Proof of physical operational premises;
4. Litigation status from an independent Legal Practitioner. Self-authored Litigation status and those authored by Commissions of Oath will not be accepted;
5. Certificate of incorporation or registration;
6. PACRA Stamped form (with details of directors/shareholders);
7. Copies of IDs of Shareholders/Directors/Partners and Senior Management;
8. Valid 2025 NAPSA Compliance Certificate;
9. Valid 2025 ZRA Tax Clearance Certificate;
10. Valid certificate of registration with ZICTA or ICTAZ;
11. Duly Signed Request For proposal;
12. Signed Joint Venture Agreement: Where a bid is being submitted as a Joint Venture (JV), all parties to the JV must submit Preliminary evaluation statutory documents stated above; and
13. Bid validity of 90 days.

Technical Evaluation

1. Bidder’s experience: The firm should have minimum of five (5) years’ experience in developing customised systems for finance and/or investments. [10 points]
2. Technical Proposals: the technical proposal should clearly explain the consultant’s understanding of the ToRs, highlight their methodology in completing the assignment and work plan (Gantt Chart); [15 Points]
3. Team Composition and qualifications: Submit the Team Composition for this assignment and their relevant qualifications. Attach CVs and Academic/professional qualification/certification and practicing licences as follows:

1. Team Lead (1): The lead team should possess post-graduate qualifications in Computer Science, Software Development or a related field. Project Management or Business Process Engineering qualification is also desirable for the team Lead. Must be submitted. 10 years
[10 points]
2. Assistant Team Lead (1): Degree in Software Development or a related field. Copies of Certificates and Curriculum Vitae. Must be submitted. 5 years
[5 points]

4. Submit at least three (3) reference letters from clients where similar assignments have been undertaken. Reference Letters must be specific to this tender and the institutions must be similar in magnitude and complexity. Past experience of similar work with large public/private sector entity will be an advantage [15 Points].
5. Submit Financial statements for the year 2022 and 2023. [10 points]
6. Presentation of ‘demo’ system by bidders based on their understanding of the ToRs. Only bidders that score above 75% of the other requirements under the technical evaluation will qualify for this stage. [35 Points]
Total Points: 100

PASS MARK: 75 points. The minimum qualifying weighted score to proceed to financial evaluation is 75 points. All bidders that fail to achieve the minimum score shall not be considered for further evaluation on price.

Method of selection: Quality and Cost-Based Criteria procedures will be used for both technical and financial proposals.

The Consultant must submit:
This is a two- envelope tender and proposals must be submitted as follow:
(a) Technical Proposal: 3 plus (1) original
(b) Financial Proposal: 3 plus (1) original

THE FINANCIAL AND TECHNICAL PROPOSAL SHOULD BE SEALED SEPARATELY. AT TENDER OPENING, ONLY THE TECHNICAL PROPOSAL WILL BE OPENED.

COMMERCIAL OR FINANCIAL EVALUATION
7. The Proposal Price – Shall be quoted in Zambian Kwacha
8. State Value Added Tax (VAT), WHT, where applicable, separate
9. All duties, taxes, and other levies payable on the items shall be included in the total price.

10. Payment terms – 30 days after submission of a valid invoice and successful implementation of the assignment.
11. Bid Validity Period: 90 days
12. The Financial proposal shall include the total cost of developing and implementing the system as well as training KPTF staff.

APPLICATION OF QUALITY AND COST BASED SELECTION (QCBS) FORMULA
The lowest evaluated Financial Proposal (Fm) is given the maximum financial score (Sf) of 100.
The formula for determining the financial scores (Sf) for the Proposal is calculated as follows:
Sf = 100 x Fm/ F, in which “Sf” is the financial score, “Fm” is the lowest price, and “F” the price of the proposal under consideration.
The combined technical and financial score (S) is calculated using the formula:
St x T% + Sf x P%.
Where; (St) is the technical score and (Sf) is the financial score. T = the weight given to the Technical Proposal; P = the weight given to the Financial Proposal; T + P = 1
NB: The weights given to technical and financial are 80 and 20, respectively

The Client will enter into negotiations with the best evaluated consultant before Contract award.

TERMS OF REFERENCE (TORS)

KPTF manages a diversified investment portfolio, which includes a broad range of asset classes such as private debt instruments, equities, real estate, Government securities, corporate bonds, and collective investment schemes. This diversified approach reflects the Fund’s commitment to optimizing returns for its members while maintaining a prudent balance between growth and risk. The Fund is dedicated to upholding the highest standards of governance, compliance, and ethical investment practices.

To enhance efficiency, accuracy, and operational effectiveness, KPTF is seeking to implement a comprehensive investment management system. This system will enable seamless and streamlined portfolio management by automating workflows, enhancing data integrity, and providing advanced analytics and reporting capabilities. By adopting this cutting-edge solution, the Fund aims to strengthen its investment operations, support informed decision-making, and ultimately deliver superior value to its members while navigating the dynamic investment landscape.

The IMS is expected to support investment operation through the following features:

1. Portfolio Management:
1.1 Provide real-time tracking and reporting for all asset classes. This should include computation of asset values as well as tracking income and expenditure;
1.2 Deliver automated reports showing growth trends in asset values, yields, income and expenditure for various time periods e.g. weekly, monthly, quarterly and annually; and
1.3 Use for advanced analytics and dashboards to consolidate data.

2. Operational Efficiency:
2.1 Easy to use application programming interface (API) for data import/export; and
2.2 Integrate the system with existing tools such as the accounting software, CAMELS rating and pension software if any (make provision for interest income alerts).
3. Compliance and Risk Management:
3.1 Integrate regulatory compliance checks and risk assessment tools into the system;
3.2 Generation of regulatory compliance reports;
3.3 Use rule-based automation for compliance validation and risk scoring; and
3.4 Conduct stress testing and scenario analysis to evaluate the portfolio’s performance under various market conditions.

4. Data Security:
4.1 Cloud based system;
4.2 Implement robust data encryption and multi-factor authentication for user access;
4.3 Achieve zero data breaches and ensure 99.9% system uptime;
4.4 Adopt industry-standard cybersecurity protocols;
4.5 Role-based access controls; and
4.6 Keep logs of all login attempts.

5. Scalable and Flexible Solutions:
5.1 Design the system to accommodate an increase in assets under management (AUM) in the future;
5.2 Ensure overall system scalability without degradation of performance;
5.3 Use a modular architecture to add functionality as needed; and
5.4 Ensure scalability features are operational from the initial rollout.

6. Decision Making and Advanced Analytics:
6.1 Provide predictive analytics and scenario analysis tools for portfolio management;
6.2 Enable users to analyse at least three scenarios for each investment decision;
6.3 Utilize AI and machine learning algorithms to provide actionable insight; and
6.4 Provision of tools for forecasting and modelling. strategic asset allocation to optimize portfolio composition.
7. Maintenance and Support
7.1 Regular updates and system enhancements;
7.2 Comprehensive training for KPTF staff; and
7.3 Dedicated customer support with guaranteed response times.
Interested Consulting Firms are to submit three (3) copies and one (1) original of their applications in a sealed envelope clearly marked “DEVELOPMENT OF AN INVESTMENT MANAGEMENT SYSTEM FOR KPTF”.

Tender closing date is Monday 17th February 2025 at 14:30hrs.

Job Info
Job Category: Tenders in Zambia
Job Type: Full-time
Deadline of this Job: Monday, February 17 2025
Duty Station: Lusaka
Posted: 03-02-2025
No of Jobs: 1
Start Publishing: 03-02-2025
Stop Publishing (Put date of 2030): 03-02-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
58.506MBMemory Usage435msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.29-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:1 [ "Itemid" => "3541000" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "d4850bacb67c2727eeefcdf23438e631" ]
$_SERVER
array:65 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1747179914 "last" => 1747179914...
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
"3541000"
  • afterLoad (4.12MB) (27.37ms)
  • afterInitialise (11.13MB) (84.67ms)
  • afterRoute (5.06MB) (36.34ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (259μs)
  • afterRenderComponent com_jsjobs (3.14MB) (37.81ms)
  • Before Access::preloadComponents (all components) (247.64KB) (7.34ms)
  • After Access::preloadComponents (all components) (132.72KB) (1.15ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (22μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (361μs)
  • afterDispatch (615.73KB) (9.82ms)
  • afterRender (31.34MB) (227ms)
  • 1 x afterRender (31.34MB) (52.15%)
    226.70ms
    1 x afterInitialise (11.13MB) (19.48%)
    84.67ms
    1 x afterRenderComponent com_jsjobs (3.14MB) (8.7%)
    37.81ms
    1 x afterRoute (5.06MB) (8.36%)
    36.34ms
    1 x afterLoad (4.12MB) (6.3%)
    27.37ms
    1 x afterDispatch (615.73KB) (2.26%)
    9.82ms
    1 x Before Access::preloadComponents (all components) (247.64KB) (1.69%)
    7.34ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.26%)
    1.15ms
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.08%)
    361μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.06%)
    259μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0.01%)
    22μs
86 statements were executed, 23 of which were duplicates, 63 unique29.01ms317.95KB
  • SELECT @@SESSION.sql_mode;46μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?123μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1251μ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_id96μ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` = :guest130μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'86μ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'168μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config117μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'127μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'71μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'68μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'67μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Request-for-Proposal-RFP-for-the-Development-of-an-Investment-Management-System-IMS-tender-at-Kwacha-Pension-Trust-Fund-71916%3FItemid%3D3541000%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Request-for-Proposal-RFP-for-the-Development-of-an-Investment-Management-System-IMS-tender-at-Kwacha-Pension-Trust-Fund-71916%3FItemid%3D3541000%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Request-for-Proposal-RFP-for-the-Development-of-an-Investment-Management-System-IMS-tender-at-Kwacha-Pension-Trust-Fund-71916%3FItemid%3D3541000%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-Request-for-Proposal-RFP-for-the-Development-of-an-Investment-Management-System-IMS-tender-at-Kwacha-Pension-Trust-Fund-71916%3FItemid%3D3541000%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Request-for-Proposal-RFP-for-the-Development-of-an-Investment-Management-System-IMS-tender-at-Kwacha-Pension-Trust-Fund-71916%3FItemid%3D3541000%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Request-for-Proposal-RFP-for-the-Development-of-an-Investment-Management-System-IMS-tender-at-Kwacha-Pension-Trust-Fund-71916%3FItemid%3D3541000%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC316μ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.id209μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'321μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'268μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'220μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'285μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'225μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'130μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'101μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'234μ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 = 71916937μs68.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'255μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 71916315μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'253μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering279μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'231μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'220μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering264μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'259μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'231μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'88μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'100μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'266μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'192μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'85μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'74μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2192μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2146μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'571μ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 = 2175μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2152μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2159μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'256μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'267μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'236μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering205μ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)696μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0131μs920B/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` = 24168μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28110μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38133μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 4092μ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` = 0100μ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.lft557μ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.lft235μ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.lft455μ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-Request-for-Proposal-RFP-for-the-Development-of-an-Investment-Management-System-IMS-tender-at-Kwacha-Pension-Trust-Fund-71916?Itemid=3541000' AND `published` = 1171μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Request-for-Proposal-RFP-for-the-Development-of-an-Investment-Management-System-IMS-tender-at-Kwacha-Pension-Trust-Fund-71916?Itemid=3541000'60μs8.94KB/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration264μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'110μ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'84μ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` = 1114μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'169μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`272μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'65μ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 desc210μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Request-for-Proposal-RFP-for-the-Development-of-an-Investment-Management-System-IMS-tender-at-Kwacha-Pension-Trust-Fund-71916?Itemid=3541000'76μ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` = 162μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"320μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES975μ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_plugin90μ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`91μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'68μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'201μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 269153μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?153μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?11.4ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy