Jenkins Sugar Group Cocoa Report
May 17, 2012 – May 30, 2012
July | $2070 | Down $222 |
Sept | $2081 | Down $223 |
Metrics:
Over the course of the past two weeks, cocoa outpaced the impressive drop in the CRB of 4.8% - New York lost 9.7% and London lost 5.9%. Dollar strength likely contributed to New York’s losses as the dollar index gained nearly 2% while the pound dropped 2.5%.
Cocoa Market:
Spain.
Greece.
Sell.
Repeat.
Wake us up when silly season begins.
Misc.
· Grindings:
o Over the past several reports, we have shown production over the past 30 years from a variety of origins. Some have shown persistent growth (Ghana); some have been a bit irregular (Brazil); some have shown an increase in the past few years (Ecuador); some have put fear in our thoughts with wobbly production, save for the past 2 La Nina related years (Cote d’Ivoire); some have seemingly hit a ceiling (Indonesia); and others have taken the exit ramp (Malaysia).
o Below we show production’s significant other, grindings. It’s impressive how production has been able to keep up with demand over this time span – from 1.5 mm tons to over 4.0mm. A key point of tension continues to exist over the market’s ability to solve for additional quantities in the future, especially should current low prices continue. Consumption dynamics really changed in 2008, with the recession that dented chocolate consumption. Grindings over the past few years have been led by powder demand, given weak chocolate sales and strong marketing efforts by companies promoting powder based goods.
· ICE cocoa & CRB:
· Misc.:
o Charles Taylor, former President of Liberia, was sentenced by The Hague to a 50 year prison sentence for his role in aiding war crimes in Sierra Leone.
o ICCO adjusted their 2011/12 deficit to 43,000 tons from 71,000 tons, roughly in line with most other estimates.
o One scholar’s take on the role of China in Africa:
§ http://www.bbc.co.uk/news/world-africa-18143515
o It’s been a slow news couple of weeks, so we offer the following article – at least these people are flying while cocoa prices are crashing:
§ http://www.bbc.co.uk/news/world-africa-18066260
Best Regards,
Ken Lorenze
Jenkins Sugar Group
142 Old Ridgefield Road
Suite 205
Wilton, Ct 06897
Office: (203) –563-6100
Cell: (203)-722-4690
This report has been compiled for general informational purposes only. While every effort has been made to ensure accuracy, Jenkins Sugar Group, Inc. assumes no responsibility for errors and omissions.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1711646208, "last": 1711646208, "now": 1711646208 } }, "registry": {}, "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 } } }
SELECT `data`
FROM `jsg_session`
WHERE `session_id` = '0ec9933ada74001f00900d2c153c4080'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jsg_session | const | PRIMARY | PRIMARY | 766 | const | 1 |
Status | Duration |
---|---|
Starting | 0.21 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.11 ms |
Checking query cache for query | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.11 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.17 ms |
Statistics | 0.07 ms |
Preparing | 0.01 ms |
Executing | 0.02 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.13 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.01 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
13 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:44 |
12 | JSessionStorageDatabase->read() | Same as call in the line below. |
11 | session_start() | JROOT/libraries/joomla/session/handler/native.php:259 |
10 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:49 |
9 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:81 |
8 | JSessionHandlerJoomla->start() | JROOT/libraries/joomla/session/session.php:636 |
7 | JSession->_start() | JROOT/libraries/joomla/session/session.php:596 |
6 | JSession->start() | JROOT/libraries/cms/application/cms.php:773 |
5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:408 |
2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
1 | JFactory::getApplication() | JROOT/index.php:46 |
SELECT `session_id`
FROM `jsg_session`
WHERE `session_id` = '0ec9933ada74001f00900d2c153c4080'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jsg_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
Status | Duration |
---|---|
Starting | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.15 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.03 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.09 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.11 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.07 ms |
Reset for next command | 0.01 ms |
# | 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 |
INSERT INTO `jsg_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('0ec9933ada74001f00900d2c153c4080', 0, 1, '1711646208', 0, '')
Status | Duration |
---|---|
Starting | 0.16 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init for update | 0.02 ms |
Update | 0.15 ms |
Waiting for query cache lock | 0.01 ms |
Update | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.15 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.10 ms |
Updating status | 0.03 ms |
Reset for next command | 0.01 ms |
# | 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 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jsg_extensions`
WHERE `type` = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jsg_extensions | ref | extension | extension | 82 | const | 34 | Using index condition |
Status | Duration |
---|---|
Starting | 0.15 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.01 ms |
checking privileges on cached | 0.10 ms |
checking permissions | 0.01 ms |
Sending cached result to clien | 0.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 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 jsg_usergroups AS a
LEFT JOIN jsg_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 | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | Using where; Using index |
Status | Duration |
---|---|
Starting | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 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 `jsg_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jsg_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 |
Status | Duration |
---|---|
Starting | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 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 jsg_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 | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jsg_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 162 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.09 ms |
Updating status | 0.01 ms |
Reset for next command | 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 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 jsg_menu AS m
LEFT JOIN jsg_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 | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 14 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | ct_jenk_3p628.m.component_id | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.12 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.11 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:86 |
14 | JMenuSite->load() | JROOT/libraries/cms/menu/menu.php:74 |
13 | JMenu->__construct() | JROOT/libraries/cms/menu/site.php:57 |
12 | JMenuSite->__construct() | JROOT/libraries/cms/menu/menu.php:145 |
11 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:439 |
10 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
9 | JApplicationSite->getMenu() | JROOT/libraries/cms/router/site.php:57 |
8 | JRouterSite->__construct() | JROOT/libraries/cms/router/router.php:197 |
7 | JRouter::getInstance() | JROOT/libraries/cms/application/cms.php:535 |
6 | JApplicationCms::getRouter() | JROOT/libraries/cms/application/site.php:407 |
5 | JApplicationSite::getRouter() | JROOT/libraries/cms/application/cms.php:1115 |
4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jsg_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jsg_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|---|
Starting | 0.15 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.09 ms |
Updating status | 0.01 ms |
Reset for next command | 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 `jsg_extensions`
SET `params` = '{\"mediaversion\":\"26450d1cf6aa1abf50d99649f287c534\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Status | Duration |
---|---|
Starting | 0.14 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init for update | 0.29 ms |
Updating | 0.05 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.10 ms |
Updating status | 0.02 ms |
Reset for next command | 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 jsg_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jsg_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/language/helper.php:164 |
5 | JLanguageHelper::getLanguages() | JROOT/libraries/cms/application/site.php:329 |
4 | JApplicationSite->getParams() | JROOT/libraries/cms/application/site.php:135 |
3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
1 | JApplicationCms->execute() | JROOT/index.php:49 |
SELECT id, home, template, s.params
FROM jsg_template_styles as s
LEFT JOIN jsg_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 | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | Using index condition; Using where |
1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|---|
Starting | 0.13 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 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 `jsg_assets`
Status | Duration |
---|---|
Starting | 0.14 ms |
checking permissions | 0.01 ms |
closing tables | 0.01 ms |
Opening tables | 0.53 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.01 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Filling schema table | 0.06 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
checking permissions | 0.09 ms |
closing tables | 0.04 ms |
Executing | 0.01 ms |
Sending data | 0.05 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.07 ms |
closing tables | 0.05 ms |
Removing tmp table | 0.16 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.05 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.10 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
19 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
18 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
17 | JTable->__construct() | JROOT/libraries/joomla/table/asset.php:60 |
16 | JTableAsset->__construct() | JROOT/libraries/joomla/table/table.php:308 |
15 | JTable::getInstance() | JROOT/libraries/joomla/access/access.php:696 |
14 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
13 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:262 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
6 | require_once JROOT/components/com_content/content.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 jsg_assets
WHERE `id` = '1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jsg_assets | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.09 ms |
Updating status | 0.01 ms |
Reset for next command | 0.04 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
16 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
15 | JTable->load() | JROOT/libraries/joomla/access/access.php:697 |
14 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
13 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:262 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
6 | require_once JROOT/components/com_content/content.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 jsg_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | index_merge | PRIMARY,idx_asset_name | PRIMARY,idx_asset_name | 4,202 | NULL | 2 | Using union(PRIMARY,idx_asset_name); Using where |
Status | Duration |
---|---|
Starting | 0.17 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
14 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:652 |
13 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:262 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
6 | require_once JROOT/components/com_content/content.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 element
FROM jsg_extensions
WHERE type = 'component'
AND enabled = '1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jsg_extensions | ref | extension | extension | 82 | const | 34 | Using index condition; Using where |
Status | Duration |
---|---|
Starting | 0.09 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 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:413 |
15 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
14 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
13 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:262 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
6 | require_once JROOT/components/com_content/content.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.name, a.rules
FROM jsg_assets AS a
WHERE (a.name IN ('com_admin','com_ajax','com_baforms','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_finder','com_installer','com_j2xml','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sppolls','com_tags','com_templates','com_users','com_wrapper') OR a.name = 'root.1')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | a | range | idx_asset_name | idx_asset_name | 202 | NULL | 35 | Using index condition |
Status | Duration |
---|---|
Starting | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
starting | 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.10 ms |
Updating status | 0.01 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
16 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:441 |
15 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
14 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
13 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
12 | JUser->authorise() | JROOT/components/com_content/models/article.php:55 |
11 | ContentModelArticle->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
10 | JModelLegacy->getState() | JROOT/components/com_content/models/article.php:262 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
6 | require_once JROOT/components/com_content/content.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 `jsg_content`
Status | Duration |
---|---|
Starting | 0.18 ms |
checking permissions | 0.01 ms |
closing tables | 0.01 ms |
Opening tables | 0.64 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init | 0.01 ms |
Optimizing | 0.01 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.01 ms |
Filling schema table | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
checking permissions | 0.20 ms |
closing tables | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.07 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.22 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.12 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
13 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
12 | JTable->__construct() | JROOT/libraries/legacy/table/content.php:31 |
11 | JTableContent->__construct() | JROOT/libraries/joomla/table/table.php:308 |
10 | JTable::getInstance() | JROOT/components/com_content/models/article.php:264 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
6 | require_once JROOT/components/com_content/content.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 jsg_content
WHERE `id` = '2384'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | jsg_content | const | PRIMARY | PRIMARY | 4 | const | 1 |
Status | Duration |
---|---|
Starting | 0.18 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.03 ms |
init | 0.05 ms |
Optimizing | 0.02 ms |
Statistics | 0.09 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.20 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.14 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.01 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
11 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
10 | JTable->load() | JROOT/components/com_content/models/article.php:265 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
6 | require_once JROOT/components/com_content/content.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 |
UPDATE jsg_content
SET `hits` = (`hits` + 1)
WHERE `id` = '2384'
Status | Duration |
---|---|
Starting | 0.15 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
init for update | 0.06 ms |
Updating | 0.10 ms |
End of update loop | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
End of update loop | 0.17 ms |
Query end | 0.01 ms |
Commit | 0.15 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.12 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/table/table.php:1228 |
10 | JTable->hit() | JROOT/components/com_content/models/article.php:266 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:109 |
8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
6 | require_once JROOT/components/com_content/content.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.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jsg_content AS a
LEFT JOIN jsg_categories AS c
on c.id = a.catid
LEFT JOIN jsg_users AS u
on u.id = a.created_by
LEFT JOIN jsg_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jsg_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jsg_categories AS cat JOIN jsg_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 2384
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-03-28 17:16:48')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-03-28 17:16:48')
AND (a.state = 1 OR a.state =2)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | a | const | PRIMARY,idx_state | PRIMARY | 4 | const | 1 | |
1 | PRIMARY | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | PRIMARY | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | PRIMARY | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | PRIMARY | v | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | const | 2 | |
2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 1 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | index | PRIMARY,idx_left_right | idx_left_right | 8 | NULL | 28 | Using where; Using index; Using join buffer (flat, BNL join) |
Status | Duration |
---|---|
Starting | 0.10 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.21 ms |
checking permissions | 0.01 ms |
Opening tables | 0.08 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.03 ms |
init | 0.12 ms |
Optimizing | 0.05 ms |
Optimizing | 0.02 ms |
Statistics | 0.08 ms |
Statistics | 0.16 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.02 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.13 ms |
Executing | 0.01 ms |
Sending data | 0.12 ms |
Creating sort index | 0.09 ms |
Removing tmp table | 0.01 ms |
Creating sort index | 0.04 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.04 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.03 ms |
Removing tmp table | 0.04 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.11 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.06 ms |
Reset for next command | 0.15 ms |
# | Caller | File and line number |
---|---|---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:159 |
12 | ContentModelArticle->getItem() | JROOT/libraries/legacy/view/legacy.php:408 |
11 | JViewLegacy->get() | JROOT/components/com_content/views/article/view.html.php:42 |
10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
6 | require_once JROOT/components/com_content/content.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 c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jsg_categories as c
LEFT JOIN (SELECT cat.id as id
FROM jsg_categories AS cat JOIN jsg_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN jsg_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND badcats.id is null
AND s.id=52
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Using temporary; Using filesort |
1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | NO INDEX KEY COULD BE USED | NULL | NULL | 28 | Using where |
1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | ct_jenk_3p628.c.id | 5 | Using where |
2 | DERIVED | parent | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 2 | Using index condition; Using temporary; Using filesort |
2 | DERIVED | cat | index | PRIMARY,idx_left_right | idx_left_right | 8 | NULL | 28 | Using where; Using index; Using join buffer (flat, BNL join) |
Status | Duration |
---|---|
Starting | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.24 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
init | 0.11 ms |
Optimizing | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.08 ms |
Statistics | 0.16 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.09 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.04 ms |
Creating tmp table | 0.08 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.08 ms |
Executing | 0.01 ms |
Sending data | 0.18 ms |
Creating sort index | 0.07 ms |
Removing tmp table | 0.01 ms |
Creating sort index | 0.97 ms |
Creating sort index | 0.07 ms |
Removing tmp table | 0.19 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.14 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.01 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|---|---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:309 |
13 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
12 | JCategories->get() | JROOT/components/com_content/helpers/route.php:44 |
11 | ContentHelperRoute::getArticleRoute() | JROOT/components/com_content/views/article/view.html.php:71 |
10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
6 | require_once JROOT/components/com_content/content.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`.`tag_id`,`t`.*
FROM `jsg_contentitem_tag_map` AS m
INNER JOIN `jsg_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 2384
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ALL | idx_tag_type | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | ct_jenk_3p628.m.tag_id | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.15 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.14 ms |
init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.15 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.06 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.10 ms |
Updating status | 0.12 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.02 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|---|---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:435 |
11 | JHelperTags->getItemTags() | JROOT/components/com_content/views/article/view.html.php:156 |
10 | ContentViewArticle->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
6 | require_once JROOT/components/com_content/content.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 |
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jsg_extensions`
1 × SELECT `data`
FROM `jsg_session`
1 × SELECT a.rules
FROM jsg_assets AS a
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jsg_categories as c
LEFT JOIN (SELECT cat.id as id
FROM jsg_categories AS cat JOIN jsg_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jsg_content AS a
LEFT JOIN jsg_categories AS c
on c.id = a.catid
LEFT JOIN jsg_users AS u
on u.id = a.created_by
LEFT JOIN jsg_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jsg_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jsg_categories AS cat JOIN jsg_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT *
FROM jsg_content
1 × SELECT a.name, a.rules
FROM jsg_assets AS a
1 × SELECT element
FROM jsg_extensions
1 × SELECT id, home, template, s.params
FROM jsg_template_styles as s
LEFT JOIN jsg_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM jsg_assets
1 × SELECT `session_id`
FROM `jsg_session`
1 × SELECT *
FROM jsg_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 jsg_menu AS m
LEFT JOIN jsg_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params
FROM jsg_extensions
1 × SELECT id, rules
FROM `jsg_viewlevels
1 × SELECT b.id
FROM jsg_usergroups AS a
LEFT JOIN jsg_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `m`.`tag_id`,`t`.*
FROM `jsg_contentitem_tag_map` AS m
INNER JOIN `jsg_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × INSERT INTO `jsg_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('0ec9933ada74001f00900d2c153c4080', 0, 1, '1711646208', 0, ''
1 × UPDATE `jsg_extensions`
SET `params` = '{\"mediaversion\":\"26450d1cf6aa1abf50d99649f287c534\"}'
1 × SHOW FULL COLUMNS
FROM `jsg_assets
1 × SHOW FULL COLUMNS
FROM `jsg_content
1 × UPDATE jsg_content
SET `hits` = (`hits` + 1)