Clementine margaine, mezzo soprano

Don Quichotte, Chicago

Lyric Opera's Don Quichotte simultaneously manages to retain the best features of San Diego Opera's production while improving on them considerably, especially in the casting of Clémentine Margaine as Dulcinea. Her ravishing performance easily holds its own alongside Furlanetto's Don Quixote, and imparts fresh insights into her character's shortcomings.

Next outcommings :

28 november, 1, 4 and 7 december 2016.

Newsflash

Clementine Margaine au MET

Clementine Margaine

Les 3, 7, 11, 15 et 18 fevrier 2016.

Two French mezzo-sopranos, Sophie Koch and Clémentine Margaine, alternate as Bizet's immortal heroine. Tenor Marcelo Álvarez is her hapless soldier Don José, and newcomer Maria Agresta—a sensation in her debut in La Bohème in the current Met season—is the devoted Micaëla, who fights to save him. Dan Ettinger and Louis Langrée share conducting duties.

Carmen au MET

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries

44 Queries Logged 61.9 ms

6 duplicate found!

2 duplicates: #12 #13

2 duplicates: #19 #21

2 duplicates: #28 #35

Query Time: 0.75 ms
```
SELECT `session_id`

  FROM `c33_session`

  WHERE `session_id` = '5f0b5bfadca7e7be0f863ddddafa1ae2' 
  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.01 ms After last query: 0.11 ms
```
INSERT INTO `c33_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('5f0b5bfadca7e7be0f863ddddafa1ae2', 0, '1696387626')
```
Explain
EXPLAIN not possible on query: INSERT INTO `c33_session` (`session_id`, `client_id`, `time`) VALUES ('5f0b5bfadca7e7be0f863ddddafa1ae2', 0, '1696387626')
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: 1.33 ms After last query: 8.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

Query Time: 0.54 ms After last query: 2.32 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.55 ms After last query: 0.53 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.54 ms After last query: 0.15 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.48 ms After last query: 11.30 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.75 ms After last query: 0.19 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.47 ms After last query: 0.38 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.55 ms After last query: 37.81 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.46 ms After last query: 2.74 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: 2.33 ms After last query: 64.55 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.37 ms After last query: 0.15 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.51 ms After last query: 15.02 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.48 ms After last query: 32.88 ms
```
SELECT *

  FROM `c33_admintools_ipautoban`

  WHERE `ip` = '18.206.194.21'
```
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: 1.14 ms After last query: 0.21 ms
```
SELECT `source`,`keepurlparams`

  FROM `c33_admintools_redirects`

  WHERE ((`dest` = 'en/') OR (`dest` = 'en/') OR ('en/' 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: 1.41 ms After last query: 46.94 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.98 ms After last query: 3.20 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.95 ms After last query: 0.24 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.84 ms After last query: 0.24 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.52 ms After last query: 0.23 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_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	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	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Query Time: 6.04 ms After last query: 302.17 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.20 ms After last query: 29.66 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: 1.10 ms After last query: 40.50 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.75 ms After last query: 1.11 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.80 ms After last query: 0.20 ms
```
UPDATE `c33_extensions`

  SET `params` = '{\"mediaversion\":\"6a264c7b4a93fb7ffc22ea887a761efa\"}'

  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.93 ms After last query: 3.31 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/libraries/cms/application/site.php:328
JROOT/libraries/cms/application/site.php:135
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	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

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: 1.78 ms After last query: 0.57 ms

Duplicate queries: #35

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.59 ms After last query: 112.35 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/articles.php:107
JROOT/components/com_content/models/featured.php:39
JROOT/libraries/joomla/application/component/model.php:400
JROOT/libraries/joomla/application/component/view.php:386
JROOT/components/com_content/views/featured/view.html.php:48
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.53 ms After last query: 1.61 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/articles.php:107

JROOT/components/com_content/models/featured.php:39

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

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

JROOT/components/com_content/views/featured/view.html.php:48

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: 6.90 ms After last query: 7.80 ms

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM c33_content AS a

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

  LEFT JOIN c33_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN c33_users AS uam 
  ON uam.id = a.modified_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 != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  INNER JOIN c33_content_frontpage AS fp 
  ON fp.content_id = a.id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-04 02:47:07') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-04 02:47:07') 
  AND a.language in ('en-GB','*')

  ORDER BY  a.featured DESC, fp.ordering,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created DESC   
  LIMIT 0, 35

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	fp	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	16	100.00	Using temporary; Using filesort
1	PRIMARY	a	NULL	eq_ref	PRIMARY,idx_access,idx_catid,idx_language	PRIMARY	4	margainemod1.fp.content_id	1	16.00	Using where
1	PRIMARY	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	margainemod1.a.catid	1	88.89	Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	margainemod1.a.created_by	1	100.00	Using where
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	margainemod1.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	margainemod1.c.parent_id	1	100.00	Using where
1	PRIMARY	v	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	margainemod1.c.id	10	100.00	Using where; 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.5 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
Opening tables	2.0 ms
init	0.2 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
System lock	0.1 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.2 ms
preparing	0.1 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.5 ms
executing	0.0 ms
Sending data	1.0 ms
Creating sort index	0.4 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.1 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.1 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
freeing items	0.2 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/application/component/model.php:301

JROOT/libraries/legacy/model/list.php:171

JROOT/components/com_content/models/articles.php:537

JROOT/components/com_content/models/featured.php:84

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

JROOT/components/com_content/views/featured/view.html.php:49

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.09 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

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.2 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.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/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/models/articles.php:663

JROOT/components/com_content/models/featured.php:84

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

JROOT/components/com_content/views/featured/view.html.php:49

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: 0.19 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` = 339 
  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

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/cms/helper/tags.php:412

JROOT/components/com_content/models/articles.php:663

JROOT/components/com_content/models/featured.php:84

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

JROOT/components/com_content/views/featured/view.html.php:49

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: 2.92 ms After last query: 2.59 ms

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM c33_content AS a

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

  LEFT JOIN c33_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN c33_users AS uam 
  ON uam.id = a.modified_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 != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  INNER JOIN c33_content_frontpage AS fp 
  ON fp.content_id = a.id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-04 02:47:07') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-04 02:47:07') 
  AND a.language in ('en-GB','*')

  ORDER BY  a.featured DESC, fp.ordering,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	fp	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	16	100.00	Using temporary; Using filesort
1	PRIMARY	a	NULL	eq_ref	PRIMARY,idx_access,idx_catid,idx_language	PRIMARY	4	margainemod1.fp.content_id	1	16.00	Using where
1	PRIMARY	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	margainemod1.a.catid	1	88.89	Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	margainemod1.a.created_by	1	100.00	Using where
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	margainemod1.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	margainemod1.c.parent_id	1	100.00	Using where
1	PRIMARY	v	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	margainemod1.c.id	10	100.00	Using where; 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.2 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
Opening tables	0.3 ms
init	0.1 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.1 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.3 ms
executing	0.0 ms
Sending data	0.5 ms
Creating sort index	0.2 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
removing tmp table	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
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/application/component/model.php:318

JROOT/libraries/legacy/model/list.php:276

JROOT/libraries/legacy/model/list.php:221

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

JROOT/components/com_content/views/featured/view.html.php:50

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.65 ms After last query: 144.08 ms

Duplicate queries: #28

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.1 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/featured/default.php:14

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

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

JROOT/components/com_content/views/featured/view.html.php:150

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: 4.11 ms After last query: 124.39 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-10-04 02:47:07') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-10-04 02:47:07') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 178 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.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.9 ms
init	0.1 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.2 ms
preparing	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	1.0 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.2 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.3 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.1 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/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: 1.32 ms After last query: 31.10 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 = 178 
  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.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.5 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
executing	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.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.39 ms After last query: 0.12 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: 6.12 ms After last query: 241.51 ms

SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM c33_content AS a

  LEFT JOIN c33_content_frontpage AS fp 
  ON fp.content_id = a.id

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

  LEFT JOIN c33_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN c33_users AS uam 
  ON uam.id = a.modified_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 != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (80) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-04 02:47:07') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-04 02:47:07') 
  AND a.language in ('en-GB','*')

  ORDER BY rand()  
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	a	NULL	ref	idx_access,idx_catid,idx_language	idx_catid	4	const	28	16.00	Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	margainemod1.a.created_by	1	100.00	Using where
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	margainemod1.a.modified_by	1	100.00	Using where; Using index
1	PRIMARY	fp	NULL	eq_ref	PRIMARY	PRIMARY	4	margainemod1.a.id	1	100.00	Using where; Using index
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	PRIMARY	v	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	10	100.00	Using where; 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.4 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
Opening tables	1.2 ms
init	0.3 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.1 ms
statistics	0.2 ms
preparing	0.1 ms
Creating tmp table	0.2 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.7 ms
executing	0.0 ms
Sending data	0.9 ms
Creating sort index	0.5 ms
Creating sort index	0.3 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.1 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.1 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

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

JROOT/libraries/legacy/model/list.php:171

JROOT/components/com_content/models/articles.php:537

JROOT/modules/mod_articles_news/helper.php:82

JROOT/modules/mod_articles_news/mod_articles_news.php:15

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

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

JROOT/libraries/joomla/document/html/renderer/modules.php:46

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.63 ms After last query: 0.51 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` = 347 
  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

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/cms/helper/tags.php:412

JROOT/components/com_content/models/articles.php:663

JROOT/modules/mod_articles_news/helper.php:82

JROOT/modules/mod_articles_news/mod_articles_news.php:15

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

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

JROOT/libraries/joomla/document/html/renderer/modules.php:46

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: 2.73 ms After last query: 1.96 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=80 
  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.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.1 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.2 ms
preparing	0.0 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.6 ms
Creating sort index	0.4 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
removing tmp table	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
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/legacy/categories/categories.php:288

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

JROOT/components/com_content/helpers/route.php:41

JROOT/modules/mod_articles_news/helper.php:93

JROOT/modules/mod_articles_news/mod_articles_news.php:15

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

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

JROOT/libraries/joomla/document/html/renderer/modules.php:46

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: 1.29 ms After last query: 103.52 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.2 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.2 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.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: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.52 ms After last query: 0.30 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.38 ms After last query: 0.71 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.1 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]

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

2 × 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

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

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 a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM c33_content AS a 
  LEFT JOIN c33_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN c33_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN c33_users AS uam 
  ON uam.id = a.modified_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

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

2 × SELECT template 
  FROM c33_template_styles as s

2 × SELECT `extension_id` 
  FROM `c33_extensions`

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

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

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 template 
  FROM c33_template_styles

1 × SELECT * 
  FROM c33_template_styles

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 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

1 × SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM c33_content AS a 
  LEFT JOIN c33_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN c33_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN c33_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN c33_users AS uam 
  ON uam.id = a.modified_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 a.rules 
  FROM c33_assets AS a

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

1 × SELECT * 
  FROM `c33_admintools_ipautoban`

1 × SELECT extension, file, type 
  FROM c33_rokcommon_configs

1 × SELECT `query` 
  FROM `c33_admintools_wafexceptions`

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

1 × SELECT `session_id` 
  FROM `c33_session`

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 COUNT(*) 
  FROM `c33_menu`

1 × SELECT `value` 
  FROM `c33_admintools_storage`

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `c33_template_styles

1 × UPDATE `c33_extensions` 
  SET `params` = '{\"mediaversion\":\"6a264c7b4a93fb7ffc22ea887a761efa\"}'

1 × SHOW FULL COLUMNS 
  FROM `c33_extensions

1 × INSERT INTO `c33_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('5f0b5bfadca7e7be0f863ddddafa1ae2', 0, '1696387626'

Clementine margaine, mezzo soprano

Don Quichotte, Chicago

Newsflash

Clementine Margaine au MET

Clementine Margaine

Les 3, 7, 11, 15 et 18 fevrier 2016.

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

44 Queries Logged 61.9 ms

6 duplicate found!

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: