Mystery Clients Consultancy at Tiko Africa
Website :
252 Days Ago
Linkedid Twitter Share on facebook

Background

Tiko Africa is an organization that uses its digital platform called Tiko to motivate users – primarily young women and adolescent girls – to make positive choices. We use nudges like reminders, discounts, in person and digital follow-ups, and reward points to encourage our users to access and use healthy products and services. We also support them in becoming entrepreneurs and adding value to their economies. Tiko Africa’s reward points can be used to redeem products and services at local shops, or as subsidies to cover the cost of sexual and reproductive health (SRH) services, removing the cost to access for the users, who are primarily 10-24 year old adolescent girls and young women (AGYW) as well as adolescent boys and young men.

Tiko Africa has operations in the following countries either by having offices or by working through local partners in Kenya, Uganda, Ethiopia, Burkina Faso, Zambia and South Africa.

Tiko Africa is looking to source a firm to conduct mystery clients at Tiko clinics and pharmacies in Zambia. These exercises shall assist Tiko Africa to monitor and evaluate the quality of services provided at the clinics and pharmacies, monitor potential fraudulent and risky behaviour and ensure compliance with the service process for Tiko services.

The coverage of this exercise shall be in Lusaka.

Mystery clients services (MCS)

The firm will offer routine mystery client services (MCS) for girls and boys between the ages of 10-24 years of age. The ideal MCS will provide the following services;

  • Provide MCS visits within the countries and regions stated above.
  • The MCS will provide verification of specific suspicious activities which will include assessment of general compliance to agreed terms in the Letter of Agreement (LOA) and/or Code of conduct (COC) with the actors. They will also check for exploitation of the system restrictions or gaming of the Tiko platform.
  • Assess the experience and quality of the entire client user journey for the users to get learnings and identify potential areas of improvement. The assessment areas will be based on the below touch points along the client user journey:

Step 1: Enrollment

The MC will assess the assisted mobilization and self-enrollment pathways:

Assisted Mobilization

The MC will get linked to the mobilizer using mobile numbers or mobiliser locations which Tiko Africa will provide. The MC will assess the:

  1. Ease of reaching a mobilizer, their level of cooperation and check if the mobilizer has a badge or any organization branding when they meet;
  2. Enrollment process by the mobilizer through lo-tech and/or no-tech pathways;
  3. Mobilizer knowledge of the offers/products/services;
  4. Effectiveness of the age verification as done by the mobilizer;
  5. Adherence to the code of conduct such coercion or misleading information on the offer;
  6. Potential mobilizer malpractice such as collusion with providers or retailers, use of client miles through gaming of the system or misleading clients;
  7. Youth friendliness of the mobilizer;
  8. Information given on location of a provider or actual escort to a provider by the immobilizer.

Self Enrollment

The MC will attend Tiko Africa activation events or visit social media platforms and assess:

  1. The ease of access to the self-enrollment instructions or information;
  2. The actual self-enrollment experience and process including messages delivered to the girl;
  3. The possibility of client gaming the system at self enrollment with checks for gender, age, multiple phone numbers;
  4. The ease of finding exact provider location of service providers for services.

A schedule of the Tiko Africa activation events and the social media platforms will be provided by Tiko Africa during project set-up.

MC will also make observations on the entire enrollment experience including the effectiveness of various messages received from the platform.

Step 2: Use

The MCS will assess the experience and quality of services offered at providers i.e. a clinic or pharmacy. The MCS will assess:

  1. Ease of finding a provider within the community through the mobilizer
  2. The ease of identification of the provider through branding and signages
  3. The youth friendliness of the clinic i.e. staff attitude at the clinic, promptness of service provision, privacy and promptness of services checked as time taken at the clinic
  4. Quality (duration) of counseling services provided
  5. Accuracy of the provider information on various contraceptive services
  6. Advice by the provider on various contraceptive side effects
  7. Age verification by the provider
  8. Overall customer experience
  9. Verification of service and product provided (clinic & pharmacy level) after provision and validation of services
  10. Potential malpractice such coercion, misleading information, charging by the provider for services, collusion with mobilizer and/or retailer

The MCS will also make observations and document the experience and support of the system through SMS messages.

Step 3: Rating

The MCS will assess the ease of rating the provider on the system. They will also confirm the effectiveness of the messaging on the importance of rating along the entire user journey including reminder SMSs or mobilizer reminder or provider reminder

Step 4: Spend

The MCS will assess:

  1. The ease of finding a retailer/trader/shop by either the use of the text code (to be provided) or provider advice or mobilizer advice on the location of the retailers
  2. The ease of identification of the retailer through branding/signages
  3. The proficiency of the trader in exchanging miles for products
  4. The time taken to complete the transaction at the traders
  5. The correct pricing of products exchanged for miles
  6. Potential collusion between the trader and /or mobilizers and providers
  7. The overall experience at the trader including the attitude of the trader, product variety

The MCS will assess the overall support of the system in improving spend of miles at the traders including SMS.

Step 5: Refer

The MCS will assess the ease of referring peers on the platform. This will include an assessment of the effectiveness of the awareness strategies such as SMS, mobilizer messaging and provider messaging.

  1. Reporting; gather all the data received by the mystery clients for quality control including checking for outliers, provide insights and conduct an integrity check.

Deliverables

  1. Data collection (MCS), time frame; Monthly, deliverable; Compiled raw data for internal checks and validation
  2. Monthly survey reports (MCS) – The reports must be insightful to assist in program improvements and risk management, time frame; Monthly (First week of subsequent month), deliverable; Detailed report with analysis supporting the findings and conclusions in the report.

Technical Requirements

The qualified firm should exhibit the following:

  1. Demonstrate experience and expertise of similar assignments with Non-Governmental Organizations (NGOs) including how the firm intends to manage interactions with users who are mostly young.
  2. Provide an activity plan (project plan) of actions to achieve the objectives of the assignment, specifying budgeted hours, timelines and sequence for its consultancy procedure and level of staff to be assigned;
  3. Incorporate CV’s of the proposed professional staff of the core management team proposed for the engagement and the authorized representative submitting the proposal. CVs should demonstrate relevant experience of dealing with similar surveys within organizations similar to Tiko Africa.
  4. List of current and past clients where the bidder has conducted mystery client/shopper along with the name of the organization, contact person, designation, and a contact number, nature of services and length of the appointment for at least three (3) International non-governmental organizations.

Evaluation Criteria

Proposals will be evaluated in two parts. The experience, technical proposal and financial quotation shall bear 70% of the total marks while the references and financial capacity shall bear 30% of the total marks.

  • Proposals should make clear about the relevant skills, experience and capacity of the participant, in respect of this particular TOR.
  • Proposals must contain the details of the proposed approach to be adopted in order to deliver the service in accordance with the TOR.
  • Proposals should clearly indicate whether or not bid participants have the capacity to meet the requirements of the TOR.
  • Proposal should clearly indicate compliance with the appropriate data protection, privacy, legal, social, tax and ethical issues applicable to the country

Description

1.Experience, Skills and Ability

  • Past experience in similar work of this nature.
  • Team member experience (accompanied by brief CV’s).
  • Ability of the bidder to fulfil Tiko Africa’s requirements

Weight: 30

2.Technical Approach and Execution Plan

  • Proposals must contain the details of the proposed approach to be adopted in order to deliver the service in accordance with the TOR.

Weight: 30

3.Financial quotation

  • Proposals should clearly indicate whether or not bid participants have the financial capacity to meet the requirements of the TOR based on the previous value of similar works done e.g. by sharing copies of recent audited financial statements.

Weight:10

4.References

  • Did the bidder submit at least three relevant and contactable clients that were serviced in the past 36 months.

Weight:10

5.Capacity

  • Proposals should clearly indicate whether or not bid participants have the capacity to meet the requirements of the TOR.

Weight:20

Totals Weight:100

Proposal submission guidelines

Firms and individuals are invited to submit proposals for this engagement. Proposals should include the contents below and not exceed a maximum length of 15 pages, excluding annexures (budget and summary profiles of proposed personnel).

  • Cover page: Summary with basic information such as names, address, contact information, proposed budget, etc.
  • Capacity statement: A brief capacity statement as to why your firm and the team you are proposing is well positioned to undertake the engagement
  • Qualification to the scope of work: Any qualifications that you may have regarding the scope of work
  • Proposed approach: Your proposed approach to delivering on the scope of work requirements
  • Proposed personnel – The qualifications of the proposed qualifications and their experience.
  • Work plan:proposed work plan with tasks, responsible person/s and timeline
  • Budget: Total budget envelope required to deliver the work (in Uganda Shillings), and line-item breakdown of direct costs and overheads
  • References of similar engagements undertaken by the firm in the last 5 years

How to apply

Applications/submissions are requested to submit their tender/application documents (technical & financial) proposals to Tiko Africa via mail procurement@tiko.org by end of day 20th September 2024. With the subject Proposal submission Mystery Clients Consultancy – Zambia

Job Info
Job Category: Tenders in Zambia
Job Type: Full-time
Deadline of this Job: Tuesday, September 24 2024
Duty Station: Lusaka
Posted: 10-09-2024
No of Jobs: 1
Start Publishing: 10-09-2024
Stop Publishing (Put date of 2030): 10-09-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60.301MBMemory Usage962msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.29-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:63 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1747810473 "last" => 1747810473...
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) (58.35ms)
  • afterInitialise (11.1MB) (277ms)
  • afterRoute (5.03MB) (94.99ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (263μs)
  • afterRenderComponent com_jsjobs (3.16MB) (70.14ms)
  • Before Access::preloadComponents (all components) (243.64KB) (7.7ms)
  • After Access::preloadComponents (all components) (132.72KB) (1.13ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (19μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (361μs)
  • afterDispatch (2.39MB) (155ms)
  • afterRender (31.5MB) (296ms)
  • 1 x afterRender (31.5MB) (30.8%)
    296.22ms
    1 x afterInitialise (11.1MB) (28.79%)
    276.90ms
    1 x afterDispatch (2.39MB) (16.1%)
    154.85ms
    1 x afterRoute (5.03MB) (9.88%)
    94.99ms
    1 x afterRenderComponent com_jsjobs (3.16MB) (7.29%)
    70.14ms
    1 x afterLoad (4.12MB) (6.07%)
    58.35ms
    1 x Before Access::preloadComponents (all components) (243.64KB) (0.8%)
    7.70ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.12%)
    1.13ms
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.04%)
    361μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.03%)
    263μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    19μs
89 statements were executed, 23 of which were duplicates, 66 unique69.58ms326.22KB
  • SELECT @@SESSION.sql_mode;85μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?20.49ms1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1152μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `icop0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)985μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`123μs1.59KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `icop0_usergroups` AS `a` LEFT JOIN `icop0_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest149μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'149μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`127μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'13.55ms2.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'101μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'91μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'106μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'84μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Mystery-Clients-Consultancy-at-Tiko-Africa-65333%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Mystery-Clients-Consultancy-at-Tiko-Africa-65333%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Mystery-Clients-Consultancy-at-Tiko-Africa-65333%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC289μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Mystery-Clients-Consultancy-at-Tiko-Africa-65333%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Mystery-Clients-Consultancy-at-Tiko-Africa-65333%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Mystery-Clients-Consultancy-at-Tiko-Africa-65333%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC527μ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.id190μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'405μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • 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 = 'social'237μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'306μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'245μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'94μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'90μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'310μ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 = 65333782μs68.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'288μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 653335.08ms48B/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 ordering309μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'237μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'235μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering253μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'240μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'243μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'103μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'79μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'343μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'249μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'94μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'88μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2195μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2184μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'643μ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'592μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2184μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2163μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2164μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'283μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'297μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'234μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering203μ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` = 0115μs920B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22116μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24144μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28102μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38190μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40226μ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` = 0125μ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.lft446μ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.lft280μ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.lft582μ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-Mystery-Clients-Consultancy-at-Tiko-Africa-65333' AND `published` = 1139μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Mystery-Clients-Consultancy-at-Tiko-Africa-65333'88μs8.94KB/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration346μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'161μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field157μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'117μ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` = 1136μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'213μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`387μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'116μ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 desc209μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`402μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid177μ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` = :muserid163μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Mystery-Clients-Consultancy-at-Tiko-Africa-65333'172μ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` = 198μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"405μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.19ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin152μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin120μ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`122μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'149μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'284μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 7588124μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?111μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?9.54ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy