Computer It Jobs at Poa Internet and Regen Organics

Whatsapp
Software Engineer job at Poa Internet


Deadline of this Job: 27 January 2023
JOB DETAILS:

Overall Responsibility
The role has the responsibility to develop software systems, micro-services, tools, scripts, and Android apps. It will involve documenting the use of frameworks and libraries as well as documenting the existing and newly created code base. The role will also involve implementing agreed upon software quality assurance standards & development/staging/production workflows using GitHub.

Key SMART Results for A-Player
• Document existing software systems (Admin, Monitor, CRM) , to be consumed by both tech and non-tech staff , following agreed upon standards and tools- Q1 2023
• Implement the road-map for internal software development, and the workflow using GitHub to support multiple developers in development, testing, staging, and production environments- Q1 2023
• Implement Poa! share software project in a timely manner , ensuring proper documentation and aligned to agreed upon software quality- Q1 2023
• Implement Poa ! flat software project in a timely manner , ensuring proper documentation and aligned to agreed upon- Q2 2023
• Implement data warehouse pipelines incorporating all Poa! Software ecosystem into a Data lake /Data Mart- Q3 2023
• Successful migration (Go live) of current OSS/BSS platform from Admin v2 to Adminv3 by June 2023- Q2 2023
• Implement a mass-SMS micro-service against Africastalking API and Admin v3- Q2 2023
• Develop a micro-service for CPE and RF equipment provisioning, which works with our existing provisioning app, and which creates new devices in Inventory and Admin v3- Q3 2023
• Extract the functionality of our CRM system from our current OSS/BSS Admin v2 and implement a microservice against OSS/BSS Admin v3 - Q2 2023
• Develop an Android App for staff use, featuring all CRM functionality (survey, install, activate, etc.) - Q4 2023

Key Competencies Criticality (H, M, L)
• Specify, develop, test, and bring into production complex software systems with minimum supervision- H
• Solid knowledge of software development using Python, PHP + HTML/CSS/JS native code - H
• Basic Understanding network systems, IP stack, communication protocols at Layer 2 and Layer 3 - L
• Excellent knowledge with databases (MySQL / SQLite/Redis) and related concepts e.g Data Modelling , SQL ,Database optimization, ETL process- H
• Communicate in real time with other team members during development and testing of software and also in a clear and concise manner that is easy to understand for non-tech personnel alike - M
• Debug complex software issues that may span multiple systems -M
• Demonstrated ability to quickly learn new technologies and concepts and apply them in your day to day problem solving activities - M

Mandatory Criteria if Any with no exceptions to hire.
• Must be aligned with similar Values and DNA to Poa! to ensure cultural alignment
• Must have developed software in PHP and JavaScript, and used HTML/CSS in front-end development
• Must have developed shell scripts (bash), python, and PHP cli scripts
• Must have deep knowledge of HTTP/REST and other API protocols, and use of tools such as Postman
• Must have experience documenting software systems e.g API documentation, ERD design documentation,SDK documentation, Test Schedules

Process Design Engineer job at Regen Organics

Deadline of this Job: 13 January 2023
JOB DETAILS:

About the role
Regen Organics is looking for a Process Design Fellow/Intern who will work under a Process Engineer and will be responsible for applying engineering principles and techniques to optimize the production processes in the manufacturing environment to meet organisational objectives.

Duties and Responsibilities
• Perform hydraulic calculations to determine line sizes, pump specifications, and control valve sizing.
• Perform heat transfer calculations to determine heat exchanger duty requirements and sizing.
• Develop piping and instrumentation diagrams (P&ID) for different processing units, including details such as line sizes, control valves, isolation valves, and control logic.
• Participate in and lead a P & ID review session.
• Participate in Hazard and Operability (HAZOP) studies.
• Create close-out reports for P&ID review sessions and HAZOP sessions.
• Contribute to reviews of vendor documentation and other discipline documents.
• Develop linelists and set hydrotest boundary limits.
• Create operating guidelines and start-up/commissioning procedures.
• Interact with other disciplines and vendors to ensure design accuracy.
• Lead Equipment installation, commissioning, operator training, and handover.
• Audit site operations to ensure equipment work instructions have been fully adopted.

Qualifications
• Bachelor's degree in Chemical, Manufacturing, or Industrial Engineering
• Good understanding of chemical engineering concepts specifically fluid dynamics and heat transfer models
• Experience developing or contributing to control philosophies and operating guidelines
• Experience developing or contributing to the sizing of processing equipment such as pumps, blowers, heat exchangers, piping systems, and control valves
• Detail-oriented with demonstrated capability to analyze processing systems efficiently and rapidly
• Ability to look beyond the most obvious solution to provide engineering designs that are safe, practical, reliable, and cost-effective
• A learning mindset and interest in taking on board constructive feedback from senior engineers in order to develop their process engineering expertise while delivering solutions that meet design requirements and stakeholder expectations
• A proactive attitude, with a willingness to get involved and learn by doing
• Ability to communicate clearly in both verbal and written form
Whatsapp
J! InfoRequestSessionProfileQueries62
60.401MBMemory Usage352msRequest 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:65 [ "USER" => "greatkenyanjobs" "HOME" => "/home/greatkenyanjobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1749707445 "last" => 1749707445...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
JSItemid
"190"
  • afterLoad (4.12MB) (25.6ms)
  • afterInitialise (11.17MB) (60.67ms)
  • afterRoute (4.66MB) (26.2ms)
  • beforeRenderComponent com_content (28.73KB) (206μs)
  • Before Access::preloadComponents (all components) (307.09KB) (2.7ms)
  • After Access::preloadComponents (all components) (196.42KB) (780μs)
  • Before Access::preloadPermissions (com_content) (4.23KB) (17μs)
  • After Access::preloadPermissions (com_content) (1.8MB) (4.43ms)
  • Before Access::getAssetRules (id:4132 name:com_content.article.2632) (130.8KB) (123μs)
  • After Access::getAssetRules (id:4132 name:com_content.article.2632) (26.84KB) (416μs)
  • afterRenderComponent com_content (2.31MB) (28.05ms)
  • Before Access::getAssetRules (id:1 name:root.1) (1MB) (9.4ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.95KB) (36μs)
  • afterDispatch (592.2KB) (8.23ms)
  • afterRender (29.95MB) (184ms)
  • 1 x afterRender (29.95MB) (52.33%)
    184.10ms
    1 x afterInitialise (11.17MB) (17.25%)
    60.67ms
    1 x afterRenderComponent com_content (2.31MB) (7.98%)
    28.05ms
    1 x afterRoute (4.66MB) (7.45%)
    26.20ms
    1 x afterLoad (4.12MB) (7.28%)
    25.60ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (1MB) (2.67%)
    9.40ms
    1 x afterDispatch (592.2KB) (2.34%)
    8.23ms
    1 x After Access::preloadPermissions (com_content) (1.8MB) (1.26%)
    4.43ms
    1 x Before Access::preloadComponents (all components) (307.09KB) (0.77%)
    2.70ms
    1 x After Access::preloadComponents (all components) (196.42KB) (0.22%)
    780μs
    1 x After Access::getAssetRules (id:4132 name:com_content.article.2632) (26.84KB) (0.12%)
    416μs
    1 x beforeRenderComponent com_content (28.73KB) (0.06%)
    206μs
    1 x Before Access::getAssetRules (id:4132 name:com_content.article.2632) (130.8KB) (0.03%)
    123μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.95KB) (0.01%)
    36μs
    1 x Before Access::preloadPermissions (com_content) (4.23KB) (0%)
    17μs
62 statements were executed, 9 of which were duplicates, 53 unique13.26ms458.88KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4
  • SELECT @@SESSION.sql_mode;54μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?95μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 172μ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)222μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`90μ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` = :guest118μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'95μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`68μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'141μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config103μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'70μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'72μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'58μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'57μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F2632-computer-it-jobs-at-poa-internet-and-regen-organics%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F2632-computer-it-jobs-at-poa-internet-and-regen-organics%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F2632-computer-it-jobs-at-poa-internet-and-regen-organics%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC229μs4.23KB/plugins/system/jlexblock/jlexblock.php:147Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`395μs21.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F2632-computer-it-jobs-at-poa-internet-and-regen-organics%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Frelated-jobs%2F2632-computer-it-jobs-at-poa-internet-and-regen-organics%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Frelated-jobs%2F2632-computer-it-jobs-at-poa-internet-and-regen-organics%2F')=1) OR `list_var` LIKE '%com_content%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC252μs6.8KB/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.id158μs1.2KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • 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)452μs8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `icop0_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.29ms173.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `icop0_content`340μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `icop0_content` SET `hits` = (`hits` + 1) WHERE `id` = '2632'349μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `icop0_content` AS `a` INNER JOIN `icop0_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `icop0_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `icop0_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `icop0_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `icop0_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)358μs24.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`290μs21.2KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `icop0_contentitem_tag_map` AS `m` INNER JOIN `icop0_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3)404μs5.27KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id110μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `icop0_content` WHERE `id` = :id74μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`263μs21.2KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'214μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'184μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'196μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering177μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 098μs11.87KB/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2294μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2487μ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` = 0102μ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.lft421μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/related-jobs/2632-computer-it-jobs-at-poa-internet-and-regen-organics' AND `published` = 1156μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/related-jobs/2632-computer-it-jobs-at-poa-internet-and-regen-organics'79μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration301μs24.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'115μs2.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'77μ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` = 1102μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'161μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`286μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'51μs912B/libraries/src/Table/Table.php:755Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `icop0_content` AS `a` INNER JOIN `icop0_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `icop0_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `icop0_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `icop0_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `icop0_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)324μs24.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `icop0_categories` AS `s` INNER JOIN `icop0_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`352μs21.2KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM icop0_fields AS a LEFT JOIN `icop0_languages` AS l ON l.lang_code = a.language LEFT JOIN icop0_users AS uc ON uc.id=a.checked_out LEFT JOIN icop0_viewlevels AS ag ON ag.id = a.access LEFT JOIN icop0_users AS ua ON ua.id = a.created_user_id LEFT JOIN icop0_fields_groups AS g ON g.id = a.group_id LEFT JOIN `icop0_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7,:preparedArray8)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC752μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'content' AND a.appview IN ('article','*') ORDER BY a.id desc141μs2.05KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc143μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/related-jobs/2632-computer-it-jobs-at-poa-internet-and-regen-organics'81μ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` = 166μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"369μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES996μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin100μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin82μ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`93μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?119μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?279μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy