2.5. Harmony*

When you have more than one pitch sounding at the same time in music, the result is harmony. Harmony is one of the basic elements of music, but it is not as basic as some other elements, such as rhythm and melody. You can have music that is just rhythms, with no pitches at all. You can also have music that is just a single melody, or just a melody with rhythm accompaniment.

But as soon as there is more than one pitch sounding at a time, you have harmony. Even if nobody is actually playing chords, or even if the notes are part of independent contrapuntal lines, you can hear the relationship of any notes that happen at the same time, and it is this relationship that makes the harmony.

Note

Harmony does not have to be particularly "harmonious"; it may be quite dissonant, in fact. For the purpose of definitions, the important fact is the notes sounding at the same time.

 

Harmony is the most emphasized and most highly developed element in Western music, and can be the subject of an entire course on music theory. Many of the concepts underlying Western harmony are explained in greater detail elsewhere (see Triads and Beginning Harmonic Analysis, for example), but here are some basic terms and short definitions that you may find useful in discussions of harmony:

Harmony Textures

  • implied harmony - A melody all by itself (Monophony) can have an implied harmony, even if no other notes are sounding at the same time. In other words, the melody can be constructed so that it strongly suggests a harmony that could accompany it. For example, when you sing a melody by itself, you may be able to "hear" in your mind the chords that usually go with it. A Bach unaccompanied cello suite also has strongly implied harmonies; if someone really wanted to play an accompaniment, the appropriate chords could be found pretty easily. But some melodies don't imply any harmony; they are not meant to be played with harmony, and don't need it to be legitimate music. (Good examples of this include plainchant, some modern art music, and some Non-Western music, for example, Native American flute music.)

  • drones - The simplest way to add harmony to a melody is to play it with drones. A drone is a note that changes rarely or not at all. Drones can be most easily found in bagpipes music, Indian Classical music and other musics that use instruments that traditionally play drone notes. (See Harmony with Drones.)

  • parallel harmony - Parallel harmony occurs when different lines in the music go up or down together (usually following the melody). (See Parallel Harmonies for examples.)

  • homophony - Homophony is a texture of music in which there is one line that is obviously the melody. The rest of the notes are harmony and accompaniment. (See Homophonic.)

  • polyphony or counterpoint - Both of these terms refer to a texture of music in which there is more than one independent melodic line at the same time, and they are all fairly equal in importance. (See Polyphonic and Counterpoint.)

Chords

  • chords - In Western music, most harmony is based on chords. Chords are groups of notes built on major or minortriads. In traditional triadic harmony, there are always at least three notes in a chord (there can be more than three), but some of the notes may be left out and only "implied" by the harmony. The notes of the chord may be played at the same time (block chords), or may be played separately with some overlap, or may be played separately but in a quick enough succession that they will be "heard" as a chord or understood to imply a chord (arpeggiated chords or arpeggios).

  • chord progression - A series of chords played one after another is a chord progression. Musicians may describe a specific chord progression (for example, "two measures of G major, then a half measure of A minor and a half measure of D seventh", or just "G, A minor, D seventh") or speak more generally of classes of chord progressions (for example a "blues chord progression"). Please see Beginning Harmonic Analysis for more information.

Harmonic Analysis

  • functional harmony - Harmony can simply be more than one note sounding at a time, providing texture and interest to a piece; drones are one example of this non-functional type of harmony. One of the most important features of common practice music, however, is functional harmony. This is harmony in which each chord functions in a specific way in the key, and underpins the form of the piece of music. For an introduction to functional harmony, see Beginning Harmonic Analysis

  • harmonic rhythm - The harmonic rhythm of a piece refers to how often the chords change. Music in which the chords change rarely has a slow harmonic rhythm; music in which the chords change often has a fast harmonic rhythm. Harmonic rhythm can be completely separate from other rhythms and tempos. For example, a section of music with many short, quick notes but only one chord has fast rhythms but a slow harmonic rhythm.

  • cadence - A cadence is a point where the music feels as if it has come to a temporary or permanent stopping point. In most Western music, cadence is tied very strongly to the harmony. For example, most listeners will feel that the strongest, most satisfying ending to a piece of music involves a dominant chord followed by a tonic chord. In fact, a song that does not end on the tonic chord will sound quite unsettled and even unfinished to most listeners. (See Cadence.)

  • diatonic - Diatonic harmony stays in a particular major or minor key.

  • chromatic - Chromatic harmony includes many notes and chords that are not in the key and so contains many accidentals.

  • dissonance - A dissonance is a note, chord, or interval that does not fit into the triadic harmonies that we have learned to expect from music. A dissonance may sound surprising, jarring, even unpleasant.

Accompaniment

  • accompaniment - All the parts of the music that are not melody are part of the accompaniment. This includes rhythmic parts, harmonies, the bass line, and chords.

  • melodic line - This is just another term for the string of notes that make up the melody.

  • bass line - The bass line is the string of notes that are the lowest notes being sung or played. Because of basic laws of physics, the bass line sets up the harmonics that all the other parts - including the melody - must fit into. This makes it a very important line both for tuning and for the harmony. The bass line also often outlines the chord progression, and it is often the most noticeable line of the accompaniment.

  • inner parts or inner voices - Accompaniment parts that fill in the music in between the melody (which is often the highest part) and the bass line.

  • descant - The melody is not always the highest line in the music. Attention is naturally drawn to high notes, so a part that is higher than the melody is sometimes given a special name such as "descant". This term is an old one going all the way back to when harmonies first began to be added to medieval chant. (See Counterpoint for more about descants.)

Suggestions for activities that introduce young students to harmony may be found in Harmony with Drones, Simple Chordal Harmony, Parallel Harmonies, and Independent Harmonies.

Previous
2.4 Texture
Top Next
2.6 Counterpoint

© Nov 14, 2013 Catherine Schmidt-Jones.
Textbook content produced by Catherine Schmidt-Jones is licensed under a Creative Commons Attribution License 2.0 license.
Download for free at http://cnx.org/contents/2ad74b7b-a72f-42a9-a31b-7e75542e54bd@3.74

Mastodon
Settings16.225MBMemory Usage113msRequest 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" => "AfmBOorfVUdL9h2e9Cc8RokorXPnBtkO5vVpsVAbz9Zi8L_KY9aggVmF" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:2 [ "68f777d662874437d2d3fbf9fc28a335" => "4d87e022be8da7b78eab6f4145088755" "_fbp" => "fb...
$_SERVER
array:51 [ "REDIRECT_HTTP_AUTHORIZATION" => "" "REDIRECT_STATUS" => "200" "HTTP_AUTHORIZATION"...
session
array:3 [ "counter" => 8 "timer" => array:3 [ "start" => 1755077663 "last" => 1755077679...
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.07KB) (570μs)
  • afterInitialise (3.92MB) (34.99ms)
  • afterRoute (2.21MB) (8.68ms)
  • beforeRenderComponent com_content (43.64KB) (284μs)
  • Before Access::preloadComponents (all components) (54.17KB) (390μs)
  • After Access::preloadComponents (all components) (136.69KB) (532μs)
  • Before Access::preloadPermissions (com_content) (424B) (8μs)
  • After Access::preloadPermissions (com_content) (120.2KB) (384μs)
  • Before Access::getAssetRules (id:243 name:com_content.article.89) (6.65KB) (9μs)
  • After Access::getAssetRules (id:243 name:com_content.article.89) (8.3KB) (34μs)
  • afterRenderComponent com_content (672.99KB) (10.59ms)
  • Before Access::getAssetRules (id:1 name:root.1) (5.17KB) (47μs)
  • After Access::getAssetRules (id:1 name:root.1) (6.48KB) (12μs)
  • Before Access::getAssetRules (id:8 name:com_content) (56.91KB) (770μs)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (5μs)
  • afterDispatch (11.91KB) (211μs)
  • beforeRenderRawModule mod_falang (FaLang Language Switcher) (2.11MB) (26.31ms)
  • afterRenderRawModule mod_falang (FaLang Language Switcher) (676.41KB) (11.49ms)
  • 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) (9μs)
  • afterRenderRawModule mod_custom (Links to Privacy and Terms) (3.95KB) (103μ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) (744B) (26μs)
  • afterRenderRawModule mod_custom (Footer) (928B) (16μs)
  • beforeRenderModule mod_custom (Footer) (704B) (1μs)
  • afterRenderModule mod_custom (Footer) (8.58KB) (515μs)
  • beforeRenderRawModule mod_astroid_menu (Understanding Basic Music Theory) (152B) (33μs)
  • afterRenderRawModule mod_astroid_menu (Understanding Basic Music Theory) (2.73MB) (5.1ms)
  • beforeRenderModule mod_astroid_menu (Understanding Basic Music Theory) (736B) (3μs)
  • afterRenderModule mod_astroid_menu (Understanding Basic Music Theory) (94.65KB) (102μs)
  • beforeRenderRawModule mod_booknavigate (Book Navigation) (4.29KB) (25μs)
  • afterRenderRawModule mod_booknavigate (Book Navigation) (5.19KB) (62μs)
  • beforeRenderModule mod_booknavigate (Book Navigation) (720B) (2μs)
  • afterRenderModule mod_booknavigate (Book Navigation) (3.13KB) (37μs)
  • beforeRenderRawModule mod_custom (Music Theory Course Copyright) (208B) (7μs)
  • afterRenderRawModule mod_custom (Music Theory Course Copyright) (1.05KB) (16μs)
  • beforeRenderModule mod_custom (Music Theory Course Copyright) (736B) (1μs)
  • afterRenderModule mod_custom (Music Theory Course Copyright) (3.22KB) (27μs)
  • afterRender (1.99MB) (8.69ms)
  • 1 x afterInitialise (3.92MB) (31.05%)
    34.99ms
    1 x beforeRenderRawModule mod_falang (FaLang Language Switcher) (2.11MB) (23.35%)
    26.31ms
    1 x afterRenderRawModule mod_falang (FaLang Language Switcher) (676.41KB) (10.19%)
    11.49ms
    1 x afterRenderComponent com_content (672.99KB) (9.39%)
    10.59ms
    1 x afterRender (1.99MB) (7.71%)
    8.69ms
    1 x afterRoute (2.21MB) (7.7%)
    8.68ms
    1 x afterRenderRawModule mod_astroid_menu (Understanding Basic Music Theory) (2.73MB) (4.53%)
    5.10ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (56.91KB) (0.68%)
    770μs
    1 x afterLoad (84.07KB) (0.51%)
    570μs
    1 x After Access::preloadComponents (all components) (136.69KB) (0.47%)
    532μs
    1 x afterRenderModule mod_custom (Footer) (8.58KB) (0.46%)
    515μs
    1 x Before Access::preloadComponents (all components) (54.17KB) (0.35%)
    390μs
    1 x After Access::preloadPermissions (com_content) (120.2KB) (0.34%)
    384μs
    1 x beforeRenderComponent com_content (43.64KB) (0.25%)
    284μs
    1 x afterDispatch (11.91KB) (0.19%)
    211μs
    1 x afterRenderRawModule mod_custom (Links to Privacy and Terms) (3.95KB) (0.09%)
    103μs
    1 x afterRenderModule mod_astroid_menu (Understanding Basic Music Theory) (94.65KB) (0.09%)
    102μs
    1 x afterRenderModule mod_falang (FaLang Language Switcher) (5.8KB) (0.06%)
    68μs
    1 x afterRenderRawModule mod_booknavigate (Book Navigation) (5.19KB) (0.05%)
    62μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (5.17KB) (0.04%)
    47μs
    1 x afterRenderModule mod_custom (Links to Privacy and Terms) (2.78KB) (0.04%)
    40μs
    1 x afterRenderModule mod_booknavigate (Book Navigation) (3.13KB) (0.03%)
    37μs
    1 x After Access::getAssetRules (id:243 name:com_content.article.89) (8.3KB) (0.03%)
    34μs
    1 x beforeRenderRawModule mod_astroid_menu (Understanding Basic Music Theory) (152B) (0.03%)
    33μs
    1 x afterRenderModule mod_custom (Music Theory Course Copyright) (3.22KB) (0.02%)
    27μs
    1 x beforeRenderRawModule mod_custom (Footer) (744B) (0.02%)
    26μs
    1 x beforeRenderRawModule mod_booknavigate (Book Navigation) (4.29KB) (0.02%)
    25μs
    1 x afterRenderRawModule mod_custom (Footer) (928B) (0.01%)
    16μs
    1 x afterRenderRawModule mod_custom (Music Theory Course Copyright) (1.05KB) (0.01%)
    16μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.01%)
    12μs
    1 x Before Access::getAssetRules (id:243 name:com_content.article.89) (6.65KB) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_custom (Links to Privacy and Terms) (3.5KB) (0.01%)
    9μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.01%)
    8μs
    1 x beforeRenderRawModule mod_custom (Music Theory Course Copyright) (208B) (0.01%)
    7μ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_astroid_menu (Understanding Basic Music Theory) (736B) (0%)
    3μs
    1 x beforeRenderModule mod_booknavigate (Book Navigation) (720B) (0%)
    2μ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
    1 x beforeRenderModule mod_custom (Music Theory Course Copyright) (736B) (0%)
    1μs
131 statements were executed, 71 of which were duplicates, 60 unique17.14ms3.15MB
  • select distinct reference_table from v12ai_falang_content163μs1016B/plugins/system/falangdriver/falang_database.php:224Copy
  • SELECT `params` FROM `v12ai_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'206μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_admintools_ipautoban`113μs656B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `ip` FROM `v12ai_admintools_ipblock`92μs776B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `source`,`dest`,`keepurlparams` FROM `v12ai_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC119μ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`3.07ms1.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`2.41ms1.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` = 1111μ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` = 1308μ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)269μ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` = 0197μs5.48KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_content`242μs1.77KB/plugins/system/falangdriver/falang_database.php:330Copy
  • UPDATE `v12ai_content` SET `hits` = (`hits` + 1) WHERE `id` = '89'138μ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)173μs22.19KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT joomlatablename,tablepkID FROM `v12ai_falang_tableinfo`52μs1KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM v12ai_languages ORDER BY ordering60μs1.64KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_languages`198μ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 (89) AND `reference_table`= 'content'91μ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`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`140μ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)101μ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`119μ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 ASC282μs4.75KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `params` FROM `v12ai_categories` WHERE `id`=2341μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `id` FROM `v12ai_rstbox` WHERE `published` = 1 AND `testmode` = 045μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `language`,`id` FROM `v12ai_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0102μ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` = :key31μ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:34:41') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-08-13 09:34:41') 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`300μs82.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,115,122,114) AND `reference_table`= 'modules'174μ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` ASC82μ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 100143μ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'86μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SHOW FULL COLUMNS FROM `v12ai_users`165μs1.58KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_users` WHERE `id` = :userid51μ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` = :muserid50μ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`101μ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`108μ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`95μ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`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`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 `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`101μ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`94μ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`167μ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)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`115μ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 `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 `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`95μ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)81μ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 `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)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`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`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)74μs14.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 `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`87μ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)73μ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`92μ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)72μ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` = :id51μ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)98μ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 (89) AND `reference_table`= 'content'61μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT alias FROM v12ai_content WHERE id = 8926μ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)96μ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 (89) 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 = 89 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'63μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `alias` FROM `v12ai_content` WHERE id = '89'26μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 89 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'51μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 23 AND fc.language_id = 3 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 = 188 AND fc.language_id = 3 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'52μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_menu`177μs1.7KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '188'62μ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 (188) AND `reference_table`= 'menu'61μ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='3' and jfc.reference_field='alias' WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 188 AND p.client_id = 0 ORDER BY p.lft113μs19.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 18829μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 188 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'55μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '188'42μ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 (188) AND `reference_table`= 'menu'45μ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 = 188 AND p.client_id = 0 ORDER BY p.lft96μs19.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)96μ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 (89) 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 = 89 AND fc.language_id = 2 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'53μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `alias` FROM `v12ai_content` WHERE id = '89'24μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 89 AND fc.language_id = 2 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'46μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 23 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 = 188 AND fc.language_id = 2 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'56μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '188'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 (188) 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='2' and jfc.reference_field='alias' WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 188 AND p.client_id = 0 ORDER BY p.lft99μs19.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 18823μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 188 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'48μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '188'41μ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 (188) AND `reference_table`= 'menu'41μ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 = 188 AND p.client_id = 0 ORDER BY p.lft89μs19.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)94μ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 (89) 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 = 89 AND fc.language_id = 4 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'55μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `alias` FROM `v12ai_content` WHERE id = '89'24μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 89 AND fc.language_id = 4 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'45μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 23 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 = 188 AND fc.language_id = 4 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` = '188'42μ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 (188) 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='4' and jfc.reference_field='alias' WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 188 AND p.client_id = 0 ORDER BY p.lft99μs19.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 18823μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 188 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` = '188'40μ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 (188) AND `reference_table`= 'menu'41μ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 = 188 AND p.client_id = 0 ORDER BY p.lft91μs19.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.ordering58μ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', ''));21μ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')224μ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')194μ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'75μ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` = 146μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_schemaorg` WHERE `itemId` = :itemId AND `context` = :context37μs9.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)111μ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 (89) AND `reference_table`= 'content'56μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • infoplg_system_j2xml - plgSystemJ2xml::__construct
  • infoplg_system_j2xml - plgSystemJ2xml::onAfterDispatch