Category Manager (Commercial Manager) job at CDL Human Resource
23 Days Ago
Linkedid Twitter Share on facebook
Category Manager (Commercial Manager)
2025-05-08T17:14:48+00:00
CDL Human Resource
https://cdn.greatkenyanjobs.com/jsjobsdata/data/employer/comp_7870/logo/CDL%20Human%20Resource.png
FULL_TIME
 
Nairobi
kenya
00100
Kenya
Human Services
Sales & Retail
KES
 
MONTH
2025-05-17T17:00:00+00:00
 
Kenya
8

KEY RESPONSIBILITIES

  • Sales Strategy Development: Develop and implement a comprehensive national sales strategy aligned with business objectives to drive revenue growth and market share. Set and monitor performance targets for regional teams and assess market trends to adjust strategies accordingly.
  • Sales Category Management: Lead brand ownership and positioning for all pharmaceutical products at a national level. Oversee the creation of effective marketing campaigns, ensuring high ROI and alignment with brand objectives. Collaborate with the marketing team to develop innovative promotional activities for brand visibility.
  • People Management: Lead, mentor, and evaluate the performance of Sales Managers, Team Leaders, Ken Account Managers and Sales Representatives to build a high-performing national team.
  • Supplier and Customer Management: Establish and maintain strategic partnerships with key suppliers to ensure product availability and quality standards. Build and nurture customer relationships to achieve high satisfaction rates, customer loyalty, adapting approaches based on client feedback.
  • Debt Collection and Management: Develop and execute strategies for managing inventory and ensuring effective debt collection and credit management to minimize overdue accounts while
  • Financials: Manage the commercial unit’s budget, targeting gross profit (GP) and overall unit profitability. Ensure accountability for financial metrics, including return on investment (ROI) for marketing activities. Prepare and oversee annual budgets, closely monitoring and adjusting to maintain financial health.

QUALIFICATIONS & EXPERIENCE

  • Must have a minimum of a science related academic qualification with a valid applicable PPB license
  • Bachelor’s degree Sales & Marketing or relevant business field
  • An MBA will be treated as an added advantage
  • A minimum of 10 year’s experience in pharmaceuticals sales, out of which 5 years should be in a senior leadership role at a regional level.
  • Be a strategist with excellent leadership, analytical and problem-solving skills
  • Must have excellent PR with the Kenyan market i.e. wholesalers, Hospitals, Chemists and sub distributors
  • Strong people management skills with high business acumen capacity
Sales Strategy Development: Develop and implement a comprehensive national sales strategy aligned with business objectives to drive revenue growth and market share. Set and monitor performance targets for regional teams and assess market trends to adjust strategies accordingly. Sales Category Management: Lead brand ownership and positioning for all pharmaceutical products at a national level. Oversee the creation of effective marketing campaigns, ensuring high ROI and alignment with brand objectives. Collaborate with the marketing team to develop innovative promotional activities for brand visibility. People Management: Lead, mentor, and evaluate the performance of Sales Managers, Team Leaders, Ken Account Managers and Sales Representatives to build a high-performing national team. Supplier and Customer Management: Establish and maintain strategic partnerships with key suppliers to ensure product availability and quality standards. Build and nurture customer relationships to achieve high satisfaction rates, customer loyalty, adapting approaches based on client feedback. Debt Collection and Management: Develop and execute strategies for managing inventory and ensuring effective debt collection and credit management to minimize overdue accounts while Financials: Manage the commercial unit’s budget, targeting gross profit (GP) and overall unit profitability. Ensure accountability for financial metrics, including return on investment (ROI) for marketing activities. Prepare and oversee annual budgets, closely monitoring and adjusting to maintain financial health.
 
Must have a minimum of a science related academic qualification with a valid applicable PPB license Bachelor’s degree Sales & Marketing or relevant business field An MBA will be treated as an added advantage A minimum of 10 year’s experience in pharmaceuticals sales, out of which 5 years should be in a senior leadership role at a regional level. Be a strategist with excellent leadership, analytical and problem-solving skills Must have excellent PR with the Kenyan market i.e. wholesalers, Hospitals, Chemists and sub distributors Strong people management skills with high business acumen capacity
bachelor degree
120
JOB-681ce688d4d71

Vacancy title:
Category Manager (Commercial Manager)

[Type: FULL_TIME, Industry: Human Services, Category: Sales & Retail]

Jobs at:
CDL Human Resource

Deadline of this Job:
Saturday, May 17 2025

Duty Station:
Nairobi | kenya | Kenya

Summary
Date Posted: Thursday, May 8 2025, Base Salary: Not Disclosed

Similar Jobs in Kenya
Learn more about CDL Human Resource
CDL Human Resource jobs in Kenya

JOB DETAILS:

KEY RESPONSIBILITIES

  • Sales Strategy Development: Develop and implement a comprehensive national sales strategy aligned with business objectives to drive revenue growth and market share. Set and monitor performance targets for regional teams and assess market trends to adjust strategies accordingly.
  • Sales Category Management: Lead brand ownership and positioning for all pharmaceutical products at a national level. Oversee the creation of effective marketing campaigns, ensuring high ROI and alignment with brand objectives. Collaborate with the marketing team to develop innovative promotional activities for brand visibility.
  • People Management: Lead, mentor, and evaluate the performance of Sales Managers, Team Leaders, Ken Account Managers and Sales Representatives to build a high-performing national team.
  • Supplier and Customer Management: Establish and maintain strategic partnerships with key suppliers to ensure product availability and quality standards. Build and nurture customer relationships to achieve high satisfaction rates, customer loyalty, adapting approaches based on client feedback.
  • Debt Collection and Management: Develop and execute strategies for managing inventory and ensuring effective debt collection and credit management to minimize overdue accounts while
  • Financials: Manage the commercial unit’s budget, targeting gross profit (GP) and overall unit profitability. Ensure accountability for financial metrics, including return on investment (ROI) for marketing activities. Prepare and oversee annual budgets, closely monitoring and adjusting to maintain financial health.

QUALIFICATIONS & EXPERIENCE

  • Must have a minimum of a science related academic qualification with a valid applicable PPB license
  • Bachelor’s degree Sales & Marketing or relevant business field
  • An MBA will be treated as an added advantage
  • A minimum of 10 year’s experience in pharmaceuticals sales, out of which 5 years should be in a senior leadership role at a regional level.
  • Be a strategist with excellent leadership, analytical and problem-solving skills
  • Must have excellent PR with the Kenyan market i.e. wholesalers, Hospitals, Chemists and sub distributors
  • Strong people management skills with high business acumen capacity

 

Work Hours: 8

Experience in Months: 120

Level of Education: bachelor degree

Job application procedure

Interested and qualified? click here

 

All Jobs | QUICK ALERT SUBSCRIPTION

Job Info
Job Category: Sales jobs in Kenya
Job Type: Full-time
Deadline of this Job: Saturday, May 17 2025
Duty Station: Nairobi | kenya | Kenya
Posted: 08-05-2025
No of Jobs: 1
Start Publishing: 08-05-2025
Stop Publishing (Put date of 2030): 08-05-2067
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
58.706MBMemory Usage460msRequest 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" => "greatkenyanjobs" "HOME" => "/home/greatkenyanjobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1748779659 "last" => 1748779659...
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) (17.74ms)
  • afterInitialise (11.17MB) (75.04ms)
  • afterRoute (5.06MB) (34.31ms)
  • beforeRenderComponent com_jsjobs (9.7KB) (247μs)
  • afterRenderComponent com_jsjobs (3.14MB) (35.33ms)
  • Before Access::preloadComponents (all components) (239.64KB) (7.03ms)
  • After Access::preloadComponents (all components) (130.74KB) (1.11ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.91KB) (23μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (345μs)
  • afterDispatch (502.27KB) (8.77ms)
  • afterRender (32.16MB) (279ms)
  • 1 x afterRender (32.16MB) (60.71%)
    279.38ms
    1 x afterInitialise (11.17MB) (16.31%)
    75.04ms
    1 x afterRenderComponent com_jsjobs (3.14MB) (7.68%)
    35.33ms
    1 x afterRoute (5.06MB) (7.46%)
    34.31ms
    1 x afterLoad (4.12MB) (3.85%)
    17.74ms
    1 x afterDispatch (502.27KB) (1.91%)
    8.77ms
    1 x Before Access::preloadComponents (all components) (239.64KB) (1.53%)
    7.03ms
    1 x After Access::preloadComponents (all components) (130.74KB) (0.24%)
    1.11ms
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.07%)
    345μs
    1 x beforeRenderComponent com_jsjobs (9.7KB) (0.05%)
    247μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.91KB) (0.01%)
    23μs
87 statements were executed, 23 of which were duplicates, 64 unique17.88ms238.13KB
  • SELECT @@SESSION.sql_mode;45μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?74μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 175μ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)228μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`102μ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` = :guest105μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'56μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`65μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'152μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config131μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'62μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'49μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'46μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'43μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Category-Manager-Commercial-Manager-job-at-CDL-Human-Resource-101463%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Category-Manager-Commercial-Manager-job-at-CDL-Human-Resource-101463%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Category-Manager-Commercial-Manager-job-at-CDL-Human-Resource-101463%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC179μs4.23KB/plugins/system/jlexblock/jlexblock.php:147Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Category-Manager-Commercial-Manager-job-at-CDL-Human-Resource-101463%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Category-Manager-Commercial-Manager-job-at-CDL-Human-Resource-101463%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Category-Manager-Commercial-Manager-job-at-CDL-Human-Resource-101463%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC287μ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.id144μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'302μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'224μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'246μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'320μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'235μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'68μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'65μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'248μ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 = 101463596μs36.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'233μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 101463296μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'232μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering274μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'222μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'237μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering252μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'243μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'256μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'62μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'66μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'238μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'233μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'67μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'73μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2154μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2148μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'570μ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'539μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2154μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2136μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2138μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'248μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'302μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'222μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering192μ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)680μs8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0103μs888B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22104μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24101μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 37100μ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` = 0140μ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.lft426μ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.lft232μ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.lft469μ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-Category-Manager-Commercial-Manager-job-at-CDL-Human-Resource-101463' AND `published` = 1151μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-Category-Manager-Commercial-Manager-job-at-CDL-Human-Resource-101463'98μ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'123μs10.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field118μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'104μ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` = 1142μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'209μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`330μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'86μ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 desc213μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`364μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid137μ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` = :muserid146μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-Category-Manager-Commercial-Manager-job-at-CDL-Human-Resource-101463'100μ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` = 190μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"427μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.14ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin106μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin105μ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`104μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'98μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'283μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 786181μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?103μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?423μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy