Joomla! Debug Console
Time
Memory
Time: 0.0 ms / 0.0 ms Memory: 0.636 MB / 0.64 MB Application: afterLoad
Time: 36.6 ms / 36.6 ms Memory: 5.483 MB / 6.12 MB Application: afterInitialise
Time: 16.5 ms / 53.1 ms Memory: 2.263 MB / 8.38 MB Application: afterRoute
Time: 61.8 ms / 114.9 ms Memory: 5.045 MB / 13.43 MB Application: afterDispatch
Time: 34.8 ms / 149.7 ms Memory: 2.824 MB / 16.25 MB Application: beforeRenderModule mod_menu (Footer Menu)
Time: 5.4 ms / 155.1 ms Memory: 0.161 MB / 16.41 MB Application: afterRenderModule mod_menu (Footer Menu)
Time: 0.8 ms / 155.9 ms Memory: 0.018 MB / 16.43 MB Application: beforeRenderModule mod_custom (footer)
Time: 0.8 ms / 156.7 ms Memory: 0.011 MB / 16.44 MB Application: afterRenderModule mod_custom (footer)
Time: 0.9 ms / 157.5 ms Memory: 0.000 MB / 16.44 MB Application: beforeRenderModule mod_custom (newsletter-form)
Time: 0.3 ms / 157.8 ms Memory: 0.008 MB / 16.45 MB Application: afterRenderModule mod_custom (newsletter-form)
Time: 0.8 ms / 158.6 ms Memory: 0.001 MB / 16.45 MB Application: beforeRenderModule mod_menu (Directory Menue Tree)
Time: 9.4 ms / 168.0 ms Memory: 0.142 MB / 16.59 MB Application: afterRenderModule mod_menu (Directory Menue Tree)
Time: 1.0 ms / 169.0 ms Memory: 0.000 MB / 16.59 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 2.0 ms / 170.9 ms Memory: 0.069 MB / 16.65 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.8 ms / 171.8 ms Memory: 0.000 MB / 16.65 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 3.4 ms / 175.2 ms Memory: 0.185 MB / 16.83 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 0.3 ms / 175.4 ms Memory: 0.000 MB / 16.80 MB Application: beforeRenderModule mod_search (search)
Time: 1.5 ms / 176.9 ms Memory: 0.036 MB / 16.84 MB Application: afterRenderModule mod_search (search)
Time: 0.1 ms / 177.0 ms Memory: 0.000 MB / 16.83 MB Application: beforeRenderModule mod_banners (Head Add Banner)
Time: 6.0 ms / 183.0 ms Memory: 0.404 MB / 17.24 MB Application: afterRenderModule mod_banners (Head Add Banner)
Time: 0.2 ms / 183.1 ms Memory: 0.013 MB / 17.25 MB Application: beforeRenderModule mod_date2 (Date2)
Time: 2.6 ms / 185.7 ms Memory: 0.312 MB / 17.56 MB Application: afterRenderModule mod_date2 (Date2)
Time: 0.1 ms / 185.8 ms Memory: 0.000 MB / 17.51 MB Application: beforeRenderModule mod_menu (Top Menue)
Time: 1.9 ms / 187.7 ms Memory: 0.049 MB / 17.56 MB Application: afterRenderModule mod_menu (Top Menue)
Time: 0.1 ms / 187.8 ms Memory: 0.000 MB / 17.55 MB Application: beforeRenderModule mod_menu (Social Media Buttons)
Time: 2.0 ms / 189.8 ms Memory: 0.049 MB / 17.60 MB Application: afterRenderModule mod_menu (Social Media Buttons)
Time: 42.3 ms / 232.1 ms Memory: 2.947 MB / 20.55 MB Application: afterRender
Database queries total: 24.2 ms
20.94 MB (21,961,072 Bytes)
62 Queries Logged 24.2 ms
- Query Time: 0.25 ms
SELECT `data`
FROM `ovl_session`
WHERE `session_id` = '5ksblg8uqaj8eub5f7vokj6o46'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.20 ms After last query: 1.07 ms
SELECT `session_id`
FROM `ovl_session`
WHERE `session_id` = '5ksblg8uqaj8eub5f7vokj6o46'
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.21 ms After last query: 0.09 ms
INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`)
VALUES ('5ksblg8uqaj8eub5f7vokj6o46', 0, '1611271474')EXPLAIN not possible on query: INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`) VALUES ('5ksblg8uqaj8eub5f7vokj6o46', 0, '1611271474')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.33 ms After last query: 3.17 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.23 ms After last query: 0.46 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.02 ms After last query: 21.00 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.45 ms After last query: 7.32 ms
UPDATE `ovl_extensions`
SET `params` = '{\"mediaversion\":\"a82b99297964cdd4526b40259645be54\"}'
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.37 ms After last query: 15.37 ms
SELECT *
FROM ovl_sobipro_object
WHERE ( id ='77' )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.57 ms After last query: 0.14 ms
SELECT pid
FROM ovl_sobipro_relations
WHERE ( id ='77' )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.08 ms
SELECT pid
FROM ovl_sobipro_relations
WHERE ( id ='62' )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.12 ms After last query: 0.09 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.15 ms After last query: 0.10 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.76 ms After last query: 2.24 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.43 ms After last query: 1.79 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.48 ms After last query: 0.84 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.44 ms After last query: 0.13 msDuplicate queries: #29
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: 0.90 ms After last query: 2.13 ms
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.42 ms After last query: 1.95 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: 0.69 ms After last query: 5.32 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:24:34' OR rel.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND ( rel.validSince < '2021-01-21 23:24:34' 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.15 ms After last query: 0.10 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.41 ms After last query: 0.53 ms
SELECT *
FROM ovl_sobipro_category
WHERE ( id ='77' )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.33 ms After last query: 0.11 ms
SELECT counter
FROM ovl_sobipro_counter
WHERE ( sid ='77' )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.74 ms After last query: 0.39 ms
SELECT sValue, sKey
FROM ovl_sobipro_language
WHERE ( id ='77' )
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.24 ms
SELECT position,pid
FROM ovl_sobipro_relations
WHERE ( id ='77' )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.79 ms After last query: 0.40 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:24:34' OR sprl.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND ( sprl.validSince < '2021-01-21 23:24:34' 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.43 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.40 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.27 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.13 msDuplicate queries: #16
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.40 ms After last query: 1.60 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 ='77' )
AND ( spo.oType ='entry' )
AND ( spo.state ='1' )
AND ( ( spo.validUntil > '2021-01-21 23:24:34' OR spo.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND ( spo.validSince < '2021-01-21 23:24:34' 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.32 ms After last query: 0.32 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 ='77' )
AND ( spo.oType ='entry' )
AND ( spo.state ='1' )
AND ( ( spo.validUntil > '2021-01-21 23:24:34' OR spo.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) )
AND ( spo.validSince < '2021-01-21 23:24:34' 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.23 ms After last query: 1.54 ms
SELECT id,oType
FROM ovl_sobipro_relations
WHERE ( pid ='77' )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.21 ms After last query: 0.83 ms
SELECT pid
FROM ovl_sobipro_relations
WHERE ( id ='77' )
AND ( pid !='77' )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.19 ms After last query: 0.15 ms
SELECT pid
FROM ovl_sobipro_relations
WHERE ( id ='62' )
AND ( pid !='62' )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.13 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.72 ms After last query: 0.18 ms
SELECT id AS id, sKey AS label, sValue AS value, language
FROM ovl_sobipro_language
WHERE ( id IN ( '77','62','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 ( '77','62','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.31 ms After last query: 0.36 ms
INSERT INTO ovl_sobipro_counter (`sid`,`counter`,`lastUpdate`)
VALUES ('77','2727','2021-01-21 23:24:34')
ON DUPLICATE KEY UPDATE sid = '77',counter = '2727',lastUpdate = '2021-01-21 23:24:34'EXPLAIN not possible on query: INSERT INTO ovl_sobipro_counter (`sid`,`counter`,`lastUpdate`) VALUES ('77','2727','2021-01-21 23:24:34') ON DUPLICATE KEY UPDATE sid = '77',counter = '2727',lastUpdate = '2021-01-21 23:24:34'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.63 ms After last query: 11.89 ms
SELECT *
FROM ovl_sobipro_registry
WHERE ( section ='messages' )
ORDER BY valueid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_sobipro_registry NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 17 10.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/registry.php:141JROOT/components/com_sobipro/lib/base/message.php:42JROOT/components/com_sobipro/lib/base/message.php:179JROOT/components/com_sobipro/lib/base/factory.php:158JROOT/components/com_sobipro/lib/views/view.php:279JROOT/components/com_sobipro/lib/views/section.php:447JROOT/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.16 ms After last query: 0.23 ms
SELECT *
FROM ovl_sobipro_registry
WHERE ( section ='reports' )
ORDER BY valueid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_sobipro_registry NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 17 10.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/registry.php:141JROOT/components/com_sobipro/lib/base/message.php:48JROOT/components/com_sobipro/lib/base/message.php:179JROOT/components/com_sobipro/lib/base/factory.php:158JROOT/components/com_sobipro/lib/views/view.php:279JROOT/components/com_sobipro/lib/views/section.php:447JROOT/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: 1.36 ms After last query: 6.11 ms
SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
FROM ovl_modules AS m
LEFT JOIN ovl_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN ovl_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.client_id = 0
AND m.access IN (1,1,5)
ORDER BY m.ordering, m.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL published,newsfeeds NO INDEX KEY COULD BE USED NULL NULL 145 5.17 Using where; Using filesort 1 SIMPLE am NULL eq_ref PRIMARY PRIMARY 4 db59gacpy8p5zb.m.id 1 100.00 Using where 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 303 db59gacpy8p5zb.m.module,const 1 10.00 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/plugins/system/advancedmodules/modulehelper.php:443JROOT/plugins/system/advancedmodules/modulehelper.php:102JROOT/libraries/joomla/document/html/html.php:497JROOT/templates/overlander/includes/params.php:63JROOT/templates/overlander/index.php:13JROOT/libraries/joomla/document/html/html.php:576JROOT/libraries/joomla/document/html/html.php:634JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:974JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.28 ms After last query: 19.13 ms
SELECT m.menutype
FROM ovl_menu AS m
WHERE m.id = 277id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/plugins/system/nnframework/helpers/assignments/menu.php:80JROOT/plugins/system/nnframework/helpers/assignments/menu.php:28JROOT/plugins/system/nnframework/helpers/assignments.php:345JROOT/plugins/system/nnframework/helpers/assignments.php:290JROOT/plugins/system/advancedmodules/advancedmodules.php:483JROOT/libraries/joomla/event/dispatcher.php:167JROOT/libraries/joomla/application/base.php:106JROOT/plugins/system/advancedmodules/modulehelper.php:496JROOT/plugins/system/advancedmodules/modulehelper.php:102JROOT/libraries/joomla/document/html/html.php:497JROOT/templates/overlander/includes/params.php:63JROOT/templates/overlander/index.php:13JROOT/libraries/joomla/document/html/html.php:576JROOT/libraries/joomla/document/html/html.php:634JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:974JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.17 ms After last query: 3.52 ms
SELECT t.parent_id
FROM ovl_menu as t
WHERE t.id = 277id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/plugins/system/nnframework/helpers/assignment.php:161JROOT/plugins/system/nnframework/helpers/assignments/menu.php:65JROOT/plugins/system/nnframework/helpers/assignments/menu.php:47JROOT/plugins/system/nnframework/helpers/assignments.php:345JROOT/plugins/system/nnframework/helpers/assignments.php:290JROOT/plugins/system/advancedmodules/advancedmodules.php:483JROOT/libraries/joomla/event/dispatcher.php:167JROOT/libraries/joomla/application/base.php:106JROOT/plugins/system/advancedmodules/modulehelper.php:496JROOT/plugins/system/advancedmodules/modulehelper.php:102JROOT/libraries/joomla/document/html/html.php:497JROOT/templates/overlander/includes/params.php:63JROOT/templates/overlander/index.php:13JROOT/libraries/joomla/document/html/html.php:576JROOT/libraries/joomla/document/html/html.php:634JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:974JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.11 ms After last query: 0.09 ms
SELECT t.parent_id
FROM ovl_menu as t
WHERE t.id = 271id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/plugins/system/nnframework/helpers/assignment.php:161JROOT/plugins/system/nnframework/helpers/assignments/menu.php:65JROOT/plugins/system/nnframework/helpers/assignments/menu.php:47JROOT/plugins/system/nnframework/helpers/assignments.php:345JROOT/plugins/system/nnframework/helpers/assignments.php:290JROOT/plugins/system/advancedmodules/advancedmodules.php:483JROOT/libraries/joomla/event/dispatcher.php:167JROOT/libraries/joomla/application/base.php:106JROOT/plugins/system/advancedmodules/modulehelper.php:496JROOT/plugins/system/advancedmodules/modulehelper.php:102JROOT/libraries/joomla/document/html/html.php:497JROOT/templates/overlander/includes/params.php:63JROOT/templates/overlander/index.php:13JROOT/libraries/joomla/document/html/html.php:576JROOT/libraries/joomla/document/html/html.php:634JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:974JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.12 ms After last query: 0.08 ms
SELECT t.parent_id
FROM ovl_menu as t
WHERE t.id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/plugins/system/nnframework/helpers/assignment.php:161JROOT/plugins/system/nnframework/helpers/assignments/menu.php:65JROOT/plugins/system/nnframework/helpers/assignments/menu.php:47JROOT/plugins/system/nnframework/helpers/assignments.php:345JROOT/plugins/system/nnframework/helpers/assignments.php:290JROOT/plugins/system/advancedmodules/advancedmodules.php:483JROOT/libraries/joomla/event/dispatcher.php:167JROOT/libraries/joomla/application/base.php:106JROOT/plugins/system/advancedmodules/modulehelper.php:496JROOT/plugins/system/advancedmodules/modulehelper.php:102JROOT/libraries/joomla/document/html/html.php:497JROOT/templates/overlander/includes/params.php:63JROOT/templates/overlander/index.php:13JROOT/libraries/joomla/document/html/html.php:576JROOT/libraries/joomla/document/html/html.php:634JROOT/libraries/joomla/document/html/html.php:452JROOT/libraries/cms/application/cms.php:974JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.43 ms After last query: 37.65 ms
SELECT *
FROM ovl_banners
WHERE '2021-01-21 23:24:34' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/administrator/components/com_banners/helpers/banners.php:80JROOT/modules/mod_banners/mod_banners.php:19JROOT/plugins/system/advancedmodules/modulehelper.php:196JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.55 ms After last query: 1.44 ms
SELECT COUNT(*)
FROM ovl_banners as a
LEFT JOIN ovl_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state idx_state 1 const 1 20.00 Using where 1 SIMPLE cl NULL eq_ref PRIMARY PRIMARY 4 db59gacpy8p5zb.a.cid 1 100.00 Using index No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/legacy/model/legacy.php:327JROOT/libraries/legacy/model/list.php:276JROOT/libraries/legacy/model/list.php:310JROOT/libraries/legacy/model/list.php:171JROOT/components/com_banners/models/banners.php:192JROOT/modules/mod_banners/helper.php:45JROOT/modules/mod_banners/mod_banners.php:20JROOT/plugins/system/advancedmodules/modulehelper.php:196JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.32 ms After last query: 0.10 ms
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM ovl_banners as a
LEFT JOIN ovl_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state idx_state 1 const 1 20.00 Using index condition; Using where; Using filesort 1 SIMPLE cl NULL eq_ref PRIMARY PRIMARY 4 db59gacpy8p5zb.a.cid 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/legacy/model/legacy.php:301JROOT/libraries/legacy/model/list.php:171JROOT/components/com_banners/models/banners.php:192JROOT/modules/mod_banners/helper.php:45JROOT/modules/mod_banners/mod_banners.php:20JROOT/plugins/system/advancedmodules/modulehelper.php:196JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.33 ms After last query: 0.15 ms
UPDATE ovl_banners
SET impmade = (impmade + 1)
WHERE id = 2id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE ovl_banners NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms updating 0.1 ms end 0.0 ms query end 0.1 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/components/com_banners/models/banners.php:231JROOT/modules/mod_banners/helper.php:46JROOT/modules/mod_banners/mod_banners.php:20JROOT/plugins/system/advancedmodules/modulehelper.php:196JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.22 ms After last query: 0.09 msDuplicate queries: #51
SELECT `count`
FROM ovl_banner_tracks
WHERE track_type=1
AND banner_id=2
AND track_date='2021-01-21 23'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_banner_tracks NULL const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 13 const,const,const 1 100.00 NULL Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.1 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Sending data 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/components/com_banners/models/banners.php:266JROOT/modules/mod_banners/helper.php:46JROOT/modules/mod_banners/mod_banners.php:20JROOT/plugins/system/advancedmodules/modulehelper.php:196JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.13 ms After last query: 0.04 msDuplicate queries: #50
SELECT `count`
FROM ovl_banner_tracks
WHERE track_type=1
AND banner_id=2
AND track_date='2021-01-21 23'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_banner_tracks NULL const PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 13 const,const,const 1 100.00 NULL Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Sending data 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/components/com_banners/models/banners.php:273JROOT/modules/mod_banners/helper.php:46JROOT/modules/mod_banners/mod_banners.php:20JROOT/plugins/system/advancedmodules/modulehelper.php:196JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.27 ms After last query: 0.07 ms
UPDATE ovl_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=2
AND track_date='2021-01-21 23'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE ovl_banner_tracks NULL range PRIMARY,idx_track_date,idx_track_type,idx_banner_id PRIMARY 13 const,const,const 1 100.00 Using where Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.1 ms updating 0.1 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/components/com_banners/models/banners.php:303JROOT/modules/mod_banners/helper.php:46JROOT/modules/mod_banners/mod_banners.php:20JROOT/plugins/system/advancedmodules/modulehelper.php:196JROOT/libraries/joomla/document/html/renderer/module.php:105JROOT/libraries/joomla/document/html/renderer/modules.php:46JROOT/libraries/joomla/document/html/html.php:408JROOT/libraries/joomla/document/html/html.php:696JROOT/libraries/joomla/document/html/html.php:474JROOT/libraries/cms/application/cms.php:988JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 1.20 ms After last query: 41.28 ms
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLESStatus Duration starting 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms checking permissions 0.8 ms Sending data 0.1 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms removing tmp table 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/libraries/f0f/table/table.php:2061JROOT/libraries/f0f/table/table.php:536JROOT/libraries/extly/tables/extension.php:33JROOT/libraries/f0f/table/table.php:433JROOT/libraries/f0f/model/model.php:2037JROOT/libraries/f0f/model/model.php:1994JROOT/libraries/extly/models/extensions.php:75JROOT/libraries/f0f/model/model.php:1219JROOT/libraries/extly/helpers/extension.php:78JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:40JROOT/plugins/system/xtdir/xtdir.php:38JROOT/plugins/system/xtdir/xtdir.php:99JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:994JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.54 ms After last query: 0.24 ms
SHOW FULL COLUMNS
FROM `ovl_extensions`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `ovl_extensions`Status Duration starting 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.1 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Opening tables 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Sending data 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms removing tmp table 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/libraries/f0f/table/table.php:2146JROOT/libraries/f0f/table/table.php:536JROOT/libraries/extly/tables/extension.php:33JROOT/libraries/f0f/table/table.php:433JROOT/libraries/f0f/model/model.php:2037JROOT/libraries/f0f/model/model.php:1994JROOT/libraries/extly/models/extensions.php:75JROOT/libraries/f0f/model/model.php:1219JROOT/libraries/extly/helpers/extension.php:78JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:40JROOT/plugins/system/xtdir/xtdir.php:38JROOT/plugins/system/xtdir/xtdir.php:99JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:994JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.35 ms After last query: 1.10 ms
SELECT *
FROM `ovl_extensions`
WHERE `folder` = 'system'
AND `element` = 'xtdir'
ORDER BY extension_id ASC
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_extensions NULL ref element_clientid,element_folder_clientid element_clientid 302 const 1 10.00 Using index condition; Using where; Using filesort Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.1 ms preparing 0.0 ms Sorting result 0.0 ms executing 0.0 ms Sending data 0.0 ms Creating sort index 0.1 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/libraries/f0f/model/model.php:1953JROOT/libraries/f0f/model/model.php:1225JROOT/libraries/extly/helpers/extension.php:78JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:40JROOT/plugins/system/xtdir/xtdir.php:38JROOT/plugins/system/xtdir/xtdir.php:99JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:994JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.33 ms After last query: 0.74 ms
SELECT *
FROM `ovl_extensions`
WHERE `folder` = 'system'
AND `element` = 'xtdir'
ORDER BY extension_id ASC
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_extensions NULL ref element_clientid,element_folder_clientid element_clientid 302 const 1 10.00 Using index condition; Using where; Using filesort Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.1 ms preparing 0.0 ms Sorting result 0.0 ms executing 0.0 ms Sending data 0.0 ms Creating sort index 0.1 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/libraries/f0f/model/model.php:1953JROOT/libraries/f0f/model/model.php:1225JROOT/libraries/extly/helpers/extension.php:78JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:42JROOT/plugins/system/xtdir/xtdir.php:38JROOT/plugins/system/xtdir/xtdir.php:99JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:994JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.29 ms After last query: 0.51 ms
SELECT *
FROM `ovl_extensions`
WHERE `folder` = 'system'
AND `element` = 'xtdir'
ORDER BY extension_id ASC
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_extensions NULL ref element_clientid,element_folder_clientid element_clientid 302 const 1 10.00 Using index condition; Using where; Using filesort Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms Sorting result 0.0 ms executing 0.0 ms Sending data 0.0 ms Creating sort index 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/libraries/f0f/model/model.php:1953JROOT/libraries/f0f/model/model.php:1225JROOT/libraries/extly/helpers/extension.php:78JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:43JROOT/plugins/system/xtdir/xtdir.php:38JROOT/plugins/system/xtdir/xtdir.php:99JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:994JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.32 ms After last query: 0.41 ms
SELECT last_update
FROM `ovl_xtdir_trees`
ORDER BY id desc
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_xtdir_trees NULL index NULL id 4 NULL 1 100.00 NULL Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.1 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms Sorting result 0.0 ms executing 0.0 ms Sending data 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:648JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:58JROOT/plugins/system/xtdir/xtdir.php:39JROOT/plugins/system/xtdir/xtdir.php:99JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:994JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.16 ms After last query: 0.13 ms
SELECT id, last_update
FROM `ovl_xtdir_trees`
ORDER BY id desc
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_xtdir_trees NULL index NULL id 4 NULL 1 100.00 NULL Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms Sorting result 0.0 ms executing 0.0 ms Sending data 0.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:195JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:115JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:80JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:66JROOT/plugins/system/xtdir/xtdir.php:39JROOT/plugins/system/xtdir/xtdir.php:99JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:994JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.23 ms After last query: 0.07 ms
SELECT count(*)
FROM `ovl_sobipro_object`
WHERE updatedTime > '2020-09-11 07:39:03'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE ovl_sobipro_object NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 79 33.33 Using where Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Sending data 0.1 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:214JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:115JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:80JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:66JROOT/plugins/system/xtdir/xtdir.php:39JROOT/plugins/system/xtdir/xtdir.php:99JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:994JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.60 ms After last query: 0.07 ms
SELECT count(*)
FROM `ovl_sobipro_field_data` AS `d`
WHERE updatedTime > '2020-09-11 07:39:03'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE d NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 582 33.33 Using where Status Duration starting 0.0 ms checking permissions 0.0 ms Opening tables 0.1 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Sending data 0.3 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:230JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:115JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:80JROOT/administrator/components/com_xtdir/helpers/treeindexer.php:66JROOT/plugins/system/xtdir/xtdir.php:39JROOT/plugins/system/xtdir/xtdir.php:99JROOT/libraries/joomla/event/event.php:71JROOT/libraries/joomla/event/dispatcher.php:162JROOT/libraries/joomla/application/base.php:106JROOT/libraries/cms/application/cms.php:994JROOT/libraries/cms/application/site.php:731JROOT/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.39 ms After last query: 1.74 ms
UPDATE `ovl_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1611271474;s:18:\"session.timer.last\";i:1611271474;s:17:\"session.timer.now\";i:1611271474;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:11:\"com_sobipro\";O:8:\"stdClass\":3:{s:8:\"back_url\";s:36:\"/dir-outdoorequipment/dir-water.html\";s:27:\"currently-displayed-entries\";a:0:{}s:14:\"messages-queue\";a:0:{}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1611271474'
WHERE `session_id` = '5ksblg8uqaj8eub5f7vokj6o46'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE ovl_session NULL range PRIMARY PRIMARY 602 const 1 100.00 Using where Status Duration starting 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms updating 0.1 ms end 0.0 ms query end 0.1 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/libraries/joomla/session/storage/database.php:85
46 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
6 × SELECT pid
FROM ovl_sobipro_relations3 × SELECT t.parent_id
FROM ovl_menu as t3 × SELECT *
FROM `ovl_extensions`2 × SELECT pid
FROM ovl_sobipro_plugin_task2 × SELECT id AS id, sKey AS label, sValue AS value, language
FROM ovl_sobipro_language2 × SELECT *
FROM ovl_sobipro_registry2 × SELECT `count`
FROM ovl_banner_tracks2 × SELECT DISTINCT spo.id
FROM ovl_sobipro_relations AS sprl
LEFT JOIN ovl_sobipro_object AS spo
ON sprl.id = spo.id2 × SELECT pid
FROM ovl_sobipro_plugin_section2 × SELECT *
FROM ovl_sobipro_object1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down
FROM ovl_modules AS m
LEFT JOIN ovl_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN ovl_advancedmodules as am
ON am.moduleid = m.id1 × SELECT count(*)
FROM `ovl_sobipro_field_data` AS `d`1 × SELECT nid,id
FROM ovl_sobipro_object1 × SELECT id,oType
FROM ovl_sobipro_relations1 × SELECT m.menutype
FROM ovl_menu AS m1 × SELECT *
FROM ovl_banners1 × SELECT last_update
FROM `ovl_xtdir_trees`1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM ovl_banners as a
LEFT JOIN ovl_banner_clients AS cl
ON cl.id = a.cid1 × SELECT id, last_update
FROM `ovl_xtdir_trees`1 × SELECT COUNT(*)
FROM ovl_banners as a
LEFT JOIN ovl_banner_clients AS cl
ON cl.id = a.cid1 × SELECT count(*)
FROM `ovl_sobipro_object`1 × SELECT position,pid
FROM ovl_sobipro_relations1 × SELECT cSection AS configsection,sKey AS sKey,sValue AS sValue
FROM ovl_sobipro_config1 × SELECT *
FROM ovl_sobipro_field1 × SELECT sValue,sKey
FROM ovl_sobipro_language1 × 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_id1 × SELECT id, rules
FROM `ovl_viewlevels1 × SELECT `session_id`
FROM `ovl_session`1 × SELECT b.id
FROM ovl_usergroups AS a
LEFT JOIN ovl_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT rel.gid
FROM ovl_sobipro_user_group AS grp
LEFT JOIN ovl_sobipro_users_relation AS rel
ON grp.gid = rel.gid1 × SELECT parent.id, parent.lft, parent.rgt
FROM ovl_usergroups AS parent1 × SELECT DISTINCT sprl.rid
FROM ovl_sobipro_permissions_groups AS spgr
LEFT JOIN ovl_sobipro_permissions_rules AS sprl
ON spgr.rid = sprl.rid1 × SELECT pid
FROM ovl_sobipro_permissions_map1 × SELECT `data`
FROM `ovl_session`1 × SELECT sValue, sKey
FROM ovl_sobipro_language1 × SELECT *
FROM ovl_sobipro_category1 × SELECT counter
FROM ovl_sobipro_counter1 × SELECT *
FROM ovl_sobipro_permissions
OTHER Tables:
1 × SHOW TABLE
1 × SHOW FULL COLUMNS
FROM `ovl_extensions1 × UPDATE `ovl_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1611271474;s:18:\"session.timer.last\";i:1611271474;s:17:\"session.timer.now\";i:1611271474;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:11:\"com_sobipro\";O:8:\"stdClass\":3:{s:8:\"back_url\";s:36:\"/dir-outdoorequipment/dir-water.html\";s:27:\"currently-displayed-entries\";a:0:{}s:14:\"messages-queue\";a:0:{}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1611271474'1 × UPDATE ovl_banner_tracks
SET `count` = (`count` + 1)1 × UPDATE ovl_banners
SET impmade = (impmade + 1)1 × UPDATE `ovl_extensions`
SET `params` = '{\"mediaversion\":\"a82b99297964cdd4526b40259645be54\"}'1 × INSERT INTO ovl_sobipro_counter (`sid`,`counter`,`lastUpdate`)
VALUES ('77','2727','2021-01-21 23:24:34')
ON DUPLICATE KEY UPDATE sid = '77',counter = '2727',lastUpdate = '2021-01-21 23:24:341 × INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`)
VALUES ('5ksblg8uqaj8eub5f7vokj6o46', 0, '1611271474'