What are chord progressions and cadences?

Chord progressions

A chord progression is a series of chords played in a sequence. It is the harmonic foundation of a musical composition and determines the overall tonal character and emotional quality of a piece. Chord progressions are typically built using triads or extended chords and are written using Roman numeral notation to represent the relationship between the chords in a key.

Chord progressions help establish the harmonic structure, tension, and resolution within a piece of music, and they often follow certain patterns or conventions based on the genre or style.

When identifying chords within a progression, the main task is to find their harmonic functions within the key, which means to compare the chord to the tonic of the key. The harmonic functions are written with the Roman numerals I, II, III, IV, etc. Each numeral stands for its corresponding degree within a scale. Therefore, identifying the degree of a chord progression involves your abilities to identify intervals accurately.

All of the seven degrees of the major and minor scales can serve as the root of a triad. The triads on the “tonal” degrees of the scale (I, IV and V) are the most important for establishing the tonality of a piece.

Below is shown the seven degrees of a C major scale:

diatonicchords

I (C major), II (d minor), III (e minor), IV (F major), V (G major), VI (a minor), VII (b dim)

For example, in the key of C major, a common chord progression is the I-IV-V progression, which consists of the C major (I), F major (IV), and G major (V) chords. Another well-known progression is the I-VI-IV-V, often found in pop and rock music, which in the key of C major would be C major (I), A minor (VI), F major (IV), and G major (V).

Cadences

A cadence is a melodic and harmonic phrase that provides a sense of resolution or conclusion to a musical phrase, section, or entire composition. It is often found at the end of musical phrases or sections and creates a feeling of closure or pause.

There are different types of cadences, including:

  • Authentic Cadence: This is the most common and strong-sounding cadence. It involves a progression from the V (dominant) chord to the I (tonic) chord, such as G major (V) to C major (I) in the key of C major.

  • Plagal Cadence: This cadence is often referred to as the "Amen" cadence due to its common use in hymns. It moves from the IV chord to the I chord, such as F major (IV) to C major (I) in the key of C major.

  • Half Cadence: This cadence creates a sense of temporary pause or suspense. It typically ends on the V chord, giving the impression of an incomplete phrase or section.

  • Deceptive Cadence: Also known as an interrupted cadence, it subverts the listener's expectation by unexpectedly resolving to a different chord instead of the expected tonic chord. For example, moving from the V chord to a vi chord instead of I.

Cadences help shape the overall structure and flow of a musical composition, providing moments of tension and release.

Both chord progressions and cadences are essential tools for composers and songwriters, as they contribute to the emotional impact, coherence, and organization of music. You can train with progressions and cadences several places in EarMaster:

 

  • General Workshops
  • Jazz Workshops
  • Customized Exercise

 

Mastodon
Settings12.497MBMemory Usage91.44msRequest 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" => "AfmBOopnRxW63__eA9Xast27EaZicC7VmPNxgWXaOtpSjVkLzTiaIJfi" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:2 [ "68f777d662874437d2d3fbf9fc28a335" => "a1ee1878feb3ddb138f099f0ff8698a9" "_fbp" => "fb...
$_SERVER
array:51 [ "REDIRECT_HTTP_AUTHORIZATION" => "" "REDIRECT_STATUS" => "200" "HTTP_AUTHORIZATION"...
session
array:3 [ "counter" => 6 "timer" => array:3 [ "start" => 1755076042 "last" => 1755076053...
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 (84.2KB) (1.82ms)
  • afterInitialise (3.92MB) (24.38ms)
  • afterRoute (2.21MB) (4.31ms)
  • beforeRenderComponent com_content (37.26KB) (202μs)
  • Before Access::preloadComponents (all components) (54.17KB) (307μs)
  • After Access::preloadComponents (all components) (136.69KB) (323μs)
  • Before Access::preloadPermissions (com_content) (424B) (5μs)
  • After Access::preloadPermissions (com_content) (120.2KB) (244μs)
  • Before Access::getAssetRules (id:255 name:com_content.article.77) (6.65KB) (7μs)
  • After Access::getAssetRules (id:255 name:com_content.article.77) (8.3KB) (28μs)
  • afterRenderComponent com_content (625.09KB) (9.42ms)
  • Before Access::getAssetRules (id:1 name:root.1) (5.17KB) (45μs)
  • After Access::getAssetRules (id:1 name:root.1) (6.48KB) (11μs)
  • Before Access::getAssetRules (id:8 name:com_content) (57.09KB) (735μs)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (5μs)
  • afterDispatch (11.79KB) (207μs)
  • beforeRenderRawModule mod_falang (FaLang Language Switcher) (2.08MB) (25.62ms)
  • afterRenderRawModule mod_falang (FaLang Language Switcher) (599.03KB) (10.48ms)
  • beforeRenderModule mod_falang (FaLang Language Switcher) (736B) (4μs)
  • afterRenderModule mod_falang (FaLang Language Switcher) (5.8KB) (69μs)
  • beforeRenderRawModule mod_custom (Links to Privacy and Terms) (3.5KB) (10μs)
  • afterRenderRawModule mod_custom (Links to Privacy and Terms) (3.95KB) (117μs)
  • beforeRenderModule mod_custom (Links to Privacy and Terms) (736B) (2μs)
  • afterRenderModule mod_custom (Links to Privacy and Terms) (2.78KB) (40μs)
  • beforeRenderRawModule mod_custom (Footer) (232B) (26μs)
  • afterRenderRawModule mod_custom (Footer) (928B) (15μs)
  • beforeRenderModule mod_custom (Footer) (704B) (1μs)
  • afterRenderModule mod_custom (Footer) (15.42KB) (754μs)
  • afterRender (1.79MB) (8.44ms)
  • 1 x beforeRenderRawModule mod_falang (FaLang Language Switcher) (2.08MB) (28.02%)
    25.62ms
    1 x afterInitialise (3.92MB) (26.67%)
    24.38ms
    1 x afterRenderRawModule mod_falang (FaLang Language Switcher) (599.03KB) (11.46%)
    10.48ms
    1 x afterRenderComponent com_content (625.09KB) (10.3%)
    9.42ms
    1 x afterRender (1.79MB) (9.23%)
    8.44ms
    1 x afterRoute (2.21MB) (4.72%)
    4.31ms
    1 x afterLoad (84.2KB) (1.99%)
    1.82ms
    1 x afterRenderModule mod_custom (Footer) (15.42KB) (0.82%)
    754μs
    1 x Before Access::getAssetRules (id:8 name:com_content) (57.09KB) (0.8%)
    735μs
    1 x After Access::preloadComponents (all components) (136.69KB) (0.35%)
    323μs
    1 x Before Access::preloadComponents (all components) (54.17KB) (0.34%)
    307μs
    1 x After Access::preloadPermissions (com_content) (120.2KB) (0.27%)
    244μs
    1 x afterDispatch (11.79KB) (0.23%)
    207μs
    1 x beforeRenderComponent com_content (37.26KB) (0.22%)
    202μs
    1 x afterRenderRawModule mod_custom (Links to Privacy and Terms) (3.95KB) (0.13%)
    117μs
    1 x afterRenderModule mod_falang (FaLang Language Switcher) (5.8KB) (0.08%)
    69μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (5.17KB) (0.05%)
    45μs
    1 x afterRenderModule mod_custom (Links to Privacy and Terms) (2.78KB) (0.04%)
    40μs
    1 x After Access::getAssetRules (id:255 name:com_content.article.77) (8.3KB) (0.03%)
    28μs
    1 x beforeRenderRawModule mod_custom (Footer) (232B) (0.03%)
    26μs
    1 x afterRenderRawModule mod_custom (Footer) (928B) (0.02%)
    15μ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 Before Access::getAssetRules (id:255 name:com_content.article.77) (6.65KB) (0.01%)
    7μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.01%)
    5μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0.01%)
    5μs
    1 x beforeRenderModule mod_falang (FaLang Language Switcher) (736B) (0%)
    4μ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 unique11.94ms3.08MB
  • select distinct reference_table from v12ai_falang_content66μs1016B/plugins/system/falangdriver/falang_database.php:224Copy
  • SELECT `params` FROM `v12ai_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'67μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_admintools_ipautoban`37μs656B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `ip` FROM `v12ai_admintools_ipblock`34μs776B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `source`,`dest`,`keepurlparams` FROM `v12ai_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC45μ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.15ms1.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`915μs1.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` = 149μ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` = 180μ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)164μ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` = 0125μs5.48KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_content`189μs1.77KB/plugins/system/falangdriver/falang_database.php:330Copy
  • UPDATE `v12ai_content` SET `hits` = (`hits` + 1) WHERE `id` = '77'114μ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)133μs22.19KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT joomlatablename,tablepkID FROM `v12ai_falang_tableinfo`33μs1KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM v12ai_languages ORDER BY ordering44μs1.64KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_languages`142μ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 (77) AND `reference_table`= 'content'73μ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`126μ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`105μ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 `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`109μ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 ASC266μs4.75KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `params` FROM `v12ai_categories` WHERE `id`=1645μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `id` FROM `v12ai_rstbox` WHERE `published` = 1 AND `testmode` = 040μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `language`,`id` FROM `v12ai_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 090μ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'61μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT `alias`,`catid` FROM v12ai_content WHERE `id` = :key30μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `alias`,`catid` FROM v12ai_content WHERE `id` = :key24μ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 09:07:34') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-08-13 09:07:34') AND c2.state = 165μ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`293μ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'177μ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` ASC88μ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 100135μ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`161μs1.58KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_users` WHERE `id` = :userid52μ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` = :muserid59μ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`130μ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`107μ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 `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`106μ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)86μ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`98μ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`90μ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 `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)71μ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`105μ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)75μ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`105μ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`91μ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)84μ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`93μ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`91μ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)75μ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`97μ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`90μ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)84μ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`99μ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`97μ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)79μ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`100μ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`91μ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)76μ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`92μ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`89μ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)80μ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` = :id55μ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)110μs22.13KBParams/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 (77) AND `reference_table`= 'content'59μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT alias FROM v12ai_content WHERE id = 7726μ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)95μs22.13KBParams/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 (77) AND `reference_table`= 'content'52μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 77 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'60μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 77 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'47μ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'44μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 522 AND fc.language_id = 3 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'52μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 52223μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 522 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'45μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_menu`197μs1.7KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '522'65μ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 (522) AND `reference_table`= 'menu'58μ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 = 522 AND p.client_id = 0 ORDER BY p.lft104μ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)103μs22.13KBParams/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 (77) AND `reference_table`= 'content'55μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 77 AND fc.language_id = 2 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'103μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `alias` FROM `v12ai_content` WHERE id = '77'33μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 77 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 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'48μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 522 AND fc.language_id = 2 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'52μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 52225μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 522 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'50μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '522'48μ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 (522) 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 = 522 AND p.client_id = 0 ORDER BY p.lft101μ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)103μs22.13KBParams/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 (77) AND `reference_table`= 'content'52μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 77 AND fc.language_id = 4 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'57μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `alias` FROM `v12ai_content` WHERE id = '77'32μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 77 AND fc.language_id = 4 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'47μ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'43μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 522 AND fc.language_id = 4 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'52μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '522'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 (522) AND `reference_table`= 'menu'43μ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 = 522 AND p.client_id = 0 ORDER BY p.lft106μs3.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 52224μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 522 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'50μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '522'48μ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 (522) 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 = 522 AND p.client_id = 0 ORDER BY p.lft88μ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.ordering57μs2.39KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM v12ai_hikashop_config90μs24.63KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));22μ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')209μ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')192μ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` = 145μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_schemaorg` WHERE `itemId` = :itemId AND `context` = :context38μ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)115μs22.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 (77) AND `reference_table`= 'content'55μ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