What are chords and chord inversions?

General definition of a chord

A chord is the layering of several tones played simultaneously - usually built on superposed thirds. Chords are defined by their root note and their quality (major, minor, 7, etc) - and eventually by their inversion.

Triads

A triad is a chord made of three notes. It consists of a root and the third and fifth above it. The most common triads are:

Major - has a major third and a perfect fifth
Minor - has a minor third and a perfect fifth
Diminished - has a minor third and a diminished fifth
Augmented - has a major third and an augmented fifth

On the staff below, the C major, C minor, C diminished and C augmented are transcribed:

triads

Seventh chords

These chords are triads with a supplementary diatonic third superposed. The most common seventh chords are:

Dominant 7 (or just "7") - is a major triad with a minor 7 added.
Minor 7 - is a minor triad with a minor 7 added.
Diminished 7 - is a diminished triad with a diminished 7 added.
Half diminished - is a diminished triad with a minor 7 added.

There are more "triad + 7" combinations than mentioned here. You can find them in the chord definition table of EarMaster's Activity Setup

Chord inversions

The regular position of a chord with its root note at the bottom is called the root position.
When the third of the chord (e.g. E in a C major triad) is at the bottom, it is said to be in first inversion. When the fifth of the chord (G in a C major triad) is at the bottom, it is said to be in second inversion.

On the staff below, the C major chord is shown in root position, 1st inversion and 2nd inversion:

inversions

Mastodon
Settings12.463MBMemory Usage107msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.2
PHP Version8.3.12
Identityguest
Response200
Templateastroid_template_two
Database
Server
mysql
Version
11.1.5-MariaDB-ubu2204
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:1 [ "srsltid" => "AfmBOoqcPDzfvH3lMJ905KUqo4Q-iX-prYMnv_Ccouz7Rw1fXxomgikz" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:50 [ "REDIRECT_HTTP_AUTHORIZATION" => "" "REDIRECT_STATUS" => "200" "HTTP_AUTHORIZATION"...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1755075576 "last" => 1755075576...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (83.76KB) (1.69ms)
  • afterInitialise (3.92MB) (25.17ms)
  • afterRoute (2.21MB) (7.14ms)
  • beforeRenderComponent com_content (38.22KB) (227μs)
  • Before Access::preloadComponents (all components) (54.17KB) (302μs)
  • After Access::preloadComponents (all components) (136.69KB) (540μs)
  • Before Access::preloadPermissions (com_content) (424B) (11μs)
  • After Access::preloadPermissions (com_content) (120.2KB) (467μs)
  • Before Access::getAssetRules (id:256 name:com_content.article.76) (6.65KB) (13μs)
  • After Access::getAssetRules (id:256 name:com_content.article.76) (8.3KB) (44μs)
  • afterRenderComponent com_content (611.7KB) (11.81ms)
  • Before Access::getAssetRules (id:1 name:root.1) (5.17KB) (49μs)
  • After Access::getAssetRules (id:1 name:root.1) (6.48KB) (11μs)
  • Before Access::getAssetRules (id:8 name:com_content) (56.91KB) (734μs)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (5μs)
  • afterDispatch (11.91KB) (205μs)
  • beforeRenderRawModule mod_falang (FaLang Language Switcher) (2.08MB) (32.82ms)
  • afterRenderRawModule mod_falang (FaLang Language Switcher) (598.67KB) (11.12ms)
  • beforeRenderModule mod_falang (FaLang Language Switcher) (736B) (3μs)
  • afterRenderModule mod_falang (FaLang Language Switcher) (5.8KB) (68μs)
  • beforeRenderRawModule mod_custom (Links to Privacy and Terms) (3.5KB) (10μs)
  • afterRenderRawModule mod_custom (Links to Privacy and Terms) (3.95KB) (157μs)
  • beforeRenderModule mod_custom (Links to Privacy and Terms) (736B) (2μs)
  • afterRenderModule mod_custom (Links to Privacy and Terms) (2.78KB) (45μs)
  • beforeRenderRawModule mod_custom (Footer) (232B) (27μs)
  • afterRenderRawModule mod_custom (Footer) (928B) (16μs)
  • beforeRenderModule mod_custom (Footer) (704B) (1μs)
  • afterRenderModule mod_custom (Footer) (15.47KB) (1.03ms)
  • afterRender (1.78MB) (9.7ms)
  • 1 x beforeRenderRawModule mod_falang (FaLang Language Switcher) (2.08MB) (30.56%)
    32.82ms
    1 x afterInitialise (3.92MB) (23.44%)
    25.17ms
    1 x afterRenderComponent com_content (611.7KB) (11%)
    11.81ms
    1 x afterRenderRawModule mod_falang (FaLang Language Switcher) (598.67KB) (10.36%)
    11.12ms
    1 x afterRender (1.78MB) (9.03%)
    9.70ms
    1 x afterRoute (2.21MB) (6.65%)
    7.14ms
    1 x afterLoad (83.76KB) (1.58%)
    1.69ms
    1 x afterRenderModule mod_custom (Footer) (15.47KB) (0.96%)
    1.03ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (56.91KB) (0.68%)
    734μs
    1 x After Access::preloadComponents (all components) (136.69KB) (0.5%)
    540μs
    1 x After Access::preloadPermissions (com_content) (120.2KB) (0.43%)
    467μs
    1 x Before Access::preloadComponents (all components) (54.17KB) (0.28%)
    302μs
    1 x beforeRenderComponent com_content (38.22KB) (0.21%)
    227μs
    1 x afterDispatch (11.91KB) (0.19%)
    205μs
    1 x afterRenderRawModule mod_custom (Links to Privacy and Terms) (3.95KB) (0.15%)
    157μs
    1 x afterRenderModule mod_falang (FaLang Language Switcher) (5.8KB) (0.06%)
    68μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (5.17KB) (0.05%)
    49μs
    1 x afterRenderModule mod_custom (Links to Privacy and Terms) (2.78KB) (0.04%)
    45μs
    1 x After Access::getAssetRules (id:256 name:com_content.article.76) (8.3KB) (0.04%)
    44μs
    1 x beforeRenderRawModule mod_custom (Footer) (232B) (0.03%)
    27μs
    1 x afterRenderRawModule mod_custom (Footer) (928B) (0.01%)
    16μs
    1 x Before Access::getAssetRules (id:256 name:com_content.article.76) (6.65KB) (0.01%)
    13μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.01%)
    11μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.01%)
    11μs
    1 x beforeRenderRawModule mod_custom (Links to Privacy and Terms) (3.5KB) (0.01%)
    10μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0%)
    5μs
    1 x beforeRenderModule mod_falang (FaLang Language Switcher) (736B) (0%)
    3μs
    1 x beforeRenderModule mod_custom (Links to Privacy and Terms) (736B) (0%)
    2μs
    1 x beforeRenderModule mod_custom (Footer) (704B) (0%)
    1μs
122 statements were executed, 66 of which were duplicates, 56 unique17.1ms2.98MB
  • select distinct reference_table from v12ai_falang_content126μs1016B/plugins/system/falangdriver/falang_database.php:224Copy
  • SELECT `params` FROM `v12ai_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'155μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_admintools_ipautoban`83μs656B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `ip` FROM `v12ai_admintools_ipblock`71μs776B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `source`,`dest`,`keepurlparams` FROM `v12ai_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC70μs960B/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_menu` AS `m` LEFT JOIN `v12ai_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`1.88ms1.23MBParams/plugins/system/falangdriver/falang_database.php:133Copy
  • 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 `v12ai_menu` AS `m` LEFT JOIN `v12ai_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`1.77ms1.23MBParams/plugins/system/falangdriver/falang_database.php:133Copy
  • SELECT `option`,`view`,`task`,`query`,`query_type`,`query_content`,`verb`,`application` FROM `v12ai_admintools_wafblacklists` WHERE `enabled` = 1104μs976B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `v12ai_template_styles` AS `s` LEFT JOIN `v12ai_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` = 1160μs1.47KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `v12ai_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,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49)293μs7.94KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `v12ai_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0235μs5.48KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_content`330μs1.77KB/plugins/system/falangdriver/falang_database.php:330Copy
  • UPDATE `v12ai_content` SET `hits` = (`hits` + 1) WHERE `id` = '76'159μs48B/plugins/system/falangdriver/falang_database.php:133Copy
  • 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 `v12ai_content` AS `a` INNER JOIN `v12ai_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `v12ai_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `v12ai_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `v12ai_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `v12ai_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) 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 (:preparedArray3,:preparedArray4)212μs6.19KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT joomlatablename,tablepkID FROM `v12ai_falang_tableinfo`35μs1KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM v12ai_languages ORDER BY ordering41μs1.64KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_languages`192μs2.77KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (76) AND `reference_table`= 'content'126μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`140μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`110μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v12ai_contentitem_tag_map` AS `m` INNER JOIN `v12ai_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)179μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`111μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 v12ai_fields AS a LEFT JOIN `v12ai_languages` AS l ON l.lang_code = a.language LEFT JOIN v12ai_users AS uc ON uc.id=a.checked_out LEFT JOIN v12ai_viewlevels AS ag ON ag.id = a.access LEFT JOIN v12ai_users AS ua ON ua.id = a.created_user_id LEFT JOIN v12ai_fields_groups AS g ON g.id = a.group_id LEFT JOIN `v12ai_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC275μs4.75KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `params` FROM `v12ai_categories` WHERE `id`=1641μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `id` FROM `v12ai_rstbox` WHERE `published` = 1 AND `testmode` = 041μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `language`,`id` FROM `v12ai_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 094μs592B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (101) AND `reference_table`= 'menu'57μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT `alias`,`catid` FROM v12ai_content WHERE `id` = :key31μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `alias`,`catid` FROM v12ai_content WHERE `id` = :key25μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `v12ai_content` AS `c` INNER JOIN `v12ai_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `v12ai_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `v12ai_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `v12ai_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-08-13 08:59:36') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-08-13 08:59:36') AND c2.state = 166μs1.47KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `v12ai_modules` AS `m` LEFT JOIN `v12ai_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `v12ai_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) AND `m`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY `m`.`position`,`m`.`ordering`286μs130.34KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (113,116,121,125,127,132,133,134,135,136,138,139,140,150,151,157,158,159,164,165,166,168,177,207,112,17,123,110,124) AND `reference_table`= 'modules'156μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT * FROM `v12ai_categories` WHERE `extension` = 'com_content' AND `published` = '1' AND `access` IN (1,5) AND `language` IN ('en-GB', '*') AND `parent_id` IN (16) ORDER BY `lft` ASC81μs5.48KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT a.*,`b`.`alias` AS `category_alias`,`b`.`title` AS `category_title` FROM `v12ai_content` AS `a` LEFT JOIN `v12ai_categories` AS `b` ON (`a`.`catid` = `b`.`id`) WHERE ( (`b`.`extension` = 'com_content' AND `a`.`state` = '1' AND `a`.`catid` IN (16)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.language IN ('en-GB','*') AND `a`.`access` IN (1,5) ORDER BY `a`.`publish_up` DESC,`a`.`created` DESC LIMIT 100132μs100.14KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (178,79,78,77,76,75,22,362,20,19,17) AND `reference_table`= 'content'84μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SHOW FULL COLUMNS FROM `v12ai_users`168μs1.58KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_users` WHERE `id` = :userid53μs3.16KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `g`.`id`,`g`.`title` FROM `v12ai_usergroups` AS `g` INNER JOIN `v12ai_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid48μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`120μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`102μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v12ai_contentitem_tag_map` AS `m` INNER JOIN `v12ai_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)85μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`104μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`96μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v12ai_contentitem_tag_map` AS `m` INNER JOIN `v12ai_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)96μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`103μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`225μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v12ai_contentitem_tag_map` AS `m` INNER JOIN `v12ai_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)161μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`203μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`203μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v12ai_contentitem_tag_map` AS `m` INNER JOIN `v12ai_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)157μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v12ai_contentitem_tag_map` AS `m` INNER JOIN `v12ai_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)160μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`196μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`201μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v12ai_contentitem_tag_map` AS `m` INNER JOIN `v12ai_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)77μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`200μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`197μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v12ai_contentitem_tag_map` AS `m` INNER JOIN `v12ai_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)156μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`198μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`209μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v12ai_contentitem_tag_map` AS `m` INNER JOIN `v12ai_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)158μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`192μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`194μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v12ai_contentitem_tag_map` AS `m` INNER JOIN `v12ai_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)156μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`192μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`202μs14.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v12ai_contentitem_tag_map` AS `m` INNER JOIN `v12ai_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)159μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`122μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`164μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v12ai_contentitem_tag_map` AS `m` INNER JOIN `v12ai_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)89μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `c2`.`language`,`c2`.`id` FROM `v12ai_menu` AS `c` INNER JOIN `v12ai_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `v12ai_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `v12ai_menu` AS `c2` ON `a2`.`id` = `c2`.`id` WHERE `c`.`id` = :id52μs1.38KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_content` AS `a` INNER JOIN `v12ai_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `v12ai_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `v12ai_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `v12ai_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `v12ai_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)104μs6.12KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (76) AND `reference_table`= 'content'59μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT alias FROM v12ai_content WHERE id = 7627μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_content` AS `a` INNER JOIN `v12ai_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `v12ai_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `v12ai_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `v12ai_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `v12ai_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)99μs6.12KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (76) AND `reference_table`= 'content'56μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 76 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'58μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 76 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'48μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 16 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'categories'43μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 520 AND fc.language_id = 3 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'50μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 52041μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 520 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'73μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_menu`347μs1.7KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '520'110μs2.84KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (520) AND `reference_table`= 'menu'118μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT p.*, jfc.value as jfcvalue FROM v12ai_menu AS n, v12ai_menu AS p LEFT JOIN v12ai_falang_content as jfc ON jfc.reference_table='menu' AND jfc.reference_id=p.id AND jfc.language_id='1' and jfc.reference_field='alias' WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 520 AND p.client_id = 0 ORDER BY p.lft207μs3.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • 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 `v12ai_content` AS `a` INNER JOIN `v12ai_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `v12ai_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `v12ai_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `v12ai_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `v12ai_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)118μs6.12KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (76) AND `reference_table`= 'content'65μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 76 AND fc.language_id = 2 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'59μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `alias` FROM `v12ai_content` WHERE id = '76'27μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 76 AND fc.language_id = 2 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'49μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 16 AND fc.language_id = 2 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'categories'43μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 520 AND fc.language_id = 2 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'48μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 52023μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 520 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'46μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '520'47μs2.84KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (520) AND `reference_table`= 'menu'42μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT p.*, jfc.value as jfcvalue FROM v12ai_menu AS n, v12ai_menu AS p LEFT JOIN v12ai_falang_content as jfc ON jfc.reference_table='menu' AND jfc.reference_id=p.id AND jfc.language_id='1' and jfc.reference_field='alias' WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 520 AND p.client_id = 0 ORDER BY p.lft99μs3.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • 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 `v12ai_content` AS `a` INNER JOIN `v12ai_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `v12ai_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `v12ai_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `v12ai_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `v12ai_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)101μs6.12KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (76) AND `reference_table`= 'content'54μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 76 AND fc.language_id = 4 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'59μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `alias` FROM `v12ai_content` WHERE id = '76'25μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 76 AND fc.language_id = 4 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'52μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 16 AND fc.language_id = 4 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'categories'46μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 520 AND fc.language_id = 4 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'47μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '520'46μs2.84KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (520) AND `reference_table`= 'menu'44μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT p.*, jfc.value as jfcvalue FROM v12ai_menu AS n, v12ai_menu AS p LEFT JOIN v12ai_falang_content as jfc ON jfc.reference_table='menu' AND jfc.reference_id=p.id AND jfc.language_id='4' and jfc.reference_field='alias' WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 520 AND p.client_id = 0 ORDER BY p.lft103μs3.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 52024μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 520 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'51μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '520'43μs2.84KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (520) AND `reference_table`= 'menu'46μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT p.*, jfc.value as jfcvalue FROM v12ai_menu AS n, v12ai_menu AS p LEFT JOIN v12ai_falang_content as jfc ON jfc.reference_table='menu' AND jfc.reference_id=p.id AND jfc.language_id='1' and jfc.reference_field='alias' WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 520 AND p.client_id = 0 ORDER BY p.lft94μs3.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT m.* FROM v12ai_modules AS m LEFT JOIN v12ai_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.client_id = 0 AND m.id = 119 AND m.access IN (1,5) AND m.published = 1 AND e.enabled = 1 ORDER BY m.ordering109μs2.39KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM v12ai_hikashop_config158μs24.63KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));23μs0B/plugins/system/falangdriver/falang_database.php:133Copy
  • SELECT a.id FROM v12ai_menu AS a INNER JOIN `v12ai_menu_types` as b on a.menutype = b.menutype WHERE a.type='component' AND a.published=1 AND b.title IS NOT NULL AND a.access IN (1,5) AND a.client_id=0 AND a.link='index.php?option=com_hikashop&view=checkout&layout=show' AND a.language IN ('*', '', 'en-GB')187μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT a.id FROM v12ai_menu AS a INNER JOIN `v12ai_menu_types` as b on a.menutype = b.menutype WHERE a.type='component' AND a.published=1 AND b.title IS NOT NULL AND a.access IN (1,5) AND a.client_id=0 AND a.link LIKE 'index.php?option=com_hikashop&view=%' AND a.language IN ('*', '', 'en-GB')188μs600B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (616,617,618,619,620) AND `reference_table`= 'menu'64μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • 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 `v12ai_scheduler_tasks` AS `a` WHERE `a`.`state` = 142μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_schemaorg` WHERE `itemId` = :itemId AND `context` = :context39μs1.55KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • 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 `v12ai_content` AS `a` INNER JOIN `v12ai_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `v12ai_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `v12ai_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `v12ai_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `v12ai_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0 AND `a`.`language` IN (:preparedArray1,:preparedArray2)) 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 (:preparedArray3,:preparedArray4)130μs6.23KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT reference_field, value, reference_id, original_value FROM `v12ai_falang_content` WHERE `language_id`=1 AND `published`= 1 AND `reference_id`IN (76) AND `reference_table`= 'content'68μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • infoplg_system_j2xml - plgSystemJ2xml::__construct
  • infoplg_system_j2xml - plgSystemJ2xml::onAfterDispatch
ExtensionFile
joomla
  • + /language/en-GB/joomla.ini
lib_joomla
  • + /language/en-GB/lib_joomla.ini
plg_system_admintools
  • + /administrator/language/en-GB/plg_system_admintools.ini
plg_system_tgeoip
  • - /administrator/language/en-GB/plg_system_tgeoip.ini
  • - /administrator/language/en-GB/en-GB.plg_system_tgeoip.ini
  • - /plugins/system/tgeoip/language/en-GB/plg_system_tgeoip.ini
  • + /plugins/system/tgeoip/language/en-GB/en-GB.plg_system_tgeoip.ini
plg_system_regularlabs
  • - /plugins/system/regularlabs/language/en-GB/plg_system_regularlabs.ini
  • + /plugins/system/regularlabs/language/en-GB/en-GB.plg_system_regularlabs.ini
plg_system_modulesanywhere
  • - /administrator/language/en-GB/plg_system_modulesanywhere.ini
  • - /administrator/language/en-GB/en-GB.plg_system_modulesanywhere.ini
  • - /plugins/system/modulesanywhere/language/en-GB/plg_system_modulesanywhere.ini
  • + /plugins/system/modulesanywhere/language/en-GB/en-GB.plg_system_modulesanywhere.ini
plg_system_j2xml
  • - /administrator/language/en-GB/plg_system_j2xml.ini
  • + /administrator/language/en-GB/en-GB.plg_system_j2xml.ini
plg_system_nrframework
  • - /administrator/language/en-GB/plg_system_nrframework.ini
  • - /administrator/language/en-GB/en-GB.plg_system_nrframework.ini
  • - /plugins/system/nrframework/language/en-GB/plg_system_nrframework.ini
  • + /plugins/system/nrframework/language/en-GB/en-GB.plg_system_nrframework.ini
plg_system_backuponupdate
  • + /administrator/language/en-GB/plg_system_backuponupdate.ini
plg_system_falangquickjump
  • - /administrator/language/en-GB/plg_system_falangquickjump.ini
  • - /administrator/language/en-GB/en-GB.plg_system_falangquickjump.ini
  • + /plugins/system/falangquickjump/language/en-GB/plg_system_falangquickjump.ini
plg_system_falangdriver
  • - /administrator/language/en-GB/plg_system_falangdriver.ini
  • - /administrator/language/en-GB/en-GB.plg_system_falangdriver.ini
  • + /plugins/system/falangdriver/language/en-GB/plg_system_falangdriver.ini
plg_actionlog_joomla
  • + /administrator/language/en-GB/plg_actionlog_joomla.ini
astroid
  • - /language/en-GB/astroid.ini
  • + /language/en-GB/en-GB.astroid.ini
tpl_astroid_template_two
  • - /language/en-GB/tpl_astroid_template_two.ini
  • + /language/en-GB/en-GB.tpl_astroid_template_two.ini
com_content
  • + /language/en-GB/com_content.ini
  • + /administrator/language/en-GB/com_content.ini
com_convertforms
  • - /administrator/components/com_convertforms/language/en-GB/com_convertforms.ini
  • + /administrator/components/com_convertforms/language/en-GB/en-GB.com_convertforms.ini
plg_fields_mediajce
  • - /administrator/language/en-GB/plg_fields_mediajce.ini
  • + /administrator/language/en-GB/en-GB.plg_fields_mediajce.ini
plg_fields_calendar
  • + /administrator/language/en-GB/plg_fields_calendar.ini
plg_fields_checkboxes
  • + /administrator/language/en-GB/plg_fields_checkboxes.ini
plg_fields_color
  • + /administrator/language/en-GB/plg_fields_color.ini
plg_fields_editor
  • + /administrator/language/en-GB/plg_fields_editor.ini
plg_fields_imagelist
  • + /administrator/language/en-GB/plg_fields_imagelist.ini
plg_fields_integer
  • + /administrator/language/en-GB/plg_fields_integer.ini
plg_fields_list
  • + /administrator/language/en-GB/plg_fields_list.ini
plg_fields_media
  • + /administrator/language/en-GB/plg_fields_media.ini
plg_fields_radio
  • + /administrator/language/en-GB/plg_fields_radio.ini
plg_fields_sql
  • + /administrator/language/en-GB/plg_fields_sql.ini
plg_fields_subform
  • + /administrator/language/en-GB/plg_fields_subform.ini
plg_fields_text
  • + /administrator/language/en-GB/plg_fields_text.ini
plg_fields_textarea
  • + /administrator/language/en-GB/plg_fields_textarea.ini
plg_fields_url
  • + /administrator/language/en-GB/plg_fields_url.ini
plg_fields_user
  • + /administrator/language/en-GB/plg_fields_user.ini
plg_fields_usergrouplist
  • + /administrator/language/en-GB/plg_fields_usergrouplist.ini
mod_falang
  • + /language/en-GB/mod_falang.ini
mod_custom
  • + /language/en-GB/mod_custom.ini
plg_hikashop_datepickerfield
  • - /administrator/language/en-GB/plg_hikashop_datepickerfield.ini
  • - /administrator/language/en-GB/en-GB.plg_hikashop_datepickerfield.ini
  • - /plugins/hikashop/datepickerfield/language/en-GB/plg_hikashop_datepickerfield.ini
  • - /plugins/hikashop/datepickerfield/language/en-GB/en-GB.plg_hikashop_datepickerfield.ini
com_hikashop
  • - /language/en-GB/com_hikashop.ini
  • + /language/en-GB/en-GB.com_hikashop.ini
plg_schemaorg_article
  • + /administrator/language/en-GB/plg_schemaorg_article.ini
plg_schemaorg_blogposting
  • + /administrator/language/en-GB/plg_schemaorg_blogposting.ini
plg_schemaorg_book
  • + /administrator/language/en-GB/plg_schemaorg_book.ini
plg_schemaorg_event
  • + /administrator/language/en-GB/plg_schemaorg_event.ini
plg_schemaorg_jobposting
  • + /administrator/language/en-GB/plg_schemaorg_jobposting.ini
plg_schemaorg_organization
  • + /administrator/language/en-GB/plg_schemaorg_organization.ini
plg_schemaorg_person
  • + /administrator/language/en-GB/plg_schemaorg_person.ini
plg_schemaorg_recipe
  • + /administrator/language/en-GB/plg_schemaorg_recipe.ini
plg_schemaorg_custom
  • + /administrator/language/en-GB/plg_schemaorg_custom.ini
plg_system_debug
  • + /administrator/language/en-GB/plg_system_debug.ini