Настройка форматов адресов в MS Dynamics AX 2012

В MS Dynamics AX 2012 есть некая настройка адресов. Эта настройка включает в себя определение формата адреса, т.е. последовательность отображения элементов адреса (индекса, страна, город и т.д.), также включает справочники стран, городов, районов и т.д. Настройку адресов желательно выполнять в самом начале настройки приложения, после его развертывания или создания нового раздела.

Настройку адресных данных можно выполнить вручную, т.е. последовательно внести в систему адресную информацию, либо импортировать КЛАДР (готовый классификатор адресов РФ).
Рассмотрим настройку адресных данных вручную:
1. Формат адреса.
Формат адреса определяет в какой последовательности адресная информация будет отображаться в отчетах, запросах и печатных формах.
Для настройки перейдите в "Управление организацией / Настройка / Адреса / Настройка адреса / Формат адреса", нажмите кнопку "Создать":
 
 
На вкладке "Сконфигурировать компонент адреса" создать строки в обратном порядке, т.е. от наименьшего к наибольшему.
В поле "Разделитель" введите запятую и пробел ( ", "), чтобы части адреса разделялись между собой.  Нажмите кнопку "Сохранить", при этом в верхнем правом поле формы будет отображен принятый формат адреса.
2. Настройка страны / региона.
Перейдите в "Управление организацией / Настройка / Адреса / Настройка адреса / Страна/регион", выберите из списка страну, в поле "формат адреса" установите созданный формат адреса, нажмите кнопку "Сохранить":
 
3. Настройка города.
Перейдите в "Управление организацией / Настройка / Адреса / Настройка адреса / Город", выберите из списка страну, нажмите кнопку "Создать", введите наименование города,  нажмите "Сохранить":
 
4. Настройка улицы.
Перейдите в "Управление организацией / Настройка / Адреса / Настройка адреса /  Улица", выберите из списка страну, город, нажмите кнопку "Создать", введите код улицы, наименование улицы ,  нажмите "Сохранить":
 
Таким образом можно настроить в системе области и районы, а так же почтовые индексы, номера домов и другие необходимые адресные данные.
J! InfoRequestSessionProfileQueries31
Settings2.898MBMemory Usage82.36msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
PHP Version8.2.28
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
10.11.11-MariaDB-0+deb12u1
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:42 [ "USER" => "www-data" "HOME" => "/var/www" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEP...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1747084395 "last" => 1747084395...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (82.38KB) (977μs)
  • afterInitialise (1.13MB) (22.47ms)
  • afterRoute (72.87KB) (6.27ms)
  • beforeRenderComponent com_content (105.63KB) (4.4ms)
  • Before Access::preloadComponents (all components) (35.02KB) (657μs)
  • After Access::preloadComponents (all components) (114.12KB) (2.41ms)
  • Before Access::preloadPermissions (com_content) (424B) (23μs)
  • After Access::preloadPermissions (com_content) (13.34KB) (1.6ms)
  • Before Access::getAssetRules (id:81 name:com_content.article.27) (104B) (26μs)
  • After Access::getAssetRules (id:81 name:com_content.article.27) (7.38KB) (136μs)
  • afterRenderComponent com_content (375.98KB) (29.62ms)
  • afterDispatch (3.16KB) (226μs)
  • beforeRenderRawModule mod_menu (Main Menu) (345.79KB) (4.65ms)
  • afterRenderRawModule mod_menu (Main Menu) (83.09KB) (726μs)
  • beforeRenderModule mod_menu (Main Menu) (704B) (7μs)
  • afterRenderModule mod_menu (Main Menu) (3.56KB) (110μs)
  • afterRender (174.48KB) (7.8ms)
  • 1 x afterRenderComponent com_content (375.98KB) (35.97%)
    29.62ms
    1 x afterInitialise (1.13MB) (27.28%)
    22.47ms
    1 x afterRender (174.48KB) (9.47%)
    7.80ms
    1 x afterRoute (72.87KB) (7.62%)
    6.27ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (345.79KB) (5.65%)
    4.65ms
    1 x beforeRenderComponent com_content (105.63KB) (5.34%)
    4.40ms
    1 x After Access::preloadComponents (all components) (114.12KB) (2.92%)
    2.41ms
    1 x After Access::preloadPermissions (com_content) (13.34KB) (1.94%)
    1.60ms
    1 x afterLoad (82.38KB) (1.19%)
    977μs
    1 x afterRenderRawModule mod_menu (Main Menu) (83.09KB) (0.88%)
    726μs
    1 x Before Access::preloadComponents (all components) (35.02KB) (0.8%)
    657μs
    1 x afterDispatch (3.16KB) (0.27%)
    226μs
    1 x After Access::getAssetRules (id:81 name:com_content.article.27) (7.38KB) (0.17%)
    136μs
    1 x afterRenderModule mod_menu (Main Menu) (3.56KB) (0.13%)
    110μs
    1 x Before Access::getAssetRules (id:81 name:com_content.article.27) (104B) (0.03%)
    26μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.03%)
    23μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0.01%)
    7μs
31 statements were executed, 6 of which were duplicates, 25 unique41.42ms131.83KB
UniquesDuplicates 1Duplicates 2
  • SELECT @@SESSION.sql_mode;141μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `ef_session` WHERE `session_id` = ?1.15ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `ef_session` WHERE `session_id` = :session_id LIMIT 1171μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `ef_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)2.52ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `ef_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 13.09ms1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ef_viewlevels`463μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `ef_usergroups` AS `a` LEFT JOIN `ef_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest777μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `ef_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`2.29ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • 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 `ef_menu` AS `m` LEFT JOIN `ef_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`1.03ms3.95KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • 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 `ef_categories` AS `s` INNER JOIN `ef_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`1.43ms3.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `ef_content` WHERE `id` = :id1.62ms1.31KBParams/components/com_content/src/Service/Router.php:289Copy
  • SELECT * FROM `ef_languages` WHERE `published` = 1 ORDER BY `ordering` ASC701μs1.59KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `ef_template_styles` AS `s` LEFT JOIN `ef_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` = 11.8ms832B/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ef_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)1.9ms7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ef_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.21ms2.36KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ef_content`799μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `ef_content` SET `hits` = (`hits` + 1) WHERE `id` = '27'782μs1.3KB/libraries/src/Table/Table.php:1348Copy
  • 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 `ef_content` AS `a` INNER JOIN `ef_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ef_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ef_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `ef_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ef_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)1.54ms22.13KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `ef_categories` AS `s` INNER JOIN `ef_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`1.11ms3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `ef_contentitem_tag_map` AS `m` INNER JOIN `ef_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)2.11ms4KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • 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 `ef_categories` AS `s` INNER JOIN `ef_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`624μs3.91KBParams/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 ef_fields AS a LEFT JOIN `ef_languages` AS l ON l.lang_code = a.language LEFT JOIN ef_users AS uc ON uc.id=a.checked_out LEFT JOIN ef_viewlevels AS ag ON ag.id = a.access LEFT JOIN ef_users AS ua ON ua.id = a.created_user_id LEFT JOIN ef_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ef_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 ASC2.45ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `ef_content` AS `a` LEFT JOIN `ef_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 DESC6.88ms2.47KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:205Copy
  • 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 `ef_categories` AS `s` INNER JOIN `ef_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`411μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `ef_modules` AS `m` LEFT JOIN `ef_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `ef_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`1.67ms1.83KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT * FROM `ef_schemaorg` WHERE `itemId` = :itemId AND `context` = :context496μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
  • 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 `ef_content` AS `a` INNER JOIN `ef_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ef_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ef_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `ef_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ef_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)356μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `ef_content` AS `a` INNER JOIN `ef_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ef_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ef_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `ef_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ef_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)289μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `ef_scheduler_tasks` AS `a` WHERE `a`.`state` = 1802μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `ef_session` WHERE `session_id` = ?121μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `ef_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?716μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy