Home

Loading…

Aktuelles

St Patrick´s day celebrations 2023

January 23, 2023

Hedgehog's Garden live im Towers Irish Pub Ludwigsburg am St. Patrick's Day 17.03.2023 von ca. 18:00 - 22:00 Uhr

Aktuelles

St Patrick´s day celebrations 2019

March 10, 2019

MyAdminUser

2016 Live im Lit Cafe PH Ludwigsburg

December 16, 2018

CDs

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1674900188,
                "last": 1674900188,
                "now": 1674900188
            },
            "token": "JuKWAf3UWapxQ0AWzgEYMHikN2oY1vlY"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 44.89 ms / 44.89 ms Memory: 0.548 MB / 0.90 MB Application: afterLoad

Time: 121.78 ms / 166.68 ms Memory: 1.149 MB / 2.05 MB Application: afterInitialise

Time: 66.88 ms / 233.56 ms Memory: 0.514 MB / 2.56 MB Application: afterRoute

Time: 0.57 ms / 234.13 ms Memory: 0.071 MB / 2.63 MB Application: beforeRenderComponent com_content

Time: 16.50 ms / 250.63 ms Memory: 0.197 MB / 2.83 MB Application: Before Access::preloadComponents (all components)

Time: 1.74 ms / 252.37 ms Memory: 0.055 MB / 2.88 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 252.40 ms Memory: -0.002 MB / 2.88 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 1.21 ms / 253.61 ms Memory: 0.008 MB / 2.89 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 36.27 ms / 289.88 ms Memory: 0.221 MB / 3.11 MB Application: afterRenderComponent com_content

Time: 3.03 ms / 292.91 ms Memory: 0.009 MB / 3.12 MB Application: afterDispatch

Time: 44.82 ms / 337.73 ms Memory: 0.523 MB / 3.64 MB Application: beforeRenderModule mod_menu (Footer menu)

Time: 5.55 ms / 343.28 ms Memory: 0.024 MB / 3.67 MB Application: afterRenderModule mod_menu (Footer menu)

Time: 0.07 ms / 343.35 ms Memory: -0.002 MB / 3.67 MB Application: beforeRenderModule mod_grid_gk5 (CDs)

Time: 2.26 ms / 345.60 ms Memory: 0.044 MB / 3.71 MB Application: beforeRenderModule mod_news_pro_gk5 (CD Grid Module I)

Time: 74.01 ms / 419.61 ms Memory: 0.435 MB / 4.14 MB Application: afterRenderModule mod_news_pro_gk5 (CD Grid Module I)

Time: 0.05 ms / 419.66 ms Memory: -0.066 MB / 4.08 MB Application: beforeRenderModule mod_news_pro_gk5 (CD Grid Module II)

Time: 35.38 ms / 455.04 ms Memory: 0.108 MB / 4.19 MB Application: afterRenderModule mod_news_pro_gk5 (CD Grid Module II)

Time: 24.97 ms / 480.01 ms Memory: -0.074 MB / 4.11 MB Application: afterRenderModule mod_grid_gk5 (CDs)

Time: 0.09 ms / 480.10 ms Memory: -0.008 MB / 4.10 MB Application: beforeRenderModule mod_grid_gk5 (Bilder)

Time: 0.32 ms / 480.42 ms Memory: 0.043 MB / 4.15 MB Application: beforeRenderModule mod_news_pro_gk5 (Pics Grid Module VI)

Time: 28.74 ms / 509.15 ms Memory: 0.148 MB / 4.30 MB Application: afterRenderModule mod_news_pro_gk5 (Pics Grid Module VI)

Time: 0.15 ms / 509.30 ms Memory: -0.065 MB / 4.23 MB Application: beforeRenderModule mod_news_pro_gk5 (Pics Grid Module V)

Time: 29.68 ms / 538.98 ms Memory: 0.107 MB / 4.34 MB Application: afterRenderModule mod_news_pro_gk5 (Pics Grid Module V)

Time: 0.04 ms / 539.02 ms Memory: -0.064 MB / 4.27 MB Application: beforeRenderModule mod_news_pro_gk5 (Pics Grid Module IV)

Time: 29.87 ms / 568.88 ms Memory: 0.109 MB / 4.38 MB Application: afterRenderModule mod_news_pro_gk5 (Pics Grid Module IV)

Time: 0.04 ms / 568.92 ms Memory: -0.064 MB / 4.32 MB Application: beforeRenderModule mod_news_pro_gk5 (Pics Grid Module III)

Time: 28.30 ms / 597.22 ms Memory: 0.109 MB / 4.43 MB Application: afterRenderModule mod_news_pro_gk5 (Pics Grid Module III)

Time: 0.04 ms / 597.25 ms Memory: -0.064 MB / 4.36 MB Application: beforeRenderModule mod_news_pro_gk5 (Pics Grid Module II)

Time: 26.90 ms / 624.15 ms Memory: 0.109 MB / 4.47 MB Application: afterRenderModule mod_news_pro_gk5 (Pics Grid Module II)

Time: 0.04 ms / 624.19 ms Memory: -0.064 MB / 4.41 MB Application: beforeRenderModule mod_news_pro_gk5 (Pics Grid Module I)

Time: 29.15 ms / 653.34 ms Memory: 0.109 MB / 4.52 MB Application: afterRenderModule mod_news_pro_gk5 (Pics Grid Module I)

Time: 27.99 ms / 681.33 ms Memory: -0.068 MB / 4.45 MB Application: afterRenderModule mod_grid_gk5 (Bilder)

Time: 0.08 ms / 681.41 ms Memory: -0.016 MB / 4.43 MB Application: beforeRenderModule mod_grid_gk5 (Hedgehogs Garden sind)

Time: 0.31 ms / 681.72 ms Memory: 0.040 MB / 4.47 MB Application: beforeRenderModule mod_news_pro_gk5 (Band Grid Module I)

Time: 35.41 ms / 717.12 ms Memory: 0.109 MB / 4.58 MB Application: afterRenderModule mod_news_pro_gk5 (Band Grid Module I)

Time: 0.04 ms / 717.16 ms Memory: -0.064 MB / 4.52 MB Application: beforeRenderModule mod_news_pro_gk5 (Band Grid Module II)

Time: 39.93 ms / 757.09 ms Memory: 0.108 MB / 4.63 MB Application: afterRenderModule mod_news_pro_gk5 (Band Grid Module II)

Time: 0.05 ms / 757.14 ms Memory: -0.064 MB / 4.56 MB Application: beforeRenderModule mod_news_pro_gk5 (Band Grid Module III)

Time: 44.50 ms / 801.64 ms Memory: 0.123 MB / 4.69 MB Application: afterRenderModule mod_news_pro_gk5 (Band Grid Module III)

Time: 0.04 ms / 801.68 ms Memory: -0.064 MB / 4.62 MB Application: beforeRenderModule mod_news_pro_gk5 (Band Grid Module IV)

Time: 42.44 ms / 844.12 ms Memory: 0.108 MB / 4.73 MB Application: afterRenderModule mod_news_pro_gk5 (Band Grid Module IV)

Time: 0.04 ms / 844.16 ms Memory: -0.064 MB / 4.67 MB Application: beforeRenderModule mod_news_pro_gk5 (Band Grid Module V)

Time: 39.75 ms / 883.91 ms Memory: 0.108 MB / 4.78 MB Application: afterRenderModule mod_news_pro_gk5 (Band Grid Module V)

Time: 0.04 ms / 883.95 ms Memory: -0.064 MB / 4.71 MB Application: beforeRenderModule mod_news_pro_gk5 (Band Grid Module VI)

Time: 40.47 ms / 924.42 ms Memory: 0.108 MB / 4.82 MB Application: afterRenderModule mod_news_pro_gk5 (Band Grid Module VI)

Time: 28.05 ms / 952.47 ms Memory: -0.071 MB / 4.75 MB Application: afterRenderModule mod_grid_gk5 (Hedgehogs Garden sind)

Time: 0.08 ms / 952.55 ms Memory: -0.017 MB / 4.73 MB Application: beforeRenderModule mod_grid_gk5 (Aktuelles)

Time: 0.28 ms / 952.83 ms Memory: 0.036 MB / 4.77 MB Application: beforeRenderModule mod_news_pro_gk5 (News Grid Module I)

Time: 64.73 ms / 1017.56 ms Memory: 0.111 MB / 4.88 MB Application: afterRenderModule mod_news_pro_gk5 (News Grid Module I)

Time: 0.04 ms / 1017.60 ms Memory: -0.064 MB / 4.82 MB Application: beforeRenderModule mod_news_pro_gk5 (News Grid Module II)

Time: 18.52 ms / 1036.12 ms Memory: 0.109 MB / 4.92 MB Application: afterRenderModule mod_news_pro_gk5 (News Grid Module II)

Time: 0.04 ms / 1036.16 ms Memory: -0.065 MB / 4.86 MB Application: beforeRenderModule mod_news_pro_gk5 (News Grid Module III)

Time: 31.41 ms / 1067.57 ms Memory: 0.109 MB / 4.97 MB Application: afterRenderModule mod_news_pro_gk5 (News Grid Module III)

Time: 24.88 ms / 1092.45 ms Memory: -0.075 MB / 4.89 MB Application: afterRenderModule mod_grid_gk5 (Aktuelles)

Time: 0.16 ms / 1092.61 ms Memory: 0.004 MB / 4.90 MB Application: beforeRenderModule mod_image_show_gk4 (Image Show GK4)

Time: 60.67 ms / 1153.29 ms Memory: 0.095 MB / 4.99 MB Application: afterRenderModule mod_image_show_gk4 (Image Show GK4)

Time: 4.51 ms / 1157.80 ms Memory: 0.056 MB / 5.05 MB Application: afterRender

Database queries total: 99.39 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN not possible on query: INSERT INTO `huwg9_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3331396164383030363165616630653362376536623931353534636230393737', 1, 1674900188, 0, '', 0)

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
update	0.21 ms
end	0.02 ms
query end	2.19 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 1.09 ms After last query: 6.11 ms Query memory: 0.024 MB Memory before query: 1.482 MB Rows returned: 37

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `huwg9_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_extensions	NULL	ref	extension	extension	82	const	38	1.00	Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.31 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.72 ms After last query: 7.74 ms Query memory: 0.021 MB Memory before query: 1.517 MB Rows returned: 3

SELECT id, rules

  FROM `huwg9_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	NULL

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.05 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 1.528 MB Rows returned: 1

SELECT b.id

  FROM huwg9_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.93 ms After last query: 2.94 ms Query memory: 0.030 MB Memory before query: 1.550 MB Rows returned: 96

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM huwg9_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_extensions	NULL	ref	extension	extension	82	const	129	0.42	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.05 ms
end	0.02 ms
query end	0.04 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.97 ms After last query: 44.10 ms Query memory: 0.072 MB Memory before query: 2.074 MB Rows returned: 46

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 huwg9_menu AS m

  LEFT JOIN huwg9_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	82	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	db226425x2266557.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 34.26 ms Query memory: 0.025 MB Memory before query: 2.399 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `huwg9_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:376
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.37 ms After last query: 0.16 ms Query memory: 0.006 MB Memory before query: 2.391 MB

UPDATE `huwg9_extensions`

  SET `params` = '{\"mediaversion\":\"53dc49326c485288e00d6f94c39f4842\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	huwg9_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.04 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.09 ms
updating	0.10 ms
end	0.02 ms
query end	0.64 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:376
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 13.82 ms Query memory: 0.022 MB Memory before query: 2.513 MB Rows returned: 1

SELECT *

  FROM huwg9_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:248
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:244
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:392
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.88 ms After last query: 6.33 ms Query memory: 0.025 MB Memory before query: 2.534 MB Rows returned: 2

SELECT id, home, template, s.params

  FROM huwg9_template_styles as s

  LEFT JOIN huwg9_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	4	1.25	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	db226425x2266557.e.element	1	50.00	Using index condition; Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.04 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:268
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:392
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.54 ms After last query: 17.93 ms Query memory: 0.028 MB Memory before query: 2.832 MB Rows returned: 37

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `huwg9_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	114	33.33	Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.23 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.45 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:45
13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.73 ms After last query: 3.10 ms Query memory: 0.024 MB Memory before query: 2.919 MB Rows returned: 0

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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM huwg9_content AS a

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

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

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

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

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

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-01-28 10:03:08') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-01-28 10:03:08')

  ORDER BY c.lft,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 9

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid,idx_featured_catid,jr_listing_count	idx_state	1	const	1	5.56	Using where; Using temporary; Using filesort
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	db226425x2266557.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	db226425x2266557.a.modified_by	1	100.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	db226425x2266557.a.catid	1	10.00	Using where
1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	db226425x2266557.c.parent_id	1	100.00	Using where
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	db226425x2266557.a.id	1	100.00	Using where

Profile

Status	Duration
starting	0.33 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.70 ms
init	0.16 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.21 ms
preparing	0.06 ms
Creating tmp table	0.16 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.29 ms
Creating sort index	0.06 ms
end	0.02 ms
query end	0.02 ms
removing tmp table	0.05 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.11 ms After last query: 2.41 ms Query memory: 0.023 MB Memory before query: 2.929 MB Rows returned: 1

SELECT COUNT(*)

  FROM huwg9_content AS a

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

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

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

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

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

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-01-28 10:03:08') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-01-28 10:03:08')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid,idx_featured_catid,jr_listing_count	idx_state	1	const	1	5.56	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	db226425x2266557.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	db226425x2266557.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	db226425x2266557.a.catid	1	10.00	Using where
1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	db226425x2266557.c.parent_id	1	100.00	Using where; Using index
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	db226425x2266557.a.id	1	100.00	Using where; Using index

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.04 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.42 ms After last query: 64.71 ms Query memory: 0.325 MB Memory before query: 3.266 MB Rows returned: 23

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

  FROM huwg9_modules AS m

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

  LEFT JOIN huwg9_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 <= '2023-01-28 10:03:08') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-01-28 10:03:08') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 640 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	6	NULL	31	1.60	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	db226425x2266557.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	db226425x2266557.m.id	1	40.00	Using where; Using index

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.38 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/gk_musicstate/lib/framework/helper.api.php:36
12	GKTemplateAPI->modules()	JROOT/templates/gk_musicstate/lib/framework/helper.layout.php:55
11	GKTemplateLayout->generateLayoutWidths()	JROOT/templates/gk_musicstate/layouts/default.php:62
10	include JROOT/templates/gk_musicstate/layouts/default.php	JROOT/templates/gk_musicstate/lib/gk.framework.php:149
9	GKTemplate->getLayout()	JROOT/templates/gk_musicstate/lib/gk.framework.php:92
8	GKTemplate->__construct()	JROOT/templates/gk_musicstate/index.php:26
7	require JROOT/templates/gk_musicstate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 25.92 ms Query memory: 0.026 MB Memory before query: 3.976 MB Rows returned: 1

Duplicate queries: #24 #28 #34 #38 #42 #46 #50 #54 #58 #62 #66 #70 #74 #78 #82 #86

select enabled 
  from huwg9_extensions 
  where type="component" 
  and element = "com_k2"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/helper.php:82
16	NSP_GK5_Helper->getComponentStatus()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.63 ms After last query: 2.94 ms Query memory: 0.026 MB Memory before query: 3.986 MB Rows returned: 7

Duplicate queries: #25

SELECT
					c.id AS CID
				
  FROM
					huwg9_k2_categories AS c
				
  LEFT JOIN
					huwg9_k2_items AS content
					
  ON
					c.id = content.catid
				
				
  WHERE
					1=1
					 
  AND ( c.id = 26) 
					
  AND
					c.published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	content	NULL	ref	catid	catid	4	const	7	100.00	Using index

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:82
17	NSP_GK5_com_k2_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:108
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.00 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 3.998 MB Rows returned: 1

SELECT
			content.id AS id
		
  FROM
			huwg9_k2_items AS content
			
			
		
  WHERE
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1) 
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-01-28 11:03:08' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-01-28 11:03:08' )
			 
  AND (  content.catid = 26 ) 
			
			
			
			

		

		
  ORDER BY
			 content.created DESC 
		
  LIMIT
			0,1;

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	index	catid,idx_item	created	5	NULL	1	5.00	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.25 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:267
17	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.17 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.011 MB Rows returned: 1

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,
			content.access AS access,
			content.catid AS cid,
			content.video AS video,
			content.plugins AS plugins,
			categories.name AS catname,
			categories.image AS cat_image,
			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
			huwg9_k2_items AS content
			
  LEFT JOIN
				huwg9_k2_categories AS categories
				
  ON categories.id = content.catid
			
  LEFT JOIN
				huwg9_users AS users
				
  ON users.id = content.created_by
			
  LEFT JOIN
				huwg9_k2_rating AS content_rating
				
  ON content_rating.itemID = content.id
		
  WHERE
			1=1
			 
  AND ( content.id = 288)
		
  ORDER BY
			 content.created DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	content_rating	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.16 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:326
17	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.35 ms After last query: 43.80 ms Query memory: 0.032 MB Memory before query: 4.093 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `huwg9_users`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `huwg9_users`

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
removing tmp table	0.08 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
29	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
28	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
27	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
26	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
25	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
24	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
23	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
22	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
21	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
20	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/helpers/route.php:85
19	K2HelperRoute::getUserRoute()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:85
18	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
17	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:196
16	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:34
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 0.99 ms Query memory: 0.028 MB Memory before query: 4.129 MB Rows returned: 1

SELECT *

  FROM `huwg9_users`

  WHERE `id` = 934

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
25	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
24	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
23	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
22	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
21	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
20	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/helpers/route.php:85
19	K2HelperRoute::getUserRoute()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:85
18	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
17	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:196
16	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:34
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 7.57 ms Query memory: 0.028 MB Memory before query: 4.144 MB Rows returned: 0

SELECT `g`.`id`,`g`.`title`

  FROM `huwg9_usergroups` AS g

  INNER JOIN `huwg9_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 934

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	db226425x2266557.m.group_id	1	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
25	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
24	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
23	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
22	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
21	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
20	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/helpers/route.php:85
19	K2HelperRoute::getUserRoute()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:85
18	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
17	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:196
16	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:34
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 2.66 ms Query memory: 0.025 MB Memory before query: 4.156 MB Rows returned: 1

Duplicate queries: #17 #28 #34 #38 #42 #46 #50 #54 #58 #62 #66 #70 #74 #78 #82 #86

select enabled 
  from huwg9_extensions 
  where type="component" 
  and element = "com_k2"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/helper.php:82
16	NSP_GK5_Helper->getComponentStatus()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 4.166 MB Rows returned: 7

Duplicate queries: #18

SELECT
					c.id AS CID
				
  FROM
					huwg9_k2_categories AS c
				
  LEFT JOIN
					huwg9_k2_items AS content
					
  ON
					c.id = content.catid
				
				
  WHERE
					1=1
					 
  AND ( c.id = 26) 
					
  AND
					c.published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	content	NULL	ref	catid	catid	4	const	7	100.00	Using index

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:82
17	NSP_GK5_com_k2_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:108
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.09 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 4.177 MB Rows returned: 1

SELECT
			content.id AS id
		
  FROM
			huwg9_k2_items AS content
			
			
		
  WHERE
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1) 
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-01-28 11:03:08' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-01-28 11:03:08' )
			 
  AND (  content.catid = 26 ) 
			
			
			
			

		

		
  ORDER BY
			 content.created DESC 
		
  LIMIT
			1,1;

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	index	catid,idx_item	created	5	NULL	2	2.50	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Sorting result	0.04 ms
executing	0.01 ms
Sending data	0.36 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:267
17	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.92 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.190 MB Rows returned: 1

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,
			content.access AS access,
			content.catid AS cid,
			content.video AS video,
			content.plugins AS plugins,
			categories.name AS catname,
			categories.image AS cat_image,
			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
			huwg9_k2_items AS content
			
  LEFT JOIN
				huwg9_k2_categories AS categories
				
  ON categories.id = content.catid
			
  LEFT JOIN
				huwg9_users AS users
				
  ON users.id = content.created_by
			
  LEFT JOIN
				huwg9_k2_rating AS content_rating
				
  ON content_rating.itemID = content.id
		
  WHERE
			1=1
			 
  AND ( content.id = 272)
		
  ORDER BY
			 content.created DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	content_rating	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:326
17	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.81 ms After last query: 57.04 ms Query memory: 0.025 MB Memory before query: 4.226 MB Rows returned: 1

Duplicate queries: #17 #24 #34 #38 #42 #46 #50 #54 #58 #62 #66 #70 #74 #78 #82 #86

select enabled 
  from huwg9_extensions 
  where type="component" 
  and element = "com_k2"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/helper.php:82
16	NSP_GK5_Helper->getComponentStatus()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 4.236 MB Rows returned: 19

Duplicate queries: #35 #39 #43 #47 #51

SELECT
					c.id AS CID
				
  FROM
					huwg9_k2_categories AS c
				
  LEFT JOIN
					huwg9_k2_items AS content
					
  ON
					c.id = content.catid
				
				
  WHERE
					1=1
					 
  AND ( c.id = 32) 
					
  AND
					c.published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	content	NULL	ref	catid	catid	4	const	19	100.00	Using index

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:82
17	NSP_GK5_com_k2_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:108
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.84 ms After last query: 0.12 ms Query memory: 0.025 MB Memory before query: 4.247 MB Rows returned: 1

SELECT
			content.id AS id
		
  FROM
			huwg9_k2_items AS content
			
			
		
  WHERE
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1) 
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-01-28 11:03:08' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-01-28 11:03:08' )
			 
  AND (  content.catid = 32 ) 
			
			
			
			

		

		
  ORDER BY
			 content.created DESC 
		
  LIMIT
			0,1;

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	index	catid,idx_item	created	5	NULL	1	5.00	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:267
17	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.06 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.260 MB Rows returned: 1

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,
			content.access AS access,
			content.catid AS cid,
			content.video AS video,
			content.plugins AS plugins,
			categories.name AS catname,
			categories.image AS cat_image,
			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
			huwg9_k2_items AS content
			
  LEFT JOIN
				huwg9_k2_categories AS categories
				
  ON categories.id = content.catid
			
  LEFT JOIN
				huwg9_users AS users
				
  ON users.id = content.created_by
			
  LEFT JOIN
				huwg9_k2_rating AS content_rating
				
  ON content_rating.itemID = content.id
		
  WHERE
			1=1
			 
  AND ( content.id = 283)
		
  ORDER BY
			 content.created DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	content_rating	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.09 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:326
17	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.75 ms After last query: 22.42 ms Query memory: 0.028 MB Memory before query: 4.275 MB Rows returned: 1

SELECT *

  FROM `huwg9_users`

  WHERE `id` = 77

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
25	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
24	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
23	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
22	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
21	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
20	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/helpers/route.php:85
19	K2HelperRoute::getUserRoute()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:85
18	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
17	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:196
16	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:34
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.73 ms After last query: 0.12 ms Query memory: 0.029 MB Memory before query: 4.297 MB Rows returned: 1

SELECT `g`.`id`,`g`.`title`

  FROM `huwg9_usergroups` AS g

  INNER JOIN `huwg9_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 77

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	db226425x2266557.m.group_id	1	100.00	NULL

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
25	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
24	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
23	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
22	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
21	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
20	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/helpers/route.php:85
19	K2HelperRoute::getUserRoute()	JROOT/modules/mod_news_pro_gk5/tmpl/com_k2/view.php:85
18	NSP_GK5_com_k2_View::info()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/controller.php:43
17	NSP_GK5_com_k2_Controller->initialize()	JROOT/modules/mod_news_pro_gk5/helper.php:196
16	NSP_GK5_Helper->renderLayout()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:34
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 1.12 ms Query memory: 0.025 MB Memory before query: 4.308 MB Rows returned: 1

Duplicate queries: #17 #24 #28 #38 #42 #46 #50 #54 #58 #62 #66 #70 #74 #78 #82 #86

select enabled 
  from huwg9_extensions 
  where type="component" 
  and element = "com_k2"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/helper.php:82
16	NSP_GK5_Helper->getComponentStatus()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.86 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.318 MB Rows returned: 19

Duplicate queries: #29 #39 #43 #47 #51

SELECT
					c.id AS CID
				
  FROM
					huwg9_k2_categories AS c
				
  LEFT JOIN
					huwg9_k2_items AS content
					
  ON
					c.id = content.catid
				
				
  WHERE
					1=1
					 
  AND ( c.id = 32) 
					
  AND
					c.published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	content	NULL	ref	catid	catid	4	const	19	100.00	Using index

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.03 ms
System lock	0.06 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:82
17	NSP_GK5_com_k2_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:108
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.29 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 4.329 MB Rows returned: 1

SELECT
			content.id AS id
		
  FROM
			huwg9_k2_items AS content
			
			
		
  WHERE
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1) 
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-01-28 11:03:08' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-01-28 11:03:08' )
			 
  AND (  content.catid = 32 ) 
			
			
			
			

		

		
  ORDER BY
			 content.created DESC 
		
  LIMIT
			1,1;

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	index	catid,idx_item	created	5	NULL	2	2.50	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.50 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:267
17	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.01 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.342 MB Rows returned: 1

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,
			content.access AS access,
			content.catid AS cid,
			content.video AS video,
			content.plugins AS plugins,
			categories.name AS catname,
			categories.image AS cat_image,
			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
			huwg9_k2_items AS content
			
  LEFT JOIN
				huwg9_k2_categories AS categories
				
  ON categories.id = content.catid
			
  LEFT JOIN
				huwg9_users AS users
				
  ON users.id = content.created_by
			
  LEFT JOIN
				huwg9_k2_rating AS content_rating
				
  ON content_rating.itemID = content.id
		
  WHERE
			1=1
			 
  AND ( content.id = 282)
		
  ORDER BY
			 content.created DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	content_rating	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:326
17	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.93 ms After last query: 25.52 ms Query memory: 0.025 MB Memory before query: 4.353 MB Rows returned: 1

Duplicate queries: #17 #24 #28 #34 #42 #46 #50 #54 #58 #62 #66 #70 #74 #78 #82 #86

select enabled 
  from huwg9_extensions 
  where type="component" 
  and element = "com_k2"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.07 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/helper.php:82
16	NSP_GK5_Helper->getComponentStatus()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.97 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.363 MB Rows returned: 19

Duplicate queries: #29 #35 #43 #47 #51

SELECT
					c.id AS CID
				
  FROM
					huwg9_k2_categories AS c
				
  LEFT JOIN
					huwg9_k2_items AS content
					
  ON
					c.id = content.catid
				
				
  WHERE
					1=1
					 
  AND ( c.id = 32) 
					
  AND
					c.published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	content	NULL	ref	catid	catid	4	const	19	100.00	Using index

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:82
17	NSP_GK5_com_k2_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:108
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.80 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 4.374 MB Rows returned: 1

SELECT
			content.id AS id
		
  FROM
			huwg9_k2_items AS content
			
			
		
  WHERE
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1) 
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-01-28 11:03:08' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-01-28 11:03:08' )
			 
  AND (  content.catid = 32 ) 
			
			
			
			

		

		
  ORDER BY
			 content.created DESC 
		
  LIMIT
			2,1;

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	index	catid,idx_item	created	5	NULL	3	1.82	Using where

Profile

Status	Duration
starting	0.32 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.69 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:267
17	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.06 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.387 MB Rows returned: 1

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,
			content.access AS access,
			content.catid AS cid,
			content.video AS video,
			content.plugins AS plugins,
			categories.name AS catname,
			categories.image AS cat_image,
			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
			huwg9_k2_items AS content
			
  LEFT JOIN
				huwg9_k2_categories AS categories
				
  ON categories.id = content.catid
			
  LEFT JOIN
				huwg9_users AS users
				
  ON users.id = content.created_by
			
  LEFT JOIN
				huwg9_k2_rating AS content_rating
				
  ON content_rating.itemID = content.id
		
  WHERE
			1=1
			 
  AND ( content.id = 267)
		
  ORDER BY
			 content.created DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	content_rating	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:326
17	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.74 ms After last query: 24.88 ms Query memory: 0.025 MB Memory before query: 4.398 MB Rows returned: 1

Duplicate queries: #17 #24 #28 #34 #38 #46 #50 #54 #58 #62 #66 #70 #74 #78 #82 #86

select enabled 
  from huwg9_extensions 
  where type="component" 
  and element = "com_k2"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/helper.php:82
16	NSP_GK5_Helper->getComponentStatus()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.78 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.407 MB Rows returned: 19

Duplicate queries: #29 #35 #39 #47 #51

SELECT
					c.id AS CID
				
  FROM
					huwg9_k2_categories AS c
				
  LEFT JOIN
					huwg9_k2_items AS content
					
  ON
					c.id = content.catid
				
				
  WHERE
					1=1
					 
  AND ( c.id = 32) 
					
  AND
					c.published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,category,published	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	content	NULL	ref	catid	catid	4	const	19	100.00	Using index

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:82
17	NSP_GK5_com_k2_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:108
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.44 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 4.419 MB Rows returned: 1

SELECT
			content.id AS id
		
  FROM
			huwg9_k2_items AS content
			
			
		
  WHERE
			content.published = 1 
  AND content.trash = 0
                 
  AND content.access IN (1,1) 
		 		
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2023-01-28 11:03:08' )
				
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2023-01-28 11:03:08' )
			 
  AND (  content.catid = 32 ) 
			
			
			
			

		

		
  ORDER BY
			 content.created DESC 
		
  LIMIT
			3,1;

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	index	catid,idx_item	created	5	NULL	4	1.82	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.64 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:267
17	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.92 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.432 MB Rows returned: 1

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,
			content.access AS access,
			content.catid AS cid,
			content.video AS video,
			content.plugins AS plugins,
			categories.name AS catname,
			categories.image AS cat_image,
			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
			huwg9_k2_items AS content
			
  LEFT JOIN
				huwg9_k2_categories AS categories
				
  ON categories.id = content.catid
			
  LEFT JOIN
				huwg9_users AS users
				
  ON users.id = content.created_by
			
  LEFT JOIN
				huwg9_k2_rating AS content_rating
				
  ON content_rating.itemID = content.id
		
  WHERE
			1=1
			 
  AND ( content.id = 279)
		
  ORDER BY
			 content.created DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	content_rating	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:326
17	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
16	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.77 ms After last query: 24.22 ms Query memory: 0.025 MB Memory before query: 4.442 MB Rows returned: 1

Duplicate queries: #17 #24 #28 #34 #38 #42 #50 #54 #58 #62 #66 #70 #74 #78 #82 #86

select enabled 
  from huwg9_extensions 
  where type="component" 
  and element = "com_k2"

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	huwg9_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/helper.php:82
16	NSP_GK5_Helper->getComponentStatus()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29
15	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/modules/mod_grid_gk5/helper.php:118
13	GridGK5Helper->moduleRender()	JROOT/modules/mod_grid_gk5/tmpl/default.php:27
12	require JROOT/modules/mod_grid_gk5/tmpl/default.php	JROOT/modules/mod_grid_gk5/helper.php:85
11	GridGK5Helper->render()	JROOT/modules/mod_grid_gk5/mod_grid_gk5.php:23
10	include JROOT/modules/mod_grid_gk5/mod_grid_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.72 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.452 MB Rows returned: 19

Aktuelles

St Patrick´s day celebrations 2023

Don't stop me now 2022

St Patrick´s day celebrations 2019

Hedgehogs Garden sind

Angela Gans

Rainer Wisniewski

Felix Peña

Fabian Piwonka

Susanne Rebhahn

Stefan Jeuk

Bilder

01 August 2015 Rouvre Sur Aube

11 Dezember 2013 Lit Cafe PH Ludwigsburg

03 August 2013 Rouvre Sur Aube

29 Juli 2010 Rouvre Sur Aube

02 Februar 2010 Literatur Cafe PH Ludwig…

22 Oktober 2009 Maxstraße Eins

CDs

2016 Live im Lit Cafe PH Ludwigsburg

2005 Animal

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

89 Queries Logged 99.39 ms

34 duplicate found!