Joomla! Debug Console
Time
Memory
Time: 0.0 ms / 0.0 ms Memory: 0.635 MB / 0.63 MB Application: afterLoad
Time: 41.1 ms / 41.1 ms Memory: 5.490 MB / 6.13 MB Application: afterInitialise
Time: 15.9 ms / 57.0 ms Memory: 2.268 MB / 8.39 MB Application: afterRoute
Time: 31.3 ms / 88.2 ms Memory: 1.539 MB / 9.93 MB Application: afterDispatch
Time: 32.0 ms / 120.3 ms Memory: 2.671 MB / 12.60 MB Application: beforeRenderModule mod_menu (Footer Menu)
Time: 2.8 ms / 123.1 ms Memory: 0.091 MB / 12.69 MB Application: afterRenderModule mod_menu (Footer Menu)
Time: 0.6 ms / 123.6 ms Memory: 0.007 MB / 12.70 MB Application: beforeRenderModule mod_articleplacedanywhere (front teaser article)
Time: 15.4 ms / 139.0 ms Memory: 0.949 MB / 13.65 MB Application: afterRenderModule mod_articleplacedanywhere (front teaser article)
Time: 0.3 ms / 139.3 ms Memory: 0.000 MB / 13.63 MB Application: beforeRenderModule mod_custom (newsletter-form (2))
Time: 0.5 ms / 139.9 ms Memory: 0.011 MB / 13.64 MB Application: afterRenderModule mod_custom (newsletter-form (2))
Time: 0.3 ms / 140.1 ms Memory: 0.000 MB / 13.63 MB Application: beforeRenderModule mod_custom (Vehicles for sale fp)
Time: 0.2 ms / 140.3 ms Memory: 0.008 MB / 13.64 MB Application: afterRenderModule mod_custom (Vehicles for sale fp)
Time: 0.1 ms / 140.4 ms Memory: 0.000 MB / 13.64 MB Application: beforeRenderModule mod_custom (visit the shop box)
Time: 0.2 ms / 140.6 ms Memory: 0.008 MB / 13.65 MB Application: afterRenderModule mod_custom (visit the shop box)
Time: 0.1 ms / 140.7 ms Memory: 0.000 MB / 13.64 MB Application: beforeRenderModule mod_custom (theForumBox)
Time: 0.2 ms / 140.8 ms Memory: 0.008 MB / 13.65 MB Application: afterRenderModule mod_custom (theForumBox)
Time: 0.1 ms / 140.9 ms Memory: 0.003 MB / 13.65 MB Application: beforeRenderModule mod_djimageslider (DJ-ImageSlider)
Time: 5.7 ms / 146.6 ms Memory: 0.194 MB / 13.85 MB Application: afterRenderModule mod_djimageslider (DJ-ImageSlider)
Time: 0.3 ms / 146.9 ms Memory: 0.000 MB / 13.83 MB Application: beforeRenderModule mod_search (search)
Time: 1.0 ms / 147.9 ms Memory: 0.036 MB / 13.87 MB Application: afterRenderModule mod_search (search)
Time: 0.1 ms / 148.0 ms Memory: 0.000 MB / 13.86 MB Application: beforeRenderModule mod_banners (Head Add Banner)
Time: 5.4 ms / 153.5 ms Memory: 0.312 MB / 14.17 MB Application: afterRenderModule mod_banners (Head Add Banner)
Time: 0.3 ms / 153.8 ms Memory: 0.013 MB / 14.18 MB Application: beforeRenderModule mod_date2 (Date2)
Time: 2.4 ms / 156.1 ms Memory: 0.311 MB / 14.50 MB Application: afterRenderModule mod_date2 (Date2)
Time: 0.1 ms / 156.2 ms Memory: 0.000 MB / 14.45 MB Application: beforeRenderModule mod_menu (Top Menue)
Time: 2.0 ms / 158.2 ms Memory: 0.049 MB / 14.49 MB Application: afterRenderModule mod_menu (Top Menue)
Time: 0.1 ms / 158.2 ms Memory: 0.000 MB / 14.49 MB Application: beforeRenderModule mod_menu (Social Media Buttons)
Time: 2.0 ms / 160.2 ms Memory: 0.049 MB / 14.54 MB Application: afterRenderModule mod_menu (Social Media Buttons)
Time: 42.6 ms / 202.8 ms Memory: 2.878 MB / 17.41 MB Application: afterRender
Database queries total: 44.6 ms
17.82 MB (18,681,944 Bytes)
38 Queries Logged 44.6 ms
- Query Time: 0.95 ms
SELECT `data`
FROM `ovl_session`
WHERE `session_id` = 'gm8lms7662bpoffollkempf3o7'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: 2.56 ms After last query: 1.38 ms
DELETE
FROM `ovl_session`
WHERE `time` < '1603848481'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 DELETE ovl_session NULL range time time 45 const 1 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/application/cms.php:685JROOT/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.64 ms After last query: 0.13 ms
SELECT `session_id`
FROM `ovl_session`
WHERE `session_id` = 'gm8lms7662bpoffollkempf3o7'
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.22 ms After last query: 0.13 ms
INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`)
VALUES ('gm8lms7662bpoffollkempf3o7', 0, '1603852081')EXPLAIN not possible on query: INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`) VALUES ('gm8lms7662bpoffollkempf3o7', 0, '1603852081')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.66 ms After last query: 3.12 ms
SELECT b.id
FROM ovl_usergroups AS a
LEFT JOIN ovl_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 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.29 ms After last query: 0.42 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.05 ms After last query: 20.73 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.37 ms After last query: 6.87 ms
UPDATE `ovl_extensions`
SET `params` = '{\"mediaversion\":\"cbb7b29d4d3efd8f34025c20c12a9906\"}'
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: 4.79 ms After last query: 12.46 ms
SELECT a.rules
FROM ovl_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftid 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 No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:248JROOT/libraries/joomla/user/user.php:364JROOT/components/com_content/models/articles.php:107JROOT/components/com_content/models/featured.php:39JROOT/libraries/legacy/model/legacy.php:415JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:48JROOT/libraries/joomla/cache/controller/view.php:98JROOT/libraries/legacy/controller/legacy.php:689JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_content/content.php:16JROOT/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: 2.32 ms After last query: 0.46 ms
SELECT b.rules
FROM ovl_assets AS a
LEFT JOIN ovl_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const idx_asset_name idx_asset_name 152 const 1 100.00 Using temporary; Using filesort 1 SIMPLE b NULL range idx_lft_rgt idx_lft_rgt 4 NULL 10 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:248JROOT/libraries/joomla/access/access.php:109JROOT/libraries/joomla/user/user.php:373JROOT/components/com_content/models/articles.php:107JROOT/components/com_content/models/featured.php:39JROOT/libraries/legacy/model/legacy.php:415JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:48JROOT/libraries/joomla/cache/controller/view.php:98JROOT/libraries/legacy/controller/legacy.php:689JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_content/content.php:16JROOT/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: 12.30 ms After last query: 0.59 ms
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM ovl_content AS a
LEFT JOIN ovl_categories AS c
ON c.id = a.catid
LEFT JOIN ovl_users AS ua
ON ua.id = a.created_by
LEFT JOIN ovl_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ovl_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ovl_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ovl_categories AS cat JOIN ovl_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN ovl_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-28 02:28:01')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-28 02:28:01')
ORDER BY c.lft, a.featured DESC, fp.ordering,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 0, 4id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY fp NULL ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using temporary; Using filesort 1 PRIMARY a NULL eq_ref PRIMARY,idx_access,idx_catid PRIMARY 4 db59gacpy8p5zb.fp.content_id 1 16.00 Using where 1 PRIMARY c NULL eq_ref PRIMARY,idx_access PRIMARY 4 db59gacpy8p5zb.a.catid 1 100.00 Using where 1 PRIMARY ua NULL eq_ref PRIMARY PRIMARY 4 db59gacpy8p5zb.a.created_by 1 100.00 Using where 1 PRIMARY uam NULL eq_ref PRIMARY PRIMARY 4 db59gacpy8p5zb.a.modified_by 1 100.00 Using where 1 PRIMARY parent NULL eq_ref PRIMARY PRIMARY 4 db59gacpy8p5zb.c.parent_id 1 100.00 Using where 1 PRIMARY v NULL eq_ref PRIMARY PRIMARY 4 db59gacpy8p5zb.a.id 1 100.00 Using where 1 PRIMARY <derived2> NULL ref <auto_key0> <auto_key0> 4 db59gacpy8p5zb.c.id 2 100.00 Using where; Using index 2 DERIVED parent NULL range cat_idx,idx_left_right cat_idx 153 NULL 2 100.00 Using index condition; Using temporary; Using filesort 2 DERIVED cat NULL index PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language idx_left_right 8 NULL 22 11.11 Using where; Using index; Using join buffer (Block Nested Loop) 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_content/models/articles.php:537JROOT/components/com_content/models/featured.php:84JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:49JROOT/libraries/joomla/cache/controller/view.php:98JROOT/libraries/legacy/controller/legacy.php:689JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_content/content.php:16JROOT/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: 1.06 ms
SELECT COUNT(*)
FROM ovl_content AS a
LEFT JOIN ovl_categories AS c
ON c.id = a.catid
LEFT JOIN ovl_users AS ua
ON ua.id = a.created_by
LEFT JOIN ovl_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ovl_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ovl_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ovl_categories AS cat JOIN ovl_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
INNER JOIN ovl_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-28 02:28:01')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-28 02:28:01')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY fp NULL index PRIMARY PRIMARY 4 NULL 1 100.00 Using index 1 PRIMARY a NULL eq_ref PRIMARY,idx_access,idx_catid PRIMARY 4 db59gacpy8p5zb.fp.content_id 1 16.00 Using where 1 PRIMARY c NULL eq_ref PRIMARY,idx_access PRIMARY 4 db59gacpy8p5zb.a.catid 1 100.00 Using where 1 PRIMARY ua NULL eq_ref PRIMARY PRIMARY 4 db59gacpy8p5zb.a.created_by 1 100.00 Using where; Using index 1 PRIMARY uam NULL eq_ref PRIMARY PRIMARY 4 db59gacpy8p5zb.a.modified_by 1 100.00 Using where; Using index 1 PRIMARY parent NULL eq_ref PRIMARY PRIMARY 4 db59gacpy8p5zb.c.parent_id 1 100.00 Using where; Using index 1 PRIMARY v NULL eq_ref PRIMARY PRIMARY 4 db59gacpy8p5zb.a.id 1 100.00 Using where; Using index 1 PRIMARY <derived2> NULL ref <auto_key0> <auto_key0> 4 db59gacpy8p5zb.c.id 2 100.00 Using where; Using index 2 DERIVED parent NULL range cat_idx,idx_left_right cat_idx 153 NULL 2 100.00 Using index condition; Using temporary; Using filesort 2 DERIVED cat NULL index PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language idx_left_right 8 NULL 22 11.11 Using where; Using index; Using join buffer (Block Nested Loop) 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:221JROOT/libraries/legacy/view/legacy.php:398JROOT/components/com_content/views/featured/view.html.php:50JROOT/libraries/joomla/cache/controller/view.php:98JROOT/libraries/legacy/controller/legacy.php:689JROOT/components/com_content/controller.php:79JROOT/libraries/legacy/controller/legacy.php:730JROOT/components/com_content/content.php:16JROOT/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.18 ms After last query: 3.62 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-front/includes/params.php:63JROOT/templates/overlander-front/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.24 ms After last query: 17.84 ms
SELECT m.menutype
FROM ovl_menu AS m
WHERE m.id = 101id 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-front/includes/params.php:63JROOT/templates/overlander-front/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.24 ms After last query: 0.28 ms
SELECT t.parent_id
FROM ovl_menu as t
WHERE t.id = 101id 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-front/includes/params.php:63JROOT/templates/overlander-front/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.16 ms After last query: 0.09 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-front/includes/params.php:63JROOT/templates/overlander-front/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: 4.37 ms After last query: 15.70 ms
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM ovl_content AS a
LEFT JOIN ovl_categories AS c
on c.id = a.catid
LEFT JOIN ovl_users AS u
on u.id = a.created_by
LEFT JOIN ovl_categories as parent
ON parent.id = c.parent_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ovl_categories AS cat JOIN ovl_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 9
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-28 02:28:01')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-28 02:28:01')
AND a.access IN (1,1,5)
AND a.state = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY a NULL const PRIMARY,idx_access,idx_state PRIMARY 4 const 1 100.00 NULL 1 PRIMARY c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 PRIMARY <derived2> NULL ref <auto_key0> <auto_key0> 4 const 1 100.00 Using index 2 DERIVED parent NULL range cat_idx,idx_left_right cat_idx 153 NULL 1 100.00 Using index condition; Using temporary; Using filesort 2 DERIVED cat NULL index PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language idx_left_right 8 NULL 22 11.11 Using where; Using index; Using join buffer (Block Nested Loop) No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/modules/mod_articleplacedanywhere/helper.php:117JROOT/modules/mod_articleplacedanywhere/mod_articleplacedanywhere.php:25JROOT/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.73 ms After last query: 1.27 ms
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM ovl_categories as c
LEFT JOIN ovl_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM ovl_categories AS cat JOIN ovl_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=2
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using temporary; Using filesort 1 PRIMARY c NULL ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 22 45.45 Using where 1 PRIMARY <derived2> NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 25.00 Using where; Not exists; Using join buffer (Block Nested Loop) 2 DERIVED parent NULL range cat_idx,idx_left_right cat_idx 153 NULL 2 100.00 Using index condition; Using temporary; Using filesort 2 DERIVED cat NULL index PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language idx_left_right 8 NULL 22 11.11 Using where; Using index; Using join buffer (Block Nested Loop) No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/legacy/categories/categories.php:288JROOT/libraries/legacy/categories/categories.php:181JROOT/components/com_content/helpers/route.php:41JROOT/modules/mod_articleplacedanywhere/helper.php:19JROOT/modules/mod_articleplacedanywhere/tmpl/default.php:13JROOT/modules/mod_articleplacedanywhere/mod_articleplacedanywhere.php:48JROOT/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.42 ms After last query: 6.48 ms
SELECT b.rules
FROM ovl_assets AS a
LEFT JOIN ovl_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.9')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const idx_asset_name idx_asset_name 152 const 1 100.00 Using temporary; Using filesort 1 SIMPLE b NULL range idx_lft_rgt idx_lft_rgt 4 NULL 12 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:248JROOT/libraries/joomla/access/access.php:109JROOT/libraries/joomla/user/user.php:373JROOT/modules/mod_articleplacedanywhere/tmpl/_item.php:32JROOT/modules/mod_articleplacedanywhere/helper.php:54JROOT/modules/mod_articleplacedanywhere/tmpl/default.php:13JROOT/modules/mod_articleplacedanywhere/mod_articleplacedanywhere.php:48JROOT/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.25 ms After last query: 3.88 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM ovl_extensions
WHERE `type` = 'component'
AND `element` = 'com_djimageslider'id 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,extension element_clientid 302 const 1 10.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/cache/controller/callback.php:158JROOT/libraries/cms/component/helper.php:396JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:73JROOT/modules/mod_djimageslider/mod_djimageslider.php:39JROOT/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: 2.78 ms After last query: 0.26 ms
SELECT a.*
FROM ovl_djimageslider AS a
WHERE a.catid = 17
AND a.published = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-10-28 02:28:01')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-10-28 02:28:01')
ORDER BY RAND()
LIMIT 0, 20id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref catid catid 5 const,const 1 16.00 Using where; Using temporary; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/modules/mod_djimageslider/helper.php:90JROOT/modules/mod_djimageslider/mod_djimageslider.php:43JROOT/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.28 ms After last query: 3.00 ms
SELECT *
FROM ovl_banners
WHERE '2020-10-28 02:28:01' >= '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.67 ms After last query: 0.88 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.39 ms After last query: 0.16 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.27 ms After last query: 0.18 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.0 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.10 msDuplicate queries: #27
SELECT `count`
FROM ovl_banner_tracks
WHERE track_type=1
AND banner_id=2
AND track_date='2020-10-28 02'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.12 ms After last query: 0.07 msDuplicate queries: #26
SELECT `count`
FROM ovl_banner_tracks
WHERE track_type=1
AND banner_id=2
AND track_date='2020-10-28 02'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.25 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-10-28 02'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/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 1.10 ms After last query: 41.51 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.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.55 ms After last query: 0.29 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/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.42 ms After last query: 1.18 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/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.41 ms After last query: 0.64 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: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.32 ms After last query: 0.46 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.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: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.27 ms After last query: 0.39 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.15 ms After last query: 0.12 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.28 ms After last query: 0.08 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/libraries/cms/application/cms.php:257JROOT/index.php:52 - Query Time: 0.50 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.2 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.38 ms After last query: 1.81 ms
UPDATE `ovl_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1603852081;s:18:\"session.timer.last\";i:1603852081;s:17:\"session.timer.now\";i:1603852081;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\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;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\";a:2:{i:0;i:1;i:1;i:9;}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:13:\"session.token\";s:32:\"682101636299a00181f4d5e02606cfce\";}' , `time` = '1603852081'
WHERE `session_id` = 'gm8lms7662bpoffollkempf3o7'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.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.0 ms closing tables 0.0 ms freeing items 0.0 ms cleaning up 0.0 ms JROOT/libraries/joomla/session/storage/database.php:85
33 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
3 × SELECT *
FROM `ovl_extensions`2 × SELECT `count`
FROM ovl_banner_tracks2 × SELECT t.parent_id
FROM ovl_menu as t2 × SELECT b.rules
FROM ovl_assets AS a
LEFT JOIN ovl_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM ovl_banners1 × SELECT count(*)
FROM `ovl_sobipro_field_data` AS `d`1 × SELECT a.*
FROM ovl_djimageslider AS a1 × SELECT COUNT(*)
FROM ovl_banners as a
LEFT JOIN ovl_banner_clients AS cl
ON cl.id = a.cid1 × 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 extension_id AS id, element AS "option", params, enabled
FROM ovl_extensions1 × SELECT count(*)
FROM `ovl_sobipro_object`1 × SELECT last_update
FROM `ovl_xtdir_trees`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM ovl_content AS a
LEFT JOIN ovl_categories AS c
on c.id = a.catid
LEFT JOIN ovl_users AS u
on u.id = a.created_by
LEFT JOIN ovl_categories as parent
ON parent.id = c.parent_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ovl_categories AS cat JOIN ovl_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × 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 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 a.rules
FROM ovl_assets AS a1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM ovl_content AS a
LEFT JOIN ovl_categories AS c
ON c.id = a.catid
LEFT JOIN ovl_users AS ua
ON ua.id = a.created_by
LEFT JOIN ovl_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ovl_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ovl_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ovl_categories AS cat JOIN ovl_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT `data`
FROM `ovl_session`1 × 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 COUNT(*)
FROM ovl_content AS a
LEFT JOIN ovl_categories AS c
ON c.id = a.catid
LEFT JOIN ovl_users AS ua
ON ua.id = a.created_by
LEFT JOIN ovl_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ovl_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ovl_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM ovl_categories AS cat JOIN ovl_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM ovl_categories as c
LEFT JOIN ovl_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM ovl_categories AS cat JOIN ovl_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
OTHER Tables:
1 × SHOW TABLE
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:1603852081;s:18:\"session.timer.last\";i:1603852081;s:17:\"session.timer.now\";i:1603852081;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\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;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\";a:2:{i:0;i:1;i:1;i:9;}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:13:\"session.token\";s:32:\"682101636299a00181f4d5e02606cfce\";}' , `time` = '1603852081'1 × UPDATE ovl_banner_tracks
SET `count` = (`count` + 1)1 × UPDATE ovl_banners
SET impmade = (impmade + 1)1 × INSERT INTO `ovl_session` (`session_id`, `client_id`, `time`)
VALUES ('gm8lms7662bpoffollkempf3o7', 0, '1603852081'1 × UPDATE `ovl_extensions`
SET `params` = '{\"mediaversion\":\"cbb7b29d4d3efd8f34025c20c12a9906\"}'1 × DELETE
FROM `ovl_session`