American Association of Higher Education
AAHEA Central
12110 Grandview Road
Grandview, MO 64030
Main Phone: 816.765.5551
E-Mail: admin@aahea.org
Alternative e-mail: DOCSRB@gmail.com
1-855-252-7622 (FAX)
ADMIN@AAHEA.ORG
Conventions, Meetings and Planning
AAHEA Blog and Bulletins Editor
Accreditation Department
Membership Department
Grants Department
President's Office
Vice President's Office
Job Listings
News Articles
American Association of Higher Education and Accreditation (AAHEA)
is one of the oldest exempt non-government organization in United States
working for enforcement of standards in formal education. Contact us for:
Joomla! Version | 5.2.5 |
PHP Version | 8.2.25 |
Identity | guest |
Response | 200 |
Template | as002031free |
Database |
|
1 x afterRender (528.49KB) (20.26%) | 55.77ms |
1 x Before Access::getAssetRules (id:1 name:root.1) (514.24KB) (16.34%) | 44.97ms |
1 x afterInitialise (1.23MB) (11.9%) | 32.77ms |
1 x afterRenderRawModule mod_articles_news (United Nations Profile) (89.54KB) (7.6%) | 20.93ms |
1 x afterRenderRawModule mod_articles_news (AAHEA Registered at OSAC) (104.3KB) (7.1%) | 19.55ms |
1 x afterRenderComponent com_content (254.48KB) (6.93%) | 19.09ms |
1 x afterRenderRawModule mod_articles_news (AAHEA - BQS) (42.77KB) (5.54%) | 15.26ms |
1 x afterRenderRawModule mod_articles_news (President's Awards) (83.62KB) (3.2%) | 8.81ms |
1 x beforeRenderRawModule mod_popupaholic (PopUp Aholic) (421.99KB) (2.66%) | 7.33ms |
1 x Before Access::preloadComponents (all components) (181.39KB) (1.59%) | 4.37ms |
1 x beforeRenderComponent com_content (162.04KB) (1.5%) | 4.12ms |
1 x After Access::preloadPermissions (com_content) (27.62KB) (1.46%) | 4.03ms |
1 x afterRenderRawModule mod_as_superfish_menu (AS Superfish Menu) (114.87KB) (1.45%) | 3.99ms |
1 x afterLoad (73.83KB) (1.37%) | 3.77ms |
1 x afterRoute (115.7KB) (1.35%) | 3.72ms |
1 x After Access::preloadComponents (all components) (115.95KB) (1.05%) | 2.90ms |
1 x afterRenderRawModule mod_custom (International University Bureau) (22.2KB) (0.93%) | 2.57ms |
1 x afterRenderRawModule mod_menu (Quick Links) (69.89KB) (0.8%) | 2.20ms |
1 x afterRenderRawModule mod_login (Member Login) (38.57KB) (0.72%) | 1.99ms |
1 x afterRenderRawModule mod_menu (Explore AAHEA) (164.11KB) (0.67%) | 1.84ms |
1 x afterRenderRawModule mod_djimageslider (AAHEA NEWS) (21.35KB) (0.65%) | 1.79ms |
1 x afterRenderRawModule mod_djimageslider (Main Slider) (4.34KB) (0.56%) | 1.53ms |
1 x afterRenderRawModule mod_search (Search) (12.51KB) (0.38%) | 1.04ms |
1 x afterRenderRawModule mod_popupaholic (PopUp Aholic) (10.55KB) (0.32%) | 890μs |
1 x afterRenderRawModule mod_custom (Contact AAHEA) (3.88KB) (0.2%) | 544μs |
1 x afterDispatch (2.58KB) (0.11%) | 301μs |
1 x afterRenderModule mod_popupaholic (PopUp Aholic) (8.05KB) (0.11%) | 293μs |
1 x afterRenderModule mod_as_superfish_menu (AS Superfish Menu) (6.31KB) (0.1%) | 267μs |
1 x afterRenderModule mod_articles_news (AAHEA - BQS) (2.67KB) (0.09%) | 260μs |
1 x afterRenderModule mod_menu (Quick Links) (3.61KB) (0.08%) | 222μs |
1 x afterRenderModule mod_articles_news (President's Awards) (3.31KB) (0.08%) | 219μs |
1 x afterRenderModule mod_custom (Contact AAHEA) (3.19KB) (0.07%) | 199μs |
1 x afterRenderModule mod_articles_news (AAHEA Registered at OSAC) (3.56KB) (0.07%) | 198μs |
1 x afterRenderModule mod_djimageslider (Main Slider) (6.64KB) (0.06%) | 169μs |
1 x afterRenderModule mod_articles_news (United Nations Profile) (3.31KB) (0.06%) | 164μs |
1 x afterRenderModule mod_login (Member Login) (4.96KB) (0.06%) | 163μs |
1 x After Access::getAssetRules (id:160 name:com_content.article.60) (7.38KB) (0.06%) | 162μs |
1 x afterRenderModule mod_custom (International University Bureau) (5.73KB) (0.06%) | 162μs |
1 x beforeRenderRawModule mod_djimageslider (Main Slider) (6.8KB) (0.06%) | 160μs |
1 x afterRenderModule mod_search (Search) (3.52KB) (0.06%) | 158μs |
1 x beforeRenderRawModule mod_search (Search) (1.77KB) (0.06%) | 152μs |
1 x beforeRenderRawModule mod_menu (Quick Links) (5.54KB) (0.05%) | 149μs |
1 x beforeRenderRawModule mod_as_superfish_menu (AS Superfish Menu) (1.68KB) (0.05%) | 144μs |
1 x afterRenderModule mod_menu (Explore AAHEA) (5.61KB) (0.05%) | 140μs |
1 x beforeRenderRawModule mod_custom (Top Message) (7.52KB) (0.05%) | 139μs |
1 x afterRenderModule mod_djimageslider (AAHEA NEWS) (5.14KB) (0.05%) | 130μs |
1 x afterRenderModule mod_custom (Other Departments) (3.19KB) (0.05%) | 127μs |
1 x afterRenderModule mod_custom (Top Message) (2.97KB) (0.05%) | 126μs |
1 x beforeRenderRawModule mod_menu (Explore AAHEA) (1.41KB) (0.05%) | 125μs |
1 x beforeRenderRawModule mod_custom (Advertise with us) (1.26KB) (0.04%) | 118μs |
1 x afterRenderModule mod_custom (Advertise with us) (2.66KB) (0.04%) | 113μs |
1 x beforeRenderRawModule mod_articles_news (AAHEA - BQS) (1.05KB) (0.04%) | 104μs |
1 x afterRenderModule mod_custom (AAHEA: Since 1870) (4.31KB) (0.03%) | 94μs |
1 x afterRenderRawModule mod_custom (Top Message) (976B) (0.03%) | 94μs |
1 x afterRenderModule mod_custom (AAHEA Fellowship Award) (3.19KB) (0.03%) | 74μs |
1 x beforeRenderRawModule mod_login (Member Login) (200B) (0.03%) | 73μs |
1 x afterRenderRawModule mod_custom (Advertise with us) (976B) (0.03%) | 71μs |
1 x afterRenderModule mod_custom (Chitika AdSense) (3.19KB) (0.03%) | 70μs |
1 x afterRenderModule mod_custom (President's Service Awards) (3.08KB) (0.02%) | 66μs |
1 x afterRenderRawModule mod_custom (Other Departments) (976B) (0.02%) | 63μs |
1 x beforeRenderRawModule mod_articles_news (AAHEA Registered at OSAC) (848B) (0.02%) | 63μs |
1 x After Access::getAssetRules (id:1 name:root.1) (6.02KB) (0.02%) | 59μs |
1 x afterRenderRawModule mod_custom (AAHEA: Since 1870) (976B) (0.02%) | 56μs |
1 x afterRenderRawModule mod_custom (Chitika AdSense) (912B) (0.02%) | 55μs |
1 x afterRenderRawModule mod_custom (AAHEA Fellowship Award) (992B) (0.02%) | 52μs |
1 x Before Access::getAssetRules (id:160 name:com_content.article.60) (1.15KB) (0.02%) | 50μs |
1 x beforeRenderRawModule mod_articles_news (United Nations Profile) (304B) (0.02%) | 46μs |
1 x Before Access::preloadPermissions (com_content) (424B) (0.02%) | 45μs |
1 x beforeRenderRawModule mod_articles_news (President's Awards) (1.08KB) (0.02%) | 44μs |
1 x beforeRenderRawModule mod_custom (Contact AAHEA) (2.61KB) (0.01%) | 40μs |
1 x beforeRenderRawModule mod_djimageslider (AAHEA NEWS) (7.59KB) (0.01%) | 39μs |
1 x afterRenderRawModule mod_custom (President's Service Awards) (1KB) (0.01%) | 37μs |
1 x beforeRenderRawModule mod_custom (Other Departments) (96B) (0.01%) | 34μs |
1 x beforeRenderRawModule mod_custom (International University Bureau) (6.64KB) (0.01%) | 31μs |
1 x beforeRenderRawModule mod_custom (AAHEA: Since 1870) (864B) (0.01%) | 30μs |
1 x beforeRenderRawModule mod_custom (AAHEA Fellowship Award) (2.59KB) (0.01%) | 29μs |
1 x beforeRenderRawModule mod_custom (Chitika AdSense) (752B) (0.01%) | 28μs |
1 x beforeRenderModule mod_articles_news (AAHEA - BQS) (704B) (0.01%) | 20μs |
1 x beforeRenderRawModule mod_custom (President's Service Awards) (176B) (0.01%) | 19μs |
1 x beforeRenderModule mod_as_superfish_menu (AS Superfish Menu) (736B) (0.01%) | 18μs |
1 x beforeRenderModule mod_articles_news (AAHEA Registered at OSAC) (720B) (0.01%) | 17μs |
1 x beforeRenderModule mod_articles_news (President's Awards) (720B) (0.01%) | 15μs |
1 x beforeRenderModule mod_search (Search) (704B) (0.01%) | 15μs |
1 x beforeRenderModule mod_popupaholic (PopUp Aholic) (720B) (0.01%) | 14μs |
1 x beforeRenderModule mod_menu (Quick Links) (720B) (0.01%) | 14μs |
1 x beforeRenderModule mod_articles_news (United Nations Profile) (720B) (0%) | 13μs |
1 x beforeRenderModule mod_djimageslider (Main Slider) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_menu (Explore AAHEA) (720B) (0%) | 11μs |
1 x beforeRenderModule mod_custom (International University Bureau) (736B) (0%) | 11μs |
1 x beforeRenderModule mod_custom (Contact AAHEA) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_login (Member Login) (720B) (0%) | 10μs |
1 x beforeRenderModule mod_djimageslider (AAHEA NEWS) (720B) (0%) | 9μs |
1 x beforeRenderModule mod_custom (Other Departments) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_custom (Advertise with us) (720B) (0%) | 6μs |
1 x beforeRenderModule mod_custom (AAHEA: Since 1870) (720B) (0%) | 5μs |
1 x beforeRenderModule mod_custom (Top Message) (720B) (0%) | 5μs |
1 x beforeRenderModule mod_custom (Chitika AdSense) (720B) (0%) | 4μs |
1 x beforeRenderModule mod_custom (AAHEA Fellowship Award) (720B) (0%) | 4μs |
1 x beforeRenderModule mod_custom (President's Service Awards) (736B) (0%) | 4μs |
SELECT @@SESSION.sql_mode;
157μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308CopySELECT `data`
FROM `teamnic_session`
WHERE `session_id` = ?
195μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250CopySELECT `session_id`
FROM `teamnic_session`
WHERE `session_id` = :session_id LIMIT 1
113μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `teamnic_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
213μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `teamnic_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
585μs1.61KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `teamnic_viewlevels`
153μs656B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `teamnic_usergroups` AS `a`
LEFT JOIN `teamnic_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
287μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `teamnic_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
1.41ms3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `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 `teamnic_menu` AS `m`
LEFT JOIN `teamnic_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`
951μs52.8KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT *
FROM `teamnic_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
307μs1.59KB/libraries/src/Language/LanguageHelper.php:177CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `teamnic_template_styles` AS `s`
LEFT JOIN `teamnic_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
495μs880B/administrator/components/com_templates/src/Model/StyleModel.php:775CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `teamnic_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)
1.27ms7.44KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `teamnic_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
3.05ms2.73KBParams/libraries/src/Access/Access.php:301CopySHOW FULL COLUMNS FROM `teamnic_content`
1.23ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587CopyUPDATE `teamnic_content`
SET `hits` = (`hits` + 1)
WHERE `id` = '60'
497μs48B/libraries/src/Table/Table.php:1348CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count`
FROM `teamnic_content` AS `a`
INNER JOIN `teamnic_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `teamnic_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `teamnic_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `teamnic_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `teamnic_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)
768μs6.12KBParams/components/com_content/src/Model/ArticleModel.php:215CopySELECT `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 `teamnic_categories` AS `s`
INNER JOIN `teamnic_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`
719μs5.17KBParams/libraries/src/Categories/Categories.php:375CopySELECT `m`.`tag_id`,`t`.*
FROM `teamnic_contentitem_tag_map` AS `m`
INNER JOIN `teamnic_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)
3.44ms3.97KBParams/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 `teamnic_categories` AS `s`
INNER JOIN `teamnic_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`
850μs3.92KBParams/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 teamnic_fields AS a
LEFT JOIN `teamnic_languages` AS l ON l.lang_code = a.language
LEFT JOIN teamnic_users AS uc ON uc.id=a.checked_out
LEFT JOIN teamnic_viewlevels AS ag ON ag.id = a.access
LEFT JOIN teamnic_users AS ua ON ua.id = a.created_user_id
LEFT JOIN teamnic_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `teamnic_fields_categories` AS fc ON fc.field_id = a.id
WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC
1.11ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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 `teamnic_categories` AS `s`
INNER JOIN `teamnic_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`
768μs3.92KBParams/libraries/src/Categories/Categories.php:375CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `teamnic_modules` AS `m`
LEFT JOIN `teamnic_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `teamnic_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.47ms18.19KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT manifest_cache FROM teamnic_extensions WHERE element='mod_djimageslider' LIMIT 1
245μs536B/modules/mod_djimageslider/mod_djimageslider.php:97CopySELECT 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 teamnic_fields AS a
LEFT JOIN `teamnic_languages` AS l ON l.lang_code = a.language
LEFT JOIN teamnic_users AS uc ON uc.id=a.checked_out
LEFT JOIN teamnic_viewlevels AS ag ON ag.id = a.access
LEFT JOIN teamnic_users AS ua ON ua.id = a.created_user_id
LEFT JOIN teamnic_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
1.54ms4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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`,`fp`.`ordering`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count`
FROM `teamnic_content` AS `a`
LEFT JOIN `teamnic_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `teamnic_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `teamnic_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `teamnic_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `teamnic_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `teamnic_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` <> :articleId AND `a`.`catid` IN (:preparedArray5) 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 1
13.06ms7.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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`,`fp`.`ordering`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count`
FROM `teamnic_content` AS `a`
LEFT JOIN `teamnic_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `teamnic_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `teamnic_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `teamnic_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `teamnic_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `teamnic_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` <> :articleId AND `a`.`catid` IN (:preparedArray5) 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 1
1.15ms7.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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 `teamnic_categories` AS `s`
INNER JOIN `teamnic_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`
613μs3.92KBParams/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 teamnic_fields AS a
LEFT JOIN `teamnic_languages` AS l ON l.lang_code = a.language
LEFT JOIN teamnic_users AS uc ON uc.id=a.checked_out
LEFT JOIN teamnic_viewlevels AS ag ON ag.id = a.access
LEFT JOIN teamnic_users AS ua ON ua.id = a.created_user_id
LEFT JOIN teamnic_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
5.47ms4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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 `teamnic_categories` AS `s`
INNER JOIN `teamnic_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`
681μs19.92KBParams/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 teamnic_fields AS a
LEFT JOIN `teamnic_languages` AS l ON l.lang_code = a.language
LEFT JOIN teamnic_users AS uc ON uc.id=a.checked_out
LEFT JOIN teamnic_viewlevels AS ag ON ag.id = a.access
LEFT JOIN teamnic_users AS ua ON ua.id = a.created_user_id
LEFT JOIN teamnic_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `teamnic_fields_categories` AS fc ON fc.field_id = a.id
WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC
1.02ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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`,`fp`.`ordering`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count`
FROM `teamnic_content` AS `a`
LEFT JOIN `teamnic_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `teamnic_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `teamnic_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `teamnic_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `teamnic_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `teamnic_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` <> :articleId AND `a`.`catid` IN (:preparedArray5) 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 1
1.07ms7.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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 `teamnic_categories` AS `s`
INNER JOIN `teamnic_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`
562μs3.92KBParams/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 `teamnic_categories` AS `s`
INNER JOIN `teamnic_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`
12.26ms6.42KBParams/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 teamnic_fields AS a
LEFT JOIN `teamnic_languages` AS l ON l.lang_code = a.language
LEFT JOIN teamnic_users AS uc ON uc.id=a.checked_out
LEFT JOIN teamnic_viewlevels AS ag ON ag.id = a.access
LEFT JOIN teamnic_users AS ua ON ua.id = a.created_user_id
LEFT JOIN teamnic_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `teamnic_fields_categories` AS fc ON fc.field_id = a.id
WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC
1.36ms4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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`,`fp`.`ordering`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count`
FROM `teamnic_content` AS `a`
LEFT JOIN `teamnic_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `teamnic_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `teamnic_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `teamnic_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `teamnic_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `teamnic_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` <> :articleId AND `a`.`catid` IN (:preparedArray5) 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 1
1.04ms23.05KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT `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 `teamnic_categories` AS `s`
INNER JOIN `teamnic_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`
575μs3.92KBParams/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 `teamnic_categories` AS `s`
INNER JOIN `teamnic_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`
539μs3.92KBParams/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 teamnic_fields AS a
LEFT JOIN `teamnic_languages` AS l ON l.lang_code = a.language
LEFT JOIN teamnic_users AS uc ON uc.id=a.checked_out
LEFT JOIN teamnic_viewlevels AS ag ON ag.id = a.access
LEFT JOIN teamnic_users AS ua ON ua.id = a.created_user_id
LEFT JOIN teamnic_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `teamnic_fields_categories` AS fc ON fc.field_id = a.id
WHERE
(
(`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND
(`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND
(`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform
ORDER BY a.ordering ASC
971μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164CopySELECT manifest_cache FROM teamnic_extensions WHERE element='mod_djimageslider' LIMIT 1
259μs536B/modules/mod_djimageslider/mod_djimageslider.php:97CopySELECT *
FROM `teamnic_schemaorg`
WHERE `itemId` = :itemId AND `context` = :context
1.81ms1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count`
FROM `teamnic_content` AS `a`
INNER JOIN `teamnic_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `teamnic_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `teamnic_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `teamnic_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `teamnic_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)
870μs6.17KBParams/components/com_content/src/Model/ArticleModel.php:215CopySELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count`
FROM `teamnic_content` AS `a`
INNER JOIN `teamnic_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `teamnic_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `teamnic_users` AS `u` ON `u`.`id` = `a`.`created_by`
LEFT JOIN `teamnic_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `teamnic_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE
(
(`a`.`id` = :pk AND `c`.`published` > 0) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)
598μs6.17KBParams/components/com_content/src/Model/ArticleModel.php:215CopySELECT 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 `teamnic_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
281μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517CopySELECT `session_id`
FROM `teamnic_session`
WHERE `session_id` = ?
236μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277CopyUPDATE `teamnic_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
431μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy