career logo round

Data Scientist

Who we are:
Do you want to join a well-established bank with a start-up culture? No, we’re not joking!   We, at tbi, have been one the most profitable banks for years and we are growing at a fast pace. We’re a bank with a long history of success that operates as a start-up and we’re always on the lookout for new opportunities to grow our business. How do we do that?                              It's all about our people. Our team is made up of brave, passionate and caring people who don’t just want to follow the same path – we want to transform into mobile-first, state-of-the-art lifestyle ecosystem. Our colleagues love working here – 80% of them would recommend tbi as an employer to their friends and family. Our people are engaged in challenging and meaningful work, inspired to grow their potential and career, encouraged to learn and empowered to take decisions. That’s not corporate babble, it’s what our people say.                             Do you want to play a key role in our unique success story?                                                                     If so, we're looking for a Data Scientist to join our team on our journey to success!                                                                                                                                                                                                                                                 What You’ll do:

  • Analyze complex datasets to identify trends, patterns, and opportunities
  • Develop predictive models using machine learning and statistical techniques to address business challenges
  • Perform hypothesis testing and design A/B experiments to validate business strategies
  • Perform data cleaning, feature selection, and feature engineering to enhance model accuracy and interpretability
  • Create and validate custom metrics and KPIs to measure model and business performance
  • Implement and evaluate machine learning algorithms (e.g., RandomForest, XGBoost, Neural Networks) 
  • Experiment with advanced techniques such as deep learning, natural language processing (NLP), and time series forecasting to derive insights from structured and unstructured data
  • Work closely with data engineers to ensure seamless data integration and pipeline development
  • Collaborate with business stakeholders to translate complex findings into actionable business strategies
  • Partner with business intelligence and analytics teams to create dashboards and visualizations that support business objectives
  • Monitor the performance of deployed models and implement retraining strategies to improve model accuracy over time
  • Optimize algorithms for scalability, efficiency, and robustness
  • Design and build dashboards using visualization tools (e.g., Power BI, Tableau, or custom-built solutions)
  • Create clear and impactful data stories and visualizations to present findings and recommendations to senior management and non-technical audiences
  • Stay current with the latest advancements in machine learning and data science
  • Experiment with new methodologies and tools to continuously enhance the data science capabilities of the organization

What you’ll need to succeed:

  • Master’s degree in Data Science, Statistics, Mathematics, Computer Science, or a related field
  • 3+ years of related work experience
  • Strong proficiency in Python for data analysis, modeling, and machine learning, alongside SQL for data manipulation and querying
  • Hands-on experience with machine learning libraries like Scikit-Learn, TensorFlow, Keras, PyTorch, and XGBoost
  • Expertise in statistical techniques such as regression, hypothesis testing, and time series analysis to address business challenges
  • In-depth knowledge of data cleaning, wrangling, and transformation using Pandas, Numpy, and SciPy
  • Familiarity with ETL pipelines, data lakes, warehouses, and big data tools (e.g., Hadoop, Spark)
  • Experience with cloud-based data ecosystems such as Snowflake, AWS Glue, Google Cloud Dataflow, or Azure Databricks
  • Proficiency in data visualization tools like Power BI, Tableau, Matplotlib, Seaborn, and Plotly
  • Knowledge of deep learning frameworks like TensorFlow and Keras, particularly in NLP, image processing, and advanced AI solutions
  • Familiarity with version control systems like Git and collaborative platforms (e.g., GitHub, GitLab)
  • Experience with cloud machine learning platforms (e.g., AWS SageMaker, Google AI) and deploying models via REST APIs or Docker containerization
  • Fluent English skills (both written and spoken)
  • Strong problem-solving, analytical, and critical thinking skills, with the ability to work both independently and as part of a team
  • A proven track record of delivering high-quality projects on time
  • Preferred certifications in areas like AWS Certified Machine Learning – Specialty or Google Professional Data Engineer
    What we offer:    
  • Seize the opportunity to grow your career
  • Engage in exciting and meaningful work
  • Get recognition for your work and attitude
  • Learn new skills and get management training
  • Become part of a large, friendly and supportive team
  • Get additional private health insurance
  • Receive special prices for multisport card and multiple retailers
  • Obtain preferential prices for our banking products
  • Enjoy a great location in Sofia’s city centre near NDK and South Park

To apply for this position, please send us your CV in English.

Mestorabota: Sofiq

19MBMemory Usage947msRequest 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) (54.69ms)
  • afterInitialise (6.99MB) (80.21ms)
  • afterRoute (1.03MB) (11.34ms)
  • beforeRenderComponent com_content (450.37KB) (5.44ms)
  • Before Access::preloadComponents (all components) (457.13KB) (4.71ms)
  • After Access::preloadComponents (all components) (104.54KB) (609μs)
  • Before Access::preloadPermissions (com_content) (1.45KB) (13μs)
  • After Access::preloadPermissions (com_content) (475.8KB) (2.88ms)
  • Before Access::getAssetRules (id:731 name:com_content.article.591) (18.65KB) (33μs)
  • After Access::getAssetRules (id:731 name:com_content.article.591) (91.13KB) (329μs)
  • afterRenderComponent com_content (2.76MB) (61.63ms)
  • afterDispatch (2.19KB) (145μs)
  • beforeRenderRawModule mod_menu (Main Menu) (472.35KB) (10.93ms)
  • afterRenderRawModule mod_menu (Main Menu) (473.95KB) (19.07ms)
  • beforeRenderRawModule mod_finder (Search) (896B) (35μs)
  • afterRenderRawModule mod_finder (Search) (508.01KB) (7.82ms)
  • beforeRenderRawModule mod_custom (CopyrightBG) (464B) (62μs)
  • afterRenderRawModule mod_custom (CopyrightBG) (5.21KB) (705μs)
  • beforeRenderModule mod_custom (CopyrightBG) (25.48KB) (358μs)
  • afterRenderModule mod_custom (CopyrightBG) (1.84KB) (276μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (528B) (43μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (19.34KB) (1.06ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.37KB) (116μs)
  • beforeRenderModule mod_finder (Search) (1.98KB) (54μs)
  • afterRenderModule mod_finder (Search) (1.21KB) (81μs)
  • beforeRenderModule mod_menu (Main Menu) (2.23KB) (30μs)
  • afterRenderModule mod_menu (Main Menu) (1.21KB) (70μs)
  • beforeRenderRawModule mod_custom (Logo_menu) (1.06KB) (38μs)
  • afterRenderRawModule mod_custom (Logo_menu) (992B) (317μs)
  • beforeRenderModule mod_custom (Logo_menu) (720B) (3μs)
  • afterRenderModule mod_custom (Logo_menu) (1.21KB) (104μs)
  • afterRender (386.45KB) (11.13ms)
  • 1 x afterInitialise (6.99MB) (8.47%)
    80.21ms
    1 x afterRenderComponent com_content (2.76MB) (6.51%)
    61.63ms
    1 x afterLoad (3.75MB) (5.78%)
    54.69ms
    1 x afterRenderRawModule mod_menu (Main Menu) (473.95KB) (2.01%)
    19.07ms
    1 x afterRoute (1.03MB) (1.2%)
    11.34ms
    1 x afterRender (386.45KB) (1.18%)
    11.13ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (472.35KB) (1.15%)
    10.93ms
    1 x afterRenderRawModule mod_finder (Search) (508.01KB) (0.83%)
    7.82ms
    1 x beforeRenderComponent com_content (450.37KB) (0.57%)
    5.44ms
    1 x Before Access::preloadComponents (all components) (457.13KB) (0.5%)
    4.71ms
    1 x After Access::preloadPermissions (com_content) (475.8KB) (0.3%)
    2.88ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (19.34KB) (0.11%)
    1.06ms
    1 x afterRenderRawModule mod_custom (CopyrightBG) (5.21KB) (0.07%)
    705μs
    1 x After Access::preloadComponents (all components) (104.54KB) (0.06%)
    609μs
    1 x beforeRenderModule mod_custom (CopyrightBG) (25.48KB) (0.04%)
    358μs
    1 x After Access::getAssetRules (id:731 name:com_content.article.591) (91.13KB) (0.03%)
    329μs
    1 x afterRenderRawModule mod_custom (Logo_menu) (992B) (0.03%)
    317μs
    1 x afterRenderModule mod_custom (CopyrightBG) (1.84KB) (0.03%)
    276μs
    1 x afterDispatch (2.19KB) (0.02%)
    145μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.37KB) (0.01%)
    116μs
    1 x afterRenderModule mod_custom (Logo_menu) (1.21KB) (0.01%)
    104μs
    1 x afterRenderModule mod_finder (Search) (1.21KB) (0.01%)
    81μs
    1 x afterRenderModule mod_menu (Main Menu) (1.21KB) (0.01%)
    70μs
    1 x beforeRenderRawModule mod_custom (CopyrightBG) (464B) (0.01%)
    62μs
    1 x beforeRenderModule mod_finder (Search) (1.98KB) (0.01%)
    54μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (528B) (0%)
    43μs
    1 x beforeRenderRawModule mod_custom (Logo_menu) (1.06KB) (0%)
    38μs
    1 x beforeRenderRawModule mod_finder (Search) (896B) (0%)
    35μs
    1 x Before Access::getAssetRules (id:731 name:com_content.article.591) (18.65KB) (0%)
    33μs
    1 x beforeRenderModule mod_menu (Main Menu) (2.23KB) (0%)
    30μs
    1 x Before Access::preloadPermissions (com_content) (1.45KB) (0%)
    13μ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 unique12.89ms195.63KB
  • SELECT @@SESSION.sql_mode;65μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
  • SELECT `data` FROM `k26uj_session` WHERE `session_id` = ?186μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `k26uj_session` WHERE `session_id` = :session_id LIMIT 1114μ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)964μ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` = 1275μs1.61KB/libraries/src/Component/ComponentHelper.php:429Copy
  • SELECT `id`,`rules` FROM `k26uj_viewlevels`107μ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` = :guest144μ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`462μs3.48KBParams/libraries/src/Plugin/PluginHelper.php:302Copy
  • SELECT * FROM `k26uj_nextend2_section_storage` WHERE `application` = 'smartslider' AND `section` = 'settings'167μ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`414μ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`325μs3.89KBParams/libraries/src/Categories/Categories.php:369Copy
  • SELECT `id` FROM `k26uj_content` WHERE `alias` = :alias AND `catid` = :catid165μ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` = :element191μs1.48KBParams/libraries/src/Helper/LibraryHelper.php:162Copy
  • UPDATE `k26uj_extensions` SET `params` = :params WHERE `type` = 'library' AND `element` = :element120μs880BParams/libraries/src/Helper/LibraryHelper.php:126Copy
  • SELECT * FROM `k26uj_languages` WHERE `published` = 1 ORDER BY `ordering` ASC153μ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` = 1260μ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)374μ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` = 02.17ms49.48KBParams/libraries/src/Access/Access.php:309Copy
  • SHOW FULL COLUMNS FROM `k26uj_content`382μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • UPDATE k26uj_content SET `hits` = (`hits` + 1) WHERE `id` = '591'947μ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)330μ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`406μ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)227μ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`344μ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 ASC775μ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` = :itemid167μ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.09ms20.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`299μ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`417μs1.91KBParams/libraries/src/Cache/Controller/CallbackController.php:52Copy
  • SELECT `name`,`element` FROM `k26uj_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1287μ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)165μ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` desc213μ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` desc191μs5.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:422Copy