Icecool diamonds

custom made diamond rings & jewellery

Book a Design Appointment

020 7404 6374

Create your Diamond Engagement Ring

It couldn't be simpler to build your diamond engagement ring.

Tailor Made Ring, Tailor Made Engagement Rings

OR if you have a specific design, perhaps you've seen something you like elsewhere or you'd like us to make something similar please contact us with your idea and we can work together to create it bespoke for you.

Step 3 - Choose your ring

Round 4 Claw Yellow Gold Engagement Ring GRC650YG

Select this ring

Round Four Claw Yellow Gold Engagement Ring GRC680YG

Select this ring

Round Six Claw Yellow Gold Engagement Ring GRC757YG

Select this ring

Round Yellow Gold Micro Diamond Set Engagement Ring CRC762

Select this ring

Round Four Claw Yellow Gold Channel Set Engagement Ring...

Select this ring

Round Four Claw Yellow Gold Channel Set Engagement Ring...

Select this ring

Round 0.50ct Yellow Gold Halo Diamond Set Engagement Ring...

Select this ring

Round 0.25ct Yellow Gold Halo Diamond Set Engagement Ring...

Select this ring

Round Rub Over Yellow Gold Engagement Ring IC0503YG

Select this ring

Round Four Claw Yellow Gold Engagement Ring ICD185YG

Select this ring

Princess Cut Four Claw Yellow Gold Engagement Ring GRC502YG

Select this ring

Princess Cut Four Claw Yellow Gold Engagement Ring GRC651YG

Select this ring

Princess Cut Four Claw Yellow Gold Engagement Ring GRC759YG

Select this ring

Princess Cut Four Claw Yellow Gold Engagement Ring GRC785

Select this ring

Princess Cut Four Claw Yellow Gold Engagement Ring ICD1527YG

Select this ring

Princess Cut 4 Claw Yellow Gold Diamond Engagement Ring...

Select this ring

Princess Cut Rub Over Yellow Gold Engagement Ring ICD1527YG

Select this ring

Round Four Claw Yellow Gold Engagement Ring GRC783YG

Select this ring

Round 0.50ct Yellow Gold Halo Diamond Set Engagement Ring...

Select this ring

Round 0.70ct Yellow Gold Halo Diamond Set Engagement Ring...

Select this ring

Round Four Claw Yellow Gold Engagement Ring ICD185YG

Select this ring

Pear Shape Yellow Gold Diamond Engagement Ring GRC689YG

Select this ring

Pear Shape Yellow Gold Diamond Engagement Ring ICD2722

Select this ring

Pear Shape Yellow Gold Ring with Channel Set Shoulders...

Select this ring

Pear Shape 3 Claw Yellow Gold Diamond Engagement Ring...

Select this ring

Pear Shape Rub Over Yellow Gold Engagement Ring ICD2852YG

Select this ring

Marquise Cut Yellow Gold Diamond Engagement Ring GRC687YG

Select this ring

Marquise Cut 4 Claw Yellow Gold Diamond Engagement Ring...

Select this ring

Marquise Cut Yellow Gold Ring with Channel Set Shoulders...

Select this ring

Marquise Cut Yellow Gold Diamond Engagement Ring ICD2402YG

Select this ring

Marquise Cut Rub Over Yellow Gold Engagement Ring ICD2554YG

Select this ring

Marquise Cut Yellow Gold Ring with Pave Set Shoulders...

Select this ring

Emerald Cut Yellow Gold Diamond Engagement Ring GRC688YG

Select this ring

Oval Yellow Gold Diamond Engagement Ring GRC575YG

Select this ring

Oval Yellow Gold Diamond Engagement Ring ICD801YG

Select this ring

Oval Yellow Gold Diamond Engagement Ring ICD1001

Select this ring

Round 4 Claw White Gold Engagement Ring GRC650

Select this ring

Round Four Claw White Gold Engagement Ring GRC680

Select this ring

Round Six Claw White Gold Engagement Ring GRC757

Select this ring

Round Diamond Engagement Ring CRC762

Select this ring

Round Four Claw White Gold Channel Set Engagement Ring...

Select this ring

Round Four Claw White Gold Channel Set Engagement Ring...

Select this ring

Round 0.50ct White Gold Halo Diamond Set Engagement Ring...

Select this ring

Round 0.25ct White Gold Halo Diamond Set Engagement Ring...

Select this ring

Round Rub Over White Gold Engagement Ring IC0503

Select this ring

Round Four Claw White Gold Engagement Ring ICD185

Select this ring

Princess Cut Four Claw White Gold Engagement Ring GRC502

Select this ring

Princess Cut Four Claw White Gold Engagement Ring GRC651

Select this ring

Princess Cut Four Claw White Gold Engagement Ring GRC759

Select this ring

Princess Cut Four Claw White Gold Engagement Ring GRC785

Select this ring

Princess Cut Four Claw White Gold Engagement Ring ICD1527

Select this ring

Princess Cut 4 Claw White Gold Diamond Engagement Ring...

Select this ring

Princess Cut Rub Over White Gold Engagement Ring ICD1527

Select this ring

Round Four Claw White Gold 950 Engagement Ring GRC783

Select this ring

Round 0.50ct White Gold Halo Diamond Set Engagement Ring...

Select this ring

Round 0.70ct White Gold Halo Diamond Set Engagement Ring...

Select this ring

Pear Shape White Gold Diamond Engagement Ring GRC689

Select this ring

Pear Shape White Gold Diamond Engagement Ring ICD2722

Select this ring

Pear Shape White Gold Ring with Channel Set Shoulders CRC750

Select this ring

Pear Shape 3 Claw White Gold Diamond Engagement Ring CRC698

Select this ring

Pear Shape Rub Over White Gold Engagement Ring ICD2852

Select this ring

Marquise Cut White Gold Diamond Engagement Ring GRC687

Select this ring

Marquise Cut 4 Claw White Gold Diamond Engagement Ring...

Select this ring

Marquise Cut White Gold Ring with Channel Set Shoulders...

Select this ring

Marquise Cut White Gold Diamond Engagement Ring ICD2402

Select this ring

Marquise Cut Rub Over White Gold Engagement Ring ICD2554

Select this ring

Marquise Cut White Gold Ring with Pave Set Shoulders GRC554

Select this ring

Emerald Cut White Gold Diamond Engagement Ring GRC688

Select this ring

Emerald Cut 4 claw Platinum Diamond Engagement Ring...

Select this ring

Oval White Gold Diamond Engagement Ring GRC575

Select this ring

Oval White Gold Diamond Engagement Ring ICD801

Select this ring

Oval White Gold Diamond Engagement Ring ICD1001

Select this ring

Oval Platinum 950 Diamond Engagement Ring ICD1001

Select this ring

Round 4 Claw Platinum Engagement Ring GRC650PLT

Select this ring

Round Four Claw Platinum Engagement Ring GRC680PLT

Select this ring

Round Six Claw Platinum Engagement Ring GRC757PLT

Select this ring

Round Four Claw Diamond Engagement Ring CRC762PLT

Select this ring

Round 4 Claw Platinum Channel Set Engagement Ring CRC761PLT

Select this ring

Round 0.50ct Platinum Halo Diamond Set Engagement Ring...

Select this ring

Round 0.25ct Platinum Halo Diamond Engagement Ring GRC639PLT

Select this ring

Round Rub Over Platinum Engagement Ring IC0503PLT

Select this ring

Round Four Claw Platinum Engagement Ring ICD185PLT

Select this ring

Princess Cut Four Claw Platinum Engagement Ring GRC651PLT

Select this ring

Princess Cut Four Claw Platinum Engagement Ring GRC502PLT

Select this ring

Princess Cut Four Claw Platinum Engagement Ring GRC759PLT

Select this ring

Princess Cut Four Claw Platinum Engagement Ring GRC785PLT

Select this ring

Princess Cut 4 Claw Platinum Engagement Ring ICD1527PLT

Select this ring

Princess Cut Platinum Micro Set Diamond Engagement Ring...

Select this ring

Round Four Claw Platinum Channel Set Engagement Ring CRC739

Select this ring

Round Four Claw Platinum Engagement Ring GRC783PLT

Select this ring

Round 0.50ct Platinum Halo Diamond Engagement Ring...

Select this ring

Round 0.70ct Platinum Halo Diamond Set Engagement Ring...

Select this ring

Round Four Claw Platinum Engagement Ring ICD185PLT

Select this ring

Pear Shape Platinum Diamond Engagement Ring GRC689PLT

Select this ring

Pear Shape Platinum Diamond Engagement Ring ICD2722

Select this ring

Pear Shape Platinum Ring with Channel Set Shoulders...

Select this ring

Pear Shape 3 Claw Platinum Diamond Engagement Ring CRC698PLT

Select this ring

Pear Shape Rub Over Platinum Engagement Ring ICD2852PLT

Select this ring

Marquise Cut Platinum Diamond Engagement Ring GRC687

Select this ring

Marquise Cut Platinum Micro Set Diamond Engagement Ring...

Select this ring

Marquise Cut Platinum Ring with Channel Set Shoulders...

Select this ring

Marquise Cut Platinum Diamond Engagement Ring ICD2402PLT

Select this ring

Marquise Cut Rub Over Platinum Engagement Ring ICD2554PLT

Select this ring

Marquise Cut Platinum Ring with Pave Set Shoulders GRC554PLT

Select this ring

Oval Platinum 950 Diamond Engagement Ring GRC575PLT

Select this ring

Oval Platinum 950 Diamond Engagement Ring ICD801PLT

Select this ring

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714657396,
                "last": 1714657396,
                "now": 1714657396
            }
        },
        "registry": {
            "com_icecool_engagement_rings": {
                "engagementrings": {
                    "ordercol": "a.ordering"
                }
            }
        },
        "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
        }
    }
}

Profile Information

Memory Usage

Database Queries

17 Queries Logged 68.84 ms

Query Time: 2.50 ms Query memory: 0.022 MB Memory before query: 0.902 MB Rows returned: 0

SELECT `data`

  FROM `icecool_session`

  WHERE `session_id` = 'cb26babeb45085a27b3754cfd8f70145'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 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.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.90 ms
executing	0.02 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.01 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 1.23 ms After last query: 6.34 ms Query memory: 0.019 MB Memory before query: 0.919 MB Rows returned: 0

SELECT `session_id`

  FROM `icecool_session`

  WHERE `session_id` = 'cb26babeb45085a27b3754cfd8f70145' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 4.83 ms After last query: 0.13 ms Query memory: 0.003 MB Memory before query: 0.924 MB

INSERT INTO `icecool_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('cb26babeb45085a27b3754cfd8f70145', 0, 1, '1714657396', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `icecool_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('cb26babeb45085a27b3754cfd8f70145', 0, 1, '1714657396', 0, '')

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	1.29 ms
Waiting for query cache lock	0.01 ms
update	0.02 ms
end	0.00 ms
query end	2.67 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Query Time: 3.82 ms After last query: 4.46 ms Query memory: 0.024 MB Memory before query: 0.948 MB Rows returned: 45

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

  FROM `icecool_extensions`

  WHERE `type` = 'component'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.75 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	2.17 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.03 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.05 ms

Call Stack

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

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

Query Time: 2.93 ms After last query: 3.95 ms Query memory: 0.021 MB Memory before query: 1.034 MB Rows returned: 2

SELECT b.id

  FROM icecool_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.06 ms
Waiting for query cache lock	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	1.68 ms
preparing	0.02 ms
executing	0.02 ms
Sending data	0.02 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.01 ms
cleaning up	0.05 ms

Call Stack

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

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

Query Time: 1.78 ms After last query: 1.82 ms Query memory: 0.021 MB Memory before query: 1.039 MB Rows returned: 4

SELECT id, rules

  FROM `icecool_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking 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.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.82 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.00 ms
cleaning up	0.03 ms

Call Stack

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

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

Query Time: 3.21 ms After last query: 0.11 ms Query memory: 0.025 MB Memory before query: 1.047 MB Rows returned: 66

SELECT folder AS type, element AS name, params

  FROM icecool_extensions

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

  ORDER BY ordering

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.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.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.04 ms
Creating sort index	1.73 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.01 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 1.91 ms After last query: 11.65 ms Query memory: 0.020 MB Memory before query: 1.331 MB Rows returned: 1

SELECT `enabled`

  FROM `icecool_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking permissions	0.03 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.04 ms
optimizing	0.01 ms
statistics	0.66 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 6.85 ms After last query: 17.01 ms Query memory: 0.090 MB Memory before query: 1.458 MB Rows returned: 59

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM icecool_menu AS m

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

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

  ORDER BY m.lft

