contact

Workflow Container

Leistungsmerkmale:

freie Workflow Konfiguration

mehrere Dokumentprozesse in einer Datenbank möglich

unbegrenzte Anzahl Workflowschritte

Aktionshistorie

Protokollierung jeder Statusänderung

Workflow Gruppen

Definition von Funktionsgruppen für Versand von Benachrichtigungen und Berechtigung

Administration

Zugriffssteuerung für jedes Einstellungsdokument

Status Definition

Vergabe von Statusnummer, Text und Ansichtssymbol

Kommentarhistorie

pro Status kann eine Kommentarhistorie aktiviert werden. Darin wird eingegebene Text in einer fortlaufenden Protokollierung festgehalten

Dokument Rollen

In jedem Status kann dem aktuellen Bearbeiter eine Rolle zugewiesen werden. Auf diese Rolle kann im weiteren Verlauf des Workflows wieder zurück gegriffen werden

Parallele Prozessverarbeitung

Durch die Parallelverarbeitung können ausgehend von einem Hauptdokument beliebig viele Teilprozesse gestartet werden. Erst wenn alle Teilprozesse abgeschlossen sind,  wird das Hauptdokument fortgeschrieben. Durch die Teilprozesse können einzelne Information extrahiert und bestimmten Personengruppen bereitgestellt werden, ohne Zugriff auf alle Informationen des Hauptdokuments gewähren zu müssen.

N-Augen-Prinzip

Diese neue Funktion erlaubt eine Einschränkung für die Fortsetzung im nächsten Workflow-Schritt. Erst wenn eine definierte Anzahl Augenpaare die Fortsetzung bestätigt hat, wird der Workflow weiterverarbeitet. Selbstverständlich ist sichergestellt, dass keine Person zweimal  bestätigen kann.

Feldhistorie

Mit dieser neuen Funktion können in jedem Status beliebige Felder auf inhaltliche Änderungen überwacht werden. Die Dokumentation der Änderungen kann in benutzerdefinierten Feldern erfolgen. Die Konfiguration der Änderungshistorie für Felder erfolgt in den Einstellungsdokumenten für Workflow-Schritte.

Dokumentgestaltung

Standardbezeichnung von Dokumenten können ebenso angepasst werden, wie beispielsweise auch die Beschriftung von Standard-Schaltflächen.

Zähler

Vergabe eines Zählernamens

Vergabe eines Präfix

Festlegen der Zeichenlänge des Zählers

Auswahl nächster Bearbeiter durch Anwender

Definition der Auswahlmöglichkeiten

- freie oder vorgegebene Auswahlliste

- Dokument Ersteller

- letzter Bearbeiter

- freie, vorgegebene oder eingeschränkte Gruppenauswahl

Weiterleitung

Festlegen von Aktionsbezeichnung und Symbol

Hinterlegen eines zu verwendenden Benachrichtigungsprofils

ggf. gleichzeitige Statusveränderung

Eskalation

- Angabe eines festen Eskalationszeitraums in Tagen, Stunden oder Minuten

- Statuswechsel bei Eskalation

- Informationen zu Zeitraum und Statuswechsel durch Eingabe des Anwenders festlegen

- Ausschließen von Wochenende möglich

Body-Feld

Anzeigen eines Body-Feldes zum Lesen oder Bearbeiten

10 stufiges Statuswechsel Konzept

10 Aktionen zum Statuswechsel möglich

- positiv oder negativ berechnete Statuswechsel

- statische Statuswechsel

- Statuswechsel in Abhängigkeit von Eingaben der Anwender

Definition von

- Bezeichnung der Schaltfläche

- Symbol

- Dokument nach Statuswechsel zum Weiterarbeiten erneut öffnen

Benachrichtigung

Umfangreiche Empfängerauswahl:

- Freie Auswahl

- Dokument Ersteller

- Letzter Bearbeiter

- Gruppe

- Dokument Rolle

- Auswahl durch den Anwender

Angabe von Betreff und Text unter Verwendung von Variablen

Einbindung von Dokumentverknüpfung

Standard Aktionen

Anzeige von Standard Aktionen für Lese- oder Bearbeiten-Modus

Berechtigung

Vergabe von Lese- und Bearbeitungsrechten mit diesen Auswahlkriterien:

- Freie Auswahl

- Dokument Ersteller

- Letzter Bearbeiter

- Gruppe

- Dokument Rolle

- Auswahl durch den Anwender

Steuerung der wechselnden Berechtigungen:

- Zurücksetzen

- Beibehalten

- Ersetzen

- Hinzufügen

Bedingte Ausführung gemäß Formel

Differenzierte Pflichtfeldprüfung

Auswahl von zu prüfenden Feldern beim Verlassen oder Erreichen eines neuen Status

Bedingte Ausführung gemäß Formel

Zentrale Felddefinition

Pflege von Fehlertexten und Mailvariablen

Mit diesen Funktionen sind für Domino Designern weitere Möglichkeiten zur Gestaltung verfügbar:

Zähler

freie Definition des zu verwendenden Feldes

Teilmasken

Umgang mit System-Teilmasken

Einbinden von eigenen Teilmasken

Formel Aktionen

Anzeigen zum Lesen und/oder Bearbeiten

Definition von Formel zum Anzeigen/Verbergen

Symbolauswahl

freie Formeleingabe

Auswahl nächster Bearbeiter durch Anwender

Definition der zu verwendenden Teilmaske

Weiterleitung

Definition der zu verwendenden Teilmaske

Eskalation

Definition der zu verwendenden Felder bei Eingabe des Anwenders

Statuswechsel Konzept

Nachschalten von eigenen Agenten zu jeder Aktion

ggf. Einbinden von eigenen Teilmasken und Feldern

Definition von Formel zum Anzeigen/Verbergen

Benachrichtigung

Erweiterte Empfängerauswahl:

- Dediziertes Feld

Einstellungsdokumente

Erweiterung durch Einbinden eigener Einstellungsdokumente

Erweitere Einstellungen

Durch Einbindung einer Teilmaske können individuelle Einstellungsfelder integriert werden

Ausführungskonzept

Durch ein neues Ausführungskonzept werden standardisierte Funktionen eingeführt, auf die nun einfach zugegriffen werden kann. Eigene Anpassungen im Workflow Container sind nun noch einfacher zu realisieren.

Einbindug eigener Programmierung

Neben der Möglichkeit, die Workflow Statuswechsel in eigenen Programmteile einzubinden, kann diese Funktion jetzt auch vollkommen im Backend über die Verwendung dieses neuen Agenten genutzt werden.

Zitate

"Nichts bringt uns mehr vom Weg zum Glück ab,
als dass wir uns nach dem Gerede der Leute richten,
statt nach unseren Überzeugungen."
(Seneca)

J! InfoRequestSessionProfileQueries31
16.831MBMemory Usage773msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
5.7.42-log
Collation
utf8_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:48 [ "UNIQUE_ID" => "Z_PC1M9bWj8BFS9xqHUt1QAADMQ" "RZ_n" => "51716976" "RZ_a" => ":Rhttp...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744028373 "last" => 1744028373...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.04MB) (133ms)
  • afterInitialise (6.07MB) (295ms)
  • afterRoute (978.84KB) (63.54ms)
  • beforeRenderComponent com_content (888.83KB) (43.16ms)
  • Before Access::preloadComponents (all components) (582.23KB) (22.92ms)
  • After Access::preloadComponents (all components) (113.73KB) (2.92ms)
  • Before Access::preloadPermissions (com_content) (2.76KB) (64μs)
  • After Access::preloadPermissions (com_content) (40.51KB) (1.88ms)
  • Before Access::getAssetRules (id:120 name:com_content.article.49) (6.8KB) (45μs)
  • After Access::getAssetRules (id:120 name:com_content.article.49) (26.84KB) (2.01ms)
  • afterRenderComponent com_content (1.32MB) (68.99ms)
  • afterDispatch (2.28KB) (216μs)
  • beforeRenderRawModule mod_articles_news (Zitate) (1.36MB) (29.92ms)
  • afterRenderRawModule mod_articles_news (Zitate) (363.37KB) (32.52ms)
  • beforeRenderRawModule mod_custom (Support (Sidebar)) (2.44KB) (68μs)
  • afterRenderRawModule mod_custom (Support (Sidebar)) (8.7KB) (5.55ms)
  • beforeRenderRawModule mod_menu (Stoll Training & Consulting) (2.99KB) (113μs)
  • afterRenderRawModule mod_menu (Stoll Training & Consulting) (331.53KB) (17.86ms)
  • beforeRenderRawModule mod_search (Suchen) (800B) (98μs)
  • afterRenderRawModule mod_search (Suchen) (52.32KB) (10.08ms)
  • beforeRenderRawModule mod_custom (Leistungen) (1.09KB) (112μs)
  • afterRenderRawModule mod_custom (Leistungen) (1.33KB) (873μs)
  • beforeRenderRawModule mod_custom (Partnerseiten) (720B) (42μs)
  • afterRenderRawModule mod_custom (Partnerseiten) (1.05KB) (399μs)
  • beforeRenderRawModule mod_menu (Bottom Menu) (2.55KB) (44μs)
  • afterRenderRawModule mod_menu (Bottom Menu) (18.2KB) (2.35ms)
  • beforeRenderModule mod_custom (Leistungen) (24.77KB) (2.12ms)
  • afterRenderModule mod_custom (Leistungen) (3.62KB) (1.67ms)
  • beforeRenderModule mod_custom (Partnerseiten) (1.15KB) (47μs)
  • afterRenderModule mod_custom (Partnerseiten) (3.09KB) (402μs)
  • beforeRenderModule mod_menu (Bottom Menu) (968B) (39μs)
  • afterRenderModule mod_menu (Bottom Menu) (2.7KB) (343μs)
  • beforeRenderModule mod_articles_news (Zitate) (1008B) (75μs)
  • afterRenderModule mod_articles_news (Zitate) (6.48KB) (926μs)
  • beforeRenderModule mod_custom (Support (Sidebar)) (3.48KB) (44μs)
  • afterRenderModule mod_custom (Support (Sidebar)) (3.98KB) (904μs)
  • beforeRenderModule mod_search (Suchen) (2.12KB) (157μs)
  • afterRenderModule mod_search (Suchen) (3.52KB) (422μs)
  • beforeRenderModule mod_menu (Stoll Training & Consulting) (848B) (78μs)
  • afterRenderModule mod_menu (Stoll Training & Consulting) (3.96KB) (359μs)
  • beforeRenderRawModule mod_custom (Kontakt) (1.52KB) (74μs)
  • afterRenderRawModule mod_custom (Kontakt) (1008B) (438μs)
  • beforeRenderModule mod_custom (Kontakt) (704B) (11μs)
  • afterRenderModule mod_custom (Kontakt) (2.98KB) (441μs)
  • afterRender (280.15KB) (28.43ms)
  • 1 x afterInitialise (6.07MB) (38.23%)
    295.44ms
    1 x afterLoad (4.04MB) (17.16%)
    132.59ms
    1 x afterRenderComponent com_content (1.32MB) (8.93%)
    68.99ms
    1 x afterRoute (978.84KB) (8.22%)
    63.54ms
    1 x beforeRenderComponent com_content (888.83KB) (5.59%)
    43.16ms
    1 x afterRenderRawModule mod_articles_news (Zitate) (363.37KB) (4.21%)
    32.52ms
    1 x beforeRenderRawModule mod_articles_news (Zitate) (1.36MB) (3.87%)
    29.92ms
    1 x afterRender (280.15KB) (3.68%)
    28.43ms
    1 x Before Access::preloadComponents (all components) (582.23KB) (2.97%)
    22.92ms
    1 x afterRenderRawModule mod_menu (Stoll Training & Consulting) (331.53KB) (2.31%)
    17.86ms
    1 x afterRenderRawModule mod_search (Suchen) (52.32KB) (1.3%)
    10.08ms
    1 x afterRenderRawModule mod_custom (Support (Sidebar)) (8.7KB) (0.72%)
    5.55ms
    1 x After Access::preloadComponents (all components) (113.73KB) (0.38%)
    2.92ms
    1 x afterRenderRawModule mod_menu (Bottom Menu) (18.2KB) (0.3%)
    2.35ms
    1 x beforeRenderModule mod_custom (Leistungen) (24.77KB) (0.27%)
    2.12ms
    1 x After Access::getAssetRules (id:120 name:com_content.article.49) (26.84KB) (0.26%)
    2.01ms
    1 x After Access::preloadPermissions (com_content) (40.51KB) (0.24%)
    1.88ms
    1 x afterRenderModule mod_custom (Leistungen) (3.62KB) (0.22%)
    1.67ms
    1 x afterRenderModule mod_articles_news (Zitate) (6.48KB) (0.12%)
    926μs
    1 x afterRenderModule mod_custom (Support (Sidebar)) (3.98KB) (0.12%)
    904μs
    1 x afterRenderRawModule mod_custom (Leistungen) (1.33KB) (0.11%)
    873μs
    1 x afterRenderModule mod_custom (Kontakt) (2.98KB) (0.06%)
    441μs
    1 x afterRenderRawModule mod_custom (Kontakt) (1008B) (0.06%)
    438μs
    1 x afterRenderModule mod_search (Suchen) (3.52KB) (0.05%)
    422μs
    1 x afterRenderModule mod_custom (Partnerseiten) (3.09KB) (0.05%)
    402μs
    1 x afterRenderRawModule mod_custom (Partnerseiten) (1.05KB) (0.05%)
    399μs
    1 x afterRenderModule mod_menu (Stoll Training & Consulting) (3.96KB) (0.05%)
    359μs
    1 x afterRenderModule mod_menu (Bottom Menu) (2.7KB) (0.04%)
    343μs
    1 x afterDispatch (2.28KB) (0.03%)
    216μs
    1 x beforeRenderModule mod_search (Suchen) (2.12KB) (0.02%)
    157μs
    1 x beforeRenderRawModule mod_menu (Stoll Training & Consulting) (2.99KB) (0.01%)
    113μs
    1 x beforeRenderRawModule mod_custom (Leistungen) (1.09KB) (0.01%)
    112μs
    1 x beforeRenderRawModule mod_search (Suchen) (800B) (0.01%)
    98μs
    1 x beforeRenderModule mod_menu (Stoll Training & Consulting) (848B) (0.01%)
    78μs
    1 x beforeRenderModule mod_articles_news (Zitate) (1008B) (0.01%)
    75μs
    1 x beforeRenderRawModule mod_custom (Kontakt) (1.52KB) (0.01%)
    74μs
    1 x beforeRenderRawModule mod_custom (Support (Sidebar)) (2.44KB) (0.01%)
    68μs
    1 x Before Access::preloadPermissions (com_content) (2.76KB) (0.01%)
    64μs
    1 x beforeRenderModule mod_custom (Partnerseiten) (1.15KB) (0.01%)
    47μs
    1 x Before Access::getAssetRules (id:120 name:com_content.article.49) (6.8KB) (0.01%)
    45μs
    1 x beforeRenderRawModule mod_menu (Bottom Menu) (2.55KB) (0.01%)
    44μs
    1 x beforeRenderModule mod_custom (Support (Sidebar)) (3.48KB) (0.01%)
    44μs
    1 x beforeRenderRawModule mod_custom (Partnerseiten) (720B) (0.01%)
    42μs
    1 x beforeRenderModule mod_menu (Bottom Menu) (968B) (0.01%)
    39μs
    1 x beforeRenderModule mod_custom (Kontakt) (704B) (0%)
    11μs
31 statements were executed, 7 of which were duplicates, 24 unique30.39ms150.55KB
UniquesDuplicates 1Duplicates 2Duplicates 3
  • SELECT @@SESSION.sql_mode;344μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `stc_session` WHERE `session_id` = ?351μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `stc_session` WHERE `session_id` = :session_id LIMIT 1349μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `stc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)3.01ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `stc_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1567μs2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `stc_viewlevels`335μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `stc_usergroups` AS `a` LEFT JOIN `stc_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest414μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `stc_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`1.31ms3.8KBParams/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 `stc_menu` AS `m` LEFT JOIN `stc_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`789μs22.02KBParams/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 `stc_categories` AS `s` INNER JOIN `stc_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`719μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `stc_languages` WHERE `published` = 1 ORDER BY `ordering` ASC496μs2.23KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `stc_template_styles` AS `s` LEFT JOIN `stc_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` = 1670μs1.14KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `stc_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,:preparedArray40,:preparedArray41)1.08ms7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `stc_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0686μs3.05KBParams/libraries/src/Access/Access.php:301Copy
  • 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 `stc_content` AS `a` INNER JOIN `stc_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `stc_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `stc_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `stc_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `stc_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.02ms24.67KBParams/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 `stc_categories` AS `s` INNER JOIN `stc_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`662μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `stc_contentitem_tag_map` AS `m` INNER JOIN `stc_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)526μs7.72KBParams/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 `stc_categories` AS `s` INNER JOIN `stc_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.51ms5.17KBParams/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 stc_fields AS a LEFT JOIN `stc_languages` AS l ON l.lang_code = a.language LEFT JOIN stc_users AS uc ON uc.id=a.checked_out LEFT JOIN stc_viewlevels AS ag ON ag.id = a.access LEFT JOIN stc_users AS ua ON ua.id = a.created_user_id LEFT JOIN stc_fields_groups AS g ON g.id = a.group_id LEFT JOIN `stc_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 ASC2.7ms6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.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 `stc_categories` AS `s` INNER JOIN `stc_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.36ms5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `stc_modules` AS `m` LEFT JOIN `stc_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `stc_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`914μs2.38KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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` FROM `stc_content` AS `a` LEFT JOIN `stc_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `stc_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `stc_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `stc_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `stc_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` <> :articleId AND `a`.`catid` IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY RAND() ASC LIMIT 12.73ms9.45KBParams/libraries/src/MVC/Model/BaseDatabaseModel.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 `stc_categories` AS `s` INNER JOIN `stc_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`692μs5.16KBParams/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 stc_fields AS a LEFT JOIN `stc_languages` AS l ON l.lang_code = a.language LEFT JOIN stc_users AS uc ON uc.id=a.checked_out LEFT JOIN stc_viewlevels AS ag ON ag.id = a.access LEFT JOIN stc_users AS ua ON ua.id = a.created_user_id LEFT JOIN stc_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 ASC1.01ms5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.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 `stc_categories` AS `s` INNER JOIN `stc_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`654μs5.16KBParams/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 stc_fields AS a LEFT JOIN `stc_languages` AS l ON l.lang_code = a.language LEFT JOIN stc_users AS uc ON uc.id=a.checked_out LEFT JOIN stc_viewlevels AS ag ON ag.id = a.access LEFT JOIN stc_users AS ua ON ua.id = a.created_user_id LEFT JOIN stc_fields_groups AS g ON g.id = a.group_id LEFT JOIN `stc_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.19ms6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `alias` FROM `stc_content` WHERE `id` = :id413μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `stc_content` WHERE `id` = :id466μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `stc_scheduler_tasks` AS `a` WHERE `a`.`state` = 1517μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `stc_session` WHERE `session_id` = ?375μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `stc_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2.52ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy