Platinum 950 four claw oval diamond engagement ring with tapered shoulders.
Product Code ICD801PLT
Diamond weight 0.35ct - 2.00ct
Centre Diamond Please call or email us and we will help you
find your perfect diamond.
Price from £400.00
Our aim is to find your perfect diamond, and we understand the difficulties that are involved in making sure the diamond you buy is the one for you. At Icecool diamonds we will help you find the diamond that fulfils your exact requirements.
Please click on the link below and give us as much information as possible and we will do the rest.
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": 11, "timer": { "start": 1715937724, "last": 1715937729, "now": 1715937729 } }, "registry": { "com_icecool_engagement_rings": { "edit": { "engagementringdetails": { "id": "123oval" } } }, "com_icecool_designer_diamonds": { "edit": { "designerdiamondsproduct": { "id": "159" } } } }, "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": "Oval Platinum 950 Diamond Engagement Ring ICD801PLT", "designerDiamondDetails": "\u00a3450.00 - BJR0150_YG" } }
SELECT `data`
FROM `icecool_session`
WHERE `session_id` = '5ac9b40cad4526554c18714b1901ad03'
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.03 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.01 ms |
checking query cache for query | 0.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.02 ms |
System lock | 0.01 ms |
Waiting for query cache lock | 0.01 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.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.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 |
DELETE
FROM `icecool_session`
WHERE `time` < '1715936829'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | icecool_session | range | time | time | 59 | const | 1 | 100.00 | Using where |
Status | Duration |
---|---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 ms |
System lock | 0.38 ms |
updating | 0.19 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.37 ms |
# | Caller | File and line number |
---|---|---|
6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:790 |
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.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.04 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.18 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.05 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.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.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.00 ms |
sending cached result to clien | 0.01 ms |
cleaning up | 0.00 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.02 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.01 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.01 ms |
checking query cache for query | 0.05 ms |
checking permissions | 0.01 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.32 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.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 |
---|---|---|
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.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.06 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.07 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.01 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.01 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.05 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
init | 0.03 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.24 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.08 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.10 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.01 ms |
freeing items | 0.00 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.02 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.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 |
# | 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\":\"194da5583af41cfbf06255e0abff2ca7\"}'
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.01 ms |
System lock | 0.05 ms |
updating | 0.04 ms |
end | 0.01 ms |
query end | 1.88 ms |
closing tables | 0.02 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.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.02 ms |
cleaning up | 0.00 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.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 |
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_engagement_rings`
Status | Duration |
---|---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.36 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.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.06 ms |
checking permissions | 0.02 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.08 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.02 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_engagement_rings/tables/engagementringdetails.php:24 |
14 | Icecool_engagement_ringsTableengagementringdetails->__construct() | JROOT/libraries/joomla/table/table.php:308 |
13 | JTable::getInstance() | JROOT/components/com_icecool_engagement_rings/models/engagementringdetails.php:100 |
12 | Icecool_engagement_ringsModelEngagementringdetails->getTable() | JROOT/components/com_icecool_engagement_rings/models/engagementringdetails.php:73 |
11 | Icecool_engagement_ringsModelEngagementringdetails->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
10 | JViewLegacy->get() | JROOT/components/com_icecool_engagement_rings/views/engagementringdetails/view.html.php:34 |
9 | Icecool_engagement_ringsViewEngagementringdetails->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_engagement_rings/icecool_engagement_rings.php:17 |
6 | require_once JROOT/components/com_icecool_engagement_rings/icecool_engagement_rings.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_engagement_rings
WHERE `id` = '123oval'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | icecool_engagement_rings | 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.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.01 ms |
optimizing | 0.01 ms |
statistics | 1.20 ms |
preparing | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
preparing | 0.01 ms |
storing result in query cache | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
cleaning up | 0.01 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_engagement_rings/models/engagementringdetails.php:76 |
11 | Icecool_engagement_ringsModelEngagementringdetails->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
10 | JViewLegacy->get() | JROOT/components/com_icecool_engagement_rings/views/engagementringdetails/view.html.php:34 |
9 | Icecool_engagement_ringsViewEngagementringdetails->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_engagement_rings/icecool_engagement_rings.php:17 |
6 | require_once JROOT/components/com_icecool_engagement_rings/icecool_engagement_rings.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.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.24 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.02 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.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.07 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.05 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_engagement_rings/tables/engagementringdetails.php:81 |
13 | Icecool_engagement_ringsTableengagementringdetails->bind() | JROOT/libraries/joomla/table/table.php:729 |
12 | JTable->load() | JROOT/components/com_icecool_engagement_rings/models/engagementringdetails.php:76 |
11 | Icecool_engagement_ringsModelEngagementringdetails->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
10 | JViewLegacy->get() | JROOT/components/com_icecool_engagement_rings/views/engagementringdetails/view.html.php:34 |
9 | Icecool_engagement_ringsViewEngagementringdetails->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_engagement_rings/icecool_engagement_rings.php:17 |
6 | require_once JROOT/components/com_icecool_engagement_rings/icecool_engagement_rings.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.01 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 |
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_engagement_rings/tables/engagementringdetails.php:81 |
13 | Icecool_engagement_ringsTableengagementringdetails->bind() | JROOT/libraries/joomla/table/table.php:729 |
12 | JTable->load() | JROOT/components/com_icecool_engagement_rings/models/engagementringdetails.php:76 |
11 | Icecool_engagement_ringsModelEngagementringdetails->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
10 | JViewLegacy->get() | JROOT/components/com_icecool_engagement_rings/views/engagementringdetails/view.html.php:34 |
9 | Icecool_engagement_ringsViewEngagementringdetails->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_engagement_rings/icecool_engagement_rings.php:17 |
6 | require_once JROOT/components/com_icecool_engagement_rings/icecool_engagement_rings.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.01 ms |
init | 0.01 ms |
checking query cache for query | 0.01 ms |
checking privileges on cached | 0.02 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_engagement_rings/tables/engagementringdetails.php:81 |
13 | Icecool_engagement_ringsTableengagementringdetails->bind() | JROOT/libraries/joomla/table/table.php:729 |
12 | JTable->load() | JROOT/components/com_icecool_engagement_rings/models/engagementringdetails.php:76 |
11 | Icecool_engagement_ringsModelEngagementringdetails->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
10 | JViewLegacy->get() | JROOT/components/com_icecool_engagement_rings/views/engagementringdetails/view.html.php:34 |
9 | Icecool_engagement_ringsViewEngagementringdetails->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_engagement_rings/icecool_engagement_rings.php:17 |
6 | require_once JROOT/components/com_icecool_engagement_rings/icecool_engagement_rings.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_engagement_rings.%' OR a.name = 'com_icecool_engagement_rings' 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.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 |
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: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_engagement_rings/tables/engagementringdetails.php:81 |
13 | Icecool_engagement_ringsTableengagementringdetails->bind() | JROOT/libraries/joomla/table/table.php:729 |
12 | JTable->load() | JROOT/components/com_icecool_engagement_rings/models/engagementringdetails.php:76 |
11 | Icecool_engagement_ringsModelEngagementringdetails->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
10 | JViewLegacy->get() | JROOT/components/com_icecool_engagement_rings/views/engagementringdetails/view.html.php:34 |
9 | Icecool_engagement_ringsViewEngagementringdetails->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_engagement_rings/icecool_engagement_rings.php:17 |
6 | require_once JROOT/components/com_icecool_engagement_rings/icecool_engagement_rings.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_engagement_rings.%' OR a.name = 'com_icecool_engagement_rings' 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.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 |
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: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_engagement_rings/tables/engagementringdetails.php:81 |
13 | Icecool_engagement_ringsTableengagementringdetails->bind() | JROOT/libraries/joomla/table/table.php:729 |
12 | JTable->load() | JROOT/components/com_icecool_engagement_rings/models/engagementringdetails.php:76 |
11 | Icecool_engagement_ringsModelEngagementringdetails->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
10 | JViewLegacy->get() | JROOT/components/com_icecool_engagement_rings/views/engagementringdetails/view.html.php:34 |
9 | Icecool_engagement_ringsViewEngagementringdetails->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_engagement_rings/icecool_engagement_rings.php:17 |
6 | require_once JROOT/components/com_icecool_engagement_rings/icecool_engagement_rings.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_engagement_rings.engagementringdetails.123' OR a.name = 'com_icecool_engagement_rings' 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.01 ms |
init | 0.01 ms |
checking query cache for query | 0.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.06 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.08 ms |
preparing | 0.02 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.24 ms |
Creating sort index | 0.03 ms |
end | 0.01 ms |
removing tmp table | 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.01 ms |
freeing items | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
freeing items | 0.01 ms |
storing result in query cache | 0.02 ms |
cleaning up | 0.02 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_engagement_rings/tables/engagementringdetails.php:81 |
13 | Icecool_engagement_ringsTableengagementringdetails->bind() | JROOT/libraries/joomla/table/table.php:729 |
12 | JTable->load() | JROOT/components/com_icecool_engagement_rings/models/engagementringdetails.php:76 |
11 | Icecool_engagement_ringsModelEngagementringdetails->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
10 | JViewLegacy->get() | JROOT/components/com_icecool_engagement_rings/views/engagementringdetails/view.html.php:34 |
9 | Icecool_engagement_ringsViewEngagementringdetails->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_engagement_rings/icecool_engagement_rings.php:17 |
6 | require_once JROOT/components/com_icecool_engagement_rings/icecool_engagement_rings.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_engagement_rings.engagementringdetails.123' OR a.name = 'com_icecool_engagement_rings')
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.07 ms |
init | 0.01 ms |
checking query cache for query | 0.04 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.01 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.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.03 ms |
cleaning up | 0.05 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_engagement_rings/tables/engagementringdetails.php:83 |
13 | Icecool_engagement_ringsTableengagementringdetails->bind() | JROOT/libraries/joomla/table/table.php:729 |
12 | JTable->load() | JROOT/components/com_icecool_engagement_rings/models/engagementringdetails.php:76 |
11 | Icecool_engagement_ringsModelEngagementringdetails->getData() | JROOT/libraries/legacy/view/legacy.php:408 |
10 | JViewLegacy->get() | JROOT/components/com_icecool_engagement_rings/views/engagementringdetails/view.html.php:34 |
9 | Icecool_engagement_ringsViewEngagementringdetails->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_engagement_rings/icecool_engagement_rings.php:17 |
6 | require_once JROOT/components/com_icecool_engagement_rings/icecool_engagement_rings.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_engagement_rings
WHERE id=123
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | icecool_engagement_rings | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
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.02 ms |
init | 0.01 ms |
System lock | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 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.01 ms |
freeing items | 0.03 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.07 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_engagement_rings/engagementringdetails/default.php:162 |
12 | include JROOT/templates/icecool-home/html/com_icecool_engagement_rings/engagementringdetails/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_engagement_rings/views/engagementringdetails/view.html.php:56 |
9 | Icecool_engagement_ringsViewEngagementringdetails->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_engagement_rings/icecool_engagement_rings.php:17 |
6 | require_once JROOT/components/com_icecool_engagement_rings/icecool_engagement_rings.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 09:22:09')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-17 09:22:09')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 124 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.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.01 ms |
checking permissions | 0.00 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 a.rules
FROM icecool_assets AS a
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `icecool_extensions`
1 × SELECT `data`
FROM `icecool_session`
1 × SELECT title
FROM icecool_engagement_rings
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 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_engagement_rings
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 × DELETE
FROM `icecool_session`
1 × UPDATE `icecool_extensions`
SET `params` = '{\"mediaversion\":\"194da5583af41cfbf06255e0abff2ca7\"}'
1 × SHOW FULL COLUMNS
FROM `icecool_engagement_rings
1 × SHOW FULL COLUMNS
FROM `icecool_assets