Joomla! Debug Console
Time
Memory
Time: 0.0 ms / 0.0 ms Memory: 0.636 MB / 0.64 MB Application: afterLoad
Time: 39.4 ms / 39.4 ms Memory: 5.483 MB / 6.12 MB Application: afterInitialise
Time: 17.6 ms / 57.0 ms Memory: 2.263 MB / 8.38 MB Application: afterRoute
Time: 137.0 ms / 194.1 ms Memory: 8.267 MB / 16.65 MB Application: afterDispatch
Time: 45.6 ms / 239.6 ms Memory: 2.825 MB / 19.47 MB Application: beforeRenderModule mod_menu (Footer Menu)
Time: 4.6 ms / 244.2 ms Memory: 0.161 MB / 19.64 MB Application: afterRenderModule mod_menu (Footer Menu)
Time: 1.2 ms / 245.4 ms Memory: 0.027 MB / 19.66 MB Application: beforeRenderModule mod_menu (Directory Menue Tree)
Time: 9.3 ms / 254.7 ms Memory: 0.142 MB / 19.80 MB Application: afterRenderModule mod_menu (Directory Menue Tree)
Time: 1.1 ms / 255.8 ms Memory: 0.000 MB / 19.80 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 1.9 ms / 257.7 ms Memory: 0.069 MB / 19.87 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.9 ms / 258.6 ms Memory: 0.000 MB / 19.86 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 3.5 ms / 262.1 ms Memory: 0.185 MB / 20.05 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.3 ms / 262.4 ms Memory: 0.000 MB / 20.02 MB Application: beforeRenderModule mod_search (search)
Time: 1.6 ms / 264.0 ms Memory: 0.036 MB / 20.05 MB Application: afterRenderModule mod_search (search)
Time: 0.1 ms / 264.1 ms Memory: 0.000 MB / 20.05 MB Application: beforeRenderModule mod_banners (Head Add Banner)
Time: 6.8 ms / 270.9 ms Memory: 0.404 MB / 20.45 MB Application: afterRenderModule mod_banners (Head Add Banner)
Time: 0.2 ms / 271.1 ms Memory: 0.013 MB / 20.46 MB Application: beforeRenderModule mod_date2 (Date2)
Time: 2.9 ms / 274.0 ms Memory: 0.311 MB / 20.77 MB Application: afterRenderModule mod_date2 (Date2)
Time: 0.1 ms / 274.1 ms Memory: 0.000 MB / 20.72 MB Application: beforeRenderModule mod_menu (Top Menue)
Time: 2.5 ms / 276.6 ms Memory: 0.049 MB / 20.77 MB Application: afterRenderModule mod_menu (Top Menue)
Time: 0.1 ms / 276.7 ms Memory: 0.000 MB / 20.77 MB Application: beforeRenderModule mod_menu (Social Media Buttons)
Time: 2.4 ms / 279.1 ms Memory: 0.053 MB / 20.82 MB Application: afterRenderModule mod_menu (Social Media Buttons)
Time: 42.8 ms / 321.9 ms Memory: 2.506 MB / 23.33 MB Application: afterRender
Database queries total: 55.5 ms
23.93 MB (25,089,944 Bytes)
110 Queries Logged 55.5 ms
27 duplicate found!
- Query Time: 0.39 ms
SELECT `data`
FROM `ovl_session`
WHERE `session_id` = '64seuccq5uhfm09mejvef9iar3'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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/session/storage/database.php:46JROOT/libraries/joomla/session/session.php:658JROOT/libraries/joomla/session/session.php:596JROOT/libraries/cms/application/cms.php:668JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:328JROOT/libraries/joomla/factory.php:124JROOT/index.php:49 - Query Time: 0.19 ms After last query: 1.16 ms
SELECT `session_id`
FROM `ovl_session`
WHERE `session_id` = '64seuccq5uhfm09mejvef9iar3'
LIMIT 0, 1id 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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/application/cms.php:175JROOT/libraries/cms/application/cms.php:694JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:328JROOT/libraries/joomla/factory.php:124JROOT/index.php:49 - Query Time: 0.28 ms After last query: 0.09 ms
INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`)
VALUES ('64seuccq5uhfm09mejvef9iar3', 0, '1611271832')EXPLAIN not possible on query: INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`) VALUES ('64seuccq5uhfm09mejvef9iar3', 0, '1611271832')No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/application/cms.php:207JROOT/libraries/cms/application/cms.php:694JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:328JROOT/libraries/joomla/factory.php:124JROOT/index.php:49 - Query Time: 0.46 ms After last query: 3.26 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 = 9id 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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:334JROOT/libraries/joomla/access/access.php:403JROOT/libraries/joomla/user/user.php:428JROOT/libraries/cms/plugin/helper.php:298JROOT/libraries/cms/plugin/helper.php:165JROOT/libraries/cms/application/site.php:575JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.26 ms After last query: 0.45 ms
SELECT id, rules
FROM `ovl_viewlevels`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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:420JROOT/libraries/joomla/user/user.php:428JROOT/libraries/cms/plugin/helper.php:298JROOT/libraries/cms/plugin/helper.php:165JROOT/libraries/cms/application/site.php:575JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 1.50 ms After last query: 22.71 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.lftid 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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/menu/site.php:47JROOT/libraries/cms/menu/menu.php:64JROOT/libraries/cms/menu/menu.php:118JROOT/libraries/cms/application/cms.php:353JROOT/libraries/cms/application/site.php:279JROOT/libraries/cms/router/site.php:218JROOT/libraries/cms/router/router.php:408JROOT/libraries/cms/router/router.php:192JROOT/libraries/cms/router/site.php:90JROOT/libraries/cms/application/cms.php:1018JROOT/libraries/cms/application/site.php:749JROOT/libraries/cms/application/site.php:231JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.56 ms After last query: 7.58 ms
UPDATE `ovl_extensions`
SET `params` = '{\"mediaversion\":\"9b862a6a6982d974c7fd46cf1acdfc52\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/library/helper.php:119JROOT/libraries/cms/version/version.php:230JROOT/libraries/cms/version/version.php:189JROOT/libraries/joomla/factory.php:734JROOT/libraries/joomla/factory.php:215JROOT/plugins/system/k2/k2.php:52JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:1027JROOT/libraries/cms/application/site.php:749JROOT/libraries/cms/application/site.php:231JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.62 ms After last query: 16.06 ms
SELECT *
FROM ovl_sobipro_object
WHERE ( id ='91' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:887JROOT/components/com_sobipro/lib/base/factory.php:181JROOT/components/com_sobipro/lib/ctrl/sobipro.php:195JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.65 ms After last query: 0.16 ms
SELECT pid
FROM ovl_sobipro_relations
WHERE ( id ='91' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:820JROOT/components/com_sobipro/lib/ctrl/sobipro.php:206JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.20 ms After last query: 0.10 ms
SELECT pid
FROM ovl_sobipro_relations
WHERE ( id ='66' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:820JROOT/components/com_sobipro/lib/ctrl/sobipro.php:206JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.17 ms After last query: 0.15 ms
SELECT pid
FROM ovl_sobipro_relations
WHERE ( id ='59' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:820JROOT/components/com_sobipro/lib/ctrl/sobipro.php:206JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.21 ms After last query: 0.18 ms
SELECT *
FROM ovl_sobipro_object
WHERE ( id ='59' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:887JROOT/components/com_sobipro/lib/base/factory.php:181JROOT/components/com_sobipro/lib/ctrl/sobipro.php:217JROOT/components/com_sobipro/lib/ctrl/sobipro.php:109JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.88 ms After last query: 3.27 ms
SELECT cSection AS configsection,sKey AS sKey,sValue AS sValue
FROM ovl_sobipro_config
WHERE ( section IN ( '0','59' ) )
ORDER BY section, configsectionid 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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:918JROOT/components/com_sobipro/lib/base/config.php:177JROOT/components/com_sobipro/lib/ctrl/sobipro.php:178JROOT/components/com_sobipro/lib/ctrl/sobipro.php:115JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.55 ms After last query: 2.69 ms
SELECT *
FROM ovl_sobipro_field
WHERE ( fid ='35' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:887JROOT/components/com_sobipro/lib/models/field.php:368JROOT/components/com_sobipro/lib/base/config.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:182JROOT/components/com_sobipro/lib/ctrl/sobipro.php:115JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.65 ms After last query: 0.98 ms
SELECT pid
FROM ovl_sobipro_plugin_task
WHERE ( onAction IN ( '*','*' ) )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66JROOT/components/com_sobipro/lib/plugins/interface.php:72JROOT/components/com_sobipro/lib/plugins/interface.php:167JROOT/components/com_sobipro/lib/sobi.php:228JROOT/components/com_sobipro/lib/models/field.php:369JROOT/components/com_sobipro/lib/base/config.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:182JROOT/components/com_sobipro/lib/ctrl/sobipro.php:115JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.50 ms After last query: 0.15 ms
SELECT pid
FROM ovl_sobipro_plugin_section
WHERE ( section ='59' )
AND ( enabled ='1' )
AND ( pid IN ( 'promotedentries' ) )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66JROOT/components/com_sobipro/lib/plugins/interface.php:83JROOT/components/com_sobipro/lib/plugins/interface.php:167JROOT/components/com_sobipro/lib/sobi.php:228JROOT/components/com_sobipro/lib/models/field.php:369JROOT/components/com_sobipro/lib/base/config.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:182JROOT/components/com_sobipro/lib/ctrl/sobipro.php:115JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 1.09 ms After last query: 2.25 msDuplicate queries: #53
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', '%' ) ASCid 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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84JROOT/components/com_sobipro/lib/models/field.php:492JROOT/components/com_sobipro/lib/models/field.php:389JROOT/components/com_sobipro/lib/models/field.php:373JROOT/components/com_sobipro/lib/base/config.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:182JROOT/components/com_sobipro/lib/ctrl/sobipro.php:115JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.49 ms After last query: 2.02 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' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:690JROOT/components/com_sobipro/lib/ctrl/sobipro.php:145JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 1.00 ms After last query: 5.58 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-21 23:30:32' OR rel.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND ( rel.validSince < '2021-01-21 23:30:32' OR rel.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND grp.enabled = 1 )
AND ( uid ='0' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:101JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:44JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:383JROOT/components/com_sobipro/lib/base/factory.php:104JROOT/components/com_sobipro/lib/sobi.php:434JROOT/components/com_sobipro/lib/models/dbobject.php:214JROOT/components/com_sobipro/lib/ctrl/controller.php:70JROOT/components/com_sobipro/lib/ctrl/sobipro.php:464JROOT/components/com_sobipro/lib/ctrl/sobipro.php:287JROOT/components/com_sobipro/lib/ctrl/sobipro.php:156JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.19 ms After last query: 0.14 ms
SELECT parent.id, parent.lft, parent.rgt
FROM ovl_usergroups AS parent
ORDER BY parent.lftid 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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:178JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:221JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:79JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:46JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:383JROOT/components/com_sobipro/lib/base/factory.php:104JROOT/components/com_sobipro/lib/sobi.php:434JROOT/components/com_sobipro/lib/models/dbobject.php:214JROOT/components/com_sobipro/lib/ctrl/controller.php:70JROOT/components/com_sobipro/lib/ctrl/sobipro.php:464JROOT/components/com_sobipro/lib/ctrl/sobipro.php:287JROOT/components/com_sobipro/lib/ctrl/sobipro.php:156JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.57 ms After last query: 0.62 ms
SELECT *
FROM ovl_sobipro_category
WHERE ( id ='91' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:887JROOT/components/com_sobipro/lib/models/dbobject.php:697JROOT/components/com_sobipro/lib/models/category.php:162JROOT/components/com_sobipro/lib/models/dbobject.php:644JROOT/components/com_sobipro/lib/ctrl/controller.php:86JROOT/components/com_sobipro/lib/ctrl/sobipro.php:465JROOT/components/com_sobipro/lib/ctrl/sobipro.php:287JROOT/components/com_sobipro/lib/ctrl/sobipro.php:156JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.39 ms After last query: 0.12 ms
SELECT counter
FROM ovl_sobipro_counter
WHERE ( sid ='91' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:820JROOT/components/com_sobipro/lib/models/dbobject.php:699JROOT/components/com_sobipro/lib/models/category.php:162JROOT/components/com_sobipro/lib/models/dbobject.php:644JROOT/components/com_sobipro/lib/ctrl/controller.php:86JROOT/components/com_sobipro/lib/ctrl/sobipro.php:465JROOT/components/com_sobipro/lib/ctrl/sobipro.php:287JROOT/components/com_sobipro/lib/ctrl/sobipro.php:156JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.82 ms After last query: 0.31 ms
SELECT sValue, sKey
FROM ovl_sobipro_language
WHERE ( id ='91' )
AND ( sKey IN ( 'description','introtext','name','metaKeys','metaDesc','nid','metaDesc','metaKeys' ) )
AND ( language ='en-GB' )
AND ( oType ='category' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84JROOT/components/com_sobipro/lib/models/dbobject.php:729JROOT/components/com_sobipro/lib/models/dbobject.php:716JROOT/components/com_sobipro/lib/models/category.php:162JROOT/components/com_sobipro/lib/models/dbobject.php:644JROOT/components/com_sobipro/lib/ctrl/controller.php:86JROOT/components/com_sobipro/lib/ctrl/sobipro.php:465JROOT/components/com_sobipro/lib/ctrl/sobipro.php:287JROOT/components/com_sobipro/lib/ctrl/sobipro.php:156JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.19 ms After last query: 0.28 ms
SELECT position,pid
FROM ovl_sobipro_relations
WHERE ( id ='91' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:887JROOT/components/com_sobipro/lib/models/category.php:167JROOT/components/com_sobipro/lib/models/dbobject.php:644JROOT/components/com_sobipro/lib/ctrl/controller.php:86JROOT/components/com_sobipro/lib/ctrl/sobipro.php:465JROOT/components/com_sobipro/lib/ctrl/sobipro.php:287JROOT/components/com_sobipro/lib/ctrl/sobipro.php:156JROOT/components/com_sobipro/sobipro.php:53JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.80 ms After last query: 0.45 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-21 23:30:32' OR sprl.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND ( sprl.validSince < '2021-01-21 23:30:32' OR sprl.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND state = 1 )
AND spgr.gid in( 0 )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:182JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:236JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180JROOT/components/com_sobipro/lib/sobi.php:249JROOT/components/com_sobipro/lib/ctrl/controller.php:359JROOT/components/com_sobipro/lib/ctrl/controller.php:200JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.49 ms After last query: 0.12 ms
SELECT pid
FROM ovl_sobipro_permissions_map
WHERE ( sid ='59' )
AND ( rid IN ( '1','3','4' ) )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:190JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:236JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180JROOT/components/com_sobipro/lib/sobi.php:249JROOT/components/com_sobipro/lib/ctrl/controller.php:359JROOT/components/com_sobipro/lib/ctrl/controller.php:200JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.48 ms After last query: 0.11 ms
SELECT *
FROM ovl_sobipro_permissions
WHERE ( site ='front' )
AND ( published ='1' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84JROOT/components/com_sobipro/lib/cms/joomla3/base/user.php:198JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:236JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:180JROOT/components/com_sobipro/lib/sobi.php:249JROOT/components/com_sobipro/lib/ctrl/controller.php:359JROOT/components/com_sobipro/lib/ctrl/controller.php:200JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.17 ms After last query: 0.26 ms
SELECT pid
FROM ovl_sobipro_plugin_task
WHERE ( onAction IN ( '*','category.view','category.*' ) )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66JROOT/components/com_sobipro/lib/plugins/interface.php:72JROOT/components/com_sobipro/lib/plugins/interface.php:167JROOT/components/com_sobipro/lib/sobi.php:228JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:182JROOT/components/com_sobipro/lib/sobi.php:249JROOT/components/com_sobipro/lib/ctrl/controller.php:359JROOT/components/com_sobipro/lib/ctrl/controller.php:200JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.18 ms After last query: 0.12 ms
SELECT pid
FROM ovl_sobipro_plugin_section
WHERE ( section ='59' )
AND ( enabled ='1' )
AND ( pid IN ( 'promotedentries' ) )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66JROOT/components/com_sobipro/lib/plugins/interface.php:83JROOT/components/com_sobipro/lib/plugins/interface.php:167JROOT/components/com_sobipro/lib/sobi.php:228JROOT/components/com_sobipro/lib/cms/joomla_common/base/user.php:182JROOT/components/com_sobipro/lib/sobi.php:249JROOT/components/com_sobipro/lib/ctrl/controller.php:359JROOT/components/com_sobipro/lib/ctrl/controller.php:200JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.46 ms After last query: 1.66 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 ='91' )
AND ( spo.oType ='entry' )
AND ( spo.state ='1' )
AND ( ( spo.validUntil > '2021-01-21 23:30:32' OR spo.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND ( spo.validSince < '2021-01-21 23:30:32' OR spo.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) )
AND ( sprl.copy ='0' )
ORDER BY position ascid 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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66JROOT/components/com_sobipro/lib/ctrl/section.php:394JROOT/components/com_sobipro/lib/ctrl/section.php:69JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.36 ms After last query: 0.35 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 ='91' )
AND ( spo.oType ='entry' )
AND ( spo.state ='1' )
AND ( ( spo.validUntil > '2021-01-21 23:30:32' OR spo.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND ( spo.validSince < '2021-01-21 23:30:32' OR spo.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) )
AND ( sprl.copy ='0' )
ORDER BY position asc
LIMIT 0, 8id 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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66JROOT/components/com_sobipro/lib/ctrl/section.php:394JROOT/components/com_sobipro/lib/ctrl/section.php:70JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.13 ms After last query: 6.16 ms
SET sql_big_selects=1EXPLAIN not possible on query: SET sql_big_selects=1No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/administrator/components/com_xtdir/helpers/searcher.php:305JROOT/administrator/components/com_xtdir/helpers/promoted.php:730JROOT/administrator/components/com_xtdir/helpers/promoted.php:689JROOT/components/com_sobipro/opt/plugins/promotedentries/helper.php:74JROOT/components/com_sobipro/opt/plugins/promotedentries/init.php:174JROOT/components/com_sobipro/opt/plugins/promotedentries/init.php:155JROOT/components/com_sobipro/lib/plugins/interface.php:179JROOT/components/com_sobipro/lib/sobi.php:228JROOT/components/com_sobipro/lib/ctrl/section.php:398JROOT/components/com_sobipro/lib/ctrl/section.php:70JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.85 ms After last query: 0.15 ms
SELECT cp.entry_id,cp.ordering,cp.counter
FROM ovl_xtdir_final_categorypromoted as cp,ovl_sobipro_object as o,ovl_sobipro_relations as r
WHERE cp.entry_id in (116)
AND cp.category_id = '91'
AND cp.entry_id = o.id
AND r.id = cp.entry_id
AND r.pid = cp.category_id
AND r.oType = 'entry'
ORDER BY r.positionid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE o NULL const PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE r NULL const PRIMARY,oType PRIMARY 8 const,const 1 100.00 NULL 1 SIMPLE cp NULL ref category_entry,entry_id category_entry 8 const,const 1 100.00 Using index condition No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/administrator/components/com_xtdir/helpers/promoted.php:757JROOT/administrator/components/com_xtdir/helpers/promoted.php:689JROOT/components/com_sobipro/opt/plugins/promotedentries/helper.php:74JROOT/components/com_sobipro/opt/plugins/promotedentries/init.php:174JROOT/components/com_sobipro/opt/plugins/promotedentries/init.php:155JROOT/components/com_sobipro/lib/plugins/interface.php:179JROOT/components/com_sobipro/lib/sobi.php:228JROOT/components/com_sobipro/lib/ctrl/section.php:398JROOT/components/com_sobipro/lib/ctrl/section.php:70JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.49 ms After last query: 0.14 ms
SELECT distinct sp.entry_id,sp.ordering,sp.counter
FROM ovl_xtdir_final_sectionpromoted as sp,ovl_sobipro_object as o,ovl_sobipro_relations as r
WHERE sp.entry_id in (116)
AND sp.entry_id = o.id
AND r.id = sp.entry_id
AND r.oType = 'entry'
ORDER BY r.positionid 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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/administrator/components/com_xtdir/helpers/promoted.php:789JROOT/administrator/components/com_xtdir/helpers/promoted.php:689JROOT/components/com_sobipro/opt/plugins/promotedentries/helper.php:74JROOT/components/com_sobipro/opt/plugins/promotedentries/init.php:174JROOT/components/com_sobipro/opt/plugins/promotedentries/init.php:155JROOT/components/com_sobipro/lib/plugins/interface.php:179JROOT/components/com_sobipro/lib/sobi.php:228JROOT/components/com_sobipro/lib/ctrl/section.php:398JROOT/components/com_sobipro/lib/ctrl/section.php:70JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.21 ms After last query: 1.50 ms
SELECT id,oType
FROM ovl_sobipro_relations
WHERE ( pid ='91' )id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_sobipro_relations NULL index NULL oType 152 NULL 92 10.00 Using where; Using index No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84JROOT/components/com_sobipro/lib/models/dbobject.php:337JROOT/components/com_sobipro/lib/ctrl/section.php:127JROOT/components/com_sobipro/lib/ctrl/section.php:73JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.20 ms After last query: 0.79 ms
SELECT pid
FROM ovl_sobipro_relations
WHERE ( id ='91' )
AND ( pid !='91' )id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_sobipro_relations NULL range PRIMARY PRIMARY 8 NULL 2 100.00 Using where; Using index No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:820JROOT/components/com_sobipro/lib/base/config.php:735JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:369JROOT/components/com_sobipro/lib/ctrl/section.php:89JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.16 ms After last query: 0.11 ms
SELECT pid
FROM ovl_sobipro_relations
WHERE ( id ='66' )
AND ( pid !='66' )id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_sobipro_relations NULL range PRIMARY PRIMARY 8 NULL 2 100.00 Using where; Using index No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:820JROOT/components/com_sobipro/lib/base/config.php:735JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:369JROOT/components/com_sobipro/lib/ctrl/section.php:89JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.15 ms After last query: 0.09 ms
SELECT pid
FROM ovl_sobipro_relations
WHERE ( id ='59' )
AND ( pid !='59' )id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_sobipro_relations NULL range PRIMARY PRIMARY 8 NULL 2 100.00 Using where; Using index No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:820JROOT/components/com_sobipro/lib/base/config.php:735JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:369JROOT/components/com_sobipro/lib/ctrl/section.php:89JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.76 ms After last query: 0.17 ms
SELECT id AS id, sKey AS label, sValue AS value, language
FROM ovl_sobipro_language
WHERE ( id IN ( '91','66','59' ) )
AND ( oType IN ( 'section','category','entry' ) )
AND ( sKey IN ( 'name','alias','nid' ) )
ORDER BY FIELD( language, 'en-GB', 'en-GB' )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 97 9.00 Using index condition; Using where; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:690JROOT/components/com_sobipro/lib/base/config.php:744JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:369JROOT/components/com_sobipro/lib/ctrl/section.php:89JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.17 ms After last query: 0.15 ms
SELECT nid,id
FROM ovl_sobipro_object
WHERE ( id IN ( '91','66','59' ) )id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_sobipro_object NULL range PRIMARY PRIMARY 4 NULL 3 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:696JROOT/components/com_sobipro/lib/base/config.php:744JROOT/components/com_sobipro/lib/cms/joomla_common/base/mainframe.php:369JROOT/components/com_sobipro/lib/ctrl/section.php:89JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.28 ms After last query: 0.39 ms
INSERT INTO ovl_sobipro_counter (`sid`,`counter`,`lastUpdate`)
VALUES ('91','3142','2021-01-21 23:30:32')
ON DUPLICATE KEY UPDATE sid = '91',counter = '3142',lastUpdate = '2021-01-21 23:30:32'EXPLAIN not possible on query: INSERT INTO ovl_sobipro_counter (`sid`,`counter`,`lastUpdate`) VALUES ('91','3142','2021-01-21 23:30:32') ON DUPLICATE KEY UPDATE sid = '91',counter = '3142',lastUpdate = '2021-01-21 23:30:32'No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:808JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:1007JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:770JROOT/components/com_sobipro/lib/models/dbobject.php:497JROOT/components/com_sobipro/lib/ctrl/section.php:91JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.29 ms After last query: 9.28 ms
SELECT counter,sid
FROM ovl_sobipro_counter
WHERE ( sid IN ( '116' ) )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84JROOT/components/com_sobipro/lib/views/view.php:748JROOT/components/com_sobipro/lib/views/section.php:407JROOT/components/com_sobipro/lib/views/section.php:444JROOT/components/com_sobipro/lib/ctrl/section.php:111JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.32 ms After last query: 2.41 ms
SELECT *
FROM ovl_sobipro_object
WHERE ( id ='116' )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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla_common/base/database.php:887JROOT/components/com_sobipro/lib/base/factory.php:181JROOT/components/com_sobipro/lib/models/dbobject.php:659JROOT/components/com_sobipro/lib/base/factory.php:256JROOT/components/com_sobipro/lib/views/section.php:192JROOT/components/com_sobipro/lib/views/section.php:410JROOT/components/com_sobipro/lib/views/section.php:444JROOT/components/com_sobipro/lib/ctrl/section.php:111JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.29 ms After last query: 0.34 ms
SELECT pid,position,validSince,validUntil
FROM ovl_sobipro_relations
WHERE ( id ='116' )
AND ( oType ='entry' )
ORDER BY positionid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_sobipro_relations NULL ref PRIMARY,oType PRIMARY 4 const 1 10.00 Using where; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84JROOT/components/com_sobipro/lib/models/entry.php:388JROOT/components/com_sobipro/lib/models/entry.php:106JROOT/components/com_sobipro/lib/models/dbobject.php:644JROOT/components/com_sobipro/lib/models/dbobject.php:663JROOT/components/com_sobipro/lib/base/factory.php:256JROOT/components/com_sobipro/lib/views/section.php:192JROOT/components/com_sobipro/lib/views/section.php:410JROOT/components/com_sobipro/lib/views/section.php:444JROOT/components/com_sobipro/lib/ctrl/section.php:111JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.14 ms After last query: 0.15 ms
SELECT id
FROM ovl_sobipro_object
WHERE ( id IN ( '91' ) )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 Using index No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:66JROOT/components/com_sobipro/lib/models/entry.php:392JROOT/components/com_sobipro/lib/models/entry.php:106JROOT/components/com_sobipro/lib/models/dbobject.php:644JROOT/components/com_sobipro/lib/models/dbobject.php:663JROOT/components/com_sobipro/lib/base/factory.php:256JROOT/components/com_sobipro/lib/views/section.php:192JROOT/components/com_sobipro/lib/views/section.php:410JROOT/components/com_sobipro/lib/views/section.php:444JROOT/components/com_sobipro/lib/ctrl/section.php:111JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52 - Query Time: 0.73 ms After last query: 0.20 ms
SELECT id AS id, sKey AS label, sValue AS value, language
FROM ovl_sobipro_language
WHERE ( id IN ( '91' ) )
AND ( oType ='category' )
AND ( sKey IN ( 'name','alias','nid' ) )
ORDER BY FIELD( language, 'en-GB', 'en-GB' )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 97 1.00 Using index condition; Using where; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/components/com_sobipro/lib/cms/joomla16/base/database.php:84JROOT/components/com_sobipro/lib/cms/joomla_common/base/lang.php:690JROOT/components/com_sobipro/lib/models/entry.php:414JROOT/components/com_sobipro/lib/models/entry.php:106JROOT/components/com_sobipro/lib/models/dbobject.php:644JROOT/components/com_sobipro/lib/models/dbobject.php:663JROOT/components/com_sobipro/lib/base/factory.php:256JROOT/components/com_sobipro/lib/views/section.php:192JROOT/components/com_sobipro/lib/views/section.php:410JROOT/components/com_sobipro/lib/views/section.php:444JROOT/components/com_sobipro/lib/ctrl/section.php:111JROOT/components/com_sobipro/lib/ctrl/controller.php:201JROOT/components/com_sobipro/lib/ctrl/category.php:63JROOT/components/com_sobipro/lib/ctrl/sobipro.php:538JROOT/components/com_sobipro/sobipro.php:54JROOT/libraries/cms/component/helper.php:352JROOT/libraries/cms/component/helper.php:332JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:237JROOT/libraries/cms/application/cms.php:251JROOT/index.php:52