Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1715948350,
                "last": 1715948350,
                "now": 1715948350
            }
        },
        "registry": {
            "com_icecool_engagement_rings": {
                "edit": {
                    "engagementringdetails": {
                        "id": "45round"
                    }
                }
            },
            "com_icecool_designer_diamonds": {
                "edit": {
                    "designerdiamondsproduct": {
                        "id": "131"
                    }
                }
            }
        },
        "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
        },
        "engagementRingDetails": "Round Four Claw Platinum Engagement Ring ICD185PLT",
        "designerDiamondDetails": "\u00a3635.00 - BJP0087RG"
    }
}

Profile Information

Time

Memory

Time: 1.33 ms / 1.33 ms Memory: 0.039 MB / 0.42 MB Application: afterLoad

Time: 30.55 ms / 31.88 ms Memory: 0.691 MB / 1.11 MB Application: afterInitialise

Time: 7.85 ms / 39.73 ms Memory: 0.466 MB / 1.58 MB Application: afterRoute

Time: 10.66 ms / 50.39 ms Memory: 0.101 MB / 1.68 MB Application: beforeRenderComponent com_icecool_designer_diamonds

Time: 13.51 ms / 63.91 ms Memory: 0.150 MB / 1.83 MB Application: Start JAccess::getAssetRules Old (1)

Time: 1.40 ms / 65.31 ms Memory: 0.015 MB / 1.84 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.04 ms / 65.35 ms Memory: 0.000 MB / 1.84 MB Application: New JAccess Preloading Process(com_icecool_designer_diamonds.designerdiamondsproduct)

Time: 1.75 ms / 67.10 ms Memory: 0.014 MB / 1.85 MB Application: After preloadPermissionsParentIdMapping (com_icecool_designer_diamonds.designerdiamondsproduct)

Time: 2.42 ms / 69.52 ms Memory: 0.078 MB / 1.93 MB Application: After preloadPermissions (com_icecool_designer_diamonds.designerdiamondsproduct)

Time: 0.02 ms / 69.53 ms Memory: 0.002 MB / 1.93 MB Application: End New JAccess Preloading Process(com_icecool_designer_diamonds.designerdiamondsproduct)

Time: 0.02 ms / 69.55 ms Memory: 0.001 MB / 1.93 MB Application: Start JAccess::getAssetRules Old (com_icecool_designer_diamonds.designerdiamondsproduct.131)

Time: 1.01 ms / 70.57 ms Memory: 0.017 MB / 1.95 MB Application: Finish JAccess::getAssetRules Old (com_icecool_designer_diamonds.designerdiamondsproduct.131)

Time: 0.21 ms / 70.78 ms Memory: 0.001 MB / 1.95 MB Application: Start JAccess::getAssetRules Old (com_icecool_designer_diamonds.designerdiamondsproduct.131)

Time: 1.39 ms / 72.17 ms Memory: 0.009 MB / 1.96 MB Application: Finish JAccess::getAssetRules Old (com_icecool_designer_diamonds.designerdiamondsproduct.131)

Time: 5.21 ms / 77.38 ms Memory: 0.022 MB / 1.98 MB Application: afterRenderComponent com_icecool_designer_diamonds

Time: 0.96 ms / 78.34 ms Memory: 0.011 MB / 1.99 MB Application: afterDispatch

Time: 4.41 ms / 82.75 ms Memory: 0.075 MB / 2.07 MB Application: beforeRenderModule mod_custom (Footer Copy)

Time: 0.32 ms / 83.07 ms Memory: 0.007 MB / 2.07 MB Application: afterRenderModule mod_custom (Footer Copy)

Time: 0.09 ms / 83.16 ms Memory: 0.001 MB / 2.07 MB Application: beforeRenderModule mod_menu (Footer Menu Right)

Time: 1.39 ms / 84.55 ms Memory: 0.035 MB / 2.11 MB Application: afterRenderModule mod_menu (Footer Menu Right)

Time: 0.07 ms / 84.62 ms Memory: 0.000 MB / 2.11 MB Application: beforeRenderModule mod_menu (Footer Menu Middle)

Time: 0.63 ms / 85.25 ms Memory: 0.010 MB / 2.12 MB Application: afterRenderModule mod_menu (Footer Menu Middle)

Time: 0.06 ms / 85.31 ms Memory: 0.000 MB / 2.11 MB Application: beforeRenderModule mod_menu (Footer Menu Left)

Time: 1.00 ms / 86.31 ms Memory: 0.018 MB / 2.13 MB Application: afterRenderModule mod_menu (Footer Menu Left)

Time: 0.07 ms / 86.38 ms Memory: 0.000 MB / 2.13 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 2.57 ms / 88.95 ms Memory: 0.053 MB / 2.18 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 1.29 ms / 90.24 ms Memory: 0.058 MB / 2.24 MB Application: afterRender

Database queries total: 43.13 ms

Memory Usage

Database Queries

23 Queries Logged 43.13 ms

Query Time: 1.45 ms Query memory: 0.022 MB Memory before query: 0.699 MB Rows returned: 1

SELECT `data`

  FROM `icecool_session`

  WHERE `session_id` = '1cf118a32e19451bc9d9a8769591a0b2'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_session	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.03 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 1.36 ms After last query: 0.68 ms Query memory: 0.024 MB Memory before query: 0.738 MB Rows returned: 45

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

  FROM `icecool_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_extensions	ref	extension	extension	82	const	45	100.00	Using index condition

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.00 ms After last query: 0.59 ms Query memory: 0.021 MB Memory before query: 0.763 MB Rows returned: 2

SELECT b.id

  FROM icecool_usergroups AS a

  LEFT JOIN icecool_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	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.14 ms Query memory: 0.021 MB Memory before query: 0.768 MB Rows returned: 4

SELECT id, rules

  FROM `icecool_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.72 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 0.776 MB Rows returned: 66

SELECT folder AS type, element AS name, params

  FROM icecool_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	filtered	Extra
1	SIMPLE	icecool_extensions	ref	extension	extension	82	const	82	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.73 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.68 ms After last query: 2.72 ms Query memory: 0.020 MB Memory before query: 1.060 MB Rows returned: 1

SELECT `enabled`

  FROM `icecool_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:80
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 4.02 ms After last query: 1.52 ms Query memory: 0.090 MB Memory before query: 1.123 MB Rows returned: 59

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

  LEFT JOIN icecool_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	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	68	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	coltscou_clients.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.41 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.08 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 3.74 ms Query memory: 0.022 MB Memory before query: 1.655 MB Rows returned: 1

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

  FROM `icecool_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.05 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.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 5.06 ms After last query: 0.18 ms Query memory: 0.005 MB Memory before query: 1.647 MB

UPDATE `icecool_extensions`

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icecool_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.40 ms After last query: 0.48 ms Query memory: 0.019 MB Memory before query: 1.663 MB Rows returned: 1

SELECT *

  FROM icecool_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.97 ms After last query: 0.32 ms Query memory: 0.019 MB Memory before query: 1.672 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM icecool_template_styles as s

  LEFT JOIN icecool_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	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	7	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	coltscou_clients.s.template,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.28 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.09 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.52 ms After last query: 4.19 ms Query memory: 0.027 MB Memory before query: 1.737 MB Rows returned: 17

SHOW FULL COLUMNS 
  FROM `icecool_icecool_designer_diamonds_products`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/administrator/components/com_icecool_designer_diamonds/tables/designerdiamondsproduct.php:24
14	Icecool_designer_diamondsTabledesignerdiamondsproduct->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/components/com_icecool_designer_diamonds/models/designerdiamondsproduct.php:100
12	Icecool_designer_diamondsModelDesignerdiamondsproduct->getTable()	JROOT/components/com_icecool_designer_diamonds/models/designerdiamondsproduct.php:73
11	Icecool_designer_diamondsModelDesignerdiamondsproduct->getData()	JROOT/libraries/legacy/view/legacy.php:408
10	JViewLegacy->get()	JROOT/components/com_icecool_designer_diamonds/views/designerdiamondsproduct/view.html.php:34
9	Icecool_designer_diamondsViewDesignerdiamondsproduct->display()	JROOT/libraries/legacy/controller/legacy.php:664
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php:17
6	require_once JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM icecool_icecool_designer_diamonds_products

  WHERE `id` = '131'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.82 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.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
12	JTable->load()	JROOT/components/com_icecool_designer_diamonds/models/designerdiamondsproduct.php:76
11	Icecool_designer_diamondsModelDesignerdiamondsproduct->getData()	JROOT/libraries/legacy/view/legacy.php:408
10	JViewLegacy->get()	JROOT/components/com_icecool_designer_diamonds/views/designerdiamondsproduct/view.html.php:34
9	Icecool_designer_diamondsViewDesignerdiamondsproduct->display()	JROOT/libraries/legacy/controller/legacy.php:664
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php:17
6	require_once JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.54 ms After last query: 0.35 ms Query memory: 0.027 MB Memory before query: 1.798 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `icecool_assets`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
19	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
18	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
17	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
16	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
14	JUser->authorise()	JROOT/administrator/components/com_icecool_designer_diamonds/tables/designerdiamondsproduct.php:94
13	Icecool_designer_diamondsTabledesignerdiamondsproduct->bind()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/components/com_icecool_designer_diamonds/models/designerdiamondsproduct.php:76
11	Icecool_designer_diamondsModelDesignerdiamondsproduct->getData()	JROOT/libraries/legacy/view/legacy.php:408
10	JViewLegacy->get()	JROOT/components/com_icecool_designer_diamonds/views/designerdiamondsproduct/view.html.php:34
9	Icecool_designer_diamondsViewDesignerdiamondsproduct->display()	JROOT/libraries/legacy/controller/legacy.php:664
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php:17
6	require_once JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.97 ms After last query: 0.17 ms Query memory: 0.025 MB Memory before query: 1.820 MB Rows returned: 1

SELECT *

  FROM icecool_assets

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
17	JTable->load()	JROOT/libraries/joomla/access/access.php:697
16	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
14	JUser->authorise()	JROOT/administrator/components/com_icecool_designer_diamonds/tables/designerdiamondsproduct.php:94
13	Icecool_designer_diamondsTabledesignerdiamondsproduct->bind()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/components/com_icecool_designer_diamonds/models/designerdiamondsproduct.php:76
11	Icecool_designer_diamondsModelDesignerdiamondsproduct->getData()	JROOT/libraries/legacy/view/legacy.php:408
10	JViewLegacy->get()	JROOT/components/com_icecool_designer_diamonds/views/designerdiamondsproduct/view.html.php:34
9	Icecool_designer_diamondsViewDesignerdiamondsproduct->display()	JROOT/libraries/legacy/controller/legacy.php:664
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php:17
6	require_once JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.10 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 1.827 MB Rows returned: 1

SELECT a.rules

  FROM icecool_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
14	JUser->authorise()	JROOT/administrator/components/com_icecool_designer_diamonds/tables/designerdiamondsproduct.php:94
13	Icecool_designer_diamondsTabledesignerdiamondsproduct->bind()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/components/com_icecool_designer_diamonds/models/designerdiamondsproduct.php:76
11	Icecool_designer_diamondsModelDesignerdiamondsproduct->getData()	JROOT/libraries/legacy/view/legacy.php:408
10	JViewLegacy->get()	JROOT/components/com_icecool_designer_diamonds/views/designerdiamondsproduct/view.html.php:34
9	Icecool_designer_diamondsViewDesignerdiamondsproduct->display()	JROOT/libraries/legacy/controller/legacy.php:664
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php:17
6	require_once JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.33 ms Query memory: 0.025 MB Memory before query: 1.840 MB Rows returned: 2

SELECT a.id, a.parent_id

  FROM icecool_assets AS a

  WHERE (a.name LIKE 'com_icecool_designer_diamonds.%' OR a.name = 'com_icecool_designer_diamonds' OR a.id = 1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	101	100.00	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
17	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
14	JUser->authorise()	JROOT/administrator/components/com_icecool_designer_diamonds/tables/designerdiamondsproduct.php:94
13	Icecool_designer_diamondsTabledesignerdiamondsproduct->bind()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/components/com_icecool_designer_diamonds/models/designerdiamondsproduct.php:76
11	Icecool_designer_diamondsModelDesignerdiamondsproduct->getData()	JROOT/libraries/legacy/view/legacy.php:408
10	JViewLegacy->get()	JROOT/components/com_icecool_designer_diamonds/views/designerdiamondsproduct/view.html.php:34
9	Icecool_designer_diamondsViewDesignerdiamondsproduct->display()	JROOT/libraries/legacy/controller/legacy.php:664
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php:17
6	require_once JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.58 ms After last query: 0.83 ms Query memory: 0.025 MB Memory before query: 1.917 MB Rows returned: 2

SELECT a.id, a.name, a.rules

  FROM icecool_assets AS a

  WHERE (a.name LIKE 'com_icecool_designer_diamonds.%' OR a.name = 'com_icecool_designer_diamonds' OR a.id = 1 )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	101	100.00	Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
18	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
17	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
14	JUser->authorise()	JROOT/administrator/components/com_icecool_designer_diamonds/tables/designerdiamondsproduct.php:94
13	Icecool_designer_diamondsTabledesignerdiamondsproduct->bind()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/components/com_icecool_designer_diamonds/models/designerdiamondsproduct.php:76
11	Icecool_designer_diamondsModelDesignerdiamondsproduct->getData()	JROOT/libraries/legacy/view/legacy.php:408
10	JViewLegacy->get()	JROOT/components/com_icecool_designer_diamonds/views/designerdiamondsproduct/view.html.php:34
9	Icecool_designer_diamondsViewDesignerdiamondsproduct->display()	JROOT/libraries/legacy/controller/legacy.php:664
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php:17
6	require_once JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 0.87 ms After last query: 0.16 ms Query memory: 0.024 MB Memory before query: 1.933 MB Rows returned: 3

SELECT b.rules

  FROM icecool_assets AS a

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

  WHERE (a.name = 'com_icecool_designer_diamonds.designerdiamondsproduct.131' OR a.name = 'com_icecool_designer_diamonds' OR a.parent_id=0)

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	202,4	NULL	3	100.00	Using sort_union(idx_asset_name,idx_parent_id); Using where; Using temporary; Using filesort
1	SIMPLE	b	ALL	idx_lft_rgt	NO INDEX KEY COULD BE USED	NULL	NULL	101	100.00	Range checked for each record (index map: 0x4)

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.14 ms
Creating sort index	0.02 ms
end	0.00 ms
removing tmp table	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
14	JUser->authorise()	JROOT/administrator/components/com_icecool_designer_diamonds/tables/designerdiamondsproduct.php:94
13	Icecool_designer_diamondsTabledesignerdiamondsproduct->bind()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/components/com_icecool_designer_diamonds/models/designerdiamondsproduct.php:76
11	Icecool_designer_diamondsModelDesignerdiamondsproduct->getData()	JROOT/libraries/legacy/view/legacy.php:408
10	JViewLegacy->get()	JROOT/components/com_icecool_designer_diamonds/views/designerdiamondsproduct/view.html.php:34
9	Icecool_designer_diamondsViewDesignerdiamondsproduct->display()	JROOT/libraries/legacy/controller/legacy.php:664
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php:17
6	require_once JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.23 ms After last query: 0.32 ms Query memory: 0.023 MB Memory before query: 1.948 MB Rows returned: 1

SELECT a.rules

  FROM icecool_assets AS a

  WHERE (a.name = 'com_icecool_designer_diamonds.designerdiamondsproduct.131' OR a.name = 'com_icecool_designer_diamonds')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	range	idx_asset_name	idx_asset_name	202	NULL	2	100.00	Using index condition

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 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.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
14	JAccess::getAssetRules()	JROOT/administrator/components/com_icecool_designer_diamonds/tables/designerdiamondsproduct.php:96
13	Icecool_designer_diamondsTabledesignerdiamondsproduct->bind()	JROOT/libraries/joomla/table/table.php:729
12	JTable->load()	JROOT/components/com_icecool_designer_diamonds/models/designerdiamondsproduct.php:76
11	Icecool_designer_diamondsModelDesignerdiamondsproduct->getData()	JROOT/libraries/legacy/view/legacy.php:408
10	JViewLegacy->get()	JROOT/components/com_icecool_designer_diamonds/views/designerdiamondsproduct/view.html.php:34
9	Icecool_designer_diamondsViewDesignerdiamondsproduct->display()	JROOT/libraries/legacy/controller/legacy.php:664
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php:17
6	require_once JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 2.10 ms After last query: 1.33 ms Query memory: 0.023 MB Memory before query: 1.983 MB Rows returned: 1

SELECT name

  FROM `icecool_icecool_designer_diamonds_designer`

  WHERE `id` = 5

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.92 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/templates/icecool-home/html/com_icecool_designer_diamonds/designerdiamondsproduct/default.php:41
12	include JROOT/templates/icecool-home/html/com_icecool_designer_diamonds/designerdiamondsproduct/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
10	JViewLegacy->display()	JROOT/components/com_icecool_designer_diamonds/views/designerdiamondsproduct/view.html.php:56
9	Icecool_designer_diamondsViewDesignerdiamondsproduct->display()	JROOT/libraries/legacy/controller/legacy.php:664
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php:17
6	require_once JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.45 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 1.990 MB Rows returned: 1

SELECT title

  FROM icecool_icecool_designer_diamonds_products

  WHERE id=131

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/templates/icecool-home/html/com_icecool_designer_diamonds/designerdiamondsproduct/default.php:182
12	include JROOT/templates/icecool-home/html/com_icecool_designer_diamonds/designerdiamondsproduct/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
10	JViewLegacy->display()	JROOT/components/com_icecool_designer_diamonds/views/designerdiamondsproduct/view.html.php:56
9	Icecool_designer_diamondsViewDesignerdiamondsproduct->display()	JROOT/libraries/legacy/controller/legacy.php:664
8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php:17
6	require_once JROOT/components/com_icecool_designer_diamonds/icecool_designer_diamonds.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 3.39 ms After last query: 2.12 ms Query memory: 0.023 MB Memory before query: 2.060 MB Rows returned: 12

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

  FROM icecool_modules AS m

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

  LEFT JOIN icecool_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 <= '2024-05-17 12:19:10') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-17 12:19:10') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 272 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	14	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	coltscou_clients.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	coltscou_clients.m.module,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.28 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
10	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
9	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
8	JModuleHelper::getModules()	JROOT/libraries/joomla/document/renderer/html/modules.php:40
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

2 × SELECT a.rules 
  FROM icecool_assets AS a

1 × SELECT `data` 
  FROM `icecool_session`

1 × SELECT title 
  FROM icecool_icecool_designer_diamonds_products

1 × SELECT name 
  FROM `icecool_icecool_designer_diamonds_designer`

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

1 × SELECT a.id, a.name, a.rules 
  FROM icecool_assets AS a

1 × SELECT a.id, a.parent_id 
  FROM icecool_assets AS a

```
1 × SELECT * 
  FROM icecool_assets
```

1 × SELECT * 
  FROM icecool_icecool_designer_diamonds_products

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

1 × SELECT * 
  FROM icecool_languages

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM icecool_menu AS m 
  LEFT JOIN icecool_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `enabled` 
  FROM `icecool_extensions`

1 × SELECT folder AS type, element AS name, params 
  FROM icecool_extensions

1 × SELECT id, rules 
  FROM `icecool_viewlevels

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

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

OTHER Tables:

1 × UPDATE `icecool_extensions` 
  SET `params` = '{\"mediaversion\":\"e85a0a96ee209d22efad0585b9531d19\"}'

1 × SHOW FULL COLUMNS 
  FROM `icecool_icecool_designer_diamonds_products

1 × SHOW FULL COLUMNS 
  FROM `icecool_assets

custom made diamond rings & jewellery

Book a Design Appointment

020 7404 6374

£635.00 - BJP0087RG

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

23 Queries Logged 43.13 ms

21 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: