contact

Cluster & Replik Vergleich

Lösung: Beratungselement Replikvergleich

Mit Hilfe eines notes-basierenden Tools werden die Datenbanken zwischen zwei Servern verglichen. Auf diese Weise wird aufgedeckt:

  • von welchen Datenbanken sind keine Repliken vorhanden
  • bei welchen Datenbanken bestehen Unterschiede in der Anzahl der Dokument
  • im Detailvergleich kann bis auf einzelne Dokumente analysiert werden

Auf Grund der protokollierten Ergebnisse des Vergleichs können notwendige Maßnahmen umgesetzt werden

Einsatzgebiet:

  • Implementierung von Clusterbildung
  • Analyse von laufendne Systemen
  • als Vorbereitung zu Hardware-Wechsel

Zitate

"Die Kultur der Toleranz beginnt damit,
zu akzeptieren, dass der andere anders ist."
(Roman Herzog)

J! InfoRequestSessionProfileQueries32
Settings18.176MBMemory Usage818msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.3
PHP Version8.1.33
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
8.0.36
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:40 [ "UNIQUE_ID" => "aQYqYc3Ikiyc_pn2YL8nUgAAAFo" "RZ_n" => "51716976" "RZ_a" => ":Rhttp...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1762011745 "last" => 1762011745...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.54MB) (97.68ms)
  • afterInitialise (7.18MB) (278ms)
  • afterRoute (905.8KB) (62.8ms)
  • beforeRenderComponent com_content (840.41KB) (41.33ms)
  • Before Access::preloadComponents (all components) (610.61KB) (18.37ms)
  • After Access::preloadComponents (all components) (123.59KB) (3.14ms)
  • Before Access::preloadPermissions (com_content) (2.76KB) (23μs)
  • After Access::preloadPermissions (com_content) (27.74KB) (2.01ms)
  • Before Access::getAssetRules (id:117 name:com_content.article.46) (6.8KB) (18μs)
  • After Access::getAssetRules (id:117 name:com_content.article.46) (26.71KB) (1.36ms)
  • afterRenderComponent com_content (2.39MB) (150ms)
  • afterDispatch (4.2KB) (773μs)
  • beforeRenderRawModule mod_articles_news (Zitate) (848.81KB) (34.1ms)
  • afterRenderRawModule mod_articles_news (Zitate) (428.18KB) (34.91ms)
  • beforeRenderRawModule mod_custom (Support (Sidebar)) (2.44KB) (53μs)
  • afterRenderRawModule mod_custom (Support (Sidebar)) (8.7KB) (4.11ms)
  • beforeRenderRawModule mod_menu (Stoll Training & Consulting) (2.93KB) (92μs)
  • afterRenderRawModule mod_menu (Stoll Training & Consulting) (235.2KB) (10.56ms)
  • beforeRenderRawModule mod_custom (Leistungen) (1.14KB) (89μs)
  • afterRenderRawModule mod_custom (Leistungen) (1.27KB) (646μs)
  • beforeRenderRawModule mod_custom (Partnerseiten) (720B) (21μs)
  • afterRenderRawModule mod_custom (Partnerseiten) (1.05KB) (245μs)
  • beforeRenderRawModule mod_menu (Bottom Menu) (2.55KB) (22μs)
  • afterRenderRawModule mod_menu (Bottom Menu) (18.2KB) (1.7ms)
  • beforeRenderModule mod_custom (Leistungen) (11.09KB) (2.85ms)
  • afterRenderModule mod_custom (Leistungen) (15.92KB) (2.64ms)
  • beforeRenderModule mod_custom (Partnerseiten) (1.64KB) (26μs)
  • afterRenderModule mod_custom (Partnerseiten) (3.58KB) (283μs)
  • beforeRenderModule mod_menu (Bottom Menu) (464B) (24μs)
  • afterRenderModule mod_menu (Bottom Menu) (3.19KB) (216μs)
  • beforeRenderModule mod_articles_news (Zitate) (504B) (50μs)
  • afterRenderModule mod_articles_news (Zitate) (4.52KB) (773μs)
  • beforeRenderModule mod_custom (Support (Sidebar)) (3.97KB) (25μs)
  • afterRenderModule mod_custom (Support (Sidebar)) (6.98KB) (733μs)
  • beforeRenderModule mod_menu (Stoll Training & Consulting) (1.61KB) (94μs)
  • afterRenderModule mod_menu (Stoll Training & Consulting) (4.45KB) (305μs)
  • beforeRenderRawModule mod_custom (Kontakt) (2.32KB) (48μs)
  • afterRenderRawModule mod_custom (Kontakt) (1008B) (305μs)
  • beforeRenderModule mod_custom (Kontakt) (704B) (6μs)
  • afterRenderModule mod_custom (Kontakt) (3.47KB) (303μs)
  • afterRender (660.62KB) (64.58ms)
  • 1 x afterInitialise (7.18MB) (33.97%)
    278ms
    1 x afterRenderComponent com_content (2.39MB) (18.34%)
    150ms
    1 x afterLoad (3.54MB) (11.95%)
    97.68ms
    1 x afterRender (660.62KB) (7.9%)
    64.58ms
    1 x afterRoute (905.8KB) (7.68%)
    62.80ms
    1 x beforeRenderComponent com_content (840.41KB) (5.06%)
    41.33ms
    1 x afterRenderRawModule mod_articles_news (Zitate) (428.18KB) (4.27%)
    34.91ms
    1 x beforeRenderRawModule mod_articles_news (Zitate) (848.81KB) (4.17%)
    34.10ms
    1 x Before Access::preloadComponents (all components) (610.61KB) (2.25%)
    18.37ms
    1 x afterRenderRawModule mod_menu (Stoll Training & Consulting) (235.2KB) (1.29%)
    10.56ms
    1 x afterRenderRawModule mod_custom (Support (Sidebar)) (8.7KB) (0.5%)
    4.11ms
    1 x After Access::preloadComponents (all components) (123.59KB) (0.38%)
    3.14ms
    1 x beforeRenderModule mod_custom (Leistungen) (11.09KB) (0.35%)
    2.85ms
    1 x afterRenderModule mod_custom (Leistungen) (15.92KB) (0.32%)
    2.64ms
    1 x After Access::preloadPermissions (com_content) (27.74KB) (0.25%)
    2.01ms
    1 x afterRenderRawModule mod_menu (Bottom Menu) (18.2KB) (0.21%)
    1.70ms
    1 x After Access::getAssetRules (id:117 name:com_content.article.46) (26.71KB) (0.17%)
    1.36ms
    1 x afterDispatch (4.2KB) (0.09%)
    773μs
    1 x afterRenderModule mod_articles_news (Zitate) (4.52KB) (0.09%)
    773μs
    1 x afterRenderModule mod_custom (Support (Sidebar)) (6.98KB) (0.09%)
    733μs
    1 x afterRenderRawModule mod_custom (Leistungen) (1.27KB) (0.08%)
    646μs
    1 x afterRenderModule mod_menu (Stoll Training & Consulting) (4.45KB) (0.04%)
    305μs
    1 x afterRenderRawModule mod_custom (Kontakt) (1008B) (0.04%)
    305μs
    1 x afterRenderModule mod_custom (Kontakt) (3.47KB) (0.04%)
    303μs
    1 x afterRenderModule mod_custom (Partnerseiten) (3.58KB) (0.03%)
    283μs
    1 x afterRenderRawModule mod_custom (Partnerseiten) (1.05KB) (0.03%)
    245μs
    1 x afterRenderModule mod_menu (Bottom Menu) (3.19KB) (0.03%)
    216μs
    1 x beforeRenderModule mod_menu (Stoll Training & Consulting) (1.61KB) (0.01%)
    94μs
    1 x beforeRenderRawModule mod_menu (Stoll Training & Consulting) (2.93KB) (0.01%)
    92μs
    1 x beforeRenderRawModule mod_custom (Leistungen) (1.14KB) (0.01%)
    89μs
    1 x beforeRenderRawModule mod_custom (Support (Sidebar)) (2.44KB) (0.01%)
    53μs
    1 x beforeRenderModule mod_articles_news (Zitate) (504B) (0.01%)
    50μs
    1 x beforeRenderRawModule mod_custom (Kontakt) (2.32KB) (0.01%)
    48μs
    1 x beforeRenderModule mod_custom (Partnerseiten) (1.64KB) (0%)
    26μs
    1 x beforeRenderModule mod_custom (Support (Sidebar)) (3.97KB) (0%)
    25μs
    1 x beforeRenderModule mod_menu (Bottom Menu) (464B) (0%)
    24μs
    1 x Before Access::preloadPermissions (com_content) (2.76KB) (0%)
    23μs
    1 x beforeRenderRawModule mod_menu (Bottom Menu) (2.55KB) (0%)
    22μs
    1 x beforeRenderRawModule mod_custom (Partnerseiten) (720B) (0%)
    21μs
    1 x Before Access::getAssetRules (id:117 name:com_content.article.46) (6.8KB) (0%)
    18μs
    1 x beforeRenderModule mod_custom (Kontakt) (704B) (0%)
    6μs
32 statements were executed, 7 of which were duplicates, 25 unique46.26ms143.92KB
UniquesDuplicates 1Duplicates 2Duplicates 3
  • SELECT @@SESSION.sql_mode;836μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `stc_session` WHERE `session_id` = ?903μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `stc_session` WHERE `session_id` = :session_id LIMIT 1900μ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)2.44ms944BParams/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` = 11ms2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `stc_viewlevels`1ms976B/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` = :guest972μ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.34ms4.3KBParams/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`1.17ms22.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`1.12ms5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `stc_content` WHERE `id` = :id878μs1.63KBParams/components/com_content/src/Service/Router.php:289Copy
  • SELECT * FROM `stc_languages` WHERE `published` = 1 ORDER BY `ordering` ASC2.35ms2.23KB/libraries/src/Language/LanguageHelper.php:179Copy
  • 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` = 11.01ms1.14KB/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • 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)1.07ms7.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` = 0989μ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.41ms8.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`1.48ms7.67KBParams/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)1.11ms5.22KBParams/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.23ms5.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.49ms6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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.29ms5.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`1.22ms2.34KBParams/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 11.77ms9.45KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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.32ms5.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.07ms5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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.06ms5.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.04ms6KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT * FROM `stc_schemaorg` WHERE `itemId` = :itemId AND `context` = :context912μs1.86KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:429Copy
  • 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.67ms8.67KBParams/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 `stc_scheduler_tasks` AS `a` WHERE `a`.`state` = 14.53ms1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `stc_session` WHERE `session_id` = ?891μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `stc_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?3.79ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy