Bugün uzaktaki makina ve ekipmanlarınızla konuştunuz mu? Onları dinleyin! Söyleyecekleri şeyler önemli olabilir.
Kablolu sistemler kapalı alanda çalıştıkları için veri güvenliği açısından daha üstün gözükmelerine rağmen, gerçek tam da böyle değildir. GSM/GPRS ağı üzerinde çalışan telemetrik modüller
Asagıdaki uygulama örnekleri TURA Teknoloji Danışmanlık'ın gönderdiği uygulama örneklerinden seçilmiştir. Detaylar için www.turaconsulting.com
Uzaktan Tank İzleme Sistemleri
Radyo dalgaları uzayda hareket eden ve pek çok iletişim sisteminin temelini oluşturan elektromanyetik dalgalardır. Değişen frekansları ile radyo yayınlarının yanı sıra kablosuz cihazlarda, telefon, televizyon, radar, navigasyon ve telemetrik sistemlerde kullanılmıştır.
OPC, bir grup otomasyon ürünleri üreticisinin Microsoft ile birlikte çalışarak geliştirdiği bir seri standart spesifikasyonudur ve orjinali Microsoft’un OLE COM (component object model) ve DCOM (Distributed component object model) teknolojilerine dayanır. Sesifikasyon, proses kontrolünde ve üretim otomasyon uygulamalarında uyum sorununu ortadan kaldırmak üzere standart nesne, arayüz ve metodları tanımlar.
Joomla! Version | 5.3.0 |
PHP Version | 8.2.18 |
Identity | guest |
Response | 200 |
Template | cassiopeia |
Database |
|
1 x afterRenderComponent com_content (1.01MB) (45.4%) | 32.17ms |
1 x afterInitialise (1.13MB) (13.89%) | 9.84ms |
1 x afterRenderRawModule mod_articles_news (Aylık Bülten) (129.18KB) (8.97%) | 6.36ms |
1 x Before Access::preloadComponents (all components) (112.36KB) (7.46%) | 5.29ms |
1 x afterRender (99.95KB) (4.87%) | 3.45ms |
1 x beforeRenderRawModule mod_custom (Twitter'da takip et) (70.81KB) (2.86%) | 2.03ms |
1 x beforeRenderComponent com_content (81.91KB) (2.79%) | 1.97ms |
1 x afterRoute (93.17KB) (2.18%) | 1.55ms |
1 x afterLoad (99.12KB) (1.57%) | 1.11ms |
1 x After Access::preloadComponents (all components) (113.65KB) (1.55%) | 1.10ms |
1 x afterRenderRawModule mod_menu (Ana Menu) (61.4KB) (1.26%) | 896μs |
1 x After Access::preloadPermissions (com_content) (191.48KB) (1.26%) | 894μs |
1 x afterRenderRawModule mod_menu (Dip Menu) (63.01KB) (0.92%) | 649μs |
1 x afterRenderRawModule mod_search (Search) (12.46KB) (0.74%) | 526μs |
1 x afterRenderRawModule mod_jm_kick_cass (KickstartCassiopeia module) (30.05KB) (0.51%) | 364μs |
1 x beforeRenderModule mod_custom (FootBanner) (808B) (0.36%) | 258μs |
1 x afterRenderRawModule mod_custom (Twitter'da takip et) (4.23KB) (0.34%) | 243μs |
1 x beforeRenderModule mod_jm_kick_cass (KickstartCassiopeia module) (39.56KB) (0.27%) | 189μs |
1 x beforeRenderRawModule mod_jm_kick_cass (KickstartCassiopeia module) (41.23KB) (0.21%) | 149μs |
1 x afterDispatch (2.34KB) (0.18%) | 125μs |
1 x afterRenderModule mod_custom (FootBanner) (3.3KB) (0.14%) | 97μs |
1 x afterRenderModule mod_menu (Dip Menu) (4.77KB) (0.09%) | 63μs |
1 x After Access::getAssetRules (id:183 name:com_content.category.85) (3.38KB) (0.08%) | 60μs |
1 x beforeRenderRawModule mod_menu (Ana Menu) (40B) (0.08%) | 53μs |
1 x afterRenderModule mod_custom (MuhendixLogo) (2.73KB) (0.06%) | 46μs |
1 x beforeRenderRawModule mod_custom (FootBanner) (1.14KB) (0.06%) | 44μs |
1 x beforeRenderRawModule mod_custom (MuhendixLogo) (2.16KB) (0.06%) | 43μs |
1 x afterRenderRawModule mod_custom (FootBanner) (1008B) (0.06%) | 42μs |
1 x beforeRenderRawModule mod_menu (Dip Menu) (39.86KB) (0.06%) | 41μs |
1 x afterRenderRawModule mod_custom (MuhendixLogo) (1KB) (0.06%) | 41μs |
1 x beforeRenderModule mod_menu (Dip Menu) (1.35KB) (0.06%) | 40μs |
1 x beforeRenderRawModule mod_search (Search) (848B) (0.05%) | 38μs |
1 x afterRenderModule mod_custom (Twitter'da takip et) (3.06KB) (0.05%) | 38μs |
1 x afterRenderModule mod_jm_kick_cass (KickstartCassiopeia module) (14.45KB) (0.05%) | 35μs |
1 x beforeRenderModule mod_search (Search) (40.85KB) (0.05%) | 35μs |
1 x afterRenderModule mod_articles_news (Aylık Bülten) (11.69KB) (0.05%) | 34μs |
1 x Before Access::getAssetRules (id:183 name:com_content.category.85) (10.65KB) (0.05%) | 32μs |
1 x beforeRenderModule mod_custom (Twitter'da takip et) (2.32KB) (0.05%) | 32μs |
1 x beforeRenderModule mod_menu (Ana Menu) (152B) (0.04%) | 31μs |
1 x afterRenderModule mod_search (Search) (3.3KB) (0.04%) | 29μs |
1 x afterRenderModule mod_menu (Ana Menu) (3.17KB) (0.04%) | 29μs |
1 x beforeRenderRawModule mod_articles_news (Aylık Bülten) (3.58KB) (0.04%) | 27μs |
1 x beforeRenderModule mod_articles_news (Aylık Bülten) (2.02KB) (0.03%) | 21μs |
1 x Before Access::preloadPermissions (com_content) (1.48KB) (0.02%) | 15μs |
1 x beforeRenderModule mod_custom (MuhendixLogo) (720B) (0.01%) | 4μs |
SELECT @@SESSION.sql_mode;
68μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259CopySELECT `data`
FROM `josdm_session`
WHERE `session_id` = ?
95μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `josdm_session`
WHERE `session_id` = :session_id LIMIT 1
73μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `josdm_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
176μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `josdm_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
269μs1.61KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `josdm_viewlevels`
101μs656B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `josdm_usergroups` AS `a`
LEFT JOIN `josdm_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
136μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `josdm_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
710μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `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 `josdm_menu` AS `m`
LEFT JOIN `josdm_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`
518μs36.55KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT *
FROM `josdm_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
152μs1.59KB/libraries/src/Language/LanguageHelper.php:179CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `josdm_template_styles` AS `s`
LEFT JOIN `josdm_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` = 1
215μs832B/administrator/components/com_templates/src/Model/StyleModel.php:718CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `josdm_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)
614μs7.44KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `josdm_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
416μs25.48KBParams/libraries/src/Access/Access.php:301CopySELECT `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`,(
SELECT COUNT(`i`.`id`)
FROM `josdm_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `josdm_categories` AS `s`
INNER JOIN `josdm_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`
583μs3.92KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `josdm_content` AS `a`
LEFT JOIN `josdm_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `josdm_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `josdm_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `josdm_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `josdm_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`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
ORDER BY c.lft, CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 10, 10
1.08ms86.44KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `josdm_contentitem_tag_map` AS `m`
INNER JOIN `josdm_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10) AND `t`.`access` IN (:preparedArray11,:preparedArray12)
241μs4.84KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT COUNT(*)
FROM `josdm_content` AS `a`
LEFT JOIN `josdm_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `josdm_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `josdm_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `josdm_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `josdm_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`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
527μs5.85KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:197CopySELECT `m`.`tag_id`,`t`.*
FROM `josdm_contentitem_tag_map` AS `m`
INNER JOIN `josdm_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)
199μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT `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 `josdm_categories` AS `s`
INNER JOIN `josdm_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`
374μs3.94KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 josdm_fields AS a
LEFT JOIN `josdm_languages` AS l ON l.lang_code = a.language
LEFT JOIN josdm_users AS uc ON uc.id=a.checked_out
LEFT JOIN josdm_viewlevels AS ag ON ag.id = a.access
LEFT JOIN josdm_users AS ua ON ua.id = a.created_user_id
LEFT JOIN josdm_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `josdm_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,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) 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 ASC
510μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT 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 josdm_fields AS a
LEFT JOIN `josdm_languages` AS l ON l.lang_code = a.language
LEFT JOIN josdm_users AS uc ON uc.id=a.checked_out
LEFT JOIN josdm_viewlevels AS ag ON ag.id = a.access
LEFT JOIN josdm_users AS ua ON ua.id = a.created_user_id
LEFT JOIN josdm_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 ASC
467μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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 `josdm_categories` AS `s`
INNER JOIN `josdm_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`
368μs3.94KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 josdm_fields AS a
LEFT JOIN `josdm_languages` AS l ON l.lang_code = a.language
LEFT JOIN josdm_users AS uc ON uc.id=a.checked_out
LEFT JOIN josdm_viewlevels AS ag ON ag.id = a.access
LEFT JOIN josdm_users AS ua ON ua.id = a.created_user_id
LEFT JOIN josdm_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `josdm_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,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) 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 ASC
477μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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 `josdm_categories` AS `s`
INNER JOIN `josdm_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`
353μs3.94KBParams/libraries/src/Categories/Categories.php:375CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `josdm_modules` AS `m`
LEFT JOIN `josdm_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `josdm_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`
984μs18KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT `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 `josdm_content` AS `a`
LEFT JOIN `josdm_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `josdm_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `josdm_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `josdm_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `josdm_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`.`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 a.ordering DESC LIMIT 5
447μs38.36KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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 `josdm_categories` AS `s`
INNER JOIN `josdm_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`
341μs3.95KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 josdm_fields AS a
LEFT JOIN `josdm_languages` AS l ON l.lang_code = a.language
LEFT JOIN josdm_users AS uc ON uc.id=a.checked_out
LEFT JOIN josdm_viewlevels AS ag ON ag.id = a.access
LEFT JOIN josdm_users AS ua ON ua.id = a.created_user_id
LEFT JOIN josdm_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 ASC
492μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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 `josdm_categories` AS `s`
INNER JOIN `josdm_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`
341μs3.95KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 josdm_fields AS a
LEFT JOIN `josdm_languages` AS l ON l.lang_code = a.language
LEFT JOIN josdm_users AS uc ON uc.id=a.checked_out
LEFT JOIN josdm_viewlevels AS ag ON ag.id = a.access
LEFT JOIN josdm_users AS ua ON ua.id = a.created_user_id
LEFT JOIN josdm_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `josdm_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,:preparedArray4,:preparedArray5)) AND `a`.`access` IN (:preparedArray6,:preparedArray7)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray8,:preparedArray9)) 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 ASC
485μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT 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 `josdm_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
129μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySELECT `session_id`
FROM `josdm_session`
WHERE `session_id` = ?
104μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `josdm_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
208μs3.08KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy