Joomla! Debug Console
Time
Memory
Time: 0.0 ms / 0.0 ms Memory: 0.636 MB / 0.64 MB Application: afterLoad
Time: 39.8 ms / 39.8 ms Memory: 5.483 MB / 6.12 MB Application: afterInitialise
Time: 19.7 ms / 59.5 ms Memory: 2.893 MB / 9.01 MB Application: afterRoute
Time: 83.7 ms / 143.2 ms Memory: 11.377 MB / 20.39 MB Application: afterDispatch
Time: 40.1 ms / 183.3 ms Memory: 3.000 MB / 23.39 MB Application: beforeRenderModule mod_menu (Footer Menu)
Time: 2.1 ms / 185.4 ms Memory: 0.123 MB / 23.51 MB Application: afterRenderModule mod_menu (Footer Menu)
Time: 0.9 ms / 186.3 ms Memory: 0.000 MB / 23.49 MB Application: beforeRenderModule mod_search (search)
Time: 1.6 ms / 187.9 ms Memory: 0.040 MB / 23.53 MB Application: afterRenderModule mod_search (search)
Time: 0.1 ms / 188.0 ms Memory: 0.000 MB / 23.52 MB Application: beforeRenderModule mod_banners (Head Add Banner)
Time: 7.8 ms / 195.8 ms Memory: 0.511 MB / 24.03 MB Application: afterRenderModule mod_banners (Head Add Banner)
Time: 0.3 ms / 196.1 ms Memory: 0.013 MB / 24.04 MB Application: beforeRenderModule mod_date2 (Date2)
Time: 2.9 ms / 199.0 ms Memory: 0.312 MB / 24.35 MB Application: afterRenderModule mod_date2 (Date2)
Time: 0.1 ms / 199.1 ms Memory: 0.000 MB / 24.30 MB Application: beforeRenderModule mod_menu (Top Menue)
Time: 0.7 ms / 199.8 ms Memory: 0.031 MB / 24.33 MB Application: afterRenderModule mod_menu (Top Menue)
Time: 0.1 ms / 199.9 ms Memory: 0.000 MB / 24.31 MB Application: beforeRenderModule mod_menu (Social Media Buttons)
Time: 1.1 ms / 201.0 ms Memory: 0.076 MB / 24.38 MB Application: afterRenderModule mod_menu (Social Media Buttons)
Time: 50.0 ms / 251.0 ms Memory: 3.063 MB / 27.45 MB Application: afterRender
Database queries total: 14.3 ms
27.8 MB (29,146,240 Bytes)
28 Queries Logged 14.3 ms
- Query Time: 1.81 ms
SELECT `data`
FROM `ovl_session`
WHERE `session_id` = '27m0c9b9ulb5nlbkjvh3bt3ke1'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.25 ms After last query: 1.18 ms
SELECT `session_id`
FROM `ovl_session`
WHERE `session_id` = '27m0c9b9ulb5nlbkjvh3bt3ke1'
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.25 ms After last query: 0.09 ms
INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`)
VALUES ('27m0c9b9ulb5nlbkjvh3bt3ke1', 0, '1607194416')EXPLAIN not possible on query: INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`) VALUES ('27m0c9b9ulb5nlbkjvh3bt3ke1', 0, '1607194416')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.61 ms After last query: 3.21 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.32 ms After last query: 0.44 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.16 ms After last query: 21.07 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.41 ms After last query: 11.18 ms
UPDATE `ovl_extensions`
SET `params` = '{\"mediaversion\":\"55cf63e739ec1db8608c48fb47a2f21f\"}'
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: 1.76 ms After last query: 91.76 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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: 21.69 ms
SELECT m.menutype
FROM ovl_menu AS m
WHERE m.id = 106id 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.42 ms
SELECT t.parent_id
FROM ovl_menu as t
WHERE t.id = 106id 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.12 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.51 ms After last query: 18.85 ms
SELECT *
FROM ovl_banners
WHERE '2020-12-05 18:53:36' >= '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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.70 ms After last query: 2.10 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.15 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.23 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 Waiting for query cache lock 0.0 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.37 ms After last query: 0.12 msDuplicate queries: #17
SELECT `count`
FROM ovl_banner_tracks
WHERE track_type=1
AND banner_id=2
AND track_date='2020-12-05 18'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.2 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.09 msDuplicate queries: #16
SELECT `count`
FROM ovl_banner_tracks
WHERE track_type=1
AND banner_id=2
AND track_date='2020-12-05 18'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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.26 ms After last query: 0.11 ms
UPDATE ovl_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=2
AND track_date='2020-12-05 18'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.0 ms end 0.0 ms Waiting for query cache lock 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: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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.10 ms After last query: 46.98 ms
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLESStatus Duration starting 0.1 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 checking permissions 0.6 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.1 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.52 ms After last query: 0.37 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.2 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Opening tables 0.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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.26 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.1 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.89 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: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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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: 0.59 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.48 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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: 0.14 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.10 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.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.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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.56 ms After last query: 0.09 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/components/com_p8pbb/p8pbb.php:730JROOT/forum/includes/hooks/index.php:143JROOT/forum/includes/functions.php:5568JROOT/forum/includes/functions.php:5521JROOT/forum/cache/data_php_search.php:1527JROOT/components/com_p8pbb/controller.php:113JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_p8pbb/p8pbb.php:1638JROOT/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.97 ms
UPDATE `ovl_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1607194416;s:18:\"session.timer.last\";i:1607194416;s:17:\"session.timer.now\";i:1607194416;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\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{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;s:5:\"phpbb\";a:82:{s:7:\"user_id\";i:1;s:9:\"user_type\";s:1:\"2\";s:8:\"group_id\";s:1:\"1\";s:14:\"user_perm_from\";s:1:\"0\";s:7:\"user_ip\";s:0:\"\";s:12:\"user_regdate\";s:10:\"1265626827\";s:8:\"username\";s:9:\"Anonymous\";s:14:\"username_clean\";s:9:\"anonymous\";s:13:\"user_password\";s:0:\"\";s:12:\"user_passchg\";s:1:\"0\";s:10:\"user_email\";s:0:\"\";s:15:\"user_email_hash\";s:1:\"0\";s:13:\"user_birthday\";s:0:\"\";s:14:\"user_lastvisit\";s:1:\"0\";s:13:\"user_lastmark\";s:1:\"0\";s:18:\"user_lastpost_time\";s:10:\"1434992131\";s:13:\"user_lastpage\";s:0:\"\";s:21:\"user_last_confirm_key\";s:10:\"1808GIVQOU\";s:16:\"user_last_search\";s:10:\"1607194275\";s:13:\"user_warnings\";s:1:\"0\";s:17:\"user_last_warning\";s:1:\"0\";s:19:\"user_login_attempts\";s:1:\"2\";s:20:\"user_inactive_reason\";s:1:\"0\";s:18:\"user_inactive_time\";s:1:\"0\";s:10:\"user_posts\";s:1:\"0\";s:9:\"user_lang\";s:2:\"en\";s:13:\"user_timezone\";s:3:\"UTC\";s:15:\"user_dateformat\";s:9:\"d M Y H:i\";s:10:\"user_style\";s:1:\"3\";s:9:\"user_rank\";s:1:\"0\";s:11:\"user_colour\";s:0:\"\";s:16:\"user_new_privmsg\";s:1:\"0\";s:19:\"user_unread_privmsg\";s:1:\"0\";s:17:\"user_last_privmsg\";s:1:\"0\";s:18:\"user_message_rules\";s:1:\"0\";s:16:\"user_full_folder\";s:2:\"-3\";s:14:\"user_emailtime\";s:10:\"1606890254\";s:20:\"user_topic_show_days\";s:1:\"0\";s:22:\"user_topic_sortby_type\";s:1:\"t\";s:21:\"user_topic_sortby_dir\";s:1:\"d\";s:19:\"user_post_show_days\";s:1:\"0\";s:21:\"user_post_sortby_type\";s:1:\"t\";s:20:\"user_post_sortby_dir\";s:1:\"a\";s:11:\"user_notify\";s:1:\"0\";s:14:\"user_notify_pm\";s:1:\"0\";s:16:\"user_notify_type\";s:1:\"0\";s:13:\"user_allow_pm\";s:1:\"0\";s:21:\"user_allow_viewonline\";s:1:\"1\";s:20:\"user_allow_viewemail\";s:1:\"0\";s:20:\"user_allow_massemail\";s:1:\"0\";s:12:\"user_options\";s:6:\"229425\";s:11:\"user_avatar\";s:0:\"\";s:16:\"user_avatar_type\";s:0:\"\";s:17:\"user_avatar_width\";s:1:\"0\";s:18:\"user_avatar_height\";s:1:\"0\";s:8:\"user_sig\";s:0:\"\";s:19:\"user_sig_bbcode_uid\";s:0:\"\";s:24:\"user_sig_bbcode_bitfield\";s:0:\"\";s:11:\"user_jabber\";s:0:\"\";s:11:\"user_actkey\";s:0:\"\";s:14:\"user_newpasswd\";s:0:\"\";s:14:\"user_form_salt\";s:16:\"e9b72229b66760bd\";s:8:\"user_new\";s:1:\"0\";s:13:\"user_reminded\";s:1:\"0\";s:18:\"user_reminded_time\";s:1:\"0\";s:18:\"session_last_visit\";i:1607194416;s:13:\"is_registered\";b:0;s:6:\"is_bot\";b:0;s:15:\"session_created\";b:1;s:10:\"session_id\";s:32:\"3e2d034c49b72c3f585a5ae4580c7634\";s:15:\"session_user_id\";i:1;s:13:\"session_start\";i:1607194416;s:12:\"session_time\";i:1607194416;s:15:\"session_browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:21:\"session_forwarded_for\";s:0:\"\";s:10:\"session_ip\";s:12:\"3.219.31.204\";s:17:\"session_autologin\";i:0;s:13:\"session_admin\";i:0;s:18:\"session_viewonline\";i:1;s:12:\"session_page\";s:10:\"search.php\";s:16:\"session_forum_id\";i:0;s:32:\"hash_mark_all_notifications_read\";s:8:\"0a668d15\";}}s:13:\"session.token\";s:32:\"ef0db7707092828024001ca6433abad5\";}' , `time` = '1607194416'
WHERE `session_id` = '27m0c9b9ulb5nlbkjvh3bt3ke1'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 Waiting for query cache lock 0.0 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
24 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
3 × SELECT *
FROM `ovl_extensions`2 × SELECT t.parent_id
FROM ovl_menu as t2 × SELECT `count`
FROM ovl_banner_tracks1 × 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 last_update
FROM `ovl_xtdir_trees`1 × SELECT count(*)
FROM `ovl_sobipro_field_data` AS `d`1 × SELECT count(*)
FROM `ovl_sobipro_object`1 × 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 *
FROM ovl_banners1 × 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 `session_id`
FROM `ovl_session`1 × SELECT id, rules
FROM `ovl_viewlevels1 × 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 m.menutype
FROM ovl_menu AS m1 × 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 `data`
FROM `ovl_session`
OTHER Tables:
1 × SHOW FULL COLUMNS
FROM `ovl_extensions1 × UPDATE `ovl_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1607194416;s:18:\"session.timer.last\";i:1607194416;s:17:\"session.timer.now\";i:1607194416;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\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{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;s:5:\"phpbb\";a:82:{s:7:\"user_id\";i:1;s:9:\"user_type\";s:1:\"2\";s:8:\"group_id\";s:1:\"1\";s:14:\"user_perm_from\";s:1:\"0\";s:7:\"user_ip\";s:0:\"\";s:12:\"user_regdate\";s:10:\"1265626827\";s:8:\"username\";s:9:\"Anonymous\";s:14:\"username_clean\";s:9:\"anonymous\";s:13:\"user_password\";s:0:\"\";s:12:\"user_passchg\";s:1:\"0\";s:10:\"user_email\";s:0:\"\";s:15:\"user_email_hash\";s:1:\"0\";s:13:\"user_birthday\";s:0:\"\";s:14:\"user_lastvisit\";s:1:\"0\";s:13:\"user_lastmark\";s:1:\"0\";s:18:\"user_lastpost_time\";s:10:\"1434992131\";s:13:\"user_lastpage\";s:0:\"\";s:21:\"user_last_confirm_key\";s:10:\"1808GIVQOU\";s:16:\"user_last_search\";s:10:\"1607194275\";s:13:\"user_warnings\";s:1:\"0\";s:17:\"user_last_warning\";s:1:\"0\";s:19:\"user_login_attempts\";s:1:\"2\";s:20:\"user_inactive_reason\";s:1:\"0\";s:18:\"user_inactive_time\";s:1:\"0\";s:10:\"user_posts\";s:1:\"0\";s:9:\"user_lang\";s:2:\"en\";s:13:\"user_timezone\";s:3:\"UTC\";s:15:\"user_dateformat\";s:9:\"d M Y H:i\";s:10:\"user_style\";s:1:\"3\";s:9:\"user_rank\";s:1:\"0\";s:11:\"user_colour\";s:0:\"\";s:16:\"user_new_privmsg\";s:1:\"0\";s:19:\"user_unread_privmsg\";s:1:\"0\";s:17:\"user_last_privmsg\";s:1:\"0\";s:18:\"user_message_rules\";s:1:\"0\";s:16:\"user_full_folder\";s:2:\"-3\";s:14:\"user_emailtime\";s:10:\"1606890254\";s:20:\"user_topic_show_days\";s:1:\"0\";s:22:\"user_topic_sortby_type\";s:1:\"t\";s:21:\"user_topic_sortby_dir\";s:1:\"d\";s:19:\"user_post_show_days\";s:1:\"0\";s:21:\"user_post_sortby_type\";s:1:\"t\";s:20:\"user_post_sortby_dir\";s:1:\"a\";s:11:\"user_notify\";s:1:\"0\";s:14:\"user_notify_pm\";s:1:\"0\";s:16:\"user_notify_type\";s:1:\"0\";s:13:\"user_allow_pm\";s:1:\"0\";s:21:\"user_allow_viewonline\";s:1:\"1\";s:20:\"user_allow_viewemail\";s:1:\"0\";s:20:\"user_allow_massemail\";s:1:\"0\";s:12:\"user_options\";s:6:\"229425\";s:11:\"user_avatar\";s:0:\"\";s:16:\"user_avatar_type\";s:0:\"\";s:17:\"user_avatar_width\";s:1:\"0\";s:18:\"user_avatar_height\";s:1:\"0\";s:8:\"user_sig\";s:0:\"\";s:19:\"user_sig_bbcode_uid\";s:0:\"\";s:24:\"user_sig_bbcode_bitfield\";s:0:\"\";s:11:\"user_jabber\";s:0:\"\";s:11:\"user_actkey\";s:0:\"\";s:14:\"user_newpasswd\";s:0:\"\";s:14:\"user_form_salt\";s:16:\"e9b72229b66760bd\";s:8:\"user_new\";s:1:\"0\";s:13:\"user_reminded\";s:1:\"0\";s:18:\"user_reminded_time\";s:1:\"0\";s:18:\"session_last_visit\";i:1607194416;s:13:\"is_registered\";b:0;s:6:\"is_bot\";b:0;s:15:\"session_created\";b:1;s:10:\"session_id\";s:32:\"3e2d034c49b72c3f585a5ae4580c7634\";s:15:\"session_user_id\";i:1;s:13:\"session_start\";i:1607194416;s:12:\"session_time\";i:1607194416;s:15:\"session_browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:21:\"session_forwarded_for\";s:0:\"\";s:10:\"session_ip\";s:12:\"3.219.31.204\";s:17:\"session_autologin\";i:0;s:13:\"session_admin\";i:0;s:18:\"session_viewonline\";i:1;s:12:\"session_page\";s:10:\"search.php\";s:16:\"session_forum_id\";i:0;s:32:\"hash_mark_all_notifications_read\";s:8:\"0a668d15\";}}s:13:\"session.token\";s:32:\"ef0db7707092828024001ca6433abad5\";}' , `time` = '1607194416'1 × SHOW TABLE
1 × UPDATE ovl_banner_tracks
SET `count` = (`count` + 1)1 × UPDATE `ovl_extensions`
SET `params` = '{\"mediaversion\":\"55cf63e739ec1db8608c48fb47a2f21f\"}'1 × UPDATE ovl_banners
SET impmade = (impmade + 1)1 × INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`)
VALUES ('27m0c9b9ulb5nlbkjvh3bt3ke1', 0, '1607194416'