Now Playing: The Golden Rule
- Date: 2020-10-26Joomla! Version | 4.4.10 |
PHP Version | 8.2.21 |
Identity | guest |
Response | 200 |
Template | rt_xenon |
Database |
|
1 x afterRender (2.07MB) (39.9%) | 34.25ms |
1 x Before Access::preloadPermissions (com_sermonspeaker) (233.05KB) (18.86%) | 16.19ms |
1 x afterRenderComponent com_sermonspeaker (616.16KB) (14.64%) | 12.56ms |
1 x afterInitialise (932.74KB) (12.43%) | 10.67ms |
1 x afterRoute (307.22KB) (6.54%) | 5.61ms |
1 x afterLoad (447.53KB) (3.04%) | 2.61ms |
1 x Before Access::preloadComponents (all components) (107.04KB) (2.41%) | 2.07ms |
1 x beforeRenderComponent com_sermonspeaker (51.95KB) (0.75%) | 643μs |
1 x After Access::preloadComponents (all components) (129.31KB) (0.61%) | 526μs |
1 x After Access::preloadPermissions (com_sermonspeaker) (34.39KB) (0.37%) | 321μs |
1 x afterDispatch (2.25KB) (0.09%) | 81μs |
1 x After Access::getAssetRules (id:75 name:com_sermonspeaker) (6.91KB) (0.09%) | 79μs |
1 x Before Access::getAssetRules (id:75 name:com_sermonspeaker) (1.27KB) (0.01%) | 13μs |
SELECT @@SESSION.sql_mode;
44μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `b8rtz_session`
WHERE `session_id` = ?
81μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `b8rtz_session`
WHERE `session_id` = :session_id LIMIT 1
55μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `b8rtz_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
107μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `id`,`rules`
FROM `b8rtz_viewlevels`
67μs976B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `b8rtz_usergroups` AS `a`
LEFT JOIN `b8rtz_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
100μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `value` FROM b8rtz_acym_configuration WHERE `name` = 'level'
72μs536B/plugins/system/acymtriggers/acymtriggers.php:639CopySELECT `value` FROM b8rtz_acym_configuration WHERE `name` = 'active_cron'
46μs536B/plugins/system/acymtriggers/acymtriggers.php:639CopySELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM b8rtz_template_styles AS s
WHERE s.client_id = 0 AND s.template = 'rt_xenon'
ORDER BY s.id
118μs1.42KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `b8rtz_assets`
WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45)
303μs7.81KBParams/libraries/src/Access/Access.php:357CopySELECT speaker.id, speaker.title, speaker.alias, speaker.website, speaker.state, speaker.catid,CASE WHEN CHAR_LENGTH(speaker.alias) THEN CONCAT_WS(':', speaker.id, speaker.alias) ELSE speaker.id END as slug,speaker.checked_out, speaker.checked_out_time, speaker.language,speaker.intro, speaker.bio, speaker.pic, speaker.hits, speaker.created, speaker.created_by,speaker.metakey, speaker.metadesc, speaker.created, speaker.created_by,speaker.publish_up, speaker.publish_down,c.title AS category_title, c.access AS category_access,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,user.name AS author
FROM b8rtz_sermon_speakers AS speaker
LEFT JOIN b8rtz_categories AS c on c.id = speaker.catid
LEFT JOIN b8rtz_users AS user ON user.id = speaker.created_by
WHERE (speaker.publish_up = '0000-00-00 00:00:00' OR speaker.publish_up <= '2025-01-21 23:15:12') AND (speaker.publish_down = '0000-00-00 00:00:00' OR speaker.publish_down >= '2025-01-21 23:15:12') AND (speaker.catid = 0 OR c.published = 1) AND speaker.id = 18 AND speaker.state = 1
182μs2.84KB/components/com_sermonspeaker/models/speaker.php:92CopySELECT `m`.`tag_id`,`t`.*
FROM `b8rtz_contentitem_tag_map` AS `m`
INNER JOIN `b8rtz_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)
153μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT sermons.id, sermons.title, sermons.catid, sermons.audiofile, sermons.videofile, sermons.audiofilesize, sermons.videofilesize, CASE WHEN CHAR_LENGTH(sermons.alias) THEN CONCAT_WS(':', sermons.id, sermons.alias) ELSE sermons.id END as slug,sermons.picture, sermons.hits, sermons.notes, sermons.checked_out, sermons.checked_out_time,sermons.sermon_date, sermons.alias, sermons.sermon_time,sermons.state, sermons.ordering, sermons.podcast, sermons.language,sermons.sermon_number, sermons.addfile, sermons.addfileDesc,sermons.created, sermons.created_by,sermons.publish_up, sermons.publish_down,GROUP_CONCAT(script.book,"|",script.cap1,"|",script.vers1,"|",script.cap2,"|",script.vers2,"|",script.text ORDER BY script.ordering ASC SEPARATOR "!") AS scripture,speakers.title AS speaker_title, speakers.pic AS pic, speakers.state as speaker_state, speakers.bio, speakers.website,speakers.catid AS speaker_catid, speakers.language AS speaker_language,speakers.id AS speaker_id, speakers.intro, speakers.bio, speakers.website,CASE WHEN CHAR_LENGTH(speakers.alias) THEN CONCAT_WS(':', speakers.id, speakers.alias) ELSE speakers.id END as speaker_slug,series.title AS series_title, series.state as series_state, series.avatar,series.catid AS series_catid, series.language AS series_language,CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as series_slug,c_sermons.title AS category_title,CASE WHEN CHAR_LENGTH(c_sermons.alias) THEN CONCAT_WS(':', c_sermons.id, c_sermons.alias) ELSE c_sermons.id END as catslug,user.name AS author
FROM `b8rtz_sermon_sermons` AS sermons
LEFT JOIN b8rtz_sermon_scriptures AS script ON script.sermon_id = sermons.id
LEFT JOIN b8rtz_sermon_speakers AS speakers ON speakers.id = sermons.speaker_id
LEFT JOIN b8rtz_sermon_series AS series ON series.id = sermons.series_id
LEFT JOIN b8rtz_categories AS c_sermons ON c_sermons.id = sermons.catid
LEFT JOIN b8rtz_categories AS c_speaker ON c_speaker.id = speakers.catid
LEFT JOIN b8rtz_categories AS c_series ON c_series.id = series.catid
LEFT JOIN b8rtz_users AS user ON user.id = sermons.created_by
WHERE (sermons.catid = 0 OR (c_sermons.access IN (1,5) AND c_sermons.published = 1)) AND (sermons.speaker_id = 0 OR speakers.catid = 0 OR (c_speaker.access IN (1,5) AND c_speaker.published = 1)) AND (sermons.series_id = 0 OR series.catid = 0 OR (c_series.access IN (1,5) AND c_series.published = 1)) AND (sermons.publish_up = '0000-00-00 00:00:00' OR sermons.publish_up <= '2025-01-21 23:15:12') AND (sermons.publish_down = '0000-00-00 00:00:00' OR sermons.publish_down >= '2025-01-21 23:15:12') AND sermons.state = 1 AND sermons.speaker_id = 18
GROUP BY sermons.id, sermons.title, sermons.catid, sermons.audiofile, sermons.videofile, sermons.audiofilesize, sermons.videofilesize, sermons.picture, sermons.hits, sermons.notes, sermons.checked_out, sermons.checked_out_time,sermons.sermon_date, sermons.alias, sermons.sermon_time,sermons.state, sermons.ordering, sermons.podcast, sermons.language,sermons.sermon_number, sermons.addfile, sermons.addfileDesc,sermons.created, sermons.created_by,sermons.publish_up, sermons.publish_down,speakers.title, speakers.pic, speakers.state, speakers.catid, speakers.language, speakers.id, speakers.alias, speakers.intro, speakers.bio, speakers.website,series.title, series.avatar, series.state, series.catid, series.language, series.id, series.alias,c_sermons.title, c_sermons.id, c_sermons.alias,user.name
ORDER BY sermon_date DESC LIMIT 20
2.28ms21.58KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT sermons.id, sermons.title, sermons.catid, sermons.audiofile, sermons.videofile, sermons.audiofilesize, sermons.videofilesize, CASE WHEN CHAR_LENGTH(sermons.alias) THEN CONCAT_WS(':', sermons.id, sermons.alias) ELSE sermons.id END as slug,sermons.picture, sermons.hits, sermons.notes, sermons.checked_out, sermons.checked_out_time,sermons.sermon_date, sermons.alias, sermons.sermon_time,sermons.state, sermons.ordering, sermons.podcast, sermons.language,sermons.sermon_number, sermons.addfile, sermons.addfileDesc,sermons.created, sermons.created_by,sermons.publish_up, sermons.publish_down,GROUP_CONCAT(script.book,"|",script.cap1,"|",script.vers1,"|",script.cap2,"|",script.vers2,"|",script.text ORDER BY script.ordering ASC SEPARATOR "!") AS scripture,speakers.title AS speaker_title, speakers.pic AS pic, speakers.state as speaker_state, speakers.bio, speakers.website,speakers.catid AS speaker_catid, speakers.language AS speaker_language,speakers.id AS speaker_id, speakers.intro, speakers.bio, speakers.website,CASE WHEN CHAR_LENGTH(speakers.alias) THEN CONCAT_WS(':', speakers.id, speakers.alias) ELSE speakers.id END as speaker_slug,series.title AS series_title, series.state as series_state, series.avatar,series.catid AS series_catid, series.language AS series_language,CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as series_slug,c_sermons.title AS category_title,CASE WHEN CHAR_LENGTH(c_sermons.alias) THEN CONCAT_WS(':', c_sermons.id, c_sermons.alias) ELSE c_sermons.id END as catslug,user.name AS author
FROM `b8rtz_sermon_sermons` AS sermons
LEFT JOIN b8rtz_sermon_scriptures AS script ON script.sermon_id = sermons.id
LEFT JOIN b8rtz_sermon_speakers AS speakers ON speakers.id = sermons.speaker_id
LEFT JOIN b8rtz_sermon_series AS series ON series.id = sermons.series_id
LEFT JOIN b8rtz_categories AS c_sermons ON c_sermons.id = sermons.catid
LEFT JOIN b8rtz_categories AS c_speaker ON c_speaker.id = speakers.catid
LEFT JOIN b8rtz_categories AS c_series ON c_series.id = series.catid
LEFT JOIN b8rtz_users AS user ON user.id = sermons.created_by
WHERE (sermons.catid = 0 OR (c_sermons.access IN (1,5) AND c_sermons.published = 1)) AND (sermons.speaker_id = 0 OR speakers.catid = 0 OR (c_speaker.access IN (1,5) AND c_speaker.published = 1)) AND (sermons.series_id = 0 OR series.catid = 0 OR (c_series.access IN (1,5) AND c_series.published = 1)) AND (sermons.publish_up = '0000-00-00 00:00:00' OR sermons.publish_up <= '2025-01-21 23:15:12') AND (sermons.publish_down = '0000-00-00 00:00:00' OR sermons.publish_down >= '2025-01-21 23:15:12') AND sermons.state = 1 AND sermons.speaker_id = 18
GROUP BY sermons.id, sermons.title, sermons.catid, sermons.audiofile, sermons.videofile, sermons.audiofilesize, sermons.videofilesize, sermons.picture, sermons.hits, sermons.notes, sermons.checked_out, sermons.checked_out_time,sermons.sermon_date, sermons.alias, sermons.sermon_time,sermons.state, sermons.ordering, sermons.podcast, sermons.language,sermons.sermon_number, sermons.addfile, sermons.addfileDesc,sermons.created, sermons.created_by,sermons.publish_up, sermons.publish_down,speakers.title, speakers.pic, speakers.state, speakers.catid, speakers.language, speakers.id, speakers.alias, speakers.intro, speakers.bio, speakers.website,series.title, series.avatar, series.state, series.catid, series.language, series.id, series.alias,c_sermons.title, c_sermons.id, c_sermons.alias,user.name
1.32ms21.58KB/libraries/src/MVC/Model/BaseDatabaseModel.php:211CopySELECT DISTINCT YEAR(`sermon_date`) AS `year`
FROM `b8rtz_sermon_sermons`
WHERE `sermon_date` != '0000-00-00' AND state = 1
ORDER BY `year` ASC
971μs680B/components/com_sermonspeaker/models/sermons.php:175CopySELECT DISTINCT MONTH(`sermon_date`) AS `value`
FROM `b8rtz_sermon_sermons`
WHERE `sermon_date` != '0000-00-00' AND state = 1
ORDER BY `value` ASC
541μs712B/components/com_sermonspeaker/models/sermons.php:138CopySELECT DISTINCT `book`
FROM `b8rtz_sermon_scriptures`
LEFT JOIN `b8rtz_sermon_sermons` AS `sermons` ON `sermon_id` = `sermons`.`id`
WHERE `book` != 0 AND `sermons`.`state` = 1
ORDER BY `book` ASC
779μs2.26KB/components/com_sermonspeaker/models/sermons.php:206CopySELECT COUNT(1)
FROM `b8rtz_contentitem_tag_map`
WHERE `type_alias` = 'com_sermonspeaker.sermon'
67μs536B/components/com_sermonspeaker/models/sermons.php:225CopySELECT 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 b8rtz_fields AS a
LEFT JOIN `b8rtz_languages` AS l ON l.lang_code = a.language
LEFT JOIN b8rtz_users AS uc ON uc.id=a.checked_out
LEFT JOIN b8rtz_viewlevels AS ag ON ag.id = a.access
LEFT JOIN b8rtz_users AS ua ON ua.id = a.created_user_id
LEFT JOIN b8rtz_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 ASC
710μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `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 `b8rtz_sermon_sermons` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `b8rtz_categories` AS `c`
WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1
ORDER BY `c`.`lft`
4.54ms3.95KBParams/libraries/src/Categories/Categories.php:375CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `b8rtz_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
188μs2.11KBParams/libraries/src/Access/Access.php:301CopySHOW FULL COLUMNS FROM `b8rtz_assets`
549μs1.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `b8rtz_assets`
WHERE `name` = 'com_sermonspeaker.sermons.category.root'
64μs912B/libraries/src/Table/Table.php:755CopySELECT series.id, series.title, series.catid, series.avatar, series.language, CASE WHEN CHAR_LENGTH(series.alias) THEN CONCAT_WS(':', series.id, series.alias) ELSE series.id END as slug, series.hits, series.series_description, series.alias, series.checked_out, series.checked_out_time, series.state, series.ordering, series.created, series.created_by, series.publish_up, series.publish_down, series.zip_dl,c_series.title AS category_title,CASE WHEN CHAR_LENGTH(c_series.alias) THEN CONCAT_WS(':', c_series.id, c_series.alias) ELSE c_series.id END as catslug,user.name AS author
FROM `b8rtz_sermon_series` AS series
LEFT JOIN b8rtz_categories AS c_series ON c_series.id = series.catid
LEFT JOIN b8rtz_users AS user ON user.id = series.created_by
WHERE (series.catid = 0 OR (c_series.access IN (1,5) AND c_series.published = 1)) AND (series.publish_up = '0000-00-00 00:00:00' OR series.publish_up <= '2025-01-21 23:15:12') AND (series.publish_down = '0000-00-00 00:00:00' OR series.publish_down >= '2025-01-21 23:15:12') AND series.state = 1 AND series.state != -2 AND series.id IN (
SELECT DISTINCT series_id
FROM b8rtz_sermon_sermons
WHERE speaker_id = 18 AND state = 1)
ORDER BY ordering ASC LIMIT 20
619μs2.55KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT COUNT(*)
FROM `b8rtz_sermon_series` AS series
LEFT JOIN b8rtz_categories AS c_series ON c_series.id = series.catid
LEFT JOIN b8rtz_users AS user ON user.id = series.created_by
WHERE (series.catid = 0 OR (c_series.access IN (1,5) AND c_series.published = 1)) AND (series.publish_up = '0000-00-00 00:00:00' OR series.publish_up <= '2025-01-21 23:15:12') AND (series.publish_down = '0000-00-00 00:00:00' OR series.publish_down >= '2025-01-21 23:15:12') AND series.state = 1 AND series.state != -2 AND series.id IN (
SELECT DISTINCT series_id
FROM b8rtz_sermon_sermons
WHERE speaker_id = 18 AND state = 1)
227μs536B/libraries/src/MVC/Model/BaseDatabaseModel.php:199CopySHOW FULL COLUMNS FROM `b8rtz_sermon_speakers`
503μs1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopyUPDATE `b8rtz_sermon_speakers`
SET `hits` = (`hits` + 1)
WHERE `id` = '18'
108μs48B/libraries/src/Table/Table.php:1325CopySELECT `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 `b8rtz_categories` AS `s`
INNER JOIN `b8rtz_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`
213μs3.86KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 b8rtz_fields AS a
LEFT JOIN `b8rtz_languages` AS l ON l.lang_code = a.language
LEFT JOIN b8rtz_users AS uc ON uc.id=a.checked_out
LEFT JOIN b8rtz_viewlevels AS ag ON ag.id = a.access
LEFT JOIN b8rtz_users AS ua ON ua.id = a.created_user_id
LEFT JOIN b8rtz_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `b8rtz_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 ASC
650μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `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 `b8rtz_categories` AS `s`
INNER JOIN `b8rtz_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`
175μs3.91KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 b8rtz_fields AS a
LEFT JOIN `b8rtz_languages` AS l ON l.lang_code = a.language
LEFT JOIN b8rtz_users AS uc ON uc.id=a.checked_out
LEFT JOIN b8rtz_viewlevels AS ag ON ag.id = a.access
LEFT JOIN b8rtz_users AS ua ON ua.id = a.created_user_id
LEFT JOIN b8rtz_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `b8rtz_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 ASC
619μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `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 `b8rtz_categories` AS `s`
INNER JOIN `b8rtz_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`
192μs3.91KBParams/libraries/src/Categories/Categories.php:375CopySELECT 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 b8rtz_fields AS a
LEFT JOIN `b8rtz_languages` AS l ON l.lang_code = a.language
LEFT JOIN b8rtz_users AS uc ON uc.id=a.checked_out
LEFT JOIN b8rtz_viewlevels AS ag ON ag.id = a.access
LEFT JOIN b8rtz_users AS ua ON ua.id = a.created_user_id
LEFT JOIN b8rtz_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 ASC
611μs6.56KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `a`.`menutype`,`a`.`title`
FROM `b8rtz_menu_types` AS `a`
WHERE `a`.`client_id` = 0
68μs608B/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138CopySELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM b8rtz_menu AS m
WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0
ORDER BY m.lft
193μs1.05KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791CopySELECT * FROM b8rtz_acym_configuration
159μs8.56KB/administrator/components/com_acym/libraries/joomla/database.php:36CopySELECT * FROM b8rtz_acym_list WHERE type = 'standard'
84μs1.69KB/administrator/components/com_acym/libraries/joomla/database.php:36CopySELECT * FROM b8rtz_acym_field
72μs1.69KB/administrator/components/com_acym/libraries/joomla/database.php:36CopySELECT * FROM b8rtz_acym_form WHERE active = 1 AND type != 'shortcode'
68μs912B/administrator/components/com_acym/libraries/joomla/database.php:36CopySELECT 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 `b8rtz_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
105μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `value` FROM b8rtz_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
172μs536B/plugins/system/acymtriggers/acymtriggers.php:430CopySHOW TABLES
489μs3.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT * FROM b8rtz_acym_plugin
71μs1.53KB/administrator/components/com_acym/libraries/joomla/database.php:36CopySELECT * FROM b8rtz_acym_plugin
61μs1.53KB/administrator/components/com_acym/libraries/joomla/database.php:36CopySELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM b8rtz_usergroups AS `groups`
64μs1.02KB/administrator/components/com_acym/libraries/joomla/database.php:36CopySELECT `session_id`
FROM `b8rtz_session`
WHERE `session_id` = ?
87μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `b8rtz_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
116μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy