SELECT `id`,`rules`
FROM `jos_viewlevels`171μs976B/libraries/src/Access/Access.php:955Copy
SELECT `b`.`id`
FROM `jos_usergroups` AS `a`
LEFTJOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest242μs2.23KBParams/libraries/src/Access/Access.php:868Copy
SELECT sampleData
FROM jos_kunena_version
ORDERBY id DESC LIMIT 1175μs856B/libraries/kunena/src/Forum/KunenaForum.php:374Copy
SELECT*FROM `jos_kunena_aliases`
WHERE `alias` LIKE'user%'298μs1.05KB/libraries/kunena/src/Route/KunenaRoute.php:859Copy
SHOWFULL COLUMNS FROM `jos_kunena_sessions`1.7ms1.97KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
SHOWFULL COLUMNS FROM `jos_kunena_users`3.37ms4.14KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
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)844μs7.88KBParams/libraries/src/Access/Access.php:357Copy
SELECTDISTINCT(user_id)
FROM `jos_usergroups` AS `ug1`
INNERJOIN `jos_usergroups` AS `ug2` ON ug2.lft >= ug1.lft AND ug1.rgt >= ug2.rgt
INNERJOIN `jos_user_usergroup_map` AS `m` ON ug2.id = m.group_id
WHERE ug1.id IN ( 8)1.03ms904B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
SELECTDISTINCT(user_id)
FROM `jos_usergroups` AS `ug1`
INNERJOIN `jos_usergroups` AS `ug2` ON ug2.lft >= ug1.lft AND ug1.rgt >= ug2.rgt
INNERJOIN `jos_user_usergroup_map` AS `m` ON ug2.id = m.group_id
WHERE ug1.id IN ( 7)836μs856B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
SELECT `user_id`,`category_id`,`role`
FROM `jos_kunena_user_categories`
WHERE `role` IN (1,2)388μs1008B/libraries/kunena/src/Access/KunenaAccess.php:184Copy
SHOWFULL COLUMNS FROM `jos_users`1.88ms2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
SELECT*FROM `jos_users`
WHERE `id` = :userid267μs4.41KBParams/libraries/src/Table/User.php:106Copy
SELECT `g`.`id`,`g`.`title`
FROM `jos_usergroups` AS `g`
INNERJOIN `jos_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id`
WHERE `m`.`user_id` = :muserid253μs1.68KBParams/libraries/src/Table/User.php:134Copy
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*FROM `jos_users` AS `u`
LEFTJOIN `jos_kunena_users` AS `ku` ON `u`.`id` = `ku`.`userid`
WHERE `u`.`id` ='184'778μs22.44KB/libraries/kunena/src/Tables/KunenaUsers.php:569Copy
SELECT*FROM `jos_users`
WHERE `id` = :userid357μs4.41KBParams/libraries/src/Table/User.php:106Copy
SELECT `g`.`id`,`g`.`title`
FROM `jos_usergroups` AS `g`
INNERJOIN `jos_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id`
WHERE `m`.`user_id` = :muserid287μs1.68KBParams/libraries/src/Table/User.php:134Copy
UPDATE `jos_kunena_users` SET `view`='',`moderator`='0',`banned`='1000-01-01 00:00:00',`ordering`='0',`posts`='33',`avatar`='users/avatar184.jpg',`karma`='0',`group_id`='1',`uhits`='177',`gender`='0',`birthdate`='0001-01-01',`rank`='0',`hideEmail`='1',`showOnline`='1',`thankyou`='0',`canSubscribe`='1',`userListtime`='-2',`status`='0',`status_text`='',`socialshare`='1',`ip`=''WHERE `userid`='184'336μs48B/libraries/kunena/src/Tables/KunenaTable.php:269Copy
SELECTDISTINCT(user_id)
FROM `jos_usergroups` AS `ug1`
INNERJOIN `jos_usergroups` AS `ug2` ON ug2.lft >= ug1.lft AND ug1.rgt >= ug2.rgt
INNERJOIN `jos_user_usergroup_map` AS `m` ON ug2.id = m.group_id
WHERE ug1.id IN ( 8)765μs904B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
SELECTDISTINCT(user_id)
FROM `jos_usergroups` AS `ug1`
INNERJOIN `jos_usergroups` AS `ug2` ON ug2.lft >= ug1.lft AND ug1.rgt >= ug2.rgt
INNERJOIN `jos_user_usergroup_map` AS `m` ON ug2.id = m.group_id
WHERE ug1.id IN ( 7)833μs856B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
SELECT `user_id`,`category_id`,`role`
FROM `jos_kunena_user_categories`
WHERE `role` IN (1,2)211μs1008B/libraries/kunena/src/Access/KunenaAccess.php:184Copy
SHOWFULL COLUMNS FROM `jos_kunena_users_banned`2.12ms2.11KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
SELECT*FROM `jos_users`
WHERE `id` = :userid352μs4.41KBParams/libraries/src/Table/User.php:106Copy
SELECT `g`.`id`,`g`.`title`
FROM `jos_usergroups` AS `g`
INNERJOIN `jos_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id`
WHERE `m`.`user_id` = :muserid268μs1.68KBParams/libraries/src/Table/User.php:134Copy
SHOWFULL COLUMNS FROM `jos_kunena_categories`1.82ms2.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='11'496μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='10'925μs18.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='1'2ms7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='6'1.76ms7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='2'1.7ms7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='12'1.85ms7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='3'2.77ms7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='13'2.03ms7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='15'1.9ms7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='4'1.76ms7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='14'476μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='16'559μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='7'473μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='5'428μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='17'427μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='8'437μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='18'480μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECT*FROM `jos_kunena_categories`
WHERE `id` ='9'908μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
SELECTCOUNT(*)
FROM `jos_kunena_messages` AS `a`
WHERE `a`.`userid` =184AND `a`.`hold` IN (0)1.03ms856B/libraries/kunena/src/Database/Object/KunenaFinder.php:278Copy
SELECT a.id
FROM `jos_kunena_messages` AS `a`
WHERE `a`.`userid` =184AND `a`.`hold` IN (0)
ORDERBY a.`time` DESC LIMIT 10386μs1000B/libraries/kunena/src/Database/Object/KunenaFinder.php:234Copy
SELECT m.*, t.message
FROM `jos_kunena_messages` AS `m`
INNERJOIN `jos_kunena_messages_text` AS `t` ON m.id = t.mesid
WHERE `m`.`id` IN (23853,23388,22680,19403,19077,18397,18349,18348,18347,18346)1.59ms3.92KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:120Copy
SHOWFULL COLUMNS FROM `jos_kunena_topics`2.56ms2.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
SELECT*FROM `jos_kunena_topics`
WHERE `id` ='9077'669μs4.06KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
SELECT*FROM `jos_kunena_topics`
WHERE `id` ='21147'563μs4.06KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
SELECT*FROM `jos_kunena_topics`
WHERE `id` ='11925'474μs4.06KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
SELECT*FROM `jos_kunena_topics`
WHERE `id` ='18687'592μs4.06KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
SELECT*FROM `jos_kunena_topics`
WHERE `id` ='18828'643μs4.06KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
SELECT*FROM `jos_kunena_topics`
WHERE `id` ='18349'513μs4.06KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
SELECT*FROM `jos_kunena_topics`
WHERE `id` ='18309'560μs4.06KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
SELECT*FROM `jos_kunena_topics`
WHERE `id` ='16921'1.03ms4.06KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
SELECT*FROM `jos_kunena_topics`
WHERE `id` ='18346'493μs4.06KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid
FROM `jos_users` AS `u`
LEFTJOIN `jos_kunena_users` AS `ku` ON `u`.`id` = `ku`.`userid`
WHERE `u`.`id` IN (64,189,63,85,169,155,226)723μs36.08KB/libraries/kunena/src/User/KunenaUserHelper.php:247Copy
SELECT*FROM `jos_kunena_user_topics`
WHERE
(`user_id` ='0') AND
(`topic_id` IN (9077,21147,11925,18687,18828,18349,18309,16921,18346))839μs1.89KB/libraries/kunena/src/Forum/Topic/User/KunenaTopicUserHelper.php:159Copy
SHOWFULL COLUMNS FROM `jos_kunena_user_topics`1.24ms10.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id,
SUM(mm.time<m.time) AS before_count,
SUM(mm.time>m.time) AS after_count
FROM `jos_kunena_messages` AS `m`
INNERJOIN `jos_kunena_messages` AS `mm` ON `m`.`thread` = `mm`.`thread`
WHERE `m`.`id` IN (23853,23388,22680,19403,19077,18397,18349,18348,18347,18346)
GROUPBY `m`.`id`,`mm`.`hold`8.82ms1.3KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
SELECT `code`,`location`
FROM `jos_kunena_smileys`248μs1.25KB/libraries/kunena/src/BBCode/KunenaBBCode.php:1122Copy
SELECTDISTINCT 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
LEFTJOIN `jos_languages` AS l ON l.lang_code = a.language
LEFTJOIN jos_users AS uc ON uc.id=a.checked_out
LEFTJOIN jos_viewlevels AS ag ON ag.id = a.access
LEFTJOIN jos_users AS ua ON ua.id = a.created_user_id
LEFTJOIN jos_fields_groups AS g ON g.id = a.group_id
WHERE
(
(`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND
(`a`.`group_id` =0OR `g`.`access` IN (:preparedArray2)) AND `a`.`state` = :state) AND
(`a`.`group_id` =0OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDERBY a.ordering ASC653μs5.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
SELECTSUM(CASEWHEN `a`.`next_execution` <= :now THEN1ELSE0END) AS due_count,SUM(CASEWHEN `a`.`locked` ISNULLTHEN0ELSE1END) AS locked_count
FROM `jos_scheduler_tasks` AS `a`
WHERE `a`.`state` =1403μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy