career logo round

European Central Bank: Traineeships in the External Developments Division (9792)
The European Central Bank has launched: Traineeships in the External Developments Division<https://talent.ecb.europa.eu/careers/SpecificFolder?jobId=9792&source=University+outreach
Type of contract Traineeship
Who can apply? EU nationals eligible for our traineeship programme
Grant The trainee grant is €1,170 per month plus an accommodation allowance (see further information section)
Working time Full time
Place of work Frankfurt am Main, Germany
Closing date 06.06.2024
Your team
You will be part of the Directorate General International and European Relations, which has 120 staff members. You will be assigned to a team in the External Developments Division, which analyses the global economic situation and economic conditions in key non-EU countries, such as the United States, United Kingdom and China. The Division also conducts simulation and scenario analyses related to the international environment, and coordinates the global part of the ECB/Eurosystem staff macroeconomic projections. Our current key projects include analysis of inflation, international trade, strategic autonomy and modelling the global economy, including climate risks.

In your role as trainee, you will be part of one of the following teams: Global, Americas, Asia-Pacific, Non-EU Europe or Modelling. Each team contributes to analytical workstreams and supports data management within the Division.

The ECB is an inclusive employer and we strive to reflect the diversity of the population we serve. We encourage you to apply irrespective of age, disability, ethnicity, gender, gender identity, race, religious beliefs, sexual orientation or other characteristics.
Your role

As a trainee you will perform one or more of the following tasks:

* contributing to, and possibly co-authoring, analytical reports by collecting data and setting up statistical and econometric processes;
* providing research assistance by:
* building and maintaining modelling tools using advanced econometric programming skills;
* assisting with data collection, programming tasks and analysis;
* handling, maintaining and developing databases used to monitor global and country-specific monetary, financial and real sector developments;
* presenting key findings to relevant stakeholders within the ECB.

If you are assigned to the Global team or one of the regional teams, you will:

* contribute to the cross-country and empirical analysis of international and country macroeconomic policy issues;
* assist in the development of econometric tools and models used to support economic analyses.

If you are assigned to the Modelling team, you will:

* contribute to scenario analysis and simulations regarding the international environment;
* participate in discussions about the international environment and the use of macroeconomic models to respond to key policy questions.

You will work closely with highly qualified experts on different tasks and projects in the field of international macroeconomics, which will provide you with valuable experience for building a successful professional career. You will also be assigned a mentor and be part of a multicultural team that strives for continuous innovation to make a positive impact on the lives of European citizens.
Qualifications, experience and skills

Essential:

* a bachelor’s degree or higher in economics, finance, statistics, data science or a related field;
* a sound understanding of international macroeconomics;
* experience in data management and handling multidimensional datasets;
* advanced knowledge of MS Office, in particular Excel;
* an intermediate knowledge of programming languages and econometric software (e.g. MATLAB, R, Julia, Stata, Python, EViews);
* an advanced (C1) command of English and an intermediate (B1) command of at least one other official language of the EU, according to the Common European Framework of Reference for Languages<https://www.coe.int/en/web/common-european-framework-reference-languages/table-1-cefr-3.3-common-reference-levels-global-scale
Desired:

* a master’s degree in economics, finance, statistics, data science or a related field (or a master’s degree in one of these areas in the final stages of completion);
* experience with state-of-the-art modelling tools and econometric techniques or data analytics, preferably in the field of global trade, country analysis or macro modelling;
* a keen interest in policy-relevant and applied research, together with a proven ability to conduct quantitative analyses;
* experience with macroeconomic and financial market data;
* a sound knowledge of statistical and econometric techniques for data analysis;
* for the Global team and regional teams: experience of time series analysis, such as error correction models and vector autoregression models, and familiarity with international trade data;
* for the Modelling team: a sound theoretical background in New Keynesian dynamic stochastic general equilibrium models and experience with structural and/or semi-structural macroeconomic models, as well as proven experience in programming with MATLAB or Julia, and in using Dynare.
You are curious and eager to learn, and want to further develop your ability to analyse complex information. You are keen to collaborate with others, pursue team goals and learn from other people’s diverse perspectives. You strive to know and anticipate stakeholder needs, and will signal any need for change and propose alternative solutions.

You are motivated to contribute to the ECB’s mission, to serve the citizens of the EU as a member of a public institution and to work with colleagues from all over Europe. You are keen to be part of our team and to use your skills and competencies to achieve the aims of this position.

Further information
Traineeship of 4 months, with a possible extension to up to 12 months in total.

Other details on the conditions applicable to traineeships<https://www.ecb.europa.eu/careers/what-we-offer/traineeship/html/index.en.html  at the ECB can be found on our website.

Application and selection process

Further information on how to apply https://www.ecb.europa.eu/careers/before-you-apply/how-to-apply/html/index.en.html is available on our website.

The recruitment process for this position will include a written exercise and an online interview.

If you are not selected for this position but are still considered suitable, you will be placed on a reserve list for 12 months from the closing date for applications, from which you might be considered for other traineeship positions within the ECB.
The European Central Bank
Directorate General Human Resources
www.ecb.europa.eu<http://www.ecb.europa.eu/
www.youtube.com/ecbeuro http://www.youtube.com/ecbeur
https://twitter.com/ecb
UNITED IN DIVERSITY - Our euro, our pride.
Do you have a question about recruitment? Ask the ECBot. https://intranet.ecb.europa.eu/Interact/Pages/Section/ContentListing.aspx?subsection=3455

19MBMemory Usage981msRequest 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" => 1745558696 "last" => 1745558696...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => null ...
  • afterLoad (3.75MB) (56.29ms)
  • afterInitialise (6.99MB) (85.91ms)
  • afterRoute (1.03MB) (12.14ms)
  • beforeRenderComponent com_content (450.3KB) (5.72ms)
  • Before Access::preloadComponents (all components) (457.13KB) (4.49ms)
  • After Access::preloadComponents (all components) (104.54KB) (940μs)
  • Before Access::preloadPermissions (com_content) (1.45KB) (12μs)
  • After Access::preloadPermissions (com_content) (479.19KB) (2.01ms)
  • Before Access::getAssetRules (id:332 name:com_content.article.192) (18.65KB) (33μs)
  • After Access::getAssetRules (id:332 name:com_content.article.192) (91.13KB) (341μs)
  • afterRenderComponent com_content (2.77MB) (44.64ms)
  • afterDispatch (2.19KB) (123μs)
  • beforeRenderRawModule mod_menu (Main Menu) (472.35KB) (5.2ms)
  • afterRenderRawModule mod_menu (Main Menu) (482.42KB) (12.49ms)
  • beforeRenderRawModule mod_finder (Search) (896B) (35μs)
  • afterRenderRawModule mod_finder (Search) (508.01KB) (8.34ms)
  • beforeRenderRawModule mod_custom (CopyrightBG) (464B) (58μs)
  • afterRenderRawModule mod_custom (CopyrightBG) (5.21KB) (617μs)
  • beforeRenderModule mod_custom (CopyrightBG) (25.48KB) (367μs)
  • afterRenderModule mod_custom (CopyrightBG) (1.84KB) (279μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (528B) (42μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (19.34KB) (1.03ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (5μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.37KB) (122μs)
  • beforeRenderModule mod_finder (Search) (1.98KB) (31μs)
  • afterRenderModule mod_finder (Search) (1.21KB) (71μs)
  • beforeRenderModule mod_menu (Main Menu) (2.23KB) (28μs)
  • afterRenderModule mod_menu (Main Menu) (1.21KB) (70μs)
  • beforeRenderRawModule mod_custom (Logo_menu) (1.06KB) (24μs)
  • afterRenderRawModule mod_custom (Logo_menu) (992B) (352μs)
  • beforeRenderModule mod_custom (Logo_menu) (720B) (4μs)
  • afterRenderModule mod_custom (Logo_menu) (1.21KB) (105μs)
  • afterRender (386.51KB) (11.43ms)
  • 1 x afterInitialise (6.99MB) (8.76%)
    85.91ms
    1 x afterLoad (3.75MB) (5.74%)
    56.29ms
    1 x afterRenderComponent com_content (2.77MB) (4.55%)
    44.64ms
    1 x afterRenderRawModule mod_menu (Main Menu) (482.42KB) (1.27%)
    12.49ms
    1 x afterRoute (1.03MB) (1.24%)
    12.14ms
    1 x afterRender (386.51KB) (1.17%)
    11.43ms
    1 x afterRenderRawModule mod_finder (Search) (508.01KB) (0.85%)
    8.34ms
    1 x beforeRenderComponent com_content (450.3KB) (0.58%)
    5.72ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (472.35KB) (0.53%)
    5.20ms
    1 x Before Access::preloadComponents (all components) (457.13KB) (0.46%)
    4.49ms
    1 x After Access::preloadPermissions (com_content) (479.19KB) (0.2%)
    2.01ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (19.34KB) (0.1%)
    1.03ms
    1 x After Access::preloadComponents (all components) (104.54KB) (0.1%)
    940μs
    1 x afterRenderRawModule mod_custom (CopyrightBG) (5.21KB) (0.06%)
    617μs
    1 x beforeRenderModule mod_custom (CopyrightBG) (25.48KB) (0.04%)
    367μs
    1 x afterRenderRawModule mod_custom (Logo_menu) (992B) (0.04%)
    352μs
    1 x After Access::getAssetRules (id:332 name:com_content.article.192) (91.13KB) (0.03%)
    341μs
    1 x afterRenderModule mod_custom (CopyrightBG) (1.84KB) (0.03%)
    279μs
    1 x afterDispatch (2.19KB) (0.01%)
    123μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (1.37KB) (0.01%)
    122μs
    1 x afterRenderModule mod_custom (Logo_menu) (1.21KB) (0.01%)
    105μs
    1 x afterRenderModule mod_finder (Search) (1.21KB) (0.01%)
    71μs
    1 x afterRenderModule mod_menu (Main Menu) (1.21KB) (0.01%)
    70μs
    1 x beforeRenderRawModule mod_custom (CopyrightBG) (464B) (0.01%)
    58μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (528B) (0%)
    42μs
    1 x beforeRenderRawModule mod_finder (Search) (896B) (0%)
    35μs
    1 x Before Access::getAssetRules (id:332 name:com_content.article.192) (18.65KB) (0%)
    33μs
    1 x beforeRenderModule mod_finder (Search) (1.98KB) (0%)
    31μs
    1 x beforeRenderModule mod_menu (Main Menu) (2.23KB) (0%)
    28μs
    1 x beforeRenderRawModule mod_custom (Logo_menu) (1.06KB) (0%)
    24μs
    1 x Before Access::preloadPermissions (com_content) (1.45KB) (0%)
    12μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (Logo_menu) (720B) (0%)
    4μs
33 statements were executed, 3 of which were duplicates, 30 unique18.13ms195.63KB
  • SELECT @@SESSION.sql_mode;105μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
  • SELECT `data` FROM `k26uj_session` WHERE `session_id` = ?350μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `k26uj_session` WHERE `session_id` = :session_id LIMIT 1222μ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.05ms944BParams/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` = 1258μs1.61KB/libraries/src/Component/ComponentHelper.php:429Copy
  • SELECT `id`,`rules` FROM `k26uj_viewlevels`153μ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` = :guest145μ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`481μs3.48KBParams/libraries/src/Plugin/PluginHelper.php:302Copy
  • SELECT * FROM `k26uj_nextend2_section_storage` WHERE `application` = 'smartslider' AND `section` = 'settings'158μ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`799μ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`507μs3.89KBParams/libraries/src/Categories/Categories.php:369Copy
  • SELECT `id` FROM `k26uj_content` WHERE `alias` = :alias AND `catid` = :catid261μ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` = :element256μs1.48KBParams/libraries/src/Helper/LibraryHelper.php:162Copy
  • UPDATE `k26uj_extensions` SET `params` = :params WHERE `type` = 'library' AND `element` = :element199μs880BParams/libraries/src/Helper/LibraryHelper.php:126Copy
  • SELECT * FROM `k26uj_languages` WHERE `published` = 1 ORDER BY `ordering` ASC244μ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` = 1290μ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)577μ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.24ms49.48KBParams/libraries/src/Access/Access.php:309Copy
  • SHOW FULL COLUMNS FROM `k26uj_content`520μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • UPDATE k26uj_content SET `hits` = (`hits` + 1) WHERE `id` = '192'1.83ms48B/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)451μ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`451μ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)358μ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`464μ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 ASC1.38ms4.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` = :itemid306μ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 DESC2.12ms20.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`536μ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`707μs1.91KBParams/libraries/src/Cache/Controller/CallbackController.php:52Copy
  • SELECT `name`,`element` FROM `k26uj_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1637μ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)334μ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` desc371μ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` desc363μs5.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:422Copy