Базовые настройки НДС в MS Dynamics AX 2012

Рассмотрим основные моменты настройки НДС на примере ставки 18% в системе MS Dynamics AX 2012.

1. Создание налогового органа.
Для начала создайте отдельную группу поставщиков "Налог". Для этого перейдите в "Расчеты с поставщиками / Настройка / Поставщики / Группы поставщиков", нажмите кнопку "Создать":


Теперь создайте поставщика с именем и реквизитами налоговой инспекции. Для этого перейдите в "Расчеты с поставщиками / Обычный / Поставщики / Все поставщики", нажмите кнопку "Создать":
Пояснения: в поле "Группа" выберете группу поставщика "Налог".

Затем перейдите на вкладку "Платеж" этой же формы :

В поле "Банковский счет" щелкните правой кнопкой мыши и выберете "Просмотр подробных сведений", нажмите "Создать" и заполните банковские реквизиты для перечисления налоговых платежей:

Теперь перейдите в "Главная книга / Настройка /Налог / Налоговые органы", нажмите кнопку "Создать", заполните форму для нового налогового органа.
Пояснения: в поле "счет поставщика" укажите ранее созданного поставщика (налоговую инспекцию).
Можно заполнить вкладки "Адрес" и "Контактная информация" в случае необходимости.

2. Настройка периодов сопоставления.
Периоды сопоставления  определяют интервалы для сдачи отчетности и оплаты сумм налогов.
Откройте "Главная книга / Настройка / Налог / Периоды сопоставления налогов", нажмите кнопку "Создать":
 
Примечания: с помощью кнопки "Новый период" можно добавлять новые периоды в уже настроенные периоды сопоставления.

3. Создание группы разноски главной книги.
Группы разноски ГК определяют счета, на которые будут формироваться бухгалтерские проводки.
Перейдите в "Главная книга / Настройка / Налог / Группы разноски ГК", нажмите кнопку "Создать":


4. Создание налогового кода.
Для создания налогового кода перейдите в "Главная книга / Настройка / Налог / Налоговые коды", нажмите кнопку "Создать":

 
Пояснения:
Определите тип налога как "стандартный НДС".
В полях "Период сопоставления" и "Группа разноски ГК" укажите ранее созданные параметры (см. п.№ 2 и № 3).

Далее нажмите кнопку "Значения", в одноименном поле укажите процентную ставку по данному налогу:

5. Создание налоговой группы.
Перейдите в "Главная книга / Настройка / Налог / Налоговые группы", нажмите "Создать":
На вкладке "Настройка" добавьте налоговые коды, тем самым формируя группу.

6. Создание налоговых групп номенклатур.
Налоговые группы номенклатур используются для расчета налога по каждой конкретной номенклатуре. При этом налоговая группа номенклатур включает в себя все налоговые коды, которые применяются для конкретной номенклатуры.
Для вычисления налога всегда требуется указание налоговой группы и налоговой группы номенклатур. Как правило, налоговая группа указывается в заголовке документов, а налоговая группа номенклатур - в строках. И для расчета налогов используются только те налоговые коды, которые указаны в двух группах одновременно.

Перейдите в "Главная книга / Настройка / Налог /Налоговые группы Номенклатур", нажмите кнопку "Создать":
На вкладке "Настройка" выберете все  необходимые налоговые коды, которые должны относиться к данной группе номенклатур.

Таким образом происходит базовая настройка стандартного НДС 18% в системе MS Dynamics AX 2012.


J! InfoRequestSessionProfileQueries31
Settings2.917MBMemory Usage55.64msRequest 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" => 1747119290 "last" => 1747119290...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (82.38KB) (905μs)
  • afterInitialise (1.13MB) (15.04ms)
  • afterRoute (72.85KB) (4.45ms)
  • beforeRenderComponent com_content (105.64KB) (3.09ms)
  • Before Access::preloadComponents (all components) (35.02KB) (436μs)
  • After Access::preloadComponents (all components) (114.12KB) (1.83ms)
  • Before Access::preloadPermissions (com_content) (424B) (13μs)
  • After Access::preloadPermissions (com_content) (13.34KB) (929μs)
  • Before Access::getAssetRules (id:59 name:com_content.article.5) (104B) (12μs)
  • After Access::getAssetRules (id:59 name:com_content.article.5) (7.38KB) (58μs)
  • afterRenderComponent com_content (391.22KB) (18.29ms)
  • afterDispatch (3.16KB) (118μs)
  • beforeRenderRawModule mod_menu (Main Menu) (345.79KB) (3.5ms)
  • afterRenderRawModule mod_menu (Main Menu) (83.09KB) (491μs)
  • beforeRenderModule mod_menu (Main Menu) (704B) (4μs)
  • afterRenderModule mod_menu (Main Menu) (3.56KB) (114μs)
  • afterRender (182.48KB) (6.13ms)
  • 1 x afterRenderComponent com_content (391.22KB) (32.88%)
    18.29ms
    1 x afterInitialise (1.13MB) (27.03%)
    15.04ms
    1 x afterRender (182.48KB) (11.02%)
    6.13ms
    1 x afterRoute (72.85KB) (7.99%)
    4.45ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (345.79KB) (6.3%)
    3.50ms
    1 x beforeRenderComponent com_content (105.64KB) (5.56%)
    3.09ms
    1 x After Access::preloadComponents (all components) (114.12KB) (3.29%)
    1.83ms
    1 x After Access::preloadPermissions (com_content) (13.34KB) (1.67%)
    929μs
    1 x afterLoad (82.38KB) (1.63%)
    905μs
    1 x afterRenderRawModule mod_menu (Main Menu) (83.09KB) (0.88%)
    491μs
    1 x Before Access::preloadComponents (all components) (35.02KB) (0.78%)
    436μs
    1 x afterDispatch (3.16KB) (0.21%)
    118μs
    1 x afterRenderModule mod_menu (Main Menu) (3.56KB) (0.21%)
    114μs
    1 x After Access::getAssetRules (id:59 name:com_content.article.5) (7.38KB) (0.1%)
    58μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.02%)
    13μs
    1 x Before Access::getAssetRules (id:59 name:com_content.article.5) (104B) (0.02%)
    12μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0.01%)
    4μs
31 statements were executed, 6 of which were duplicates, 25 unique30.33ms131.83KB
UniquesDuplicates 1Duplicates 2
  • SELECT @@SESSION.sql_mode;72μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `ef_session` WHERE `session_id` = ?344μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `ef_session` WHERE `session_id` = :session_id LIMIT 189μ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.18ms944BParams/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` = 12.22ms1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `ef_viewlevels`347μ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` = :guest676μ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.03ms3.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`801μs3.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.16ms3.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `ef_content` WHERE `id` = :id834μs1.31KBParams/components/com_content/src/Service/Router.php:289Copy
  • SELECT * FROM `ef_languages` WHERE `published` = 1 ORDER BY `ordering` ASC500μ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.55ms832B/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.58ms7.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` = 0738μs2.36KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ef_content`369μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `ef_content` SET `hits` = (`hits` + 1) WHERE `id` = '5'902μ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.13ms22.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`611μs3.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)1.62ms4KBParams/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`274μ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 ASC1.39ms4.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 DESC4.82ms2.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`280μ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.22ms1.83KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT * FROM `ef_schemaorg` WHERE `itemId` = :itemId AND `context` = :context331μ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)288μ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)293μ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` = 1608μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `ef_session` WHERE `session_id` = ?151μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `ef_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?927μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy