Live Free or Die: The Dallas Opera's Carmen Seduces to the End

Margaine's voice was certainly part of the appeal -- consistently powerful and capable of big sound, she maintained a warmth of tone in both high and low ranges.
She also made you believe what she was singing. Carmen can come off as flighty; she falls in and out of love over the course of an aria. But rather than playing her as simply manipulative or capricious, Margaine sold Carmen's side of the story.
She did want that guy, until she didn't. She was disillusioned, misunderstood. Ultimately, she just wanted the freedom to love and to leave, to be certain and then change her mind.
And it is her free spirit, not her sensuality that is the draw.

Dallas observer By Katie Womack, Mon., Oct. 28 2013

Voir l'article complet

52 Queries Logged 50.5 ms

11 duplicate found!

2 duplicates: #12 #13

2 duplicates: #19 #21

2 duplicates: #26 #30

5 duplicates: #33 #42 #43 #44 #45

Query Time: 1.15 ms
```
SELECT `session_id`

  FROM `c33_session`

  WHERE `session_id` = '2ef6f424580afb94f8fbc0121b1e56d3' 
  LIMIT 0, 1
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_session NULL const PRIMARY PRIMARY 602 const 1 100.00 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:175
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.65 ms After last query: 0.10 ms
```
INSERT INTO `c33_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('2ef6f424580afb94f8fbc0121b1e56d3', 0, '1686104178')
```
Explain
EXPLAIN not possible on query: INSERT INTO `c33_session` (`session_id`, `client_id`, `time`) VALUES ('2ef6f424580afb94f8fbc0121b1e56d3', 0, '1686104178')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:207
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.95 ms After last query: 6.42 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM c33_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_users'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:570
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_session	NULL	const	PRIMARY	PRIMARY	602	const	1	100.00	Using index

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Query Time: 0.37 ms After last query: 2.19 ms

SELECT b.id

  FROM c33_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/joomla/access/access.php:334

JROOT/libraries/joomla/access/access.php:403

JROOT/libraries/joomla/user/user.php:428

JROOT/libraries/cms/plugin/helper.php:298

JROOT/libraries/cms/plugin/helper.php:165

JROOT/libraries/cms/application/site.php:575

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.37 ms After last query: 0.48 ms
```
SELECT id, rules

  FROM `c33_viewlevels`
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:420
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.35 ms After last query: 0.14 ms
```
SELECT folder AS type, element AS name, params

  FROM c33_extensions

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

  ORDER BY ordering
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_extensions NULL ref extension extension 62 const 96 2.22 Using index condition; Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.38 ms After last query: 8.17 ms
```
SELECT *

  FROM c33_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 50.00 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/language/helper.php:166
JROOT/plugins/system/languagefilter/languagefilter.php:67
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.68 ms After last query: 0.16 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM c33_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/plugins/system/languagefilter/languagefilter.php:69
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.33 ms After last query: 0.33 ms
```
SELECT COUNT(*)

  FROM `c33_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 89 1.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:32
JROOT/plugins/system/languagefilter/languagefilter.php:71
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.43 ms After last query: 22.30 ms
```
SELECT `query`

  FROM `c33_admintools_wafexceptions`

  WHERE (`option` IS NULL OR `option` = '') 
  AND (`view` IS NULL OR `view` = '')

  GROUP BY `query`

  ORDER BY `query` ASC
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/admintools/admintools/main.php:488
JROOT/plugins/system/admintools/admintools/main.php:96
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:582
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.43 ms After last query: 1.57 ms
```
SELECT `value`

  FROM `c33_admintools_storage`

  WHERE `key` = 'cparams'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_admintools/models/storage.php:97
JROOT/administrator/components/com_admintools/models/storage.php:49
JROOT/plugins/system/admintools/feature/nofesalogin.php:26
JROOT/plugins/system/admintools/admintools/main.php:354
JROOT/plugins/system/admintools/admintools/main.php:99
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:582
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.37 ms After last query: 39.94 ms
Duplicate queries: #13
```
SELECT template

  FROM c33_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE s NULL ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 11 9.09 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
JROOT/libraries/rokcommon/RokCommon/Service.php:71
JROOT/libraries/rokcommon/include.php:38
JROOT/plugins/system/rokcommon/rokcommon.php:99
JROOT/plugins/system/rokcommon/rokcommon.php:57
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:582
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.33 ms After last query: 0.08 ms
Duplicate queries: #12
```
SELECT template

  FROM c33_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE s NULL ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 11 9.09 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
JROOT/libraries/rokcommon/RokCommon/Service.php:71
JROOT/libraries/rokcommon/include.php:38
JROOT/plugins/system/rokcommon/rokcommon.php:99
JROOT/plugins/system/rokcommon/rokcommon.php:57
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:582
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.47 ms After last query: 10.89 ms
```
SELECT extension, file, type

  FROM c33_rokcommon_configs

  ORDER BY priority
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_rokcommon_configs NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 100.00 Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/rokcommon/rokcommon.php:130
JROOT/plugins/system/rokcommon/rokcommon.php:78
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:582
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.38 ms After last query: 24.69 ms
```
SELECT *

  FROM `c33_admintools_ipautoban`

  WHERE `ip` = '3.238.118.27'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/admintools/feature/autoipfiltering.php:32
JROOT/plugins/system/admintools/admintools/main.php:536
JROOT/plugins/system/admintools/admintools/main.php:124
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.97 ms After last query: 0.22 ms
```
SELECT `source`,`keepurlparams`

  FROM `c33_admintools_redirects`

  WHERE ((`dest` = 'en/2013-09-05-13-41-29/mariage-julien/vendredi-chez-pernot/254-live-free-or-die') OR (`dest` = 'en/2013-09-05-13-41-29/mariage-julien/vendredi-chez-pernot/254-live-free-or-die') OR ('en/2013-09-05-13-41-29/mariage-julien/vendredi-chez-pernot/254-live-free-or-die' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 0, 1
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL no matching row in const table
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/admintools/feature/urlredir.php:89
JROOT/plugins/system/admintools/admintools/main.php:536
JROOT/plugins/system/admintools/admintools/main.php:124
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.98 ms After last query: 10.52 ms
```
SHOW FULL COLUMNS 
  FROM `c33_extensions`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `c33_extensions`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:237
JROOT/libraries/joomla/table/table.php:158
JROOT/libraries/joomla/table/extension.php:31
JROOT/libraries/joomla/table/table.php:301
JROOT/plugins/system/roksprocket/roksprocket.php:46
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.57 ms After last query: 2.02 ms
```
SELECT `extension_id`

  FROM `c33_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/extension.php:108
JROOT/plugins/system/roksprocket/roksprocket.php:50
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.50 ms After last query: 0.13 ms
Duplicate queries: #21
```
SELECT *

  FROM c33_extensions

  WHERE `extension_id` = '10044'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_extensions NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:723
JROOT/plugins/system/roksprocket/roksprocket.php:55
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.57 ms After last query: 0.15 ms
```
SELECT `extension_id`

  FROM `c33_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/extension.php:108
JROOT/plugins/system/roksprocket/roksprocket.php:73
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.35 ms After last query: 0.13 ms
Duplicate queries: #19
```
SELECT *

  FROM c33_extensions

  WHERE `extension_id` = '10044'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_extensions NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:723
JROOT/plugins/system/roksprocket/roksprocket.php:77
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_extensions	NULL	ref	extension	extension	62	const	96	2.22	Using index condition; Using where; Using filesort

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	89	1.00	Using where

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	11	9.09	Using where

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	11	9.09	Using where

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Query Time: 4.24 ms After last query: 171.26 ms

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 c33_menu AS m

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

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

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	88	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	margainemod1.m.component_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/cms/menu/site.php:47

JROOT/libraries/cms/menu/menu.php:64

JROOT/libraries/cms/menu/menu.php:118

JROOT/libraries/cms/application/cms.php:353

JROOT/libraries/cms/application/site.php:279

JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:131

JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:103

JROOT/plugins/system/sh404sef/sh404sef.php:47

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:583

JROOT/libraries/cms/application/site.php:649

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 1.06 ms After last query: 26.41 ms
```
SELECT `params` 
  FROM c33_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:716
JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:364
JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
JROOT/administrator/components/com_sh404sef/helpers/general.php:111
JROOT/administrator/components/com_sh404sef/classes/config.php:560
JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119
JROOT/plugins/system/sh404sef/sh404sef.php:56
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.53 ms After last query: 24.34 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM c33_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_content'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_extensions NULL ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/components/com_content/router.php:289
JROOT/libraries/cms/router/site.php:369
JROOT/libraries/cms/router/router.php:408
JROOT/libraries/cms/router/router.php:192
JROOT/libraries/cms/router/site.php:90
JROOT/libraries/cms/application/cms.php:1018
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

Query Time: 2.04 ms After last query: 2.81 ms

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 c33_categories as c

  LEFT JOIN c33_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM c33_categories AS cat JOIN c33_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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=254 
  AND badcats.id is null

  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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	38	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	72	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/router.php:327

JROOT/libraries/cms/router/site.php:369

JROOT/libraries/cms/router/router.php:408

JROOT/libraries/cms/router/router.php:192

JROOT/libraries/cms/router/site.php:90

JROOT/libraries/cms/application/cms.php:1018

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 1.65 ms After last query: 0.21 ms
Duplicate queries: #30
```
SELECT `alias`,`catid`

  FROM `c33_content`

  WHERE `id` = 254
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_content/router.php:343
JROOT/libraries/cms/router/site.php:369
JROOT/libraries/cms/router/router.php:408
JROOT/libraries/cms/router/router.php:192
JROOT/libraries/cms/router/site.php:90
JROOT/libraries/cms/application/cms.php:1018
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.25 ms After last query: 0.39 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM c33_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_aclmanager'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/plugins/system/aclmanager/aclmanager.php:22
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.87 ms After last query: 1.33 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM c33_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_extensions NULL ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:179
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/sef/sef.php:30
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.69 ms After last query: 0.31 ms
```
UPDATE `c33_extensions`

  SET `params` = '{\"mediaversion\":\"0e5427850b433b6c18da9347f647da25\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 UPDATE c33_extensions NULL range element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:230
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/sef/sef.php:30
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.46 ms After last query: 4.09 ms
Duplicate queries: #26
```
SELECT `alias`,`catid`

  FROM `c33_content`

  WHERE `id` = 254
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_content/router.php:343
JROOT/libraries/cms/router/site.php:369
JROOT/libraries/cms/router/router.php:408
JROOT/libraries/cms/router/router.php:192
JROOT/libraries/cms/router/site.php:90
JROOT/plugins/system/sef/sef.php:47
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.62 ms After last query: 0.62 ms
```
SELECT alias

  FROM c33_content

  WHERE id=254
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_content NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_content/router.php:113
JROOT/libraries/cms/router/site.php:463
JROOT/libraries/cms/router/site.php:426
JROOT/libraries/cms/router/router.php:231
JROOT/libraries/cms/router/site.php:106
JROOT/libraries/joomla/application/route.php:64
JROOT/plugins/system/sef/sef.php:49
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	c33_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Query Time: 0.57 ms After last query: 0.23 ms

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 c33_categories as c

  LEFT JOIN c33_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM c33_categories AS cat JOIN c33_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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=84 
  AND badcats.id is null

  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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	72	14.66	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	margainemod1.c.id	10	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	38	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	72	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/router.php:146

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:64

JROOT/plugins/system/sef/sef.php:49

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1027

JROOT/libraries/cms/application/site.php:749

JROOT/libraries/cms/application/site.php:231

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 1.54 ms After last query: 1.16 ms

Duplicate queries: #42 #43 #44 #45

SELECT id, home, template, s.params

  FROM c33_template_styles as s

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	11	10.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	margainemod1.s.template,const	1	4.54	Using index condition; Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/cms/application/site.php:486

JROOT/libraries/cms/application/site.php:165

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.49 ms After last query: 17.50 ms
```
SELECT a.rules

  FROM c33_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:248
JROOT/libraries/joomla/user/user.php:364
JROOT/components/com_content/models/article.php:55
JROOT/libraries/joomla/application/component/model.php:400
JROOT/components/com_content/models/article.php:75
JROOT/libraries/joomla/application/component/view.php:386
JROOT/components/com_content/views/article/view.html.php:44
JROOT/libraries/joomla/application/component/controller.php:722
JROOT/components/com_content/controller.php:79
JROOT/libraries/joomla/application/component/controller.php:761
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

Query Time: 0.47 ms After last query: 1.53 ms

SELECT b.rules

  FROM c33_assets AS a

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

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	NULL	range	idx_lft_rgt	idx_lft_rgt	4	NULL	13	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/joomla/access/access.php:248

JROOT/libraries/joomla/access/access.php:109

JROOT/libraries/joomla/user/user.php:373

JROOT/components/com_content/models/article.php:55

JROOT/libraries/joomla/application/component/model.php:400

JROOT/components/com_content/models/article.php:75

JROOT/libraries/joomla/application/component/view.php:386

JROOT/components/com_content/views/article/view.html.php:44

JROOT/libraries/joomla/application/component/controller.php:722

JROOT/components/com_content/controller.php:79

JROOT/libraries/joomla/application/component/controller.php:761

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 3.66 ms After last query: 1.12 ms

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 c33_content AS a

  LEFT JOIN c33_categories AS c 
  on c.id = a.catid

  LEFT JOIN c33_users AS u 
  on u.id = a.created_by

  LEFT JOIN c33_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN c33_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM c33_categories AS cat JOIN c33_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.language in ('en-GB','*') 
  AND a.id = 254 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-07 02:16:18') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-07 02:16:18') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	const	PRIMARY,idx_state,idx_language	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	9	100.00	Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	37	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	72	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/components/com_content/models/article.php:158

JROOT/libraries/joomla/application/component/view.php:386

JROOT/components/com_content/views/article/view.html.php:44

JROOT/libraries/joomla/application/component/controller.php:722

JROOT/components/com_content/controller.php:79

JROOT/libraries/joomla/application/component/controller.php:761

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.90 ms After last query: 6.84 ms
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM c33_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_tags'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c33_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 10.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/helper/tags.php:392
JROOT/components/com_content/views/article/view.html.php:155
JROOT/libraries/joomla/application/component/controller.php:722
JROOT/components/com_content/controller.php:79
JROOT/libraries/joomla/application/component/controller.php:761
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Query Time: 1.11 ms After last query: 0.22 ms

SELECT `m`.`tag_id`,`t`.*

  FROM `c33_contentitem_tag_map` AS m 

  INNER JOIN `c33_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 254 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	margainemod1.m.tag_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/libraries/cms/helper/tags.php:412

JROOT/components/com_content/views/article/view.html.php:155

JROOT/libraries/joomla/application/component/controller.php:722

JROOT/components/com_content/controller.php:79

JROOT/libraries/joomla/application/component/controller.php:761

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 1.50 ms After last query: 21.42 ms

SHOW FULL COLUMNS 
  FROM `c33_content`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `c33_content`

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.2 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.2 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:237

JROOT/libraries/joomla/table/table.php:158

JROOT/libraries/legacy/table/content.php:31

JROOT/libraries/joomla/table/table.php:301

JROOT/components/com_content/models/article.php:263

JROOT/components/com_content/views/article/view.html.php:176

JROOT/libraries/joomla/application/component/controller.php:722

JROOT/components/com_content/controller.php:79

JROOT/libraries/joomla/application/component/controller.php:761

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.84 ms After last query: 4.21 ms

SELECT *

  FROM c33_content

  WHERE `id` = '254'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:723

JROOT/components/com_content/models/article.php:264

JROOT/components/com_content/views/article/view.html.php:176

JROOT/libraries/joomla/application/component/controller.php:722

JROOT/components/com_content/controller.php:79

JROOT/libraries/joomla/application/component/controller.php:761

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 1.76 ms After last query: 0.28 ms

UPDATE c33_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '254'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	c33_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.1 ms
updating	0.1 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.0 ms
query end	1.1 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:1233

JROOT/components/com_content/models/article.php:265

JROOT/components/com_content/views/article/view.html.php:176

JROOT/libraries/joomla/application/component/controller.php:722

JROOT/components/com_content/controller.php:79

JROOT/libraries/joomla/application/component/controller.php:761

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.57 ms After last query: 45.40 ms

Duplicate queries: #33 #43 #44 #45

SELECT id, home, template, s.params

  FROM c33_template_styles as s

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	11	10.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	margainemod1.s.template,const	1	4.54	Using index condition; Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/gantry/core/gantrytemplate.class.php:638

JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:65

JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36

JROOT/libraries/gantry/core/gantry.class.php:1843

JROOT/libraries/gantry/core/gantry.class.php:392

JROOT/libraries/gantry/gantry.php:275

JROOT/libraries/gantry/gantry.php:432

JROOT/templates/rt_momentum/html/com_content/article/default.php:14

JROOT/libraries/joomla/application/component/view.php:647

JROOT/libraries/joomla/application/component/view.php:205

JROOT/components/com_content/views/article/view.html.php:184

JROOT/libraries/joomla/application/component/controller.php:722

JROOT/components/com_content/controller.php:79

JROOT/libraries/joomla/application/component/controller.php:761

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.54 ms After last query: 3.02 ms

Duplicate queries: #33 #42 #44 #45

SELECT id, home, template, s.params

  FROM c33_template_styles as s

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	11	10.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	margainemod1.s.template,const	1	4.54	Using index condition; Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/gantry/core/gantrytemplate.class.php:638

JROOT/libraries/gantry/core/gantrytemplate.class.php:590

JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69

JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36

JROOT/libraries/gantry/core/gantry.class.php:1843

JROOT/libraries/gantry/core/gantry.class.php:392

JROOT/libraries/gantry/gantry.php:275

JROOT/libraries/gantry/gantry.php:432

JROOT/templates/rt_momentum/html/com_content/article/default.php:14

JROOT/libraries/joomla/application/component/view.php:647

JROOT/libraries/joomla/application/component/view.php:205

JROOT/components/com_content/views/article/view.html.php:184

JROOT/libraries/joomla/application/component/controller.php:722

JROOT/components/com_content/controller.php:79

JROOT/libraries/joomla/application/component/controller.php:761

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.50 ms After last query: 1.96 ms

Duplicate queries: #33 #42 #43 #45

SELECT id, home, template, s.params

  FROM c33_template_styles as s

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	11	10.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	margainemod1.s.template,const	1	4.54	Using index condition; Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/gantry/core/gantrytemplate.class.php:638

JROOT/libraries/gantry/core/gantrytemplate.class.php:590

JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69

JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36

JROOT/libraries/gantry/core/gantry.class.php:1843

JROOT/libraries/gantry/core/gantry.class.php:392

JROOT/libraries/gantry/gantry.php:275

JROOT/libraries/gantry/gantry.php:432

JROOT/templates/rt_momentum/html/com_content/article/default.php:14

JROOT/libraries/joomla/application/component/view.php:647

JROOT/libraries/joomla/application/component/view.php:205

JROOT/components/com_content/views/article/view.html.php:184

JROOT/libraries/joomla/application/component/controller.php:722

JROOT/components/com_content/controller.php:79

JROOT/libraries/joomla/application/component/controller.php:761

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 0.64 ms After last query: 1.71 ms

Duplicate queries: #33 #42 #43 #44

SELECT id, home, template, s.params

  FROM c33_template_styles as s

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	11	10.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	margainemod1.s.template,const	1	4.54	Using index condition; Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.1 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/gantry/core/gantrytemplate.class.php:638

JROOT/libraries/gantry/core/gantrytemplate.class.php:590

JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69

JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36

JROOT/libraries/gantry/core/gantry.class.php:1843

JROOT/libraries/gantry/core/gantry.class.php:392

JROOT/libraries/gantry/gantry.php:275

JROOT/libraries/gantry/gantry.php:432

JROOT/templates/rt_momentum/html/com_content/article/default.php:14

JROOT/libraries/joomla/application/component/view.php:647

JROOT/libraries/joomla/application/component/view.php:205

JROOT/components/com_content/views/article/view.html.php:184

JROOT/libraries/joomla/application/component/controller.php:722

JROOT/components/com_content/controller.php:79

JROOT/libraries/joomla/application/component/controller.php:761

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:237

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Query Time: 3.58 ms After last query: 68.90 ms

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

  FROM c33_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-06-07 02:16:18') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-07 02:16:18') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 293 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	51	0.98	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	margainemod1.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	margainemod1.m.id	3	40.00	Using where; Using index

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.3 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	1.1 ms
init	0.2 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
System lock	0.2 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.5 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.1 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.4 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/module/helper.php:376

JROOT/libraries/cms/module/helper.php:84

JROOT/libraries/joomla/document/html/html.php:497

JROOT/libraries/gantry/core/gantry.class.php:804

JROOT/libraries/gantry/core/gantry.class.php:757

JROOT/templates/rt_momentum/index.php:57

JROOT/libraries/joomla/document/html/html.php:576

JROOT/libraries/joomla/document/html/html.php:634

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:974

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.47 ms After last query: 29.77 ms

SELECT ts.template

  FROM c33_template_styles AS ts

  INNER JOIN c33_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 293 
  AND m.template_style_id != 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:98

JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:71

JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:22

JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/templates/rt_momentum/features/splitmenu.php:84

JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:65

JROOT/libraries/gantry/core/gantry.class.php:867

JROOT/templates/rt_momentum/index.php:107

JROOT/libraries/joomla/document/html/html.php:576

JROOT/libraries/joomla/document/html/html.php:634

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:974

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.35 ms After last query: 0.08 ms

SELECT template

  FROM c33_template_styles

  WHERE home = 1 
  AND client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_template_styles	NULL	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	11	9.09	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:113

JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:71

JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:22

JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/templates/rt_momentum/features/splitmenu.php:84

JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:65

JROOT/libraries/gantry/core/gantry.class.php:867

JROOT/templates/rt_momentum/index.php:107

JROOT/libraries/joomla/document/html/html.php:576

JROOT/libraries/joomla/document/html/html.php:634

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:974

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 1.66 ms After last query: 65.90 ms

SHOW FULL COLUMNS 
  FROM `c33_template_styles`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `c33_template_styles`

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.3 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.4 ms
checking permissions	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.1 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:237

JROOT/libraries/joomla/table/table.php:158

JROOT/administrator/components/com_templates/tables/style.php:30

JROOT/libraries/joomla/table/table.php:301

JROOT/plugins/system/gantry/gantry.php:194

JROOT/plugins/system/gantry/gantry.php:165

JROOT/plugins/system/gantry/gantry.php:234

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/joomla/document/html/renderer/head.php:59

JROOT/libraries/joomla/document/html/renderer/head.php:36

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.45 ms After last query: 0.20 ms

SELECT *

  FROM c33_template_styles

  WHERE `id` = '12'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c33_template_styles	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:723

JROOT/plugins/system/gantry/gantry.php:168

JROOT/plugins/system/gantry/gantry.php:234

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/joomla/document/html/renderer/head.php:59

JROOT/libraries/joomla/document/html/renderer/head.php:36

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:696

JROOT/libraries/joomla/document/html/html.php:474

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.32 ms After last query: 0.44 ms

SELECT b.rules

  FROM c33_assets AS a

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

  WHERE (a.name = 'com_categories')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	NULL	ALL	idx_lft_rgt	NO INDEX KEY COULD BE USED	NULL	NULL	496	100.00	Using where

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/access/access.php:248

JROOT/libraries/joomla/access/access.php:109

JROOT/libraries/joomla/user/user.php:373

JROOT/plugins/system/aclmanager/aclmanager.php:132

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:994

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

Query Time: 0.65 ms After last query: 1.90 ms

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 c33_categories as c

  LEFT JOIN c33_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM c33_categories AS cat JOIN c33_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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=78 
  AND badcats.id is null

  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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	72	14.66	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	margainemod1.c.id	10	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	38	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	72	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.0 ms
checking privileges on cached	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
sending cached result to clien	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/router.php:146

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:64

JROOT/plugins/system/sef/sef.php:160

JROOT/plugins/system/sef/sef.php:76

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:994

JROOT/libraries/cms/application/site.php:731

JROOT/libraries/cms/application/cms.php:257

JROOT/index.php:40

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

36 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

6 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM c33_extensions

5 × SELECT id, home, template, s.params 
  FROM c33_template_styles as s 
  LEFT JOIN c33_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

3 × 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 c33_categories as c 
  LEFT JOIN c33_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM c33_categories AS cat JOIN c33_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

2 × SELECT `extension_id` 
  FROM `c33_extensions`

2 × SELECT `alias`,`catid` 
  FROM `c33_content`

2 × SELECT template 
  FROM c33_template_styles as s

2 × SELECT b.rules 
  FROM c33_assets AS a 
  LEFT JOIN c33_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

```
2 × SELECT * 
  FROM c33_extensions
```

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 c33_content AS a 
  LEFT JOIN c33_categories AS c 
  on c.id = a.catid 
  LEFT JOIN c33_users AS u 
  on u.id = a.created_by 
  LEFT JOIN c33_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN c33_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM c33_categories AS cat JOIN c33_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT b.id 
  FROM c33_usergroups AS a 
  LEFT JOIN c33_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT a.rules 
  FROM c33_assets AS a

1 × SELECT id, rules 
  FROM `c33_viewlevels

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `c33_contentitem_tag_map` AS m  
  INNER JOIN `c33_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

```
1 × SELECT * 
  FROM c33_content
```

1 × SELECT * 
  FROM c33_template_styles

1 × SELECT template 
  FROM c33_template_styles

1 × SELECT ts.template 
  FROM c33_template_styles AS ts 
  INNER JOIN c33_menu AS m 
  ON ts.id=m.template_style_id

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

```
1 × SELECT alias 
  FROM c33_content
```

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

1 × SELECT `source`,`keepurlparams` 
  FROM `c33_admintools_redirects`

1 × SELECT * 
  FROM `c33_admintools_ipautoban`

1 × SELECT extension, file, type 
  FROM c33_rokcommon_configs

1 × SELECT `query` 
  FROM `c33_admintools_wafexceptions`

1 × SELECT COUNT(*) 
  FROM `c33_menu`

1 × SELECT `session_id` 
  FROM `c33_session`

```
1 × SELECT * 
  FROM c33_languages
```

1 × SELECT `params` 
  FROM c33_extensions

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM c33_menu AS m 
  LEFT JOIN c33_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `value` 
  FROM `c33_admintools_storage`

OTHER Tables:

1 × UPDATE c33_content 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `c33_template_styles

1 × SHOW FULL COLUMNS 
  FROM `c33_content

1 × UPDATE `c33_extensions` 
  SET `params` = '{\"mediaversion\":\"0e5427850b433b6c18da9347f647da25\"}'

1 × SHOW FULL COLUMNS 
  FROM `c33_extensions

1 × INSERT INTO `c33_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('2ef6f424580afb94f8fbc0121b1e56d3', 0, '1686104178'

Live Free or Die: The Dallas Opera's Carmen Seduces to the End

Famille Menu

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

52 Queries Logged 50.5 ms

11 duplicate found!

36 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: