MIT'den Makina mühendisleri arabalar için akıllı co-pilot geliştirdiler. Sürücülerin emniyeti için yarı otonom sistem direksiyonun kontrolunu alıyor. 

MIT'nin Makina Mühendisliği Departmanında doktora öğrencisi Sterling Anderson ve yine MIT'nin Robotik Mobilite Grubundan  Karl Iagnemma ile birlikte geliştirdiği yarı-otonom güvenlik sisteminin test sonucu: Variller ve külahlar yerleştirilmiş boş bir alanda yapılan denemede sürücü uzaktan aracı yönlendirirken, engellerden birine çarpmak üzere aracı yönlendirdiğinde sürücünün direksiyonu düz tutmasına rağmen araç engel etrafında dönmeye başlıyor. Tehlike geçtikten sonra aracın kotrolu tekrar sürücüye geçiyor. 

Sistem, aracın etrafındaki tehlikeleri belirlemek üzere bir kamera ve menzil algılayıcısı kullanıyor. Verileri

analiz edip, engeller ve diğer araçlar gibi çarpma noktalarını ve güvenli bölgeleri belirlemek üzere bir algoritma geliştirilmiş. Araç güvenli bölgeden çıkmadığı sürece kontrolu sürücüde, ancak güvenli bölgeden çıkma durumunda sistem devreye giriyor. 

 

Michigan'da geçen Eylül'den beri sistemi test eden Anderson, "akıllı co-pilot" olarak tarif etmiş bu sürücü performansını takip edip, arka planda aracı engellere çarpmaktan alı koyacak ayarlamalar yapan sistemi. Anderson'ın tarifine göre " bu işin geliştirme tarafı kontrolu sürücü ile paylaşan ve yalnızca bir yere çarpmamanızı sağlayan" bir sistem olmasında. Araştırma grubu güvenlik sisteminin detaylarını İspanya'da Akıllı Arabalar Sempozyumu'nda sunmuş. 

Son yıllarda robotik araştırmaları hem robot hem de insanlar tarafından kontrol edilen sistemler üretmeye yoğunlaştı. Arabalardan medikal ekipmana, endüstriyel makinalara kadar geliştirilmeye çalışan bu sistem, ön programlaması yapılmış bir yol üzerinde çalışıyor. Örneğin, son yıllarda hayatımıza giren kendi kendini parkedebilen araçlar. Paralel park için sürücü bir düğme ile teknolojiyi harekete geçiriyor, sonra da ellerini direksiyondan çekiyor. Araç, etraftaki araçlara göre mesafesine bakarak önceden programlanmış bir rotada kendi kendini parkediyor. 

Park için bu planlama mantığı işlerken, arabayıyı sürmek dediğinizde yolu planlamak mümkün değil. Aracın gittiği bir şerit var ama trafiğin durumuna göre karayolu içinde diğer araçlara çarpmadan şerit değiştiriliyor. Anderson ve Iagnema, trafikte giderken sürücünün perspektifini robotik sistemlerine entegre etmişler. Ekip, spesifik bir yol yerine, güvenli bölge ve "homotopiler" üzerine  bir yaklaşım geliştirmiş. Karayolu üzerine tek tek şeritleri yerleştirmek yerine aracın etrafını, kenarları şerit çizgisi ya da engel olan üçgenlere ayırmışlar.

Geliştirilen algoritma, sürücüyü aracın çevresindeki bu üçgenler arasında geçiş yapmasına izin veriyor, ancak bu üçgenlerin tehlike içeren kenarına yaklaşırsa sistemi devreye alıyor ve aracı tekrar güvenli bölgeye getiriyor.  

Şu ana kadar 1200'den fazla deneme yapılmış ve bu denemelerde yalnızca bir kaç çarpışma gerçekleşmiş. Bu çarpışmalarda çoğunlukla sistemin kamerasında ufak arızalar meydana geldiğinde bir engeli göremediği için oluşmuş. Bu bir kaç durum dışında sistem, sürücülerin kaza yapmasına engel olmuş. Anderson'ın sisteminde kullanılan sensör ve bilgisayar ekipmanı, daha önce geliştirilen tam otonoma sahip araçlardan daha hafif ve daha az maliyetli.

Bu arada Anderson testlere katılan kişilerde enteresan eğitimler de gölemlemiş. Sisteme güvenenlerin sürüş performansı, güvenmeyenlerden çok daha iyiymiş. "Bir de böyle bir sistemin aracında devrede olduğunu bilmeyenleri düşünün, muhtemelen çok yetenekli bir sürücü olduklarını düşüneceklerdir" diyor. Ancak şunu da kabul ediyor ki yeni araç sürmeyi öğrenenlerin aracında olması uygun bir sistem değil. Zira olduklarından çok daha iyi bir sürücü olduklarını düşünebilirler. Şimdi Anderson ve Lagnema sistemi farklı tecrübe seviyesinde sürücülere göre ayarlamaya çalışıyorlar. Bir diğer araştırma alanı da sistemi daha da basitleştirip, ucuzlatmak ve herkesin erişebileceği hale getirmek. Mesela kamera yerine bir cep telefonu kullanmak. 

Araştırma US Askeri Araştırma Ofisi ve Savunma İleri Araştırma Projeleri Ajansı tarafından desteklenmiş. 

Adaptasyon: http://web.mit.edu/newsoffice/2012/mechanical-engineers-develop-intelligent-car-co-pilot-0713.html

Settings3.498MBMemory Usage122msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
PHP Version8.2.18
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
5.7.23-23
Collation
utf8_unicode_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:74 [ "LSPHP_ENABLE_USER_INI" => "on" "PATH" => "/usr/local/bin:/usr/bin:/bin" "TEMP" => ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1748869680 "last" => 1748869680...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (99KB) (1.17ms)
  • afterInitialise (1.13MB) (11.31ms)
  • afterRoute (174.48KB) (4.27ms)
  • beforeRenderComponent com_content (111.12KB) (1.88ms)
  • Before Access::preloadComponents (all components) (33.25KB) (6.63ms)
  • After Access::preloadComponents (all components) (112.91KB) (1.12ms)
  • Before Access::preloadPermissions (com_content) (1.48KB) (18μs)
  • After Access::preloadPermissions (com_content) (190.74KB) (930μs)
  • Before Access::getAssetRules (id:319 name:com_content.article.174) (10.65KB) (37μs)
  • After Access::getAssetRules (id:319 name:com_content.article.174) (3.38KB) (72μs)
  • afterRenderComponent com_content (383.08KB) (69.13ms)
  • afterDispatch (2.31KB) (139μs)
  • beforeRenderRawModule mod_custom (Twitter'da takip et) (374.87KB) (7.04ms)
  • afterRenderRawModule mod_custom (Twitter'da takip et) (4.23KB) (284μs)
  • beforeRenderRawModule mod_articles_news (Aylık Bülten) (3.58KB) (30μs)
  • afterRenderRawModule mod_articles_news (Aylık Bülten) (192.68KB) (9.64ms)
  • beforeRenderRawModule mod_menu (Ana Menu) (40B) (59μs)
  • afterRenderRawModule mod_menu (Ana Menu) (61.4KB) (939μs)
  • beforeRenderRawModule mod_search (Search) (848B) (42μs)
  • afterRenderRawModule mod_search (Search) (18.97KB) (829μs)
  • beforeRenderRawModule mod_jm_kick_cass (KickstartCassiopeia module) (41.23KB) (172μs)
  • afterRenderRawModule mod_jm_kick_cass (KickstartCassiopeia module) (30.17KB) (651μs)
  • beforeRenderRawModule mod_menu (Dip Menu) (39.86KB) (47μs)
  • afterRenderRawModule mod_menu (Dip Menu) (48.37KB) (795μs)
  • beforeRenderRawModule mod_custom (FootBanner) (1.14KB) (34μs)
  • afterRenderRawModule mod_custom (FootBanner) (1008B) (45μs)
  • beforeRenderModule mod_custom (FootBanner) (808B) (286μs)
  • afterRenderModule mod_custom (FootBanner) (3.3KB) (109μs)
  • beforeRenderModule mod_menu (Dip Menu) (1.35KB) (40μs)
  • afterRenderModule mod_menu (Dip Menu) (4.77KB) (159μs)
  • beforeRenderModule mod_custom (Twitter'da takip et) (2.32KB) (85μs)
  • afterRenderModule mod_custom (Twitter'da takip et) (3.06KB) (49μs)
  • beforeRenderModule mod_articles_news (Aylık Bülten) (2.02KB) (21μs)
  • afterRenderModule mod_articles_news (Aylık Bülten) (11.69KB) (38μs)
  • beforeRenderModule mod_jm_kick_cass (KickstartCassiopeia module) (39.56KB) (289μs)
  • afterRenderModule mod_jm_kick_cass (KickstartCassiopeia module) (14.45KB) (68μs)
  • beforeRenderModule mod_search (Search) (40.85KB) (49μs)
  • afterRenderModule mod_search (Search) (3.3KB) (39μs)
  • beforeRenderModule mod_menu (Ana Menu) (152B) (35μs)
  • afterRenderModule mod_menu (Ana Menu) (3.17KB) (31μs)
  • beforeRenderRawModule mod_custom (MuhendixLogo) (2.16KB) (30μs)
  • afterRenderRawModule mod_custom (MuhendixLogo) (1KB) (57μs)
  • beforeRenderModule mod_custom (MuhendixLogo) (720B) (4μs)
  • afterRenderModule mod_custom (MuhendixLogo) (2.73KB) (34μs)
  • afterRender (112.7KB) (2.73ms)
  • 1 x afterRenderComponent com_content (383.08KB) (56.56%)
    69.13ms
    1 x afterInitialise (1.13MB) (9.25%)
    11.31ms
    1 x afterRenderRawModule mod_articles_news (Aylık Bülten) (192.68KB) (7.89%)
    9.64ms
    1 x beforeRenderRawModule mod_custom (Twitter'da takip et) (374.87KB) (5.76%)
    7.04ms
    1 x Before Access::preloadComponents (all components) (33.25KB) (5.43%)
    6.63ms
    1 x afterRoute (174.48KB) (3.49%)
    4.27ms
    1 x afterRender (112.7KB) (2.23%)
    2.73ms
    1 x beforeRenderComponent com_content (111.12KB) (1.54%)
    1.88ms
    1 x afterLoad (99KB) (0.96%)
    1.17ms
    1 x After Access::preloadComponents (all components) (112.91KB) (0.92%)
    1.12ms
    1 x afterRenderRawModule mod_menu (Ana Menu) (61.4KB) (0.77%)
    939μs
    1 x After Access::preloadPermissions (com_content) (190.74KB) (0.76%)
    930μs
    1 x afterRenderRawModule mod_search (Search) (18.97KB) (0.68%)
    829μs
    1 x afterRenderRawModule mod_menu (Dip Menu) (48.37KB) (0.65%)
    795μs
    1 x afterRenderRawModule mod_jm_kick_cass (KickstartCassiopeia module) (30.17KB) (0.53%)
    651μs
    1 x beforeRenderModule mod_jm_kick_cass (KickstartCassiopeia module) (39.56KB) (0.24%)
    289μs
    1 x beforeRenderModule mod_custom (FootBanner) (808B) (0.23%)
    286μs
    1 x afterRenderRawModule mod_custom (Twitter'da takip et) (4.23KB) (0.23%)
    284μs
    1 x beforeRenderRawModule mod_jm_kick_cass (KickstartCassiopeia module) (41.23KB) (0.14%)
    172μs
    1 x afterRenderModule mod_menu (Dip Menu) (4.77KB) (0.13%)
    159μs
    1 x afterDispatch (2.31KB) (0.11%)
    139μs
    1 x afterRenderModule mod_custom (FootBanner) (3.3KB) (0.09%)
    109μs
    1 x beforeRenderModule mod_custom (Twitter'da takip et) (2.32KB) (0.07%)
    85μs
    1 x After Access::getAssetRules (id:319 name:com_content.article.174) (3.38KB) (0.06%)
    72μs
    1 x afterRenderModule mod_jm_kick_cass (KickstartCassiopeia module) (14.45KB) (0.06%)
    68μs
    1 x beforeRenderRawModule mod_menu (Ana Menu) (40B) (0.05%)
    59μs
    1 x afterRenderRawModule mod_custom (MuhendixLogo) (1KB) (0.05%)
    57μs
    1 x afterRenderModule mod_custom (Twitter'da takip et) (3.06KB) (0.04%)
    49μs
    1 x beforeRenderModule mod_search (Search) (40.85KB) (0.04%)
    49μs
    1 x beforeRenderRawModule mod_menu (Dip Menu) (39.86KB) (0.04%)
    47μs
    1 x afterRenderRawModule mod_custom (FootBanner) (1008B) (0.04%)
    45μs
    1 x beforeRenderRawModule mod_search (Search) (848B) (0.03%)
    42μs
    1 x beforeRenderModule mod_menu (Dip Menu) (1.35KB) (0.03%)
    40μs
    1 x afterRenderModule mod_search (Search) (3.3KB) (0.03%)
    39μs
    1 x afterRenderModule mod_articles_news (Aylık Bülten) (11.69KB) (0.03%)
    38μs
    1 x Before Access::getAssetRules (id:319 name:com_content.article.174) (10.65KB) (0.03%)
    37μs
    1 x beforeRenderModule mod_menu (Ana Menu) (152B) (0.03%)
    35μs
    1 x beforeRenderRawModule mod_custom (FootBanner) (1.14KB) (0.03%)
    34μs
    1 x afterRenderModule mod_custom (MuhendixLogo) (2.73KB) (0.03%)
    34μs
    1 x afterRenderModule mod_menu (Ana Menu) (3.17KB) (0.03%)
    31μs
    1 x beforeRenderRawModule mod_articles_news (Aylık Bülten) (3.58KB) (0.02%)
    30μs
    1 x beforeRenderRawModule mod_custom (MuhendixLogo) (2.16KB) (0.02%)
    30μs
    1 x beforeRenderModule mod_articles_news (Aylık Bülten) (2.02KB) (0.02%)
    21μs
    1 x Before Access::preloadPermissions (com_content) (1.48KB) (0.01%)
    18μs
    1 x beforeRenderModule mod_custom (MuhendixLogo) (720B) (0%)
    4μs
34 statements were executed, 5 of which were duplicates, 29 unique12.96ms235.4KB
  • SELECT @@SESSION.sql_mode;76μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `josdm_session` WHERE `session_id` = ?303μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `josdm_session` WHERE `session_id` = :session_id LIMIT 174μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `josdm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)213μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `josdm_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1235μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `josdm_viewlevels`144μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `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` = :guest443μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `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`716μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `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`565μs36.55KBParams/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 `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`425μs3.89KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `josdm_content` WHERE `id` = :id107μs1.31KBParams/components/com_content/src/Service/Router.php:289Copy
  • SELECT * FROM `josdm_languages` WHERE `published` = 1 ORDER BY `ordering` ASC141μs1.59KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `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` = 1210μs832B/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SELECT `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)560μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `josdm_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0444μs25.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `josdm_content`352μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `josdm_content` SET `hits` = (`hits` + 1) WHERE `id` = '174'163μs1.3KB/libraries/src/Table/Table.php:1348Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `josdm_content` AS `a` INNER JOIN `josdm_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `josdm_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `josdm_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `josdm_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `josdm_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)363μs22.13KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `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`508μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `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)230μs3.97KBParams/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 `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`337μs3.94KBParams/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 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 ASC772μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `josdm_content` AS `a` LEFT JOIN `josdm_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC1.21ms20.22KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:205Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `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`506μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `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`1.01ms18KBParams/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 `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`.`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 a.ordering DESC LIMIT 5498μs39.02KBParams/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 `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`363μs3.95KBParams/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 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 ASC538μs4.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 `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`330μs3.95KBParams/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 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 ASC437μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `alias`,`catid` FROM josdm_content WHERE `id` = :key96μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • 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 `josdm_scheduler_tasks` AS `a` WHERE `a`.`state` = 1144μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `josdm_session` WHERE `session_id` = ?107μs3.5KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `josdm_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?345μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy