In dit bouwverslag (of is het toch een ombouwverslag) ga ik laten zien hoe ik een werkwagen ga 'upgraden'.

Het is een vergelijkbare upgrade als mijn eigen 5221, maar nu voor iemand anders. (Werk-motorwagen 5221 is in eigen huis in 2018 omgebouwd waarbij de motorwagen is voorzien van een werkend achterlicht, en een set werkende zwaailichten.)

 

Om te kunnen kijken wat we met de huidige situatie kunnen, om de werkwagen aan te passen, gaan we deze uit elkaar halen, om deze daarna stap voor stap weer op te bouwen, inclusief aanpassingen. Het doel: Deze werkwagen weer laten rijden op de hobbybeurs in Assen, op de trambaan van de Haagse Module Groep.

---

Edit 13 april 2019: De missie om de tram rijdende te hebben op de beurs in Assen is mislukt! Om één of andere reden zit er een storing in de ombouw. Om dit correct op te lossen is de modeltram even ter zijde gezet om daarna alle stappen opnieuw te doorlopen en te controleren waar het mis is gegaan. Ook word een reserve decoder bij de hand gehouden, voor mocht daar het probleem blijken te liggen. Op zo kort mogelijke termijn word de ombouw verder afgewerkt in dit verslag, dat is namelijk blijven liggen door drukte.

---

Onlangs kreeg ik het verzoek of ik een werkwagen wilde gaan ombouwen. Dit, omdat mijn eigen werkwagen, de 5221, al diverse keren op de baan van de Haagse Module Groep heeft gereden en dit een zelfde werkwagen is. Dat leek me een leuke klus dus dat gaan we doen. Omdat ik van de 5221 destijds géén ombouw verslag had gemaakt, wil ik dat hier nu wèl doen.

 

Om te beginnen een overzicht wat het doel is en hoe we te werk gaan:

Doel:

  1. Het plaatsen van een werkend sluitsein op beide koppen, mee-wisselend met de rij-richting.
  2. Het plaatsen van een set zwaailichten op het dak van de werk-motorwagen.

Hierbij moet er gekeken worden, of er met de huidige decoder genoeg aansluitingen zijn om de zwaailichten te laten werken. De sluitlichten worden gekoppeld aan de frontseinen, dat is de makkelijkste oplossing.

 

Hoe gaan we aan het werk:

  • Demontage: We moeten de wagen uit elkaar halen, zo ver als noodzakelijk is om de werkwagen aan te passen.
  • Inventariseren wat we precies nodig hebben voor de upgrade en of dit voorhanden is.
  • Onderhoud en reparatie; Nu we de motorwagen toch groot en deels uit elkaar hebben, is het handig om defecten meteen te herstellen, en onderhoud te plegen aan het hart: De motor. In dit geval komt dat neer op het reinigen van de wielen en tandwielen, het opnieuw smeren van de tandwielen en zorgen dat de motor nog jaren als een zonnetje mag lopen.
  • Opbouwen van de werkwagen: Het opnieuw in elkaar zetten stap voor stap, maar nu inclusief de upgrades.
  • Testen: natuurlijk éérst testen, programmeren en controleren voordat de tram word afgeleverd.
  • Afleveren; Als alles goed gaat en de tram is gereed, dan zal deze rijden op de modelbaan van de Haagse Module Groep, naar verwachting op de hobby beurs in Assen, op 1, 2 en 3 maart 2019.

De werk-motorwagen is nu voorzien van een decoder van ESU en rijd op zich mooi op de baan van de HMG (Analoog 2-rail) maar het kan beter. Er zijn best verschillen tussen het rijden van deze werkwagen en de 5221. Om die reden ook, doe ik een onderhoudsbeurt voor de aandrijving. Na de vele kilometers die deze werkwagen al heeft gereden, is dat geen overbodige luxe!

Harry's werkwagen vóór de verbouwing.

 De werkwagen vóór de verbouwing.

Op de volgende pagina gaan we beginnen met het avontuur..

18.05MBMemory Usage710msRequest Duration
Joomla! Version4.4.13
PHP Version8.1.33
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" => "aIbsOYl4N_Xy_ml2LVAj3wAAACU" "RZ_n" => "510285223" "RZ_a" => ":Rhtt...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1753672761 "last" => 1753672761...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_webauthn
array:1 [ "returnUrl" => "https://bommeldamschetram.nl/index.php/bouwverslagen/84-ombouw-harry-s-r...
  • afterLoad (4.1MB) (102ms)
  • afterInitialise (6.89MB) (291ms)
  • afterRoute (691.24KB) (35.87ms)
  • beforeRenderComponent com_content (891.49KB) (38.57ms)
  • Before Access::preloadComponents (all components) (398.04KB) (12.1ms)
  • After Access::preloadComponents (all components) (112.77KB) (5.47ms)
  • Before Access::preloadPermissions (com_content) (61.24KB) (21μs)
  • After Access::preloadPermissions (com_content) (154.61KB) (2.22ms)
  • Before Access::getAssetRules (id:218 name:com_content.article.84) (10.8KB) (35μs)
  • After Access::getAssetRules (id:218 name:com_content.article.84) (26.9KB) (1.26ms)
  • afterRenderComponent com_content (2.61MB) (102ms)
  • afterDispatch (2.28KB) (121μs)
  • beforeRenderRawModule mod_menu ( Menu) (600.46KB) (20.63ms)
  • afterRenderRawModule mod_menu ( Menu) (156.13KB) (14.4ms)
  • beforeRenderRawModule mod_menu (Bommeldam) (768B) (38μs)
  • afterRenderRawModule mod_menu (Bommeldam) (114.88KB) (4.15ms)
  • beforeRenderRawModule mod_menu (Openbaar Vervoer) (656B) (40μs)
  • afterRenderRawModule mod_menu (Openbaar Vervoer) (27.11KB) (1.84ms)
  • beforeRenderRawModule mod_menu (OV-Museum) (720B) (38μs)
  • afterRenderRawModule mod_menu (OV-Museum) (117.25KB) (4.34ms)
  • beforeRenderRawModule mod_menu (Wagenwerkplaats) (752B) (42μs)
  • afterRenderRawModule mod_menu (Wagenwerkplaats) (53.38KB) (2.39ms)
  • beforeRenderRawModule mod_search (Zoeken) (1.24KB) (65μs)
  • afterRenderRawModule mod_search (Zoeken) (63.45KB) (8.52ms)
  • beforeRenderRawModule mod_footer ( Footer) (1.28KB) (70μs)
  • afterRenderRawModule mod_footer ( Footer) (16.55KB) (4.78ms)
  • beforeRenderRawModule mod_login ( Login) (1.06KB) (40μs)
  • afterRenderRawModule mod_login ( Login) (367.83KB) (20.23ms)
  • beforeRenderModule mod_footer ( Footer) (29.25KB) (926μs)
  • afterRenderModule mod_footer ( Footer) (2.96KB) (1.06ms)
  • beforeRenderModule mod_login ( Login) (8B) (40μs)
  • afterRenderModule mod_login ( Login) (9.93KB) (258μs)
  • beforeRenderModule mod_menu ( Menu) (1.19KB) (74μs)
  • afterRenderModule mod_menu ( Menu) (7.16KB) (903μs)
  • beforeRenderModule mod_menu (Bommeldam) (328B) (39μs)
  • afterRenderModule mod_menu (Bommeldam) (3.77KB) (381μs)
  • beforeRenderModule mod_menu (Openbaar Vervoer) (488B) (42μs)
  • afterRenderModule mod_menu (Openbaar Vervoer) (2.32KB) (334μs)
  • beforeRenderModule mod_menu (OV-Museum) (888B) (36μs)
  • afterRenderModule mod_menu (OV-Museum) (3.18KB) (339μs)
  • beforeRenderModule mod_menu (Wagenwerkplaats) (824B) (35μs)
  • afterRenderModule mod_menu (Wagenwerkplaats) (2.7KB) (329μs)
  • beforeRenderModule mod_search (Zoeken) (808B) (120μs)
  • afterRenderModule mod_search (Zoeken) (2.68KB) (252μs)
  • beforeRenderRawModule mod_custom ( Topbar) (1.88KB) (55μs)
  • afterRenderRawModule mod_custom ( Topbar) (8.93KB) (4.4ms)
  • beforeRenderModule mod_custom ( Topbar) (704B) (8μs)
  • afterRenderModule mod_custom ( Topbar) (2.21KB) (292μs)
  • afterRender (252.52KB) (25.3ms)
  • 1 x afterInitialise (6.89MB) (41%)
    291.17ms
    1 x afterRenderComponent com_content (2.61MB) (14.43%)
    102.49ms
    1 x afterLoad (4.1MB) (14.31%)
    101.65ms
    1 x beforeRenderComponent com_content (891.49KB) (5.43%)
    38.57ms
    1 x afterRoute (691.24KB) (5.05%)
    35.87ms
    1 x afterRender (252.52KB) (3.56%)
    25.30ms
    1 x beforeRenderRawModule mod_menu ( Menu) (600.46KB) (2.9%)
    20.63ms
    1 x afterRenderRawModule mod_login ( Login) (367.83KB) (2.85%)
    20.23ms
    1 x afterRenderRawModule mod_menu ( Menu) (156.13KB) (2.03%)
    14.40ms
    1 x Before Access::preloadComponents (all components) (398.04KB) (1.7%)
    12.10ms
    1 x afterRenderRawModule mod_search (Zoeken) (63.45KB) (1.2%)
    8.52ms
    1 x After Access::preloadComponents (all components) (112.77KB) (0.77%)
    5.47ms
    1 x afterRenderRawModule mod_footer ( Footer) (16.55KB) (0.67%)
    4.78ms
    1 x afterRenderRawModule mod_custom ( Topbar) (8.93KB) (0.62%)
    4.40ms
    1 x afterRenderRawModule mod_menu (OV-Museum) (117.25KB) (0.61%)
    4.34ms
    1 x afterRenderRawModule mod_menu (Bommeldam) (114.88KB) (0.58%)
    4.15ms
    1 x afterRenderRawModule mod_menu (Wagenwerkplaats) (53.38KB) (0.34%)
    2.39ms
    1 x After Access::preloadPermissions (com_content) (154.61KB) (0.31%)
    2.22ms
    1 x afterRenderRawModule mod_menu (Openbaar Vervoer) (27.11KB) (0.26%)
    1.84ms
    1 x After Access::getAssetRules (id:218 name:com_content.article.84) (26.9KB) (0.18%)
    1.26ms
    1 x afterRenderModule mod_footer ( Footer) (2.96KB) (0.15%)
    1.06ms
    1 x beforeRenderModule mod_footer ( Footer) (29.25KB) (0.13%)
    926μs
    1 x afterRenderModule mod_menu ( Menu) (7.16KB) (0.13%)
    903μs
    1 x afterRenderModule mod_menu (Bommeldam) (3.77KB) (0.05%)
    381μs
    1 x afterRenderModule mod_menu (OV-Museum) (3.18KB) (0.05%)
    339μs
    1 x afterRenderModule mod_menu (Openbaar Vervoer) (2.32KB) (0.05%)
    334μs
    1 x afterRenderModule mod_menu (Wagenwerkplaats) (2.7KB) (0.05%)
    329μs
    1 x afterRenderModule mod_custom ( Topbar) (2.21KB) (0.04%)
    292μs
    1 x afterRenderModule mod_login ( Login) (9.93KB) (0.04%)
    258μs
    1 x afterRenderModule mod_search (Zoeken) (2.68KB) (0.04%)
    252μs
    1 x afterDispatch (2.28KB) (0.02%)
    121μs
    1 x beforeRenderModule mod_search (Zoeken) (808B) (0.02%)
    120μs
    1 x beforeRenderModule mod_menu ( Menu) (1.19KB) (0.01%)
    74μs
    1 x beforeRenderRawModule mod_footer ( Footer) (1.28KB) (0.01%)
    70μs
    1 x beforeRenderRawModule mod_search (Zoeken) (1.24KB) (0.01%)
    65μs
    1 x beforeRenderRawModule mod_custom ( Topbar) (1.88KB) (0.01%)
    55μs
    1 x beforeRenderRawModule mod_menu (Wagenwerkplaats) (752B) (0.01%)
    42μs
    1 x beforeRenderModule mod_menu (Openbaar Vervoer) (488B) (0.01%)
    42μs
    1 x beforeRenderRawModule mod_menu (Openbaar Vervoer) (656B) (0.01%)
    40μs
    1 x beforeRenderModule mod_login ( Login) (8B) (0.01%)
    40μs
    1 x beforeRenderRawModule mod_login ( Login) (1.06KB) (0.01%)
    40μs
    1 x beforeRenderModule mod_menu (Bommeldam) (328B) (0.01%)
    39μs
    1 x beforeRenderRawModule mod_menu (Bommeldam) (768B) (0.01%)
    38μs
    1 x beforeRenderRawModule mod_menu (OV-Museum) (720B) (0.01%)
    38μs
    1 x beforeRenderModule mod_menu (OV-Museum) (888B) (0.01%)
    36μs
    1 x Before Access::getAssetRules (id:218 name:com_content.article.84) (10.8KB) (0%)
    35μs
    1 x beforeRenderModule mod_menu (Wagenwerkplaats) (824B) (0%)
    35μs
    1 x Before Access::preloadPermissions (com_content) (61.24KB) (0%)
    21μs
    1 x beforeRenderModule mod_custom ( Topbar) (704B) (0%)
    8μs
32 statements were executed, 5 of which were duplicates, 27 unique53.59ms225.97KB
  • SELECT @@SESSION.sql_mode;438μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?546μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1610μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)3.82ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 11.18ms2.23KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`583μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos_usergroups` AS `a` LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest724μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jos_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`2.35ms3.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `value` FROM `jos_admintools_storage` WHERE `key` = 'cparams'1.08ms2.09KB/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `jos_admintools_wafexceptions`527μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'763μs856B/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • 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 `jos_menu` AS `m` LEFT JOIN `jos_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`2.23ms53.17KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_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.23ms5.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC843μs2.23KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jos_template_styles` AS `s` LEFT JOIN `jos_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.08ms1.13KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_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)3.31ms7.75KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.25ms8.3KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`2.73ms2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '84'11.03ms48B/libraries/src/Table/Table.php:1325Copy
  • 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 `jos_content` AS `a` INNER JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_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)961μs88.63KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_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`794μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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.45ms5.41KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_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.16ms5.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 jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jos_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 ASC1.86ms6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `jos_content` AS `a` LEFT JOIN `jos_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 `a`.`ordering`1.49ms2.08KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • 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 `jos_categories` AS `s` INNER JOIN `jos_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.05ms5.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 `jos_modules` AS `m` LEFT JOIN `jos_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jos_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.95ms2.5KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `alias` FROM `jos_content` WHERE `id` = :id556μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `jos_content` WHERE `id` = :id478μ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 `jos_scheduler_tasks` AS `a` WHERE `a`.`state` = 1714μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?688μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?4.11ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy