2.3. Melody*

Introduction

Melody is one of the most basic elements of music. A note is a sound with a particular pitch and duration. String a series of notes together, one after the other, and you have a melody. But the melody of a piece of music isn't just any string of notes. It's the notes that catch your ear as you listen; the line that sounds most important is the melody. There are some common terms used in discussions of melody that you may find it useful to know. First of all, the melodic line of a piece of music is the string of notes that make up the melody. Extra notes, such as trills and slides, that are not part of the main melodic line but are added to the melody either by the composer or the performer to make the melody more complex and interesting are called ornaments or embellishments. Below are some more concepts that are associated with melody.

The Shape or Contour of a Melody

A melody that stays on the same pitch gets boring pretty quickly. As the melody progresses, the pitches may go up or down slowly or quickly. One can picture a line that goes up steeply when the melody suddenly jumps to a much higher note, or that goes down slowly when the melody gently falls. Such a line gives the contour or shape of the melodic line. You can often get a good idea of the shape of this line by looking at the melody as it is written on the staff, but you can also hear it as you listen to the music.

Figure 2.1. 

Arch shapes (in which the melody rises and then falls) are easy to find in many melodies.

You can also describe the shape of a melody verbally. For example, you can speak of a "rising melody" or of an "arch-shaped" phrase. Please see The Shape of a Melody for children's activities covering melodic contour.

Melodic Motion

Another set of useful terms describe how quickly a melody goes up and down. A melody that rises and falls slowly, with only small pitch changes between one note and the next, is conjunct. One may also speak of such a melody in terms of step-wise or scalar motion, since most of the intervals in the melody are half or whole steps or are part of a scale.

A melody that rises and falls quickly, with large intervals between one note and the next, is a disjunct melody. One may also speak of "leaps" in the melody. Many melodies are a mixture of conjunct and disjunct motion.

Figure 2.2. 

A melody may show conjuct motion, with small changes in pitch from one note to the next, or disjunct motion, with large leaps. Many melodies are an interesting, fairly balanced mixture of conjunct and disjunct motion.

Melodic Phrases

Melodies are often described as being made up of phrases. A musical phrase is actually a lot like a grammatical phrase. A phrase in a sentence (for example, "into the deep, dark forest" or "under that heavy book") is a group of words that make sense together and express a definite idea, but the phrase is not a complete sentence by itself. A melodic phrase is a group of notes that make sense together and express a definite melodic "idea", but it takes more than one phrase to make a complete melody.

How do you spot a phrase in a melody? Just as you often pause between the different sections in a sentence (for example, when you say, "wherever you go, there you are"), the melody usually pauses slightly at the end of each phrase. In vocal music, the musical phrases tend to follow the phrases and sentences of the text. For example, listen to the phrases in the melody of "The Riddle Song" and see how they line up with the four sentences in the song.

Figure 2.3. The Riddle Song

This melody has four phrases, one for each sentence of the text.

But even without text, the phrases in a melody can be very clear. Even without words, the notes are still grouped into melodic "ideas". Listen to the first strain of Scott Joplin's "The Easy Winners" to see if you can hear four phrases in the melody.

One way that a composer keeps a piece of music interesting is by varying how strongly the end of each phrase sounds like "the end". Usually, full-stop ends come only at the end of the main sections of the music. (See form and cadence for more on this.) By varying aspects of the melody, the rhythm, and the harmony, the composer gives the ends of the other phrases stronger or weaker "ending" feelings. Often, phrases come in definite pairs, with the first phrase feeling very unfinished until it is completed by the second phrase, as if the second phrase were answering a question asked by the first phrase. When phrases come in pairs like this, the first phrase is called the antecedent phrase, and the second is called the consequent phrase. Listen to antecedent and consequent phrases in the tune "Auld Lang Syne".

Figure 2.4. Antecedent and Consequent Phrases

The rhythm of the first two phrases of "Auld Lang Syne" is the same, but both the melody and the harmony lead the first phrase to feel unfinished until it is answered by the second phrase. Note that both the melody and harmony of the second phrase end on the tonic, the "home" note and chord of the key.

Of course, melodies don't always divide into clear, separated phrases. Often the phrases in a melody will run into each other, cut each other short, or overlap. This is one of the things that keeps a melody interesting.

Motif

Another term that usually refers to a piece of melody (although it can also refer to a rhythm or a chord progression) is "motif". A motif is a short musical idea - shorter than a phrase - that occurs often in a piece of music. A short melodic idea may also be called a motiv, a motive, a cell, or a figure. These small pieces of melody will appear again and again in a piece of music, sometimes exactly the same and sometimes changed. When a motif returns, it can be slower or faster, or in a different key. It may return "upside down" (with the notes going up instead of down, for example), or with the pitches or rhythms altered.

Figure 2.5. 

The "fate motif" from the first movement of Beethoven's Symphony No. 5. This is a good example of a short melodic idea (a cell, motive, or figure) that is used in many different ways throughout the movement.

Most figures and motifs are shorter than phrases, but some of the leitmotifs of Wagner's operas are long enough to be considered phrases. A leitmotif (whether it is a very short cell or a long phrase) is associated with a particular character, place, thing, or idea in the opera and may be heard whenever that character is on stage or that idea is an important part of the plot. As with other motifs, leitmotifs may be changed when they return. For example, the same melody may sound quite different depending on whether the character is in love, being heroic, or dying.

Figure 2.6. 

A melodic phrase based on the Siegfried leitmotif, from Wagner's opera The Valkyrie.

Melodies in Counterpoint

Counterpoint has more than one melody at the same time. This tends to change the rules for using and developing melodies, so the terms used to talk about contrapuntal melodies are different, too. For example, the melodic idea that is most important in a fugue is called its subject. Like a motif, a subject has often changed when it reappears, sounding higher or lower, for example, or faster or slower. For more on the subject (pun intended), please see Counterpoint.

Themes

A longer section of melody that keeps reappearing in the music - for example, in a "theme and variations" - is often called a theme. Themes generally are at least one phrase long and often have several phrases. Many longer works of music, such as symphony movements, have more than one melodic theme.

Figure 2.7. Theme from Beethoven's Symphony No. 9

The tune of this theme will be very familiar to most people, but you may want to listen to the entire last movement of the symphony to hear the different ways that Beethoven uses the melody again and again.

The musical scores for movies and television can also contain melodic themes, which can be developed as they might be in a symphony or may be used very much like operatic leitmotifs. For example, in the music John Williams composed for the Star Wars movies, there are melodic themes that are associated with the main characters. These themes are often complete melodies with many phrases, but a single phrase can be taken from the melody and used as a motif. A single phrase of Ben Kenobi's Theme, for example, can remind you of all the good things he stands for, even if he is not on the movie screen at the time.

Suggestions for Presenting these Concepts to Children

Melody is a particularly easy concept to convey to children, since attention to a piece of music is naturally drawn to the melody. If you would like to introduce some of these concepts and terms to children, please see A Melody Activity, The Shape of a Melody, Melodic Phrases, and Theme and Motif in Music.

Previous
2.2 Timbre
Top Next
2.4 Texture

© 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.339MBMemory Usage112msRequest 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" => "AfmBOooXtsbE7SpaDzuFzCiL9gGWd2QPdpjxUO6xuqgJFVpoKfXTSK16" ]
$_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" => 4 "timer" => array:3 [ "start" => 1755076042 "last" => 1755076049...
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) (1.55ms)
  • afterInitialise (3.92MB) (35.13ms)
  • afterRoute (2.21MB) (6.4ms)
  • beforeRenderComponent com_content (43.64KB) (232μs)
  • Before Access::preloadComponents (all components) (54.17KB) (397μs)
  • After Access::preloadComponents (all components) (136.69KB) (373μs)
  • Before Access::preloadPermissions (com_content) (424B) (6μs)
  • After Access::preloadPermissions (com_content) (120.2KB) (295μs)
  • Before Access::getAssetRules (id:245 name:com_content.article.87) (6.65KB) (8μs)
  • After Access::getAssetRules (id:245 name:com_content.article.87) (8.3KB) (37μs)
  • afterRenderComponent com_content (692.81KB) (9.66ms)
  • 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) (742μs)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (5μs)
  • afterDispatch (11.91KB) (206μs)
  • beforeRenderRawModule mod_falang (FaLang Language Switcher) (2.15MB) (26.51ms)
  • afterRenderRawModule mod_falang (FaLang Language Switcher) (676.41KB) (11.39ms)
  • beforeRenderModule mod_falang (FaLang Language Switcher) (736B) (3μs)
  • afterRenderModule mod_falang (FaLang Language Switcher) (5.8KB) (77μs)
  • beforeRenderRawModule mod_custom (Links to Privacy and Terms) (3.5KB) (9μs)
  • afterRenderRawModule mod_custom (Links to Privacy and Terms) (3.95KB) (188μ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) (14μs)
  • beforeRenderModule mod_custom (Footer) (704B) (1μs)
  • afterRenderModule mod_custom (Footer) (9.52KB) (514μs)
  • beforeRenderRawModule mod_astroid_menu (Understanding Basic Music Theory) (152B) (35μs)
  • afterRenderRawModule mod_astroid_menu (Understanding Basic Music Theory) (2.73MB) (5.82ms)
  • 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) (26μs)
  • afterRenderRawModule mod_booknavigate (Book Navigation) (5.19KB) (71μs)
  • beforeRenderModule mod_booknavigate (Book Navigation) (720B) (1μs)
  • afterRenderModule mod_booknavigate (Book Navigation) (3.13KB) (36μs)
  • beforeRenderRawModule mod_custom (Music Theory Course Copyright) (208B) (6μ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) (32μs)
  • afterRender (2.02MB) (8.98ms)
  • 1 x afterInitialise (3.92MB) (31.43%)
    35.13ms
    1 x beforeRenderRawModule mod_falang (FaLang Language Switcher) (2.15MB) (23.71%)
    26.51ms
    1 x afterRenderRawModule mod_falang (FaLang Language Switcher) (676.41KB) (10.19%)
    11.39ms
    1 x afterRenderComponent com_content (692.81KB) (8.64%)
    9.66ms
    1 x afterRender (2.02MB) (8.04%)
    8.98ms
    1 x afterRoute (2.21MB) (5.73%)
    6.40ms
    1 x afterRenderRawModule mod_astroid_menu (Understanding Basic Music Theory) (2.73MB) (5.2%)
    5.82ms
    1 x afterLoad (84.07KB) (1.39%)
    1.55ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (56.91KB) (0.66%)
    742μs
    1 x afterRenderModule mod_custom (Footer) (9.52KB) (0.46%)
    514μs
    1 x Before Access::preloadComponents (all components) (54.17KB) (0.36%)
    397μs
    1 x After Access::preloadComponents (all components) (136.69KB) (0.33%)
    373μs
    1 x After Access::preloadPermissions (com_content) (120.2KB) (0.26%)
    295μs
    1 x beforeRenderComponent com_content (43.64KB) (0.21%)
    232μs
    1 x afterDispatch (11.91KB) (0.18%)
    206μs
    1 x afterRenderRawModule mod_custom (Links to Privacy and Terms) (3.95KB) (0.17%)
    188μ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.07%)
    77μs
    1 x afterRenderRawModule mod_booknavigate (Book Navigation) (5.19KB) (0.06%)
    71μ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 After Access::getAssetRules (id:245 name:com_content.article.87) (8.3KB) (0.03%)
    37μs
    1 x afterRenderModule mod_booknavigate (Book Navigation) (3.13KB) (0.03%)
    36μs
    1 x beforeRenderRawModule mod_astroid_menu (Understanding Basic Music Theory) (152B) (0.03%)
    35μs
    1 x afterRenderModule mod_custom (Music Theory Course Copyright) (3.22KB) (0.03%)
    32μs
    1 x beforeRenderRawModule mod_custom (Footer) (744B) (0.02%)
    26μs
    1 x beforeRenderRawModule mod_booknavigate (Book Navigation) (4.29KB) (0.02%)
    26μs
    1 x afterRenderRawModule mod_custom (Music Theory Course Copyright) (1.05KB) (0.01%)
    16μs
    1 x afterRenderRawModule mod_custom (Footer) (928B) (0.01%)
    14μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.01%)
    12μs
    1 x beforeRenderRawModule mod_custom (Links to Privacy and Terms) (3.5KB) (0.01%)
    9μs
    1 x Before Access::getAssetRules (id:245 name:com_content.article.87) (6.65KB) (0.01%)
    8μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.01%)
    6μs
    1 x beforeRenderRawModule mod_custom (Music Theory Course Copyright) (208B) (0.01%)
    6μ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_custom (Links to Privacy and Terms) (736B) (0%)
    2μs
    1 x beforeRenderModule mod_custom (Footer) (704B) (0%)
    1μs
    1 x beforeRenderModule mod_booknavigate (Book Navigation) (720B) (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 unique14.27ms3.34MB
  • select distinct reference_table from v12ai_falang_content120μs1016B/plugins/system/falangdriver/falang_database.php:224Copy
  • SELECT `params` FROM `v12ai_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'124μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_admintools_ipautoban`72μs656B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `ip` FROM `v12ai_admintools_ipblock`60μs776B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `source`,`dest`,`keepurlparams` FROM `v12ai_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC74μ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`2.04ms1.23MBParams/plugins/system/falangdriver/falang_database.php:133Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `v12ai_menu` AS `m` LEFT JOIN `v12ai_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`1.66ms1.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` = 187μ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` = 1133μ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)192μ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` = 0153μs5.48KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_content`207μs1.77KB/plugins/system/falangdriver/falang_database.php:330Copy
  • UPDATE `v12ai_content` SET `hits` = (`hits` + 1) WHERE `id` = '87'120μ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)132μs46.19KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT joomlatablename,tablepkID FROM `v12ai_falang_tableinfo`36μ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`140μ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 (87) AND `reference_table`= 'content'74μ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`124μ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)87μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`110μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT 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 ASC265μs4.75KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `params` FROM `v12ai_categories` WHERE `id`=2339μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `id` FROM `v12ai_rstbox` WHERE `published` = 1 AND `testmode` = 043μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `language`,`id` FROM `v12ai_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 088μ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'58μ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` = :key25μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `v12ai_content` AS `c` INNER JOIN `v12ai_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `v12ai_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `v12ai_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `v12ai_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-08-13 09:07:33') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-08-13 09:07:33') AND c2.state = 164μ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μ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,115,122,114) AND `reference_table`= 'modules'172μ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` ASC83μ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 100141μ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`152μs1.58KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_users` WHERE `id` = :userid50μ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`127μ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)87μ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 `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)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`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`88μ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)78μ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`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)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`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`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)72μ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`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)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`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)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`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`88μ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 `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`88μ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)76μ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`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)82μ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`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)73μ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` = :id53μ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)102μs46.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 (87) AND `reference_table`= 'content'58μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT alias FROM v12ai_content WHERE id = 8726μ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)89μs46.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 (87) AND `reference_table`= 'content'51μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 87 AND fc.language_id = 3 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 = '87'24μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 87 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'49μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 23 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'categories'45μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 171 AND fc.language_id = 3 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'49μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_menu`165μs1.7KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '171'59μ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 (171) AND `reference_table`= 'menu'56μ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 = 171 AND p.client_id = 0 ORDER BY p.lft112μs19.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 17127μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 171 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'54μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '171'49μ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 (171) AND `reference_table`= 'menu'44μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT p.*, jfc.value as jfcvalue FROM v12ai_menu AS n, v12ai_menu AS p LEFT JOIN v12ai_falang_content as jfc ON jfc.reference_table='menu' AND jfc.reference_id=p.id AND jfc.language_id='1' and jfc.reference_field='alias' WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 171 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)97μs46.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 (87) AND `reference_table`= 'content'51μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 87 AND fc.language_id = 2 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'52μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `alias` FROM `v12ai_content` WHERE id = '87'25μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 87 AND fc.language_id = 2 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 = 2 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'categories'46μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 171 AND fc.language_id = 2 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'47μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '171'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 (171) 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='2' and jfc.reference_field='alias' WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 171 AND p.client_id = 0 ORDER BY p.lft98μs19.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 17124μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 171 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` = '171'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 (171) 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 = 171 AND p.client_id = 0 ORDER BY p.lft87μ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μs46.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 (87) 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 = 87 AND fc.language_id = 4 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'56μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `alias` FROM `v12ai_content` WHERE id = '87'25μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 87 AND fc.language_id = 4 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 = 4 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 = 171 AND fc.language_id = 4 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'47μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '171'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 (171) 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='4' and jfc.reference_field='alias' WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 171 AND p.client_id = 0 ORDER BY p.lft100μs19.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 17124μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 171 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'47μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '171'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 (171) 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 = 171 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.ordering55μ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')230μ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')193μ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'71μ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` = :context41μ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)110μs46.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 (87) AND `reference_table`= 'content'58μ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
mod_astroid_menu
  • + /language/en-GB/mod_astroid_menu.ini
mod_booknavigate
  • - /language/en-GB/mod_booknavigate.ini
  • - /language/en-GB/en-GB.mod_booknavigate.ini
  • - /modules/mod_booknavigate/language/en-GB/mod_booknavigate.ini
  • - /modules/mod_booknavigate/language/en-GB/en-GB.mod_booknavigate.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