Explain

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

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 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.03 ms
optimizing	0.02 ms
statistics	1.11 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.81 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.08 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.09 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.02 ms
freeing items	0.01 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Query Time: 1.16 ms After last query: 41.49 ms Query memory: 0.022 MB Memory before query: 2.125 MB Rows returned: 1

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

  FROM `icecool_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.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.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.07 ms
Waiting for query cache lock	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 3.80 ms After last query: 0.14 ms Query memory: 0.005 MB Memory before query: 2.116 MB

UPDATE `icecool_extensions`

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

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.05 ms
updating	0.04 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.03 ms
query end	2.96 ms
closing tables	0.03 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 2.75 ms After last query: 3.46 ms Query memory: 0.019 MB Memory before query: 2.132 MB Rows returned: 1

SELECT *

  FROM icecool_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

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

Call Stack

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

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

Query Time: 1.83 ms After last query: 0.22 ms Query memory: 0.019 MB Memory before query: 2.141 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM icecool_template_styles as s

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

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

Explain

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

Profile

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	1.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.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.05 ms

Call Stack

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

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

Query Time: 16.78 ms After last query: 11.67 ms Query memory: 0.047 MB Memory before query: 2.268 MB Rows returned: 20

SELECT a.*,uc.name AS editor,icecool_engagement_rings_diamond_shapes_704271.title AS diamondshapes_title_704271,icecool_engagement_rings_metal_types_704272.title AS metaltypes_title_704272,created_by.name AS created_by

  FROM `icecool_engagement_rings` AS a

  LEFT JOIN icecool_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN icecool_engagement_rings_diamond_shapes AS icecool_engagement_rings_diamond_shapes_704271 
  ON icecool_engagement_rings_diamond_shapes_704271.id = a.diamond_shape

  LEFT JOIN icecool_engagement_rings_metal_types AS icecool_engagement_rings_metal_types_704272 
  ON icecool_engagement_rings_metal_types_704272.id = a.metal_type

  LEFT JOIN icecool_users AS created_by 
  ON created_by.id = a.created_by 
  LIMIT 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	126	100.00	NULL
1	SIMPLE	uc	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	icecool_engagement_rings_diamond_shapes_704271	eq_ref	PRIMARY	PRIMARY	4	coltscou_clients.a.diamond_shape	1	100.00	Using where
1	SIMPLE	icecool_engagement_rings_metal_types_704272	eq_ref	PRIMARY	PRIMARY	4	coltscou_clients.a.metal_type	1	100.00	Using where
1	SIMPLE	created_by	eq_ref	PRIMARY	PRIMARY	4	coltscou_clients.a.created_by	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	12.13 ms
init	0.04 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.04 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	3.03 ms
Waiting for query cache lock	0.02 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 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.05 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
13	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
12	JModelList->getItems()	JROOT/components/com_icecool_engagement_rings/models/engagementrings.php:123
11	Icecool_engagement_ringsModelEngagementrings->getItems()	JROOT/libraries/legacy/view/legacy.php:408
10	JViewLegacy->get()	JROOT/components/com_icecool_engagement_rings/views/engagementrings/view.html.php:33
9	Icecool_engagement_ringsViewEngagementrings->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

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

Query Time: 1.07 ms After last query: 2.26 ms Query memory: 0.023 MB Memory before query: 2.344 MB Rows returned: 1

SELECT COUNT(*)

  FROM `icecool_engagement_rings` AS a

  LEFT JOIN icecool_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN icecool_engagement_rings_diamond_shapes AS icecool_engagement_rings_diamond_shapes_704271 
  ON icecool_engagement_rings_diamond_shapes_704271.id = a.diamond_shape

  LEFT JOIN icecool_engagement_rings_metal_types AS icecool_engagement_rings_metal_types_704272 
  ON icecool_engagement_rings_metal_types_704272.id = a.metal_type

  LEFT JOIN icecool_users AS created_by 
  ON created_by.id = a.created_by

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	126	100.00	NULL
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	coltscou_clients.a.checked_out	1	100.00	Using index
1	SIMPLE	icecool_engagement_rings_diamond_shapes_704271	eq_ref	PRIMARY	PRIMARY	4	coltscou_clients.a.diamond_shape	1	100.00	Using where; Using index
1	SIMPLE	icecool_engagement_rings_metal_types_704272	index	PRIMARY	PRIMARY	4	NULL	3	100.00	Using where; Using index; Using join buffer (Block Nested Loop)
1	SIMPLE	created_by	eq_ref	PRIMARY	PRIMARY	4	coltscou_clients.a.created_by	1	100.00	Using index

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
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.03 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.36 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.04 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
13	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
12	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
11	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:408
10	JViewLegacy->get()	JROOT/components/com_icecool_engagement_rings/views/engagementrings/view.html.php:34
9	Icecool_engagement_ringsViewEngagementrings->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

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

Query Time: 8.20 ms After last query: 2.87 ms Query memory: 0.247 MB Memory before query: 2.363 MB Rows returned: 106

Select e.title as gallerytitle, e.id as galleryid, e.*, m.*, d.* 
  From icecool_engagement_rings as e, icecool_engagement_rings_metal_types as m, icecool_engagement_rings_diamond_shapes as d 
  Where e.state = 1 
  AND e.diamond_shape=d.id 
  AND e.metal_type=m.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	126	100.00	Using where
1	SIMPLE	d	eq_ref	PRIMARY	PRIMARY	4	coltscou_clients.e.diamond_shape	1	100.00	Using index condition
1	SIMPLE	m	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	3	100.00	Using where; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 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.02 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.45 ms
Waiting for query cache lock	0.01 ms
Sending data	0.21 ms
Waiting for query cache lock	0.01 ms
Sending data	0.14 ms
Waiting for query cache lock	0.00 ms
Sending data	0.14 ms
Waiting for query cache lock	0.00 ms
Sending data	0.13 ms
Waiting for query cache lock	0.00 ms
Sending data	0.14 ms
Waiting for query cache lock	0.00 ms
Sending data	0.14 ms
Waiting for query cache lock	0.00 ms
Sending data	0.26 ms
Waiting for query cache lock	0.01 ms
Sending data	0.14 ms
Waiting for query cache lock	0.00 ms
Sending data	0.14 ms
Waiting for query cache lock	0.00 ms
Sending data	0.04 ms
end	0.03 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.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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/templates/icecool-home/html/com_icecool_engagement_rings/engagementrings/default.php:105
12	include JROOT/templates/icecool-home/html/com_icecool_engagement_rings/engagementrings/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/engagementrings/view.html.php:43
9	Icecool_engagement_ringsViewEngagementrings->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

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

Query Time: 4.18 ms After last query: 21.02 ms Query memory: 0.024 MB Memory before query: 2.866 MB Rows returned: 12

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

  FROM icecool_modules AS m

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

  LEFT JOIN icecool_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-02 13:43:17') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-02 13:43:17') 
  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

Explain

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

Profile

Status	Duration
starting	0.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.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	1.42 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.71 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.43 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.03 ms

Call Stack

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

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

16 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

1 × SELECT `data` 
  FROM `icecool_session`

1 × SELECT `session_id` 
  FROM `icecool_session`

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 id, rules 
  FROM `icecool_viewlevels

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

1 × SELECT `enabled` 
  FROM `icecool_extensions`

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 * 
  FROM icecool_languages

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 a.*,uc.name AS editor,icecool_engagement_rings_diamond_shapes_704271.title AS diamondshapes_title_704271,icecool_engagement_rings_metal_types_704272.title AS metaltypes_title_704272,created_by.name AS created_by 
  FROM `icecool_engagement_rings` AS a 
  LEFT JOIN icecool_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN icecool_engagement_rings_diamond_shapes AS icecool_engagement_rings_diamond_shapes_704271 
  ON icecool_engagement_rings_diamond_shapes_704271.id = a.diamond_shape 
  LEFT JOIN icecool_engagement_rings_metal_types AS icecool_engagement_rings_metal_types_704272 
  ON icecool_engagement_rings_metal_types_704272.id = a.metal_type 
  LEFT JOIN icecool_users AS created_by 
  ON created_by.id = a.created_by 
  LIMIT 2

1 × SELECT COUNT(*) 
  FROM `icecool_engagement_rings` AS a 
  LEFT JOIN icecool_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN icecool_engagement_rings_diamond_shapes AS icecool_engagement_rings_diamond_shapes_704271 
  ON icecool_engagement_rings_diamond_shapes_704271.id = a.diamond_shape 
  LEFT JOIN icecool_engagement_rings_metal_types AS icecool_engagement_rings_metal_types_704272 
  ON icecool_engagement_rings_metal_types_704272.id = a.metal_type 
  LEFT JOIN icecool_users AS created_by 
  ON created_by.id = a.created_b

1 × Select e.title as gallerytitle, e.id as galleryid, e.*, m.*, d.* 
  From icecool_engagement_rings as e, icecool_engagement_rings_metal_types as m, icecool_engagement_rings_diamond_shapes as d

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

OTHER Tables:

1 × INSERT INTO `icecool_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('cb26babeb45085a27b3754cfd8f70145', 0, 1, '1714657396', 0, ''

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