Clementine margaine, mezzo soprano

	Compositeur	Oeuvre
	Bach	Passion selon St Jean/ selon St Mathieu
	Bizet	Les adieux de l'hôtesse arabe*
	Debussy	Chansons de Bilitis*
	De Falla	Siete canciones populares espagnolas*
	Dvorak	Stabat Mater
	Granados	Tres Maja dolorosa*
	Haendel	The Messiah
	Haydn	Stabat Mater
	Mahler	Lieder eines fahrenden Gesellen*
	Mahler	Kindertotenlieder*
	Mendelssohn	Elias*
	Moussorgsky	Chants et danses de la mort
	Montsalvage	Cincos canciones negras*
	Mozart	Requiem
	Pergolese	Stabat Mater
	Ravel	Shéhérazade*
	Rossini	Stabat Mater/ Petite Messe solennelle
	Saint Saens	Oratorio de Noel
	Schumann	Der Rose Pilgefärtt
	Verdi	Requiem*
	Wagner	Wesendonck Lieder
	Wolf	Möricke Lieder

Les oeuvres marquées d'une * ont été chantées sur scène.

Opéras-opérettes

Compositeur	Oeuvre	Role
Berlioz	Damnation de Faust	Marguerite
Berlioz	Les Troyens	Anna*
Bizet	Carmen	Carmen* / Mercedes
Campra	Europe galante	La Discorde/ Roxanne
Debussy	Pelléas et Mélisande	Geneviève*
Donizetti	La favorite	Leonora
Glück	Orfeo ed Euridice	Orfeo*
Gounod	Faust	Siebel / Dame Marthe*
Haendel	Giulio Cesare	Sesto
Haendel	Alcina	Ruggiero / Bradamante*
Massenet	Don quichotte	Dulcinée
Massenet	Werther	Charlotte
Monteverdi	Incoronazione di Poppea	Ottavia
Mozart	La Clemenza di Tito	Annio
	Cosi fan tutte	Dorabella
	Die Zauberflöte	Dritte Dame
Offenbach	La grande duchesse de Gerolstein	La grande duchesse
Offenbach	Orphée aux enfers	L'opinion publique*
Purcell	Dido et Aeneas	Dido
Saint Saens	Samson et Dalila	Dalila*
Tchaikovsky	Eugène Oneguine	Olga / Mme Larina
Tchaikovsky	La dame de pique	Pauline
Verdi	La Traviata	Flora

Les rôles marqués d'une * ont été chantés sur scène.

Oratorio-Concert

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries

47 Queries Logged 56.1 ms

9 duplicate found!

2 duplicates: #13 #14

2 duplicates: #20 #22

3 duplicates: #29 #40 #41

2 duplicates: #34 #38

Query Time: 1.06 ms
```
DELETE 

  FROM `c33_session`

  WHERE `time` < '1686099899'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 DELETE c33_session NULL range time time 45 const 1 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:685
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.72 ms After last query: 0.12 ms
```
SELECT `session_id`

  FROM `c33_session`

  WHERE `session_id` = 'a11b7b0bf70040bfcdbcc967777641f2' 
  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: 2.15 ms After last query: 0.10 ms
```
INSERT INTO `c33_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('a11b7b0bf70040bfcdbcc967777641f2', 0, '1686100799')
```
Explain
EXPLAIN not possible on query: INSERT INTO `c33_session` (`session_id`, `client_id`, `time`) VALUES ('a11b7b0bf70040bfcdbcc967777641f2', 0, '1686100799')
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.29 ms After last query: 6.30 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	DELETE	c33_session	NULL	range	time	time	45	const	1	100.00	Using where

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.62 ms After last query: 2.06 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.47 ms After last query: 0.49 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.39 ms After last query: 0.16 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.69 ms After last query: 13.88 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: 1.03 ms After last query: 0.27 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.56 ms After last query: 0.52 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.49 ms After last query: 26.92 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.54 ms After last query: 1.62 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.59 ms After last query: 40.40 ms
Duplicate queries: #14
```
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.47 ms After last query: 0.14 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: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.46 ms After last query: 10.39 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.66 ms After last query: 22.96 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: 1.07 ms After last query: 0.21 ms
```
SELECT `source`,`keepurlparams`

  FROM `c33_admintools_redirects`

  WHERE ((`dest` = 'en/repertoire') OR (`dest` = 'en/repertoire') OR ('en/repertoire' 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.46 ms After last query: 10.68 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.95 ms After last query: 2.06 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.94 ms After last query: 0.14 ms
Duplicate queries: #22
```
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.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.66 ms After last query: 0.12 ms
Duplicate queries: #20
```
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	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

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

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	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

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

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: 3.02 ms After last query: 254.67 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.12 ms After last query: 18.68 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.90 ms After last query: 15.22 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.90 ms After last query: 1.04 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: 2.22 ms After last query: 0.19 ms
```
UPDATE `c33_extensions`

  SET `params` = '{\"mediaversion\":\"8e1ecf6867971592e5ba634fd7e5f4e5\"}'

  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: 1.07 ms After last query: 5.32 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:37
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	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.72 ms After last query: 0.75 ms

Duplicate queries: #40 #41

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.50 ms After last query: 16.15 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/category.php:137
JROOT/libraries/joomla/application/component/model.php:400
JROOT/libraries/joomla/application/component/view.php:386
JROOT/libraries/legacy/view/category.php:107
JROOT/components/com_content/views/category/view.html.php:72
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.57 ms After last query: 1.20 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.category.74')

  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	21	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/category.php:137

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

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

JROOT/libraries/legacy/view/category.php:107

JROOT/components/com_content/views/category/view.html.php:72

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: 5.23 ms After last query: 8.13 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,COUNT(i.`id`) AS numitems

  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

  LEFT JOIN `c33_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=74 
  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
1	PRIMARY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	margainemod1.c.id	6	100.00	Using where
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/models/category.php:336

JROOT/components/com_content/models/category.php:224

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.46 ms After last query: 2.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_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:449

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

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

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

JROOT/components/com_content/models/category.php:244

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.09 ms After last query: 0.43 ms

Duplicate queries: #38

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_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 = 74 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-07 01:19:59') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-07 01:19:59') 
  AND a.language in ('en-GB','*')

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

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 filesort
1	PRIMARY	a	NULL	ref	idx_access,idx_catid,idx_language	idx_catid	4	const	3	16.00	Using index condition; 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	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	eq_ref	PRIMARY	PRIMARY	4	margainemod1.a.id	1	100.00	Using where
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.3 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.9 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
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.2 ms
executing	0.0 ms
Sending data	0.7 ms
Creating sort index	0.1 ms
Waiting for query cache lock	0.0 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
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.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/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/category.php:244

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.75 ms After last query: 3.05 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.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/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/category.php:244

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.24 ms After last query: 0.16 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` = 124 
  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.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
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/cms/helper/tags.php:412

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

JROOT/components/com_content/models/category.php:244

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.85 ms After last query: 0.38 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` = 121 
  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.1 ms
checking permissions	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/cms/helper/tags.php:412

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

JROOT/components/com_content/models/category.php:244

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.77 ms After last query: 1.90 ms

Duplicate queries: #34

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_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 = 74 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-06-07 01:19:59') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-06-07 01:19:59') 
  AND a.language in ('en-GB','*')

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

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 filesort
1	PRIMARY	a	NULL	ref	idx_access,idx_catid,idx_language	idx_catid	4	const	3	16.00	Using index condition; 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	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	eq_ref	PRIMARY	PRIMARY	4	margainemod1.a.id	1	100.00	Using where
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.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
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 cached result to clien	0.1 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/components/com_content/models/category.php:256

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

JROOT/libraries/legacy/view/category.php:108

JROOT/components/com_content/views/category/view.html.php:72

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.89 ms After last query: 0.33 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.category' 
  AND `m`.`content_item_id` = 74 
  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.1 ms
checking permissions	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/cms/helper/tags.php:412

JROOT/libraries/legacy/view/category.php:179

JROOT/components/com_content/views/category/view.html.php:72

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.59 ms After last query: 58.01 ms

Duplicate queries: #29 #41

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/category/blog.php:14

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

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

JROOT/libraries/legacy/view/category.php:195

JROOT/components/com_content/views/category/view.html.php:260

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.68 ms After last query: 1.86 ms

Duplicate queries: #29 #40

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/category/blog.php:14

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

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

JROOT/libraries/legacy/view/category.php:195

JROOT/components/com_content/views/category/view.html.php:260

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: 16.32 ms

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

  FROM c33_extensions

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

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.1 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.1 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/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/gantry/overrides/3.3/2.5/com_content/category/blog.php:18

JROOT/templates/rt_momentum/html/base_override.php:96

JROOT/templates/rt_momentum/html/com_content/category/blog.php:16

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

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

JROOT/libraries/legacy/view/category.php:195

JROOT/components/com_content/views/category/view.html.php:260

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.00 ms After last query: 54.94 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 01:19:59') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-06-07 01:19:59') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 99 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.1 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.7 ms
init	0.1 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
System lock	0.1 ms
optimizing	0.1 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.4 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.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: 1.17 ms After last query: 30.39 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 = 99 
  AND m.template_style_id != 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ts	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.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.4 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/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: 1.26 ms After last query: 81.93 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.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.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.19 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.59 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.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]

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

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

3 × 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 `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 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_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

2 × SELECT `extension_id` 
  FROM `c33_extensions`

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

2 × SELECT template 
  FROM c33_template_styles as s

1 × SELECT `params` 
  FROM c33_extensions

1 × SELECT a.rules 
  FROM c33_assets AS a

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems 
  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 * 
  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 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 `source`,`keepurlparams` 
  FROM `c33_admintools_redirects`

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

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

1 × SELECT id, rules 
  FROM `c33_viewlevels

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

1 × SELECT `query` 
  FROM `c33_admintools_wafexceptions`

1 × SELECT * 
  FROM `c33_admintools_ipautoban`

1 × SELECT extension, file, type 
  FROM c33_rokcommon_configs

1 × SELECT `value` 
  FROM `c33_admintools_storage`

1 × SELECT `session_id` 
  FROM `c33_session`

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `c33_template_styles

1 × UPDATE `c33_extensions` 
  SET `params` = '{\"mediaversion\":\"8e1ecf6867971592e5ba634fd7e5f4e5\"}'

1 × SHOW FULL COLUMNS 
  FROM `c33_extensions

1 × INSERT INTO `c33_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('a11b7b0bf70040bfcdbcc967777641f2', 0, '1686100799'

```
1 × DELETE  
  FROM `c33_session`
```

Clementine margaine, mezzo soprano

Compositeur

Oeuvre

Compositeur

Oeuvre

Role

Repertoire Menu

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

47 Queries Logged 56.1 ms

9 duplicate found!

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: