PRINT ISSN 1998-3425
PRINT ISSN 1998-3425
Paper |
Download |
EDITORIALDr. A.K.Srivastava Editor-in-Chief |
Download Paper HOT |
UAE: Financial Development and Economic GrowthAlexander Mosesov, Associate Professor, Skyline College Sharjah, UAE Nizar Mousa Farih Sahawneh, Lecturer, Skyline College Sharjah, UAE |
Download Paper HOT |
The Persuasive Power of Country of Origin on Consumer Value Perception: A Control Theoretic PerspectiveMd. Humayun Kabir Chowdhury, Associate Professor, Department of Marketing, Rajshahi University, Rajshahi 6205, BangladeshABSTRACT The primary goal of this study is to analyze consumer perceptions of country of origin in relation to the attentional cognitive structure...Read more Suggested citation: Chowdhury, M. H. K. (2005). The Persuasive Power of Country of Origin on Consumer Value Perception: A Control Theoretic Perspective. Skyline Business Journal, Volume 1, No. 2, pp 6-12. |
Download Paper HOT |
Globalization and Higher Education: Emerging HR Challenges and Benchmarking Issues before Universities in 21st CenturyVijay Kumar Gudep, Lecturer, Business and Management Studies, PO Box 1797, Skyline College Sharjah, UAEABSTRACT The complexion of Higher Education sector underwent a sea change in the last two decades due to Globalization. Higher education, science, and technology have always been international endeavors, but have…Read more Keywords: Globalization, virtual education, educational franchising, Electronic Document Management (EDM), General Agreement on Trade in Services (GATS), Business Process Re-engineering (BPR) and benchmarking. Suggested citation: Gudep, V. K. (2005). Globalization and Higher Education: Emerging HR Challenges and Benchmarking Issues before Universities in 21st Century. Skyline Business Journal, Volume 1, No. 2, pp 13-18. |
Download Paper HOT |
A New Commit Processing Under Distributed Real Time Database SystemsY. Jayanta Singh, Department of Computer Studies, Skyline College, P.O.Box 1797, Sharjah, UAE Vikas Humbe, Research Scholar, Department of Computer Science and I.T. Dr. Babasaheb Ambedkar Marathwada University, Aurangabad – 431004. (M.S), India S. C. Mehrotra, Department of Computer Science and I.T. Dr. Babasaheb Ambedkar Marathwada University, Aurangabad – 431004. (M.S). India.
Keywords: Real time database system, distributed sites, deadlines of transactions |
Download Paper HOT |
On the Empirical Evidence of Price Stability and Money Supply Relation in the United Arab EmiratesAtul Deshpande, Lecturer, Skyline College, Sharjah, UAE |
Download Paper HOT |
A SCENT-SATIONAL STUDY An Empirical Study on the Purchase Behaviour of Employed and Unemployed Women of Dubai and Sharjah Regions, U.A.E., towards PerfumesK. Shivakumar, Associate Professor, Department of Marketing Studies, Skyline College, Sharjah, U.A.E Sumathi Natarajan, Adjunct Faculty, Skyline College, Sharjah, UAE Rengasamy Elango, Assistant Professor, Department of Business and Management Studies, Skyline College, Sharjah, U.A.E |
Download Paper HOT |
Personality Correlates of Time Management: A Quantitative Study of Time Behaviour of Indian ExecutivesBeena S. Saji, Assistant Professor, Skyline College, Sharjah, UAE Suggested citation: Saji, B. S. (2005). Personality Correlates of Time Management: A Quantitative Study of Time Behaviour of Indian Executives. Skyline Business Journal, Volume 1, No. 2, pp 39-44. |
Download Paper HOT |
Shared Secret Authentication Protocol for Client and Server in Internet Banking ApplicationsHasan Al-Saedy, Associate Professor, Skyline College, Sharjah, UAE
Suggested citation: Al-Saedy, H. (2005). Shared Secret Authentication Protocol for Client and Server in Internet Banking Applications. Skyline Business Journal, Volume 1, No. 2, pp 45-46. |
Download Paper HOT |
Issues and Challenges in the New Generation Customer Relationship Management (CRM): Coping with Unreliable DataVijaya Kumar Gudep, Lecturer, Business & Management, P.O. Box: 1797, Skyline College, Sharjah, UAE SK Pemmaraju, Modern College of Business and Science, P.O. Box: 100, Al-Khwair, Sultanate of Oman
Suggested citation: Gudep, V. K., & Pemmaraju, S.K. (2005). Issues and Challenges in the New Generation Customer Relationship Management (CRM): Coping with Unreliable Data. Skyline Business Journal, Volume 1, No. 2, pp 47-51. |
Download Paper HOT |
Recent Trends in Marketing of Banking ServicesP. Mariappan, Assistant Professor, Department of Management Studies, MAHE (Dubai Campus), Knowedge Village, Dubai
Suggested citation: Mariappan, P. (2005). Recent Trends in Marketing of Banking Services. Skyline Business Journal, Volume 1, No. 2, pp 52-54. |
Download Paper HOT |
Information Technology (IT) and Decision Making: Impact of IT-Assisted Group Decision Support Systems (GDSS) on Efficiency and Effectiveness of Group DecisionsManuel Fernandez, Lecturer, Skyline College, Sharjah, UAE A. Nelson, Selection Grade Lecturer in Commerce Government College, Kollam, Kerala, India
Suggested citation: Fernandez, M., & Nelson, A. (2005). Information Technology (IT) and Decision Making: Impact of IT-Assisted Group Decision Support Systems (GDSS) on Efficiency and Effectiveness of Group Decisions. Skyline Business Journal, Volume 1, No. 2, pp 55-58. |
Download Paper HOT |
Knowledge, Property, and System Dynamics of Technological ChangeGhazi Abdul Razzak Alnakkash, Associate Professor, Skyline College, Sharjah, UAE
Suggested citation: Alnakkash, G. A. R. (2005). “Knowledge, Property, and System Dynamics of Technological Change”. Skyline Business Journal, Volume 1, No. 2, pp 59-64. |
Download Paper HOT |
Rational System of BudgetingMukdad M. Ibrahim, Assistant Professor, Skyline College, Sharjah, UAE
Suggested citation: Ibrahim, M. M. (2005). Rational System of Budgeting. Skyline Business Journal, Volume 1, No. 2, pp 65-68. |
Download Paper HOT |
Excess Management, Managed and ModeratorAmin Zehra Rizvi, Assistant Professor, Department of General Education, Skyline College, Sharjah, UAE
Suggested citation: Rizvi, A. Z. (2005). Excess Management, Managed and Moderator. Skyline Business Journal, Volume 1, No. 2, pp 69-71. |
Download Paper HOT |
Issues in Institution BuildingM.Selvam, Professor in International Business and Commerce, Alagappa University, Karaikudi, India
Suggested citation: Selvam, M. (2005). Issues in Institution Building. Skyline Business Journal, Volume 1, No. 2, pp 72-76. |
Download Paper HOT |
Will the Electronic Journals Replace the Paper-print Version in Lebanon?Abdul Razzak Charbaji, School of Business and Economics, Lebanese University
Suggested citation: Charbaji, A. R. (2005). Will the Electronic Journals Replace the Paper-print Version in Lebanon?. Skyline Business Journal, Volume 1, No. 2, pp 77-84. |
Download Paper HOT |
Joomla! Version | 4.4.6 |
PHP Version | 8.3.14 |
Identity | guest |
Response | 200 |
Template | infetech |
Database |
|
1 x afterRenderRawModule mod_sppagebuilder (logo bottom) (7.12MB) (22.74%) | 72.50ms |
1 x afterInitialise (9.28MB) (20.64%) | 65.79ms |
1 x Before Access::getAssetRules (id:1 name:root.1) (3.35MB) (8.81%) | 28.09ms |
1 x afterLoad (4.03MB) (6.77%) | 21.60ms |
1 x Before Access::getAssetRules (id:809 name:com_jdownloads.download.201) (607.74KB) (5.68%) | 18.11ms |
1 x beforeRenderRawModule mod_sppagebuilder (logo bottom) (1.41MB) (5.38%) | 17.16ms |
1 x beforeRenderRawModule mod_search (search) (188.22KB) (5.02%) | 16.02ms |
1 x afterRender (528.57KB) (4.24%) | 13.52ms |
1 x afterRoute (1.03MB) (3.22%) | 10.27ms |
1 x Before Access::preloadComponents (all components) (1.27MB) (1.89%) | 6.01ms |
1 x afterRenderComponent com_content (163.52KB) (1.2%) | 3.82ms |
1 x beforeRenderComponent com_content (409.8KB) (0.83%) | 2.63ms |
1 x afterDispatch (315.07KB) (0.81%) | 2.58ms |
1 x Before Access::getAssetRules (id:8 name:com_content) (365.34KB) (0.78%) | 2.48ms |
1 x afterRenderRawModule mod_search (search) (87.13KB) (0.76%) | 2.42ms |
1 x Before Access::getAssetRules (id:810 name:com_jdownloads.download.202) (97.8KB) (0.62%) | 1.98ms |
1 x Before Access::getAssetRules (id:811 name:com_jdownloads.download.203) (78.03KB) (0.59%) | 1.88ms |
1 x Before Access::getAssetRules (id:812 name:com_jdownloads.download.204) (86.03KB) (0.59%) | 1.87ms |
1 x afterRenderModule mod_sppagebuilder (logo bottom) (75.25KB) (0.59%) | 1.87ms |
1 x Before Access::getAssetRules (id:817 name:com_jdownloads.download.209) (78.03KB) (0.58%) | 1.86ms |
1 x Before Access::getAssetRules (id:821 name:com_jdownloads.download.213) (78.66KB) (0.58%) | 1.86ms |
1 x Before Access::getAssetRules (id:813 name:com_jdownloads.download.205) (78.34KB) (0.58%) | 1.86ms |
1 x Before Access::getAssetRules (id:816 name:com_jdownloads.download.208) (90.03KB) (0.58%) | 1.86ms |
1 x Before Access::getAssetRules (id:820 name:com_jdownloads.download.212) (102.53KB) (0.58%) | 1.85ms |
1 x Before Access::getAssetRules (id:819 name:com_jdownloads.download.211) (78.03KB) (0.58%) | 1.85ms |
1 x Before Access::getAssetRules (id:815 name:com_jdownloads.download.207) (78.66KB) (0.58%) | 1.85ms |
1 x Before Access::getAssetRules (id:814 name:com_jdownloads.download.206) (78.03KB) (0.58%) | 1.85ms |
1 x Before Access::getAssetRules (id:818 name:com_jdownloads.download.210) (78.66KB) (0.58%) | 1.84ms |
1 x Before Access::getAssetRules (id:822 name:com_jdownloads.download.214) (78.03KB) (0.58%) | 1.84ms |
1 x Before Access::getAssetRules (id:823 name:com_jdownloads.download.215) (79.28KB) (0.58%) | 1.84ms |
1 x Before Access::getAssetRules (id:824 name:com_jdownloads.download.216) (78.03KB) (0.58%) | 1.84ms |
1 x afterRenderModule mod_sppagebuilder (logo header) (46.79KB) (0.48%) | 1.53ms |
1 x afterRenderRawModule mod_sppagebuilder (logo header) (148.97KB) (0.28%) | 883μs |
1 x After Access::preloadComponents (all components) (104.34KB) (0.25%) | 811μs |
1 x After Access::preloadPermissions (com_jdownloads) (186.14KB) (0.2%) | 642μs |
1 x After Access::preloadPermissions (com_content) (168.07KB) (0.2%) | 638μs |
1 x After Access::getAssetRules (id:833 name:com_content.category.39) (25.49KB) (0.08%) | 263μs |
1 x afterRenderModule mod_search (search) (3.09KB) (0.08%) | 256μs |
1 x beforeRenderRawModule mod_sppagebuilder (logo header) (1.12KB) (0.02%) | 51μs |
1 x Before Access::preloadPermissions (com_jdownloads) (7.76KB) (0.01%) | 38μs |
1 x Before Access::getAssetRules (id:304 name:com_jdownloads) (1.48KB) (0.01%) | 36μs |
1 x After Access::getAssetRules (id:1 name:root.1) (6.02KB) (0.01%) | 19μs |
1 x Before Access::getAssetRules (id:808 name:com_jdownloads.download.200) (7.41KB) (0.01%) | 18μs |
1 x After Access::getAssetRules (id:304 name:com_jdownloads) (6.34KB) (0%) | 14μs |
1 x Before Access::getAssetRules (id:833 name:com_content.category.39) (10.65KB) (0%) | 13μs |
1 x Before Access::preloadPermissions (com_content) (424B) (0%) | 10μs |
1 x After Access::getAssetRules (id:809 name:com_jdownloads.download.201) (1.3KB) (0%) | 8μs |
1 x After Access::getAssetRules (id:8 name:com_content) (1.28KB) (0%) | 7μs |
1 x After Access::getAssetRules (id:810 name:com_jdownloads.download.202) (1.3KB) (0%) | 7μs |
1 x After Access::getAssetRules (id:812 name:com_jdownloads.download.204) (1.61KB) (0%) | 7μs |
1 x After Access::getAssetRules (id:815 name:com_jdownloads.download.207) (2.55KB) (0%) | 7μs |
1 x After Access::getAssetRules (id:817 name:com_jdownloads.download.209) (1.3KB) (0%) | 7μs |
1 x After Access::getAssetRules (id:818 name:com_jdownloads.download.210) (1.3KB) (0%) | 7μs |
1 x After Access::getAssetRules (id:819 name:com_jdownloads.download.211) (1.3KB) (0%) | 7μs |
1 x After Access::getAssetRules (id:824 name:com_jdownloads.download.216) (1.3KB) (0%) | 7μs |
1 x After Access::getAssetRules (id:811 name:com_jdownloads.download.203) (1.3KB) (0%) | 7μs |
1 x After Access::getAssetRules (id:821 name:com_jdownloads.download.213) (1.3KB) (0%) | 7μs |
1 x After Access::getAssetRules (id:822 name:com_jdownloads.download.214) (1.3KB) (0%) | 7μs |
1 x After Access::getAssetRules (id:823 name:com_jdownloads.download.215) (1.3KB) (0%) | 7μs |
1 x beforeRenderModule mod_sppagebuilder (logo bottom) (720B) (0%) | 6μs |
1 x After Access::getAssetRules (id:813 name:com_jdownloads.download.205) (1.3KB) (0%) | 6μs |
1 x After Access::getAssetRules (id:814 name:com_jdownloads.download.206) (1.3KB) (0%) | 6μs |
1 x After Access::getAssetRules (id:816 name:com_jdownloads.download.208) (1.3KB) (0%) | 6μs |
1 x After Access::getAssetRules (id:820 name:com_jdownloads.download.212) (1.92KB) (0%) | 6μs |
1 x After Access::getAssetRules (id:808 name:com_jdownloads.download.200) (1.3KB) (0%) | 5μs |
1 x beforeRenderModule mod_sppagebuilder (logo header) (720B) (0%) | 4μs |
1 x beforeRenderModule mod_search (search) (704B) (0%) | 3μs |
SELECT @@SESSION.sql_mode;
50μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334CopySELECT `data`
FROM `xc0xt_session`
WHERE `session_id` = ?
116μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261CopySELECT `session_id`
FROM `xc0xt_session`
WHERE `session_id` = :session_id LIMIT 1
49μs1.3KBParams/libraries/src/Session/MetadataManager.php:187CopyINSERT INTO `xc0xt_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(:session_id, :guest, :time, :user_id, :username, :client_id)
545μs944BParams/libraries/src/Session/MetadataManager.php:260CopySELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `xc0xt_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
246μs17.61KB/libraries/src/Component/ComponentHelper.php:399CopySELECT `id`,`rules`
FROM `xc0xt_viewlevels`
68μs656B/libraries/src/Access/Access.php:955CopySELECT `b`.`id`
FROM `xc0xt_usergroups` AS `a`
LEFT JOIN `xc0xt_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt`
WHERE `a`.`id` = :guest
115μs1.33KBParams/libraries/src/Access/Access.php:868CopySELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM `xc0xt_extensions`
WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2)
ORDER BY `ordering`
428μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294CopySELECT `path`
FROM xc0xt_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'
59μs1.13KB/administrator/components/com_rsfirewall/helpers/config.php:56CopySELECT `file`
FROM xc0xt_rsfirewall_hashes
WHERE `type`='protect'
66μs520B/administrator/components/com_rsfirewall/helpers/config.php:63CopySELECT *
FROM xc0xt_rsfirewall_configuration
93μs1.88KB/administrator/components/com_rsfirewall/helpers/config.php:71CopySHOW FULL COLUMNS FROM `xc0xt_rsfirewall_logs`
719μs1.42KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625CopySELECT *
FROM `xc0xt_languages`
WHERE `published` = 1
ORDER BY `ordering` ASC
125μs1.63KB/libraries/src/Language/LanguageHelper.php:142CopySELECT `element`,`name`,`client_id`,`extension_id`
FROM `xc0xt_extensions`
WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1
103μs736B/libraries/src/Language/LanguageHelper.php:213CopySELECT `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 `xc0xt_menu` AS `m`
LEFT JOIN `xc0xt_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`
519μs100.3KBParams/libraries/src/Menu/SiteMenu.php:166CopySELECT *
FROM xc0xt_rsform_config
107μs1KB/administrator/components/com_rsform/helpers/config.php:52CopyUPDATE xc0xt_rsform_config
SET `SettingValue`='1736235558'
WHERE `SettingName`='deleteafter.last_run'
84μs1.3KB/administrator/components/com_rsform/helpers/config.php:92CopySELECT `FormId`,`DeleteSubmissionsAfter`
FROM `xc0xt_rsform_forms`
WHERE `DeleteSubmissionsAfter` > '0'
79μs528B/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:53CopySELECT *
FROM xc0xt_rsfirewall_hashes
WHERE (`type`='4.4.6' OR `type`='protect') AND (`flag`!='C' OR `flag` IS NULL)
88μs816B/plugins/system/rsfirewall/rsfirewall.php:1078CopySELECT *
FROM xc0xt_rsfirewall_snapshots
WHERE `type`='protect'
61μs688B/administrator/components/com_rsfirewall/helpers/snapshot.php:49CopySELECT `ip`,`reason`
FROM xc0xt_rsfirewall_lists
WHERE (`ip`='3.147.68.82' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'
85μs576B/plugins/system/rsfirewall/rsfirewall.php:172CopySELECT `ip`,`reason`
FROM xc0xt_rsfirewall_lists
WHERE (`ip`='3.147.68.82' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'
53μs576B/plugins/system/rsfirewall/rsfirewall.php:172CopySELECT *
FROM xc0xt_rsfirewall_exceptions
WHERE `published`='1'
61μs1.42KB/plugins/system/rsfirewall/rsfirewall.php:729CopySELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent`
FROM `xc0xt_template_styles` AS `s`
LEFT JOIN `xc0xt_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
342μs40.83KB/administrator/components/com_templates/src/Model/StyleModel.php:773CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
78μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySHOW TABLES
749μs2.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `xc0xt_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)
609μs7.31KBParams/libraries/src/Access/Access.php:357CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `xc0xt_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
384μs9.48KBParams/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 `xc0xt_content` AS `i`
WHERE `i`.`catid` = `c`.`id` AND `i`.`state` = 1 AND `i`.`language` IN (:preparedArray3,:preparedArray4)) AS `numitems`
FROM `xc0xt_categories` AS `s`
INNER JOIN `xc0xt_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray1,:preparedArray2)) 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`
532μs52KBParams/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`,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 `xc0xt_content` AS `a`
LEFT JOIN `xc0xt_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `xc0xt_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `xc0xt_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `xc0xt_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `xc0xt_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `xc0xt_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6)
ORDER BY c.lft, CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END DESC , a.created
667μs71.34KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`tag_id`,`m`.`content_item_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18) AND `t`.`access` IN (:preparedArray19,:preparedArray20)
195μs6.28KBParams/libraries/src/Helper/TagsHelper.php:448CopySELECT COUNT(*)
FROM `xc0xt_content` AS `a`
LEFT JOIN `xc0xt_categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `xc0xt_users` AS `ua` ON `ua`.`id` = `a`.`created_by`
LEFT JOIN `xc0xt_users` AS `uam` ON `uam`.`id` = `a`.`modified_by`
LEFT JOIN `xc0xt_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
LEFT JOIN `xc0xt_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id`
LEFT JOIN `xc0xt_content_rating` AS `v` ON `a`.`id` = `v`.`content_id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` = :categoryId AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`language` IN (:preparedArray5,:preparedArray6)
353μs6.09KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:199CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
143μs6.47KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT id, link from xc0xt_menu WHERE link LIKE 'index.php?option=com_jdownloads&view=category%' AND published = 1
149μs576B/plugins/content/jdownloads/jdownloads.php:76CopySELECT id, link, published, access, language FROM xc0xt_menu WHERE (link LIKE 'index.php?option=com_jdownloads%') AND published = 1 AND client_id = 0 AND language = 'en-gb' AND access IN (1,5)
104μs752B/components/com_jdownloads/src/Helper/JDHelper.php:246CopySELECT id, link, published, access, language FROM xc0xt_menu WHERE (link LIKE 'index.php?option=com_jdownloads%') AND published = 1 AND client_id = 0 AND access IN (1,5)
194μs768B/components/com_jdownloads/src/Helper/JDHelper.php:251CopySELECT id FROM xc0xt_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND language = 'en-gb' AND access IN (1,5)
76μs520B/components/com_jdownloads/src/Helper/JDHelper.php:304CopySELECT id FROM xc0xt_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND access IN (1,5)
163μs536B/components/com_jdownloads/src/Helper/JDHelper.php:309CopySELECT id FROM xc0xt_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND language = 'en-gb' AND access IN (1,5)
59μs520B/components/com_jdownloads/src/Helper/JDHelper.php:358CopySELECT id FROM xc0xt_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND access IN (1,5)
137μs536B/components/com_jdownloads/src/Helper/JDHelper.php:363CopySELECT id FROM xc0xt_menu WHERE link = 'index.php?option=com_jdownloads&view=search' AND published = 1 AND client_id = 0 AND access IN (1,5)
119μs520B/components/com_jdownloads/src/Helper/JDHelper.php:377CopySELECT id FROM xc0xt_menu WHERE link = 'index.php?option=com_jdownloads&view=form&layout=edit' AND published = 1 AND client_id = 0 AND access IN (1,5)
117μs520B/components/com_jdownloads/src/Helper/JDHelper.php:382CopySELECT id, link from xc0xt_menu WHERE link LIKE 'index.php?option=com_jdownloads&view=category&catid%' AND published = 1 AND access IN (1,5)
102μs576B/components/com_jdownloads/src/Helper/JDHelper.php:414CopySELECT `enabled`
FROM `xc0xt_extensions`
WHERE
(`element`='com_sppagebuilder') AND
(`type`='component')
101μs536B/plugins/content/sppagebuilder/sppagebuilder.php:218CopySELECT `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 `xc0xt_categories` AS `s`
INNER JOIN `xc0xt_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
338μs51.97KBParams/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 xc0xt_fields AS a
LEFT JOIN `xc0xt_languages` AS l ON l.lang_code = a.language
LEFT JOIN xc0xt_users AS uc ON uc.id=a.checked_out
LEFT JOIN xc0xt_viewlevels AS ag ON ag.id = a.access
LEFT JOIN xc0xt_users AS ua ON ua.id = a.created_user_id
LEFT JOIN xc0xt_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `xc0xt_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
332μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
83μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
60μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
56μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
52μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT 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 xc0xt_fields AS a
LEFT JOIN `xc0xt_languages` AS l ON l.lang_code = a.language
LEFT JOIN xc0xt_users AS uc ON uc.id=a.checked_out
LEFT JOIN xc0xt_viewlevels AS ag ON ag.id = a.access
LEFT JOIN xc0xt_users AS ua ON ua.id = a.created_user_id
LEFT JOIN xc0xt_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
201μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `id`,`name`,`rules`,`parent_id`
FROM `xc0xt_assets`
WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0
413μs5.48KBParams/libraries/src/Access/Access.php:301CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 200) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
510μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT 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 xc0xt_fields AS a
LEFT JOIN `xc0xt_languages` AS l ON l.lang_code = a.language
LEFT JOIN xc0xt_users AS uc ON uc.id=a.checked_out
LEFT JOIN xc0xt_viewlevels AS ag ON ag.id = a.access
LEFT JOIN xc0xt_users AS ua ON ua.id = a.created_user_id
LEFT JOIN xc0xt_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `xc0xt_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
199μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
134μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
163μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
77μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
191μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
57μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySET SESSION SQL_BIG_SELECTS = 1
20μs0B/components/com_jdownloads/src/Helper/CategoriesHelper.php:236CopySELECT c.*, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as slug,(
SELECT COUNT(`files`.`id`)
FROM `xc0xt_jdownloads_files` AS `files`
WHERE `files`.`catid` = `c`.`id` AND `files`.`published` = 1 AND files.access IN (1,5) AND files.user_access = 0 AND (files.publish_up IS NULL OR files.publish_up <= '2025-01-07 07:39:18') AND (files.publish_down IS NULL OR files.publish_down >= '2025-01-07 07:39:18') AND `files`.`language` IN (:preparedArray3,:preparedArray4)) AS `numitems`,(
SELECT COUNT(*)
FROM `xc0xt_jdownloads_categories` AS `cat`
WHERE `cat`.`parent_id` = `c`.`id` AND cat.parent_id > 1 AND cat.published = 1 AND cat.access IN (1,5) AND `cat`.`language` IN (:preparedArray5,:preparedArray6)) AS `subcatitems`,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid
FROM `xc0xt_jdownloads_categories` AS `s`
INNER JOIN `xc0xt_jdownloads_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray1,:preparedArray2)) OR (`c`.`lft` <= `s`.`lft` AND `s`.`rgt` <= `c`.`rgt`)
LEFT JOIN `xc0xt_jdownloads_files` AS files ON files.`catid` = c.id AND files.published = 1
LEFT JOIN xc0xt_users AS u on u.id = files.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = files.modified_by
LEFT JOIN (SELECT id, link, access, published from xc0xt_menu GROUP BY link) AS menu on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=', c.id) AND menu.published = 1 AND menu.access IN (1,5)
WHERE c.access IN (1,5) AND c.published = 1 AND `s`.`id` = c.id
GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.access
ORDER BY c.lft
11.92ms6.03KBParams/components/com_jdownloads/src/Helper/CategoriesHelper.php:433CopySELECT alias, id
FROM xc0xt_jdownloads_categories
WHERE id > 1
ORDER BY `id`
74μs1KB/components/com_jdownloads/src/Helper/LegacyRouter.php:77CopySELECT alias, id
FROM xc0xt_jdownloads_files
ORDER BY `id`
129μs4.56KB/components/com_jdownloads/src/Helper/LegacyRouter.php:87CopySELECT 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 xc0xt_fields AS a
LEFT JOIN `xc0xt_languages` AS l ON l.lang_code = a.language
LEFT JOIN xc0xt_users AS uc ON uc.id=a.checked_out
LEFT JOIN xc0xt_viewlevels AS ag ON ag.id = a.access
LEFT JOIN xc0xt_users AS ua ON ua.id = a.created_user_id
LEFT JOIN xc0xt_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
192μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 201) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
358μs21.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
142μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
112μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
54μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
188μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
55μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 202) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
334μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
139μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
109μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
53μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
184μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
54μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 203) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
333μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
132μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
112μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
54μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
188μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
54μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 204) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
338μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
132μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
104μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
52μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
185μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
53μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 205) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
331μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
132μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
106μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
51μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
186μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
55μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 206) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
336μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
134μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
106μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
52μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
192μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
53μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 207) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
342μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
133μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
104μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
50μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
184μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
53μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 208) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
331μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
132μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
111μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
53μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
191μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
53μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 209) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
330μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
140μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
105μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
51μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
186μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
53μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 210) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
336μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
133μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
111μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
53μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
183μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
53μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 211) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
330μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
133μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
106μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
52μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
185μs39.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
53μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 212) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
330μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
133μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
104μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
51μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
193μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
57μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 213) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
337μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
133μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
106μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
51μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
187μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
53μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 214) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
334μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
132μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
106μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
50μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
183μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
53μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 215) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
326μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
134μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
107μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
51μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
187μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
53μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
FROM xc0xt_jdownloads_files AS a
LEFT JOIN xc0xt_jdownloads_files AS aa on aa.id = a.other_file_id
INNER JOIN xc0xt_jdownloads_categories AS c on c.id = a.catid
LEFT JOIN xc0xt_users AS u on u.id = a.created_by
LEFT JOIN xc0xt_users AS u2 on u2.id = a.modified_by
LEFT JOIN xc0xt_users AS u3 on u3.id = a.user_access
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM xc0xt_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by
LEFT JOIN xc0xt_jdownloads_licenses AS l on l.id = a.license
LEFT JOIN xc0xt_jdownloads_ratings AS r on r.file_id = a.id
LEFT JOIN xc0xt_jdownloads_categories as parent ON parent.id = c.parent_id
LEFT OUTER JOIN (SELECT cat.id as id FROM xc0xt_jdownloads_categories AS cat JOIN xc0xt_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id
WHERE
(
(c.published > 0 AND a.language in ('en-GB','*') AND a.id = 216) AND
(`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND
(`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)
329μs10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258CopySELECT `m`.`tag_id`,`t`.*
FROM `xc0xt_contentitem_tag_map` AS `m`
INNER JOIN `xc0xt_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)
143μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388CopySELECT * FROM xc0xt_jdownloads_templates WHERE (template_name = 'Files link only v3.9') AND (template_typ = 2)
104μs2.72KB/plugins/content/jdownloads/jdownloads.php:533CopySELECT group_id, importance, id
FROM xc0xt_jdownloads_usergroups_limits
ORDER BY importance
52μs800B/components/com_jdownloads/src/Helper/JDHelper.php:90CopySELECT * FROM xc0xt_jdownloads_usergroups_limits WHERE group_id IN (1)
184μs31.91KB/components/com_jdownloads/src/Helper/JDHelper.php:114CopySELECT *
FROM `xc0xt_usergroups`
WHERE `id` = :id
54μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237CopySELECT `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 `xc0xt_categories` AS `s`
INNER JOIN `xc0xt_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
307μs51.97KBParams/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 xc0xt_fields AS a
LEFT JOIN `xc0xt_languages` AS l ON l.lang_code = a.language
LEFT JOIN xc0xt_users AS uc ON uc.id=a.checked_out
LEFT JOIN xc0xt_viewlevels AS ag ON ag.id = a.access
LEFT JOIN xc0xt_users AS ua ON ua.id = a.created_user_id
LEFT JOIN xc0xt_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `xc0xt_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
200μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
63μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT 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 xc0xt_fields AS a
LEFT JOIN `xc0xt_languages` AS l ON l.lang_code = a.language
LEFT JOIN xc0xt_users AS uc ON uc.id=a.checked_out
LEFT JOIN xc0xt_viewlevels AS ag ON ag.id = a.access
LEFT JOIN xc0xt_users AS ua ON ua.id = a.created_user_id
LEFT JOIN xc0xt_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
280μs4.22KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166CopySELECT `language`,`id`
FROM `xc0xt_menu`
WHERE `home` = '1' AND `published` = 1 AND `client_id` = 0
147μs592B/libraries/src/Language/Multilanguage.php:123CopySELECT `c2`.`language`,`c2`.`id`
FROM `xc0xt_menu` AS `c`
INNER JOIN `xc0xt_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `xc0xt_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `xc0xt_menu` AS `c2` ON `a2`.`id` = `c2`.`id`
WHERE `c`.`id` = :id
87μs1.38KBParams/libraries/src/Language/Associations.php:145CopySELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
FROM `xc0xt_categories` AS `c`
INNER JOIN `xc0xt_associations` AS `a` ON `a`.`id` = `c`.`id` AND `a`.`context` = :context
INNER JOIN `xc0xt_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNER JOIN `xc0xt_categories` AS `c2` ON `a2`.`id` = `c2`.`id` AND c2.extension = :extension1
WHERE `c`.`id` = :id AND `c`.`extension` = :extension3
76μs1.42KBParams/libraries/src/Language/Associations.php:145CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
72μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
56μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
48μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
62μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
54μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid`
FROM `xc0xt_modules` AS `m`
LEFT JOIN `xc0xt_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id`
LEFT JOIN `xc0xt_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) AND `m`.`language` IN (:preparedArray3,:preparedArray4)
ORDER BY `m`.`position`,`m`.`ordering`
473μs1.97KBParams/libraries/src/Cache/Controller/CallbackController.php:51CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
72μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
56μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
58μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
54μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '107'
3.46ms74.81KB/modules/mod_sppagebuilder/helper.php:40CopySELECT `template`
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `home` = 1
110μs536B/components/com_sppagebuilder/parser/addon-parser.php:831CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `xc0xt_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
86μs592B/components/com_sppagebuilder/helpers/helper.php:134CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `xc0xt_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
63μs592B/components/com_sppagebuilder/helpers/helper.php:134CopySELECT `template`
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `home` = 1
66μs536B/administrator/components/com_sppagebuilder/builder/classes/base.php:43CopySELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id
FROM (
SELECT id,title,level,published,parent_id,lft,rgt
FROM xc0xt_tags
WHERE `published` = '1') AS a
LEFT JOIN `xc0xt_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt
WHERE `a`.`level` != '0'
ORDER BY a.lft ASC
158μs816B/administrator/components/com_sppagebuilder/builder/classes/base.php:265CopySELECT a.enabled
FROM `xc0xt_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
153μs520B/administrator/components/com_sppagebuilder/builder/classes/base.php:702CopySELECT a.enabled
FROM `xc0xt_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
126μs520B/administrator/components/com_sppagebuilder/builder/classes/base.php:702CopySELECT a.enabled
FROM `xc0xt_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
108μs520B/administrator/components/com_sppagebuilder/builder/classes/base.php:702CopySELECT a.enabled
FROM `xc0xt_extensions` AS `a`
WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')
84μs520B/administrator/components/com_sppagebuilder/builder/classes/base.php:615CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
82μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
57μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
55μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
52μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '180'
1.17ms18.81KB/modules/mod_sppagebuilder/helper.php:40CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `xc0xt_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
93μs592B/components/com_sppagebuilder/helpers/helper.php:134CopySELECT e.manifest_cache,`e`.`manifest_cache`
FROM `xc0xt_extensions` AS `e`
WHERE `e`.`element` = 'com_sppagebuilder'
54μs592B/components/com_sppagebuilder/helpers/helper.php:134CopySELECT `template`
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `home` = 1
60μs536B/administrator/components/com_sppagebuilder/builder/classes/base.php:43CopySELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
FROM xc0xt_modules AS m
WHERE
(
(m.published = 1 AND m.id = 181) AND
(`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND
(`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown) AND m.access IN (1,5) AND m.client_id = 0 AND m.language IN ('en-GB','*')
98μs1.72KBParams/components/com_sppagebuilder/addons/module/site.php:127CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
64μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
54μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
61μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
53μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
63μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
54μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
54μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
53μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
54μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
51μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
52μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
53μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
59μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
52μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
49μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
55μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
53μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySELECT 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 `xc0xt_scheduler_tasks` AS `a`
WHERE `a`.`state` = 1
90μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466CopySELECT *
FROM `xc0xt_template_styles`
WHERE `client_id` = 0 AND `id` = '15'
63μs40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54CopySHOW TABLES
721μs2.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678CopySELECT `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 `xc0xt_categories` AS `s`
INNER JOIN `xc0xt_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray3,:preparedArray4)) 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`
313μs51.97KBParams/libraries/src/Categories/Categories.php:375CopySELECT `session_id`
FROM `xc0xt_session`
WHERE `session_id` = ?
59μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291CopyUPDATE `xc0xt_session`
SET `data` = ?
, `time` = ?
WHERE `session_id` = ?
406μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy