US Pharmacopeial Convention

PPB Dashboard Development Consultancy – Kenya job at US Pharmacopeia

Dashboard
Job Detail

Website :

323 Days Ago

Vacancy title:
PPB Dashboard Development Consultancy – Kenya

[ Type: FULL TIME , Industry: Nonprofit, and NGO , Category: Consultant ]

Jobs at:

US Pharmacopeia

Deadline of this Job:
Friday, August 02 2024

Duty Station:
Within Kenya , Nairobi, East Africa

Summary
Date Posted: Friday, July 19 2024, Base Salary: Not Disclosed

JOB DETAILS:
Users and Survivors of Psychiatry in Kenya (USP Kenya) welcomes all members of the public and relevant stakeholders to be partners in promoting the human rights discourse of persons with psychosocial disabilities.

This will entail gathering information from PPB staff and external users/clients on their specific needs and requirements for the envisaged regulatory information dashboard. The results of this assignment will inform the design, development, deployment and use of the proposed regulatory information dashboard for the PPB.

Key Responsibilities/Tasks
The consultant will:
• Interview a cross section of PPB staff and external clients to collect the end-users’ specific needs for a regulatory information dashboard.
• Collate the suggestions from the sampled end-users and work with PPB IT manager, PQM+ team and other experts/partners supporting PPB to develop a use case and user requirements specifications document that considers functional requirements and non-functional requirements.
• Review information dashboards from comparable regulators and recommend relevant attributes for incorporating into the PPB dashboard.
• Create, implement, and manage a stakeholder engagement matrix; and participate in joint meetings with PPB, PQM+, and other stakeholders involved in the development of the PPB regulatory information dashboard.

Assignment Deliverables
• Brief inception report demonstrating understanding of the assignment
• Users’ specific needs report on the regulatory information dashboard
• End-user requirement specifications for the regulatory information dashboard

Basic Qualifications and Experience
• Bachelor’s degree in computer science or information systems/management or related field. An advanced qualification in a closely related field will be an advantage.
• Minimum of ten (10) years of experience in information systems analysis and design (or end-to-end software development), in Kenya
• Experience in designing and developing interactive informational dashboards that are linked to databases will be added advantage.

Other Competencies
• Experience with Identification of Medicinal Product’s (IDMP) five ISO standards is desirable.
• Experience in pharma regulation is desirable.
• Demonstrates high professional integrity and zeal to work.
• Results driven with demonstrated successful outcomes.
• Ability to work with multiple teams and willingness to consider others’ ideas
• Ability to handle multiple priorities in a fast-paced environment.
• Ability to work flexible hours when needed.

Work Hours: 8

Experience in Months: 120

Level of Education: Bachelor Degree

Job application procedure

If you are interested in this consulting work, please provide us with the following:
• A covering letter demonstrating how you meet the criteria described above, and how you propose to organize the work outlined above, in a simple Gantt Chart
• Your hourly, all inclusive, consultancy fees in KES
• Your availability to do the work during the specified period.
• A copy of your Curriculum Vitae, showing similar and relevant work done
• Names and contact details for three referees.
• Clarification on whether you are bidding as an individual or as a company.
Closing Date: The closing date for applications is July 30, 2024. Applications should be submitted to ATTN: Masoud Azam, at GPH_Procurement@USP.org . When submitting your application, write, “PPB Dashboard Development Consultancy – Kenya” in the email Subject Line.

All Jobs

QUICK ALERT SUBSCRIPTIO

Vacancy title:
PPB Dashboard Development Consultancy – Kenya

[ Type: FULL TIME , Industry: Nonprofit, and NGO , Category: Consultant ]

Jobs at:

US Pharmacopeia

Deadline of this Job:
Friday, August 02 2024

Duty Station:
Within Kenya , Nairobi, East Africa

Summary
Date Posted: Friday, July 19 2024, Base Salary: Not Disclosed

QUICK ALERT SUBSCRIPTION

Job Info

Job Category: Consultant/ Contractual jobs in Kenya

Job Type: Full-time

Deadline of this Job: Friday, August 02 2024

Duty Station: Nairobi

Posted: 19-07-2024

No of Jobs: 1

Start Publishing: 19-07-2024

Stop Publishing (Put date of 2030): 19-07-2067

Apply Now

Notification Board

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.

J! Info Request Session Profile Queries87 Log

58.707MB451ms

Joomla! Version	4.4.10
PHP Version	8.1.32
Identity	guest
Response	200
Template	jl_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" => "greatkenyanjobs" "HOME" => "/home/greatkenyanjobs" "SCRIPT_NAME" => "/in...

session: array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1749348103 "last" => 1749348103...
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.greatkenyanjobs.com/how-to-app...
JSItemid: "190"

afterLoad (4.12MB) (27.94ms)
afterInitialise (11.17MB) (96.13ms)
afterRoute (5.03MB) (30.61ms)
beforeRenderComponent com_jsjobs (9.7KB) (191μs)
afterRenderComponent com_jsjobs (3.16MB) (34.88ms)
Before Access::preloadComponents (all components) (247.64KB) (4.74ms)
After Access::preloadComponents (all components) (130.74KB) (918μs)
Before Access::getAssetRules (id:1 name:root.1) (3.91KB) (14μs)
After Access::getAssetRules (id:1 name:root.1) (26.2KB) (237μs)
afterDispatch (494.27KB) (5.68ms)
afterRender (32.19MB) (242ms)

1 x afterRender (32.19MB) (53.63%)	241.97ms
1 x afterInitialise (11.17MB) (21.31%)	96.13ms
1 x afterRenderComponent com_jsjobs (3.16MB) (7.73%)	34.88ms
1 x afterRoute (5.03MB) (6.78%)	30.61ms
1 x afterLoad (4.12MB) (6.19%)	27.94ms
1 x afterDispatch (494.27KB) (1.26%)	5.68ms
1 x Before Access::preloadComponents (all components) (247.64KB) (1.05%)	4.74ms
1 x After Access::preloadComponents (all components) (130.74KB) (0.2%)	918μs
1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.05%)	237μs
1 x beforeRenderComponent com_jsjobs (9.7KB) (0.04%)	191μs
1 x Before Access::getAssetRules (id:1 name:root.1) (3.91KB) (0%)	14μs

87 statements were executed, 23 of which were duplicates, 64 unique38.38ms278.13KB

SELECT @@SESSION.sql_mode;51μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
SELECT `data` FROM `icop0_session` WHERE `session_id` = ?103μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 192μ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)9.59ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
SELECT `id`,`rules` FROM `icop0_viewlevels`121μ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` = :guest136μs1.64KBParams/libraries/src/Access/Access.php:868Copy
SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'114μ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'186μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
SELECT * FROM icop0_rsform_config163μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'76μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'51μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'63μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'58μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-PPB-Dashboard-Development-Consultancy-%25e2%2580%2593-Kenya-job-at-US-Pharmacopeia-100046%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-PPB-Dashboard-Development-Consultancy-%25e2%2580%2593-Kenya-job-at-US-Pharmacopeia-100046%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-PPB-Dashboard-Development-Consultancy-%25e2%2580%2593-Kenya-job-at-US-Pharmacopeia-100046%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC254μs4.23KB/plugins/system/jlexblock/jlexblock.php:147Copy
SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-PPB-Dashboard-Development-Consultancy-%25e2%2580%2593-Kenya-job-at-US-Pharmacopeia-100046%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-PPB-Dashboard-Development-Consultancy-%25e2%2580%2593-Kenya-job-at-US-Pharmacopeia-100046%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-PPB-Dashboard-Development-Consultancy-%25e2%2580%2593-Kenya-job-at-US-Pharmacopeia-100046%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC296μs4.25KB/plugins/system/jlexblock/jlexblock.php:147Copy
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.id163μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'217μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'187μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'264μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'298μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'217μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'55μs856B/components/com_jsjobs/models/configurations.php:103Copy
SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'54μs856B/components/com_jsjobs/models/configurations.php:103Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'232μ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 = 1000461.02ms76.03KB/components/com_jsjobs/models/job.php:1579Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'156μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 1000464.69ms48B/components/com_jsjobs/models/job.php:1588Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'242μs992B/components/com_jsjobs/models/configurations.php:82Copy
SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering293μ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'241μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering249μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'212μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'245μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'63μs856B/components/com_jsjobs/models/configurations.php:103Copy
SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'49μs856B/components/com_jsjobs/models/configurations.php:103Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'214μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'193μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'56μs856B/components/com_jsjobs/models/configurations.php:103Copy
SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'52μs856B/components/com_jsjobs/models/configurations.php:103Copy
SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2147μs856B/components/com_jsjobs/models/customfields.php:198Copy
SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2126μs856B/components/com_jsjobs/models/customfields.php:198Copy
SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'500μ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'543μ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 = 2162μs856B/components/com_jsjobs/models/customfields.php:198Copy
SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2127μs856B/components/com_jsjobs/models/customfields.php:198Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'236μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'269μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'243μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering178μ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)653μs8.12KBParams/libraries/src/Access/Access.php:357Copy
SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0125μs888B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
SELECT * FROM `icop0_rstbox` WHERE `id` = 2288μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
SELECT * FROM `icop0_rstbox` WHERE `id` = 24120μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
SELECT * FROM `icop0_rstbox` WHERE `id` = 3772μ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` = 0117μ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.lft294μ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.lft212μ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.lft332μs2.3KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-PPB-Dashboard-Development-Consultancy-–-Kenya-job-at-US-Pharmacopeia-100046' AND `published` = 1157μs1.2KB/plugins/system/jmap/jmap.php:818Copy
SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-PPB-Dashboard-Development-Consultancy-–-Kenya-job-at-US-Pharmacopeia-100046'61μs960B/plugins/system/jmap/jmap.php:920Copy
SELECT * FROM icop0_acym_configuration315μs24.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
SELECT * FROM icop0_acym_list WHERE type = 'standard'156μs10.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
SELECT * FROM icop0_acym_field103μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'76μ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` = 1105μ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`274μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'107μ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 desc187μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
SHOW FULL COLUMNS FROM `icop0_users`373μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
SELECT * FROM `icop0_users` WHERE `id` = :userid157μ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` = :muserid147μs1.68KBParams/libraries/src/Table/User.php:132Copy
SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-PPB-Dashboard-Development-Consultancy-–-Kenya-job-at-US-Pharmacopeia-100046'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` = 188μs1008B/plugins/system/jmap/jmap.php:508Copy
SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"487μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
SHOW TABLES1.23ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
SELECT * FROM icop0_acym_plugin103μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
SELECT * FROM icop0_acym_plugin92μ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`113μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'66μs856B/components/com_jsjobs/models/configurations.php:103Copy
SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'259μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 476667μs856B/components/com_jsjobs/models/company.php:1832Copy
SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?88μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?7.26ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy