TunerStudio Articles

TunerStudio 3.1 Features by Edition

Details
Category: TunerStudio

Selecting the TunerStudio Edition for you

Make sure your ECU is supported by TunerStudio MS Lite! 
OBD2 is not supported.

 

Starting with TunerStudio 3.0 there are 3 Editions with progressively more features. Below is a high level summary of each Edition, followed by a more detailed Feature Matrix.

 TunerStudio MS Lite! - This is offered to the community for free and allows you to connect to your MegaSquirt and change the calibration settings in the controller. It will let you capture and datalog runtime data but is limited to 15 records per second. The is a single 8 gauge dash with selectable gauges.

 TunerStudio MS (Registered) - This is the 1st level upgrade offering many additional features including VE Analyze Live - Tune For you, multiple tabbed dashboards, fancy dashboards, a dashboard designer, Multi Select 1d Curves and tables, Additional Connection options (Bluetooth Direct, D2XX USB, WiFi), a gamut of other tools to make you life easier getting your project up an running it's best. Most people will want to at least register for this edition!

TunerStudio MS Ultra - This is the top of the line TunerStudio for the serious tuner or enthusiast! It has all the features of the standard registered edition, but adds in an Integrated Log Viewer, Tuning and Dyno Views, Advanced Channel Editor, Trim Table Auto-Tune and More!

 

TunerStudio 3.0 Feature Matrix

Key features supported in each edition
Features TunerStudio Lite! TunerStudio MS TunerStudio Ultra
Basic Data Logging ✔ ✔ ✔
Contextual Help Bubbles (Read More) ✔ ✔ ✔
Editing of all Controller Settings ✔ ✔ ✔
Firmware Loader (Read More) ✔ ✔ ✔
Ignition & Composite Logger display ✔ ✔ ✔
Load and Save Tune Files ✔ ✔ ✔
Main Dash Selectable Gauges ✔ ✔ ✔
Multiple Project Support ✔ ✔ ✔
Offline tuning ✔ ✔ ✔
Standard Serial Communication ✔ ✔ ✔
Table 3D Tuning Dialog ✔ ✔ ✔
Unlimited Length Logging ✔ ✔ ✔
Add Channel Wizard (Simple) (Read More)   ✔ ✔
Advanced Math Functions   ✔ ✔
Automatic Restore Points   ✔ ✔
Communication - Bluetooth Direct* (Read More) ✔ ✔ ✔
Communication - FTDI D2XX USB (Read More) ✔ ✔ ✔
Communication - WiFi (Read More)   ✔ ✔
Compare Tune to saved tune   ✔ ✔
Contextual Settings Notes   ✔ ✔
Curve Graph Baselines   ✔ ✔
Curve Graph Tools (Read More)   ✔ ✔
CurveGraph Multi-Select (Read More)   ✔ ✔
Dashboard Designer   ✔ ✔
Data Log Profiles. (Read More)   ✔ ✔
Data Log Triggering - Auto Logging (Read More)   ✔ ✔
Enhanced 2D Table   ✔ ✔
Enhanced 3D Tuning   ✔ ✔
GPS Support (Read More)   ✔ ✔
Graphical Difference Reports   ✔ ✔
High Speed (>15Hz) Logging   ✔ ✔
Ignition & Composite Logger File load   ✔ ✔
Multiple Tabbed Dashboards   ✔ ✔
Notes Log   ✔ ✔
Performance and Economy Fields (Read More)   ✔ ✔
Recent Project List   ✔ ✔
Settings Search (Read More)   ✔ ✔
Single Dialog Settings Save/Load (Read More)   ✔ ✔
VE Analyze Live - Auto Tune   ✔ ✔
WUE Analyze - Warm up Auto Tune (Read More))   ✔ ✔
Integrated Log Viewer (Read More)     ✔
Log Trailing and Playback (Read More)     ✔
Trim Table AutoTune (Read More)     ✔
Tuning & Dyno View Designer (Read More)     ✔
Tuning & Dyno Views (Read More)     ✔
Channel Editor (Simple & Advanced) (Read More)
    ✔
X-Y Plotting on Curve Graphs (Read More)     ✔
Full Application Log Playback (Read More)     ✔
Trigger Sound Alerts     ✔
User Actions (Read More)     ✔
Action Triggers (Read More)     ✔
Acceleration Performance Dash (Read More)     ✔

* Bluetooth Direct is currently only supported on Windows. Linux and MAC installs need to configure virtual com ports in order to use Bluetooth

Hits: 200359
J! InfoRequestSessionProfileQueries26
5MBMemory Usage46.85msRequest Duration
Joomla! Version4.2.6
PHP Version7.4.33
Identityguest
Response200
Templatetunerstudiocom
Database
Server
mysql
Version
5.6.51
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
[]
$_COOKIE
[]
$_SERVER
array:34 [ "UNIQUE_ID" => "Z347b084T0sDQvHiIkfyIQAAAAU" "HTTP_HOST" => "tunerdash.com" "HTTP_C...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1736325999 "last" => 1736325999...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
PHPDEBUGBAR_STACK_DATA
[]
  • afterLoad (547.03KB) (1.88ms)
  • afterInitialise (1.45MB) (12.44ms)
  • afterRoute (353.85KB) (2.93ms)
  • beforeRenderComponent com_content (153.98KB) (1.56ms)
  • Before Access::preloadComponents (all components) (52.55KB) (425μs)
  • After Access::preloadComponents (all components) (110.08KB) (748μs)
  • Before Access::preloadPermissions (com_content) (2.76KB) (19μs)
  • After Access::preloadPermissions (com_content) (44.02KB) (484μs)
  • Before Access::getAssetRules (id:146 name:com_content.article.119) (6.8KB) (17μs)
  • After Access::getAssetRules (id:146 name:com_content.article.119) (8.47KB) (65μs)
  • afterRenderComponent com_content (644.88KB) (10.96ms)
  • afterDispatch (2.25KB) (74μs)
  • Before Access::getAssetRules (id:180 name:com_pagebuilderck) (248.81KB) (2ms)
  • After Access::getAssetRules (id:180 name:com_pagebuilderck) (6.97KB) (26μs)
  • beforeRenderRawModule mod_custom (My Footer) (18.53KB) (216μs)
  • afterRenderRawModule mod_custom (My Footer) (8.19KB) (312μs)
  • beforeRenderModule mod_custom (My Footer) (720B) (5μs)
  • afterRenderModule mod_custom (My Footer) (4.4KB) (77μs)
  • beforeRenderRawModule mod_menu (Left Menu) (1.83KB) (36μs)
  • afterRenderRawModule mod_menu (Left Menu) (210.53KB) (1.58ms)
  • beforeRenderModule mod_menu (Left Menu) (704B) (7μs)
  • afterRenderModule mod_menu (Left Menu) (3.66KB) (60μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (1.5KB) (45μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (13.09KB) (375μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.18KB) (73μs)
  • beforeRenderRawModule mod_menu (Top Menu) (1.53KB) (38μs)
  • afterRenderRawModule mod_menu (Top Menu) (53.28KB) (1.34ms)
  • beforeRenderModule mod_menu (Top Menu) (704B) (6μs)
  • afterRenderModule mod_menu (Top Menu) (5.91KB) (60μs)
  • afterRender (273.91KB) (5.33ms)
  • 1 x afterInitialise (1.45MB) (26.56%)
    12.44ms
    1 x afterRenderComponent com_content (644.88KB) (23.4%)
    10.96ms
    1 x afterRender (273.91KB) (11.39%)
    5.33ms
    1 x afterRoute (353.85KB) (6.25%)
    2.93ms
    1 x Before Access::getAssetRules (id:180 name:com_pagebuilderck) (248.81KB) (4.26%)
    2.00ms
    1 x afterLoad (547.03KB) (4.02%)
    1.88ms
    1 x afterRenderRawModule mod_menu (Left Menu) (210.53KB) (3.38%)
    1.58ms
    1 x beforeRenderComponent com_content (153.98KB) (3.32%)
    1.56ms
    1 x afterRenderRawModule mod_menu (Top Menu) (53.28KB) (2.85%)
    1.34ms
    1 x After Access::preloadComponents (all components) (110.08KB) (1.6%)
    748μs
    1 x After Access::preloadPermissions (com_content) (44.02KB) (1.03%)
    484μs
    1 x Before Access::preloadComponents (all components) (52.55KB) (0.91%)
    425μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (13.09KB) (0.8%)
    375μs
    1 x afterRenderRawModule mod_custom (My Footer) (8.19KB) (0.67%)
    312μs
    1 x beforeRenderRawModule mod_custom (My Footer) (18.53KB) (0.46%)
    216μs
    1 x afterRenderModule mod_custom (My Footer) (4.4KB) (0.16%)
    77μs
    1 x afterDispatch (2.25KB) (0.16%)
    74μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.18KB) (0.16%)
    73μs
    1 x After Access::getAssetRules (id:146 name:com_content.article.119) (8.47KB) (0.14%)
    65μs
    1 x afterRenderModule mod_menu (Left Menu) (3.66KB) (0.13%)
    60μs
    1 x afterRenderModule mod_menu (Top Menu) (5.91KB) (0.13%)
    60μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (1.5KB) (0.1%)
    45μs
    1 x beforeRenderRawModule mod_menu (Top Menu) (1.53KB) (0.08%)
    38μs
    1 x beforeRenderRawModule mod_menu (Left Menu) (1.83KB) (0.08%)
    36μs
    1 x After Access::getAssetRules (id:180 name:com_pagebuilderck) (6.97KB) (0.06%)
    26μs
    1 x Before Access::preloadPermissions (com_content) (2.76KB) (0.04%)
    19μs
    1 x Before Access::getAssetRules (id:146 name:com_content.article.119) (6.8KB) (0.04%)
    17μs
    1 x beforeRenderModule mod_menu (Left Menu) (704B) (0.01%)
    7μs
    1 x beforeRenderModule mod_menu (Top Menu) (704B) (0.01%)
    6μs
    1 x beforeRenderModule mod_custom (My Footer) (720B) (0.01%)
    5μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0.01%)
    4μs
26 statements were executed, 3 of which were duplicates, 23 unique10.81ms271.2KB
UniquesDuplicates 1
  • SELECT @@SESSION.sql_mode;69μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
  • SELECT `data` FROM `t1ucm_session` WHERE `session_id` = ?120μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `t1ucm_session` WHERE `session_id` = :session_id LIMIT 181μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `t1ucm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)2.01ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `t1ucm_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1282μs4.73KB/libraries/src/Component/ComponentHelper.php:393Copy
  • SELECT `id`,`rules` FROM `t1ucm_viewlevels`84μs1.11KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `t1ucm_usergroups` AS `a` LEFT JOIN `t1ucm_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest127μs1.67KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `t1ucm_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`619μs16.3KBParams/libraries/src/Plugin/PluginHelper.php:283Copy
  • 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 `t1ucm_menu` AS `m` LEFT JOIN `t1ucm_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`447μs50.42KBParams/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 `t1ucm_categories` AS `s` INNER JOIN `t1ucm_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`294μs6.62KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT * FROM `t1ucm_languages` WHERE `published` = 1 ORDER BY `ordering` ASC125μs2.44KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `t1ucm_template_styles` AS `s` LEFT JOIN `t1ucm_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` = 1162μs1.33KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `t1ucm_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)451μs10.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `t1ucm_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0248μs11.05KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `t1ucm_content`491μs10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • UPDATE t1ucm_content SET `hits` = (`hits` + 1) WHERE `id` = '119'2.08ms48B/libraries/src/Table/Table.php:1319Copy
  • 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 `t1ucm_content` AS `a` INNER JOIN `t1ucm_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `t1ucm_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `t1ucm_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `t1ucm_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `t1ucm_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)306μs99.88KBParams/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 `t1ucm_categories` AS `s` INNER JOIN `t1ucm_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`287μs6.67KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `t1ucm_contentitem_tag_map` AS `m` INNER JOIN `t1ucm_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)240μs5.22KBParams/libraries/src/Helper/TagsHelper.php:364Copy
  • 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 `t1ucm_categories` AS `s` INNER JOIN `t1ucm_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`303μs6.67KBParams/libraries/src/Categories/Categories.php:360Copy
  • 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 t1ucm_fields AS a LEFT JOIN `t1ucm_languages` AS l ON l.lang_code = a.language LEFT JOIN t1ucm_users AS uc ON uc.id=a.checked_out LEFT JOIN t1ucm_viewlevels AS ag ON ag.id = a.access LEFT JOIN t1ucm_users AS ua ON ua.id = a.created_user_id LEFT JOIN t1ucm_fields_groups AS g ON g.id = a.group_id LEFT JOIN `t1ucm_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 ASC650μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
  • 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 `t1ucm_content` AS `a` LEFT JOIN `t1ucm_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 DESC340μs5.53KBParams/plugins/content/pagenavigation/pagenavigation.php:186Copy
  • 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 `t1ucm_categories` AS `s` INNER JOIN `t1ucm_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`276μs6.67KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `t1ucm_modules` AS `m` LEFT JOIN `t1ucm_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `t1ucm_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`354μs3.53KBParams/libraries/src/Cache/Controller/CallbackController.php:52Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `t1ucm_scheduler_tasks` AS `a` LEFT JOIN `t1ucm_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` asc205μs4.45KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `t1ucm_scheduler_tasks` AS `a` LEFT JOIN `t1ucm_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` asc151μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy