COMESA are invited to the publication launch
Chambers and associations in COMESA are invited to the publication launch
27-11-2020
27-11-2020
- Home
- /News
Parliament agrees with Finance Minister to pass VAT
in exchange for imposing another tax.
Egypt Cabinet to increase civil servants minimum wage
Ministry of Planning Monitoring and Administrative Reform (MPMAR) is preparing a study to raise
Read more...
Health Ministry backtracks on price hike for chronic diseases drugs
The Health Ministry gave in to the demands of the pharmaceutical companies with regard to increas
Save the Date 15 & 16 April 2019
Save the Date 15 & 16 April 2019....Stay tuned for details
Read more...Egypt Targets new 656,000 Affordable Housing Units in 2 1/2 Years: Sisi
Egypt's government is aiming to finish building 656,000 socially affordable housing units over the coming two and half years,
Contact us
-
1195 Nile Corniche,
Boulaq, Cairo Governorate
-
+20(2)25796590-2
+20(2) 25797074-6 -
+20(2)25796593-4
+20(2)25766672
Our Location
NEWSLETTER SUBSCRIPTION
Joomla! Debug Console
Time
Memory
Time: 0.0 ms / 0.0 ms Memory: 0.753 MB / 0.75 MB Application: afterLoad
Time: 253.9 ms / 253.9 ms Memory: 19.487 MB / 20.24 MB Application: afterInitialise
Time: 9.2 ms / 263.1 ms Memory: 0.500 MB / 20.74 MB Application: afterRoute
Time: 148.1 ms / 411.2 ms Memory: 5.959 MB / 26.70 MB Application: afterDispatch
Time: 62.9 ms / 474.2 ms Memory: 1.469 MB / 28.17 MB Application: beforeRenderModule mod_custom (Footer2)
Time: 1.9 ms / 476.0 ms Memory: 0.053 MB / 28.22 MB Application: afterRenderModule mod_custom (Footer2)
Time: 0.1 ms / 476.2 ms Memory: 0.000 MB / 28.22 MB Application: beforeRenderModule mod_custom (Copyrights)
Time: 0.3 ms / 476.5 ms Memory: 0.007 MB / 28.22 MB Application: afterRenderModule mod_custom (Copyrights)
Time: 0.1 ms / 476.6 ms Memory: 0.003 MB / 28.23 MB Application: beforeRenderModule mod_acymailing (NEWSLETTER SUBSCRIPTION)
Time: 16.0 ms / 492.6 ms Memory: 1.169 MB / 29.39 MB Application: afterRenderModule mod_acymailing (NEWSLETTER SUBSCRIPTION)
Time: 0.2 ms / 492.8 ms Memory: 0.000 MB / 29.37 MB Application: beforeRenderModule mod_custom (Our Location)
Time: 0.4 ms / 493.2 ms Memory: 0.006 MB / 29.37 MB Application: afterRenderModule mod_custom (Our Location)
Time: 0.1 ms / 493.3 ms Memory: 0.000 MB / 29.37 MB Application: beforeRenderModule mod_custom (Contact us)
Time: 0.3 ms / 493.6 ms Memory: 0.006 MB / 29.38 MB Application: afterRenderModule mod_custom (Contact us)
Time: 0.1 ms / 493.7 ms Memory: 0.000 MB / 29.38 MB Application: beforeRenderModule mod_menu (Main Links)
Time: 16.0 ms / 509.8 ms Memory: 0.113 MB / 29.49 MB Application: afterRenderModule mod_menu (Main Links)
Time: 0.2 ms / 509.9 ms Memory: 0.000 MB / 29.49 MB Application: beforeRenderModule mod_menu (Media Center)
Time: 13.1 ms / 523.0 ms Memory: 0.050 MB / 29.54 MB Application: afterRenderModule mod_menu (Media Center)
Time: 0.1 ms / 523.2 ms Memory: 0.000 MB / 29.53 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 2.5 ms / 525.7 ms Memory: 0.029 MB / 29.56 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.1 ms / 525.9 ms Memory: 0.000 MB / 29.56 MB Application: beforeRenderModule mod_datetime (Date and Time)
Time: 2.2 ms / 528.1 ms Memory: 0.030 MB / 29.59 MB Application: afterRenderModule mod_datetime (Date and Time)
Time: 0.2 ms / 528.2 ms Memory: 0.000 MB / 29.57 MB Application: beforeRenderModule mod_custom (Header Search)
Time: 0.4 ms / 528.6 ms Memory: 0.007 MB / 29.58 MB Application: afterRenderModule mod_custom (Header Search)
Time: 0.2 ms / 528.7 ms Memory: 0.000 MB / 29.58 MB Application: beforeRenderModule mod_menu (Top Menu)
Time: 7.3 ms / 536.1 ms Memory: 0.024 MB / 29.60 MB Application: afterRenderModule mod_menu (Top Menu)
Time: 0.1 ms / 536.2 ms Memory: 0.000 MB / 29.60 MB Application: beforeRenderModule mod_languages (Language:)
Time: 7.8 ms / 544.0 ms Memory: 0.274 MB / 29.87 MB Application: afterRenderModule mod_languages (Language:)
Time: 0.1 ms / 544.1 ms Memory: 0.000 MB / 29.87 MB Application: beforeRenderModule mod_custom (Social top)
Time: 0.4 ms / 544.4 ms Memory: 0.006 MB / 29.87 MB Application: afterRenderModule mod_custom (Social top)
Time: 17.6 ms / 562.1 ms Memory: 0.577 MB / 30.45 MB Application: afterRender
Database queries total: 70.2 ms
30.92 MB (32,421,176 Bytes)
46 Queries Logged 70.2 ms
8 duplicate found!
- Query Time: 0.34 ms
SELECT `data`
FROM `bonnie_session`
WHERE `session_id` = 'adv1d0lkurpvjvghk48r7jslg4'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_session 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:44JROOT/libraries/joomla/session/session.php:665JROOT/libraries/joomla/session/session.php:603JROOT/libraries/cms/application/cms.php:739JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:399JROOT/libraries/joomla/factory.php:125JROOT/index.php:37 - Query Time: 0.32 ms After last query: 2.61 ms
DELETE
FROM `bonnie_session`
WHERE `time` < '1606465451'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_session 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:756JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:399JROOT/libraries/joomla/factory.php:125JROOT/index.php:37 - Query Time: 0.29 ms After last query: 0.13 ms
SELECT `session_id`
FROM `bonnie_session`
WHERE `session_id` = 'adv1d0lkurpvjvghk48r7jslg4'
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_session 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:176JROOT/libraries/cms/application/cms.php:765JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:399JROOT/libraries/joomla/factory.php:125JROOT/index.php:37 - Query Time: 0.32 ms After last query: 0.14 ms
INSERT INTO `bonnie_session` (`session_id`, `client_id`, `time`)
VALUES ('adv1d0lkurpvjvghk48r7jslg4', 0, '1606469051')EXPLAIN not possible on query: INSERT INTO `bonnie_session` (`session_id`, `client_id`, `time`) VALUES ('adv1d0lkurpvjvghk48r7jslg4', 0, '1606469051')No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/application/cms.php:208JROOT/libraries/cms/application/cms.php:765JROOT/libraries/cms/application/cms.php:131JROOT/libraries/cms/application/site.php:63JROOT/libraries/cms/application/cms.php:399JROOT/libraries/joomla/factory.php:125JROOT/index.php:37 - Query Time: 0.65 ms After last query: 6.31 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM bonnie_extensions
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_extensions ref extension extension 62 const 62 100.00 Using index condition No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/cache/controller/callback.php:157JROOT/libraries/cms/component/helper.php:434JROOT/libraries/cms/component/helper.php:43JROOT/libraries/cms/component/helper.php:119JROOT/libraries/cms/application/site.php:568JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.39 ms After last query: 1.87 ms
SELECT b.id
FROM bonnie_usergroups AS a
LEFT JOIN bonnie_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 100.00 Using where; Using index No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:332JROOT/libraries/joomla/access/access.php:401JROOT/libraries/joomla/user/user.php:453JROOT/libraries/cms/plugin/helper.php:296JROOT/libraries/cms/plugin/helper.php:163JROOT/libraries/cms/application/site.php:573JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.29 ms After last query: 0.66 ms
SELECT id, rules
FROM `bonnie_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:418JROOT/libraries/joomla/user/user.php:453JROOT/libraries/cms/plugin/helper.php:296JROOT/libraries/cms/plugin/helper.php:163JROOT/libraries/cms/application/site.php:573JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.86 ms After last query: 0.20 ms
SELECT folder AS type, element AS name, params
FROM bonnie_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_extensions ref extension extension 62 const 121 100.00 Using index condition; Using where; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/plugin/helper.php:310JROOT/libraries/cms/plugin/helper.php:163JROOT/libraries/cms/application/site.php:573JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 8.85 ms After last query: 5.06 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 bonnie_menu AS m
LEFT JOIN bonnie_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 type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 997 75.03 Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 feiorgeg_fei3.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:45JROOT/libraries/cms/menu/menu.php:64JROOT/libraries/cms/menu/menu.php:118JROOT/libraries/cms/application/cms.php:424JROOT/libraries/cms/application/site.php:272JROOT/libraries/cms/router/site.php:57JROOT/libraries/cms/router/router.php:196JROOT/libraries/cms/application/cms.php:520JROOT/libraries/cms/application/site.php:407JROOT/plugins/system/languagefilter/languagefilter.php:61JROOT/libraries/cms/plugin/helper.php:255JROOT/libraries/cms/plugin/helper.php:170JROOT/libraries/cms/application/site.php:573JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.49 ms After last query: 84.20 ms
SELECT *
FROM bonnie_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 100.00 Using where; Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/language/helper.php:164JROOT/plugins/system/languagefilter/languagefilter.php:67JROOT/libraries/cms/plugin/helper.php:255JROOT/libraries/cms/plugin/helper.php:170JROOT/libraries/cms/application/site.php:573JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.94 ms After last query: 0.61 ms
SELECT COUNT(*)
FROM `bonnie_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_menu ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 997 75.03 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/administrator/components/com_languages/helpers/multilangstatus.php:36JROOT/plugins/system/languagefilter/languagefilter.php:71JROOT/libraries/cms/plugin/helper.php:255JROOT/libraries/cms/plugin/helper.php:170JROOT/libraries/cms/application/site.php:573JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.50 ms After last query: 19.96 msDuplicate queries: #13
SELECT template
FROM bonnie_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 8 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105JROOT/libraries/rokcommon/RokCommon/Service.php:71JROOT/libraries/rokcommon/include.php:38JROOT/plugins/system/rokcommon/rokcommon.php:96JROOT/plugins/system/rokcommon/rokcommon.php:54JROOT/libraries/cms/plugin/helper.php:255JROOT/libraries/cms/plugin/helper.php:170JROOT/libraries/cms/application/cms.php:653JROOT/libraries/cms/application/site.php:647JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.37 ms After last query: 0.11 msDuplicate queries: #12
SELECT template
FROM bonnie_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 8 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106JROOT/libraries/rokcommon/RokCommon/Service.php:71JROOT/libraries/rokcommon/include.php:38JROOT/plugins/system/rokcommon/rokcommon.php:96JROOT/plugins/system/rokcommon/rokcommon.php:54JROOT/libraries/cms/plugin/helper.php:255JROOT/libraries/cms/plugin/helper.php:170JROOT/libraries/cms/application/cms.php:653JROOT/libraries/cms/application/site.php:647JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.32 ms After last query: 7.53 ms
SELECT extension, file, type
FROM bonnie_rokcommon_configs
ORDER BY priorityid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_rokcommon_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 100.00 Using filesort No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/plugins/system/rokcommon/rokcommon.php:132JROOT/plugins/system/rokcommon/rokcommon.php:76JROOT/libraries/cms/plugin/helper.php:255JROOT/libraries/cms/plugin/helper.php:170JROOT/libraries/cms/application/cms.php:653JROOT/libraries/cms/application/site.php:647JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.93 ms After last query: 26.08 ms
SHOW FULL COLUMNS
FROM `bonnie_extensions`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bonnie_extensions`No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/table/table.php:241JROOT/libraries/joomla/table/table.php:162JROOT/libraries/joomla/table/extension.php:30JROOT/libraries/joomla/table/table.php:305JROOT/plugins/system/roksprocket/roksprocket.php:46JROOT/libraries/joomla/event/event.php:69JROOT/libraries/joomla/event/dispatcher.php:160JROOT/libraries/joomla/application/base.php:83JROOT/libraries/cms/application/cms.php:654JROOT/libraries/cms/application/site.php:647JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.40 ms After last query: 1.02 ms
SELECT `extension_id`
FROM `bonnie_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 100.00 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/table/extension.php:108JROOT/plugins/system/roksprocket/roksprocket.php:50JROOT/libraries/joomla/event/event.php:69JROOT/libraries/joomla/event/dispatcher.php:160JROOT/libraries/joomla/application/base.php:83JROOT/libraries/cms/application/cms.php:654JROOT/libraries/cms/application/site.php:647JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.32 ms After last query: 0.19 msDuplicate queries: #19
SELECT *
FROM bonnie_extensions
WHERE `extension_id` = '10234'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_extensions const PRIMARY PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/table/table.php:728JROOT/plugins/system/roksprocket/roksprocket.php:55JROOT/libraries/joomla/event/event.php:69JROOT/libraries/joomla/event/dispatcher.php:160JROOT/libraries/joomla/application/base.php:83JROOT/libraries/cms/application/cms.php:654JROOT/libraries/cms/application/site.php:647JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.35 ms After last query: 0.17 ms
SELECT `extension_id`
FROM `bonnie_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 100.00 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/table/extension.php:108JROOT/plugins/system/roksprocket/roksprocket.php:73JROOT/libraries/joomla/event/event.php:69JROOT/libraries/joomla/event/dispatcher.php:160JROOT/libraries/joomla/application/base.php:83JROOT/libraries/cms/application/cms.php:654JROOT/libraries/cms/application/site.php:647JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.41 ms After last query: 0.16 msDuplicate queries: #17
SELECT *
FROM bonnie_extensions
WHERE `extension_id` = '10234'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_extensions const PRIMARY PRIMARY 4 const 1 100.00 NULL No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/table/table.php:728JROOT/plugins/system/roksprocket/roksprocket.php:77JROOT/libraries/joomla/event/event.php:69JROOT/libraries/joomla/event/dispatcher.php:160JROOT/libraries/joomla/application/base.php:83JROOT/libraries/cms/application/cms.php:654JROOT/libraries/cms/application/site.php:647JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.64 ms After last query: 33.10 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM bonnie_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using index condition No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/cache/controller/callback.php:157JROOT/libraries/cms/library/helper.php:156JROOT/libraries/cms/library/helper.php:47JROOT/libraries/cms/library/helper.php:90JROOT/libraries/cms/version/version.php:177JROOT/libraries/joomla/factory.php:736JROOT/libraries/joomla/factory.php:216JROOT/plugins/system/helix/core/helix.php:50JROOT/plugins/system/helix/core/helix.php:36JROOT/plugins/system/helix/helix.php:21JROOT/libraries/joomla/event/event.php:69JROOT/libraries/joomla/event/dispatcher.php:160JROOT/libraries/joomla/application/base.php:83JROOT/libraries/cms/application/cms.php:654JROOT/libraries/cms/application/site.php:647JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.39 ms After last query: 0.31 ms
UPDATE `bonnie_extensions`
SET `params` = '{\"mediaversion\":\"5fcab4a031477372c06299765fc01da8\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_extensions 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:228JROOT/libraries/cms/version/version.php:187JROOT/libraries/joomla/factory.php:736JROOT/libraries/joomla/factory.php:216JROOT/plugins/system/helix/core/helix.php:50JROOT/plugins/system/helix/core/helix.php:36JROOT/plugins/system/helix/helix.php:21JROOT/libraries/joomla/event/event.php:69JROOT/libraries/joomla/event/dispatcher.php:160JROOT/libraries/joomla/application/base.php:83JROOT/libraries/cms/application/cms.php:654JROOT/libraries/cms/application/site.php:647JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.82 ms After last query: 2.45 ms
SELECT id, home, template, s.params
FROM bonnie_template_styles as s
LEFT JOIN bonnie_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 62 const 5 100.00 Using index condition; Using where 1 SIMPLE s ref idx_template idx_template 152 feiorgeg_fei3.e.element 1 100.00 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/application/site.php:484JROOT/plugins/system/helix/core/helix.php:65JROOT/plugins/system/helix/core/helix.php:114JROOT/plugins/system/helix/core/helix.php:302JROOT/plugins/system/helix/core/helix.php:290JROOT/plugins/system/helix/core/helix.php:1592JROOT/plugins/system/helix/helix.php:22JROOT/libraries/joomla/event/event.php:69JROOT/libraries/joomla/event/dispatcher.php:160JROOT/libraries/joomla/application/base.php:83JROOT/libraries/cms/application/cms.php:654JROOT/libraries/cms/application/site.php:647JROOT/libraries/cms/application/site.php:209JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.55 ms After last query: 33.56 ms
SELECT a.rules
FROM bonnie_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a 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:246JROOT/libraries/joomla/user/user.php:384JROOT/components/com_content/models/category.php:141JROOT/libraries/legacy/model/legacy.php:431JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394JROOT/libraries/legacy/view/category.php:105JROOT/components/com_content/views/category/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 1.19 ms After last query: 0.91 ms
SELECT b.rules
FROM bonnie_assets AS a
LEFT JOIN bonnie_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.category.91')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const idx_asset_name idx_asset_name 152 const 1 100.00 Using temporary; Using filesort 1 SIMPLE b range idx_lft_rgt idx_lft_rgt 4 NULL 123 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:246JROOT/libraries/joomla/access/access.php:107JROOT/libraries/joomla/user/user.php:393JROOT/components/com_content/models/category.php:141JROOT/libraries/legacy/model/legacy.php:431JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394JROOT/libraries/legacy/view/category.php:105JROOT/components/com_content/views/category/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 4.36 ms After last query: 2.29 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,COUNT(i.`id`) AS numitems
FROM bonnie_categories as c
LEFT JOIN bonnie_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 bonnie_categories AS cat JOIN bonnie_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
LEFT JOIN `bonnie_content` AS i
ON i.`catid` = c.id
AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id=91
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 type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 221 78.73 Using where 1 PRIMARY <derived2> ref <auto_key0> <auto_key0> 4 feiorgeg_fei3.c.id 40 100.00 Using where; Not exists; Using index 1 PRIMARY i ref idx_state,idx_catid idx_catid 4 feiorgeg_fei3.c.id 4 100.00 Using where 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 40 100.00 Using index condition; Using temporary; Using filesort 2 DERIVED cat index PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language idx_left_right 8 NULL 221 100.00 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:289JROOT/libraries/legacy/categories/categories.php:182JROOT/components/com_content/models/category.php:357JROOT/components/com_content/models/category.php:234JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394JROOT/libraries/legacy/view/category.php:106JROOT/components/com_content/views/category/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 1.13 ms After last query: 4.32 ms
SELECT b.rules
FROM bonnie_assets AS a
LEFT JOIN bonnie_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 type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const idx_asset_name idx_asset_name 152 const 1 100.00 Using temporary; Using filesort 1 SIMPLE b range idx_lft_rgt idx_lft_rgt 4 NULL 15 100.00 Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/joomla/access/access.php:246JROOT/libraries/joomla/access/access.php:107JROOT/libraries/joomla/user/user.php:393JROOT/components/com_content/models/articles.php:449JROOT/libraries/legacy/model/list.php:113JROOT/libraries/legacy/model/list.php:165JROOT/components/com_content/models/articles.php:537JROOT/components/com_content/models/category.php:256JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394JROOT/libraries/legacy/view/category.php:106JROOT/components/com_content/views/category/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 13.24 ms After last query: 0.61 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 bonnie_content AS a
LEFT JOIN bonnie_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN bonnie_categories AS c
ON c.id = a.catid
LEFT JOIN bonnie_users AS ua
ON ua.id = a.created_by
LEFT JOIN bonnie_users AS uam
ON uam.id = a.modified_by
LEFT JOIN bonnie_categories as parent
ON parent.id = c.parent_id
LEFT JOIN bonnie_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM bonnie_categories AS cat JOIN bonnie_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 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.catid = 91 OR a.catid IN ( SELECT sub.id
FROM bonnie_categories as sub
INNER JOIN bonnie_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 91))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-27 09:24:11')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-27 09:24:11')
AND a.language in ('en-GB','*')
ORDER BY c.lft, a.ordering, a.created
LIMIT 0, 6id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c ALL PRIMARY,idx_access NO INDEX KEY COULD BE USED NULL NULL 221 100.00 Using where; Using temporary; Using filesort 1 PRIMARY a ref idx_access,idx_catid,idx_language idx_catid 4 feiorgeg_fei3.c.id 4 100.00 Using index condition; Using where 1 PRIMARY fp eq_ref PRIMARY PRIMARY 4 feiorgeg_fei3.a.id 1 100.00 Using where; Using index 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 feiorgeg_fei3.a.created_by 1 100.00 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 feiorgeg_fei3.a.modified_by 1 100.00 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 feiorgeg_fei3.c.parent_id 1 100.00 Using where 1 PRIMARY v ALL PRIMARY NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using join buffer (Block Nested Loop) 1 PRIMARY <derived2> ref <auto_key0> <auto_key0> 4 feiorgeg_fei3.c.id 40 100.00 Using where; Using index 3 SUBQUERY this const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 3 SUBQUERY sub range PRIMARY,idx_left_right idx_left_right 4 NULL 187 100.00 Using where; Using index 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 40 100.00 Using index condition; Using temporary; Using filesort 2 DERIVED cat index PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language idx_left_right 8 NULL 221 100.00 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:304JROOT/libraries/legacy/model/list.php:169JROOT/components/com_content/models/articles.php:537JROOT/components/com_content/models/category.php:256JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394JROOT/libraries/legacy/view/category.php:106JROOT/components/com_content/views/category/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.66 ms After last query: 3.57 ms
SELECT `m`.`tag_id`,`t`.*
FROM `bonnie_contentitem_tag_map` AS m
INNER JOIN `bonnie_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 3859
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t ref PRIMARY,tag_idx,idx_access tag_idx 1 const 11 100.00 Using index condition 1 SIMPLE m ref idx_tag_type,idx_tag idx_tag_type 4 feiorgeg_fei3.t.id 1 100.00 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/helper/tags.php:426JROOT/components/com_content/models/articles.php:663JROOT/components/com_content/models/category.php:256JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394JROOT/libraries/legacy/view/category.php:106JROOT/components/com_content/views/category/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.48 ms After last query: 0.53 ms
SELECT `m`.`tag_id`,`t`.*
FROM `bonnie_contentitem_tag_map` AS m
INNER JOIN `bonnie_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 3184
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t ref PRIMARY,tag_idx,idx_access tag_idx 1 const 11 100.00 Using index condition 1 SIMPLE m ref idx_tag_type,idx_tag idx_tag_type 4 feiorgeg_fei3.t.id 1 100.00 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/helper/tags.php:426JROOT/components/com_content/models/articles.php:663JROOT/components/com_content/models/category.php:256JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394JROOT/libraries/legacy/view/category.php:106JROOT/components/com_content/views/category/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.47 ms After last query: 0.47 ms
SELECT `m`.`tag_id`,`t`.*
FROM `bonnie_contentitem_tag_map` AS m
INNER JOIN `bonnie_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 3288
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t ref PRIMARY,tag_idx,idx_access tag_idx 1 const 11 100.00 Using index condition 1 SIMPLE m ref idx_tag_type,idx_tag idx_tag_type 4 feiorgeg_fei3.t.id 1 100.00 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/helper/tags.php:426JROOT/components/com_content/models/articles.php:663JROOT/components/com_content/models/category.php:256JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394JROOT/libraries/legacy/view/category.php:106JROOT/components/com_content/views/category/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.47 ms After last query: 0.45 ms
SELECT `m`.`tag_id`,`t`.*
FROM `bonnie_contentitem_tag_map` AS m
INNER JOIN `bonnie_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 3295
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t ref PRIMARY,tag_idx,idx_access tag_idx 1 const 11 100.00 Using index condition 1 SIMPLE m ref idx_tag_type,idx_tag idx_tag_type 4 feiorgeg_fei3.t.id 1 100.00 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/helper/tags.php:426JROOT/components/com_content/models/articles.php:663JROOT/components/com_content/models/category.php:256JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394JROOT/libraries/legacy/view/category.php:106JROOT/components/com_content/views/category/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.46 ms After last query: 0.47 ms
SELECT `m`.`tag_id`,`t`.*
FROM `bonnie_contentitem_tag_map` AS m
INNER JOIN `bonnie_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 3762
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t ref PRIMARY,tag_idx,idx_access tag_idx 1 const 11 100.00 Using index condition 1 SIMPLE m ref idx_tag_type,idx_tag idx_tag_type 4 feiorgeg_fei3.t.id 1 100.00 Using index condition; Using where No SHOW PROFILE (maybe because there are more than 100 queries)JROOT/libraries/cms/helper/tags.php:426JROOT/components/com_content/models/articles.php:663JROOT/components/com_content/models/category.php:256JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394JROOT/libraries/legacy/view/category.php:106JROOT/components/com_content/views/category/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.74 ms After last query: 0.49 ms
SELECT `m`.`tag_id`,`t`.*
FROM `bonnie_contentitem_tag_map` AS m
INNER JOIN `bonnie_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 532
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t ref PRIMARY,tag_idx,idx_access tag_idx 1 const 11 100.00 Using index condition 1 SIMPLE m ref idx_tag_type,idx_tag idx_tag_type 4 feiorgeg_fei3.t.id 1 100.00 Using index condition; Using where Status Duration starting 0.1 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.1 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.1 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.1 ms cleaning up 0.0 ms JROOT/libraries/cms/helper/tags.php:426JROOT/components/com_content/models/articles.php:663JROOT/components/com_content/models/category.php:256JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394JROOT/libraries/legacy/view/category.php:106JROOT/components/com_content/views/category/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 14.00 ms After last query: 1.68 ms
SELECT COUNT(*)
FROM bonnie_content AS a
LEFT JOIN bonnie_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN bonnie_categories AS c
ON c.id = a.catid
LEFT JOIN bonnie_users AS ua
ON ua.id = a.created_by
LEFT JOIN bonnie_users AS uam
ON uam.id = a.modified_by
LEFT JOIN bonnie_categories as parent
ON parent.id = c.parent_id
LEFT JOIN bonnie_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM bonnie_categories AS cat JOIN bonnie_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 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.catid = 91 OR a.catid IN ( SELECT sub.id
FROM bonnie_categories as sub
INNER JOIN bonnie_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 91))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-27 09:24:11')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-27 09:24:11')
AND a.language in ('en-GB','*')id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c ALL PRIMARY,idx_access NO INDEX KEY COULD BE USED NULL NULL 221 100.00 Using where 1 PRIMARY a ref idx_access,idx_catid,idx_language idx_catid 4 feiorgeg_fei3.c.id 4 100.00 Using index condition; Using where 1 PRIMARY fp eq_ref PRIMARY PRIMARY 4 feiorgeg_fei3.a.id 1 100.00 Using where; Using index 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 feiorgeg_fei3.a.created_by 1 100.00 Using where; Using index 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 feiorgeg_fei3.a.modified_by 1 100.00 Using where; Using index 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 feiorgeg_fei3.c.parent_id 1 100.00 Using where; Using index 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 feiorgeg_fei3.a.id 1 100.00 Using where; Using index 1 PRIMARY <derived2> ref <auto_key0> <auto_key0> 4 feiorgeg_fei3.c.id 40 100.00 Using where; Using index 3 SUBQUERY this const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 3 SUBQUERY sub range PRIMARY,idx_left_right idx_left_right 4 NULL 187 100.00 Using where; Using index 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 40 100.00 Using index condition; Using temporary; Using filesort 2 DERIVED cat index PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language idx_left_right 8 NULL 221 100.00 Using where; Using index; Using join buffer (Block Nested Loop) Status Duration starting 0.3 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 Opening tables 0.1 ms init 0.1 ms System lock 0.0 ms optimizing 0.0 ms optimizing 0.0 ms statistics 0.1 ms preparing 0.0 ms Creating tmp table 0.0 ms Sorting result 0.0 ms statistics 0.2 ms preparing 0.1 ms executing 0.0 ms Sending data 0.1 ms optimizing 0.0 ms statistics 0.2 ms preparing 0.0 ms executing 0.0 ms Sending data 4.5 ms executing 0.0 ms Sending data 1.2 ms Creating sort index 0.1 ms removing tmp table 0.0 ms Creating sort index 6.4 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 removing tmp table 0.0 ms freeing items 0.1 ms cleaning up 0.0 ms JROOT/libraries/legacy/model/legacy.php:333JROOT/libraries/legacy/model/list.php:274JROOT/libraries/legacy/model/list.php:219JROOT/components/com_content/models/category.php:268JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394JROOT/libraries/legacy/view/category.php:106JROOT/components/com_content/views/category/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.83 ms After last query: 0.71 ms
SELECT `m`.`tag_id`,`t`.*
FROM `bonnie_contentitem_tag_map` AS m
INNER JOIN `bonnie_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 91
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t ref PRIMARY,tag_idx,idx_access tag_idx 1 const 11 100.00 Using index condition 1 SIMPLE m ref idx_tag_type,idx_tag idx_tag_type 4 feiorgeg_fei3.t.id 1 100.00 Using index condition; Using where Status Duration starting 0.2 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.1 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.1 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.1 ms cleaning up 0.0 ms JROOT/libraries/cms/helper/tags.php:426JROOT/libraries/legacy/view/category.php:177JROOT/components/com_content/views/category/view.html.php:72JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.57 ms After last query: 24.93 ms
SELECT id,template
FROM bonnie_template_styles
WHERE client_id=0
AND home=1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_template_styles ALL idx_home NO INDEX KEY COULD BE USED NULL NULL 8 100.00 Using where Status Duration starting 0.2 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.0 ms preparing 0.0 ms executing 0.0 ms Sending data 0.1 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.1 ms cleaning up 0.0 ms JROOT/administrator/components/com_widgetkit/widgetkit.php:23JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240JROOT/administrator/components/com_widgetkit/src/Application.php:49JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149JROOT/administrator/components/com_widgetkit/widgetkit.php:67JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6JROOT/plugins/content/widgetkit/widgetkit.php:9JROOT/libraries/joomla/event/event.php:69JROOT/libraries/joomla/event/dispatcher.php:160JROOT/components/com_content/views/category/view.html.php:106JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 4.78 ms After last query: 18.42 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 bonnie_categories as c
LEFT JOIN bonnie_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 bonnie_categories AS cat JOIN bonnie_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=91
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 type possible_keys key key_len ref rows filtered Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using temporary; Using filesort 1 PRIMARY c ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 221 78.73 Using where 1 PRIMARY <derived2> ref <auto_key0> <auto_key0> 4 feiorgeg_fei3.c.id 40 100.00 Using where; Not exists; Using index 2 DERIVED parent range cat_idx,idx_left_right cat_idx 153 NULL 40 100.00 Using index condition; Using temporary; Using filesort 2 DERIVED cat index PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language idx_left_right 8 NULL 221 100.00 Using where; Using index; Using join buffer (Block Nested Loop) Status Duration starting 0.4 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.1 ms init 0.1 ms System lock 0.0 ms optimizing 0.0 ms optimizing 0.0 ms statistics 0.1 ms preparing 0.1 ms Creating tmp table 0.0 ms Sorting result 0.0 ms statistics 0.2 ms preparing 0.1 ms Creating tmp table 0.1 ms Sorting result 0.0 ms executing 0.0 ms Sending data 0.1 ms executing 0.0 ms Sending data 1.9 ms Creating sort index 0.1 ms removing tmp table 0.0 ms Creating sort index 0.8 ms Creating sort index 0.1 ms end 0.0 ms removing tmp table 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/legacy/categories/categories.php:289JROOT/libraries/legacy/categories/categories.php:182JROOT/components/com_content/helpers/route.php:44JROOT/templates/vina_bonnie/html/com_content/category/blog_item.php:350JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661JROOT/templates/vina_bonnie/html/com_content/category/blog.php:247JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207JROOT/libraries/legacy/view/category.php:193JROOT/components/com_content/views/category/view.html.php:258JROOT/libraries/legacy/controller/legacy.php:690JROOT/components/com_content/controller.php:104JROOT/libraries/legacy/controller/legacy.php:728JROOT/components/com_content/content.php:16JROOT/libraries/cms/component/helper.php:391JROOT/libraries/cms/component/helper.php:371JROOT/libraries/cms/application/site.php:191JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.74 ms After last query: 11.65 msDuplicate queries: #44
SELECT m2.language, m2.id
FROM bonnie_menu as m
INNER JOIN bonnie_associations as a
ON a.id=m.id
AND a.context='com_menus.item'
INNER JOIN bonnie_associations as a2
ON a.key=a2.key
INNER JOIN bonnie_menu as m2
ON a2.id=m2.id
WHERE m.id=935id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m const PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE a const PRIMARY,idx_key PRIMARY 156 const,const 1 100.00 NULL 1 SIMPLE a2 ref idx_key idx_key 96 const 2 100.00 Using index 1 SIMPLE m2 eq_ref PRIMARY PRIMARY 4 feiorgeg_fei3.a2.id 1 100.00 NULL Status Duration starting 0.2 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.1 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.1 ms cleaning up 0.0 ms JROOT/administrator/components/com_menus/helpers/menus.php:283JROOT/plugins/system/languagefilter/languagefilter.php:592JROOT/libraries/joomla/event/event.php:69JROOT/libraries/joomla/event/dispatcher.php:160JROOT/libraries/joomla/application/base.php:83JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.58 ms After last query: 1.24 msDuplicate queries: #45
SELECT c2.language,CONCAT_WS(':', c2.id, c2.alias) AS id
FROM bonnie_categories as c
INNER JOIN bonnie_associations as a
ON a.id = c.id
AND a.context='com_categories.item'
INNER JOIN bonnie_associations as a2
ON a.key = a2.key
INNER JOIN bonnie_categories as c2
ON a2.id = c2.id
AND c2.extension = 'com_content'
WHERE c.id =91
AND c.extension = 'com_content'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c const PRIMARY,cat_idx PRIMARY 4 const 1 100.00 NULL 1 SIMPLE a const PRIMARY,idx_key PRIMARY 156 const,const 1 100.00 NULL 1 SIMPLE a2 ref idx_key idx_key 96 const 1 100.00 Using index 1 SIMPLE c2 eq_ref PRIMARY,cat_idx PRIMARY 4 feiorgeg_fei3.a2.id 1 100.00 Using where Status Duration starting 0.1 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.1 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.1 ms cleaning up 0.0 ms JROOT/administrator/components/com_categories/helpers/categories.php:119JROOT/administrator/components/com_categories/helpers/association.php:44JROOT/components/com_content/helpers/association.php:61JROOT/plugins/system/languagefilter/languagefilter.php:603JROOT/libraries/joomla/event/event.php:69JROOT/libraries/joomla/event/dispatcher.php:160JROOT/libraries/joomla/application/base.php:83JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 0.38 ms After last query: 16.00 ms
SELECT *
FROM bonnie_rsform_configid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_rsform_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 36 100.00 NULL 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.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.1 ms cleaning up 0.0 ms JROOT/administrator/components/com_rsform/helpers/config.php:51JROOT/administrator/components/com_rsform/helpers/config.php:18JROOT/administrator/components/com_rsform/helpers/config.php:98JROOT/administrator/components/com_rsform/helpers/rsform.php:318JROOT/administrator/components/com_rsform/helpers/legacy.php:36JROOT/administrator/components/com_rsform/helpers/rsform.php:124JROOT/administrator/components/com_rsform/helpers/rsform.php:35JROOT/plugins/system/rsfpregistration/rsfpregistration.php:42JROOT/plugins/system/rsfpregistration/rsfpregistration.php:638JROOT/libraries/joomla/event/event.php:69JROOT/libraries/joomla/event/dispatcher.php:160JROOT/libraries/joomla/application/base.php:83JROOT/libraries/cms/application/site.php:196JROOT/libraries/cms/application/site.php:230JROOT/libraries/cms/application/cms.php:252JROOT/index.php:40 - Query Time: 2.88 ms After last query: 42.82 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM bonnie_modules AS m
LEFT JOIN bonnie_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN bonnie_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-11-27 09:24:11')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-27 09:24:11')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 935 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds,idx_language published 1 const 149 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 303 feiorgeg_fei3.m.module,const 1 100.00 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 feiorgeg_fei3.m.id 5 100.00 Using where; Using index Status Duration starting 0.2 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.1 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.2 ms preparing 0.1 ms Sorting result 0.0 ms executing 0.0 ms Sending data 0.0 ms Creating sort index 2.0 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.1 ms cleaning up 0.0 ms JROOT/plugins/system/helix/core/classes/joomla30/helper.php:369JROOT/plugins/system/helix/core/classes/joomla30/helper.php:84JROOT/libraries/joomla/document/html/html.php:501JROOT/plugins/system/helix/core/helix.php:735JROOT/plugins/system/helix/core/helix.php:351JROOT/plugins/system/helix/core/helix.php:448JROOT/plugins/system/helix/core/helix.php:713JROOT/templates/vina_bonnie/index.php:79JROOT/libraries/joomla/document/html/html.php:578JROOT/libraries/joomla/document/html/html.php:635JROOT/libraries/joomla/document/html/html.php:455JROOT/libraries/cms/application/cms.php:1045JROOT/libraries/cms/application/site.php:729JROOT/libraries/cms/application/cms.php:258JROOT/index.php:40 - Query Time: 0.49 ms After last query: 31.91 ms
SELECT *
FROM bonnie_acymailing_configid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_acymailing_config ALL NULL NO INDEX KEY COULD BE USED NULL NULL 79 100.00 NULL 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.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.1 ms cleaning up 0.0 ms JROOT/administrator/components/com_acymailing/classes/cpanel.php:17JROOT/administrator/components/com_acymailing/helpers/helper.php:440JROOT/administrator/components/com_acymailing/helpers/helper.php:908JROOT/modules/mod_acymailing/mod_acymailing.php:12JROOT/plugins/system/helix/core/classes/joomla30/helper.php:177JROOT/libraries/joomla/document/html/renderer/module.php:103JROOT/libraries/joomla/document/html/renderer/modules.php:43JROOT/libraries/joomla/document/html/html.php:411JROOT/libraries/joomla/document/html/html.php:697JROOT/libraries/joomla/document/html/html.php:477JROOT/libraries/cms/application/cms.php:1059JROOT/libraries/cms/application/site.php:729JROOT/libraries/cms/application/cms.php:258JROOT/index.php:40 - Query Time: 0.37 ms After last query: 4.14 ms
SELECT *
FROM bonnie_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_acymailing_list system typeorderingindex,typeuseridindex NO INDEX KEY COULD BE USED NULL NULL 1 100.00 NULL 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.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.1 ms cleaning up 0.0 ms JROOT/administrator/components/com_acymailing/classes/list.php:29JROOT/modules/mod_acymailing/mod_acymailing.php:121JROOT/plugins/system/helix/core/classes/joomla30/helper.php:177JROOT/libraries/joomla/document/html/renderer/module.php:103JROOT/libraries/joomla/document/html/renderer/modules.php:43JROOT/libraries/joomla/document/html/html.php:411JROOT/libraries/joomla/document/html/html.php:697JROOT/libraries/joomla/document/html/html.php:477JROOT/libraries/cms/application/cms.php:1059JROOT/libraries/cms/application/site.php:729JROOT/libraries/cms/application/cms.php:258JROOT/index.php:40 - Query Time: 0.65 ms After last query: 48.88 msDuplicate queries: #38
SELECT m2.language, m2.id
FROM bonnie_menu as m
INNER JOIN bonnie_associations as a
ON a.id=m.id
AND a.context='com_menus.item'
INNER JOIN bonnie_associations as a2
ON a.key=a2.key
INNER JOIN bonnie_menu as m2
ON a2.id=m2.id
WHERE m.id=935id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m const PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE a const PRIMARY,idx_key PRIMARY 156 const,const 1 100.00 NULL 1 SIMPLE a2 ref idx_key idx_key 96 const 2 100.00 Using index 1 SIMPLE m2 eq_ref PRIMARY PRIMARY 4 feiorgeg_fei3.a2.id 1 100.00 NULL Status Duration starting 0.1 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.2 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.1 ms cleaning up 0.0 ms JROOT/administrator/components/com_menus/helpers/menus.php:283JROOT/modules/mod_languages/helper.php:62JROOT/modules/mod_languages/mod_languages.php:18JROOT/plugins/system/helix/core/classes/joomla30/helper.php:177JROOT/libraries/joomla/document/html/renderer/module.php:103JROOT/libraries/joomla/document/html/renderer/modules.php:43JROOT/libraries/joomla/document/html/html.php:411JROOT/libraries/joomla/document/html/html.php:697JROOT/libraries/joomla/document/html/html.php:477JROOT/libraries/cms/application/cms.php:1059JROOT/libraries/cms/application/site.php:729JROOT/libraries/cms/application/cms.php:258JROOT/index.php:40 - Query Time: 0.53 ms After last query: 0.24 msDuplicate queries: #39
SELECT c2.language,CONCAT_WS(':', c2.id, c2.alias) AS id
FROM bonnie_categories as c
INNER JOIN bonnie_associations as a
ON a.id = c.id
AND a.context='com_categories.item'
INNER JOIN bonnie_associations as a2
ON a.key = a2.key
INNER JOIN bonnie_categories as c2
ON a2.id = c2.id
AND c2.extension = 'com_content'
WHERE c.id =91
AND c.extension = 'com_content'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c const PRIMARY,cat_idx PRIMARY 4 const 1 100.00 NULL 1 SIMPLE a const PRIMARY,idx_key PRIMARY 156 const,const 1 100.00 NULL 1 SIMPLE a2 ref idx_key idx_key 96 const 1 100.00 Using index 1 SIMPLE c2 eq_ref PRIMARY,cat_idx PRIMARY 4 feiorgeg_fei3.a2.id 1 100.00 Using where Status Duration starting 0.1 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms optimizing 0.0 ms statistics 0.1 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.1 ms cleaning up 0.0 ms JROOT/administrator/components/com_categories/helpers/categories.php:119JROOT/administrator/components/com_categories/helpers/association.php:44JROOT/components/com_content/helpers/association.php:61JROOT/modules/mod_languages/helper.php:71JROOT/modules/mod_languages/mod_languages.php:18JROOT/plugins/system/helix/core/classes/joomla30/helper.php:177JROOT/libraries/joomla/document/html/renderer/module.php:103JROOT/libraries/joomla/document/html/renderer/modules.php:43JROOT/libraries/joomla/document/html/html.php:411JROOT/libraries/joomla/document/html/html.php:697JROOT/libraries/joomla/document/html/html.php:477JROOT/libraries/cms/application/cms.php:1059JROOT/libraries/cms/application/site.php:729JROOT/libraries/cms/application/cms.php:258JROOT/index.php:40 - Query Time: 0.49 ms After last query: 22.32 ms
UPDATE `bonnie_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1606469051;s:18:\"session.timer.last\";i:1606469051;s:17:\"session.timer.now\";i:1606469051;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}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:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"5ba23e8908e5e136cad3ec64493d78b3\";}' , `time` = '1606469051'
WHERE `session_id` = 'adv1d0lkurpvjvghk48r7jslg4'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE bonnie_session range PRIMARY PRIMARY 602 const 1 100.00 Using where Status Duration starting 0.1 ms checking permissions 0.0 ms Opening tables 0.0 ms init 0.0 ms System lock 0.0 ms updating 0.1 ms end 0.0 ms query end 0.0 ms closing tables 0.0 ms freeing items 0.1 ms cleaning up 0.0 ms JROOT/libraries/joomla/session/storage/database.php:84
33 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
7 × SELECT `m`.`tag_id`,`t`.*
FROM `bonnie_contentitem_tag_map` AS m
INNER JOIN `bonnie_tags` AS t
ON `m`.`tag_id` = `t`.`id`2 × SELECT template
FROM bonnie_template_styles as s2 × SELECT `extension_id`
FROM `bonnie_extensions`2 × SELECT *
FROM bonnie_extensions2 × SELECT c2.language,CONCAT_WS(':', c2.id, c2.alias) AS id
FROM bonnie_categories as c
INNER JOIN bonnie_associations as a
ON a.id = c.id
AND a.context='com_categories.item'
INNER JOIN bonnie_associations as a2
ON a.key = a2.key
INNER JOIN bonnie_categories as c2
ON a2.id = c2.id
AND c2.extension = 'com_content'2 × SELECT b.rules
FROM bonnie_assets AS a
LEFT JOIN bonnie_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt2 × SELECT m2.language, m2.id
FROM bonnie_menu as m
INNER JOIN bonnie_associations as a
ON a.id=m.id
AND a.context='com_menus.item'
INNER JOIN bonnie_associations as a2
ON a.key=a2.key
INNER JOIN bonnie_menu as m2
ON a2.id=m2.id2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM bonnie_extensions1 × SELECT COUNT(*)
FROM bonnie_content AS a
LEFT JOIN bonnie_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN bonnie_categories AS c
ON c.id = a.catid
LEFT JOIN bonnie_users AS ua
ON ua.id = a.created_by
LEFT JOIN bonnie_users AS uam
ON uam.id = a.modified_by
LEFT JOIN bonnie_categories as parent
ON parent.id = c.parent_id
LEFT JOIN bonnie_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM bonnie_categories AS cat JOIN bonnie_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT *
FROM bonnie_acymailing_list1 × SELECT *
FROM bonnie_acymailing_confi1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM bonnie_modules AS m
LEFT JOIN bonnie_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN bonnie_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × 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 bonnie_categories as c
LEFT JOIN bonnie_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 bonnie_categories AS cat JOIN bonnie_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT *
FROM bonnie_rsform_confi1 × SELECT id,template
FROM bonnie_template_styles1 × 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 bonnie_content AS a
LEFT JOIN bonnie_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN bonnie_categories AS c
ON c.id = a.catid
LEFT JOIN bonnie_users AS ua
ON ua.id = a.created_by
LEFT JOIN bonnie_users AS uam
ON uam.id = a.modified_by
LEFT JOIN bonnie_categories as parent
ON parent.id = c.parent_id
LEFT JOIN bonnie_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM bonnie_categories AS cat JOIN bonnie_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT id, home, template, s.params
FROM bonnie_template_styles as s
LEFT JOIN bonnie_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT folder AS type, element AS name, params
FROM bonnie_extensions1 × SELECT id, rules
FROM `bonnie_viewlevels1 × SELECT b.id
FROM bonnie_usergroups AS a
LEFT JOIN bonnie_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `session_id`
FROM `bonnie_session`1 × 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 bonnie_menu AS m
LEFT JOIN bonnie_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM bonnie_languages1 × SELECT a.rules
FROM bonnie_assets AS a1 × SELECT `data`
FROM `bonnie_session`1 × SELECT extension, file, type
FROM bonnie_rokcommon_configs1 × SELECT COUNT(*)
FROM `bonnie_menu`1 × 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,COUNT(i.`id`) AS numitems
FROM bonnie_categories as c
LEFT JOIN bonnie_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 bonnie_categories AS cat JOIN bonnie_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
OTHER Tables:
1 × UPDATE `bonnie_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1606469051;s:18:\"session.timer.last\";i:1606469051;s:17:\"session.timer.now\";i:1606469051;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{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\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}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:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"5ba23e8908e5e136cad3ec64493d78b3\";}' , `time` = '1606469051'1 × UPDATE `bonnie_extensions`
SET `params` = '{\"mediaversion\":\"5fcab4a031477372c06299765fc01da8\"}'1 × SHOW FULL COLUMNS
FROM `bonnie_extensions1 × INSERT INTO `bonnie_session` (`session_id`, `client_id`, `time`)
VALUES ('adv1d0lkurpvjvghk48r7jslg4', 0, '1606469051'1 × DELETE
FROM `bonnie_session`