Giclee Art by Warren Percell Sr - a California Artist

Sanctuary

Category: Art

18" x 24" Giclee

More...

Screaming Vase In The Dark

Category: Art

18" x 24" Giclee

More...

September Song

Category: Art

18" x 24" Giclee

More...

Shayman Beat

Category: Art

18" x 24" Giclee

More...

Silver Serenade

Category: Art

18" x 24" Giclee

More...

Summer Day

Category: Art

18" x 24" Giclee

More...

Summer Vision

Category: Art

18" x 24" Giclee

More...

Sunset Seranade

Category: Art

18" x 24" Giclee

More...

Timeless Passage

Category: Art

18" x 24" Giclee

More...

Tranquill Water

Category: Art

18" x 24" Giclee

More...

Valley Dawn

Category: Art

18" x 24" Giclee

More...

Start
Prev
1
2
Next
End

Main Menu

Login Form

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1791675352,
                "last": 1791675352,
                "now": 1791675352
            },
            "token": "ZQPhBlsYLXILBiNaF5gQZhoAKWOSM5FW"
        },
        "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
        }
    }
}

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nz88qu8e0mjos_session	const	PRIMARY	PRIMARY	194	const	1

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nz88qu8e0mjos_session	const	PRIMARY	PRIMARY	194	const	1

#	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 `nz88qu8e0mjos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3039663864313363613339636430393735663166626335343332646132393864', 1, 1791675352, 0, '', 0)

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.12 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	1.24 ms
Writing to binlog	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 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: 0.80 ms After last query: 1.79 ms Query memory: 0.024 MB Memory before query: 4.442 MB Rows returned: 39

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

  FROM `nz88qu8e0mjos_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nz88qu8e0mjos_extensions	ref	extension	extension	82	const	39	Using index condition; Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.34 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 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.32 ms After last query: 1.74 ms Query memory: 0.021 MB Memory before query: 4.697 MB Rows returned: 5

SELECT id, rules

  FROM `nz88qu8e0mjos_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 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: 0.36 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 4.709 MB Rows returned: 2

SELECT b.id

  FROM nz88qu8e0mjos_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.02 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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: 0.67 ms After last query: 0.55 ms Query memory: 0.030 MB Memory before query: 4.778 MB Rows returned: 83

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

  FROM nz88qu8e0mjos_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.28 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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.37 ms After last query: 11.36 ms Query memory: 0.028 MB Memory before query: 6.267 MB Rows returned: 10

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

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	11	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db712232021.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.76 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.02 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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.48 ms After last query: 5.74 ms Query memory: 0.023 MB Memory before query: 6.899 MB Rows returned: 1

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

  FROM `nz88qu8e0mjos_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	nz88qu8e0mjos_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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.82 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 6.890 MB

UPDATE `nz88qu8e0mjos_extensions`

  SET `params` = '{\"mediaversion\":\"38d19b3dc46f21b6ea6939e663d8f16f\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `nz88qu8e0mjos_extensions` SET `params` = '{\"mediaversion\":\"38d19b3dc46f21b6ea6939e663d8f16f\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
checking permissions	0.00 ms
After opening tables	0.00 ms
init for update	0.00 ms
init	0.01 ms
Updating main table	0.01 ms
init	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.00 ms
init for update	0.04 ms
Updating	0.12 ms
End of update loop	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	1.30 ms
Writing to binlog	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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: 0.42 ms After last query: 1.64 ms Query memory: 0.019 MB Memory before query: 7.088 MB Rows returned: 1

SELECT *

  FROM nz88qu8e0mjos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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: 0.43 ms After last query: 0.18 ms Query memory: 0.019 MB Memory before query: 7.105 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM nz88qu8e0mjos_template_styles as s

  LEFT JOIN nz88qu8e0mjos_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	db712232021.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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.45 ms After last query: 4.82 ms Query memory: 0.023 MB Memory before query: 7.695 MB Rows returned: 1

SELECT c.*, img.fullname AS item_image, img.caption AS image_caption, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug  
  FROM nz88qu8e0mjos_djc2_categories AS c 
  LEFT JOIN (select im1.fullname, im1.caption, im1.type, im1.item_id 
  from nz88qu8e0mjos_djc2_images as im1, (select item_id, type, min(ordering) as lowest_order 
  from nz88qu8e0mjos_djc2_images 
  group by item_id, type) as im2 
  where im1.item_id = im2.item_id 
  and im1.type=im2.type 
  and im1.ordering = im2.lowest_order) AS img 
  ON img.item_id = c.id 
  AND img.type='category' 
  ORDER BY c.parent_id ASC, c.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort
1	PRIMARY	im1	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	PRIMARY	<derived3>	ref	key0	key0	4	db712232021.c.id	1	Using where
3	DERIVED	nz88qu8e0mjos_djc2_images	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.16 ms
Optimizing	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.48 ms
Creating sort index	0.06 ms
Removing tmp table	0.07 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:223
13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:105
12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:141
11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:48
10	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/helpers/theme.php:39
9	DJCatalog2ThemeHelper::setThemeAssets()	JROOT/components/com_djcatalog2/controller.php:42
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:55
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.20 ms After last query: 8.74 ms Query memory: 0.023 MB Memory before query: 8.653 MB Rows returned: 1

SELECT c.*, img.fullname AS item_image, img.caption AS image_caption, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug  
  FROM nz88qu8e0mjos_djc2_categories AS c 
  LEFT JOIN (select im1.fullname, im1.caption, im1.type, im1.item_id 
  from nz88qu8e0mjos_djc2_images as im1, (select item_id, type, min(ordering) as lowest_order 
  from nz88qu8e0mjos_djc2_images 
  group by item_id, type) as im2 
  where im1.item_id = im2.item_id 
  and im1.type=im2.type 
  and im1.ordering = im2.lowest_order) AS img 
  ON img.item_id = c.id 
  AND img.type='category' 
  WHERE c.published=1 
  ORDER BY c.parent_id ASC, c.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort
1	PRIMARY	im1	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	PRIMARY	<derived3>	ref	key0	key0	4	db712232021.c.id	1	Using where
3	DERIVED	nz88qu8e0mjos_djc2_images	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort

Profile

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.08 ms
Optimizing	0.04 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.03 ms
Executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.04 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:223
13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:105
12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:141
11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/views/items/view.html.php:92
10	DJCatalog2ViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:44
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:55
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 0.67 ms After last query: 0.16 ms Query memory: 0.024 MB Memory before query: 8.671 MB Rows returned: 0

Duplicate queries: #22

SELECT f.*, group_concat(fo.id 
  order by fo.ordering asc separator '|') as options

  FROM nz88qu8e0mjos_djc2_items_extra_fields as f

  LEFT JOIN nz88qu8e0mjos_djc2_items_extra_fields_options as fo 
  ON fo.field_id=f.id

  WHERE f.published = 1

  GROUP BY f.id

  ORDER BY f.ordering asc, fo.ordering asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort
1	SIMPLE	fo	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Creating tmp table	0.04 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.17 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.00 ms
Removing tmp table	0.04 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Removing tmp table	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:435
15	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:179
14	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:170
13	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
12	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:150
11	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:94
10	DJCatalog2ViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:44
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:55
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.79 ms After last query: 0.12 ms Query memory: 0.078 MB Memory before query: 8.696 MB Rows returned: 41

SELECT distinct i.*,
  CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(":", i.id, i.alias) ELSE i.id END as slug ,c.id as _category_id, c.name as category, c.published as publish_category,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug ,p.id as _producer_id, p.name as producer, p.published as publish_producer,
  CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as prodslug ,img.fullname as item_image, img.caption AS image_caption,group_concat(distinct ic.category_id 
  order by ic.category_id asc separator '|') AS categorylist

  FROM nz88qu8e0mjos_djc2_items as i

  INNER JOIN (SELECT ic.item_id 
  FROM nz88qu8e0mjos_djc2_items_categories AS ic 
  INNER JOIN nz88qu8e0mjos_djc2_categories AS c 
  ON c.id=ic.category_id 
  WHERE c.published = 1 
  AND ic.category_id IN (1)) as category_filter 
  ON i.id = category_filter.item_id

  LEFT JOIN nz88qu8e0mjos_djc2_categories AS c 
  ON c.id = i.cat_id

  LEFT JOIN nz88qu8e0mjos_djc2_producers AS p 
  ON p.id = i.producer_id

  LEFT JOIN (select im1.fullname, im1.caption, im1.type, im1.item_id 
  from nz88qu8e0mjos_djc2_images as im1, (select item_id, type, min(ordering) as lowest_order 
  from nz88qu8e0mjos_djc2_images 
  group by item_id, type) as im2 
  where im1.item_id = im2.item_id 
  and im1.type=im2.type 
  and im1.ordering = im2.lowest_order 
  group by im1.type, im1.item_id) AS img 
  ON img.item_id = i.id 
  AND img.type='item'

  LEFT JOIN nz88qu8e0mjos_djc2_items_categories AS ic 
  ON ic.item_id=i.id

  WHERE i.published = 1

  GROUP BY i.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	ic	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	41	Using where
1	PRIMARY	i	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	db712232021.i.cat_id	1
1	PRIMARY	p	eq_ref	PRIMARY	PRIMARY	4	db712232021.i.producer_id	1
1	PRIMARY	<derived3>	ref	key0	key0	5	db712232021.ic.item_id	1	Using where
1	PRIMARY	ic	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	41	Using where; Using join buffer (flat, BNL join)
3	DERIVED	im1	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort
3	DERIVED	<derived4>	ref	key0	key0	203	db712232021.im1.item_id,db712232021.im1.type,db712232021.im1.ordering	1
4	DERIVED	nz88qu8e0mjos_djc2_images	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.12 ms
Optimizing	0.04 ms
Optimizing	0.01 ms
Optimizing	0.00 ms
Statistics	0.02 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Statistics	0.09 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.12 ms
Sorting result	0.04 ms
Executing	0.00 ms
Sending data	0.08 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
Removing tmp table	0.00 ms
Creating sort index	0.00 ms
Removing tmp table	0.00 ms
Creating sort index	1.07 ms
Creating sort index	0.25 ms
Removing tmp table	0.14 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Removing tmp table	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
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:323
12	Joomla\CMS\MVC\Model\ListModel->getStart()	JROOT/components/com_djcatalog2/models/items.php:152
11	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:94
10	DJCatalog2ViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:44
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:55
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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.91 ms After last query: 0.07 ms Query memory: 0.046 MB Memory before query: 8.696 MB Rows returned: 11

SELECT distinct i.*,
  CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(":", i.id, i.alias) ELSE i.id END as slug ,c.id as _category_id, c.name as category, c.published as publish_category,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug ,p.id as _producer_id, p.name as producer, p.published as publish_producer,
  CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as prodslug ,img.fullname as item_image, img.caption AS image_caption,group_concat(distinct ic.category_id 
  order by ic.category_id asc separator '|') AS categorylist

  FROM nz88qu8e0mjos_djc2_items as i

  INNER JOIN (SELECT ic.item_id 
  FROM nz88qu8e0mjos_djc2_items_categories AS ic 
  INNER JOIN nz88qu8e0mjos_djc2_categories AS c 
  ON c.id=ic.category_id 
  WHERE c.published = 1 
  AND ic.category_id IN (1)) as category_filter 
  ON i.id = category_filter.item_id

  LEFT JOIN nz88qu8e0mjos_djc2_categories AS c 
  ON c.id = i.cat_id

  LEFT JOIN nz88qu8e0mjos_djc2_producers AS p 
  ON p.id = i.producer_id

  LEFT JOIN (select im1.fullname, im1.caption, im1.type, im1.item_id 
  from nz88qu8e0mjos_djc2_images as im1, (select item_id, type, min(ordering) as lowest_order 
  from nz88qu8e0mjos_djc2_images 
  group by item_id, type) as im2 
  where im1.item_id = im2.item_id 
  and im1.type=im2.type 
  and im1.ordering = im2.lowest_order 
  group by im1.type, im1.item_id) AS img 
  ON img.item_id = i.id 
  AND img.type='item'

  LEFT JOIN nz88qu8e0mjos_djc2_items_categories AS ic 
  ON ic.item_id=i.id

  WHERE i.published = 1

  GROUP BY i.id

  ORDER BY  i.ordering asc, c.ordering asc 
  LIMIT 30, 30

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	ic	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	41	Using where
1	PRIMARY	i	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	db712232021.i.cat_id	1
1	PRIMARY	p	eq_ref	PRIMARY	PRIMARY	4	db712232021.i.producer_id	1
1	PRIMARY	<derived3>	ref	key0	key0	5	db712232021.ic.item_id	1	Using where
1	PRIMARY	ic	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	41	Using where; Using join buffer (flat, BNL join)
3	DERIVED	im1	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort
3	DERIVED	<derived4>	ref	key0	key0	203	db712232021.im1.item_id,db712232021.im1.type,db712232021.im1.ordering	1
4	DERIVED	nz88qu8e0mjos_djc2_images	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort

Profile

Status	Duration
Starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.11 ms
Optimizing	0.04 ms
Optimizing	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.06 ms
Creating tmp table	0.05 ms
Sorting result	0.04 ms
Executing	0.00 ms
Sending data	0.05 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.00 ms
Removing tmp table	0.00 ms
Creating sort index	1.10 ms
Creating sort index	0.41 ms
Creating sort index	0.11 ms
Removing tmp table	0.08 ms
Creating sort index	0.01 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Removing tmp table	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:134
12	DJCatalog2ModelItems->_getList()	JROOT/components/com_djcatalog2/models/items.php:152
11	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:94
10	DJCatalog2ViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:44
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:55
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 0.45 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 8.741 MB Rows returned: 0

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value

  FROM nz88qu8e0mjos_djc2_items_extra_fields_values_int as fieldvalues

  INNER JOIN nz88qu8e0mjos_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN nz88qu8e0mjos_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  LEFT JOIN nz88qu8e0mjos_djc2_items_extra_fields_options as fieldoptions 
  ON fieldoptions.id = fieldvalues.value 
  AND fieldoptions.field_id = fields.id

  WHERE fieldvalues.item_id IN (31,32,33,34,35,36,37,38,39,40,41) 
  AND (fields.visibility = 2 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fieldvalues.field_id asc, fieldvalues.field_id asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fieldvalues	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort
1	SIMPLE	items	eq_ref	PRIMARY	PRIMARY	4	db712232021.fieldvalues.item_id	1
1	SIMPLE	fields	eq_ref	PRIMARY	PRIMARY	4	db712232021.fieldvalues.field_id	1	Using where
1	SIMPLE	fieldoptions	eq_ref	PRIMARY	PRIMARY	4	db712232021.fieldvalues.value	1	Using where

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:468
12	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:164
11	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:94
10	DJCatalog2ViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:44
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:55
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 0.45 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 8.748 MB Rows returned: 0

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value

  FROM nz88qu8e0mjos_djc2_items_extra_fields_values_text as fieldvalues

  INNER JOIN nz88qu8e0mjos_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN nz88qu8e0mjos_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  WHERE fieldvalues.item_id IN (31,32,33,34,35,36,37,38,39,40,41) 
  AND (fields.visibility = 2 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fieldvalues.field_id asc, fieldvalues.field_id asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fieldvalues	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort
1	SIMPLE	items	eq_ref	PRIMARY	PRIMARY	4	db712232021.fieldvalues.item_id	1
1	SIMPLE	fields	eq_ref	PRIMARY	PRIMARY	4	db712232021.fieldvalues.field_id	1	Using where

Profile

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:471
12	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:164
11	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:94
10	DJCatalog2ViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:44
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:55
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 0.48 ms After last query: 2.38 ms Query memory: 0.022 MB Memory before query: 8.944 MB Rows returned: 0

Duplicate queries: #21

SELECT DISTINCT p.id, p.name as text,  
  CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as value  
  FROM nz88qu8e0mjos_djc2_producers as p  
  INNER JOIN nz88qu8e0mjos_djc2_items AS i 
  ON p.id = i.producer_id  
  INNER JOIN nz88qu8e0mjos_djc2_categories AS c 
  ON c.id = i.cat_id  
  WHERE c.id IN (1) 
  AND p.published=1 
  ORDER BY text

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using temporary; Using filesort
1	SIMPLE	p	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	i	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	41	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:516
11	DJCatalog2ModelItems->getProducers()	JROOT/components/com_djcatalog2/views/items/view.html.php:110
10	DJCatalog2ViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:44
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:55
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 0.38 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 8.950 MB Rows returned: 0

Duplicate queries: #20

SELECT DISTINCT p.id, p.name as text,  
  CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as value  
  FROM nz88qu8e0mjos_djc2_producers as p  
  INNER JOIN nz88qu8e0mjos_djc2_items AS i 
  ON p.id = i.producer_id  
  INNER JOIN nz88qu8e0mjos_djc2_categories AS c 
  ON c.id = i.cat_id  
  WHERE c.id IN (1) 
  AND p.published=1 
  ORDER BY text

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	Using temporary; Using filesort
1	SIMPLE	p	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	i	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	41	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:517
11	DJCatalog2ModelItems->getProducers()	JROOT/components/com_djcatalog2/views/items/view.html.php:110
10	DJCatalog2ViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:44
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:55
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 0.69 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 8.971 MB Rows returned: 0

Duplicate queries: #15

SELECT f.*, group_concat(fo.id 
  order by fo.ordering asc separator '|') as options

  FROM nz88qu8e0mjos_djc2_items_extra_fields as f

  LEFT JOIN nz88qu8e0mjos_djc2_items_extra_fields_options as fo 
  ON fo.field_id=f.id

  WHERE f.published = 1

  GROUP BY f.id

  ORDER BY f.ordering asc, fo.ordering asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort
1	SIMPLE	fo	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Creating tmp table	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.22 ms
Creating sort index	0.02 ms
Removing tmp table	0.00 ms
Creating sort index	0.00 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Removing tmp table	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:435
13	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:179
12	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:607
11	DJCatalog2ModelItems->getIndexCount()	JROOT/components/com_djcatalog2/views/items/view.html.php:114
10	DJCatalog2ViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:44
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:55
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 4.54 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 8.991 MB Rows returned: 1

SELECT  count(a.id) as a,  count(b.id) as b,  count(c.id) as c,  count(d.id) as d,  count(e.id) as e,  count(f.id) as f,  count(g.id) as g,  count(h.id) as h,  count(i.id) as i,  count(j.id) as j,  count(k.id) as k,  count(l.id) as l,  count(m.id) as m,  count(n.id) as n,  count(o.id) as o,  count(p.id) as p,  count(q.id) as q,  count(r.id) as r,  count(s.id) as s,  count(t.id) as t,  count(u.id) as u,  count(v.id) as v,  count(w.id) as w,  count(x.id) as x,  count(y.id) as y,  count(z.id) as z
 
  FROM nz88qu8e0mjos_djc2_items as items 

  left join nz88qu8e0mjos_djc2_items as a 
  on a.id = items.id 
  and lower(a.name) like 'a%'

  left join nz88qu8e0mjos_djc2_items as b 
  on b.id = items.id 
  and lower(b.name) like 'b%'

  left join nz88qu8e0mjos_djc2_items as c 
  on c.id = items.id 
  and lower(c.name) like 'c%'

  left join nz88qu8e0mjos_djc2_items as d 
  on d.id = items.id 
  and lower(d.name) like 'd%'

  left join nz88qu8e0mjos_djc2_items as e 
  on e.id = items.id 
  and lower(e.name) like 'e%'

  left join nz88qu8e0mjos_djc2_items as f 
  on f.id = items.id 
  and lower(f.name) like 'f%'

  left join nz88qu8e0mjos_djc2_items as g 
  on g.id = items.id 
  and lower(g.name) like 'g%'

  left join nz88qu8e0mjos_djc2_items as h 
  on h.id = items.id 
  and lower(h.name) like 'h%'

  left join nz88qu8e0mjos_djc2_items as i 
  on i.id = items.id 
  and lower(i.name) like 'i%'

  left join nz88qu8e0mjos_djc2_items as j 
  on j.id = items.id 
  and lower(j.name) like 'j%'

  left join nz88qu8e0mjos_djc2_items as k 
  on k.id = items.id 
  and lower(k.name) like 'k%'

  left join nz88qu8e0mjos_djc2_items as l 
  on l.id = items.id 
  and lower(l.name) like 'l%'

  left join nz88qu8e0mjos_djc2_items as m 
  on m.id = items.id 
  and lower(m.name) like 'm%'

  left join nz88qu8e0mjos_djc2_items as n 
  on n.id = items.id 
  and lower(n.name) like 'n%'

  left join nz88qu8e0mjos_djc2_items as o 
  on o.id = items.id 
  and lower(o.name) like 'o%'

  left join nz88qu8e0mjos_djc2_items as p 
  on p.id = items.id 
  and lower(p.name) like 'p%'

  left join nz88qu8e0mjos_djc2_items as q 
  on q.id = items.id 
  and lower(q.name) like 'q%'

  left join nz88qu8e0mjos_djc2_items as r 
  on r.id = items.id 
  and lower(r.name) like 'r%'

  left join nz88qu8e0mjos_djc2_items as s 
  on s.id = items.id 
  and lower(s.name) like 's%'

  left join nz88qu8e0mjos_djc2_items as t 
  on t.id = items.id 
  and lower(t.name) like 't%'

  left join nz88qu8e0mjos_djc2_items as u 
  on u.id = items.id 
  and lower(u.name) like 'u%'

  left join nz88qu8e0mjos_djc2_items as v 
  on v.id = items.id 
  and lower(v.name) like 'v%'

  left join nz88qu8e0mjos_djc2_items as w 
  on w.id = items.id 
  and lower(w.name) like 'w%'

  left join nz88qu8e0mjos_djc2_items as x 
  on x.id = items.id 
  and lower(x.name) like 'x%'

  left join nz88qu8e0mjos_djc2_items as y 
  on y.id = items.id 
  and lower(y.name) like 'y%'

  left join nz88qu8e0mjos_djc2_items as z 
  on z.id = items.id 
  and lower(z.name) like 'z%' 
  where items.id in (
SELECT i.id

  FROM nz88qu8e0mjos_djc2_items as i

  INNER JOIN (SELECT ic.item_id 
  FROM nz88qu8e0mjos_djc2_items_categories AS ic 
  INNER JOIN nz88qu8e0mjos_djc2_categories AS c 
  ON c.id=ic.category_id 
  WHERE c.published = 1 
  AND ic.category_id IN (1)) as category_filter 
  ON i.id = category_filter.item_id

  LEFT JOIN nz88qu8e0mjos_djc2_categories AS c 
  ON c.id = i.cat_id

  LEFT JOIN nz88qu8e0mjos_djc2_producers AS p 
  ON p.id = i.producer_id

  WHERE i.published = 1

  GROUP BY i.id

  ORDER BY  i.ordering asc, c.ordering asc)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	ic	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	41	Using where; Start temporary
1	PRIMARY	items	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1
1	PRIMARY	i	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	db712232021.i.cat_id	1
1	PRIMARY	p	eq_ref	PRIMARY	PRIMARY	4	db712232021.i.producer_id	1	End temporary
1	PRIMARY	a	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	b	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	d	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	e	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	g	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	h	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	i	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	j	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	k	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	l	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	m	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	n	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	o	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	p	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	q	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	r	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	s	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	t	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	w	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	x	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	y	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where
1	PRIMARY	z	eq_ref	PRIMARY	PRIMARY	4	db712232021.ic.item_id	1	Using where

Profile

Status	Duration
Starting	0.33 ms
checking permissions	0.02 ms
Opening tables	0.86 ms
After opening tables	0.04 ms
System lock	0.05 ms
table lock	0.01 ms
init	0.17 ms
Optimizing	0.12 ms
Statistics	0.55 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.37 ms
Executing	0.01 ms
Sending data	1.63 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.00 ms
Query end	0.01 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/items.php:621
11	DJCatalog2ModelItems->getIndexCount()	JROOT/components/com_djcatalog2/views/items/view.html.php:114
10	DJCatalog2ViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:44
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:55
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 0.80 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 8.979 MB Rows returned: 0

SELECT f.*, group_concat(fo.id 
  order by fo.ordering asc separator '|') as options

  FROM nz88qu8e0mjos_djc2_items_extra_fields as f

  LEFT JOIN nz88qu8e0mjos_djc2_items_extra_fields_options as fo 
  ON fo.field_id=f.id

  WHERE (f.visibility = 2 or f.visibility = 3) 
  and f.published = 1

  GROUP BY f.id

  ORDER BY f.ordering asc, fo.ordering asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort
1	SIMPLE	fo	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.22 ms
Creating sort index	0.06 ms
Removing tmp table	0.01 ms
Creating sort index	0.00 ms
Removing tmp table	0.08 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Removing tmp table	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:435
11	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/views/items/view.html.php:143
10	DJCatalog2ViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:44
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:55
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 0.32 ms After last query: 2.34 ms Query memory: 0.027 MB Memory before query: 9.145 MB Rows returned: 41

select id, producer_id 
  from nz88qu8e0mjos_djc2_items 
  where published=1

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/route.php:62
16	DJCatalogHelperRoute::getItemRoute()	JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php:78
15	include JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_djcatalog2/views/items/tmpl/default.php:106
13	include JROOT/components/com_djcatalog2/views/items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_djcatalog2/views/items/view.html.php:146
10	DJCatalog2ViewItems->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:44
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:55
6	require_once JROOT/components/com_djcatalog2/djcatalog2.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: 0.90 ms After last query: 7.54 ms Query memory: 0.024 MB Memory before query: 9.541 MB Rows returned: 8

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

  FROM nz88qu8e0mjos_modules AS m

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

  LEFT JOIN nz88qu8e0mjos_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 <= '2026-10-10 23:35:52') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-10 23:35:52') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 175 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	5	NULL	12	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db712232021.m.id	1	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	db712232021.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.19 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	Same as call in the line below.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/wrpgreen1/library/Artx/Page.php:42
8	ArtxPage->containsModules()	JROOT/templates/wrpgreen1/index.php:69
7	require JROOT/templates/wrpgreen1/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: 1.26 ms After last query: 2.94 ms Query memory: 0.023 MB Memory before query: 9.716 MB Rows returned: 0

SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params

  FROM `nz88qu8e0mjos_contentitem_tag_map` AS `m`

  INNER JOIN `nz88qu8e0mjos_tags` AS `t` 
  ON `tag_id` = t.id

  INNER JOIN `nz88qu8e0mjos_ucm_content` AS `c` 
  ON `m`.`core_content_id` = `c`.`core_content_id`

  WHERE `t`.`access` IN (1,1,5) 
  AND `t`.`published` = 1  
  AND `m`.`type_alias` = `c`.`core_type_alias` 
  AND `c`.`core_state` = 1 
  AND (`c`.`core_access` IN (1,1,5) OR `c`.`core_access` = 0) 
  AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2026-10-10 23:35:52') 
  AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR  `c`.`core_publish_down` >= '2026-10-10 23:35:52')

  GROUP BY `tag_id`,`title`,`access`,`alias`

  ORDER BY `count` DESC 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	PRIMARY,tag_idx,idx_access,idx_content_type	tag_idx	5	NULL	1	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_core_content_id	4	db712232021.c.core_content_id	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	db712232021.m.tag_id	1	Using where

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.32 ms
Creating sort index	0.06 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
Query end	0.01 ms
closing tables	0.03 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tags_popular/helper.php:134
14	ModTagsPopularHelper::getList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
10	include JROOT/modules/mod_tags_popular/mod_tags_popular.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.]

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

3 × SELECT f.*, group_concat(fo.id 
  order by fo.ordering asc separator '|') as options 
  FROM nz88qu8e0mjos_djc2_items_extra_fields as f 
  LEFT JOIN nz88qu8e0mjos_djc2_items_extra_fields_options as fo 
  ON fo.field_id=f.id

2 × SELECT c.*, img.fullname AS item_image, img.caption AS image_caption, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug  
  FROM nz88qu8e0mjos_djc2_categories AS c 
  LEFT JOIN (select im1.fullname, im1.caption, im1.type, im1.item_id 
  from nz88qu8e0mjos_djc2_images as im1, (select item_id, type, min(ordering) as lowest_order 
  from nz88qu8e0mjos_djc2_images 
  group by item_id, type) as im2

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `nz88qu8e0mjos_extensions`

2 × SELECT DISTINCT p.id, p.name as text,  
  CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as value  
  FROM nz88qu8e0mjos_djc2_producers as p  
  INNER JOIN nz88qu8e0mjos_djc2_items AS i 
  ON p.id = i.producer_id  
  INNER JOIN nz88qu8e0mjos_djc2_categories AS c 
  ON c.id = i.cat_id

2 × SELECT distinct i.*,
  CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(":", i.id, i.alias) ELSE i.id END as slug ,c.id as _category_id, c.name as category, c.published as publish_category,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug ,p.id as _producer_id, p.name as producer, p.published as publish_producer,
  CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as prodslug ,img.fullname as item_image, img.caption AS image_caption,group_concat(distinct ic.category_id 
  order by ic.category_id asc separator '|') AS categorylist 
  FROM nz88qu8e0mjos_djc2_items as i 
  INNER JOIN (SELECT ic.item_id 
  FROM nz88qu8e0mjos_djc2_items_categories AS ic 
  INNER JOIN nz88qu8e0mjos_djc2_categories AS c 
  ON c.id=ic.category_id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM nz88qu8e0mjos_modules AS m 
  LEFT JOIN nz88qu8e0mjos_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN nz88qu8e0mjos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × select id, producer_id 
  from nz88qu8e0mjos_djc2_items

1 × SELECT  count(a.id) as a,  count(b.id) as b,  count(c.id) as c,  count(d.id) as d,  count(e.id) as e,  count(f.id) as f,  count(g.id) as g,  count(h.id) as h,  count(i.id) as i,  count(j.id) as j,  count(k.id) as k,  count(l.id) as l,  count(m.id) as m,  count(n.id) as n,  count(o.id) as o,  count(p.id) as p,  count(q.id) as q,  count(r.id) as r,  count(s.id) as s,  count(t.id) as t,  count(u.id) as u,  count(v.id) as v,  count(w.id) as w,  count(x.id) as x,  count(y.id) as y,  count(z.id) as z  
  FROM nz88qu8e0mjos_djc2_items as items  
  left join nz88qu8e0mjos_djc2_items as a 
  on a.id = items.id 
  and lower(a.name) like 'a%' 
  left join nz88qu8e0mjos_djc2_items as b 
  on b.id = items.id 
  and lower(b.name) like 'b%' 
  left join nz88qu8e0mjos_djc2_items as c 
  on c.id = items.id 
  and lower(c.name) like 'c%' 
  left join nz88qu8e0mjos_djc2_items as d 
  on d.id = items.id 
  and lower(d.name) like 'd%' 
  left join nz88qu8e0mjos_djc2_items as e 
  on e.id = items.id 
  and lower(e.name) like 'e%' 
  left join nz88qu8e0mjos_djc2_items as f 
  on f.id = items.id 
  and lower(f.name) like 'f%' 
  left join nz88qu8e0mjos_djc2_items as g 
  on g.id = items.id 
  and lower(g.name) like 'g%' 
  left join nz88qu8e0mjos_djc2_items as h 
  on h.id = items.id 
  and lower(h.name) like 'h%' 
  left join nz88qu8e0mjos_djc2_items as i 
  on i.id = items.id 
  and lower(i.name) like 'i%' 
  left join nz88qu8e0mjos_djc2_items as j 
  on j.id = items.id 
  and lower(j.name) like 'j%' 
  left join nz88qu8e0mjos_djc2_items as k 
  on k.id = items.id 
  and lower(k.name) like 'k%' 
  left join nz88qu8e0mjos_djc2_items as l 
  on l.id = items.id 
  and lower(l.name) like 'l%' 
  left join nz88qu8e0mjos_djc2_items as m 
  on m.id = items.id 
  and lower(m.name) like 'm%' 
  left join nz88qu8e0mjos_djc2_items as n 
  on n.id = items.id 
  and lower(n.name) like 'n%' 
  left join nz88qu8e0mjos_djc2_items as o 
  on o.id = items.id 
  and lower(o.name) like 'o%' 
  left join nz88qu8e0mjos_djc2_items as p 
  on p.id = items.id 
  and lower(p.name) like 'p%' 
  left join nz88qu8e0mjos_djc2_items as q 
  on q.id = items.id 
  and lower(q.name) like 'q%' 
  left join nz88qu8e0mjos_djc2_items as r 
  on r.id = items.id 
  and lower(r.name) like 'r%' 
  left join nz88qu8e0mjos_djc2_items as s 
  on s.id = items.id 
  and lower(s.name) like 's%' 
  left join nz88qu8e0mjos_djc2_items as t 
  on t.id = items.id 
  and lower(t.name) like 't%' 
  left join nz88qu8e0mjos_djc2_items as u 
  on u.id = items.id 
  and lower(u.name) like 'u%' 
  left join nz88qu8e0mjos_djc2_items as v 
  on v.id = items.id 
  and lower(v.name) like 'v%' 
  left join nz88qu8e0mjos_djc2_items as w 
  on w.id = items.id 
  and lower(w.name) like 'w%' 
  left join nz88qu8e0mjos_djc2_items as x 
  on x.id = items.id 
  and lower(x.name) like 'x%' 
  left join nz88qu8e0mjos_djc2_items as y 
  on y.id = items.id 
  and lower(y.name) like 'y%' 
  left join nz88qu8e0mjos_djc2_items as z 
  on z.id = items.id 
  and lower(z.name) like 'z%'

1 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value 
  FROM nz88qu8e0mjos_djc2_items_extra_fields_values_text as fieldvalues 
  INNER JOIN nz88qu8e0mjos_djc2_items as items 
  on items.id=fieldvalues.item_id 
  INNER JOIN nz88qu8e0mjos_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

1 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value 
  FROM nz88qu8e0mjos_djc2_items_extra_fields_values_int as fieldvalues 
  INNER JOIN nz88qu8e0mjos_djc2_items as items 
  on items.id=fieldvalues.item_id 
  INNER JOIN nz88qu8e0mjos_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id 
  LEFT JOIN nz88qu8e0mjos_djc2_items_extra_fields_options as fieldoptions 
  ON fieldoptions.id = fieldvalues.value 
  AND fieldoptions.field_id = fields.id

1 × SELECT `data` 
  FROM `nz88qu8e0mjos_session`

1 × SELECT `session_id` 
  FROM `nz88qu8e0mjos_session`

1 × SELECT id, home, template, s.params 
  FROM nz88qu8e0mjos_template_styles as s 
  LEFT JOIN nz88qu8e0mjos_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT * 
  FROM nz88qu8e0mjos_languages

1 × 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 nz88qu8e0mjos_menu AS m 
  LEFT JOIN nz88qu8e0mjos_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM nz88qu8e0mjos_extensions

1 × SELECT b.id 
  FROM nz88qu8e0mjos_usergroups AS a 
  LEFT JOIN nz88qu8e0mjos_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `nz88qu8e0mjos_viewlevels

1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params 
  FROM `nz88qu8e0mjos_contentitem_tag_map` AS `m` 
  INNER JOIN `nz88qu8e0mjos_tags` AS `t` 
  ON `tag_id` = t.id 
  INNER JOIN `nz88qu8e0mjos_ucm_content` AS `c` 
  ON `m`.`core_content_id` = `c`.`core_content_id`

OTHER Tables:

1 × INSERT INTO `nz88qu8e0mjos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3039663864313363613339636430393735663166626335343332646132393864', 1, 1791675352, 0, '', 0

1 × UPDATE `nz88qu8e0mjos_extensions` 
  SET `params` = '{\"mediaversion\":\"38d19b3dc46f21b6ea6939e663d8f16f\"}'

Sanctuary

Screaming Vase In The Dark

September Song

Shayman Beat

Silver Serenade

Summer Day

Summer Vision

Sunset Seranade

Timeless Passage

Tranquill Water

Valley Dawn

Main Menu

Login Form

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

27 Queries Logged 28.78 ms

4 duplicate found!

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: