Dobbs Firearm Training

Mens - Choose Wisely

4.3 oz, 100% preshrunk soft jersey cotton
Tear-away, removable labels
Made to fit comfortably all day long

$15.00

ESHOP_PRODUCT_VIEW_DETAILS

Womens - Choose Wisely

4.3 oz., 100% combed ring-spun cotton fine jersey
Heather Colors are 90% ringspun combed cotton fine jersey, 10% polyester
Relaxed fit
Front cover-stitched 1x1 baby rib-knit set-in collar
Tear-away label
Crossover V

$15.00

ESHOP_PRODUCT_VIEW_DETAILS

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1793234892,
                "last": 1793234892,
                "now": 1793234892
            },
            "token": "2vRsvxaJiOSQXBN8f5s8cxpZ2GrysFAP"
        },
        "registry": {
            "limit": "15",
            "sort_options": "a.ordering-ASC",
            "from_view": "category"
        },
        "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
        },
        "continue_shopping_url": "https://dobbsfirearmtraining.com/index.php/shop"
    }
}

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

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

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

EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6f6d327336656d6b6267643230636f71766e366737386a31696b', 1, 1793234892, 0, '', 0)

Profile

Status	Duration
starting	0.04 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.00 ms
init	0.01 ms
update	0.16 ms
Waiting for query cache lock	0.01 ms
update	0.00 ms
end	0.00 ms
query end	0.57 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 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.51 ms After last query: 1.26 ms Query memory: 0.042 MB Memory before query: 1.085 MB Rows returned: 49

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

  FROM `jos_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	jos_extensions	ref	extension	extension	82	const	50	Using index condition; Using where

Profile

Status	Duration
starting	0.03 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.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.26 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 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.19 ms After last query: 1.20 ms Query memory: 0.021 MB Memory before query: 1.130 MB Rows returned: 5

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 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.24 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 1.142 MB Rows returned: 2

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 1.26 ms After last query: 0.24 ms Query memory: 0.035 MB Memory before query: 1.164 MB Rows returned: 139

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

  FROM jos_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	jos_extensions	ref	extension	extension	82	const	242	Using index condition; Using where; Using filesort

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.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.77 ms
Sending data	0.21 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 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: 0.27 ms After last query: 11.46 ms Query memory: 0.024 MB Memory before query: 1.679 MB Rows returned: 1

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

  FROM `jos_extensions`

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

Explain

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

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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/responsivizer/responsivizer.php:141
8	plgSystemResponsivizer->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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.82 ms After last query: 0.13 ms Query memory: 0.006 MB Memory before query: 1.673 MB

UPDATE `jos_extensions`

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

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

Explain

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

Profile

Status	Duration
starting	0.03 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.00 ms
init	0.05 ms
updating	0.08 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.00 ms
query end	0.52 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/responsivizer/responsivizer.php:141
8	plgSystemResponsivizer->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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.75 ms After last query: 2.30 ms Query memory: 0.091 MB Memory before query: 1.783 MB Rows returned: 55

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

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

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

  ORDER BY m.lft

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 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.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.20 ms
Sending data	0.28 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 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.33 ms After last query: 6.54 ms Query memory: 0.021 MB Memory before query: 2.066 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM jos_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	joomla_5.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 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.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
9	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/routerreplacer/routerreplacer.php:95
8	plgSystemRouterReplacer->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.28 ms Query memory: 0.019 MB Memory before query: 2.074 MB Rows returned: 1

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 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.68 ms After last query: 19.50 ms Query memory: 0.041 MB Memory before query: 2.144 MB Rows returned: 265

SELECT config_key, config_value

  FROM jos_eshop_configs

Explain

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

Profile

Status	Duration
starting	0.04 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.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.37 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:48
9	EshopHelper::getConfig()	JROOT/components/com_eshop/helpers/helper.php:160
8	EshopHelper::getConfigValue()	JROOT/administrator/components/com_eshop/libraries/rad/bootstrap.php:8
7	require_once JROOT/administrator/components/com_eshop/libraries/rad/bootstrap.php	JROOT/components/com_eshop/eshop.php:30
6	require_once JROOT/components/com_eshop/eshop.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.71 ms After last query: 13.88 ms Query memory: 0.029 MB Memory before query: 2.367 MB Rows returned: 22

SHOW FULL COLUMNS 
  FROM `jos_eshop_productdetails`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.25 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.05 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:114
14	EshopRADModelList->__construct()	JROOT/components/com_eshop/models/products.php:41
13	EshopModelProducts->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
11	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
10	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
9	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.72 ms After last query: 0.67 ms Query memory: 0.023 MB Memory before query: 2.400 MB Rows returned: 1

SELECT a.*, b.category_name, b.category_alias, b.category_desc, b.category_page_title, b.category_page_heading, b.category_alt_image, b.meta_key, b.meta_desc

  FROM jos_eshop_categories AS a

  INNER JOIN jos_eshop_categorydetails AS b 
  ON a.id = b.category_id

  WHERE a.id = 2 
  AND a.published = 1 
  AND b.language = "en-GB"

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,published	PRIMARY	4	const	1
1	SIMPLE	b	ref	category_id	category_id	5	const	1	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 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.03 ms
optimizing	0.02 ms
statistics	0.39 ms
preparing	0.00 ms
Unlocking tables	0.02 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:289
14	EshopHelper::getCategory()	JROOT/components/com_eshop/models/products.php:50
13	EshopModelProducts->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
11	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
10	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
9	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.17 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 2.410 MB Rows returned: 1

SELECT params

  FROM jos_eshop_categories

  WHERE id = 2

Explain

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

Profile

Status	Duration
starting	0.02 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.02 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:7160
14	EshopHelper::getDefaultSortingCategory()	JROOT/components/com_eshop/models/products.php:98
13	EshopModelProducts->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
11	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
10	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
9	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.30 ms After last query: 0.27 ms Query memory: 0.023 MB Memory before query: 2.434 MB Rows returned: 1

SELECT a.*, b.category_name, b.category_alias, b.category_desc, b.category_page_title, b.category_page_heading, b.category_alt_image, b.meta_key, b.meta_desc

  FROM jos_eshop_categories AS a

  INNER JOIN jos_eshop_categorydetails AS b 
  ON a.id = b.category_id

  WHERE a.id = 2 
  AND a.published = 1 
  AND b.language = "en-GB" 
  AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,published	PRIMARY	4	const	1
1	SIMPLE	b	ref	category_id	category_id	5	const	1	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:289
10	EshopHelper::getCategory()	JROOT/components/com_eshop/views/category/view.html.php:119
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.44 ms After last query: 0.88 ms Query memory: 0.022 MB Memory before query: 2.444 MB Rows returned: 2

SELECT a.id, a.category_parent_id, b.category_name

  FROM jos_eshop_categories AS a

  INNER JOIN jos_eshop_categorydetails AS b 
  ON (a.id = b.category_id)

  WHERE a.published = 1 
  AND b.language = 'en-GB'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	ALL	category_id	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where
1	SIMPLE	a	eq_ref	PRIMARY,published	PRIMARY	4	joomla_5.b.category_id	1	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.22 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:5293
10	EshopHelper::getCategoriesBreadcrumb()	JROOT/components/com_eshop/views/category/view.html.php:147
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.72 ms After last query: 0.08 ms Query memory: 0.005 MB Memory before query: 2.449 MB

UPDATE jos_eshop_categories

  SET hits = hits + 1

  WHERE id = 2

Explain

EXPLAIN not possible on query: UPDATE jos_eshop_categories SET hits = hits + 1 WHERE id = 2

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.02 ms
updating	0.03 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.00 ms
query end	0.53 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/components/com_eshop/helpers/helper.php:633
10	EshopHelper::updateHits()	JROOT/components/com_eshop/views/category/view.html.php:160
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.86 ms After last query: 0.41 ms Query memory: 0.023 MB Memory before query: 2.463 MB Rows returned: 0

Duplicate queries: #30

SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc

  FROM jos_eshop_categories AS a

  INNER JOIN jos_eshop_categorydetails AS b 
  ON (a.id = b.category_id)

  WHERE a.category_parent_id = 2 
  AND a.published = 1 
  AND b.language = 'en-GB' 
  AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))

  ORDER BY b.category_name ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,category_parent_id,published	category_parent_id	5	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	b	ALL	category_id	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 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.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.32 ms
preparing	0.04 ms
executing	0.00 ms
Creating tmp table	0.13 ms
Copying to tmp table	0.05 ms
Sorting result	0.03 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.05 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1035
14	EshopHelper::getCategories()	JROOT/components/com_eshop/helpers/helper.php:1050
13	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/models/category.php:28
12	EShopModelCategory->_buildQueryWhere()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:152
11	EshopRADModelList->getData()	JROOT/components/com_eshop/models/products.php:122
10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:180
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.64 ms After last query: 0.12 ms Query memory: 0.040 MB Memory before query: 2.468 MB Rows returned: 2

SELECT a.*,b.product_name,b.product_alias,b.product_desc,b.product_short_desc,b.product_page_title,b.product_page_heading,b.product_alt_image,b.meta_key,b.meta_desc

  FROM jos_eshop_products AS a

  INNER JOIN jos_eshop_productdetails AS b 
  ON a.id = b.product_id

  WHERE a.published = 1 
  AND b.language='en-GB' 
  AND ((a.product_customergroups = "") OR (a.product_customergroups IS NULL) OR (a.product_customergroups = "1") OR (a.product_customergroups LIKE "1,%") OR (a.product_customergroups LIKE "%,1,%") OR (a.product_customergroups LIKE "%,1")) 
  AND (a.product_available_date = '0000-00-00 00:00:00' OR a.product_available_date IS NULL OR a.product_available_date <= '2026-10-28 17:48:12') 
  AND (a.product_end_date = '0000-00-00 00:00:00' OR a.product_end_date IS NULL OR a.product_end_date >= '2026-10-28 17:48:12') 
  AND ((a.product_languages = "") OR (a.product_languages IS NULL) OR (a.product_languages = "en-GB") OR (a.product_languages LIKE "en-GB,%") OR (a.product_languages LIKE "%,en-GB,%") OR (a.product_languages LIKE "%,en-GB")) 
  AND a.id IN (
SELECT pc.product_id 
  FROM jos_eshop_productcategories AS pc 
  WHERE pc.category_id IN (2))

  ORDER BY a.ordering ASC,a.ordering 
  LIMIT 15

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	PRIMARY,published	published	2	const	2	Using where; Using temporary; Using filesort
1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	4	func	1
1	PRIMARY	b	ALL	product_id	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)
2	MATERIALIZED	pc	ref	product_id,category_id	category_id	5	const	2

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.00 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.61 ms
preparing	0.09 ms
executing	0.01 ms
Creating tmp table	0.19 ms
Copying to tmp table	0.26 ms
Sorting result	0.03 ms
Sending data	0.04 ms
end	0.00 ms
removing tmp table	0.04 ms
end	0.00 ms
removing tmp table	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:157
11	EshopRADModelList->getData()	JROOT/components/com_eshop/models/products.php:122
10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:180
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.29 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 2.482 MB Rows returned: 1

SELECT pi.*

  FROM jos_eshop_productimages AS pi

  WHERE product_id = 1 
  AND published = 1

  ORDER BY pi.ordering

Explain

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

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.11 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1597
11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:173
10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:180
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.60 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 2.489 MB Rows returned: 0

SELECT DISTINCT(label_id)

  FROM jos_eshop_labelelements

  WHERE (element_type = "product" 
  AND element_id = 1) OR (element_type = "manufacturer" 
  AND element_id = (SELECT manufacturer_id 
  FROM jos_eshop_products 
  WHERE id = 1)) OR (element_type = "category" 
  AND element_id IN (SELECT category_id 
  FROM jos_eshop_productcategories 
  WHERE product_id = 1))

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	jos_eshop_labelelements	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary
3	DEPENDENT SUBQUERY	jos_eshop_productcategories	ref	product_id,category_id	product_id	5	const	1	Using where
2	SUBQUERY	jos_eshop_products	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 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.03 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
statistics	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.21 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.01 ms
Copying to tmp table	0.09 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:5510
11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:204
10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:180
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.15 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 2.495 MB Rows returned: 1

SELECT product_quantity

  FROM jos_eshop_products

  WHERE id = 1

Explain

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

Profile

Status	Duration
starting	0.01 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:5518
11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:204
10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:180
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.17 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 2.501 MB Rows returned: 1

Duplicate queries: #48

SELECT product_manage_stock, product_stock_display, product_show_availability, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id

  FROM jos_eshop_products

  WHERE id = 1

Explain

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

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2519
11	EshopHelper::getProductInventory()	JROOT/components/com_eshop/models/products.php:207
10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:180
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.23 ms After last query: 1.48 ms Query memory: 0.022 MB Memory before query: 2.523 MB Rows returned: 1

SELECT pi.*

  FROM jos_eshop_productimages AS pi

  WHERE product_id = 2 
  AND published = 1

  ORDER BY pi.ordering

Explain

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

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.04 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.02 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1597
11	EshopHelper::getProductImages()	JROOT/components/com_eshop/models/products.php:173
10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:180
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.29 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 2.529 MB Rows returned: 0

SELECT DISTINCT(label_id)

  FROM jos_eshop_labelelements

  WHERE (element_type = "product" 
  AND element_id = 2) OR (element_type = "manufacturer" 
  AND element_id = (SELECT manufacturer_id 
  FROM jos_eshop_products 
  WHERE id = 2)) OR (element_type = "category" 
  AND element_id IN (SELECT category_id 
  FROM jos_eshop_productcategories 
  WHERE product_id = 2))

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	jos_eshop_labelelements	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary
3	DEPENDENT SUBQUERY	jos_eshop_productcategories	ref	product_id,category_id	product_id	5	const	1	Using where
2	SUBQUERY	jos_eshop_products	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 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.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
statistics	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
preparing	0.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Creating tmp table	0.01 ms
Copying to tmp table	0.01 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/components/com_eshop/helpers/helper.php:5510
11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:204
10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:180
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.15 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 2.535 MB Rows returned: 1

SELECT product_quantity

  FROM jos_eshop_products

  WHERE id = 2

Explain

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

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:5518
11	EshopHelper::getProductLabels()	JROOT/components/com_eshop/models/products.php:204
10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:180
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.18 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 2.541 MB Rows returned: 1

Duplicate queries: #59

SELECT product_manage_stock, product_stock_display, product_show_availability, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id

  FROM jos_eshop_products

  WHERE id = 2

Explain

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

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2519
11	EshopHelper::getProductInventory()	JROOT/components/com_eshop/models/products.php:207
10	EshopModelProducts->getData()	JROOT/components/com_eshop/views/category/view.html.php:180
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.47 ms After last query: 0.95 ms Query memory: 0.023 MB Memory before query: 2.568 MB Rows returned: 0

Duplicate queries: #20

SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc

  FROM jos_eshop_categories AS a

  INNER JOIN jos_eshop_categorydetails AS b 
  ON (a.id = b.category_id)

  WHERE a.category_parent_id = 2 
  AND a.published = 1 
  AND b.language = 'en-GB' 
  AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))

  ORDER BY b.category_name ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,category_parent_id,published	category_parent_id	5	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	b	ALL	category_id	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 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.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.00 ms
Creating tmp table	0.13 ms
Copying to tmp table	0.02 ms
Sorting result	0.02 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1035
14	EshopHelper::getCategories()	JROOT/components/com_eshop/helpers/helper.php:1050
13	EshopHelper::getAllChildCategories()	JROOT/components/com_eshop/models/category.php:28
12	EShopModelCategory->_buildQueryWhere()	JROOT/components/com_eshop/models/products.php:432
11	EshopModelProducts->getTotal()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:197
10	EshopRADModelList->getPagination()	JROOT/components/com_eshop/views/category/view.html.php:182
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.42 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 2.574 MB Rows returned: 1

SELECT COUNT(*)

  FROM jos_eshop_products AS a

  INNER JOIN jos_eshop_productdetails AS b 
  ON a.id = b.product_id

  WHERE a.published = 1 
  AND b.language='en-GB' 
  AND ((a.product_customergroups = "") OR (a.product_customergroups IS NULL) OR (a.product_customergroups = "1") OR (a.product_customergroups LIKE "1,%") OR (a.product_customergroups LIKE "%,1,%") OR (a.product_customergroups LIKE "%,1")) 
  AND (a.product_available_date = '0000-00-00 00:00:00' OR a.product_available_date IS NULL OR a.product_available_date <= '2026-10-28 17:48:12') 
  AND (a.product_end_date = '0000-00-00 00:00:00' OR a.product_end_date IS NULL OR a.product_end_date >= '2026-10-28 17:48:12') 
  AND ((a.product_languages = "") OR (a.product_languages IS NULL) OR (a.product_languages = "en-GB") OR (a.product_languages LIKE "en-GB,%") OR (a.product_languages LIKE "%,en-GB,%") OR (a.product_languages LIKE "%,en-GB")) 
  AND a.id IN (
SELECT pc.product_id 
  FROM jos_eshop_productcategories AS pc 
  WHERE pc.category_id IN (2))

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	b	ALL	product_id	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where
1	PRIMARY	<subquery2>	ALL	distinct_key	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where
1	PRIMARY	a	eq_ref	PRIMARY,published	PRIMARY	4	joomla_5.b.product_id	1	Using where
2	MATERIALIZED	pc	ref	product_id,category_id	category_id	5	const	2

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 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.03 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.04 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
removing tmp table	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/models/products.php:435
11	EshopModelProducts->getTotal()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:197
10	EshopRADModelList->getPagination()	JROOT/components/com_eshop/views/category/view.html.php:182
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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: 1.18 ms Query memory: 0.026 MB Memory before query: 2.582 MB Rows returned: 11

SHOW FULL COLUMNS 
  FROM `jos_eshop_categorydetails`

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
closing tables	0.00 ms
Opening tables	0.13 ms
After opening tables	0.06 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
closing tables	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:114
12	EshopRADModelList->__construct()	JROOT/components/com_eshop/models/categories.php:33
11	EshopModelCategories->__construct()	JROOT/administrator/components/com_eshop/libraries/rad/model/model.php:95
10	EshopRADModel::getInstance()	JROOT/components/com_eshop/views/category/view.html.php:186
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.61 ms After last query: 0.22 ms Query memory: 0.023 MB Memory before query: 2.612 MB Rows returned: 0

SELECT a.*,category_name,category_alias,category_page_title,category_page_heading,category_alt_image,category_desc,meta_key,meta_desc

  FROM jos_eshop_categories AS a

  INNER JOIN jos_eshop_categorydetails AS b 
  ON a.id = b.category_id

  WHERE a.published = 1 
  AND b.language='en-GB' 
  AND a.category_parent_id=2 
  AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))

  ORDER BY b.category_name ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	PRIMARY,category_parent_id,published	category_parent_id	5	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	b	ALL	category_id	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 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.00 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.01 ms
Creating tmp table	0.16 ms
Copying to tmp table	0.03 ms
Sorting result	0.03 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eshop/libraries/rad/model/list.php:157
11	EshopRADModelList->getData()	JROOT/components/com_eshop/models/categories.php:66
10	EshopModelCategories->getData()	JROOT/components/com_eshop/views/category/view.html.php:190
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.34 ms After last query: 2.52 ms Query memory: 0.022 MB Memory before query: 2.626 MB Rows returned: 3

SELECT *

  FROM jos_eshop_currencies

  WHERE published = 1

Explain

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

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/currency.php:54
10	EshopCurrency->__construct()	JROOT/components/com_eshop/views/category/view.html.php:296
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.24 ms After last query: 0.40 ms Query memory: 0.022 MB Memory before query: 2.635 MB Rows returned: 3

Duplicate queries: #39 #50

SELECT a.id, a.category_parent_id, b.category_alias

  FROM jos_eshop_categories AS a

  INNER JOIN jos_eshop_categorydetails AS b 
  ON (a.id = b.category_id)

  WHERE b.language = 'en-GB'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index	PRIMARY	category_parent_id	5	NULL	3	Using index
1	SIMPLE	b	ALL	category_id	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:5241
11	EshopHelper::getCategoryPath()	JROOT/components/com_eshop/helpers/route.php:81
10	EshopRoute::getCategoryRoute()	JROOT/components/com_eshop/views/category/view.html.php:320
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.29 ms Query memory: 0.022 MB Memory before query: 2.644 MB Rows returned: 0

SELECT a.id, b.attributegroup_name

  FROM jos_eshop_attributegroups AS a

  INNER JOIN jos_eshop_attributegroupdetails AS b 
  ON (a.id = b.attributegroup_id)

  WHERE a.published = 1 
  AND b.language = 'en-GB'

  ORDER BY a.ordering

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.01 ms
Copying to tmp table	0.11 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.00 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:865
10	EshopHelper::getAttributeGroups()	JROOT/components/com_eshop/views/category/view.html.php:323
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.39 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 2.651 MB Rows returned: 1

SELECT a.id, b.category_id, b.category_name, b.category_page_title

  FROM jos_eshop_categories AS a

  INNER JOIN jos_eshop_categorydetails AS b 
  ON (a.id = b.category_id)

  WHERE a.published = 1 
  AND a.category_parent_id = (SELECT category_parent_id 
  FROM jos_eshop_categories 
  WHERE id = 2) 
  AND b.language = 'en-GB' 
  AND ((a.category_customergroups = "") OR (a.category_customergroups IS NULL) OR (a.category_customergroups = "1") OR (a.category_customergroups LIKE "1,%") OR (a.category_customergroups LIKE "%,1,%") OR (a.category_customergroups LIKE "%,1"))

  ORDER BY a.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	index_merge	PRIMARY,category_parent_id,published	published,category_parent_id	2,5	NULL	1	Using intersect(published,category_parent_id); Using where; Using temporary; Using filesort
1	PRIMARY	b	ALL	category_id	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)
2	SUBQUERY	jos_eshop_categories	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.98 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.03 ms
optimizing	0.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
statistics	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.01 ms
Copying to tmp table	0.06 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:5059
10	EshopHelper::getCategoriesNavigation()	JROOT/components/com_eshop/views/category/view.html.php:340
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.20 ms After last query: 6.04 ms Query memory: 0.025 MB Memory before query: 2.696 MB Rows returned: 1

SELECT COUNT(*)

  FROM jos_eshop_productcategories

  WHERE product_id = 1 
  AND category_id = 2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_eshop_productcategories	ref	product_id,category_id	product_id	5	const	1	Using where

Profile

Status	Duration
starting	0.03 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:6681
15	EshopHelper::isProductCategory()	JROOT/components/com_eshop/themes/default/views/common/products.php:97
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.23 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 2.707 MB Rows returned: 3

Duplicate queries: #35 #50

SELECT a.id, a.category_parent_id, b.category_alias

  FROM jos_eshop_categories AS a

  INNER JOIN jos_eshop_categorydetails AS b 
  ON (a.id = b.category_id)

  WHERE b.language = 'en-GB'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index	PRIMARY	category_parent_id	5	NULL	3	Using index
1	SIMPLE	b	ALL	category_id	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:5241
16	EshopHelper::getCategoryPath()	JROOT/components/com_eshop/helpers/route.php:44
15	EshopRoute::getProductRoute()	JROOT/components/com_eshop/themes/default/views/common/products.php:97
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.43 ms After last query: 0.16 ms Query memory: 0.027 MB Memory before query: 2.717 MB Rows returned: 1

SELECT product_name, product_alias

  FROM jos_eshop_productdetails

  WHERE product_id = 1 
  AND language = 'en-GB'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_eshop_productdetails	ref	product_id	product_id	5	const	1	Using where

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.24 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:5007
22	EshopHelper::getElementAlias()	JROOT/components/com_eshop/router.php:148
21	EshopRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eshop/themes/default/views/common/products.php:97
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.26 ms After last query: 1.29 ms Query memory: 0.027 MB Memory before query: 2.791 MB Rows returned: 1

SELECT id

  FROM jos_eshop_urls

  WHERE md5_key="7386fb74fee32ea364a0d956b96a9d68"

Explain

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

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/router.php:335
21	EshopRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eshop/themes/default/views/common/products.php:97
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.95 ms After last query: 0.07 ms Query memory: 0.011 MB Memory before query: 2.802 MB

UPDATE jos_eshop_urls

  SET query="view=product&id=1&catid=2"

  WHERE md5_key="7386fb74fee32ea364a0d956b96a9d68"

Explain

EXPLAIN not possible on query: UPDATE jos_eshop_urls SET query="view=product&id=1&catid=2" WHERE md5_key="7386fb74fee32ea364a0d956b96a9d68"

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.01 ms
updating	0.05 ms
end	0.01 ms
query end	0.77 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/components/com_eshop/router.php:353
21	EshopRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eshop/themes/default/views/common/products.php:97
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.33 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 2.812 MB Rows returned: 0

SELECT price

  FROM jos_eshop_productspecials

  WHERE product_id = 1 
  AND published = 1 
  AND customergroup_id = 1 
  AND (date_start = '0000-00-00 00:00:00' OR date_start IS NULL OR date_start <= '2026-10-28 17:48:12') 
  AND (date_end = '0000-00-00 00:00:00' OR date_end IS NULL OR date_end >= '2026-10-28 17:48:12')

  ORDER BY priority 
  LIMIT 1

Explain

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

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.00 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sorting result	0.10 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:1990
16	EshopHelper::getSpecialPrice()	JROOT/components/com_eshop/helpers/helper.php:2181
15	EshopHelper::getProductPriceArray()	JROOT/components/com_eshop/themes/default/views/common/products.php:209
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.59 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 2.824 MB Rows returned: 0

SELECT a.*

  FROM jos_eshop_discounts AS a

  INNER JOIN jos_eshop_discountelements AS b 
  ON (a.id = b.discount_id)

  WHERE a.published = 1 
  AND b.element_type = "product" 
  AND (b.element_id = 1 OR b.element_id = 0) 
  AND ((a.discount_customergroups = "") OR (a.discount_customergroups IS NULL) OR (a.discount_customergroups = "1") OR (a.discount_customergroups LIKE "1,%") OR (a.discount_customergroups LIKE "%,1,%") OR (a.discount_customergroups LIKE "%,1")) 
  AND (a.discount_start_date = '0000-00-00 00:00:00' OR a.discount_start_date IS NULL OR a.discount_start_date <= '2026-10-28 17:48:12') 
  AND (a.discount_end_date = '0000-00-00 00:00:00' OR a.discount_end_date IS NULL OR a.discount_end_date >= '2026-10-28 17:48:12')

  ORDER BY a.id DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort
1	SIMPLE	b	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
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.00 ms
Creating tmp table	0.15 ms
Copying to tmp table	0.10 ms
Sorting result	0.02 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2024
16	EshopHelper::getSpecialPrice()	JROOT/components/com_eshop/helpers/helper.php:2181
15	EshopHelper::getProductPriceArray()	JROOT/components/com_eshop/themes/default/views/common/products.php:209
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.64 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 2.834 MB Rows returned: 0

SELECT a.*

  FROM jos_eshop_discounts AS a

  INNER JOIN jos_eshop_discountelements AS b 
  ON (a.id = b.discount_id)

  WHERE a.published = 1 
  AND ((b.element_type = "manufacturer" 
  AND (b.element_id = (SELECT manufacturer_id 
  FROM jos_eshop_products 
  WHERE id = 1) OR b.element_id = 0)) OR (b.element_type = "category" 
  AND (b.element_id IN (SELECT category_id 
  FROM jos_eshop_productcategories 
  WHERE product_id = 1)  OR b.element_id = 0))) 
  AND ((a.discount_customergroups = "") OR (a.discount_customergroups IS NULL) OR (a.discount_customergroups = "1") OR (a.discount_customergroups LIKE "1,%") OR (a.discount_customergroups LIKE "%,1,%") OR (a.discount_customergroups LIKE "%,1")) 
  AND (a.discount_start_date = '0000-00-00 00:00:00' OR a.discount_start_date IS NULL OR a.discount_start_date <= '2026-10-28 17:48:12') 
  AND (a.discount_end_date = '0000-00-00 00:00:00' OR a.discount_end_date IS NULL OR a.discount_end_date >= '2026-10-28 17:48:12')

  ORDER BY a.id DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort
1	PRIMARY	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
3	DEPENDENT SUBQUERY	jos_eshop_productcategories	ref	product_id,category_id	product_id	5	const	1	Using where
2	SUBQUERY	jos_eshop_products	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 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.06 ms
optimizing	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
statistics	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
preparing	0.03 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.13 ms
Copying to tmp table	0.03 ms
Sorting result	0.02 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2040
16	EshopHelper::getSpecialPrice()	JROOT/components/com_eshop/helpers/helper.php:2181
15	EshopHelper::getProductPriceArray()	JROOT/components/com_eshop/themes/default/views/common/products.php:209
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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: 0.12 ms Query memory: 0.025 MB Memory before query: 2.842 MB Rows returned: 0

SELECT price

  FROM jos_eshop_productdiscounts

  WHERE product_id = 1 
  AND published = 1 
  AND customergroup_id = 1 
  AND (date_start = '0000-00-00 00:00:00' OR date_start IS NULL OR date_start <= '2026-10-28 17:48:12') 
  AND (date_end = '0000-00-00 00:00:00' OR date_end IS NULL OR date_end >= '2026-10-28 17:48:12') 
  AND quantity = 1

  ORDER BY priority

Explain

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

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.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.10 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:1879
16	EshopHelper::getDiscountPrice()	JROOT/components/com_eshop/helpers/helper.php:2182
15	EshopHelper::getProductPriceArray()	JROOT/components/com_eshop/themes/default/views/common/products.php:209
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.95 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 2.853 MB Rows returned: 1

SELECT o.id, o.option_type, o.option_image, od.option_name, od.option_desc, po.required, po.id AS product_option_id

  FROM jos_eshop_options AS o

  INNER JOIN jos_eshop_optiondetails AS od 
  ON (o.id = od.option_id)

  INNER JOIN jos_eshop_productoptions AS po 
  ON (o.id = po.option_id)

  WHERE po.product_id = 1 
  AND od.language = 'en-GB' 
  AND o.published = 1

  ORDER BY od.option_name ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	o	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort
1	SIMPLE	od	ALL	option_id	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	po	ref	product_id,option_id	product_id	5	const	1	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 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.28 ms
preparing	0.03 ms
executing	0.00 ms
Creating tmp table	0.10 ms
Copying to tmp table	0.27 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.00 ms
removing tmp table	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1547
16	EshopHelper::getProductOptions()	JROOT/components/com_eshop/helpers/helper.php:6736
15	EshopHelper::isRequiredOptionProduct()	JROOT/components/com_eshop/themes/default/views/common/products.php:271
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.21 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 2.861 MB Rows returned: 1

Duplicate queries: #25

SELECT product_manage_stock, product_stock_display, product_show_availability, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id

  FROM jos_eshop_products

  WHERE id = 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.03 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2519
15	EshopHelper::getProductInventory()	JROOT/components/com_eshop/themes/default/views/common/products.php:325
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.20 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 2.870 MB Rows returned: 1

SELECT COUNT(*)

  FROM jos_eshop_productcategories

  WHERE product_id = 2 
  AND category_id = 2

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_eshop_productcategories	ref	product_id,category_id	product_id	5	const	1	Using where

Profile

Status	Duration
starting	0.02 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.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:6681
15	EshopHelper::isProductCategory()	JROOT/components/com_eshop/themes/default/views/common/products.php:97
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.21 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 2.881 MB Rows returned: 3

Duplicate queries: #35 #39

SELECT a.id, a.category_parent_id, b.category_alias

  FROM jos_eshop_categories AS a

  INNER JOIN jos_eshop_categorydetails AS b 
  ON (a.id = b.category_id)

  WHERE b.language = 'en-GB'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index	PRIMARY	category_parent_id	5	NULL	3	Using index
1	SIMPLE	b	ALL	category_id	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:5241
16	EshopHelper::getCategoryPath()	JROOT/components/com_eshop/helpers/route.php:44
15	EshopRoute::getProductRoute()	JROOT/components/com_eshop/themes/default/views/common/products.php:97
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.19 ms After last query: 0.16 ms Query memory: 0.027 MB Memory before query: 2.890 MB Rows returned: 1

SELECT product_name, product_alias

  FROM jos_eshop_productdetails

  WHERE product_id = 2 
  AND language = 'en-GB'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_eshop_productdetails	ref	product_id	product_id	5	const	1	Using where

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:5007
22	EshopHelper::getElementAlias()	JROOT/components/com_eshop/router.php:148
21	EshopRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eshop/themes/default/views/common/products.php:97
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.16 ms After last query: 0.10 ms Query memory: 0.027 MB Memory before query: 2.902 MB Rows returned: 1

SELECT id

  FROM jos_eshop_urls

  WHERE md5_key="e25cbe7cef6c2e7cfa09cf9add3e6ede"

Explain

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

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/router.php:335
21	EshopRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eshop/themes/default/views/common/products.php:97
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.60 ms After last query: 0.06 ms Query memory: 0.011 MB Memory before query: 2.913 MB

UPDATE jos_eshop_urls

  SET query="view=product&id=2&catid=2"

  WHERE md5_key="e25cbe7cef6c2e7cfa09cf9add3e6ede"

Explain

EXPLAIN not possible on query: UPDATE jos_eshop_urls SET query="view=product&id=2&catid=2" WHERE md5_key="e25cbe7cef6c2e7cfa09cf9add3e6ede"

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.01 ms
updating	0.03 ms
end	0.00 ms
query end	0.43 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/components/com_eshop/router.php:353
21	EshopRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eshop/themes/default/views/common/products.php:97
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.26 ms After last query: 0.24 ms Query memory: 0.025 MB Memory before query: 2.923 MB Rows returned: 0

SELECT price

  FROM jos_eshop_productspecials

  WHERE product_id = 2 
  AND published = 1 
  AND customergroup_id = 1 
  AND (date_start = '0000-00-00 00:00:00' OR date_start IS NULL OR date_start <= '2026-10-28 17:48:12') 
  AND (date_end = '0000-00-00 00:00:00' OR date_end IS NULL OR date_end >= '2026-10-28 17:48:12')

  ORDER BY priority 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_eshop_productspecials	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.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.02 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:1990
16	EshopHelper::getSpecialPrice()	JROOT/components/com_eshop/helpers/helper.php:2181
15	EshopHelper::getProductPriceArray()	JROOT/components/com_eshop/themes/default/views/common/products.php:209
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.50 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 2.934 MB Rows returned: 0

SELECT a.*

  FROM jos_eshop_discounts AS a

  INNER JOIN jos_eshop_discountelements AS b 
  ON (a.id = b.discount_id)

  WHERE a.published = 1 
  AND b.element_type = "product" 
  AND (b.element_id = 2 OR b.element_id = 0) 
  AND ((a.discount_customergroups = "") OR (a.discount_customergroups IS NULL) OR (a.discount_customergroups = "1") OR (a.discount_customergroups LIKE "1,%") OR (a.discount_customergroups LIKE "%,1,%") OR (a.discount_customergroups LIKE "%,1")) 
  AND (a.discount_start_date = '0000-00-00 00:00:00' OR a.discount_start_date IS NULL OR a.discount_start_date <= '2026-10-28 17:48:12') 
  AND (a.discount_end_date = '0000-00-00 00:00:00' OR a.discount_end_date IS NULL OR a.discount_end_date >= '2026-10-28 17:48:12')

  ORDER BY a.id DESC 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 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.00 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.00 ms
Creating tmp table	0.15 ms
Copying to tmp table	0.02 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2024
16	EshopHelper::getSpecialPrice()	JROOT/components/com_eshop/helpers/helper.php:2181
15	EshopHelper::getProductPriceArray()	JROOT/components/com_eshop/themes/default/views/common/products.php:209
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.64 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 2.945 MB Rows returned: 0

SELECT a.*

  FROM jos_eshop_discounts AS a

  INNER JOIN jos_eshop_discountelements AS b 
  ON (a.id = b.discount_id)

  WHERE a.published = 1 
  AND ((b.element_type = "manufacturer" 
  AND (b.element_id = (SELECT manufacturer_id 
  FROM jos_eshop_products 
  WHERE id = 2) OR b.element_id = 0)) OR (b.element_type = "category" 
  AND (b.element_id IN (SELECT category_id 
  FROM jos_eshop_productcategories 
  WHERE product_id = 2)  OR b.element_id = 0))) 
  AND ((a.discount_customergroups = "") OR (a.discount_customergroups IS NULL) OR (a.discount_customergroups = "1") OR (a.discount_customergroups LIKE "1,%") OR (a.discount_customergroups LIKE "%,1,%") OR (a.discount_customergroups LIKE "%,1")) 
  AND (a.discount_start_date = '0000-00-00 00:00:00' OR a.discount_start_date IS NULL OR a.discount_start_date <= '2026-10-28 17:48:12') 
  AND (a.discount_end_date = '0000-00-00 00:00:00' OR a.discount_end_date IS NULL OR a.discount_end_date >= '2026-10-28 17:48:12')

  ORDER BY a.id DESC 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort
1	PRIMARY	b	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
3	DEPENDENT SUBQUERY	jos_eshop_productcategories	ref	product_id,category_id	product_id	5	const	1	Using where
2	SUBQUERY	jos_eshop_products	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
init	0.04 ms
optimizing	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
statistics	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
preparing	0.03 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.12 ms
Copying to tmp table	0.02 ms
Sorting result	0.01 ms
Sending data	0.04 ms
end	0.01 ms
removing tmp table	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2040
16	EshopHelper::getSpecialPrice()	JROOT/components/com_eshop/helpers/helper.php:2181
15	EshopHelper::getProductPriceArray()	JROOT/components/com_eshop/themes/default/views/common/products.php:209
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.19 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 2.953 MB Rows returned: 0

SELECT price

  FROM jos_eshop_productdiscounts

  WHERE product_id = 2 
  AND published = 1 
  AND customergroup_id = 1 
  AND (date_start = '0000-00-00 00:00:00' OR date_start IS NULL OR date_start <= '2026-10-28 17:48:12') 
  AND (date_end = '0000-00-00 00:00:00' OR date_end IS NULL OR date_end >= '2026-10-28 17:48:12') 
  AND quantity = 1

  ORDER BY priority

Explain

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

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.01 ms
Table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/components/com_eshop/helpers/helper.php:1879
16	EshopHelper::getDiscountPrice()	JROOT/components/com_eshop/helpers/helper.php:2182
15	EshopHelper::getProductPriceArray()	JROOT/components/com_eshop/themes/default/views/common/products.php:209
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.44 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 2.964 MB Rows returned: 1

SELECT o.id, o.option_type, o.option_image, od.option_name, od.option_desc, po.required, po.id AS product_option_id

  FROM jos_eshop_options AS o

  INNER JOIN jos_eshop_optiondetails AS od 
  ON (o.id = od.option_id)

  INNER JOIN jos_eshop_productoptions AS po 
  ON (o.id = po.option_id)

  WHERE po.product_id = 2 
  AND od.language = 'en-GB' 
  AND o.published = 1

  ORDER BY od.option_name ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	o	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using temporary; Using filesort
1	SIMPLE	od	ALL	option_id	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	po	ref	product_id,option_id	product_id	5	const	1	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 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.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Creating tmp table	0.11 ms
Copying to tmp table	0.05 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.01 ms
removing tmp table	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_eshop/helpers/helper.php:1547
16	EshopHelper::getProductOptions()	JROOT/components/com_eshop/helpers/helper.php:6736
15	EshopHelper::isRequiredOptionProduct()	JROOT/components/com_eshop/themes/default/views/common/products.php:271
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.18 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 2.971 MB Rows returned: 1

Duplicate queries: #29

SELECT product_manage_stock, product_stock_display, product_show_availability, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id

  FROM jos_eshop_products

  WHERE id = 2

Explain

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

Profile

Status	Duration
starting	0.02 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.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
Unlocking tables	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_eshop/helpers/helper.php:2519
15	EshopHelper::getProductInventory()	JROOT/components/com_eshop/themes/default/views/common/products.php:325
14	include JROOT/components/com_eshop/themes/default/views/common/products.php	JROOT/components/com_eshop/helpers/html.php:196
13	EshopHtmlHelper::loadCommonLayout()	JROOT/components/com_eshop/themes/default/views/category/default.php:66
12	include JROOT/components/com_eshop/themes/default/views/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_eshop/libraries/mvc/view.php:91
10	EShopView->display()	JROOT/components/com_eshop/views/category/view.html.php:345
9	EShopViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eshop/eshop.php:112
6	require_once JROOT/components/com_eshop/eshop.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.71 ms After last query: 5.22 ms Query memory: 0.023 MB Memory before query: 3.050 MB Rows returned: 6

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

  FROM jos_modules AS m

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

  LEFT JOIN jos_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-29 00:48:12') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-29 00:48:12') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 220 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	11	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	joomla_5.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	joomla_5.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.05 ms
executing	0.00 ms
Sorting result	0.12 ms
Sending data	0.15 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	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:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/protostar/index.php:91
7	require JROOT/templates/protostar/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.]

40 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × SELECT product_manage_stock, product_stock_display, product_show_availability, product_stock_warning, product_inventory_global, product_quantity, product_threshold, product_stock_checkout, product_stock_status_id 
  FROM jos_eshop_products

4 × SELECT a.* 
  FROM jos_eshop_discounts AS a 
  INNER JOIN jos_eshop_discountelements AS b 
  ON (a.id = b.discount_id)

3 × SELECT a.id, a.category_parent_id, b.category_alias 
  FROM jos_eshop_categories AS a 
  INNER JOIN jos_eshop_categorydetails AS b 
  ON (a.id = b.category_id)

2 × SELECT a.*, b.category_name, b.category_alias, b.category_desc, b.category_page_title, b.category_page_heading, b.category_alt_image, b.meta_key, b.meta_desc 
  FROM jos_eshop_categories AS a 
  INNER JOIN jos_eshop_categorydetails AS b 
  ON a.id = b.category_id

2 × SELECT product_quantity 
  FROM jos_eshop_products

2 × SELECT pi.* 
  FROM jos_eshop_productimages AS pi

2 × SELECT a.id, a.category_parent_id, a.category_image, b.category_name, b.category_desc 
  FROM jos_eshop_categories AS a 
  INNER JOIN jos_eshop_categorydetails AS b 
  ON (a.id = b.category_id)

2 × SELECT DISTINCT(label_id) 
  FROM jos_eshop_labelelements

2 × SELECT product_name, product_alias 
  FROM jos_eshop_productdetails

```
2 × SELECT id 
  FROM jos_eshop_urls
```

2 × SELECT price 
  FROM jos_eshop_productspecials

2 × SELECT price 
  FROM jos_eshop_productdiscounts

2 × SELECT o.id, o.option_type, o.option_image, od.option_name, od.option_desc, po.required, po.id AS product_option_id 
  FROM jos_eshop_options AS o 
  INNER JOIN jos_eshop_optiondetails AS od 
  ON (o.id = od.option_id) 
  INNER JOIN jos_eshop_productoptions AS po 
  ON (o.id = po.option_id)

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

2 × SELECT COUNT(*) 
  FROM jos_eshop_productcategories

1 × SELECT a.*,category_name,category_alias,category_page_title,category_page_heading,category_alt_image,category_desc,meta_key,meta_desc 
  FROM jos_eshop_categories AS a 
  INNER JOIN jos_eshop_categorydetails AS b 
  ON a.id = b.category_id

1 × SELECT a.id, b.category_id, b.category_name, b.category_page_title 
  FROM jos_eshop_categories AS a 
  INNER JOIN jos_eshop_categorydetails AS b 
  ON (a.id = b.category_id)

1 × SELECT a.id, b.attributegroup_name 
  FROM jos_eshop_attributegroups AS a 
  INNER JOIN jos_eshop_attributegroupdetails AS b 
  ON (a.id = b.attributegroup_id)

1 × SELECT * 
  FROM jos_eshop_currencies

1 × SELECT `data` 
  FROM `jos_session`

1 × SELECT COUNT(*) 
  FROM jos_eshop_products AS a 
  INNER JOIN jos_eshop_productdetails AS b 
  ON a.id = b.product_id

1 × SELECT `session_id` 
  FROM `jos_session`

1 × SELECT a.*,b.product_name,b.product_alias,b.product_desc,b.product_short_desc,b.product_page_title,b.product_page_heading,b.product_alt_image,b.meta_key,b.meta_desc 
  FROM jos_eshop_products AS a 
  INNER JOIN jos_eshop_productdetails AS b 
  ON a.id = b.product_id

1 × SELECT a.id, a.category_parent_id, b.category_name 
  FROM jos_eshop_categories AS a 
  INNER JOIN jos_eshop_categorydetails AS b 
  ON (a.id = b.category_id)

1 × SELECT params 
  FROM jos_eshop_categories

1 × SELECT config_key, config_value 
  FROM jos_eshop_config

```
1 × SELECT * 
  FROM jos_languages
```

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

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 jos_menu AS m 
  LEFT JOIN jos_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 jos_extensions

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

1 × SELECT id, rules 
  FROM `jos_viewlevels

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

OTHER Tables:

1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6f6d327336656d6b6267643230636f71766e366737386a31696b', 1, 1793234892, 0, '', 0

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"cdc9de1d3859728271fe7120315c9d3b\"}'

1 × SHOW FULL COLUMNS 
  FROM `jos_eshop_productdetails

1 × UPDATE jos_eshop_categories 
  SET hits = hits + 1

1 × SHOW FULL COLUMNS 
  FROM `jos_eshop_categorydetails

1 × UPDATE jos_eshop_urls 
  SET query="view=product&id=1&catid=2"

1 × UPDATE jos_eshop_urls 
  SET query="view=product&id=2&catid=2"

T-Shirts

Mens - Choose Wisely

Womens - Choose Wisely

Login

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

60 Queries Logged 28.20 ms

9 duplicate found!

40 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: