14 November 2024

Visualisations

This infographic is a visual guide to the different labour migration and mobility pathways to Croatia. Updated up to February 2024. 

5.504MBMemory Usage120msRequest Duration
Joomla! Version4.4.12
PHP Version8.2.28
Identityguest
Response200
Templatet3_bs3_blank
Database
Server
mysql
Version
5.7.41
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:48 [ "REDIRECT_UNIQUE_ID" => "Z-WhE0un6r0GLbHstKumwwAAAA4" "REDIRECT_HTTP_AUTHORIZATION" =...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743102227 "last" => 1743102227...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (478.07KB) (3.22ms)
  • afterInitialise (1.78MB) (39.4ms)
  • afterRoute (721.63KB) (5.08ms)
  • beforeRenderComponent com_repo (18.17KB) (335μs)
  • afterRenderComponent com_repo (833.39KB) (27.42ms)
  • afterDispatch (215.28KB) (3.75ms)
  • beforeRenderModule mod_custom (Footer) (156.32KB) (4.23ms)
  • afterRenderRawModule mod_custom (Footer) (130.84KB) (6.99ms)
  • beforeRenderModule mod_custom (Footer) (704B) (5μs)
  • afterRenderModule mod_custom (Footer) (54.23KB) (1.28ms)
  • beforeRenderModule mod_custom (Subscribe to our Newsletter) (728B) (177μs)
  • afterRenderRawModule mod_custom (Subscribe to our Newsletter) (992B) (252μs)
  • beforeRenderModule mod_custom (Subscribe to our Newsletter) (736B) (4μs)
  • afterRenderModule mod_custom (Subscribe to our Newsletter) (1.97KB) (545μs)
  • beforeRenderModule mod_menu (Main Menu) (1.95KB) (111μs)
  • afterRenderRawModule mod_menu (Main Menu) (263.12KB) (7.75ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (5μs)
  • afterRenderModule mod_menu (Main Menu) (2.59KB) (581μs)
  • beforeRenderModule mod_search (Search) (312B) (472μs)
  • afterRenderRawModule mod_search (Search) (29.3KB) (1.36ms)
  • beforeRenderModule mod_search (Search) (704B) (4μs)
  • afterRenderModule mod_search (Search) (1.65KB) (553μs)
  • beforeRenderModule mod_custom (Log in button) (1.98KB) (13μs)
  • afterRenderRawModule mod_custom (Log in button) (992B) (240μs)
  • beforeRenderModule mod_custom (Log in button) (720B) (2μs)
  • afterRenderModule mod_custom (Log in button) (3.04KB) (637μs)
  • afterRender (255.3KB) (14.5ms)
  • 1 x afterInitialise (1.78MB) (32.93%)
    39.40ms
    1 x afterRenderComponent com_repo (833.39KB) (22.92%)
    27.42ms
    1 x afterRender (255.3KB) (12.12%)
    14.50ms
    1 x afterRenderRawModule mod_menu (Main Menu) (263.12KB) (6.48%)
    7.75ms
    1 x afterRenderRawModule mod_custom (Footer) (130.84KB) (5.84%)
    6.99ms
    1 x afterRoute (721.63KB) (4.25%)
    5.08ms
    1 x beforeRenderModule mod_custom (Footer) (156.32KB) (3.54%)
    4.23ms
    1 x afterDispatch (215.28KB) (3.13%)
    3.75ms
    1 x afterLoad (478.07KB) (2.69%)
    3.22ms
    1 x afterRenderRawModule mod_search (Search) (29.3KB) (1.14%)
    1.36ms
    1 x afterRenderModule mod_custom (Footer) (54.23KB) (1.07%)
    1.28ms
    1 x afterRenderModule mod_custom (Log in button) (3.04KB) (0.53%)
    637μs
    1 x afterRenderModule mod_menu (Main Menu) (2.59KB) (0.49%)
    581μs
    1 x afterRenderModule mod_search (Search) (1.65KB) (0.46%)
    553μs
    1 x afterRenderModule mod_custom (Subscribe to our Newsletter) (1.97KB) (0.46%)
    545μs
    1 x beforeRenderModule mod_search (Search) (312B) (0.39%)
    472μs
    1 x beforeRenderComponent com_repo (18.17KB) (0.28%)
    335μs
    1 x afterRenderRawModule mod_custom (Subscribe to our Newsletter) (992B) (0.21%)
    252μs
    1 x afterRenderRawModule mod_custom (Log in button) (992B) (0.2%)
    240μs
    1 x beforeRenderModule mod_custom (Subscribe to our Newsletter) (728B) (0.15%)
    177μs
    1 x beforeRenderModule mod_menu (Main Menu) (1.95KB) (0.09%)
    111μs
    1 x beforeRenderModule mod_custom (Log in button) (1.98KB) (0.01%)
    13μs
    1 x beforeRenderModule mod_custom (Footer) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_search (Search) (704B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Subscribe to our Newsletter) (736B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (Log in button) (720B) (0%)
    2μs
34 statements were executed, 6 of which were duplicates, 28 unique7.4ms99.23KB
  • SELECT @@SESSION.sql_mode;42μs968B/libraries/src/Session/MetadataManager.php:184Copy
  • SELECT `session_id` FROM `mpf_session` WHERE `session_id` = :session_id LIMIT 170μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `mpf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)2.44ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `mpf_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1211μs1.42KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `mpf_viewlevels`70μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `mpf_usergroups` AS `a` LEFT JOIN `mpf_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest106μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `mpf_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`467μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `mpf_kunena_configuration` WHERE `id` = 155μs592B/libraries/kunena/src/Config/KunenaConfig.php:1709Copy
  • SELECT sampleData FROM mpf_kunena_version ORDER BY id DESC LIMIT 135μs1.15KB/libraries/kunena/src/Forum/KunenaForum.php:374Copy
  • SELECT `params` FROM `mpf_comprofiler_plugin` WHERE `id` = 146μs536BCopy
  • 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 `mpf_menu` AS `m` LEFT JOIN `mpf_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`396μs36.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `mpf_languages` WHERE `published` = 1 ORDER BY `ordering` ASC89μs1.59KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `element`,`name`,`client_id`,`extension_id` FROM `mpf_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 178μs736B/libraries/src/Language/LanguageHelper.php:213Copy
  • 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 `mpf_categories` AS `c` WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `c`.`language` IN (:preparedArray1,:preparedArray2) ORDER BY `c`.`lft`240μs4.3KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `mpf_template_styles` AS `s` LEFT JOIN `mpf_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` = 1136μs880B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT document.id, document.alias, document.title, document.image, document.description, document.abstract, document.authors, document.date, document.type, document.file, document.password,category.title AS category, category.id AS catid, category.alias AS catalias,GROUP_CONCAT(DISTINCT topic.title ORDER BY topic.ordering ASC SEPARATOR ", ") AS topics FROM `mpf_repo_document` AS `document` LEFT JOIN `mpf_categories` AS `category` ON (`document`.`catid` = `category`.`id`) LEFT JOIN `mpf_repo_document_topic` AS `doc_top` ON (`document`.`id` = `doc_top`.`document_id`) LEFT JOIN `mpf_repo_topic` AS `topic` ON (`doc_top`.`topic_id` = `topic`.`id`) WHERE `document`.`state` = 1 AND `document`.`access` IN ("1","5") AND `document`.`id` = '230' AND `category`.`published` = 1 AND `category`.`access` IN ("1","5")173μs1.63KB/components/com_repo/models/document.php:36Copy
  • 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 `mpf_categories` AS `s` INNER JOIN `mpf_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`183μs5.22KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 mpf_fields AS a LEFT JOIN `mpf_languages` AS l ON l.lang_code = a.language LEFT JOIN mpf_users AS uc ON uc.id=a.checked_out LEFT JOIN mpf_viewlevels AS ag ON ag.id = a.access LEFT JOIN mpf_users AS ua ON ua.id = a.created_user_id LEFT JOIN mpf_fields_groups AS g ON g.id = a.group_id LEFT JOIN `mpf_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)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) 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 ASC272μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 mpf_fields AS a LEFT JOIN `mpf_languages` AS l ON l.lang_code = a.language LEFT JOIN mpf_users AS uc ON uc.id=a.checked_out LEFT JOIN mpf_viewlevels AS ag ON ag.id = a.access LEFT JOIN mpf_users AS ua ON ua.id = a.created_user_id LEFT JOIN mpf_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) 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 ASC292μs4.09KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `field_id`,`value` FROM `mpf_fields_values` WHERE `field_id` IN (:preparedArray1,:preparedArray2) AND `item_id` = :itemid81μs1.42KBParams/administrator/components/com_fields/src/Model/FieldModel.php:728Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `mpf_repo_document` AS `c` INNER JOIN `mpf_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `mpf_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `mpf_repo_document` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `mpf_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id114μs1.47KBParams/libraries/src/Language/Associations.php:145Copy
  • 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 `mpf_categories` AS `s` INNER JOIN `mpf_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`211μs3.97KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `language`,`id` FROM `mpf_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0138μs592B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `mpf_repo_document` WHERE id = '230'44μs536B/components/com_repo/router.php:103Copy
  • SELECT `alias` FROM `mpf_repo_document` WHERE id = '230'36μs536B/components/com_repo/router.php:103Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `mpf_repo_document` AS `c` INNER JOIN `mpf_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `mpf_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `mpf_repo_document` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `mpf_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.state = 1109μs1.47KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `mpf_modules` AS `m` LEFT JOIN `mpf_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `mpf_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) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`411μs2.03KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `extension_id`,`name`,`enabled`,`params` FROM mpf_extensions WHERE `type` = 'plugin' AND `element` = 'osyoutube' AND `folder` = 'content'95μs704B/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170Copy
  • 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 mpf_fields AS a LEFT JOIN `mpf_languages` AS l ON l.lang_code = a.language LEFT JOIN mpf_users AS uc ON uc.id=a.checked_out LEFT JOIN mpf_viewlevels AS ag ON ag.id = a.access LEFT JOIN mpf_users AS ua ON ua.id = a.created_user_id LEFT JOIN mpf_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) 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 ASC292μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `mpf_repo_document` WHERE id = '230'54μs536B/components/com_repo/router.php:103Copy
  • SELECT `alias` FROM `mpf_repo_document` WHERE id = '230'42μs536B/components/com_repo/router.php:103Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `mpf_scheduler_tasks` AS `a` WHERE `a`.`state` = 178μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `alias` FROM `mpf_content` WHERE `id` = :id59μs3.81KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `mpf_categories` AS `s` INNER JOIN `mpf_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`230μs3.97KBParams/libraries/src/Categories/Categories.php:375Copy