18ct white gold channel set half eternity set with 0.25ct of princess cut diamonds of G colour and SI1 clarity.
Product code: BJR0130PR
Total diamond weight:0.25ct
Price from: £ 530.00
To place an order or to discuss your ideas:
Email: nina@icecooldiamonds.com
At Icecool diamonds we pride ourselves on our customer service, attention to detail and ensuring our clients enjoys a unique & personal experience.
Because every customer is an individual we tailor our service entirely to your needs, and don’t believe in shopping “baskets” which we feel removes the human element. We fully understand the difficulties of committing to a purchase without the reassurance that a personal service guarantees.
So please call or email us, we look forward to hearing from you.
{ "__default": { "session": { "counter": 5, "timer": { "start": 1715941992, "last": 1715941994, "now": 1715941994 } }, "registry": { "com_icecool_engagement_rings": { "edit": { "engagementringdetails": { "id": "48princess" } } }, "com_icecool_designer_diamonds": { "edit": { "designerdiamondsproduct": { "id": "139" } } } }, "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": "Princess Cut Four Claw Yellow Gold Engagement Ring GRC502YG ", "designerDiamondDetails": "\u00a3530.00 - BJR0130PR" } }
SELECT `data`
FROM `icecool_session`
WHERE `session_id` = 'c4f9cbb12c37a236bddc14c62388b66d'
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 |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.01 ms |
checking query cache for query | 0.04 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.03 ms |
optimizing | 0.01 ms |
statistics | 0.03 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.00 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.01 ms |
cleaning up | 0.01 ms |
# | 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 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `icecool_extensions`
WHERE `type` = 'component'
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 |
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.09 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.17 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.01 ms |
freeing items | 0.04 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.00 ms |
storing result in query cache | 0.14 ms |
cleaning up | 0.03 ms |
# | 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 |
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
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 |
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 |
checking permissions | 0.00 ms |
sending cached result to clien | 0.02 ms |
cleaning up | 0.04 ms |
# | 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 |
SELECT id, rules
FROM `icecool_viewlevels`
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 |
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 |
# | 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 |
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
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 |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.00 ms |
checking query cache for query | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.03 ms |
optimizing | 0.02 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.42 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 |
# | 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 |
SELECT `enabled`
FROM `icecool_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
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 |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.06 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.01 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 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.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.01 ms |
cleaning up | 0.14 ms |
# | 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 |
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
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 |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.00 ms |
checking query cache for query | 0.06 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.09 ms |
Waiting for query cache lock | 0.00 ms |
System lock | 0.04 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
Creating sort index | 0.23 ms |
Waiting for query cache lock | 0.00 ms |
Creating sort index | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.12 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.01 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.01 ms |
# | 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 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `icecool_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
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 |
Status | Duration |
---|---|
starting | 0.02 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.02 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.03 ms |
Waiting for query cache lock | 0.00 ms |
freeing items | 0.00 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.01 ms |
# | 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 |
UPDATE `icecool_extensions`
SET `params` = '{\"mediaversion\":\"22079e63f3f57c608c2cdec3ebefc8dc\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
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 |
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.07 ms |
System lock | 0.07 ms |
updating | 0.04 ms |
end | 0.01 ms |
query end | 7.45 ms |
closing tables | 0.03 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | 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 |
SELECT *
FROM icecool_languages
WHERE published=1
ORDER BY ordering ASC
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 |
Status | Duration |
---|---|
starting | 0.02 ms |
Waiting for query cache lock | 0.08 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 |
sending cached result to clien | 0.02 ms |
cleaning up | 0.01 ms |
# | 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 |
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
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 |
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 privileges on cached | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.02 ms |
cleaning up | 0.00 ms |
# | 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 |
SHOW FULL COLUMNS
FROM `icecool_icecool_designer_diamonds_products`
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.21 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.01 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.05 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 ms |
# | 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 |
SELECT *
FROM icecool_icecool_designer_diamonds_products
WHERE `id` = '139'
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 |
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.02 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.49 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.04 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.00 ms |
storing result in query cache | 0.02 ms |
cleaning up | 0.02 ms |
# | 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 |
SHOW FULL COLUMNS
FROM `icecool_assets`
Status | Duration |
---|---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.97 ms |
init | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 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.02 ms |
checking permissions | 0.01 ms |
Sending data | 0.02 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 |
freeing items | 0.03 ms |
cleaning up | 0.03 ms |
# | 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 |
SELECT *
FROM icecool_assets
WHERE `id` = '1'
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 |
Status | Duration |
---|---|
starting | 0.02 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.01 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.02 ms |
cleaning up | 0.01 ms |
# | 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 |
SELECT a.rules
FROM icecool_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')
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 |
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 |
# | 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 |
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)
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 |
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 |
# | 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 |
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 )
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 |
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.04 ms |
cleaning up | 0.00 ms |
# | 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 |
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.139' OR a.name = 'com_icecool_designer_diamonds' OR a.parent_id=0)
ORDER BY b.lft
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) |
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 |
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.01 ms |
statistics | 0.13 ms |
preparing | 0.02 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.00 ms |
executing | 0.00 ms |
Sending data | 0.14 ms |
Creating sort index | 0.03 ms |
end | 0.00 ms |
removing tmp table | 0.01 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 |
# | 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 |
SELECT a.rules
FROM icecool_assets AS a
WHERE (a.name = 'com_icecool_designer_diamonds.designerdiamondsproduct.139' OR a.name = 'com_icecool_designer_diamonds')
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 |
Status | Duration |
---|---|
starting | 0.01 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.00 ms |
System lock | 0.03 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 |
# | 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 |
SELECT name
FROM `icecool_icecool_designer_diamonds_designer`
WHERE `id` = 5
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 |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.05 ms |
init | 0.01 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.00 ms |
checking permissions | 0.00 ms |
sending cached result to clien | 0.01 ms |
cleaning up | 0.00 ms |
# | 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 |
SELECT title
FROM icecool_icecool_designer_diamonds_products
WHERE id=139
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 |
Status | Duration |
---|---|
starting | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
init | 0.01 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.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 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.01 ms |
freeing items | 0.00 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.01 ms |
# | 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 |
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 10:33:14')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-17 10:33:14')
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
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 |
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 |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
sending cached result to clien | 0.02 ms |
cleaning up | 0.00 ms |
# | 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 |
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
1 × UPDATE `icecool_extensions`
SET `params` = '{\"mediaversion\":\"22079e63f3f57c608c2cdec3ebefc8dc\"}'
1 × SHOW FULL COLUMNS
FROM `icecool_icecool_designer_diamonds_products
1 × SHOW FULL COLUMNS
FROM `icecool_assets