Notice: file_put_contents(): Write of 49179 bytes failed with errno=28 No space left on device in /srv/http/rizov/career/libraries/src/Filesystem/File.php on line 472
INTERN DATA ANALYST

career logo round

INTERN DATA ANALYST

Детайли
Посещения: 47

INTERN DATA ANALYST

Because this is exactly what you are about to find here!

Our team is aware of how valuable it is to get support at the beginning of your career. That's why we take care to ensure various opportunities for all young colleagues to put their knowledge into practice while making their first professional steps.

By joining our Internship program, university students and recent graduates will be able to explore banking activities through diverse training and challenges from the real practice of our leading on-market financial institution.

The main responsibilities are:

  • Support the strategic, credit and integrated risk department in day-to-day tasks related to data manipulation, data analysis and data management automations;
  • Writes, tests, and executes scripts in order to support data preparation related to optimization of regular or ad-hoc data and portfolio analysis;
  • Support the reports preparation, automation, visualization and transformation to BI tools, namely PowerBI;
  • Creating detailed documentation outlining design and technical specifications of each data solution;
  • Getting exposure to the integration of diverse big data sources;
  • Support the credit risk lending infrastructure improvement.

We expect:

  • At least 3rd or 4th year student in the field of Economics, Mathematics, Statistics;
  • Interests in banking, data exploration and analysis , data mining;
  • Excellent knowledge of MS Office and SQL;
  • Knowledge or experience in Python, R, SAS, Power BI will be considered an advantage;
  • Fluency in English.

What do we offer you:

  • Flexible working hours - 4-8 hours;
  • Flexible internship duration 3-6 months or more;
  • Attractive payment;
  • To study and to learn from the best professionals in the field;
  • Being involved in exciting work on projects;
  • Possibility to stay on a permanent position after the internship;
  • Opportunities to get involved in various socially responsible initiatives;
  • A certificate after successfully completing your internship.

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

J! InfoRequestSessionProfileQueries33
19MBMemory Usage731msRequest 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" => 1743308534 "last" => 1743308534...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => null ...
  • afterLoad (3.75MB) (24.58ms)
  • afterInitialise (6.99MB) (63.42ms)
  • afterRoute (1.03MB) (12.16ms)
  • beforeRenderComponent com_content (450.36KB) (7.05ms)
  • Before Access::preloadComponents (all components) (457.13KB) (4.42ms)
  • After Access::preloadComponents (all components) (104.54KB) (1.02ms)
  • Before Access::preloadPermissions (com_content) (1.45KB) (11μs)
  • After Access::preloadPermissions (com_content) (474.34KB) (2.16ms)
  • Before Access::getAssetRules (id:858 name:com_content.article.716) (18.65KB) (49μs)
  • After Access::getAssetRules (id:858 name:com_content.article.716) (91.13KB) (328μs)
  • afterRenderComponent com_content (2.74MB) (41.43ms)
  • afterDispatch (2.19KB) (120μs)
  • beforeRenderRawModule mod_menu (Main Menu) (472.35KB) (4.71ms)
  • afterRenderRawModule mod_menu (Main Menu) (473.95KB) (11.98ms)
  • beforeRenderRawModule mod_finder (Search) (896B) (44μs)
  • afterRenderRawModule mod_finder (Search) (508.01KB) (7.59ms)
  • beforeRenderRawModule mod_custom (CopyrightBG) (464B) (42μs)
  • afterRenderRawModule mod_custom (CopyrightBG) (5.21KB) (642μs)
  • beforeRenderModule mod_custom (CopyrightBG) (25.48KB) (321μs)
  • afterRenderModule mod_custom (CopyrightBG) (1.84KB) (264μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (528B) (42μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (19.34KB) (1ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.37KB) (126μs)
  • beforeRenderModule mod_finder (Search) (1.98KB) (33μs)
  • afterRenderModule mod_finder (Search) (1.21KB) (72μs)
  • beforeRenderModule mod_menu (Main Menu) (2.23KB) (28μs)
  • afterRenderModule mod_menu (Main Menu) (1.21KB) (71μs)
  • beforeRenderRawModule mod_custom (Logo_menu) (1.06KB) (25μs)
  • afterRenderRawModule mod_custom (Logo_menu) (992B) (310μs)
  • beforeRenderModule mod_custom (Logo_menu) (720B) (3μs)
  • afterRenderModule mod_custom (Logo_menu) (1.21KB) (103μs)
  • afterRender (378.45KB) (10.84ms)
  • 1 x afterInitialise (6.99MB) (8.67%)
    63.42ms
    1 x afterRenderComponent com_content (2.74MB) (5.66%)
    41.43ms
    1 x afterLoad (3.75MB) (3.36%)
    24.58ms
    1 x afterRoute (1.03MB) (1.66%)
    12.16ms
    1 x afterRenderRawModule mod_menu (Main Menu) (473.95KB) (1.64%)
    11.98ms
    1 x afterRender (378.45KB) (1.48%)
    10.84ms
    1 x afterRenderRawModule mod_finder (Search) (508.01KB) (1.04%)
    7.59ms
    1 x beforeRenderComponent com_content (450.36KB) (0.96%)
    7.05ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (472.35KB) (0.64%)
    4.71ms
    1 x Before Access::preloadComponents (all components) (457.13KB) (0.6%)
    4.42ms
    1 x After Access::preloadPermissions (com_content) (474.34KB) (0.3%)
    2.16ms
    1 x After Access::preloadComponents (all components) (104.54KB) (0.14%)
    1.02ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (19.34KB) (0.14%)
    1.00ms
    1 x afterRenderRawModule mod_custom (CopyrightBG) (5.21KB) (0.09%)
    642μs
    1 x After Access::getAssetRules (id:858 name:com_content.article.716) (91.13KB) (0.04%)
    328μs
    1 x beforeRenderModule mod_custom (CopyrightBG) (25.48KB) (0.04%)
    321μs
    1 x afterRenderRawModule mod_custom (Logo_menu) (992B) (0.04%)
    310μs
    1 x afterRenderModule mod_custom (CopyrightBG) (1.84KB) (0.04%)
    264μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.37KB) (0.02%)
    126μs
    1 x afterDispatch (2.19KB) (0.02%)
    120μs
    1 x afterRenderModule mod_custom (Logo_menu) (1.21KB) (0.01%)
    103μs
    1 x afterRenderModule mod_finder (Search) (1.21KB) (0.01%)
    72μs
    1 x afterRenderModule mod_menu (Main Menu) (1.21KB) (0.01%)
    71μs
    1 x Before Access::getAssetRules (id:858 name:com_content.article.716) (18.65KB) (0.01%)
    49μs
    1 x beforeRenderRawModule mod_finder (Search) (896B) (0.01%)
    44μs
    1 x beforeRenderRawModule mod_custom (CopyrightBG) (464B) (0.01%)
    42μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (528B) (0.01%)
    42μs
    1 x beforeRenderModule mod_finder (Search) (1.98KB) (0%)
    33μ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%)
    11μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Logo_menu) (720B) (0%)
    3μs
33 statements were executed, 3 of which were duplicates, 30 unique17.87ms179.63KB
UniquesDuplicates 1
  • SELECT @@SESSION.sql_mode;124μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
  • SELECT `data` FROM `k26uj_session` WHERE `session_id` = ?278μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `k26uj_session` WHERE `session_id` = :session_id LIMIT 1207μ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.31ms944BParams/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` = 1456μs1.61KB/libraries/src/Component/ComponentHelper.php:429Copy
  • SELECT `id`,`rules` FROM `k26uj_viewlevels`278μ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` = :guest296μ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`894μs3.48KBParams/libraries/src/Plugin/PluginHelper.php:302Copy
  • SELECT * FROM `k26uj_nextend2_section_storage` WHERE `application` = 'smartslider' AND `section` = 'settings'340μ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`759μ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`531μs3.89KBParams/libraries/src/Categories/Categories.php:369Copy
  • SELECT `id` FROM `k26uj_content` WHERE `alias` = :alias AND `catid` = :catid290μ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` = :element305μs1.48KBParams/libraries/src/Helper/LibraryHelper.php:162Copy
  • UPDATE `k26uj_extensions` SET `params` = :params WHERE `type` = 'library' AND `element` = :element1.32ms880BParams/libraries/src/Helper/LibraryHelper.php:126Copy
  • SELECT * FROM `k26uj_languages` WHERE `published` = 1 ORDER BY `ordering` ASC317μ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` = 1355μ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)696μ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` = 01.38ms49.48KBParams/libraries/src/Access/Access.php:309Copy
  • SHOW FULL COLUMNS FROM `k26uj_content`671μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • UPDATE k26uj_content SET `hits` = (`hits` + 1) WHERE `id` = '716'1.25ms48B/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)498μ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`510μ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)322μ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`328μ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 ASC880μ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` = :itemid270μ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.13ms20.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`358μ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`377μs1.91KBParams/libraries/src/Cache/Controller/CallbackController.php:52Copy
  • SELECT `name`,`element` FROM `k26uj_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1398μ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)192μ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` desc296μ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` desc255μs5.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:422Copy