Pricing Analyst job at Energy and Petroleum Regulatory Authority (EPRA)
Website :
1013 Days Ago
Linkedid Twitter Share on facebook

Vacancy title:
Pricing Analyst

[ Type: FULL TIME , Industry: Public Administration, and Government , Category: Accounting & Finance ]

Jobs at:

Energy and Petroleum Regulatory Authority (EPRA)

Deadline of this Job:
31 July 2022  

Duty Station:
Within Kenya , Nairobi , East Africa

Summary
Date Posted: Monday, July 04, 2022 , Base Salary: Not Disclosed

Similar Jobs in Kenya
Learn more about Energy and Petroleum Regulatory Authority (EPRA)
Energy and Petroleum Regulatory Authority (EPRA) jobs in Kenya

JOB DETAILS:
Pricing Analyst (1 POSITION) EPRA JOB GRADE 6 (PERMANENT &
PENSIONABLE)
REF: VA/46/6/2022

Duties and Responsibilities Financial Analysis
1. Implement an effective monitoring and evaluation system to facilitate indepth analysis of instances of non-compliance;
2. Coordinate continuous financial reporting by regulated utilities as well as timely review of those financial returns;
3. Setting, review and adjustment of tariffs and tariff structures in the energy sector;
4. Monitor and enforce sector utility regulatory performance targets, especially the financial health of the licensees;
5. Monitoring and evaluation of the status of competition in the energy sector;
6. Analyze statutory trading arrangements; including electric power purchase agreements, and network service contracts;
7. Coordinate the setting, review, adjustment, and investigation on implementation of electricity tariffs and structures;
8. Enforce compliance with regulatory accounting regulations and tariff codes;
9. Analyze petroleum refining, storage and pipeline transportation contracts;
10. Compute the monthly retail price caps for regulated petroleum products;
11. Compute pass-through electricity costs including FCC, FERFA, Inflation adjustments and WARMA;
12. Undertake pass through costs audits on periodic basis;
13. Participating in designated Committees;
14. Supporting the preparation of the Sections Budgets; and 15. Supporting the development of Section’s Procurement Plans.

Energy Economics (petroleum)
1. Setting, review and adjustment of tariffs and tariff structures in the energy sector;
2. Monitor and enforce sector utility regulatory performance targets, especially the performance of Oil Marketing Companies;
3. Monitoring and evaluating compliance with Legal Notice Number 196;
4. Maintains oversight on petroleum, electricity and renewable energy subsectors operations with a view to enforcing fair play and competition;
5. Monitoring and evaluation of the status of competition in the energy sector;
6. Analyze statutory trading arrangements; including electric power purchase agreements, and network service contracts;
7. Participate in the setting, review, adjustment, and investigation on implementation of electricity tariffs and structure;
8. Enforce compliance with regulatory accounting regulations and tariff codes;
9. Analyze petroleum refining, storage and pipeline transportation contracts;
10. Compute the monthly retail price caps for regulated petroleum products;
11. Compute and set price caps for selected petroleum products;
12. Develop international petroleum price projections and conduct monthly price data acquisition;
13. Participate in the computation of pass-through electricity costs including FCC, FERFA, Inflation adjustments and WARMA;
14. Participate in regulatory research in the sector on emerging topical issues that inform policy dispensation in the sector;
15. Participating in designated Committees;
16. Supporting the preparation of the Sections Budgets; and 17. Supporting the development of Section’s Procurement Plans.

Energy Economics (electricity)
1. Implement an effective monitoring and evaluation system to facilitate in-depth analysis of instances of non-compliance;
2. Setting, review and adjustment of tariffs and tariff structures in the energy sector;
3. Monitor and enforce sector utility regulatory performance targets, especially the performance of licensees in the electric power sub-sector;
4. Develop and review regulatory accounting regulations and tariff codes;
5. Maintain oversight on petroleum, electricity and renewable energy subsectors operations with a view to enforcing fair play and competition;
6. Monitoring and evaluation of the status of competition in the energy sector;
7. Analyze statutory trading arrangements; including electric power purchase agreements, and network service contracts;
8. Coordinate continuous financial reporting by regulated utilities as well as timely review of those financial returns;
9. Co-ordinate the setting, review, adjustment, and investigation on implementation of electricity tariffs and structure;
10. Enforce compliance with regulatory accounting regulations and tariff codes;
11. Participate in the analysis of petroleum refining, storage and pipeline transportation contracts;
12. Monitor and evaluate financial performance of regulated utilities;
13. Participate in the computation and setting of price caps for selected petroleum products;
14. Compute pass-through electricity costs including FCC, FERFA, Inflation adjustments, WARMA;
15. Undertaking audits for pass-through electricity costs including FCC, WARMA, FERFA & Inflation adjustments;
16. Conduct studies of various utility applications and conducting rate analysis and assist with rates computation;
17. Participate in regulatory research in the sector on emerging topical issues that inform policy dispensation in the sector;
18. Participating in designated Committees;
19. Supporting the preparation of the Sections Budgets; and 20. Supporting the development of Section’s Procurement Plans.

Qualifications
1. Bachelor’s Degree in any of the following disciplines: Economics, Econometrics, an Applied Economics Discipline, Finance or Business Studies, from a recognized university or equivalent qualification from a recognized institution;
2. Proficiency in Computer applications skills; and
3. Fulfilled the requirements of Chapter Six of the Constitution.

Job Experience: No Requirements

Work Hours: 8

Job application procedure
Mandatory Requirements for all Positions
Applicants MUST provide the following documents on application:
1. A Signed application letter;
2. A detailed Curriculum Vitae indicating their current and previous employers, positions held, current and expected salary, level of education and names of at least three professional referees, two of which must be working in the current organization;
3. Copies of academic and professional certificates;
4. Copy of Birth Certificate; and
5. Copy of National Identification Card.

Interested and qualified individuals are required to submit their applications, quoting the reference number, through email Recruitment22@epra.go.ke  not later than 5.00 p.m. on 31st July 2022, addressed to the undersigned:

The Director General,
Energy & Petroleum Regulatory Authority (EPRA), P.O Box 42681 - 00100, Nairobi.

EPRA is an equal opportunity employer. Youth, female candidates, Persons with Disability (PWD) and marginalized are strongly encouraged to apply.

ONLY SHORTLISTED CANDIDATES WILL BE CONTACTED.

Shortlisted candidates will be required to avail original and copy of application letter, Curriculum Vitae; certified copies of the relevant academic and professional certificates; national identity card; birth certificate and valid clearance certificates from KRA; HELB; EACC; Credit Reference Bureau and Kenya Police as per chapter six of the Constitution during the interview.


All Jobs

QUICK ALERT SUBSCRIPTION

Job Info
Job Category: Accounting/ Finance jobs in Kenya
Job Type: Full-time
Deadline of this Job: 31 July 2022
Duty Station: Nairobi
Posted: 04-07-2022
No of Jobs: 1
Start Publishing: 04-07-2022
Stop Publishing (Put date of 2030): 04-07-2065
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
59.775MBMemory Usage505msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.28-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:63 [ "USER" => "greatkenyanjobs" "HOME" => "/home/greatkenyanjobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744489094 "last" => 1744489094...
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) (25.67ms)
  • afterInitialise (11.09MB) (89.33ms)
  • afterRoute (5.02MB) (36.93ms)
  • beforeRenderComponent com_jsjobs (9.48KB) (236μs)
  • afterRenderComponent com_jsjobs (3.08MB) (35.5ms)
  • Before Access::preloadComponents (all components) (304.89KB) (7.52ms)
  • After Access::preloadComponents (all components) (132.67KB) (1.18ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (24μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (371μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.37MB) (32.31ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.48MB) (81.67ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (8μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (394μs)
  • afterDispatch (76.48KB) (127μs)
  • afterRender (13.83MB) (194ms)
  • 1 x afterRender (13.83MB) (38.34%)
    193.74ms
    1 x afterInitialise (11.09MB) (17.68%)
    89.33ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.48MB) (16.16%)
    81.67ms
    1 x afterRoute (5.02MB) (7.31%)
    36.93ms
    1 x afterRenderComponent com_jsjobs (3.08MB) (7.03%)
    35.50ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.37MB) (6.39%)
    32.31ms
    1 x afterLoad (4.12MB) (5.08%)
    25.67ms
    1 x Before Access::preloadComponents (all components) (304.89KB) (1.49%)
    7.52ms
    1 x After Access::preloadComponents (all components) (132.67KB) (0.23%)
    1.18ms
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.08%)
    394μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.07%)
    371μs
    1 x beforeRenderComponent com_jsjobs (9.48KB) (0.05%)
    236μs
    1 x afterDispatch (76.48KB) (0.03%)
    127μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    24μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    8μs
87 statements were executed, 23 of which were duplicates, 64 unique42.68ms236KB
  • SELECT @@SESSION.sql_mode;57μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?90μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 193μ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)1.17ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`86μ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` = :guest129μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'102μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`92μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'202μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config99μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'96μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'57μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'55μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'52μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Pricing-Analyst-job-at-Energy-and-Petroleum-Regulatory-Authority-EPRA-63066%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Pricing-Analyst-job-at-Energy-and-Petroleum-Regulatory-Authority-EPRA-63066%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Pricing-Analyst-job-at-Energy-and-Petroleum-Regulatory-Authority-EPRA-63066%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC198μ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.id160μs1.2KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'285μs6.44KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'223μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'207μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'265μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'206μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'63μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'78μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'277μ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 = 63066558μs36.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'222μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 63066322μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'207μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering285μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'226μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'239μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering268μs4.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'206μs12.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'233μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'60μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'57μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'274μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'202μs1.02KB/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'51μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2152μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2151μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'579μ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'575μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2163μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2134μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2156μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'270μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'262μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'206μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering171μ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)716μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0149μs904B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22122μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24219μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 36110μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 37185μ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` = 0139μ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.lft395μ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.lft195μ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.lft494μ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-Pricing-Analyst-job-at-Energy-and-Petroleum-Regulatory-Authority-EPRA-63066' AND `published` = 1179μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-Pricing-Analyst-job-at-Energy-and-Petroleum-Regulatory-Authority-EPRA-63066'71μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration294μs24.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'116μs10.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field137μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'73μ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` = 191μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'145μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`223μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'106μ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 desc249μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`252μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid113μ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` = :muserid123μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-Pricing-Analyst-job-at-Energy-and-Petroleum-Regulatory-Authority-EPRA-63066'129μ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` = 1116μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"229μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES713μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin89μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin67μ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`107μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'137μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'264μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 367382μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?69μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?25.15ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy