v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}
Tuesday November 18, 2014
World sugar futures posted a recent high at 16.44 last Wednesday and have quietly shed 79 points, or 4.8 %, since basis today’s low. March has printed lower highs, lows and settlements each of the past four sessions in indifferent dealings. As for today, prices settled six lower in March at 15.71 and from four to 10 lower in the back months. Traded volume was 56,486 lots – as good an indication as any of the session’s energy level. On spread, March/May traded from 34 to 38 under and last at 37 under. May/July traded from 23 to 26 under and last at 24 under.
Option watch: Option volume was a brawny 24,509 contacts with more than 50 % traded in the March calls. Vol’s in the front months drifted lower. January vol is 17.71, down .43 %; March vol is 18.04, down .43 %; and May is 17.00, down .39 %. Trades of note: 1,630 January 15.00 Puts trade 6-7, 500 January 16.00/15.50 Fences trade flat, 650 February 15.00 Puts vs 15.70 trade 17, 500 February 16.25 Calls vs 15.74 trade 25, 500 February 16.50/15.00 Fences trade flat, 2,700 March 16.50 Calls vs 15.75 trade 28-29, 2,500 March 16.00 Calls vs 15.75 trade 45, 1,070 March 16.75/15.00 Fences trade 4, 1,000 March 16.25/17.50 Call Spreads vs 15.74 trade 25, 850 March 16.75/16.00 Put Spreads trade 54, 800 March 16.50/17.75 Call Spreads vs 15.75 trade 20 and 700 July 17.00 Calls vs 16.34 trade 54.
The Ukraine has produced1.5 million tonnes of sugar from domestically grown beets, a 90 % increase over last season at the same point. The Ag Ministry and producer’s union expect total production of 1.70 million tonnes, a 42 % increase over last year. Brazil’s government has called for a meeting with representatives of the ethanol production sector and theautomotive industry on Friday to discuss the increase in the percentage of anhydrous ethanol blended with gasoline from 25 % to 27.5 %, according to Kingsman’s Daily News Summary. The government is expected to present the results of technical studies showing the elevated mix will not cause increased risk for motor vehicles. The National Sugarcane Forum would like the high level of ethanol to be implemented by January 1st, but expectations are that the government will not act until April 2015. India’s food department has forecast the current crop at 25.0 million tonnes, above the 24.5 million tonnes forecast earlier this year. According to the Times of India, 56 cooperative and 41 private mills have started crushing in Maharashtra, although wet conditions have slowed cane cutting and transport to mills. Sugar output in the country is up 21 % year on year at 560,000 tonnes, compared to 462,000 tonnes at this stage a year earlier. According to the Indian Sugar Mills Association, stocks in the country total 7.5 million tonnes as of October 1st. Mills in Pakistan may delay the start of their crushing season, which should begin by the fourth week of November, due to surplus stocks of 1.5 million tonnes from last season and the government’s refusal to grant a subsidy for exports.
In the NAFTAregion: Light activity in the spot January between 24.05 and 24.00 accounted for all of the activity in the US futures market today. Prices settled 17 higher in January at 24.20, 18 higher in March and from eight higher to 20 lower in the back months. Some comments regarding the AD/CVD suspension agreements have been made public. Comments submitted on behalf of the American Sugar Coalition, the Plaintiffs in the case, stated in part, “for purposes of the Agreements, ‘refined sugar’ must be defined as sugar with a polarity of 99.50 and above, dry weight, pursuant to Chapter 17 Harmonized Tariff Schedule of the United States, 19 U.S.C. §1202 (hereinafter cited as ‘HTSUS’). All ‘other sugar’ must be defined as sugar with a polarity of less than 99.50 dry weight that is imported for further processing in a refinery. For this purpose, ‘further processing’ should be defined as ‘(1) performing those actions to further improve the quality of the sugar resulting in an enhancement of the dry weight polarimeter reading of not less than 0.15 degrees, and (2) performing all three of the following steps: (a) one or more of affination, defecation, or clarification, (b) filtration, and (c) further purification by one or more of adsorption, ion-exchange or crystallization.’” Additionally, ASC stated that “each importer of record in the United States should be required to certify to CBP that, to the best of the importer’s knowledge and belief, the price actually paid to the mill or mills that produced the sugar being entered was at or above the relevant Reference Price. In addition, each importer of “other sugar” should be required to provide to CBP in connection with each entry of “other sugar” a certification or certifications from refiners that the Sugar covered by that entry will be further processed in the United States.” Most importantly, to our eyes, ASC requested, “The Department should clarify in the final suspension agreement that the United States will prohibit entry of any Sugar from Mexico that issold at prices less than the reference price established in Appendix I of the Agreement. In so clarifying, the Department should explain that the 15 percent rule in paragraph two of the “Price Undercutting” section is a secondary requirement to the Reference Price. Simply put, the Reference Price is the price that governs on a transaction-by-transaction basis. In addition, the Department should define the basis for the Reference Prices to be F.O.B. mill U.S. dollars per pound at 96 degrees polarity, dry weight.” The full ASC comment can be found here: http://www.sugaralliance.org/wp-content/uploads/2014/11/2014-11-18-Petitioners-Suspension-Agreement-Comments.pdf
The Sweetener Users Association also offered significant comments. In part, the SUA requested, “In particular, the suspension agreements should not take effect until after the Department has issued final determinations in the antidumping and countervailing duty investigations and, assuming those determinations are affirmative, the United States International Trade Commission ("ITC") has issued a final affirmative injury determination.” SUA also stated “the Department should revise the definition of ‘refined sugar’ in the draft AD and CVD suspension agreements so that the definition is consistent with the prevailing industry definition that is also embodied in the HTSUS (i.e., a definition of refined sugar as having a polarimeter reading of 99.5 degrees or greater). The SUA’s full comment can be found here: http://sugarreform.org/wp-content/uploads/2014/11/SUA-Comments-re-Draft-Agreements.pdf
While it is not clear how willing the signatories in the case - DOC and the Government of Mexico – will be to adopt these and/or other changes to the suspension agreements, today was an important day in the ongoing process. It is increasingly clearthat the cane refining industry in the US as it currently exists will be drastically challenged if the suspension agreements are signed as initiallyproposed. As the comment presented on behalf of the ASC concluded, “Without these changes, the efficacy of the AD Agreement and its ability to ensure the continued vitality of the domestic sugar industry is substantially undermined, if not fully eviscerated.”
Regards,
Jenkins Sugar Group, Inc.
This email address is being protected from spambots. You need JavaScript enabled to view it.
JSG Indications: |
Q4’14 |
Q1’15 |
Q2’15 |
Q3’15 |
Q4’15 |
Q1’16 |
|
Raws: USNH: |
23.25 |
24.25 |
24.50 |
24.75 |
25.00 |
25.00 |
|
Mexican peso to USD: |
13.5674 |
Raws: “Fair value” #16 futures pre-close, or JSG estimate.
This report has been compiled for general informational purposes only. While efforts have been made to ensure accuracy, Jenkins Sugar Group, Inc. assumes no responsibility for errors and omissions.
{ "__default": { "session": { "counter": 1, "timer": { "start": 1714145848, "last": 1714145848, "now": 1714145848 } }, "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` = '0fabe745021c5baaf8b26810dd348c11'
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.15 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.05 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.02 ms |
init | 0.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.06 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.18 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.09 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.16 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` = '0fabe745021c5baaf8b26810dd348c11'
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.08 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.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.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.08 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.03 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 ('0fabe745021c5baaf8b26810dd348c11', 0, 1, '1714145848', 0, '')
Status | Duration |
---|---|
Starting | 0.16 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 |
init for update | 0.02 ms |
Update | 0.25 ms |
Waiting for query cache lock | 0.01 ms |
Update | 0.03 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.24 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.08 ms |
Updating status | 0.02 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.08 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.02 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.02 ms |
Optimizing | 0.01 ms |
Statistics | 0.29 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.25 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.09 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 |
---|---|---|
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.14 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.12 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.07 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.10 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.07 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.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.03 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.58 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.10 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.09 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 |
---|---|---|
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.09 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 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 |
Waiting for query cache lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.13 ms |
Preparing | 0.04 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.17 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.09 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 |
---|---|---|
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.17 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 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.02 ms |
Statistics | 0.12 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.04 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.08 ms |
Updating status | 0.03 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.17 ms |
Reset for next command | 0.05 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\":\"a65d5aa1103f475c07ee4fe9e7b03306\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Status | Duration |
---|---|
Starting | 0.11 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.07 ms |
init for update | 0.06 ms |
Updating | 0.07 ms |
End of update loop | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
End of update loop | 0.20 ms |
Query end | 0.01 ms |
Commit | 0.11 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.08 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.16 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.07 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.07 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.07 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.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.05 ms |
Executing | 0.01 ms |
Sending data | 0.09 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.58 ms |
Freeing items | 0.08 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 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.03 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.12 ms |
checking permissions | 0.01 ms |
closing tables | 0.01 ms |
Opening tables | 0.52 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.03 ms |
After opening tables | 0.01 ms |
checking permissions | 0.09 ms |
closing tables | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.04 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.14 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.05 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.08 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.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.11 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: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.14 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 |
---|---|---|
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.12 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.02 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.16 ms |
Preparing | 0.03 ms |
Executing | 0.01 ms |
Sending data | 0.12 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.08 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.05 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 ms |
Storing result in query cache | 0.08 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.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.11 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.11 ms |
checking permissions | 0.01 ms |
closing tables | 0.01 ms |
Opening tables | 0.27 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.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
checking permissions | 0.16 ms |
closing tables | 0.01 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 |
Removing tmp table | 0.13 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.08 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` = '3561'
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.09 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.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.03 ms |
Optimizing | 0.01 ms |
Statistics | 0.06 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.07 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.03 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.09 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 |
---|---|---|
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` = '3561'
Status | Duration |
---|---|
Starting | 0.12 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 |
init for update | 0.05 ms |
Updating | 0.09 ms |
End of update loop | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
End of update loop | 0.55 ms |
Query end | 0.01 ms |
Commit | 0.12 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.09 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 = 3561
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 15:37:28')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 15:37:28')
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.08 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.23 ms |
checking permissions | 0.02 ms |
Opening tables | 0.08 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
table lock | 0.01 ms |
Waiting for query cache lock | 0.03 ms |
init | 0.11 ms |
Optimizing | 0.05 ms |
Optimizing | 0.02 ms |
Statistics | 0.10 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.10 ms |
Executing | 0.01 ms |
Sending data | 0.11 ms |
Creating sort index | 0.06 ms |
Removing tmp table | 0.01 ms |
Creating sort index | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
Creating sort index | 0.06 ms |
End of update loop | 0.02 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
closing tables | 0.01 ms |
Removing tmp table | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.09 ms |
Updating status | 0.04 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.03 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.08 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.17 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.02 ms |
init | 0.11 ms |
Optimizing | 0.04 ms |
Optimizing | 0.02 ms |
Statistics | 0.07 ms |
Statistics | 0.15 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.02 ms |
Preparing | 0.01 ms |
Unlocking tables | 0.01 ms |
Preparing | 0.05 ms |
Creating tmp table | 0.07 ms |
Sorting result | 0.02 ms |
Executing | 0.01 ms |
Sending data | 0.07 ms |
Executing | 0.01 ms |
Sending data | 0.09 ms |
Creating sort index | 0.10 ms |
Removing tmp table | 0.01 ms |
Creating sort index | 0.56 ms |
Creating sort index | 0.08 ms |
Removing tmp table | 0.12 ms |
Creating sort index | 0.01 ms |
End of update loop | 0.01 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.09 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.03 ms |
Reset for next command | 0.03 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` = 3561
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.10 ms |
Waiting for query cache lock | 0.01 ms |
starting | 0.01 ms |
Checking query cache for query | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 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.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.08 ms |
Preparing | 0.03 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.01 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.08 ms |
Updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
Updating status | 0.01 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 ('0fabe745021c5baaf8b26810dd348c11', 0, 1, '1714145848', 0, ''
1 × UPDATE `jsg_extensions`
SET `params` = '{\"mediaversion\":\"a65d5aa1103f475c07ee4fe9e7b03306\"}'
1 × SHOW FULL COLUMNS
FROM `jsg_assets
1 × SHOW FULL COLUMNS
FROM `jsg_content
1 × UPDATE jsg_content
SET `hits` = (`hits` + 1)