Latest Global Media News
True Crime
Reviews
This Week's TV & Streaming Premieres: 09/29 - 10/05/2024
Here is the complete rundown of TV and streaming television premieres for the week of Sunday,...
Load more...
Here is the complete rundown of TV and streaming television premieres for the week of Sunday,...
Joomla! Version | 4.4.4 |
PHP Version | 8.1.32 |
Identity | guest |
Response | 200 |
Template | ja_blockk |
Database |
|
1 x afterRenderComponent com_content (1.1MB) (21.39%) | 96.55ms |
1 x afterRenderRawModule mod_jacontentlisting (Top Lead) (429.56KB) (14.98%) | 67.60ms |
1 x afterRenderRawModule mod_articles_latest (Recent Post) (137.87KB) (9.88%) | 44.61ms |
1 x beforeRenderRawModule mod_menu (Newsletters) (322.29KB) (6.42%) | 28.97ms |
1 x afterRenderRawModule mod_jacontentlisting (Latest Global Media News) (214.37KB) (6.05%) | 27.29ms |
1 x afterInitialise (1.27MB) (5.41%) | 24.42ms |
1 x afterRenderRawModule mod_jacontentlisting (Latest U.S. Media News) (135.54KB) (5.17%) | 23.35ms |
1 x afterRenderRawModule mod_jacontentlisting (Press Releases) (165.78KB) (5.09%) | 22.99ms |
1 x afterRenderRawModule mod_jacontentlisting (True Crime ) (249.13KB) (4.71%) | 21.27ms |
1 x afterRenderRawModule mod_jacontentlisting (Video) (158.91KB) (4.6%) | 20.75ms |
1 x afterRenderRawModule mod_jacontentlisting (Photo Galleries) (119.1KB) (3.44%) | 15.55ms |
1 x afterRender (903.7KB) (3.03%) | 13.68ms |
1 x After Access::preloadPermissions (com_content) (2.97MB) (1.78%) | 8.05ms |
1 x Before Access::getAssetRules (id:8 name:com_content) (116.64KB) (1.71%) | 7.70ms |
1 x afterLoad (528.41KB) (0.86%) | 3.90ms |
1 x afterRoute (103.28KB) (0.84%) | 3.78ms |
1 x afterRenderRawModule mod_finder (Head Search) (82.1KB) (0.74%) | 3.32ms |
1 x afterRenderRawModule mod_menu (magazine-menu-3) (121.13KB) (0.58%) | 2.63ms |
1 x afterRenderRawModule mod_banners (Magazine Vertical ) (44.05KB) (0.57%) | 2.57ms |
1 x Before Access::preloadComponents (all components) (49.84KB) (0.44%) | 1.97ms |
1 x afterRenderRawModule mod_banners (Magazine Banner 1) (33.9KB) (0.33%) | 1.51ms |
1 x beforeRenderRawModule mod_menu (magazine-menu-3) (56.39KB) (0.21%) | 966μs |
1 x afterRenderRawModule mod_menu (Newsletters) (15.08KB) (0.21%) | 931μs |
1 x After Access::preloadComponents (all components) (110.03KB) (0.2%) | 909μs |
1 x beforeRenderComponent com_content (114.56KB) (0.17%) | 756μs |
1 x afterRenderRawModule mod_custom (Lead Info) (3.87KB) (0.08%) | 368μs |
1 x afterDispatch (66.28KB) (0.06%) | 253μs |
1 x afterRenderModule mod_menu (Newsletters) (3.17KB) (0.05%) | 238μs |
1 x afterRenderModule mod_jacontentlisting (Video) (17.34KB) (0.05%) | 237μs |
1 x afterRenderModule mod_jacontentlisting (Press Releases) (9.93KB) (0.05%) | 209μs |
1 x afterRenderModule mod_articles_latest (Recent Post) (9.93KB) (0.04%) | 191μs |
1 x Before Access::getAssetRules (id:892 name:com_content.category.97) (258.8KB) (0.04%) | 169μs |
1 x afterRenderModule mod_jacontentlisting (Latest U.S. Media News) (14.31KB) (0.04%) | 159μs |
1 x After Access::getAssetRules (id:892 name:com_content.category.97) (8.47KB) (0.04%) | 158μs |
1 x afterRenderModule mod_jacontentlisting (Latest Global Media News) (18.31KB) (0.03%) | 149μs |
1 x afterRenderModule mod_jacontentlisting (True Crime ) (18.3KB) (0.03%) | 137μs |
1 x afterRenderRawModule mod_menu (Other Content) (944B) (0.03%) | 130μs |
1 x afterRenderModule mod_jacontentlisting (Photo Galleries) (10.31KB) (0.03%) | 126μs |
1 x afterRenderModule mod_jacontentlisting (Top Lead) (18.3KB) (0.03%) | 123μs |
1 x afterRenderRawModule mod_menu (Off Canvas) (944B) (0.03%) | 121μs |
1 x afterRenderModule mod_banners (Magazine Vertical ) (2.39KB) (0.03%) | 117μs |
1 x afterRenderModule mod_finder (Head Search) (13.75KB) (0.03%) | 117μs |
1 x afterRenderModule mod_custom (Lead Info) (2.38KB) (0.02%) | 108μs |
1 x beforeRenderRawModule mod_jacontentlisting (Video) (4.94KB) (0.02%) | 105μs |
1 x afterRenderModule mod_custom ([Offcanvas] Custom banner) (2.32KB) (0.02%) | 100μs |
1 x afterRenderModule mod_custom ([Offcanvas] Social media) (2.93KB) (0.02%) | 98μs |
1 x afterRenderModule mod_menu (Other Content) (1.3KB) (0.02%) | 93μs |
1 x beforeRenderRawModule mod_jacontentlisting (Latest U.S. Media News) (24B) (0.02%) | 92μs |
1 x afterRenderRawModule mod_custom ([Offcanvas] Social media) (1.05KB) (0.02%) | 91μs |
1 x beforeRenderRawModule mod_jacontentlisting (Photo Galleries) (344B) (0.02%) | 88μs |
1 x afterRenderModule mod_banners (Magazine Banner 1) (2.39KB) (0.02%) | 87μs |
1 x beforeRenderRawModule mod_jacontentlisting (Latest Global Media News) (344B) (0.02%) | 85μs |
1 x afterRenderRawModule mod_custom ([Offcanvas] Custom banner) (976B) (0.02%) | 85μs |
1 x beforeRenderRawModule mod_jacontentlisting (True Crime ) (440B) (0.02%) | 82μs |
1 x beforeRenderRawModule mod_finder (Head Search) (1.06KB) (0.02%) | 82μs |
1 x beforeRenderRawModule mod_banners (Magazine Vertical ) (760B) (0.02%) | 81μs |
1 x afterRenderModule mod_menu (Off Canvas) (1.28KB) (0.02%) | 77μs |
1 x afterRenderModule mod_menu (magazine-menu-3) (6.28KB) (0.02%) | 77μs |
1 x beforeRenderRawModule mod_banners (Magazine Banner 1) (552B) (0.02%) | 69μs |
1 x beforeRenderRawModule mod_jacontentlisting (Top Lead) (280B) (0.01%) | 65μs |
1 x beforeRenderRawModule mod_jacontentlisting (Press Releases) (1.77KB) (0.01%) | 53μs |
1 x beforeRenderRawModule mod_custom (Lead Info) (2.23KB) (0.01%) | 51μs |
1 x beforeRenderRawModule mod_menu (Other Content) (1.4KB) (0.01%) | 48μs |
1 x beforeRenderRawModule mod_custom ([Offcanvas] Custom banner) (248B) (0.01%) | 45μs |
1 x beforeRenderRawModule mod_articles_latest (Recent Post) (584B) (0.01%) | 44μs |
1 x beforeRenderRawModule mod_custom ([Offcanvas] Social media) (24B) (0%) | 22μs |
1 x beforeRenderRawModule mod_menu (Off Canvas) (2.23KB) (0%) | 21μs |
1 x beforeRenderModule mod_articles_latest (Recent Post) (704B) (0%) | 14μs |
1 x Before Access::preloadPermissions (com_content) (3.91KB) (0%) | 12μs |
1 x beforeRenderModule mod_jacontentlisting (Press Releases) (736B) (0%) | 12μs |
1 x beforeRenderModule mod_jacontentlisting (Video) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_jacontentlisting (Latest U.S. Media News) (736B) (0%) | 11μs |
1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0%) | 10μs |
1 x beforeRenderModule mod_jacontentlisting (Photo Galleries) (736B) (0%) | 10μs |
1 x beforeRenderModule mod_jacontentlisting (Latest Global Media News) (736B) (0%) | 9μs |
1 x beforeRenderModule mod_jacontentlisting (Top Lead) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_banners (Magazine Vertical ) (720B) (0%) | 8μs |
1 x beforeRenderModule mod_jacontentlisting (True Crime ) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_menu (Newsletters) (720B) (0%) | 7μs |
1 x beforeRenderModule mod_banners (Magazine Banner 1) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_custom (Lead Info) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_menu (magazine-menu-3) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_finder (Head Search) (720B) (0%) | 5μs |
1 x beforeRenderModule mod_custom ([Offcanvas] Custom banner) (736B) (0%) | 5μs |
1 x beforeRenderModule mod_menu (Other Content) (720B) (0%) | 4μs |
1 x beforeRenderModule mod_custom ([Offcanvas] Social media) (736B) (0%) | 4μs |
1 x beforeRenderModule mod_menu (Off Canvas) (720B) (0%) | 3μs |
SELECT @@SESSION.sql_mode;
94μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `tvlfg_session`
WHERE `session_id` = ?
179μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `tvlfg_session`
WHERE `session_id` = :session_id LIMIT 1
78μs1.63KBParams/libraries/src/Session/MetadataManager.php:187CopyUPDATE `tvlfg_session`
SET `guest` = :guest
, `time` = :time
, `userid` = :user_id
, `username` = :username
, `client_id` = :client_id
WHERE `session_id` = :session_id
2.12ms992BParams/libraries/src/Session/MetadataManager.php:316CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `tvlfg_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
356μs2.19KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `tvlfg_viewlevels`
117μs976B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `tvlfg_usergroups` AS `a`
LEFT JOIN `tvlfg_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
203μs1.64KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `tvlfg_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
741μs3.8KBParams/libraries/src/Plugin/PluginHelper.php:294CopyUPDATE tvlfg_extensions
SET enabled=1
WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'
4.87ms1.3KB/plugins/system/jacontenttype/jacontenttype.php:62CopySELECT *
FROM `tvlfg_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
224μs2.17KB/libraries/src/Language/LanguageHelper.php:142CopySELECT *
FROM tvlfg_menu
WHERE alias ='' AND published=1
186μs4.08KB/plugins/system/t4/src/t4/MVC/Router/T4.php:352CopySELECT `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 `tvlfg_menu` AS `m`
LEFT JOIN `tvlfg_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`
563μs20.92KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `tvlfg_template_styles` AS `s`
LEFT JOIN `tvlfg_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` = 1
245μs1.16KB/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `tvlfg_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)
623μs7.75KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `tvlfg_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
3.82ms229.8KBParams/libraries/src/Access/Access.php:301CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
6.03ms5.36KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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`
FROM `tvlfg_content` AS `a`
LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`catid` = :categoryId OR `a`.`catid` IN (
SELECT `sub`.`id`
FROM `tvlfg_categories` AS `sub`
INNER JOIN `tvlfg_categories` AS `this` ON `sub`.`lft` > `this`.`lft` AND `sub`.`rgt` < `this`.`rgt`
WHERE `this`.`id` = :subCategoryId)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
ORDER BY c.lft, CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 168, 6
46.69ms76.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `tvlfg_contentitem_tag_map` AS `m`
INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6) AND `t`.`access` IN (:preparedArray7,:preparedArray8)
2.83ms6.12KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT COUNT(*)
FROM `tvlfg_content` AS `a`
LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`catid` = :categoryId OR `a`.`catid` IN (
SELECT `sub`.`id`
FROM `tvlfg_categories` AS `sub`
INNER JOIN `tvlfg_categories` AS `this` ON `sub`.`lft` > `this`.`lft` AND `sub`.`rgt` < `this`.`rgt`
WHERE `this`.`id` = :subCategoryId)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
16.45ms5.91KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:199CopySELECT `m`.`tag_id`,`t`.*
FROM `tvlfg_contentitem_tag_map` AS `m`
INNER JOIN `tvlfg_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)
2.01ms5.22KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
457μs5.19KBParams/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 tvlfg_fields AS a
LEFT JOIN `tvlfg_languages` AS l ON l.lang_code = a.language
LEFT JOIN tvlfg_users AS uc ON uc.id=a.checked_out
LEFT JOIN tvlfg_viewlevels AS ag ON ag.id = a.access
LEFT JOIN tvlfg_users AS ua ON ua.id = a.created_user_id
LEFT JOIN tvlfg_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `tvlfg_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 ASC
407μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT 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 tvlfg_fields AS a
LEFT JOIN `tvlfg_languages` AS l ON l.lang_code = a.language
LEFT JOIN tvlfg_users AS uc ON uc.id=a.checked_out
LEFT JOIN tvlfg_viewlevels AS ag ON ag.id = a.access
LEFT JOIN tvlfg_users AS ua ON ua.id = a.created_user_id
LEFT JOIN tvlfg_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
310μs5.31KBParams/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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
561μs5.38KBParams/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 tvlfg_fields AS a
LEFT JOIN `tvlfg_languages` AS l ON l.lang_code = a.language
LEFT JOIN tvlfg_users AS uc ON uc.id=a.checked_out
LEFT JOIN tvlfg_viewlevels AS ag ON ag.id = a.access
LEFT JOIN tvlfg_users AS ua ON ua.id = a.created_user_id
LEFT JOIN tvlfg_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `tvlfg_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
327μs6KBParams/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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
355μs5.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
326μs5.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
272μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
165μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
106μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
106μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
108μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
109μs11.84KB/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `tvlfg_modules` AS `m`
LEFT JOIN `tvlfg_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `tvlfg_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`
1.28ms18.56KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT `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`
FROM `tvlfg_content` AS `a`
LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`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,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19) 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.publish_up DESC LIMIT 5
36.53ms43.17KBParams/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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
666μs5.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
685μs5.22KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
580μs5.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
674μs5.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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.28ms5.22KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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`
FROM `tvlfg_content` AS `a`
LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`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`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)
ORDER BY a.created DESC LIMIT 3
2.73ms24.83KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `tvlfg_contentitem_tag_map` AS `m`
INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `t`.`access` IN (:preparedArray4,:preparedArray5)
2.63ms5.38KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
512μs5.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
438μs5.19KBParams/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 tvlfg_fields AS a
LEFT JOIN `tvlfg_languages` AS l ON l.lang_code = a.language
LEFT JOIN tvlfg_users AS uc ON uc.id=a.checked_out
LEFT JOIN tvlfg_viewlevels AS ag ON ag.id = a.access
LEFT JOIN tvlfg_users AS ua ON ua.id = a.created_user_id
LEFT JOIN tvlfg_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
503μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
133μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
120μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
113μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT `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`
FROM `tvlfg_content` AS `a`
LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE
(`a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition) AND
(`a`.`featured` = 0 OR (`fp`.`featured_up` IS NOT NULL AND `fp`.`featured_up` >= :featuredUp) OR (`fp`.`featured_down` IS NOT NULL AND `fp`.`featured_down` <= :featuredDown)) AND `a`.`catid` IN (:preparedArray5) 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 5
7.31ms25.55KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `tvlfg_contentitem_tag_map` AS `m`
INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5) AND `t`.`access` IN (:preparedArray6,:preparedArray7)
3.34ms5.42KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
700μs5.22KBParams/libraries/src/Categories/Categories.php:375CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
112μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
88μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
105μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
122μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
115μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT *
FROM `tvlfg_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)
338μs7.89KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69CopySELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `tvlfg_banners` AS `a`
LEFT JOIN `tvlfg_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1)
ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 1
373μs2.89KBParams/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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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.22ms5.2KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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.26ms5.2KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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`
FROM `tvlfg_content` AS `a`
LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE
(`a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition) AND
(`a`.`featured` = 0 OR (`fp`.`featured_up` IS NOT NULL AND `fp`.`featured_up` >= :featuredUp) OR (`fp`.`featured_down` IS NOT NULL AND `fp`.`featured_down` <= :featuredDown)) AND `a`.`catid` IN (:preparedArray5,: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 publish_up DESC LIMIT 7
1.53ms41.66KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `tvlfg_contentitem_tag_map` AS `m`
INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7) AND `t`.`access` IN (:preparedArray8,:preparedArray9)
3.31ms6.16KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
703μs5.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
709μs5.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
157μs8.84KB/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
103μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
107μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
116μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
116μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
111μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
110μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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.96ms5.2KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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`
FROM `tvlfg_content` AS `a`
LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE
(`a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition) AND
(`a`.`featured` = 0 OR (`fp`.`featured_up` IS NOT NULL AND `fp`.`featured_up` >= :featuredUp) OR (`fp`.`featured_down` IS NOT NULL AND `fp`.`featured_down` <= :featuredDown)) AND `a`.`catid` IN (:preparedArray5) 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 3
3.62ms25.52KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `tvlfg_contentitem_tag_map` AS `m`
INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3) AND `t`.`access` IN (:preparedArray4,:preparedArray5)
3.14ms5.36KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
679μs5.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
84μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
79μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
79μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
2.19ms5.22KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
3.15ms5.22KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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`
FROM `tvlfg_content` AS `a`
LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE
(`a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition) AND
(`a`.`featured` = 0 OR (`fp`.`featured_up` IS NOT NULL AND `fp`.`featured_up` >= :featuredUp) OR (`fp`.`featured_down` IS NOT NULL AND `fp`.`featured_down` <= :featuredDown)) AND `a`.`catid` IN (:preparedArray5,: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 publish_up DESC LIMIT 7
7.38ms109.66KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `tvlfg_contentitem_tag_map` AS `m`
INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7) AND `t`.`access` IN (:preparedArray8,:preparedArray9)
2.49ms6.22KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
461μs5.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
99μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
103μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
95μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
76μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
75μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
73μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
75μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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.99ms5.22KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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`
FROM `tvlfg_content` AS `a`
LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
WHERE
(`a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition) AND
(`a`.`featured` = 0 OR (`fp`.`featured_up` IS NOT NULL AND `fp`.`featured_up` >= :featuredUp) OR (`fp`.`featured_down` IS NOT NULL AND `fp`.`featured_down` <= :featuredDown)) AND `a`.`catid` IN (:preparedArray5) 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 5
8.41ms297.55KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `tvlfg_contentitem_tag_map` AS `m`
INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5) AND `t`.`access` IN (:preparedArray6,:preparedArray7)
2.8ms5.5KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
100μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
80μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
125μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
111μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
116μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT *
FROM `tvlfg_banners`
WHERE
(`reset` <= :date AND `reset` IS NOT NULL) AND
(`checked_out` IS NULL OR `checked_out` = :userId)
273μs7.89KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69CopySELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions`
FROM `tvlfg_banners` AS `a`
LEFT JOIN `tvlfg_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid`
WHERE
(
(
(`a`.`state` = 1) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND
(`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1)
ORDER BY `a`.`sticky` DESC, `a`.`ordering` LIMIT 5
385μs2.89KBParams/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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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.13ms5.2KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
456μs5.2KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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.63ms5.22KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
759μs5.22KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
694μs5.2KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
560μs5.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
2.52ms5.31KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1) AS `numitems`
FROM `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
595μs5.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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`
FROM `tvlfg_content` AS `a`
LEFT JOIN `tvlfg_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `tvlfg_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `tvlfg_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `tvlfg_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `tvlfg_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`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,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23) 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 8
40.51ms139.22KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `tvlfg_contentitem_tag_map` AS `m`
INNER JOIN `tvlfg_tags` AS `t` ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = :contentType AND `t`.`published` = 1 AND `m`.`content_item_id` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8) AND `t`.`access` IN (:preparedArray9,:preparedArray10)
2.61ms6.41KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
395μs5.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
369μs5.19KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
332μs5.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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`
600μs5.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT `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 `tvlfg_categories` AS `s`
INNER JOIN `tvlfg_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μs5.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
102μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
94μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
105μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
76μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
58μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
59μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 42 AND block = 0
251μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT username
FROM tvlfg_users
WHERE id = 51 AND block = 0
65μs856B/modules/mod_jacontentlisting/tmpl/elements/info_block/author.php:29CopySELECT `name`,`element`
FROM `tvlfg_extensions`
WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1
363μs976B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135CopySELECT `title`
FROM `tvlfg_finder_taxonomy`
WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)
150μs904B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314CopySELECT * FROM tvlfg_acym_configuration
272μs2.88KB/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT * FROM tvlfg_acym_list WHERE type = 'standard'
175μs2.28KB/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT * FROM tvlfg_acym_field
94μs2.31KB/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT * FROM tvlfg_acym_form WHERE active = 1 AND type != 'shortcode'
96μs17.2KB/administrator/components/com_acym/libraries/joomla/database.php:32CopySELECT 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 `tvlfg_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
154μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT `session_id`
FROM `tvlfg_session`
WHERE `session_id` = ?
198μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `tvlfg_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
1.01ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy