Who is Online

We have 51 guests and no members online

Radio Pioneer

My grandfather's principal interest, outside work, was radio experimentation and research.  

In the 1890's experiments based on James Clerk Maxwell's theory of electromagnetic radiation by Hertz, Tesla, Marconi and others demonstrated the practical transmission of radio waves but without a suitable amplifier they were limited to sending Morse code, using spark gaps to generate the necessary high frequencies.

Scientists at Edison's laboratory had identified thermionic emission, which became known as the Edison effect, but only as a nuisance that they thought was due to carbon atoms boiling off the heated element. 

Despite other advances in radio they failed to realise that it was actually electrons being emitted and hence to see it's potential (same pun - intended).

The English physicist John Ambrose Fleming realised that the thermionic emission was electrons - and could Thus,
provide a one way 'valve' directing the flow of electricity. In 1904 he patented the first vacuum-tube rectifier or thermionic valve also known as the Fleming valve.  Within a year a young American, Lee DeForest, realised that by placing 'grid' between the cathode and the anode he could regulate the flow of electric current through the valve by means of a control voltage applied to the grid. 

Thus, DeForest had invented, and in 1906 patented, the first triode: a device capable of electronic signal amplification. In early valve catalogues this quality is still called 'magnification'.

This device is still known as a valve (in England and Australia and so on) and as a vacuum tube or just 'tube' (in the US). 

 


Triode examples, showing the enormous technological development from 1918 (left) to the 1960s
The valves used in walkie-talkies and hearing aids got down to three centimetres long and the diameter of a pencil
Size reduction improved a number of performance characteristics and allowed much more compact chassis
but required much greater manufacturing precision
These were superseded by discrete transistors the size of a pea and then by the microchip and surface-mount devices 
(picture by RJB1 - via Wikimedia Commons)

 

The triode was probably the greatest invention of the early 20th century, surpassing even the contemporary Wright Brothers mastery of powered flight. The triode heralded the electronic age without which modern aircraft could not exist and it powered the first electronic computers that were an essential step to incredible scientific and engineering advances, including decoding our genome. 

Now electronic circuits could switch each other on and off in logic circuits or be made to oscillate indefinitely in a radio transmitter as the valve made up the losses due to power being absorbed by the aerial and its radiated transmission or magnify and transform the tiny electrical signals picked up by an aerial, until they were large and powerful enough to drive the voice coil of a booming loudspeaker.

AT&T purchased the DeForest patent and used it to make the first audio modulated radio broadcasts in the summer of 1913, transmitting realistic voice and music as we know it today, no longer restricted to a sequence of Morse Code dots and dashes.  The year before my grandparents were married modern Radio had been heard for the first time.

Initially Edison's carbon microphone had been inserted into the circuit to 'modulate' the amplitude of the signal, with voice or music, providing the first amplitude (or audio) modulated (AM) broadcasts.   But it was quickly realised that suitably designed valves could be used to amplify the tiny signals from higher quality microphones that could be connected by wire to the transmitting equipment. Not only that but in addition to driving loud speakers they could drive other devices, like the cutter that made the grooves in a record.

As in aircraft technology and many other fields major advances were made in radio valve technology and radio transmission during the First World War.  Soon both planes and radio messages were circling the globe.

Soon after moving in my grandfather created a workshop in the basement their home at Queens Road, Monkseaton, where he experimented with radio designs and transmission.  To facilitate his investigations, after the War was over, he had constructed the largest privately owned radio mast in the North of England, in their front garden.

Some time after we had settled in Australia my father was interviewing factory workers and one interviewee announced that he knew the name McKie because he had helped to build his father's radio mast.  It was quite famous.

The first public news and entertainment broadcast in Britain took place on November 14th 1922 from a 1.5kW medium wave transmitter broadcasting from the top of Marconi House in London.

So, my grandfather built a 12 valve receiver on which the family and friends could gather-round and listen to 'London Calling', the first entertainment radio and the beginning of the BBC, a considerable novelty.  It was like the beginning of television. 

His set must have been impressively large, as valves were similar in size to incandescent light bulbs.  It would have used a lot of power for that time, and generated a lot of heat, around that of an electric room heater.  All the valves would have been triodes. Multi-grid valves were not yet commercially available. 

I have made a guess at the circuit based on contemporary records and designs my father built and told me about. 

The audio section is probably easiest to guess at because I know he wound his own output transformers and the business he worked in wound commercial motors and dynamos. This suggests a push-pull design requiring five triodes and a purpose-wound output transformer driving the loud speaker. Proper balance is extremely critical to avoid distortion and such transformers weren't an off-the-shelf item back then.  So, it's not surprising that my father in turn often wound his own coils and transformers and I grew up with dozens of rolls of different gauge winding wire in a kitchen cupboard.

I'm assuming that JWL McKie's famous 'big receiver' was a superheterodyne design to improve sensitivity and selectivity.  The idea of intermediate frequency is attributed to Armstrong in 1918.  The concept was in the literature and use by radio enthusiasts as early as 1920.  My grandfather would certainly have experimented with this technology and his son, my father designed and built a wide range of devices using the same concept.  But it was difficult to implement with triodes and was very fussy back then.  It soon became commonplace after the invention of multi-grid and multi-element valves and became the dominant radio and television receiver technology from the 1930' to the present day. 

Early triode superheterodyne designs had a separate local oscillator and mixer.  A typical design would account for a further six valves with three IF stages.  The twelfth valve may have been initial RF amplification.  I'm assuming that he was using a DC mains supply directly for the HT rail and put the heaters in series, for reasons that will be obvious later.

It certainly would have been quite a wireless.

My grandfather instilled a love of research in my father who was encouraged to help in the workshop, to make his own crystal sets to listen to broadcasts and to perform other small experiments, like making his own lead sulphide crystals.

While melting lead one day my father used a soldered can so that the lead ran out through the soldered seam and scarred his foot.  He would show me the scar and tell me to be careful not the make the same mistake when melting lead.  He was around six or seven at the time of the accident. There was no suggestion that I should refrain from melting lead - but avoid the fumes and wash your hands before eating.

My father, in turn, helped me make my first crystal set, showing me how to neatly wind my coil.  The variable tuning condenser came from an old radio and I used my pocket money to buy a pair of earphones, my pride and joy.

Before suggesting the project, he'd raised my interest by giving me a mysterious device that turned out to be a cat's whisker holder, together with a (commercial) crystal of lead sulphide or perhaps one of the other suitable crystals to put into its crystal holder.  It came from 'Radio House', a hobby-shop in Sydney long since gone, and it looked exactly like this image I found on the net, like seeing a picture of an old friend:

 

crystal detector 01
Cat's Whisker crystal-detector
To the right is a housing that holds a suitable metallic crystal like lead sulphide
To the left is a bar with a ball socket that mounts the fine wire or cat's whisker
The whisker is moved over the crystal until a diode detector forms, heralded by hissing in the earphones.
 

I took my crystal set to school in fourth class for 'show and tell' but it refused to work having been shoved into a box for transport.  I was mocked by our teacher who said that if I spent as much time leaning my spelling list as I did on all this nonsense, I would do much better at school.

Interestingly if you put a battery and shunt across the cat's whisker junction it would emit a dull light in the dark, which might have been a little arc.  But we now know to be a light emitting diode or LED.  No one thought much of it at the time and it demonstrates that it takes an enquiring mind to look beyond the obvious.

Years ago, my mother wrote:  Stephen's personal memory of his father is of love and admiration for a man who always had time for him.

Thinking back, I could say the same thing about my father.

In the early 1920's amplification of electronic signals from a passive, but higher quality, microphone, using the new triodes and later, pentodes, brought in the Jazz Age and allowed a new style of singers, the crooners, to sing into the new microphones.

The same technology enabled the Public Address (PA) system that US President Woodrow Wilson used in 1919 to address a crowd of 75,000 in California.  Numerous innovations in the first years of the 1920's soon resulted in public radio transmission for entertainment, information and propaganda.

By the late 1920's President Wilson's feeble 25 W PA system was surpassed many times over with systems driving up to 200 loudspeaker horns.

Thus, the rise of Hitler and Mussolini was in no small measure due to the invention of the triode valve and then the pentode.  All the result of the evolution of the thermionic valve (vacuum tube) from a humble electric light bulb.

My grandfather did not invent a new type of valve.  Pentodes were not invented until 1926.  But he made pioneering advances in circuit design that my father was proud of and spoke about. 

Numerous other radio stations quickly followed the first amateur transmissions, addressing this audience with local content, including briefly my grandfather's own broadcasts. It was a bit like the 'dot com' explosion, when websites proliferated.

The Geneva Frequency Plan of 1926 put an end to this radio proliferation.  But by1926 my Grandfather no longer cared, he was dead.

 

 

No comments

Travel

In the footsteps of Marco Polo

 

 

 

 

Travels in Central Asia

 

In June 2018 we travelled to China before joining an organised tour in Central Asia that, except for a sojourn in the mountains of Tajikistan, followed in the footsteps of Marco Polo along the Great Silk Road. 

Read more: In the footsteps of Marco Polo

Fiction, Recollections & News

A Discourse on History

 

 

 

On Australia Day 2011 again we hear the calls: Change the Flag; become a Republic; reparations for the White Invasion...

There are strong arguments for progress in each of these areas but as the following article discusses we first need to ensure that the changes that must be made are indeed progress; that we don't sacrifice that which has been achieved already.

Read more: A Discourse on History

Opinions and Philosophy

Frederick Sanger - a life well spent

 

I have reached a point in my life when the death of a valued colleague seems to be a monthly occurrence.  I remember my parents saying the same thing. 

We go thought phases.  First it is the arrival of adulthood when all one's friends are reaching 21 or 18, as the case may be.  Then they are all getting married.  Then the babies arrive.  Then it is our children's turn and we see them entering the same cycle.  And now the Grim Reaper appears regularly. 

As I have repeatedly affirmed elsewhere on this website, each of us has a profound impact on the future.  Often without our awareness or deliberate choice, we are by commission or omission, continuously taking actions that change our life's path and therefore the lives of others.  Thus our every decision has an impact on the very existence of those yet to be born. 

Read more: Frederick Sanger - a life well spent

Terms of Use

Terms of Use                                                                    Copyright

6.23MBMemory Usage203msRequest Duration
Joomla! Version4.4.13
PHP Version8.1.32
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
5.7.44-cll-lve
Collation
utf8_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:1 [ "start" => "7" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:54 [ "PHPRC" => "/etc/" "PHP_FCGI_CHILDREN" => "0" "PATH" => "/sbin:/usr/sbin:/bin:/usr/...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1746318103 "last" => 1746318103...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (529.34KB) (5.72ms)
  • afterInitialise (1.26MB) (25.81ms)
  • afterRoute (357.13KB) (8.65ms)
  • beforeRenderComponent com_content (28.64KB) (1.26ms)
  • Before Access::preloadComponents (all components) (35.21KB) (1.59ms)
  • After Access::preloadComponents (all components) (123.43KB) (702μs)
  • Before Access::preloadPermissions (com_content) (2.76KB) (18μs)
  • After Access::preloadPermissions (com_content) (186.05KB) (691μs)
  • Before Access::getAssetRules (id:318 name:com_content.article.173) (18.8KB) (29μs)
  • After Access::getAssetRules (id:318 name:com_content.article.173) (8.47KB) (186μs)
  • Before Access::getAssetRules (id:450 name:com_engage) (1.58MB) (65.18ms)
  • After Access::getAssetRules (id:450 name:com_engage) (6.95KB) (54μs)
  • afterRenderComponent com_content (277.24KB) (17.92ms)
  • Before Access::getAssetRules (id:8 name:com_content) (22.23KB) (1.42ms)
  • After Access::getAssetRules (id:8 name:com_content) (6.95KB) (44μs)
  • afterDispatch (12.46KB) (950μs)
  • beforeRenderRawModule mod_finder (Search) (43.49KB) (1.23ms)
  • afterRenderRawModule mod_finder (Search) (74.9KB) (4.03ms)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (720B) (45μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (13.27KB) (1.15ms)
  • beforeRenderRawModule mod_whosonline (Who is Online) (336B) (27μs)
  • afterRenderRawModule mod_whosonline (Who is Online) (14.37KB) (875μs)
  • beforeRenderRawModule mod_articles_news (Travel) (4.72KB) (57μs)
  • afterRenderRawModule mod_articles_news (Travel) (325.15KB) (21.16ms)
  • beforeRenderRawModule mod_articles_news (Fiction, Recollections & News) (80B) (48μs)
  • afterRenderRawModule mod_articles_news (Fiction, Recollections & News) (200.51KB) (14.68ms)
  • beforeRenderRawModule mod_articles_news (Opinions and Philosophy) (1.33KB) (46μs)
  • afterRenderRawModule mod_articles_news (Opinions and Philosophy) (297.05KB) (17.01ms)
  • Before Access::getAssetRules (id:16 name:com_menus) (8.24KB) (601μs)
  • After Access::getAssetRules (id:16 name:com_menus) (6.95KB) (64μs)
  • beforeRenderModule mod_articles_news (Travel) (8.62KB) (329μs)
  • afterRenderModule mod_articles_news (Travel) (3.71KB) (212μs)
  • beforeRenderModule mod_articles_news (Fiction, Recollections & News) (984B) (51μs)
  • afterRenderModule mod_articles_news (Fiction, Recollections & News) (5.71KB) (126μs)
  • beforeRenderModule mod_articles_news (Opinions and Philosophy) (1.54KB) (51μs)
  • afterRenderModule mod_articles_news (Opinions and Philosophy) (3.96KB) (130μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (200B) (178μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.95KB) (158μs)
  • beforeRenderModule mod_whosonline (Who is Online) (728B) (36μs)
  • afterRenderModule mod_whosonline (Who is Online) (2.26KB) (134μs)
  • beforeRenderModule mod_finder (Search) (624B) (79μs)
  • afterRenderModule mod_finder (Search) (3.26KB) (163μs)
  • afterRender (290.43KB) (9.28ms)
  • 1 x Before Access::getAssetRules (id:450 name:com_engage) (1.58MB) (32.13%)
    65.18ms
    1 x afterInitialise (1.26MB) (12.72%)
    25.81ms
    1 x afterRenderRawModule mod_articles_news (Travel) (325.15KB) (10.43%)
    21.16ms
    1 x afterRenderComponent com_content (277.24KB) (8.83%)
    17.92ms
    1 x afterRenderRawModule mod_articles_news (Opinions and Philosophy) (297.05KB) (8.38%)
    17.01ms
    1 x afterRenderRawModule mod_articles_news (Fiction, Recollections & News) (200.51KB) (7.24%)
    14.68ms
    1 x afterRender (290.43KB) (4.57%)
    9.28ms
    1 x afterRoute (357.13KB) (4.27%)
    8.65ms
    1 x afterLoad (529.34KB) (2.82%)
    5.72ms
    1 x afterRenderRawModule mod_finder (Search) (74.9KB) (1.99%)
    4.03ms
    1 x Before Access::preloadComponents (all components) (35.21KB) (0.78%)
    1.59ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (22.23KB) (0.7%)
    1.42ms
    1 x beforeRenderComponent com_content (28.64KB) (0.62%)
    1.26ms
    1 x beforeRenderRawModule mod_finder (Search) (43.49KB) (0.61%)
    1.23ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (13.27KB) (0.57%)
    1.15ms
    1 x afterDispatch (12.46KB) (0.47%)
    950μs
    1 x afterRenderRawModule mod_whosonline (Who is Online) (14.37KB) (0.43%)
    875μs
    1 x After Access::preloadComponents (all components) (123.43KB) (0.35%)
    702μs
    1 x After Access::preloadPermissions (com_content) (186.05KB) (0.34%)
    691μs
    1 x Before Access::getAssetRules (id:16 name:com_menus) (8.24KB) (0.3%)
    601μs
    1 x beforeRenderModule mod_articles_news (Travel) (8.62KB) (0.16%)
    329μs
    1 x afterRenderModule mod_articles_news (Travel) (3.71KB) (0.1%)
    212μs
    1 x After Access::getAssetRules (id:318 name:com_content.article.173) (8.47KB) (0.09%)
    186μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (200B) (0.09%)
    178μs
    1 x afterRenderModule mod_finder (Search) (3.26KB) (0.08%)
    163μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.95KB) (0.08%)
    158μs
    1 x afterRenderModule mod_whosonline (Who is Online) (2.26KB) (0.07%)
    134μs
    1 x afterRenderModule mod_articles_news (Opinions and Philosophy) (3.96KB) (0.06%)
    130μs
    1 x afterRenderModule mod_articles_news (Fiction, Recollections & News) (5.71KB) (0.06%)
    126μs
    1 x beforeRenderModule mod_finder (Search) (624B) (0.04%)
    79μs
    1 x After Access::getAssetRules (id:16 name:com_menus) (6.95KB) (0.03%)
    64μs
    1 x beforeRenderRawModule mod_articles_news (Travel) (4.72KB) (0.03%)
    57μs
    1 x After Access::getAssetRules (id:450 name:com_engage) (6.95KB) (0.03%)
    54μs
    1 x beforeRenderModule mod_articles_news (Fiction, Recollections & News) (984B) (0.03%)
    51μs
    1 x beforeRenderModule mod_articles_news (Opinions and Philosophy) (1.54KB) (0.03%)
    51μs
    1 x beforeRenderRawModule mod_articles_news (Fiction, Recollections & News) (80B) (0.02%)
    48μs
    1 x beforeRenderRawModule mod_articles_news (Opinions and Philosophy) (1.33KB) (0.02%)
    46μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (720B) (0.02%)
    45μs
    1 x After Access::getAssetRules (id:8 name:com_content) (6.95KB) (0.02%)
    44μs
    1 x beforeRenderModule mod_whosonline (Who is Online) (728B) (0.02%)
    36μs
    1 x Before Access::getAssetRules (id:318 name:com_content.article.173) (18.8KB) (0.01%)
    29μs
    1 x beforeRenderRawModule mod_whosonline (Who is Online) (336B) (0.01%)
    27μs
    1 x Before Access::preloadPermissions (com_content) (2.76KB) (0.01%)
    18μs
105 statements were executed, 57 of which were duplicates, 48 unique47.68ms1.89MB
  • SELECT @@SESSION.sql_mode;95μs1.57KB/libraries/src/Session/MetadataManager.php:184Copy
  • SELECT `session_id` FROM `ttl_session` WHERE `session_id` = :session_id LIMIT 1208μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `ttl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)236μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `ttl_viewlevels`71μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `ttl_usergroups` AS `a` LEFT JOIN `ttl_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest77μs2.27KBParams/libraries/src/Access/Access.php:868Copy
  • 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 `ttl_categories` AS `s` INNER JOIN `ttl_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray1,:preparedArray2)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`627μs13.19KBParams/libraries/src/Categories/Categories.php:375Copy
  • SHOW TABLES665μs2.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ttl_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)170μs8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `ttl_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0131μs27.05KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `ttl_content`540μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `ttl_content` SET `hits` = (`hits` + 1) WHERE `id` = '173'1.18ms48B/libraries/src/Table/Table.php:1325Copy
  • 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 `ttl_content` AS `a` INNER JOIN `ttl_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ttl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ttl_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `ttl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ttl_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)788μs592.69KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `ttl_categories` AS `s` INNER JOIN `ttl_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`158μs5.25KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `ttl_contentitem_tag_map` AS `m` INNER JOIN `ttl_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)396μs5.22KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `extension_id`,`name`,`enabled`,`params` FROM ttl_extensions WHERE `type` = 'plugin' AND `element` = 'osembed' AND `folder` = 'content'109μs1KB/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170Copy
  • 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 `ttl_categories` AS `s` INNER JOIN `ttl_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`199μs5.25KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 ttl_fields AS a LEFT JOIN `ttl_languages` AS l ON l.lang_code = a.language LEFT JOIN ttl_users AS uc ON uc.id=a.checked_out LEFT JOIN ttl_viewlevels AS ag ON ag.id = a.access LEFT JOIN ttl_users AS ua ON ua.id = a.created_user_id LEFT JOIN ttl_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ttl_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,:preparedArray3,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) 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 ASC985μs8.56KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `ttl_content` AS `a` LEFT JOIN `ttl_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) AND `a`.`language` IN (:preparedArray3,:preparedArray4) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC892μs2.44KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SHOW FULL COLUMNS FROM `ttl_users`463μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `ttl_users` WHERE `id` = :userid149μs4.41KBParams/libraries/src/Table/User.php:104Copy
  • SELECT `g`.`id`,`g`.`title` FROM `ttl_usergroups` AS `g` INNER JOIN `ttl_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid111μs1.7KBParams/libraries/src/Table/User.php:132Copy
  • SHOW FULL COLUMNS FROM `ttl_categories`564μs2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '33'332μs20.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)291μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)121μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` FROM `ttl_categories` AS `c` INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1 WHERE `c`.`id` = :id AND `c`.`extension` = :extension3408μs1.73KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '54'321μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)256μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)201μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` FROM `ttl_categories` AS `c` INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1 WHERE `c`.`id` = :id AND `c`.`extension` = :extension3504μs1.73KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '46'249μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)177μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)159μs12.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` FROM `ttl_categories` AS `c` INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1 WHERE `c`.`id` = :id AND `c`.`extension` = :extension3204μs1.73KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '1'231μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)264μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)177μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` FROM `ttl_categories` AS `c` INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1 WHERE `c`.`id` = :id AND `c`.`extension` = :extension3153μs1.73KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `c`.`id`,`c`.`parent_id` FROM `ttl_engage_comments` AS `c` LEFT JOIN `ttl_users` AS `u` ON `u`.`id` = `c`.`created_by` LEFT JOIN `ttl_content` AS `a` ON `a`.`asset_id` = `c`.`asset_id` LEFT JOIN `ttl_categories` AS `cat` ON `cat`.`id` = `a`.`catid` WHERE `c`.`asset_id` = :asset_id AND `c`.`enabled` = :enabled ORDER BY `c`.`created` DESC, `c`.`id` DESC417μs1.69KBParams/administrator/components/com_engage/src/Model/CommentsModel.php:220Copy
  • SELECT COUNT(*) FROM `ttl_engage_comments` AS `c` LEFT JOIN `ttl_users` AS `u` ON `u`.`id` = `c`.`created_by` LEFT JOIN `ttl_content` AS `a` ON `a`.`asset_id` = `c`.`asset_id` LEFT JOIN `ttl_categories` AS `cat` ON `cat`.`id` = `a`.`catid` WHERE `c`.`asset_id` = :asset_id AND `c`.`enabled` = :enabled207μs2.45KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:199Copy
  • SELECT `alias` FROM `ttl_content` WHERE `id` = :id163μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ttl_content` WHERE `id` = :id74μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `ttl_categories` AS `s` INNER JOIN `ttl_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`152μs5.25KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `language`,`id` FROM `ttl_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 078μs912B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT `alias` FROM `ttl_content` WHERE `id` = :id78μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ttl_content` WHERE `id` = :id72μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', `ca`.`id`, `ca`.`alias`) AS `catid` FROM `ttl_content` AS `c` INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `ttl_content` AS `c2` ON `a2`.`id` = `c2`.`id` INNER JOIN `ttl_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-05-04 00:21:43') AND (c2.publish_down IS NULL OR c2.publish_down >= '2025-05-04 00:21:43') AND c2.state = 1429μs1.78KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT `name`,`element` FROM `ttl_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 173μs992B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `ttl_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)86μs1000B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT guest, client_id FROM ttl_session WHERE client_id = 0210μs1.75KB/modules/mod_whosonline/src/Helper/WhosonlineHelper.php:51Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `ttl_content` AS `a` LEFT JOIN `ttl_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ttl_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `ttl_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `ttl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ttl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ttl_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` <> :articleId AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13) 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 (:preparedArray14,:preparedArray15) ORDER BY RAND() ASC LIMIT 19.76ms875.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `ttl_categories` AS `s` INNER JOIN `ttl_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`168μs5.23KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 ttl_fields AS a LEFT JOIN `ttl_languages` AS l ON l.lang_code = a.language LEFT JOIN ttl_users AS uc ON uc.id=a.checked_out LEFT JOIN ttl_viewlevels AS ag ON ag.id = a.access LEFT JOIN ttl_users AS ua ON ua.id = a.created_user_id LEFT JOIN ttl_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) 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 ASC151μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `ttl_categories` AS `s` INNER JOIN `ttl_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`133μs5.23KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 ttl_fields AS a LEFT JOIN `ttl_languages` AS l ON l.lang_code = a.language LEFT JOIN ttl_users AS uc ON uc.id=a.checked_out LEFT JOIN ttl_viewlevels AS ag ON ag.id = a.access LEFT JOIN ttl_users AS ua ON ua.id = a.created_user_id LEFT JOIN ttl_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ttl_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,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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 ASC749μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `asset_id` FROM `ttl_content` WHERE `id` = '217'224μs856B/plugins/content/engage/src/Extension/Engage.php:691Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '38'218μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)191μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)79μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` FROM `ttl_categories` AS `c` INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1 WHERE `c`.`id` = :id AND `c`.`extension` = :extension3235μs1.73KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '48'116μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)81μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)78μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` FROM `ttl_categories` AS `c` INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1 WHERE `c`.`id` = :id AND `c`.`extension` = :extension388μs1.73KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '1'108μs12.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)81μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)78μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `ttl_content` AS `a` LEFT JOIN `ttl_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ttl_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `ttl_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `ttl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ttl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ttl_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` <> :articleId AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9) 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 (:preparedArray10,:preparedArray11) ORDER BY RAND() ASC LIMIT 17.58ms97.67KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `asset_id` FROM `ttl_content` WHERE `id` = '54'188μs856B/plugins/content/engage/src/Extension/Engage.php:691Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '33'108μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)395μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)80μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '54'116μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)79μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)77μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '46'115μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)80μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)78μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '1'110μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)81μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)78μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `ttl_content` AS `a` LEFT JOIN `ttl_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `ttl_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `ttl_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `ttl_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `ttl_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `ttl_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` <> :articleId AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15) 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 (:preparedArray16,:preparedArray17) ORDER BY RAND() ASC LIMIT 16.43ms27.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `ttl_categories` AS `s` INNER JOIN `ttl_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`149μs5.25KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `ttl_categories` AS `s` INNER JOIN `ttl_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`131μs5.25KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 ttl_fields AS a LEFT JOIN `ttl_languages` AS l ON l.lang_code = a.language LEFT JOIN ttl_users AS uc ON uc.id=a.checked_out LEFT JOIN ttl_viewlevels AS ag ON ag.id = a.access LEFT JOIN ttl_users AS ua ON ua.id = a.created_user_id LEFT JOIN ttl_fields_groups AS g ON g.id = a.group_id LEFT JOIN `ttl_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,:preparedArray3,:preparedArray4)) AND `a`.`access` IN (:preparedArray5,:preparedArray6)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray7,:preparedArray8)) 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 ASC666μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `asset_id` FROM `ttl_content` WHERE `id` = '143'144μs856B/plugins/content/engage/src/Extension/Engage.php:691Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '9'215μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)188μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)79μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id` FROM `ttl_categories` AS `c` INNER JOIN `ttl_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context INNER JOIN `ttl_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `ttl_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1 WHERE `c`.`id` = :id AND `c`.`extension` = :extension3233μs1.73KBParams/libraries/src/Language/Associations.php:145Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '54'108μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)82μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)77μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '46'112μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)81μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)91μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT * FROM `ttl_categories` WHERE `id` = '1'179μs4.25KB/libraries/src/Table/Table.php:755Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)123μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `t`.`id` FROM `ttl_tags` AS `t` INNER JOIN `ttl_contentitem_tag_map` AS `m` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :prefix AND `m`.`content_item_id` IN (:preparedArray1)106μs1.63KBParams/libraries/src/Helper/TagsHelper.php:503Copy
  • SELECT `alias` FROM `ttl_content` WHERE `id` = :id116μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `ttl_content` WHERE `id` = :id131μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `ttl_scheduler_tasks` AS `a` WHERE `a`.`state` = 1328μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SHOW TABLES971μs2.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • 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 `ttl_categories` AS `s` INNER JOIN `ttl_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`188μs5.25KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `ttl_categories` AS `s` INNER JOIN `ttl_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`138μs5.25KBParams/libraries/src/Categories/Categories.php:375Copy
  • infoakeeba.runpluginstrait - Event "onComEngageDispatcherBeforeDispatch" resolved to class Joomla\Event\...
  • infoakeeba.runpluginstrait - Event "onComEngageCommentsControllerBeforeExecute" resolved to class Joomla...
  • infoakeeba.runpluginstrait - Event "onComEngageCommentsControllerBeforeMain" resolved to class Joomla\Ev...
  • infoakeeba.runpluginstrait - Event "onAkeebaEngageGetAssetMeta" resolved to class Joomla\Event\Event -- ...
  • infoakeeba.runpluginstrait - Event "onComEngageCommentsControllerAfterMain" resolved to class Joomla\Eve...
  • infoakeeba.runpluginstrait - Event "onComEngageCommentsControllerAfterExecute" resolved to class Joomla\...
  • infoakeeba.runpluginstrait - Event "onComEngageDispatcherAfterDispatch" resolved to class Joomla\Event\E...