3.1. Acoustics for Music Theory*

Music is Organized Sound Waves

Music is sound that's organized by people on purpose, to dance to, to tell a story, to make other people feel a certain way, or just to sound pretty or be entertaining. Music is organized on many different levels. Sounds can be arranged into melodies, harmonies, rhythms, textures and phrases. Beats, measures, cadences, and form all help to keep the music organized and understandable. But the most basic way that music is organized is by arranging the actual sound waves themselves so that the sounds are interesting and pleasant and go well together.

A rhythmic, organized set of thuds and crashes is perfectly good music - think of your favorite drum solo - but many musical instruments are designed specifically to produce the regular, evenly spaced sound waves that we hear as particular pitches. Crashes, thuds, and bangs are loud, short jumbles of lots of different wavelengths. These are the kinds of sound we often call "noise", when they're random and disorganized, but as soon as they are organized in time (rhythm), they begin to sound like music. (When used as a scientific term, noise refers to continuous sounds that are random mixtures of different wavelengths, not shorter crashes and thuds.)

However, to get the melodic kind of sounds more often associated with music, the sound waves must themselves be organized and regular, not random mixtures. Most of the sounds we hear are brought to our ears through the air. A movement of an object causes a disturbance of the normal motion of the air molecules near the object. Those molecules in turn disturb other nearby molecules out of their normal patterns of random motion, so that the disturbance itself becomes a thing that moves through the air - a sound wave. If the movement of the object is a fast, regular vibration, then the sound waves are also very regular. We hear such regular sound waves as tones, sounds with a particular pitch. It is this kind of sound that we most often associate with music, and that many musical instruments are designed to make.

Figure 3.1. 

A random jumble of sound waves is heard as a noise. A regular, evenly-spaced sound wave is heard as a tone.

Musicians have terms that they use to describe tones. (Musicians also have other meanings for the word "tone", but this course will stick to the "a sound with pitch" meaning.) This kind of (regular, evenly spaced) wave is useful for things other than music, however, so scientists and engineers also have terms that describe pitched sound waves. As we talk about where music theory comes from, it will be very useful to know both the scientific and the musical terms and how they are related to each other.

For example, the closer together those evenly-spaced waves are, the higher the note sounds. Musicians talk about the pitch of the sound, or name specific notes, or talk about tuning. Scientists and engineers, on the other hand, talk about the frequency and the wavelength of the sound. They are all essentially talking about the same things, but talking about them in slightly different ways, and using the scientific ideas of wavelength and frequency can help clarify some of the main ideas underlying music theory.

Longitudinal and Transverse Waves

So what are we talking about when we speak of sound waves? Waves are disturbances; they are changes in something - the surface of the ocean, the air, electromagnetic fields. Normally, these changes are travelling (except for standing waves); the disturbance is moving away from whatever created it, in a kind of domino effect.

Most kinds of waves are transverse waves. In a transverse wave, as the wave is moving in one direction, it is creating a disturbance in a different direction. The most familiar example of this is waves on the surface of water. As the wave travels in one direction - say south - it is creating an up-and-down (not north-and-south) motion on the water's surface. This kind of wave is fairly easy to draw; a line going from left-to-right has up-and-down wiggles. (See Figure 3.2.)

Figure 3.2. Transverse and Longitudinal Waves

In water waves and other transverse waves, the ups and downs are in a different direction from the forward movement of the wave. The "highs and lows" of sound waves and other longitudinal waves are arranged in the "forward" direction.

But sound waves are not transverse. Sound waves are longitudinal waves. If sound waves are moving south, the disturbance that they are creating is giving the air molecules extra north-and-south (not east-and-west, or up-and-down) motion. If the disturbance is from a regular vibration, the result is that the molecules end up squeezed together into evenly-spaced waves. This is very difficult to show clearly in a diagram, so most diagrams, even diagrams of sound waves, show transverse waves.

Longitudinal waves may also be a little difficult to imagine, because there aren't any examples that we can see in everyday life (unless you like to play with toy slinkies). A mathematical description might be that in longitudinal waves, the waves (the disturbances) are along the same axis as the direction of motion of the wave; transverse waves are at right angles to the direction of motion of the wave. If this doesn't help, try imagining yourself as one of the particles that the wave is disturbing (a water drop on the surface of the ocean, or an air molecule). As it comes from behind you, a transverse waves lifts you up and then drops down; a longitudinal wave coming from behind pushes you forward and pulls you back. You can view here animations of:



(There were also some nice animations of longitudinal waves available as of this writing at Musemath.)

The result of these "forward and backward" waves is that the "high point" of a sound wave is where the air molecules are bunched together, and the "low point" is where there are fewer air molecules. In a pitched sound, these areas of bunched molecules are very evenly spaced. In fact, they are so even, that there are some very useful things we can measure and say about them. In order to clearly show you what they are, most of the diagrams in this course will show sound waves as if they are transverse waves.

Wave Amplitude and Loudness

Both transverse and longitudinal waves cause a displacement of something: air molecules, for example, or the surface of the ocean. The amount of displacement at any particular spot changes as the wave passes. If there is no wave, or if the spot is in the same state it would be in if there was no wave, there is no displacement. Displacement is biggest (furthest from "normal") at the highest and lowest points of the wave. In a sound wave, then, there is no displacement wherever the air molecules are at a normal density. The most displacement occurs wherever the molecules are the most crowded or least crowded.

Figure 3.3. Displacement


The amplitude of the wave is a measure of the displacement: how big is the change from no displacement to the peak of a wave? Are the waves on the lake two inches high or two feet? Are the air molecules bunched very tightly together, with very empty spaces between the waves, or are they barely more organized than they would be in their normal course of bouncing off of each other? Scientists measure the amplitude of sound waves in decibels. Leaves rustling in the wind are about 10 decibels; a jet engine is about 120 decibels.

Musicians call the loudness of a note its dynamic level. Forte (pronounced "FOR-tay") is a loud dynamic level; piano is soft. Dynamic levels don't correspond to a measured decibel level. An orchestra playing "fortissimo" (which basically means "even louder than forte") is going to be quite a bit louder than a string quartet playing "fortissimo". (See Dynamics for more of the terms that musicians use to talk about loudness.) Dynamics are more of a performance issue than a music theory issue, so amplitude doesn't need much discussion here.

Figure 3.4. Amplitude is Loudness

The size of a wave (how much it is "piled up" at the high points) is its amplitude. For sound waves, the bigger the amplitude, the louder the sound.

Wavelength, Frequency, and Pitch

The aspect of evenly-spaced sound waves that really affects music theory is the spacing between the waves, the distance between, for example, one high point and the next high point. This is the wavelength, and it affects the pitch of the sound; the closer together the waves are, the higher the tone sounds.

All sound waves are travelling at about the same speed - the speed of sound. So waves with a shorter wavelength arrive (at your ear, for example) more often (frequently) than longer waves. This aspect of a sound - how often a peak of a wave goes by, is called frequency by scientists and engineers. They measure it in hertz, which is how many peaks go by per second. People can hear sounds that range from about 20 to about 17,000 hertz.

Figure 3.5. Wavelength, Frequency, and Pitch

Since the sounds are travelling at about the same speed, the one with the shorter wavelength "waves" more frequently; it has a higher frequency, or pitch. In other words, it sounds higher.

The word that musicians use for frequency is pitch. The shorter the wavelength, the higher the frequency, and the higher the pitch, of the sound. In other words, short waves sound high; long waves sound low. Instead of measuring frequencies, musicians name the pitches that they use most often. They might call a note "middle C" or "second line G" or "the F sharp in the bass clef". (See Octaves and Diatonic Music and Tuning Systems for more on naming specific frequencies.) These notes have frequencies (Have you heard of the "A 440" that is used as a tuning note?), but the actual frequency of a middle C can vary a little from one orchestra, piano, or performance, to another, so musicians usually find it more useful to talk about note names.

Most musicians cannot name the frequencies of any notes other than the tuning A (440 hertz). The human ear can easily distinguish two pitches that are only one hertz apart when it hears them both, but it is the very rare musician who can hear specifically that a note is 442 hertz rather than 440. So why should we bother talking about frequency, when musicians usually don't? As we will see, the physics of sound waves - and especially frequency - affects the most basic aspects of music, including pitch, tuning, consonance and dissonance, harmony, and timbre.

Previous
Top Next
3.2 Standing Waves and Musical Instruments

© 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.357MBMemory Usage119msRequest 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" => "AfmBOorOrIcqoq2ZbTzWG9o--fn4t9cA3_zlA_XmSbnPnwmC2eEiJmPy" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:2 [ "68f777d662874437d2d3fbf9fc28a335" => "53aa6ade1c1fede41582790c94769956" "_fbp" => "fb...
$_SERVER
array:51 [ "REDIRECT_HTTP_AUTHORIZATION" => "" "REDIRECT_STATUS" => "200" "HTTP_AUTHORIZATION"...
session
array:3 [ "counter" => 7 "timer" => array:3 [ "start" => 1755076465 "last" => 1755076483...
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.83ms)
  • afterInitialise (3.92MB) (32.58ms)
  • afterRoute (2.21MB) (6.42ms)
  • beforeRenderComponent com_content (43.64KB) (383μs)
  • Before Access::preloadComponents (all components) (54.17KB) (596μs)
  • After Access::preloadComponents (all components) (136.69KB) (691μs)
  • Before Access::preloadPermissions (com_content) (424B) (12μs)
  • After Access::preloadPermissions (com_content) (120.2KB) (600μs)
  • Before Access::getAssetRules (id:239 name:com_content.article.93) (6.65KB) (16μs)
  • After Access::getAssetRules (id:239 name:com_content.article.93) (8.3KB) (64μs)
  • afterRenderComponent com_content (692.91KB) (14.85ms)
  • Before Access::getAssetRules (id:1 name:root.1) (5.17KB) (46μs)
  • After Access::getAssetRules (id:1 name:root.1) (6.48KB) (12μs)
  • Before Access::getAssetRules (id:8 name:com_content) (56.92KB) (754μs)
  • After Access::getAssetRules (id:8 name:com_content) (1.28KB) (5μs)
  • afterDispatch (11.9KB) (212μs)
  • beforeRenderRawModule mod_falang (FaLang Language Switcher) (2.15MB) (27.27ms)
  • afterRenderRawModule mod_falang (FaLang Language Switcher) (676.55KB) (11.84ms)
  • 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) (140μ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) (24μs)
  • afterRenderRawModule mod_custom (Footer) (928B) (20μs)
  • beforeRenderModule mod_custom (Footer) (704B) (1μs)
  • afterRenderModule mod_custom (Footer) (9.51KB) (743μs)
  • beforeRenderRawModule mod_astroid_menu (Understanding Basic Music Theory) (152B) (45μs)
  • afterRenderRawModule mod_astroid_menu (Understanding Basic Music Theory) (2.73MB) (5.88ms)
  • beforeRenderModule mod_astroid_menu (Understanding Basic Music Theory) (736B) (3μs)
  • afterRenderModule mod_astroid_menu (Understanding Basic Music Theory) (94.65KB) (103μs)
  • beforeRenderRawModule mod_booknavigate (Book Navigation) (4.29KB) (26μs)
  • afterRenderRawModule mod_booknavigate (Book Navigation) (4.94KB) (109μs)
  • beforeRenderModule mod_booknavigate (Book Navigation) (720B) (2μs)
  • afterRenderModule mod_booknavigate (Book Navigation) (3.38KB) (42μs)
  • beforeRenderRawModule mod_custom (Music Theory Course Copyright) (208B) (7μs)
  • afterRenderRawModule mod_custom (Music Theory Course Copyright) (1.05KB) (17μs)
  • beforeRenderModule mod_custom (Music Theory Course Copyright) (736B) (1μs)
  • afterRenderModule mod_custom (Music Theory Course Copyright) (3.22KB) (32μs)
  • afterRender (2.03MB) (9.4ms)
  • 1 x afterInitialise (3.92MB) (27.45%)
    32.58ms
    1 x beforeRenderRawModule mod_falang (FaLang Language Switcher) (2.15MB) (22.97%)
    27.27ms
    1 x afterRenderComponent com_content (692.91KB) (12.52%)
    14.85ms
    1 x afterRenderRawModule mod_falang (FaLang Language Switcher) (676.55KB) (9.98%)
    11.84ms
    1 x afterRender (2.03MB) (7.92%)
    9.40ms
    1 x afterRoute (2.21MB) (5.41%)
    6.42ms
    1 x afterRenderRawModule mod_astroid_menu (Understanding Basic Music Theory) (2.73MB) (4.96%)
    5.88ms
    1 x afterLoad (84.07KB) (1.54%)
    1.83ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (56.92KB) (0.64%)
    754μs
    1 x afterRenderModule mod_custom (Footer) (9.51KB) (0.63%)
    743μs
    1 x After Access::preloadComponents (all components) (136.69KB) (0.58%)
    691μs
    1 x After Access::preloadPermissions (com_content) (120.2KB) (0.51%)
    600μs
    1 x Before Access::preloadComponents (all components) (54.17KB) (0.5%)
    596μs
    1 x beforeRenderComponent com_content (43.64KB) (0.32%)
    383μs
    1 x afterDispatch (11.9KB) (0.18%)
    212μs
    1 x afterRenderRawModule mod_custom (Links to Privacy and Terms) (3.95KB) (0.12%)
    140μs
    1 x afterRenderRawModule mod_booknavigate (Book Navigation) (4.94KB) (0.09%)
    109μs
    1 x afterRenderModule mod_astroid_menu (Understanding Basic Music Theory) (94.65KB) (0.09%)
    103μs
    1 x afterRenderModule mod_falang (FaLang Language Switcher) (5.8KB) (0.06%)
    68μs
    1 x After Access::getAssetRules (id:239 name:com_content.article.93) (8.3KB) (0.05%)
    64μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (5.17KB) (0.04%)
    46μs
    1 x beforeRenderRawModule mod_astroid_menu (Understanding Basic Music Theory) (152B) (0.04%)
    45μs
    1 x afterRenderModule mod_booknavigate (Book Navigation) (3.38KB) (0.04%)
    42μs
    1 x afterRenderModule mod_custom (Links to Privacy and Terms) (2.78KB) (0.03%)
    40μs
    1 x afterRenderModule mod_custom (Music Theory Course Copyright) (3.22KB) (0.03%)
    32μs
    1 x beforeRenderRawModule mod_booknavigate (Book Navigation) (4.29KB) (0.02%)
    26μs
    1 x beforeRenderRawModule mod_custom (Footer) (744B) (0.02%)
    24μs
    1 x afterRenderRawModule mod_custom (Footer) (928B) (0.02%)
    20μs
    1 x afterRenderRawModule mod_custom (Music Theory Course Copyright) (1.05KB) (0.01%)
    17μs
    1 x Before Access::getAssetRules (id:239 name:com_content.article.93) (6.65KB) (0.01%)
    16μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.01%)
    12μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.01%)
    12μs
    1 x beforeRenderRawModule mod_custom (Links to Privacy and Terms) (3.5KB) (0.01%)
    9μ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_custom (Links to Privacy and Terms) (736B) (0%)
    2μs
    1 x beforeRenderModule mod_booknavigate (Book Navigation) (720B) (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 unique15.47ms3.39MB
  • select distinct reference_table from v12ai_falang_content109μs1016B/plugins/system/falangdriver/falang_database.php:224Copy
  • SELECT `params` FROM `v12ai_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'103μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_admintools_ipautoban`59μs656B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `ip` FROM `v12ai_admintools_ipblock`54μs776B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `source`,`dest`,`keepurlparams` FROM `v12ai_admintools_redirects` WHERE `published` = 1 ORDER BY `ordering` ASC64μs960B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `v12ai_menu` AS `m` LEFT JOIN `v12ai_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`1.71ms1.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.27ms1.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` = 176μ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` = 1131μ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)345μ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` = 0306μs5.48KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_content`409μs1.77KB/plugins/system/falangdriver/falang_database.php:330Copy
  • UPDATE `v12ai_content` SET `hits` = (`hits` + 1) WHERE `id` = '93'213μ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)318μs54.19KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT joomlatablename,tablepkID FROM `v12ai_falang_tableinfo`73μs1KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM v12ai_languages ORDER BY ordering91μs1.64KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_languages`276μ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 (93) AND `reference_table`= 'content'131μ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`220μ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`183μ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)143μ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`141μ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 ASC295μ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` = 040μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `language`,`id` FROM `v12ai_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 087μ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'63μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT `alias`,`catid` FROM v12ai_content WHERE `id` = :key30μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `alias`,`catid` FROM v12ai_content WHERE `id` = :key24μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `v12ai_content` AS `c` INNER JOIN `v12ai_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `v12ai_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `v12ai_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `v12ai_categories` AS `ca` ON `c2`.`catid` = `ca`.`id` AND `ca`.`extension` = :extension2 WHERE `c`.`id` = :id AND c2.access IN (1,5) AND c2.language != 'en-GB' AND (c2.publish_up IS NULL OR c2.publish_up <= '2025-08-13 09:14:44') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-08-13 09:14:44') AND c2.state = 175μ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'169μ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 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'145μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SHOW FULL COLUMNS FROM `v12ai_users`160μs1.58KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_users` WHERE `id` = :userid53μs3.16KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `g`.`id`,`g`.`title` FROM `v12ai_usergroups` AS `g` INNER JOIN `v12ai_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid55μ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`125μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`102μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v12ai_contentitem_tag_map` AS `m` INNER JOIN `v12ai_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)85μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`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`143μ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)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`110μ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 `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`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μ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μ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`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 `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)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`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`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)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`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`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μ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`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`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)86μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`106μs3.97KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `v12ai_categories` AS `s` INNER JOIN `v12ai_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`93μ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` = :id52μs1.38KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `v12ai_content` AS `a` INNER JOIN `v12ai_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `v12ai_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `v12ai_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `v12ai_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `v12ai_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)101μs54.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 (93) AND `reference_table`= 'content'59μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT alias FROM v12ai_content WHERE id = 9326μ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)90μs54.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 (93) AND `reference_table`= 'content'50μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 93 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'58μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT `alias` FROM `v12ai_content` WHERE id = '93'24μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 93 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'47μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 23 AND fc.language_id = 3 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'categories'49μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 204 AND fc.language_id = 3 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'50μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SHOW FULL COLUMNS FROM `v12ai_menu`164μs1.7KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '204'56μ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 (204) AND `reference_table`= 'menu'55μ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 = 204 AND p.client_id = 0 ORDER BY p.lft155μs19.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 20426μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 204 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` = '204'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 (204) 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='1' and jfc.reference_field='alias' WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 204 AND p.client_id = 0 ORDER BY p.lft194μ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)101μs54.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 (93) 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 = 93 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 = '93'28μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 93 AND fc.language_id = 2 AND fc.reference_field = 'alias' AND fc.published = 1 AND fc.reference_table = 'content'47μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 23 AND fc.language_id = 2 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 = 204 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` = '204'45μ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 (204) 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 = 204 AND p.client_id = 0 ORDER BY p.lft140μs19.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 20428μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 204 AND fc.language_id = 1 AND fc.reference_field = 'path' AND fc.published = 1 AND fc.reference_table = 'menu'49μs520B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_menu` WHERE `id` = '204'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 (204) 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='1' and jfc.reference_field='alias' WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 204 AND p.client_id = 0 ORDER BY p.lft184μ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)98μs54.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 (93) AND `reference_table`= 'content'54μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 93 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 = '93'24μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 93 AND fc.language_id = 4 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 = 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 = 204 AND fc.language_id = 4 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` = '204'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 (204) AND `reference_table`= 'menu'43μs688B/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT p.*, jfc.value as jfcvalue FROM v12ai_menu AS n, v12ai_menu AS p LEFT JOIN v12ai_falang_content as jfc ON jfc.reference_table='menu' AND jfc.reference_id=p.id AND jfc.language_id='4' and jfc.reference_field='alias' WHERE n.lft BETWEEN p.lft AND p.rgt AND n.id = 204 AND p.client_id = 0 ORDER BY p.lft139μs19.05KB/plugins/system/falangdriver/falang_database.php:325Copy
  • SELECT m.path FROM v12ai_menu m WHERE m.id = 20424μs536B/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT fc.value FROM v12ai_falang_content fc WHERE fc.reference_id = 204 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` = '204'39μ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 (204) 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 = 204 AND p.client_id = 0 ORDER BY p.lft189μ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.ordering57μs2.39KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM v12ai_hikashop_config90μs24.63KB/plugins/system/falangdriver/falang_database.php:330Copy
  • SET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));23μs0B/plugins/system/falangdriver/falang_database.php:133Copy
  • SELECT a.id FROM v12ai_menu AS a INNER JOIN `v12ai_menu_types` as b on a.menutype = b.menutype WHERE a.type='component' AND a.published=1 AND b.title IS NOT NULL AND a.access IN (1,5) AND a.client_id=0 AND a.link='index.php?option=com_hikashop&view=checkout&layout=show' AND a.language IN ('*', '', 'en-GB')249μ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')222μ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'74μ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` = 149μs1.37KBParams/plugins/system/falangdriver/falang_database.php:330Copy
  • SELECT * FROM `v12ai_schemaorg` WHERE `itemId` = :itemId AND `context` = :context40μ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μs54.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 (93) AND `reference_table`= 'content'56μ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