Friday, 22 January 2021, 01:06:37

Clothing

Joomla! Debug Console

Session

Profile Information

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.636 MB / 0.64 MB Application: afterLoad

Time: 49.8 ms / 49.8 ms Memory: 5.491 MB / 6.13 MB Application: afterInitialise

Time: 26.9 ms / 76.7 ms Memory: 2.263 MB / 8.39 MB Application: afterRoute

Time: 286.2 ms / 362.9 ms Memory: 10.789 MB / 19.18 MB Application: afterDispatch

Time: 37.5 ms / 400.4 ms Memory: 2.888 MB / 22.07 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 5.1 ms / 405.5 ms Memory: 0.161 MB / 22.23 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 1.2 ms / 406.7 ms Memory: 0.027 MB / 22.25 MB Application: beforeRenderModule mod_menu (Directory Menue Tree)

Time: 13.5 ms / 420.2 ms Memory: 0.143 MB / 22.40 MB Application: afterRenderModule mod_menu (Directory Menue Tree)

Time: 1.3 ms / 421.6 ms Memory: 0.000 MB / 22.39 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 2.5 ms / 424.1 ms Memory: 0.069 MB / 22.46 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.1 ms / 425.2 ms Memory: 0.000 MB / 22.45 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 4.5 ms / 429.6 ms Memory: 0.185 MB / 22.64 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.3 ms / 430.0 ms Memory: 0.000 MB / 22.61 MB Application: beforeRenderModule mod_search (search)

Time: 1.9 ms / 431.9 ms Memory: 0.036 MB / 22.65 MB Application: afterRenderModule mod_search (search)

Time: 0.2 ms / 432.1 ms Memory: 0.000 MB / 22.64 MB Application: beforeRenderModule mod_banners (Head Add Banner)

Time: 7.4 ms / 439.5 ms Memory: 0.404 MB / 23.04 MB Application: afterRenderModule mod_banners (Head Add Banner)

Time: 0.3 ms / 439.8 ms Memory: 0.013 MB / 23.06 MB Application: beforeRenderModule mod_date2 (Date2)

Time: 4.0 ms / 443.8 ms Memory: 0.312 MB / 23.37 MB Application: afterRenderModule mod_date2 (Date2)

Time: 0.1 ms / 443.9 ms Memory: 0.000 MB / 23.32 MB Application: beforeRenderModule mod_menu (Top Menue)

Time: 2.9 ms / 446.9 ms Memory: 0.049 MB / 23.37 MB Application: afterRenderModule mod_menu (Top Menue)

Time: 0.1 ms / 447.0 ms Memory: 0.000 MB / 23.36 MB Application: beforeRenderModule mod_menu (Social Media Buttons)

Time: 2.5 ms / 449.5 ms Memory: 0.053 MB / 23.41 MB Application: afterRenderModule mod_menu (Social Media Buttons)

Time: 41.3 ms / 490.8 ms Memory: 2.508 MB / 25.92 MB Application: afterRender

Database queries total: 94.4 ms

Memory Usage

Database Queries

193 Queries Logged 94.4 ms

123 duplicate found!

3 duplicates: #17 #30 #87

4 duplicates: #18 #54 #97 #138

7 duplicates: #37 #49 #79 #93 #122 #134 #163

7 duplicates: #38 #50 #80 #94 #123 #135 #164

7 duplicates: #39 #51 #81 #95 #124 #136 #165

2 duplicates: #46 #131

2 duplicates: #47 #132

4 duplicates: #48 #85 #133 #169

3 duplicates: #55 #98 #139

3 duplicates: #56 #99 #140

3 duplicates: #57 #100 #141

3 duplicates: #58 #101 #142

3 duplicates: #59 #102 #143

3 duplicates: #60 #103 #144

2 duplicates: #61 #62

3 duplicates: #63 #106 #147

3 duplicates: #64 #107 #148

3 duplicates: #65 #108 #149

3 duplicates: #66 #109 #150

3 duplicates: #67 #110 #151

3 duplicates: #68 #111 #152

3 duplicates: #69 #112 #153

3 duplicates: #70 #113 #154

3 duplicates: #71 #114 #155

3 duplicates: #72 #115 #156

3 duplicates: #73 #116 #157

3 duplicates: #74 #117 #158

3 duplicates: #75 #118 #159

3 duplicates: #76 #119 #160

2 duplicates: #77 #82

2 duplicates: #78 #83

2 duplicates: #84 #168

2 duplicates: #92 #128

2 duplicates: #104 #105

2 duplicates: #120 #125

2 duplicates: #121 #126

2 duplicates: #145 #146

2 duplicates: #161 #166

2 duplicates: #162 #167

2 duplicates: #181 #182

3 duplicates: #186 #187 #188

Query Time: 0.17 ms
```
SELECT `data`

  FROM `ovl_session`

  WHERE `session_id` = '45s8csgoovmi2uj49iafs144f4'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_session NULL const PRIMARY PRIMARY 602 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:46
JROOT/libraries/joomla/session/session.php:658
JROOT/libraries/joomla/session/session.php:596
JROOT/libraries/cms/application/cms.php:668
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:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.48 ms After last query: 1.43 ms
```
DELETE 

  FROM `ovl_session`

  WHERE `time` < '1611270397'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 DELETE ovl_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:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.22 ms After last query: 0.17 ms
```
SELECT `session_id`

  FROM `ovl_session`

  WHERE `session_id` = '45s8csgoovmi2uj49iafs144f4' 
  LIMIT 0, 1
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_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:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.27 ms After last query: 0.19 ms
```
INSERT INTO `ovl_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('45s8csgoovmi2uj49iafs144f4', 0, '1611273997')
```
Explain
EXPLAIN not possible on query: INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`) VALUES ('45s8csgoovmi2uj49iafs144f4', 0, '1611273997')
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:49
[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	ovl_session	NULL	const	PRIMARY	PRIMARY	602	const	1	100.00	NULL

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	ovl_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	ovl_session	NULL	const	PRIMARY	PRIMARY	602	const	1	100.00	Using index

Query Time: 0.35 ms After last query: 5.12 ms

SELECT b.id

  FROM ovl_usergroups AS a

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

  WHERE a.id = 9

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	2	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:52

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

Query Time: 0.21 ms After last query: 0.69 ms
```
SELECT id, rules

  FROM `ovl_viewlevels`
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 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:52
[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	ovl_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	NULL

Query Time: 1.10 ms After last query: 31.22 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 ovl_menu AS m

  LEFT JOIN ovl_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	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	202	5.99	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	db59gacpy8p5zb.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/libraries/cms/router/site.php:218

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

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

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

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

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

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

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

JROOT/index.php:52

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

Query Time: 0.58 ms After last query: 12.09 ms
```
UPDATE `ovl_extensions`

  SET `params` = '{\"mediaversion\":\"3474479146a67777282a83b6522153ec\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 UPDATE ovl_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/k2/k2.php:52
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.37 ms After last query: 35.53 ms
```
SELECT * 
  FROM ovl_sobipro_object 
  WHERE  ( id ='73' )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_object NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:887
JROOT/components/com_sobipro/lib/base/factory.php:181
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:195
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109
JROOT/components/com_sobipro/sobipro.php:53
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:52
[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.16 ms
```
SELECT pid 
  FROM ovl_sobipro_relations 
  WHERE  ( id ='73' )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_relations NULL ref PRIMARY PRIMARY 4 const 1 100.00 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:820
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:206
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109
JROOT/components/com_sobipro/sobipro.php:53
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.26 ms After last query: 0.20 ms
```
SELECT pid 
  FROM ovl_sobipro_relations 
  WHERE  ( id ='62' )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_relations NULL ref PRIMARY PRIMARY 4 const 1 100.00 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:820
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:206
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109
JROOT/components/com_sobipro/sobipro.php:53
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.20 ms After last query: 0.13 ms
```
SELECT pid 
  FROM ovl_sobipro_relations 
  WHERE  ( id ='59' )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_relations NULL ref PRIMARY PRIMARY 4 const 1 100.00 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:820
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:206
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109
JROOT/components/com_sobipro/sobipro.php:53
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.23 ms After last query: 0.16 ms
```
SELECT * 
  FROM ovl_sobipro_object 
  WHERE  ( id ='59' )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_object NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:887
JROOT/components/com_sobipro/lib/base/factory.php:181
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:217
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109
JROOT/components/com_sobipro/sobipro.php:53
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.97 ms After last query: 6.86 ms
```
SELECT cSection AS configsection,sKey AS sKey,sValue AS sValue 
  FROM ovl_sobipro_config 
  WHERE  ( section  IN ( '0','59' ) )   
  ORDER BY section,  configsection
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_config NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 82 20.00 Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:918
JROOT/components/com_sobipro/lib/base/config.php:177
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:178
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:115
JROOT/components/com_sobipro/sobipro.php:53
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.50 ms After last query: 4.20 ms
```
SELECT * 
  FROM ovl_sobipro_field 
  WHERE  ( fid ='35' )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_field NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:887
JROOT/components/com_sobipro/lib/models/field.php:368
JROOT/components/com_sobipro/lib/base/config.php:63
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:182
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:115
JROOT/components/com_sobipro/sobipro.php:53
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.54 ms After last query: 2.49 ms
```
SELECT pid 
  FROM ovl_sobipro_plugin_task 
  WHERE  ( onAction  IN ( '*','*' ) )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_plugin_task NULL index NULL pid 757 NULL 9 22.22 Using where; Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66
JROOT/components/com_sobipro/lib/plugins/interface.php:72
JROOT/components/com_sobipro/lib/plugins/interface.php:167
JROOT/components/com_sobipro/lib/sobi.php:228
JROOT/components/com_sobipro/lib/models/field.php:369
JROOT/components/com_sobipro/lib/base/config.php:63
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:182
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:115
JROOT/components/com_sobipro/sobipro.php:53
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.48 ms After last query: 0.20 ms
Duplicate queries: #30 #87
```
SELECT pid 
  FROM ovl_sobipro_plugin_section 
  WHERE  ( section ='59' )  
  AND  ( enabled ='1' )  
  AND  ( pid  IN ( 'promotedentries' ) )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_plugin_section NULL ref PRIMARY PRIMARY 156 const,const 1 33.33 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66
JROOT/components/com_sobipro/lib/plugins/interface.php:83
JROOT/components/com_sobipro/lib/plugins/interface.php:167
JROOT/components/com_sobipro/lib/sobi.php:228
JROOT/components/com_sobipro/lib/models/field.php:369
JROOT/components/com_sobipro/lib/base/config.php:63
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:182
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:115
JROOT/components/com_sobipro/sobipro.php:53
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 2.82 ms After last query: 7.09 ms
Duplicate queries: #54 #97 #138
```
SELECT sValue,sKey 
  FROM ovl_sobipro_language 
  WHERE  ( fid ='35' )  
  AND  ( sKey  IN ( 'name','description','suffix' ) )  
  AND  ( oType ='field' )   
  ORDER BY FIELD( language,  'en-GB',  '%' ) ASC
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_language NULL range PRIMARY,sKey sKey 452 NULL 115 1.00 Using index condition; Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84
JROOT/components/com_sobipro/lib/models/field.php:492
JROOT/components/com_sobipro/lib/models/field.php:389
JROOT/components/com_sobipro/lib/models/field.php:373
JROOT/components/com_sobipro/lib/base/config.php:63
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:182
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:115
JROOT/components/com_sobipro/sobipro.php:53
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.50 ms After last query: 4.33 ms
```
SELECT id AS id, sKey AS label, sValue AS value, language 
  FROM ovl_sobipro_language 
  WHERE  ( id ='59' )  
  AND  ( oType ='section' )  
  AND  ( sKey  IN ( 'name' ) )   
  ORDER BY FIELD( language,  'en-GB',  'en-GB' )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_language NULL ref PRIMARY,sKey sKey 452 const 31 1.00 Using index condition; Using where; Using filesort
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84
JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:690
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145
JROOT/components/com_sobipro/sobipro.php:53
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:52
[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	UPDATE	ovl_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	ovl_sobipro_object	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	ovl_sobipro_relations	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_sobipro_object	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	ovl_sobipro_config	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	82	20.00	Using where; Using filesort

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_sobipro_field	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	ovl_sobipro_plugin_task	NULL	index	NULL	pid	757	NULL	9	22.22	Using where; Using index

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_sobipro_plugin_section	NULL	ref	PRIMARY	PRIMARY	156	const,const	1	33.33	Using where

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_sobipro_language	NULL	range	PRIMARY,sKey	sKey	452	NULL	115	1.00	Using index condition; Using where; Using filesort

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_sobipro_language	NULL	ref	PRIMARY,sKey	sKey	452	const	31	1.00	Using index condition; Using where; Using filesort

Query Time: 0.97 ms After last query: 10.87 ms

SELECT rel.gid 
  FROM  ovl_sobipro_user_group AS grp 
  LEFT JOIN ovl_sobipro_users_relation AS rel 
  ON grp.gid =  rel.gid 
  WHERE ( ( rel.validUntil > '2021-01-22 00:06:37' OR rel.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) 
  AND ( rel.validSince < '2021-01-22 00:06:37' OR rel.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )   
  AND grp.enabled = 1  )  
  AND  ( uid ='0' )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	grp	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	rel	NULL	ref	PRIMARY	PRIMARY	8	const,db59gacpy8p5zb.grp.gid	1	100.00	Using where

Profile

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

Call Stack

JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66

JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:101

JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:44

JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:383

JROOT/components/com_sobipro/lib/base/factory.php:104

JROOT/components/com_sobipro/lib/sobi.php:434

JROOT/components/com_sobipro/lib/models/dbobject.php:214

JROOT/components/com_sobipro/lib/ctrl/controller.php:70

JROOT/components/com_sobipro/lib/ctrl/sobipro.php:464

JROOT/components/com_sobipro/lib/ctrl/sobipro.php:287

JROOT/components/com_sobipro/lib/ctrl/sobipro.php:156

JROOT/components/com_sobipro/sobipro.php:53

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

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

Query Time: 0.18 ms After last query: 0.13 ms
```
SELECT parent.id, parent.lft, parent.rgt

  FROM ovl_usergroups AS parent

  ORDER BY parent.lft
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE parent NULL index NULL idx_usergroup_nested_set_lookup 8 NULL 10 100.00 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:178
JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:221
JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:79
JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:46
JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:383
JROOT/components/com_sobipro/lib/base/factory.php:104
JROOT/components/com_sobipro/lib/sobi.php:434
JROOT/components/com_sobipro/lib/models/dbobject.php:214
JROOT/components/com_sobipro/lib/ctrl/controller.php:70
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:464
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:287
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:156
JROOT/components/com_sobipro/sobipro.php:53
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.43 ms After last query: 0.58 ms
```
SELECT * 
  FROM ovl_sobipro_category 
  WHERE  ( id ='73' )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_category NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:887
JROOT/components/com_sobipro/lib/models/dbobject.php:697
JROOT/components/com_sobipro/lib/models/category.php:162
JROOT/components/com_sobipro/lib/models/dbobject.php:644
JROOT/components/com_sobipro/lib/ctrl/controller.php:86
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:465
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:287
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:156
JROOT/components/com_sobipro/sobipro.php:53
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.32 ms After last query: 0.13 ms
```
SELECT counter 
  FROM ovl_sobipro_counter 
  WHERE  ( sid ='73' )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_counter NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:820
JROOT/components/com_sobipro/lib/models/dbobject.php:699
JROOT/components/com_sobipro/lib/models/category.php:162
JROOT/components/com_sobipro/lib/models/dbobject.php:644
JROOT/components/com_sobipro/lib/ctrl/controller.php:86
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:465
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:287
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:156
JROOT/components/com_sobipro/sobipro.php:53
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.76 ms After last query: 0.27 ms
```
SELECT sValue, sKey 
  FROM ovl_sobipro_language 
  WHERE  ( id ='73' )  
  AND  ( sKey  IN ( 'description','introtext','name','metaKeys','metaDesc','nid','metaDesc','metaKeys' ) )  
  AND  ( language ='en-GB' )  
  AND  ( oType ='category' )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_language NULL range PRIMARY,sKey,language PRIMARY 608 NULL 6 10.00 Using index condition; Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84
JROOT/components/com_sobipro/lib/models/dbobject.php:729
JROOT/components/com_sobipro/lib/models/dbobject.php:716
JROOT/components/com_sobipro/lib/models/category.php:162
JROOT/components/com_sobipro/lib/models/dbobject.php:644
JROOT/components/com_sobipro/lib/ctrl/controller.php:86
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:465
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:287
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:156
JROOT/components/com_sobipro/sobipro.php:53
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.18 ms After last query: 0.22 ms
```
SELECT position,pid 
  FROM ovl_sobipro_relations 
  WHERE  ( id ='73' )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_relations NULL ref PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:887
JROOT/components/com_sobipro/lib/models/category.php:167
JROOT/components/com_sobipro/lib/models/dbobject.php:644
JROOT/components/com_sobipro/lib/ctrl/controller.php:86
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:465
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:287
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:156
JROOT/components/com_sobipro/sobipro.php:53
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:52
[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	parent	NULL	index	NULL	idx_usergroup_nested_set_lookup	8	NULL	10	100.00	Using index

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_sobipro_category	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	ovl_sobipro_counter	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	ovl_sobipro_language	NULL	range	PRIMARY,sKey,language	PRIMARY	608	NULL	6	10.00	Using index condition; Using where

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

Query Time: 0.80 ms After last query: 0.46 ms

SELECT  DISTINCT sprl.rid 
  FROM  ovl_sobipro_permissions_groups AS spgr 
  LEFT JOIN ovl_sobipro_permissions_rules AS sprl 
  ON spgr.rid =  sprl.rid 
  WHERE ( ( sprl.validUntil > '2021-01-22 00:06:37' OR sprl.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) 
  AND ( sprl.validSince < '2021-01-22 00:06:37' OR sprl.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )   
  AND state = 1  ) 
  AND spgr.gid in( 0 )

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sprl	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	4	25.00	Using where; Using temporary
1	SIMPLE	spgr	NULL	eq_ref	PRIMARY	PRIMARY	8	db59gacpy8p5zb.sprl.rid,const	1	100.00	Using index; Distinct

Profile

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

Call Stack

JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66

JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:182

JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:236

JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180

JROOT/components/com_sobipro/lib/sobi.php:249

JROOT/components/com_sobipro/lib/ctrl/controller.php:359

JROOT/components/com_sobipro/lib/ctrl/controller.php:200

JROOT/components/com_sobipro/lib/ctrl/category.php:63

JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538

JROOT/components/com_sobipro/sobipro.php:54

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

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

Query Time: 0.50 ms After last query: 0.12 ms
```
SELECT pid 
  FROM ovl_sobipro_permissions_map 
  WHERE  ( sid ='59' )  
  AND  ( rid  IN ( '1','3','4' ) )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_permissions_map NULL range PRIMARY PRIMARY 8 NULL 7 100.00 Using where; Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66
JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:190
JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:236
JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180
JROOT/components/com_sobipro/lib/sobi.php:249
JROOT/components/com_sobipro/lib/ctrl/controller.php:359
JROOT/components/com_sobipro/lib/ctrl/controller.php:200
JROOT/components/com_sobipro/lib/ctrl/category.php:63
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538
JROOT/components/com_sobipro/sobipro.php:54
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.46 ms After last query: 0.09 ms
```
SELECT * 
  FROM ovl_sobipro_permissions 
  WHERE  ( site ='front' )  
  AND  ( published ='1' )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_permissions NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 27 3.70 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84
JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:198
JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:236
JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180
JROOT/components/com_sobipro/lib/sobi.php:249
JROOT/components/com_sobipro/lib/ctrl/controller.php:359
JROOT/components/com_sobipro/lib/ctrl/controller.php:200
JROOT/components/com_sobipro/lib/ctrl/category.php:63
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538
JROOT/components/com_sobipro/sobipro.php:54
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.16 ms After last query: 0.26 ms
```
SELECT pid 
  FROM ovl_sobipro_plugin_task 
  WHERE  ( onAction  IN ( '*','category.view','category.*' ) )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_plugin_task NULL index NULL pid 757 NULL 9 33.33 Using where; Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66
JROOT/components/com_sobipro/lib/plugins/interface.php:72
JROOT/components/com_sobipro/lib/plugins/interface.php:167
JROOT/components/com_sobipro/lib/sobi.php:228
JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:182
JROOT/components/com_sobipro/lib/sobi.php:249
JROOT/components/com_sobipro/lib/ctrl/controller.php:359
JROOT/components/com_sobipro/lib/ctrl/controller.php:200
JROOT/components/com_sobipro/lib/ctrl/category.php:63
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538
JROOT/components/com_sobipro/sobipro.php:54
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:52
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.17 ms After last query: 0.12 ms
Duplicate queries: #17 #87
```
SELECT pid 
  FROM ovl_sobipro_plugin_section 
  WHERE  ( section ='59' )  
  AND  ( enabled ='1' )  
  AND  ( pid  IN ( 'promotedentries' ) )
```
Explain
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE ovl_sobipro_plugin_section NULL ref PRIMARY PRIMARY 156 const,const 1 33.33 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66
JROOT/components/com_sobipro/lib/plugins/interface.php:83
JROOT/components/com_sobipro/lib/plugins/interface.php:167
JROOT/components/com_sobipro/lib/sobi.php:228
JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:182
JROOT/components/com_sobipro/lib/sobi.php:249
JROOT/components/com_sobipro/lib/ctrl/controller.php:359
JROOT/components/com_sobipro/lib/ctrl/controller.php:200
JROOT/components/com_sobipro/lib/ctrl/category.php:63
JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538
JROOT/components/com_sobipro/sobipro.php:54
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:52
[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	ovl_sobipro_permissions_map	NULL	range	PRIMARY	PRIMARY	8	NULL	7	100.00	Using where; Using index

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_sobipro_permissions	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	27	3.70	Using where

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_sobipro_plugin_task	NULL	index	NULL	pid	757	NULL	9	33.33	Using where; Using index

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ovl_sobipro_plugin_section	NULL	ref	PRIMARY	PRIMARY	156	const,const	1	33.33	Using where

Query Time: 0.51 ms After last query: 2.28 ms

SELECT  DISTINCT spo.id 
  FROM  ovl_sobipro_relations AS sprl 
  LEFT JOIN ovl_sobipro_object AS spo 
  ON sprl.id =  spo.id 
  WHERE  ( sprl.pid ='73' )  
  AND  ( spo.oType ='entry' )  
  AND  ( spo.state ='1' )  
  AND ( ( spo.validUntil > '2021-01-22 00:06:37' OR spo.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) 
  AND ( spo.validSince < '2021-01-22 00:06:37' OR spo.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )   )  
  AND  ( sprl.copy ='0' )   
  ORDER BY position asc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sprl	NULL	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	92	1.09	Using where; Using temporary; Using filesort
1	SIMPLE	spo	NULL	eq_ref	PRIMARY,name,oType,owner,parent,state,validSince,validUntil,version	PRIMARY	4	db59gacpy8p5zb.sprl.id	1	44.42	Using where

Profile

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

Call Stack

JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66

JROOT/components/com_sobipro/lib/ctrl/section.php:394

JROOT/components/com_sobipro/lib/ctrl/section.php:69

JROOT/components/com_sobipro/lib/ctrl/controller.php:201

JROOT/components/com_sobipro/lib/ctrl/category.php:63

JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538

JROOT/components/com_sobipro/sobipro.php:54

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

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

Query Time: 0.40 ms After last query: 0.36 ms

Clothing

Berghaus

Tamarack Outdoors

Lyon Equipment

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

193 Queries Logged 94.4 ms

123 duplicate found!