Concerto Barocco - Associazione Sicut Lilium

Domenica 29 ottobre 2017 
ore 16:00 
Busca (CN), Chiesa M. V. Assunta 

gruppo vocale "Ensemble del Giglio"
Livio Cavallo, Maestro del Coro

ensemble barocco "Accademia Eridana"

Direttore: Alessandro Quarta

 

Concerto di musica barocca per festeggiare i Trecento anni della fondazione della Parrocchia di Maria Vergine Assunta in Busca (CN).

Ospite d'eccezione il Maestro Alessandro Quarta che dirigerà l'Ensemble del Giglio (maestro del coro Livio Cavallo) e l'ensemble barocco "Accademia Eridana" del violinista buschese Bruno Raspini.

In programma brani legati al Piemonte, alla Diocesi, al periodo storico ed all'anno 1717: verranno eseguiti brani vocali e strumentali di A. Vivaldi, Isabella Leonarda, G. Ancina, F. Soto, G. Somis, J. Stamiz ed anche C. Monteverdi e F. Couperin.

Un programma brillante ed entusiasmante appositamente approntato per celebrare l'importante anniversario, i cui festeggiamenti prevedono, oltre a questo concerto, anche una mostra di dipinti, sculture, paramenti ed ostensori che sarà inaugurata il 7 ottobre, ore 16:00.

Legato a questo concerto, sabato 28 ottobre, ore 16:30-20:30, si terrà un Laboratorio di Musica Barocca ad ingresso libero: Laboratorio Barocco.

 

Ingresso libero e gratuito

 

L'evento su FaceBook  -  Seguici su FaceBook


Prove aperte in Beinette, Salone Polivalente "A. Olivetti":

ven. 27/10, h19:30-23:00
sab. 28/10, h10:00-12:30 / 14:00-20:30
dom. 29/10, h10:30-12:30

joomplu:363Alessandro Quarta, direttore e compositore, svolge attività concertistica con particolare attenzione al repertorio vocale Rinascimentale e Barocco; è fondatore e direttore dell’ensemble vocale e strumentale Concerto Romano con il quale si dedica principalmente al repertorio romano (e più in generale italiano) dei sec. XVI, XVII e XVIII.

Con il Concerto Romano ha inciso tre CD per l’etichetta Christophorus; il secondo, “Sacred music for the Poor”, è stato nominato fra i progetti discografici più interessanti del 2014 dalla giuria del Preis der Deutschen Schallplattenkritik ed è vincitore del Prix Caecilia 2015.
L’ultimo CD "La Sete di Christo" di Bernardo Pasquini ha ottenuto il Diapason d’or nel 2016. Dal 2007 al 2012 ha ricoperto la carica di maestro di cappella della Insigne Cappella Musicale del Pantheon ed è attualmente maestro nella Chiesa di S. Lucia al Gonfalone a Roma. Nel 2016 è fra i direttori ospiti dell’Orchestra barocca nazionale dei Conservatori italiani.
Dal 2007 è docente di canto madrigalistico presso i corsi internazionali di musica antica della FIMA (Fondazione Italiana per la Musica Antica), ove dal 2013 tiene anche un master class sull’oratorio romano del ‘600.
Dal 2015 figura fra i conduttori della trasmissione musicale Radio3-suite in onda sulla Rai-radio3.


Registrazioni dal vivo del concerto
(28 ottobre 2017, Busca, Chiesa Parrocchiale M.V. Assunta)


Associazione

Coro Sicut Lilium

Ensemble del Giglio

Sentieri di Musica

Iscrizione alla Mailing-list

* campo necessario
 

Piccola Scuola di Musica

7.212MBMemory Usage432msRequest Duration
Joomla! Version4.4.12
PHP Version8.3.19
Identityguest
Response200
Templatepurity_iii
Database
Server
mysql
Version
10.6.21-MariaDB-cll-lve-log
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:39 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743744408 "last" => 1743744408...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.94KB) (5.11ms)
  • afterInitialise (1.2MB) (31.78ms)
  • afterRoute (618.5KB) (15.82ms)
  • beforeRenderComponent com_content (52.57KB) (2.61ms)
  • Before Access::preloadComponents (all components) (35.94KB) (1.13ms)
  • After Access::preloadComponents (all components) (126.01KB) (1.85ms)
  • Before Access::preloadPermissions (com_content) (1.73KB) (54μs)
  • After Access::preloadPermissions (com_content) (96.88KB) (2.09ms)
  • Before Access::getAssetRules (id:594 name:com_content.article.97) (6.65KB) (27μs)
  • After Access::getAssetRules (id:594 name:com_content.article.97) (7.47KB) (187μs)
  • Before Access::getAssetRules (id:1 name:root.1) (911.55KB) (45.51ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.02KB) (50μs)
  • Before Access::getAssetRules (id:218 name:com_jdownloads) (1.48KB) (79μs)
  • After Access::getAssetRules (id:218 name:com_jdownloads) (6.53KB) (34μs)
  • Before Access::preloadPermissions (com_jdownloads) (7.7KB) (103μs)
  • After Access::preloadPermissions (com_jdownloads) (38.84KB) (1.28ms)
  • Before Access::getAssetRules (id:611 name:com_jdownloads.download.8) (680B) (23μs)
  • After Access::getAssetRules (id:611 name:com_jdownloads.download.8) (1.92KB) (13μs)
  • Before Access::getAssetRules (id:613 name:com_jdownloads.download.10) (322.08KB) (34.1ms)
  • After Access::getAssetRules (id:613 name:com_jdownloads.download.10) (1.3KB) (26μs)
  • Before Access::getAssetRules (id:609 name:com_jdownloads.download.6) (79.67KB) (7.7ms)
  • After Access::getAssetRules (id:609 name:com_jdownloads.download.6) (1.3KB) (22μs)
  • Before Access::getAssetRules (id:614 name:com_jdownloads.download.11) (94.1KB) (8.51ms)
  • After Access::getAssetRules (id:614 name:com_jdownloads.download.11) (1.3KB) (20μs)
  • Before Access::getAssetRules (id:617 name:com_jdownloads.download.14) (80.2KB) (7.17ms)
  • After Access::getAssetRules (id:617 name:com_jdownloads.download.14) (1.3KB) (18μs)
  • Before Access::getAssetRules (id:619 name:com_jdownloads.download.16) (79.85KB) (7.17ms)
  • After Access::getAssetRules (id:619 name:com_jdownloads.download.16) (1.61KB) (18μs)
  • Before Access::getAssetRules (id:610 name:com_jdownloads.download.7) (79.23KB) (6.99ms)
  • After Access::getAssetRules (id:610 name:com_jdownloads.download.7) (1.3KB) (17μs)
  • Before Access::getAssetRules (id:607 name:com_jdownloads.download.4) (83.16KB) (6.96ms)
  • After Access::getAssetRules (id:607 name:com_jdownloads.download.4) (1.3KB) (16μs)
  • Before Access::getAssetRules (id:612 name:com_jdownloads.download.9) (79.38KB) (7.14ms)
  • After Access::getAssetRules (id:612 name:com_jdownloads.download.9) (2.55KB) (18μs)
  • Before Access::getAssetRules (id:608 name:com_jdownloads.download.5) (79.16KB) (9.28ms)
  • After Access::getAssetRules (id:608 name:com_jdownloads.download.5) (1.3KB) (20μs)
  • Before Access::getAssetRules (id:615 name:com_jdownloads.download.12) (79.26KB) (8.12ms)
  • After Access::getAssetRules (id:615 name:com_jdownloads.download.12) (1.3KB) (19μs)
  • Before Access::getAssetRules (id:616 name:com_jdownloads.download.13) (78.98KB) (7.91ms)
  • After Access::getAssetRules (id:616 name:com_jdownloads.download.13) (1.3KB) (17μs)
  • Before Access::getAssetRules (id:618 name:com_jdownloads.download.15) (78.76KB) (7.31ms)
  • After Access::getAssetRules (id:618 name:com_jdownloads.download.15) (1.3KB) (16μs)
  • afterRenderComponent com_content (238.69KB) (18.22ms)
  • afterDispatch (16.13KB) (1.19ms)
  • beforeRenderModule mod_articles_category (Sentieri di Musica) (54.52KB) (66.12ms)
  • afterRenderRawModule mod_articles_category (Sentieri di Musica) (251.82KB) (16.91ms)
  • beforeRenderModule mod_articles_category (Sentieri di Musica) (720B) (14μs)
  • afterRenderModule mod_articles_category (Sentieri di Musica) (2.41KB) (385μs)
  • beforeRenderModule mod_custom (Iscrizione alla Mailing-list) (9.72KB) (45μs)
  • afterRenderRawModule mod_custom (Iscrizione alla Mailing-list) (4.42KB) (843μs)
  • beforeRenderModule mod_custom (Iscrizione alla Mailing-list) (736B) (8μs)
  • afterRenderModule mod_custom (Iscrizione alla Mailing-list) (128.09KB) (16.66ms)
  • beforeRenderModule mod_articles_category (Piccola Scuola di Musica) (13.42KB) (93μs)
  • afterRenderRawModule mod_articles_category (Piccola Scuola di Musica) (163.23KB) (10.49ms)
  • beforeRenderModule mod_articles_category (Piccola Scuola di Musica) (720B) (13μs)
  • afterRenderModule mod_articles_category (Piccola Scuola di Musica) (1.95KB) (261μs)
  • beforeRenderModule mod_login (Login Form) (4.44KB) (54μs)
  • afterRenderRawModule mod_login (Login Form) (215.88KB) (4.25ms)
  • beforeRenderModule mod_login (Login Form) (720B) (10μs)
  • afterRenderModule mod_login (Login Form) (2.19KB) (267μs)
  • beforeRenderModule mod_custom (Acquista CD Lamentatio) (1.21KB) (102μs)
  • afterRenderRawModule mod_custom (Acquista CD Lamentatio) (120.1KB) (12.08ms)
  • beforeRenderModule mod_custom (Acquista CD Lamentatio) (720B) (14μs)
  • afterRenderModule mod_custom (Acquista CD Lamentatio) (1.95KB) (278μs)
  • beforeRenderModule mod_articles_category (Associazione) (9.58KB) (55μs)
  • afterRenderRawModule mod_articles_category (Associazione) (66.05KB) (7.42ms)
  • beforeRenderModule mod_articles_category (Associazione) (704B) (11μs)
  • afterRenderModule mod_articles_category (Associazione) (1.69KB) (247μs)
  • beforeRenderModule mod_articles_category (Coro Sicut Lilium) (2.84KB) (71μs)
  • afterRenderRawModule mod_articles_category (Coro Sicut Lilium) (56.77KB) (6.43ms)
  • beforeRenderModule mod_articles_category (Coro Sicut Lilium) (720B) (10μs)
  • afterRenderModule mod_articles_category (Coro Sicut Lilium) (1.95KB) (248μs)
  • beforeRenderModule mod_articles_category (Ensemble del Giglio) (4.84KB) (50μs)
  • afterRenderRawModule mod_articles_category (Ensemble del Giglio) (57.29KB) (6.89ms)
  • beforeRenderModule mod_articles_category (Ensemble del Giglio) (720B) (10μs)
  • afterRenderModule mod_articles_category (Ensemble del Giglio) (1.95KB) (228μs)
  • beforeRenderModule mod_articles_categories (Categorie Articoli) (9.09KB) (37μs)
  • afterRenderRawModule mod_articles_categories (Categorie Articoli) (371.61KB) (24.02ms)
  • beforeRenderModule mod_articles_categories (Categorie Articoli) (720B) (14μs)
  • afterRenderModule mod_articles_categories (Categorie Articoli) (1.69KB) (315μs)
  • afterRender (218.12KB) (10ms)
  • 1 x beforeRenderModule mod_articles_category (Sentieri di Musica) (54.52KB) (15.3%)
    66.12ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (911.55KB) (10.53%)
    45.51ms
    1 x Before Access::getAssetRules (id:613 name:com_jdownloads.download.10) (322.08KB) (7.89%)
    34.10ms
    1 x afterInitialise (1.2MB) (7.35%)
    31.78ms
    1 x afterRenderRawModule mod_articles_categories (Categorie Articoli) (371.61KB) (5.56%)
    24.02ms
    1 x afterRenderComponent com_content (238.69KB) (4.22%)
    18.22ms
    1 x afterRenderRawModule mod_articles_category (Sentieri di Musica) (251.82KB) (3.91%)
    16.91ms
    1 x afterRenderModule mod_custom (Iscrizione alla Mailing-list) (128.09KB) (3.86%)
    16.66ms
    1 x afterRoute (618.5KB) (3.66%)
    15.82ms
    1 x afterRenderRawModule mod_custom (Acquista CD Lamentatio) (120.1KB) (2.79%)
    12.08ms
    1 x afterRenderRawModule mod_articles_category (Piccola Scuola di Musica) (163.23KB) (2.43%)
    10.49ms
    1 x afterRender (218.12KB) (2.31%)
    10.00ms
    1 x Before Access::getAssetRules (id:608 name:com_jdownloads.download.5) (79.16KB) (2.15%)
    9.28ms
    1 x Before Access::getAssetRules (id:614 name:com_jdownloads.download.11) (94.1KB) (1.97%)
    8.51ms
    1 x Before Access::getAssetRules (id:615 name:com_jdownloads.download.12) (79.26KB) (1.88%)
    8.12ms
    1 x Before Access::getAssetRules (id:616 name:com_jdownloads.download.13) (78.98KB) (1.83%)
    7.91ms
    1 x Before Access::getAssetRules (id:609 name:com_jdownloads.download.6) (79.67KB) (1.78%)
    7.70ms
    1 x afterRenderRawModule mod_articles_category (Associazione) (66.05KB) (1.72%)
    7.42ms
    1 x Before Access::getAssetRules (id:618 name:com_jdownloads.download.15) (78.76KB) (1.69%)
    7.31ms
    1 x Before Access::getAssetRules (id:617 name:com_jdownloads.download.14) (80.2KB) (1.66%)
    7.17ms
    1 x Before Access::getAssetRules (id:619 name:com_jdownloads.download.16) (79.85KB) (1.66%)
    7.17ms
    1 x Before Access::getAssetRules (id:612 name:com_jdownloads.download.9) (79.38KB) (1.65%)
    7.14ms
    1 x Before Access::getAssetRules (id:610 name:com_jdownloads.download.7) (79.23KB) (1.62%)
    6.99ms
    1 x Before Access::getAssetRules (id:607 name:com_jdownloads.download.4) (83.16KB) (1.61%)
    6.96ms
    1 x afterRenderRawModule mod_articles_category (Ensemble del Giglio) (57.29KB) (1.59%)
    6.89ms
    1 x afterRenderRawModule mod_articles_category (Coro Sicut Lilium) (56.77KB) (1.49%)
    6.43ms
    1 x afterLoad (444.94KB) (1.18%)
    5.11ms
    1 x afterRenderRawModule mod_login (Login Form) (215.88KB) (0.98%)
    4.25ms
    1 x beforeRenderComponent com_content (52.57KB) (0.6%)
    2.61ms
    1 x After Access::preloadPermissions (com_content) (96.88KB) (0.48%)
    2.09ms
    1 x After Access::preloadComponents (all components) (126.01KB) (0.43%)
    1.85ms
    1 x After Access::preloadPermissions (com_jdownloads) (38.84KB) (0.3%)
    1.28ms
    1 x afterDispatch (16.13KB) (0.28%)
    1.19ms
    1 x Before Access::preloadComponents (all components) (35.94KB) (0.26%)
    1.13ms
    1 x afterRenderRawModule mod_custom (Iscrizione alla Mailing-list) (4.42KB) (0.2%)
    843μs
    1 x afterRenderModule mod_articles_category (Sentieri di Musica) (2.41KB) (0.09%)
    385μs
    1 x afterRenderModule mod_articles_categories (Categorie Articoli) (1.69KB) (0.07%)
    315μs
    1 x afterRenderModule mod_custom (Acquista CD Lamentatio) (1.95KB) (0.06%)
    278μs
    1 x afterRenderModule mod_login (Login Form) (2.19KB) (0.06%)
    267μs
    1 x afterRenderModule mod_articles_category (Piccola Scuola di Musica) (1.95KB) (0.06%)
    261μs
    1 x afterRenderModule mod_articles_category (Coro Sicut Lilium) (1.95KB) (0.06%)
    248μs
    1 x afterRenderModule mod_articles_category (Associazione) (1.69KB) (0.06%)
    247μs
    1 x afterRenderModule mod_articles_category (Ensemble del Giglio) (1.95KB) (0.05%)
    228μs
    1 x After Access::getAssetRules (id:594 name:com_content.article.97) (7.47KB) (0.04%)
    187μs
    1 x Before Access::preloadPermissions (com_jdownloads) (7.7KB) (0.02%)
    103μs
    1 x beforeRenderModule mod_custom (Acquista CD Lamentatio) (1.21KB) (0.02%)
    102μs
    1 x beforeRenderModule mod_articles_category (Piccola Scuola di Musica) (13.42KB) (0.02%)
    93μs
    1 x Before Access::getAssetRules (id:218 name:com_jdownloads) (1.48KB) (0.02%)
    79μs
    1 x beforeRenderModule mod_articles_category (Coro Sicut Lilium) (2.84KB) (0.02%)
    71μs
    1 x beforeRenderModule mod_articles_category (Associazione) (9.58KB) (0.01%)
    55μs
    1 x Before Access::preloadPermissions (com_content) (1.73KB) (0.01%)
    54μs
    1 x beforeRenderModule mod_login (Login Form) (4.44KB) (0.01%)
    54μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.02KB) (0.01%)
    50μs
    1 x beforeRenderModule mod_articles_category (Ensemble del Giglio) (4.84KB) (0.01%)
    50μs
    1 x beforeRenderModule mod_custom (Iscrizione alla Mailing-list) (9.72KB) (0.01%)
    45μs
    1 x beforeRenderModule mod_articles_categories (Categorie Articoli) (9.09KB) (0.01%)
    37μs
    1 x After Access::getAssetRules (id:218 name:com_jdownloads) (6.53KB) (0.01%)
    34μs
    1 x Before Access::getAssetRules (id:594 name:com_content.article.97) (6.65KB) (0.01%)
    27μs
    1 x After Access::getAssetRules (id:613 name:com_jdownloads.download.10) (1.3KB) (0.01%)
    26μs
    1 x Before Access::getAssetRules (id:611 name:com_jdownloads.download.8) (680B) (0.01%)
    23μs
    1 x After Access::getAssetRules (id:609 name:com_jdownloads.download.6) (1.3KB) (0.01%)
    22μs
    1 x After Access::getAssetRules (id:614 name:com_jdownloads.download.11) (1.3KB) (0%)
    20μs
    1 x After Access::getAssetRules (id:608 name:com_jdownloads.download.5) (1.3KB) (0%)
    20μs
    1 x After Access::getAssetRules (id:615 name:com_jdownloads.download.12) (1.3KB) (0%)
    19μs
    1 x After Access::getAssetRules (id:617 name:com_jdownloads.download.14) (1.3KB) (0%)
    18μs
    1 x After Access::getAssetRules (id:612 name:com_jdownloads.download.9) (2.55KB) (0%)
    18μs
    1 x After Access::getAssetRules (id:619 name:com_jdownloads.download.16) (1.61KB) (0%)
    18μs
    1 x After Access::getAssetRules (id:610 name:com_jdownloads.download.7) (1.3KB) (0%)
    17μs
    1 x After Access::getAssetRules (id:616 name:com_jdownloads.download.13) (1.3KB) (0%)
    17μs
    1 x After Access::getAssetRules (id:607 name:com_jdownloads.download.4) (1.3KB) (0%)
    16μs
    1 x After Access::getAssetRules (id:618 name:com_jdownloads.download.15) (1.3KB) (0%)
    16μs
    1 x beforeRenderModule mod_articles_category (Sentieri di Musica) (720B) (0%)
    14μs
    1 x beforeRenderModule mod_articles_categories (Categorie Articoli) (720B) (0%)
    14μs
    1 x beforeRenderModule mod_custom (Acquista CD Lamentatio) (720B) (0%)
    14μs
    1 x After Access::getAssetRules (id:611 name:com_jdownloads.download.8) (1.92KB) (0%)
    13μs
    1 x beforeRenderModule mod_articles_category (Piccola Scuola di Musica) (720B) (0%)
    13μs
    1 x beforeRenderModule mod_articles_category (Associazione) (704B) (0%)
    11μs
    1 x beforeRenderModule mod_login (Login Form) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_articles_category (Coro Sicut Lilium) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_articles_category (Ensemble del Giglio) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Iscrizione alla Mailing-list) (736B) (0%)
    8μs
179 statements were executed, 69 of which were duplicates, 110 unique115ms882.31KB
  • SELECT @@SESSION.sql_mode;200μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?295μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 1206μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)761μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1575μs17.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`200μs672B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos_usergroups` AS `a` LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest353μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `jos_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`832μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`678μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'214μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT INDEX_NAME FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'jos_tagz' AND INDEX_NAME = 'idx_component_id'341μs536B/plugins/system/tagz/tagz.php:157Copy
  • SELECT INDEX_NAME FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'jos_tagz' AND INDEX_NAME = 'idx_component_type'220μs536B/plugins/system/tagz/tagz.php:157Copy
  • 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 `jos_menu` AS `m` LEFT JOIN `jos_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`756μs19.52KBParams/libraries/src/Menu/SiteMenu.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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`809μs4.02KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jos_template_styles` AS `s` LEFT JOIN `jos_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` = 1560μs864B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SHOW TABLES1.13ms2.26KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC395μs2.86KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_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)1.04ms7.81KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.48ms20.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`2.4ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '97'1.2ms48B/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 `jos_content` AS `a` INNER JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_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) AND `a`.`state` IN (:preparedArray1,:preparedArray2)762μs22.13KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`638μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)432μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT id, link from jos_menu WHERE link LIKE 'index.php?option=com_jdownloads&view=category%' AND published = 1339μs576B/plugins/content/jdownloads/jdownloads.php:76Copy
  • SELECT id, link, published, access, language FROM jos_menu WHERE (link LIKE 'index.php?option=com_jdownloads%') AND published = 1 AND client_id = 0 AND language = 'it-it' AND access IN (1,5)391μs752B/components/com_jdownloads/src/Helper/JDHelper.php:247Copy
  • SELECT id, link, published, access, language FROM jos_menu WHERE (link LIKE 'index.php?option=com_jdownloads%') AND published = 1 AND client_id = 0 AND access IN (1,5)295μs752B/components/com_jdownloads/src/Helper/JDHelper.php:252Copy
  • SELECT id FROM jos_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND language = 'it-it' AND access IN (1,5)250μs520B/components/com_jdownloads/src/Helper/JDHelper.php:305Copy
  • SELECT id FROM jos_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND access IN (1,5)287μs520B/components/com_jdownloads/src/Helper/JDHelper.php:310Copy
  • SELECT id FROM jos_menu WHERE (link = 'index.php?option=com_jdownloads&view=downloads') AND published = 1 AND client_id = 0 AND client_id = 0 AND access IN (1,5)331μs520B/components/com_jdownloads/src/Helper/JDHelper.php:341Copy
  • SELECT id FROM jos_menu WHERE (link = 'index.php?option=com_jdownloads&view=downloads&type=uncategorised') AND published = 1 AND client_id = 0 AND access IN (1,5)352μs520B/components/com_jdownloads/src/Helper/JDHelper.php:348Copy
  • SELECT id FROM jos_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND language = 'it-it' AND access IN (1,5)638μs520B/components/com_jdownloads/src/Helper/JDHelper.php:359Copy
  • SELECT id FROM jos_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND access IN (1,5)648μs3.01KB/components/com_jdownloads/src/Helper/JDHelper.php:364Copy
  • SELECT id FROM jos_menu WHERE link = 'index.php?option=com_jdownloads&view=search' AND published = 1 AND client_id = 0 AND access IN (1,5)381μs520B/components/com_jdownloads/src/Helper/JDHelper.php:378Copy
  • SELECT id FROM jos_menu WHERE link = 'index.php?option=com_jdownloads&view=form&layout=edit' AND published = 1 AND client_id = 0 AND access IN (1,5)336μs520B/components/com_jdownloads/src/Helper/JDHelper.php:383Copy
  • SELECT id, link from jos_menu WHERE link LIKE 'index.php?option=com_jdownloads&view=category&catid%' AND published = 1 AND access IN (1,5)843μs576B/components/com_jdownloads/src/Helper/JDHelper.php:415Copy
  • 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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`660μs3.94KBParams/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 jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jos_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 ASC1.28ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT count(*) FROM jos_jdownloads_categories WHERE published = 1 AND id IN (2) AND access IN (1,5)439μs536B/plugins/content/jdownloads/jdownloads.php:1697Copy
  • SELECT * FROM jos_jdownloads_files WHERE published = 1 AND catid IN (2) AND access IN (1,5) ORDER BY ordering ASC1ms22.23KB/plugins/content/jdownloads/jdownloads.php:1711Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0837μs2.23KBParams/libraries/src/Access/Access.php:301Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM jos_jdownloads_files AS a LEFT JOIN jos_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN jos_jdownloads_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_users AS u2 on u2.id = a.modified_by LEFT JOIN jos_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN jos_jdownloads_licenses AS l on l.id = a.license LEFT JOIN jos_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN jos_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 8) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)1.43ms10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • 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 jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jos_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 ASC1.01ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)347μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM jos_jdownloads_templates WHERE (template_name = 'Files link only v3.2') AND (template_typ = 2)539μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM jos_jdownloads_usergroups_limits ORDER BY importance404μs800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM jos_jdownloads_usergroups_limits WHERE group_id IN (1)632μs11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `jos_usergroups` WHERE `id` = :id249μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SET SESSION SQL_BIG_SELECTS = 1115μs0B/components/com_jdownloads/src/Helper/CategoriesHelper.php:236Copy
  • SELECT c.*, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as slug,( SELECT COUNT(`files`.`id`) FROM `jos_jdownloads_files` AS `files` WHERE `files`.`catid` = `c`.`id` AND `files`.`published` = 1 AND files.access IN (1,5) AND files.user_access = 0 AND (files.publish_up IS NULL OR files.publish_up <= '2025-04-04 05:26:48') AND (files.publish_down IS NULL OR files.publish_down >= '2025-04-04 05:26:48')) AS `numitems`,( SELECT COUNT(*) FROM `jos_jdownloads_categories` AS `cat` WHERE `cat`.`parent_id` = `c`.`id` AND cat.parent_id > 1 AND cat.published = 1 AND cat.access IN (1,5)) AS `subcatitems`,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid FROM `jos_jdownloads_categories` AS `s` INNER JOIN `jos_jdownloads_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) LEFT JOIN `jos_jdownloads_files` AS files ON files.`catid` = c.id AND files.published = 1 LEFT JOIN jos_users AS u on u.id = files.created_by LEFT JOIN jos_users AS u2 on u2.id = files.modified_by LEFT JOIN (SELECT id, link, access, published from jos_menu GROUP BY link) AS menu on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=', c.id) AND menu.published = 1 AND menu.access IN (1,5) WHERE c.access IN (1,5) AND c.published = 1 AND `s`.`id` = c.id GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.access ORDER BY c.lft4.87ms4.75KB/components/com_jdownloads/src/Helper/CategoriesHelper.php:433Copy
  • SELECT alias, id FROM jos_jdownloads_categories WHERE id > 1 ORDER BY `id`258μs656B/components/com_jdownloads/src/Helper/LegacyRouter.php:75Copy
  • SELECT alias, id FROM jos_jdownloads_files ORDER BY `id`217μs1.19KB/components/com_jdownloads/src/Helper/LegacyRouter.php:85Copy
  • SET SESSION SQL_BIG_SELECTS = 1106μs0B/components/com_jdownloads/src/Helper/CategoriesHelper.php:236Copy
  • SELECT c.*, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as slug,( SELECT COUNT(`files`.`id`) FROM `jos_jdownloads_files` AS `files` WHERE `files`.`catid` = `c`.`id` AND `files`.`published` = 1 AND files.access IN (1,5) AND files.user_access = 0 AND (files.publish_up IS NULL OR files.publish_up <= '2025-04-04 05:26:48') AND (files.publish_down IS NULL OR files.publish_down >= '2025-04-04 05:26:48')) AS `numitems`,( SELECT COUNT(*) FROM `jos_jdownloads_categories` AS `cat` WHERE `cat`.`parent_id` = `c`.`id` AND cat.parent_id > 1 AND cat.published = 1 AND cat.access IN (1,5)) AS `subcatitems`,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid FROM `jos_jdownloads_categories` AS `s` INNER JOIN `jos_jdownloads_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) LEFT JOIN `jos_jdownloads_files` AS files ON files.`catid` = c.id AND files.published = 1 LEFT JOIN jos_users AS u on u.id = files.created_by LEFT JOIN jos_users AS u2 on u2.id = files.modified_by LEFT JOIN (SELECT id, link, access, published from jos_menu GROUP BY link) AS menu on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=', c.id) AND menu.published = 1 AND menu.access IN (1,5) WHERE c.access IN (1,5) AND c.published = 1 AND `s`.`id` = c.id GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.access ORDER BY c.lft3.98ms4.75KB/components/com_jdownloads/src/Helper/CategoriesHelper.php:433Copy
  • 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 jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_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 ASC970μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM jos_jdownloads_files AS a LEFT JOIN jos_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN jos_jdownloads_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_users AS u2 on u2.id = a.modified_by LEFT JOIN jos_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN jos_jdownloads_licenses AS l on l.id = a.license LEFT JOIN jos_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN jos_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 10) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)982μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)354μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM jos_jdownloads_templates WHERE (template_name = 'Files link only v3.2') AND (template_typ = 2)351μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM jos_jdownloads_usergroups_limits ORDER BY importance236μs800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM jos_jdownloads_usergroups_limits WHERE group_id IN (1)707μs11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `jos_usergroups` WHERE `id` = :id213μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM jos_jdownloads_files AS a LEFT JOIN jos_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN jos_jdownloads_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_users AS u2 on u2.id = a.modified_by LEFT JOIN jos_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN jos_jdownloads_licenses AS l on l.id = a.license LEFT JOIN jos_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN jos_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 6) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)1.17ms10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)421μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM jos_jdownloads_templates WHERE (template_name = 'Files link only v3.2') AND (template_typ = 2)434μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM jos_jdownloads_usergroups_limits ORDER BY importance287μs11.78KB/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM jos_jdownloads_usergroups_limits WHERE group_id IN (1)748μs11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `jos_usergroups` WHERE `id` = :id248μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM jos_jdownloads_files AS a LEFT JOIN jos_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN jos_jdownloads_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_users AS u2 on u2.id = a.modified_by LEFT JOIN jos_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN jos_jdownloads_licenses AS l on l.id = a.license LEFT JOIN jos_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN jos_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 11) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)873μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)357μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM jos_jdownloads_templates WHERE (template_name = 'Files link only v3.2') AND (template_typ = 2)331μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM jos_jdownloads_usergroups_limits ORDER BY importance247μs800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM jos_jdownloads_usergroups_limits WHERE group_id IN (1)604μs11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `jos_usergroups` WHERE `id` = :id202μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM jos_jdownloads_files AS a LEFT JOIN jos_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN jos_jdownloads_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_users AS u2 on u2.id = a.modified_by LEFT JOIN jos_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN jos_jdownloads_licenses AS l on l.id = a.license LEFT JOIN jos_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN jos_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 14) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)879μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)367μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM jos_jdownloads_templates WHERE (template_name = 'Files link only v3.2') AND (template_typ = 2)321μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM jos_jdownloads_usergroups_limits ORDER BY importance228μs800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM jos_jdownloads_usergroups_limits WHERE group_id IN (1)608μs11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `jos_usergroups` WHERE `id` = :id221μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM jos_jdownloads_files AS a LEFT JOIN jos_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN jos_jdownloads_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_users AS u2 on u2.id = a.modified_by LEFT JOIN jos_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN jos_jdownloads_licenses AS l on l.id = a.license LEFT JOIN jos_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN jos_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 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.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)862μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)357μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM jos_jdownloads_templates WHERE (template_name = 'Files link only v3.2') AND (template_typ = 2)347μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM jos_jdownloads_usergroups_limits ORDER BY importance218μs800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM jos_jdownloads_usergroups_limits WHERE group_id IN (1)601μs11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `jos_usergroups` WHERE `id` = :id219μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM jos_jdownloads_files AS a LEFT JOIN jos_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN jos_jdownloads_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_users AS u2 on u2.id = a.modified_by LEFT JOIN jos_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN jos_jdownloads_licenses AS l on l.id = a.license LEFT JOIN jos_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN jos_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 7) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)876μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)366μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM jos_jdownloads_templates WHERE (template_name = 'Files link only v3.2') AND (template_typ = 2)306μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM jos_jdownloads_usergroups_limits ORDER BY importance208μs800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM jos_jdownloads_usergroups_limits WHERE group_id IN (1)572μs11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `jos_usergroups` WHERE `id` = :id224μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM jos_jdownloads_files AS a LEFT JOIN jos_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN jos_jdownloads_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_users AS u2 on u2.id = a.modified_by LEFT JOIN jos_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN jos_jdownloads_licenses AS l on l.id = a.license LEFT JOIN jos_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN jos_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 4) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)887μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)391μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM jos_jdownloads_templates WHERE (template_name = 'Files link only v3.2') AND (template_typ = 2)314μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM jos_jdownloads_usergroups_limits ORDER BY importance211μs800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM jos_jdownloads_usergroups_limits WHERE group_id IN (1)672μs11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `jos_usergroups` WHERE `id` = :id220μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM jos_jdownloads_files AS a LEFT JOIN jos_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN jos_jdownloads_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_users AS u2 on u2.id = a.modified_by LEFT JOIN jos_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN jos_jdownloads_licenses AS l on l.id = a.license LEFT JOIN jos_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN jos_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 9) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)922μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)342μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM jos_jdownloads_templates WHERE (template_name = 'Files link only v3.2') AND (template_typ = 2)559μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM jos_jdownloads_usergroups_limits ORDER BY importance479μs800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM jos_jdownloads_usergroups_limits WHERE group_id IN (1)970μs11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `jos_usergroups` WHERE `id` = :id298μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM jos_jdownloads_files AS a LEFT JOIN jos_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN jos_jdownloads_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_users AS u2 on u2.id = a.modified_by LEFT JOIN jos_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN jos_jdownloads_licenses AS l on l.id = a.license LEFT JOIN jos_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN jos_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)942μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)437μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM jos_jdownloads_templates WHERE (template_name = 'Files link only v3.2') AND (template_typ = 2)387μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM jos_jdownloads_usergroups_limits ORDER BY importance277μs800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM jos_jdownloads_usergroups_limits WHERE group_id IN (1)692μs11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `jos_usergroups` WHERE `id` = :id272μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM jos_jdownloads_files AS a LEFT JOIN jos_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN jos_jdownloads_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_users AS u2 on u2.id = a.modified_by LEFT JOIN jos_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN jos_jdownloads_licenses AS l on l.id = a.license LEFT JOIN jos_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN jos_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 12) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)876μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)415μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM jos_jdownloads_templates WHERE (template_name = 'Files link only v3.2') AND (template_typ = 2)389μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM jos_jdownloads_usergroups_limits ORDER BY importance275μs800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM jos_jdownloads_usergroups_limits WHERE group_id IN (1)658μs11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `jos_usergroups` WHERE `id` = :id272μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM jos_jdownloads_files AS a LEFT JOIN jos_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN jos_jdownloads_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_users AS u2 on u2.id = a.modified_by LEFT JOIN jos_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN jos_jdownloads_licenses AS l on l.id = a.license LEFT JOIN jos_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN jos_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 13) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)961μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)353μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM jos_jdownloads_templates WHERE (template_name = 'Files link only v3.2') AND (template_typ = 2)334μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM jos_jdownloads_usergroups_limits ORDER BY importance236μs800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM jos_jdownloads_usergroups_limits WHERE group_id IN (1)594μs11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `jos_usergroups` WHERE `id` = :id230μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM jos_jdownloads_files AS a LEFT JOIN jos_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN jos_jdownloads_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_users AS u2 on u2.id = a.modified_by LEFT JOIN jos_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM jos_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN jos_jdownloads_licenses AS l on l.id = a.license LEFT JOIN jos_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN jos_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 15) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)854μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_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)376μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM jos_jdownloads_templates WHERE (template_name = 'Files link only v3.2') AND (template_typ = 2)322μs2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT group_id, importance, id FROM jos_jdownloads_usergroups_limits ORDER BY importance215μs800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM jos_jdownloads_usergroups_limits WHERE group_id IN (1)585μs11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `jos_usergroups` WHERE `id` = :id234μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • 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 `jos_content` AS `a` LEFT JOIN `jos_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) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC1.21ms2.03KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • 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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`602μs11.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jos_modules` AS `m` LEFT JOIN `jos_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jos_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) ORDER BY `m`.`position`,`m`.`ordering`776μs2KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 512 AND `component_type` = "menu"350μs520B/plugins/system/tagz/tagz.php:691Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 97 AND `component_type` = "content"474μs536B/plugins/system/tagz/tagz.php:691Copy
  • 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`,( SELECT COUNT(`i`.`id`) FROM `jos_content` AS `i` WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`1.24ms4.09KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `jos_content` AS `a` LEFT JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `jos_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_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`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13) AND `a`.`created_by_alias` IN (:preparedArray14) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY publish_up DESC LIMIT 24.82ms24.5KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`498μs3.94KBParams/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 jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_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 ASC923μs4.06KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`489μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SHOW FULL COLUMNS FROM `jos_content`630μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT `article`.`id` AS `article.id`,'http://sicutlilium.it/attivita/sentieri-di-musica/22-sm-2017/97-concerto-barocco\n[683] RegularLabs.Plugin.System.ArticlesAnywhere.Articles.getValuesByArticleIds\n[733] RegularLabs.Plugin.System.ArticlesAnywhere.Database.getResults\n[ 95] RegularLabs.Plugin.System.ArticlesAnywhere.Helpers.DB.__callStatic' as 'query_comment' FROM `jos_content` AS `article` WHERE `article`.`id` = 97 LIMIT 1243μs592B/plugins/system/articlesanywhere/src/Database.php:115Copy
  • SELECT category.id,'http://sicutlilium.it/attivita/sentieri-di-musica/22-sm-2017/97-concerto-barocco\n[246] RegularLabs.Plugin.System.ArticlesAnywhere.Articles.getUnpublishedCategoryIds\n[621] RegularLabs.Plugin.System.ArticlesAnywhere.Database.getResults\n[ 95] RegularLabs.Plugin.System.ArticlesAnywhere.Helpers.DB.__callStatic' as 'query_comment' FROM `jos_categories` AS `category` LEFT JOIN `jos_categories` AS `parent` ON `category`.`parent_id` = `parent`.`id` WHERE `category`.`extension` = 'com_content' AND (`category`.`published` IN (0,-1,-2) OR `parent`.`published` IN (0,-1,-2)) GROUP BY category.id578μs576B/plugins/system/articlesanywhere/src/Database.php:115Copy
  • SELECT `article`.`id` AS `article.id`,'http://sicutlilium.it/attivita/sentieri-di-musica/22-sm-2017/97-concerto-barocco\n[745] RegularLabs.Plugin.System.ArticlesAnywhere.Articles.getArticleIdsByFilters\n[311] RegularLabs.Plugin.System.ArticlesAnywhere.Database.getResults\n[ 95] RegularLabs.Plugin.System.ArticlesAnywhere.Helpers.DB.__callStatic' as 'query_comment' FROM `jos_content` AS `article` WHERE ((`article`.`state` = 1 AND (`article`.`publish_up` IS NULL OR `article`.`publish_up` <= '2025-04-04 05:26:48') AND (`article`.`publish_down` IS NULL OR `article`.`publish_down` = '0000-00-00 00:00:00' OR `article`.`publish_down` > '2025-04-04 05:26:48')) AND `article`.`access` IN (1,5) AND `article`.`language` IN ('it-IT','*')) AND `article`.`title` = 'Iscrizione alla Mailing-list' LIMIT 1575μs592B/plugins/system/articlesanywhere/src/Database.php:115Copy
  • SELECT `article`.`id` AS `article.id`,`article`.`introtext` AS `article.introtext`,`article`.`fulltext` AS `article.fulltext`,'http://sicutlilium.it/attivita/sentieri-di-musica/22-sm-2017/97-concerto-barocco\n[747] RegularLabs.Plugin.System.ArticlesAnywhere.Articles.getValuesByArticleIds\n[733] RegularLabs.Plugin.System.ArticlesAnywhere.Database.getResults\n[ 95] RegularLabs.Plugin.System.ArticlesAnywhere.Helpers.DB.__callStatic' as 'query_comment' FROM `jos_content` AS `article` WHERE `article`.`id` = 90 LIMIT 1295μs704B/plugins/system/articlesanywhere/src/Database.php:115Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '90'1.01ms48B/libraries/src/Table/Table.php:1325Copy
  • 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`,( SELECT COUNT(`i`.`id`) FROM `jos_content` AS `i` WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`1.02ms4.02KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `jos_content` AS `a` LEFT JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `jos_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_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`.`featured` = 1 AND (`fp`.`featured_up` IS NULL OR `fp`.`featured_up` <= :featuredUp) AND (`fp`.`featured_down` IS NULL OR `fp`.`featured_down` >= :featuredDown) AND `a`.`catid` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12) AND `a`.`created_by_alias` IN (:preparedArray13) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.ordering ASC LIMIT 31.19ms24.52KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`467μs3.94KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`476μs3.94KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`636μs3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `jos_content` WHERE `id` = :id250μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `jos_content` WHERE `id` = :id293μs1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `article`.`id` AS `article.id`,'http://sicutlilium.it/attivita/sentieri-di-musica/22-sm-2017/97-concerto-barocco\n[745] RegularLabs.Plugin.System.ArticlesAnywhere.Articles.getArticleIdsByFilters\n[311] RegularLabs.Plugin.System.ArticlesAnywhere.Database.getResults\n[ 95] RegularLabs.Plugin.System.ArticlesAnywhere.Helpers.DB.__callStatic' as 'query_comment' FROM `jos_content` AS `article` WHERE ((`article`.`state` = 1 AND (`article`.`publish_up` IS NULL OR `article`.`publish_up` <= '2025-04-04 05:26:48') AND (`article`.`publish_down` IS NULL OR `article`.`publish_down` = '0000-00-00 00:00:00' OR `article`.`publish_down` > '2025-04-04 05:26:48')) AND `article`.`access` IN (1,5) AND `article`.`language` IN ('it-IT','*')) AND (`article`.`id` = 136 OR `article`.`alias` = '136' OR `article`.`title` = '136') LIMIT 1700μs592B/plugins/system/articlesanywhere/src/Database.php:115Copy
  • SELECT `article`.`id` AS `article.id`,`article`.`introtext` AS `article.introtext`,`article`.`fulltext` AS `article.fulltext`,'http://sicutlilium.it/attivita/sentieri-di-musica/22-sm-2017/97-concerto-barocco\n[747] RegularLabs.Plugin.System.ArticlesAnywhere.Articles.getValuesByArticleIds\n[733] RegularLabs.Plugin.System.ArticlesAnywhere.Database.getResults\n[ 95] RegularLabs.Plugin.System.ArticlesAnywhere.Helpers.DB.__callStatic' as 'query_comment' FROM `jos_content` AS `article` WHERE `article`.`id` = 136 LIMIT 1415μs704B/plugins/system/articlesanywhere/src/Database.php:115Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '136'1.01ms48B/libraries/src/Table/Table.php:1325Copy
  • 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 jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_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 ASC1.46ms4.02KBParams/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`,( SELECT COUNT(`i`.`id`) FROM `jos_content` AS `i` WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`1.12ms3.95KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `jos_content` AS `a` LEFT JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `jos_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_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`.`catid` IN (:preparedArray5) AND `a`.`created_by_alias` IN (:preparedArray6) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.ordering ASC LIMIT 2843μs23.03KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`498μs3.92KBParams/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`,( SELECT COUNT(`i`.`id`) FROM `jos_content` AS `i` WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`793μs3.95KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `jos_content` AS `a` LEFT JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `jos_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_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`.`catid` IN (:preparedArray5) AND `a`.`created_by_alias` IN (:preparedArray6) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.ordering ASC LIMIT 2718μs23.03KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`695μs3.92KBParams/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`,( SELECT COUNT(`i`.`id`) FROM `jos_content` AS `i` WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`782μs3.95KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `jos_content` AS `a` LEFT JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `jos_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_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`.`catid` IN (:preparedArray5) AND `a`.`created_by_alias` IN (:preparedArray6) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.ordering ASC LIMIT 2891μs47.03KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`662μs3.92KBParams/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`,( SELECT COUNT(`i`.`id`) FROM `jos_content` AS `i` WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems` FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`1.72ms4.28KBParams/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 jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_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 ASC1.24ms4.06KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`663μs3.94KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`612μs3.94KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`707μs3.94KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`568μs3.94KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`483μs3.94KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`468μs3.94KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`488μs3.94KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`460μs3.94KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`616μs3.94KBParams/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 `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) 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`632μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `jos_scheduler_tasks` AS `a` WHERE `a`.`state` = 1322μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SHOW TABLES567μs2.26KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?242μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?871μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy