Joomla! Debug Console

Session

Profile Information

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.596 MB / 0.60 MB Application: afterLoad

Time: 961.3 ms / 961.3 ms Memory: 8.240 MB / 8.84 MB Application: afterInitialise

Time: 119.7 ms / 1081.0 ms Memory: 4.098 MB / 12.93 MB Application: afterRoute

Time: 351.9 ms / 1432.9 ms Memory: 4.264 MB / 17.20 MB Application: afterDispatch

Time: 151.7 ms / 1584.6 ms Memory: 0.458 MB / 17.66 MB Application: beforeRenderModule mod_k2_tools (Cerca)

Time: 41.0 ms / 1625.6 ms Memory: 0.561 MB / 18.22 MB Application: afterRenderModule mod_k2_tools (Cerca)

Time: 0.4 ms / 1626.0 ms Memory: 0.000 MB / 18.21 MB Application: beforeRenderModule mod_roknavmenu (Menu EN)

Time: 165.4 ms / 1791.4 ms Memory: 1.261 MB / 19.47 MB Application: afterRenderModule mod_roknavmenu (Menu EN)

Time: 0.2 ms / 1791.6 ms Memory: 0.000 MB / 19.43 MB Application: beforeRenderModule mod_languages (Menu Multilingua)

Time: 48.8 ms / 1840.4 ms Memory: 0.276 MB / 19.71 MB Application: afterRenderModule mod_languages (Menu Multilingua)

Time: 0.5 ms / 1840.9 ms Memory: 0.024 MB / 19.73 MB Application: beforeRenderModule mod_news_pro_gk5 (Featured projects)

Time: 413.6 ms / 2254.5 ms Memory: 0.788 MB / 20.52 MB Application: afterRenderModule mod_news_pro_gk5 (Featured projects)

Time: 0.8 ms / 2255.3 ms Memory: 0.000 MB / 20.45 MB Application: beforeRenderModule mod_news_pro_gk5 (Featured projects)

Time: 128.7 ms / 2384.0 ms Memory: 0.305 MB / 20.75 MB Application: afterRenderModule mod_news_pro_gk5 (Featured projects)

Time: 0.6 ms / 2384.6 ms Memory: 0.000 MB / 20.68 MB Application: beforeRenderModule mod_news_pro_gk5 (Featured news )

Time: 552.8 ms / 2937.4 ms Memory: 0.158 MB / 20.83 MB Application: afterRenderModule mod_news_pro_gk5 (Featured news )

Time: 0.5 ms / 2937.9 ms Memory: 0.000 MB / 20.77 MB Application: beforeRenderModule mod_news_pro_gk5 (Featured news)

Time: 293.9 ms / 3231.8 ms Memory: 0.142 MB / 20.91 MB Application: afterRenderModule mod_news_pro_gk5 (Featured news)

Time: 0.5 ms / 3232.3 ms Memory: 0.000 MB / 20.83 MB Application: beforeRenderModule mod_djimageslider (Homepage Slider - ENG)

Time: 24.7 ms / 3256.9 ms Memory: 0.209 MB / 21.04 MB Application: afterRenderModule mod_djimageslider (Homepage Slider - ENG)

Time: 239.7 ms / 3496.6 ms Memory: 0.361 MB / 21.40 MB Application: afterRender

Database queries total: 49.4 ms

Memory Usage

Database Queries

73 Queries Logged 49.4 ms

16 duplicate found!

2 duplicates: #13 #14

2 duplicates: #19 #21

2 duplicates: #25 #31

2 duplicates: #37 #49

2 duplicates: #47 #59

2 duplicates: #48 #60

2 duplicates: #61 #65

2 duplicates: #63 #67

Query Time: 0.32 ms
```
SELECT `data`

  FROM `suze1_session`

  WHERE `session_id` = '6cjpcgdq79ottu273ofeam8093'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_session const PRIMARY PRIMARY 602 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:46
JROOT/libraries/joomla/session/session.php:659
JROOT/libraries/joomla/session/session.php:597
JROOT/libraries/cms/application/cms.php:672
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.39 ms After last query: 12.45 ms
```
SELECT `session_id`

  FROM `suze1_session`

  WHERE `session_id` = '6cjpcgdq79ottu273ofeam8093' 
  LIMIT 0, 1
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_session const PRIMARY PRIMARY 602 const 1 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:175
JROOT/libraries/cms/application/cms.php:698
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.34 ms After last query: 0.19 ms
```
INSERT INTO `suze1_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('6cjpcgdq79ottu273ofeam8093', 0, '1665022216')
```
Explain
EXPLAIN not possible on query: INSERT INTO `suze1_session` (`session_id`, `client_id`, `time`) VALUES ('6cjpcgdq79ottu273ofeam8093', 0, '1665022216')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:207
JROOT/libraries/cms/application/cms.php:698
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:332
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.50 ms After last query: 21.82 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM suze1_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_users'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:541
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.32 ms After last query: 5.94 ms
```
SELECT b.id

  FROM suze1_usergroups AS a

  LEFT JOIN suze1_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a const PRIMARY PRIMARY 4 const 1
1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 Using where; Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:336
JROOT/libraries/joomla/access/access.php:405
JROOT/libraries/joomla/user/user.php:420
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.26 ms After last query: 1.82 ms
```
SELECT id, rules

  FROM `suze1_viewlevels`
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:422
JROOT/libraries/joomla/user/user.php:420
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.03 ms After last query: 0.25 ms
```
SELECT folder AS type, element AS name, params

  FROM suze1_extensions

  WHERE enabled >= 1 
  AND type ='plugin' 
  AND state >= 0 
  AND access IN (1,1,5)

  ORDER BY ordering
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_extensions ref extension extension 62 const 114 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.27 ms After last query: 22.96 ms
```
SELECT *

  FROM suze1_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/language/helper.php:166
JROOT/plugins/system/languagefilter/languagefilter.php:67
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.46 ms After last query: 0.34 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM suze1_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/plugins/system/languagefilter/languagefilter.php:69
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.22 ms After last query: 1.74 ms
```
SELECT COUNT(*)

  FROM `suze1_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_menu ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 231 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:32
JROOT/plugins/system/languagefilter/languagefilter.php:71
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:546
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.31 ms After last query: 73.06 ms
```
SELECT `query`

  FROM `suze1_admintools_wafexceptions`

  WHERE (`option` IS NULL OR `option` = '') 
  AND (`view` IS NULL OR `view` = '')

  GROUP BY `query`

  ORDER BY `query` ASC
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/admintools/admintools/main.php:488
JROOT/plugins/system/admintools/admintools/main.php:96
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:586
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.30 ms After last query: 6.50 ms
```
SELECT `value`

  FROM `suze1_admintools_storage`

  WHERE `key` = 'cparams'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_admintools_storage const PRIMARY PRIMARY 767 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_admintools/models/storage.php:97
JROOT/administrator/components/com_admintools/models/storage.php:49
JROOT/plugins/system/admintools/feature/httpsizer.php:26
JROOT/plugins/system/admintools/admintools/main.php:354
JROOT/plugins/system/admintools/admintools/main.php:99
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:586
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.37 ms After last query: 91.26 ms
Duplicate queries: #14
```
SELECT template

  FROM suze1_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 5 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
JROOT/libraries/rokcommon/RokCommon/Service.php:71
JROOT/libraries/rokcommon/include.php:38
JROOT/plugins/system/rokcommon/rokcommon.php:99
JROOT/plugins/system/rokcommon/rokcommon.php:57
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:586
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.26 ms After last query: 0.21 ms
Duplicate queries: #13
```
SELECT template

  FROM suze1_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 5 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
JROOT/libraries/rokcommon/RokCommon/Service.php:71
JROOT/libraries/rokcommon/include.php:38
JROOT/plugins/system/rokcommon/rokcommon.php:99
JROOT/plugins/system/rokcommon/rokcommon.php:57
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:586
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.33 ms After last query: 35.23 ms
```
SELECT extension, file, type

  FROM suze1_rokcommon_configs

  ORDER BY priority
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_rokcommon_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/rokcommon/rokcommon.php:130
JROOT/plugins/system/rokcommon/rokcommon.php:78
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:586
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.74 ms After last query: 91.01 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM suze1_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_k2'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/plugins/system/k2/k2.php:435
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.02 ms After last query: 30.25 ms
```
SHOW FULL COLUMNS 
  FROM `suze1_extensions`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `suze1_extensions`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:229
JROOT/libraries/joomla/table/table.php:150
JROOT/libraries/joomla/table/extension.php:31
JROOT/libraries/joomla/table/table.php:294
JROOT/plugins/system/roksprocket/roksprocket.php:46
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.34 ms After last query: 4.34 ms
```
SELECT `extension_id`

  FROM `suze1_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/extension.php:108
JROOT/plugins/system/roksprocket/roksprocket.php:50
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.37 ms After last query: 0.23 ms
Duplicate queries: #21
```
SELECT *

  FROM suze1_extensions

  WHERE `extension_id` = '10114'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_extensions const PRIMARY PRIMARY 4 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:705
JROOT/plugins/system/roksprocket/roksprocket.php:55
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.42 ms After last query: 0.20 ms
```
SELECT `extension_id`

  FROM `suze1_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/extension.php:108
JROOT/plugins/system/roksprocket/roksprocket.php:73
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.21 ms After last query: 0.18 ms
Duplicate queries: #19
```
SELECT *

  FROM suze1_extensions

  WHERE `extension_id` = '10114'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_extensions const PRIMARY PRIMARY 4 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:705
JROOT/plugins/system/roksprocket/roksprocket.php:77
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:587
JROOT/libraries/cms/application/site.php:620
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_session	const	PRIMARY	PRIMARY	602	const	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_session	const	PRIMARY	PRIMARY	602	const	1	Using index

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_extensions	ref	extension	extension	62	const	114	Using where; Using filesort

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using filesort

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	231	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_admintools_storage	const	PRIMARY	PRIMARY	767	const	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_rokcommon_configs	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using filesort

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_extensions	const	PRIMARY	PRIMARY	4	const	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_extensions	const	PRIMARY	PRIMARY	4	const	1

Query Time: 3.92 ms After last query: 459.47 ms

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, 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,e.element as component

  FROM suze1_menu AS m

  LEFT JOIN suze1_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	230	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.m.component_id	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/cms/menu/site.php:47

JROOT/libraries/cms/menu/menu.php:64

JROOT/libraries/cms/menu/menu.php:118

JROOT/libraries/cms/application/cms.php:357

JROOT/libraries/cms/application/site.php:250

JROOT/libraries/cms/router/site.php:210

JROOT/libraries/cms/router/router.php:391

JROOT/libraries/cms/router/router.php:184

JROOT/libraries/cms/router/site.php:82

JROOT/libraries/cms/application/cms.php:1022

JROOT/libraries/cms/application/site.php:720

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.45 ms After last query: 29.73 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM suze1_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:179
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/k2/k2.php:52
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1031
JROOT/libraries/cms/application/site.php:720
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.48 ms After last query: 0.37 ms
```
UPDATE `suze1_extensions`

  SET `params` = '{\"mediaversion\":\"d3d72e039e5432b95cfc3fa2b3ba0512\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: UPDATE `suze1_extensions` SET `params` = '{\"mediaversion\":\"d3d72e039e5432b95cfc3fa2b3ba0512\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:230
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/k2/k2.php:52
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1031
JROOT/libraries/cms/application/site.php:720
JROOT/libraries/cms/application/site.php:202
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where

Query Time: 0.78 ms After last query: 23.23 ms

Duplicate queries: #31

SELECT id, home, template, s.params

  FROM suze1_template_styles as s

  LEFT JOIN suze1_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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	Sql560032_2.s.template,const	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/cms/application/site.php:457

JROOT/libraries/cms/html/html.php:336

JROOT/libraries/cms/html/html.php:682

JROOT/libraries/cms/html/html.php:238

JROOT/libraries/cms/html/html.php:140

JROOT/libraries/cms/html/behavior.php:63

JROOT/libraries/cms/html/html.php:238

JROOT/libraries/cms/html/html.php:140

JROOT/administrator/components/com_k2/helpers/html.php:76

JROOT/plugins/system/k2/k2.php:55

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1031

JROOT/libraries/cms/application/site.php:720

JROOT/libraries/cms/application/site.php:202

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.67 ms After last query: 55.87 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM suze1_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_content'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:299
JROOT/libraries/cms/application/site.php:122
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.23 ms After last query: 47.10 ms
```
SELECT a.rules

  FROM suze1_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a const PRIMARY PRIMARY 4 const 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:250
JROOT/libraries/joomla/user/user.php:356
JROOT/components/com_content/models/articles.php:107
JROOT/components/com_content/models/featured.php:39
JROOT/libraries/legacy/model/legacy.php:415
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_content/views/featured/view.html.php:46
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.20 ms After last query: 4.14 ms
```
SELECT b.rules

  FROM suze1_assets AS a

  LEFT JOIN suze1_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a const idx_asset_name idx_asset_name 152 const 1 Using temporary; Using filesort
1 SIMPLE b range idx_lft_rgt idx_lft_rgt 4 NULL 11 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:250
JROOT/libraries/joomla/access/access.php:110
JROOT/libraries/joomla/user/user.php:365
JROOT/components/com_content/models/articles.php:107
JROOT/components/com_content/models/featured.php:39
JROOT/libraries/legacy/model/legacy.php:415
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_content/views/featured/view.html.php:46
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:208
JROOT/libraries/cms/application/cms.php:255
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; Using filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	11	Using where

Query Time: 2.06 ms After last query: 2.90 ms

SELECT 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, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' 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.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null 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,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM suze1_content AS a

  LEFT JOIN suze1_categories AS c 
  ON c.id = a.catid

  LEFT JOIN suze1_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN suze1_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN suze1_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN suze1_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM suze1_categories AS cat JOIN suze1_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  INNER JOIN suze1_content_frontpage AS fp 
  ON fp.content_id = a.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-10-06 02:10:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-10-06 02:10:17') 
  AND a.language in ('en-GB','*')

  ORDER BY c.lft,  a.featured DESC, fp.ordering,  a.created DESC   
  LIMIT 0, 4

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	const row not found
1	PRIMARY	a	ALL	PRIMARY,idx_access,idx_catid,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.a.created_by	1
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.a.modified_by	1
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	Sql560032_2.a.catid	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.c.parent_id	1
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.a.id	1
1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.a.id	1	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using where; Using temporary; Using filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	13	Using where; Using index; Using join buffer

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/legacy/model/legacy.php:301

JROOT/libraries/legacy/model/list.php:187

JROOT/components/com_content/models/articles.php:537

JROOT/components/com_content/models/featured.php:84

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_content/views/featured/view.html.php:47

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:38

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.89 ms After last query: 6.92 ms

SELECT COUNT(*)

  FROM suze1_content AS a

  LEFT JOIN suze1_categories AS c 
  ON c.id = a.catid

  LEFT JOIN suze1_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN suze1_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN suze1_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN suze1_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM suze1_categories AS cat JOIN suze1_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  INNER JOIN suze1_content_frontpage AS fp 
  ON fp.content_id = a.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-10-06 02:10:17') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-10-06 02:10:17') 
  AND a.language in ('en-GB','*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	const row not found
1	PRIMARY	a	ALL	PRIMARY,idx_access,idx_catid,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.a.created_by	1	Using index
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.a.modified_by	1	Using index
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	Sql560032_2.a.catid	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.c.parent_id	1	Using index
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.a.id	1	Using index
1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.a.id	1	Using where; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using where; Using temporary; Using filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	13	Using where; Using index; Using join buffer

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/legacy/model/legacy.php:327

JROOT/libraries/legacy/model/list.php:292

JROOT/libraries/legacy/model/list.php:237

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_content/views/featured/view.html.php:48

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:38

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.37 ms After last query: 113.49 ms

Duplicate queries: #25

SELECT id, home, template, s.params

  FROM suze1_template_styles as s

  LEFT JOIN suze1_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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	Sql560032_2.s.template,const	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/gantry/core/gantrytemplate.class.php:638

JROOT/libraries/gantry/core/gantrytemplate.class.php:590

JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69

JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36

JROOT/libraries/gantry/core/gantry.class.php:1843

JROOT/libraries/gantry/core/gantry.class.php:392

JROOT/libraries/gantry/gantry.php:275

JROOT/libraries/gantry/gantry.php:432

JROOT/templates/gantry/html/com_content/featured/default.php:9

JROOT/libraries/legacy/view/legacy.php:663

JROOT/libraries/legacy/view/legacy.php:211

JROOT/components/com_content/views/featured/view.html.php:148

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:38

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:208

JROOT/libraries/cms/application/cms.php:255

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 1.92 ms After last query: 286.09 ms

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM suze1_modules AS m

  LEFT JOIN suze1_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN suze1_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.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-10-06 02:10:17') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-10-06 02:10:17') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 257 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	166	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Sql560032_2.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	Sql560032_2.m.module,const	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/cms/module/helper.php:385

JROOT/libraries/cms/module/helper.php:84

JROOT/libraries/joomla/document/html/html.php:502

JROOT/libraries/gantry/core/gantry.class.php:804

JROOT/libraries/gantry/core/gantry.class.php:757

JROOT/templates/gantry/index.php:78

JROOT/libraries/joomla/document/html/html.php:570

JROOT/libraries/joomla/document/html/html.php:628

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:978

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.44 ms After last query: 166.66 ms
```
SELECT ts.template

  FROM suze1_template_styles AS ts

  INNER JOIN suze1_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 257 
  AND m.template_style_id != 0
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:98
JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:71
JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:22
JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:992
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.17 ms After last query: 0.15 ms
```
SELECT template

  FROM suze1_template_styles

  WHERE home = 1 
  AND client_id = 0
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_template_styles ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 5 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:113
JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:71
JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:22
JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:992
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.48 ms After last query: 38.95 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM suze1_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_contactenhanced'
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/components/com_contactenhanced/router.php:14
JROOT/libraries/cms/router/site.php:455
JROOT/libraries/cms/router/site.php:413
JROOT/libraries/cms/router/router.php:216
JROOT/libraries/cms/router/site.php:98
JROOT/libraries/joomla/application/route.php:62
JROOT/modules/mod_roknavmenu/lib/providers/RokMenuProviderJoomla16.php:174
JROOT/modules/mod_roknavmenu/lib/providers/RokMenuProviderJoomla16.php:207
JROOT/modules/mod_roknavmenu/lib/providers/RokMenuProviderJoomla16.php:273
JROOT/modules/mod_roknavmenu/lib/librokmenu/RokMenuDefaultRenderer.php:65
JROOT/modules/mod_roknavmenu/lib/librokmenu/RokMenu.php:88
JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:22
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:992
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.39 ms After last query: 50.84 ms
```
SELECT m2.language, m2.id

  FROM suze1_menu as m

  INNER JOIN suze1_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item'

  INNER JOIN suze1_associations as a2 
  ON a.key=a2.key

  INNER JOIN suze1_menu as m2 
  ON a2.id=m2.id

  WHERE m.id=257
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_menus/helpers/menus.php:257
JROOT/modules/mod_languages/helper.php:58
JROOT/modules/mod_languages/mod_languages.php:18
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:992
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.64 ms After last query: 59.10 ms
Duplicate queries: #49
```
SELECT 
					c.id AS CID
				
  FROM 
					suze1_k2_categories AS c
				
  LEFT JOIN 
					suze1_k2_items AS content 
					
  ON 
					c.id = content.catid 	
				 
				
  WHERE 
					(  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
					
  AND 
					c.published = 1
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE content range PRIMARY,catid PRIMARY 4 NULL 9 Using where
1 SIMPLE c eq_ref PRIMARY,category,published PRIMARY 4 Sql560032_2.content.catid 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:83
JROOT/modules/mod_news_pro_gk5/helper.php:91
JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:992
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	range	PRIMARY,catid	PRIMARY	4	NULL	9	Using where
1	SIMPLE	c	eq_ref	PRIMARY,category,published	PRIMARY	4	Sql560032_2.content.catid	1	Using where

Query Time: 0.43 ms After last query: 0.34 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=1245 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
			

		
  LIMIT
			0,9;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.47 ms After last query: 0.13 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=1246 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
			

		
  LIMIT
			0,9;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.40 ms After last query: 0.12 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=714 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
			

		
  LIMIT
			0,9;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.41 ms After last query: 0.12 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=750 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
			

		
  LIMIT
			0,9;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.40 ms After last query: 0.14 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=1247 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
			

		
  LIMIT
			0,9;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.34 ms After last query: 0.18 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=3225 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
			

		
  LIMIT
			0,9;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.40 ms After last query: 0.14 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=744 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
			

		
  LIMIT
			0,9;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.38 ms After last query: 0.13 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=1215 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
			

		
  LIMIT
			0,9;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.41 ms After last query: 0.11 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=1254 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
			

		
  LIMIT
			0,9;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.30 ms After last query: 0.12 ms
Duplicate queries: #59
```
SELECT * 
  FROM suze1_k2_additional_categories 
  WHERE catid=49;
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_k2_additional_categories ALL NULL NO INDEX KEY COULD BE USED NULL NULL 922 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:312
JROOT/modules/mod_news_pro_gk5/helper.php:101
JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:992
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	suze1_k2_additional_categories	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	922	Using where

Query Time: 0.83 ms After last query: 0.15 ms

Duplicate queries: #60

SELECT
				content.id AS id,
				content.access AS access,
				content.catid AS cid,
				categories.name AS catname,
				categories.alias AS cat_alias,
				users.email AS author_email,
				content.created_by_alias AS author_alias,
				users.name AS author_username,
				content.created_by AS author_id,
				content_rating.rating_sum AS rating_sum,
				content_rating.rating_count AS rating_count		
			
  FROM 
				suze1_k2_items AS content 
				
  LEFT JOIN 
					suze1_k2_categories AS categories 
					
  ON categories.id = content.catid
				
  LEFT JOIN 
					suze1_users AS users 
					
  ON users.id = content.created_by 			
				
  LEFT JOIN 
					suze1_k2_rating AS content_rating 
					
  ON content_rating.itemID = content.id
			
  WHERE 
				 content.id = 1245 OR  content.id = 1246 OR  content.id = 714 OR  content.id = 750 OR  content.id = 1247 OR  content.id = 744 OR  content.id = 1215 OR  content.id = 1254
			
  ORDER BY 
				 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content_rating	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	const row not found
1	SIMPLE	content	range	PRIMARY	PRIMARY	4	NULL	8	Using where
1	SIMPLE	categories	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.content.catid	1
1	SIMPLE	users	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.content.created_by	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:395

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.35 ms After last query: 383.48 ms
Duplicate queries: #37
```
SELECT 
					c.id AS CID
				
  FROM 
					suze1_k2_categories AS c
				
  LEFT JOIN 
					suze1_k2_items AS content 
					
  ON 
					c.id = content.catid 	
				 
				
  WHERE 
					(  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
					
  AND 
					c.published = 1
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE content range PRIMARY,catid PRIMARY 4 NULL 9 Using where
1 SIMPLE c eq_ref PRIMARY,category,published PRIMARY 4 Sql560032_2.content.catid 1 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:83
JROOT/modules/mod_news_pro_gk5/helper.php:91
JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:992
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	range	PRIMARY,catid	PRIMARY	4	NULL	9	Using where
1	SIMPLE	c	eq_ref	PRIMARY,category,published	PRIMARY	4	Sql560032_2.content.catid	1	Using where

Query Time: 0.62 ms After last query: 0.37 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=1245 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
  AND content.featured = 1 
			

		
  LIMIT
			0,3;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,featured,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.69 ms After last query: 0.16 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=1246 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
  AND content.featured = 1 
			

		
  LIMIT
			0,3;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,featured,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.66 ms After last query: 0.14 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=714 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
  AND content.featured = 1 
			

		
  LIMIT
			0,3;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,featured,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.61 ms After last query: 0.15 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=750 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
  AND content.featured = 1 
			

		
  LIMIT
			0,3;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,featured,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.47 ms After last query: 0.12 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=1247 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
  AND content.featured = 1 
			

		
  LIMIT
			0,3;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,featured,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.45 ms After last query: 0.13 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=3225 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
  AND content.featured = 1 
			

		
  LIMIT
			0,3;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.43 ms After last query: 0.11 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=744 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
  AND content.featured = 1 
			

		
  LIMIT
			0,3;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,featured,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.46 ms After last query: 0.12 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=1215 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
  AND content.featured = 1 
			

		
  LIMIT
			0,3;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,featured,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.47 ms After last query: 0.13 ms

SELECT
			content.id AS id,
			content.alias AS alias,
			content.title AS title, 
			content.introtext AS text, 
			content.created AS date, 
			content.publish_up AS date_publish,
			content.hits AS hits,
			content.featured AS frontpage				
		
  FROM 
			suze1_k2_items AS content 
			
		
  WHERE
			content.id=1254 
  AND 
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1,5)    
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2022-10-06 04:10:18' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2022-10-06 04:10:18' )
			 
  AND (  content.id = 1245 OR content.id = 1246 OR content.id = 714 OR content.id = 750 OR content.id = 1247 OR content.id = 3225 OR content.id = 744 OR content.id = 1215 OR content.id = 1254 ) 
			 
  AND content.language in ('en-GB','*') 
			 
  AND content.featured = 1 
			

		
  LIMIT
			0,3;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content	const	PRIMARY,item,featured,language	PRIMARY	4	const	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:238

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.18 ms After last query: 0.11 ms
Duplicate queries: #47
```
SELECT * 
  FROM suze1_k2_additional_categories 
  WHERE catid=49;
```
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE suze1_k2_additional_categories ALL NULL NO INDEX KEY COULD BE USED NULL NULL 922 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:312
JROOT/modules/mod_news_pro_gk5/helper.php:101
JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:690
JROOT/libraries/joomla/document/html/html.php:471
JROOT/libraries/cms/application/cms.php:992
JROOT/libraries/cms/application/site.php:702
JROOT/libraries/cms/application/cms.php:261
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.31 ms After last query: 0.10 ms

Duplicate queries: #48

SELECT
				content.id AS id,
				content.access AS access,
				content.catid AS cid,
				categories.name AS catname,
				categories.alias AS cat_alias,
				users.email AS author_email,
				content.created_by_alias AS author_alias,
				users.name AS author_username,
				content.created_by AS author_id,
				content_rating.rating_sum AS rating_sum,
				content_rating.rating_count AS rating_count		
			
  FROM 
				suze1_k2_items AS content 
				
  LEFT JOIN 
					suze1_k2_categories AS categories 
					
  ON categories.id = content.catid
				
  LEFT JOIN 
					suze1_users AS users 
					
  ON users.id = content.created_by 			
				
  LEFT JOIN 
					suze1_k2_rating AS content_rating 
					
  ON content_rating.itemID = content.id
			
  WHERE 
				 content.id = 1245 OR  content.id = 1246 OR  content.id = 714 OR  content.id = 750 OR  content.id = 1247 OR  content.id = 744 OR  content.id = 1215 OR  content.id = 1254
			
  ORDER BY 
				 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	content_rating	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	0	const row not found
1	SIMPLE	content	range	PRIMARY	PRIMARY	4	NULL	8	Using where
1	SIMPLE	categories	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.content.catid	1
1	SIMPLE	users	eq_ref	PRIMARY	PRIMARY	4	Sql560032_2.content.created_by	1

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:395

JROOT/modules/mod_news_pro_gk5/helper.php:101

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.56 ms After last query: 121.52 ms

Duplicate queries: #65

SELECT 
					c.id AS CID
				
  FROM 
					suze1_k2_categories AS c
				
  LEFT JOIN 
					suze1_k2_items AS content 
					
  ON 
					c.id = content.catid 	
				 
				
  WHERE 
					(  c.id = 135 ) 
					
  AND 
					c.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,category,published	PRIMARY	4	const	1
1	SIMPLE	content	ref	catid	catid	4	const	120	Using index

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:83

JROOT/modules/mod_news_pro_gk5/helper.php:91

JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:992

JROOT/libraries/cms/application/site.php:702

JROOT/libraries/cms/application/cms.php:261

JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 3.99 ms After last query: 0.56 ms

Featured news

DIGITAL INNOVATION GATE, Cherasco | Updates from the construction site

Nemesi certified EN ISO 9001:2015

LOFT RIETI | IN/ARCH AWARD

NEMESI | CASA PLATFORM @ ARCHITECTURE BIENNALE OF VENICE 2021

DIGITAL INNOVATION GATE | under construction

DIGITAL INNOVATION GATE | under construction, august 2021

Featured news

DIGITAL INNOVATION GATE, Cherasco | Up…

Nemesi certified EN ISO 9001:2015

LOFT RIETI | IN/ARCH AWARD

Featured projects

NEW TESISQUARE HEADQUARTER, CHERASCO

YUN XI TING CENTER, SHENZHEN

ITALY PAVILION EXPO 2015, MILAN

ENI NEW HEADQUARTER, SAN DONATO MILANE…

THE CORAL, SHENZHEN

HAINAN AIRPORT

NEW ISTAT HEADQUARTER, ROME

HUMAN TECHNOPOLE: NEW HEADQUARTERS

Featured projects

NEW TESISQUARE HEADQUARTER, CHERASCO

YUN XI TING CENTER, SHENZHEN

ITALY PAVILION EXPO 2015, MILAN

Cerca

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

73 Queries Logged 49.4 ms

16 duplicate found!