career logo round

Accounts Receivable Intern

 

Company Description

BIC® products are recognized all over the world for their quality, safety, affordability and ease of use. The ballpoint pen, the pocket lighter, and the shaver are all part of the daily lives of millions of consumers. These products make BIC® an iconic international brand, present in more than 4 million retail outlets in more than 160 countries around the world.

BIC Services Sofia, BIC’s first worldwide Shared Service Center that acts as a highly efficient

internal service provider offering a full range of tools and services that help BIC increase its

efficiency and achieve sustainable growth. It consolidates administrative tasks and activities

within BIC’s European Finance, Accounting, Reporting, Transactional Procurement, Customer

Service and other corporate functions in Europe, like HR and Project Quality Control.


Job Description

Collections Management:

  • Ensure customer payments are received on time by performing effective customer contacts and collecting outstanding receivables.
  • Ensure ongoing Follow up of overdue receivables, balance confirmations, interaction, and clarification with customers.

Accounts Receivable: 

  • Ensure all customer incoming payments are allocated timely and correctly to customer accounts, incoming cash accounts and customer accounts are reconciled, and any unreconciled items are followed up and resolved

Qualifications

  • Willingness for self-development
  • Highly motivated with the drive to make a difference and challenge the status quo
  • Self-drive to take a task to its resolution
  • High interpersonal skills to effectively coordinate/ communicate simultaneously with multiple stakeholders in the persuasion of a shared goal
  • Ability to work with a broad spectrum of people across various cultures
  • Accuracy and detail-oriented

What we offer

  • To Obtain Skills In: Written Communication Skills, Verbal Communication Skills, Interpersonal Effectiveness, Building Collaborative Relationships, Teamwork, Client-oriented Behavior, Entrepreneurial Orientation, Continuous Improvement Mindset, Analytical Thinking, Attention to Detail, Initiative, Results Orientation, Compliance Focus, Self-organization & Planning Skills, Time Management Skills, Prioritization Skills, Problem-Solving Skills, Ability to work in a dynamic environment, Ability to work independently, Ability to handle stress, Personal Credibility, Personal Judgement, Reliability, Flexibility, Adaptivity
  • Gain Knowledge In: Finance and Accounting processes, Overdue Control, Payment Processing, Outstanding Receivables Collection, Timely Issue Resolution, Establishing positive and trusted customer relationships, Ensuring data accuracy and completeness, Logical Thinking, Accountability, Empathy, MS Office 365, SharePoint, JD Edwards, ServiceNow, SHOWCASE, IVR
  • Our benefits:
  1. Hybrid model of working;
  2. Food Vouchers - 200 BGN;
  3. Transportation and Communication Allowance – 60 BGN or equivalent;
  4. Training materials;
  5. Coffee, Fruits and Healthy Food in the office.

Кандидатствай тук: https://www.jobs.bg/job/7755496

19MBMemory Usage1.05sRequest 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" => 1743554146 "last" => 1743554146...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => null ...
  • afterLoad (3.75MB) (56.04ms)
  • afterInitialise (6.99MB) (87.76ms)
  • afterRoute (1.03MB) (11.72ms)
  • beforeRenderComponent com_content (450.35KB) (5.33ms)
  • Before Access::preloadComponents (all components) (457.13KB) (4.57ms)
  • After Access::preloadComponents (all components) (104.54KB) (622μs)
  • Before Access::preloadPermissions (com_content) (1.45KB) (13μs)
  • After Access::preloadPermissions (com_content) (475.31KB) (1.38ms)
  • Before Access::getAssetRules (id:836 name:com_content.article.694) (18.65KB) (53μs)
  • After Access::getAssetRules (id:836 name:com_content.article.694) (91.13KB) (328μs)
  • afterRenderComponent com_content (2.74MB) (39.74ms)
  • afterDispatch (2.19KB) (151μs)
  • beforeRenderRawModule mod_menu (Main Menu) (472.35KB) (5.13ms)
  • afterRenderRawModule mod_menu (Main Menu) (473.95KB) (12.35ms)
  • beforeRenderRawModule mod_finder (Search) (896B) (36μs)
  • afterRenderRawModule mod_finder (Search) (508.01KB) (8.05ms)
  • beforeRenderRawModule mod_custom (CopyrightBG) (464B) (43μs)
  • afterRenderRawModule mod_custom (CopyrightBG) (5.21KB) (632μs)
  • beforeRenderModule mod_custom (CopyrightBG) (25.48KB) (367μs)
  • afterRenderModule mod_custom (CopyrightBG) (1.84KB) (312μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (528B) (46μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (19.34KB) (1.04ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.37KB) (117μs)
  • beforeRenderModule mod_finder (Search) (1.98KB) (32μs)
  • afterRenderModule mod_finder (Search) (1.21KB) (73μs)
  • beforeRenderModule mod_menu (Main Menu) (2.23KB) (28μs)
  • afterRenderModule mod_menu (Main Menu) (1.21KB) (72μs)
  • beforeRenderRawModule mod_custom (Logo_menu) (1.06KB) (25μs)
  • afterRenderRawModule mod_custom (Logo_menu) (992B) (331μs)
  • beforeRenderModule mod_custom (Logo_menu) (720B) (12μs)
  • afterRenderModule mod_custom (Logo_menu) (1.21KB) (113μs)
  • afterRender (378.57KB) (11.48ms)
  • 1 x afterInitialise (6.99MB) (8.34%)
    87.76ms
    1 x afterLoad (3.75MB) (5.33%)
    56.04ms
    1 x afterRenderComponent com_content (2.74MB) (3.78%)
    39.74ms
    1 x afterRenderRawModule mod_menu (Main Menu) (473.95KB) (1.17%)
    12.35ms
    1 x afterRoute (1.03MB) (1.11%)
    11.72ms
    1 x afterRender (378.57KB) (1.09%)
    11.48ms
    1 x afterRenderRawModule mod_finder (Search) (508.01KB) (0.77%)
    8.05ms
    1 x beforeRenderComponent com_content (450.35KB) (0.51%)
    5.33ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (472.35KB) (0.49%)
    5.13ms
    1 x Before Access::preloadComponents (all components) (457.13KB) (0.43%)
    4.57ms
    1 x After Access::preloadPermissions (com_content) (475.31KB) (0.13%)
    1.38ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (19.34KB) (0.1%)
    1.04ms
    1 x afterRenderRawModule mod_custom (CopyrightBG) (5.21KB) (0.06%)
    632μs
    1 x After Access::preloadComponents (all components) (104.54KB) (0.06%)
    622μs
    1 x beforeRenderModule mod_custom (CopyrightBG) (25.48KB) (0.03%)
    367μs
    1 x afterRenderRawModule mod_custom (Logo_menu) (992B) (0.03%)
    331μs
    1 x After Access::getAssetRules (id:836 name:com_content.article.694) (91.13KB) (0.03%)
    328μs
    1 x afterRenderModule mod_custom (CopyrightBG) (1.84KB) (0.03%)
    312μs
    1 x afterDispatch (2.19KB) (0.01%)
    151μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.37KB) (0.01%)
    117μs
    1 x afterRenderModule mod_custom (Logo_menu) (1.21KB) (0.01%)
    113μs
    1 x afterRenderModule mod_finder (Search) (1.21KB) (0.01%)
    73μs
    1 x afterRenderModule mod_menu (Main Menu) (1.21KB) (0.01%)
    72μs
    1 x Before Access::getAssetRules (id:836 name:com_content.article.694) (18.65KB) (0.01%)
    53μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (528B) (0%)
    46μs
    1 x beforeRenderRawModule mod_custom (CopyrightBG) (464B) (0%)
    43μs
    1 x beforeRenderRawModule mod_finder (Search) (896B) (0%)
    36μs
    1 x beforeRenderModule mod_finder (Search) (1.98KB) (0%)
    32μs
    1 x beforeRenderModule mod_menu (Main Menu) (2.23KB) (0%)
    28μs
    1 x beforeRenderRawModule mod_custom (Logo_menu) (1.06KB) (0%)
    25μs
    1 x Before Access::preloadPermissions (com_content) (1.45KB) (0%)
    13μs
    1 x beforeRenderModule mod_custom (Logo_menu) (720B) (0%)
    12μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0%)
    5μs
33 statements were executed, 3 of which were duplicates, 30 unique13.01ms179.63KB
  • SELECT @@SESSION.sql_mode;97μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
  • SELECT `data` FROM `k26uj_session` WHERE `session_id` = ?272μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `k26uj_session` WHERE `session_id` = :session_id LIMIT 1251μ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)1.2ms944BParams/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` = 1304μs1.61KB/libraries/src/Component/ComponentHelper.php:429Copy
  • SELECT `id`,`rules` FROM `k26uj_viewlevels`111μ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` = :guest149μ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`470μs3.48KBParams/libraries/src/Plugin/PluginHelper.php:302Copy
  • SELECT * FROM `k26uj_nextend2_section_storage` WHERE `application` = 'smartslider' AND `section` = 'settings'224μ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`398μ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`334μs3.89KBParams/libraries/src/Categories/Categories.php:369Copy
  • SELECT `id` FROM `k26uj_content` WHERE `alias` = :alias AND `catid` = :catid163μ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` = :element168μs1.48KBParams/libraries/src/Helper/LibraryHelper.php:162Copy
  • UPDATE `k26uj_extensions` SET `params` = :params WHERE `type` = 'library' AND `element` = :element143μs880BParams/libraries/src/Helper/LibraryHelper.php:126Copy
  • SELECT * FROM `k26uj_languages` WHERE `published` = 1 ORDER BY `ordering` ASC173μ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` = 1176μ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)350μ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` = 0661μs49.48KBParams/libraries/src/Access/Access.php:309Copy
  • SHOW FULL COLUMNS FROM `k26uj_content`306μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • UPDATE k26uj_content SET `hits` = (`hits` + 1) WHERE `id` = '694'1.01ms48B/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)312μs6.12KBParams/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`282μs3.94KBParams/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)234μ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`278μs3.94KBParams/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 ASC681μ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` = :itemid159μ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 DESC1.79ms20.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`449μs3.94KBParams/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`576μs1.91KBParams/libraries/src/Cache/Controller/CallbackController.php:52Copy
  • SELECT `name`,`element` FROM `k26uj_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1432μ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)275μ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` desc306μ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` desc277μs5.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:422Copy