career logo round

 Partners & Affiliates Program Manager Sofia 

YOUR ROLE:
  • We are looking for a Partners & Affiliates Program Manager to join our Marketing Growth team and lead a team of experienced professionals who deal with SiteGround's partners and affiliates directly. The selected candidate will be responsible for identifying, evaluating and optimizing partnership and affiliate opportunities, and ensuring the partnership program performance and growth.
YOUR RESPONSIBILITIES:
  • Lead the team of Affiliate and Partnership Managers and ensure that all team goals are met; 
  • Outline and execute comprehensive insight-driven strategies to ensure the partnership program’s success and growth; 
  • Identify new affiliate opportunities, partnerships and prospects to grow the program; 
  • Evaluate program performance, partnership status and events; 
  • Оptimize affiliate and partnership campaigns and incentives for maximum success; 
  • Oversee and manage the program budget to optimize acquisition and maintenance cost;
  • Stay up to date with the competitors’ landscape and latest industry trends; 
  • Directly communicate and maintain relationships with our most important partners and affiliates; 
  • Advise Affiliate and Partnership Managers on negotiations and case handling, when necessary; 
  • Work with the rest of the marketing team to optimize affiliate performance; 
  • Regularly monitor affiliate performance and recognize opportunities for improvement;
  • Work with the Legal and Finance team to close partnership agreements; 
  • Participate, attend or speak at events with the purpose of identifying and connecting with new partners, recruiting affiliates or promoting the program;
  • Prepare regular reports about the program performance, partnership status and events. 
OUR EXPECTATIONS:
  • At least 3 years experience in strategic partnerships, affiliate marketing at a large scale or similar;
  • Excellent sales and negotiation skills - both written and verbal, in one on one and team environments; 
  • Solid understanding of the affiliate industry; 
  • Strong analytical skills with the ability to read, understand and take actions based on performance data; 
  • Ability to effectively manage multiple tasks with intertwining deadlines;
  • Purpose-driven, self-motivated and focused;
  • Good people management skills; 
  • Fluent in English. 
ADVANTAGES:
  • Experience at an IT/software company or understanding of the hosting industry and hosting affiliate programs in particular;
  • Managerial experience;
  • Experience as a digital marketer; 
  • Experience working with social media influencers;
  • Very good command of Spanish, Italian or German.
WHAT WE OFFER:
  • Working on in-house built products, using the latest technologies;
  • Competitive salary with achievement bonus;
  • Premium Health Insurance plan;
  • Employee Assistance program;
  • Аdditional trainings to upskill your job competencies;
  • Sponsorship to attend worldwide conferences with full company coverage of business expenses;
  • Free company restaurant with our own chef team;
  • Free access to our in-office gym with professional instructors (including Table tennis, Yoga, Pilates, HIIT, Prama classes and more);
  • Multisport or CoolFit card;
  • Additional days off for long service and volunteering;
  • Reduced working hours every Friday.
  •  APPLY FOR THIS JOB - https://jobs.lever.co/siteground/4a260c72-75ce-472b-a968-31ec224ab70b/apply
19MBMemory Usage899msRequest Duration
Joomla! Version4.1.2
PHP Version8.3.12
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
11.3.2-MariaDB
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "PHPDEBUGBAR_STACK_DATA" => [] ]
$_COOKIE
[]
$_SERVER
array:44 [ "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "career.swu.bg" "REDIRECT_STATUS...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743885942 "last" => 1743885942...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => null ...
  • afterLoad (3.75MB) (53.5ms)
  • afterInitialise (6.99MB) (76.29ms)
  • afterRoute (1.02MB) (11.53ms)
  • beforeRenderComponent com_content (450.33KB) (6.43ms)
  • Before Access::preloadComponents (all components) (457.13KB) (4.8ms)
  • After Access::preloadComponents (all components) (104.54KB) (658μs)
  • Before Access::preloadPermissions (com_content) (1.45KB) (14μs)
  • After Access::preloadPermissions (com_content) (475.8KB) (1.44ms)
  • Before Access::getAssetRules (id:916 name:com_content.article.765) (18.65KB) (33μs)
  • After Access::getAssetRules (id:916 name:com_content.article.765) (91.13KB) (349μs)
  • afterRenderComponent com_content (2.71MB) (42.35ms)
  • afterDispatch (2.19KB) (133μs)
  • beforeRenderRawModule mod_menu (Main Menu) (472.35KB) (4.95ms)
  • afterRenderRawModule mod_menu (Main Menu) (473.88KB) (12.36ms)
  • beforeRenderRawModule mod_finder (Search) (896B) (35μs)
  • afterRenderRawModule mod_finder (Search) (508.01KB) (7.76ms)
  • beforeRenderRawModule mod_custom (CopyrightBG) (464B) (45μs)
  • afterRenderRawModule mod_custom (CopyrightBG) (5.21KB) (643μs)
  • beforeRenderModule mod_custom (CopyrightBG) (25.48KB) (329μs)
  • afterRenderModule mod_custom (CopyrightBG) (1.84KB) (271μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (528B) (43μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (16.33KB) (915μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.43KB) (135μs)
  • beforeRenderModule mod_finder (Search) (1.98KB) (35μs)
  • afterRenderModule mod_finder (Search) (1.21KB) (147μs)
  • beforeRenderModule mod_menu (Main Menu) (2.23KB) (35μs)
  • afterRenderModule mod_menu (Main Menu) (1.21KB) (81μs)
  • beforeRenderRawModule mod_custom (Logo_menu) (1.06KB) (26μs)
  • afterRenderRawModule mod_custom (Logo_menu) (992B) (313μs)
  • beforeRenderModule mod_custom (Logo_menu) (720B) (3μs)
  • afterRenderModule mod_custom (Logo_menu) (1.21KB) (103μs)
  • afterRender (374.57KB) (11.4ms)
  • 1 x afterInitialise (6.99MB) (8.49%)
    76.29ms
    1 x afterLoad (3.75MB) (5.95%)
    53.50ms
    1 x afterRenderComponent com_content (2.71MB) (4.71%)
    42.35ms
    1 x afterRenderRawModule mod_menu (Main Menu) (473.88KB) (1.38%)
    12.36ms
    1 x afterRoute (1.02MB) (1.28%)
    11.53ms
    1 x afterRender (374.57KB) (1.27%)
    11.40ms
    1 x afterRenderRawModule mod_finder (Search) (508.01KB) (0.86%)
    7.76ms
    1 x beforeRenderComponent com_content (450.33KB) (0.72%)
    6.43ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (472.35KB) (0.55%)
    4.95ms
    1 x Before Access::preloadComponents (all components) (457.13KB) (0.53%)
    4.80ms
    1 x After Access::preloadPermissions (com_content) (475.8KB) (0.16%)
    1.44ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (16.33KB) (0.1%)
    915μs
    1 x After Access::preloadComponents (all components) (104.54KB) (0.07%)
    658μs
    1 x afterRenderRawModule mod_custom (CopyrightBG) (5.21KB) (0.07%)
    643μs
    1 x After Access::getAssetRules (id:916 name:com_content.article.765) (91.13KB) (0.04%)
    349μs
    1 x beforeRenderModule mod_custom (CopyrightBG) (25.48KB) (0.04%)
    329μs
    1 x afterRenderRawModule mod_custom (Logo_menu) (992B) (0.03%)
    313μs
    1 x afterRenderModule mod_custom (CopyrightBG) (1.84KB) (0.03%)
    271μs
    1 x afterRenderModule mod_finder (Search) (1.21KB) (0.02%)
    147μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.43KB) (0.02%)
    135μs
    1 x afterDispatch (2.19KB) (0.01%)
    133μs
    1 x afterRenderModule mod_custom (Logo_menu) (1.21KB) (0.01%)
    103μs
    1 x afterRenderModule mod_menu (Main Menu) (1.21KB) (0.01%)
    81μs
    1 x beforeRenderRawModule mod_custom (CopyrightBG) (464B) (0.01%)
    45μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (528B) (0%)
    43μs
    1 x beforeRenderRawModule mod_finder (Search) (896B) (0%)
    35μs
    1 x beforeRenderModule mod_finder (Search) (1.98KB) (0%)
    35μs
    1 x beforeRenderModule mod_menu (Main Menu) (2.23KB) (0%)
    35μs
    1 x Before Access::getAssetRules (id:916 name:com_content.article.765) (18.65KB) (0%)
    33μs
    1 x beforeRenderRawModule mod_custom (Logo_menu) (1.06KB) (0%)
    26μs
    1 x Before Access::preloadPermissions (com_content) (1.45KB) (0%)
    14μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Logo_menu) (720B) (0%)
    3μs
33 statements were executed, 3 of which were duplicates, 30 unique15.46ms232.57KB
  • SELECT @@SESSION.sql_mode;59μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
  • SELECT `data` FROM `k26uj_session` WHERE `session_id` = ?180μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `k26uj_session` WHERE `session_id` = :session_id LIMIT 1107μs1.3KBParams/libraries/src/Session/MetadataManager.php:191Copy
  • INSERT INTO `k26uj_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)887μs944BParams/libraries/src/Session/MetadataManager.php:269Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `k26uj_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1327μs1.61KB/libraries/src/Component/ComponentHelper.php:429Copy
  • SELECT `id`,`rules` FROM `k26uj_viewlevels`158μs656B/libraries/src/Access/Access.php:1026Copy
  • SELECT `b`.`id` FROM `k26uj_usergroups` AS `a` LEFT JOIN `k26uj_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest178μs1.33KBParams/libraries/src/Access/Access.php:935Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `k26uj_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`527μs3.48KBParams/libraries/src/Plugin/PluginHelper.php:302Copy
  • SELECT * FROM `k26uj_nextend2_section_storage` WHERE `application` = 'smartslider' AND `section` = 'settings'248μs1.5KB/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `k26uj_menu` AS `m` LEFT JOIN `k26uj_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`537μs36.05KBParams/libraries/src/Menu/SiteMenu.php:155Copy
  • 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 `k26uj_categories` AS `s` INNER JOIN `k26uj_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`318μs3.88KBParams/libraries/src/Categories/Categories.php:369Copy
  • SELECT `id` FROM `k26uj_content` WHERE `alias` = :alias AND `catid` = :catid239μs1.34KBParams/components/com_content/src/Service/Router.php:274Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `k26uj_extensions` WHERE `type` = 'library' AND `element` = :element257μs1.48KBParams/libraries/src/Helper/LibraryHelper.php:162Copy
  • UPDATE `k26uj_extensions` SET `params` = :params WHERE `type` = 'library' AND `element` = :element970μs880BParams/libraries/src/Helper/LibraryHelper.php:126Copy
  • SELECT * FROM `k26uj_languages` WHERE `published` = 1 ORDER BY `ordering` ASC227μs1.56KB/libraries/src/Language/LanguageHelper.php:156Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `k26uj_template_styles` AS `s` LEFT JOIN `k26uj_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1248μs832B/libraries/src/Application/SiteApplication.php:488Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `k26uj_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)377μs8.69KBParams/libraries/src/Access/Access.php:369Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `k26uj_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0743μs49.48KBParams/libraries/src/Access/Access.php:309Copy
  • SHOW FULL COLUMNS FROM `k26uj_content`303μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • UPDATE k26uj_content SET `hits` = (`hits` + 1) WHERE `id` = '765'959μs48B/libraries/src/Table/Table.php:1441Copy
  • 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 `k26uj_content` AS `a` INNER JOIN `k26uj_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `k26uj_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `k26uj_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `k26uj_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `k26uj_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)377μs22.13KBParams/components/com_content/src/Model/ArticleModel.php:218Copy
  • 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 `k26uj_categories` AS `s` INNER JOIN `k26uj_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`347μs3.92KBParams/libraries/src/Categories/Categories.php:369Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `k26uj_contentitem_tag_map` AS `m` INNER JOIN `k26uj_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)395μs3.97KBParams/libraries/src/Helper/TagsHelper.php:389Copy
  • 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 `k26uj_categories` AS `s` INNER JOIN `k26uj_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`305μs3.92KBParams/libraries/src/Categories/Categories.php:369Copy
  • 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 k26uj_fields AS a LEFT JOIN `k26uj_languages` AS l ON l.lang_code = a.language LEFT JOIN k26uj_users AS uc ON uc.id=a.checked_out LEFT JOIN k26uj_viewlevels AS ag ON ag.id = a.access LEFT JOIN k26uj_users AS ua ON ua.id = a.created_user_id LEFT JOIN k26uj_fields_groups AS g ON g.id = a.group_id LEFT JOIN `k26uj_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,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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 ASC788μs4.88KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:148Copy
  • SELECT `field_id`,`value` FROM `k26uj_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4) AND `item_id` = :itemid174μs1.45KBParams/administrator/components/com_fields/src/Model/FieldModel.php:756Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `k26uj_content` AS `a` LEFT JOIN `k26uj_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC3.32ms57.72KBParams/plugins/content/pagenavigation/pagenavigation.php:196Copy
  • 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 `k26uj_categories` AS `s` INNER JOIN `k26uj_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`388μs3.92KBParams/libraries/src/Categories/Categories.php:369Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `k26uj_modules` AS `m` LEFT JOIN `k26uj_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `k26uj_extensions` AS `e` ON `e`.`element` = `m`.`module` AND `e`.`client_id` = `m`.`client_id` WHERE ( ( (`m`.`published` = 1 AND `e`.`enabled` = 1 AND `m`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`472μs1.91KBParams/libraries/src/Cache/Controller/CallbackController.php:52Copy
  • SELECT `name`,`element` FROM `k26uj_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1293μs656B/administrator/components/com_finder/src/Helper/LanguageHelper.php:138Copy
  • SELECT `title` FROM `k26uj_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)224μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `k26uj_scheduler_tasks` AS `a` LEFT JOIN `k26uj_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` desc254μs3.2KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:422Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `k26uj_scheduler_tasks` AS `a` LEFT JOIN `k26uj_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` desc276μs5.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:422Copy