Query Time: 0.33 ms Query memory: 0.015 MB Memory before query: 2.294 MB Rows returned: 0
SELECT `data`
FROM `j3_session`
WHERE `session_id` = '22lc48j4mecuhb64tgqpt072v7'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j3_session | NULL | const | PRIMARY | PRIMARY | 602 | const | 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 |
executing | 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:46
JROOT/libraries/joomla/session/session.php:651
JROOT/libraries/joomla/session/session.php:589
JROOT/libraries/cms/application/cms.php:668
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:42
Query Time: 0.22 ms After last query: 1.98 ms Query memory: 0.012 MB Memory before query: 2.441 MB Rows returned: 0
SELECT `session_id`
FROM `j3_session`
WHERE `session_id` = '22lc48j4mecuhb64tgqpt072v7'
LIMIT 0, 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j3_session | NULL | const | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | Using index |
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 |
executing | 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/cms/application/cms.php:175
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:42
Query Time: 0.31 ms After last query: 0.18 ms Query memory: 0.009 MB Memory before query: 2.453 MB
INSERT INTO `j3_session`
(`session_id`, `client_id`, `time`)
VALUES
('22lc48j4mecuhb64tgqpt072v7', 0, '1614972146')
EXPLAIN not possible on query: INSERT INTO `j3_session`
(`session_id`, `client_id`, `time`) VALUES
('22lc48j4mecuhb64tgqpt072v7', 0, '1614972146')
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 |
update | 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/cms/application/cms.php:207
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:42
Query Time: 0.44 ms After last query: 4.18 ms Query memory: 0.014 MB Memory before query: 2.814 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j3_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.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 |
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.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:570
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.32 ms After last query: 1.54 ms Query memory: 0.014 MB Memory before query: 2.918 MB Rows returned: 1
SELECT b.id
FROM j3_usergroups AS a
LEFT JOIN j3_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
id | 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 |
Status | Duration |
---|
starting | 0.0 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
executing | 0.0 ms |
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/libraries/joomla/access/access.php:334
JROOT/libraries/joomla/access/access.php:403
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.23 ms After last query: 0.75 ms Query memory: 0.013 MB Memory before query: 2.981 MB Rows returned: 3
SELECT id, rules
FROM `j3_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j3_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 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/libraries/joomla/access/access.php:420
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 1.23 ms After last query: 0.23 ms Query memory: 0.015 MB Memory before query: 2.999 MB Rows returned: 80
SELECT folder AS type, element AS name, params
FROM j3_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j3_extensions | NULL | ref | extension | extension | 62 | const | 120 | 2.22 | 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.8 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/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.36 ms After last query: 0.66 ms Query memory: 0.014 MB Memory before query: 3.100 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j3_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.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 |
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.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:628
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.45 ms After last query: 18.05 ms Query memory: 0.028 MB Memory before query: 4.597 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
WHERE `type` = 'component'
AND `element` = 'com_k2'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j3_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.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 |
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.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/plugins/system/k2/k2.php:435
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:583
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 1.31 ms After last query: 6.95 ms Query memory: 0.031 MB Memory before query: 5.200 MB Rows returned: 49
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 j3_menu AS m
LEFT JOIN j3_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.lft
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 1 | 5.00 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | gator_joomla3.m.component_id | 1 | 100.00 | 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.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.9 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/cms/menu/site.php:47
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:353
JROOT/libraries/cms/application/site.php:279
JROOT/libraries/cms/router/site.php:218
JROOT/libraries/cms/router/router.php:408
JROOT/libraries/cms/router/router.php:192
JROOT/libraries/cms/router/site.php:90
JROOT/libraries/cms/application/cms.php:1018
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.40 ms After last query: 4.55 ms Query memory: 0.024 MB Memory before query: 5.720 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j3_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 364 | 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.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.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:179
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/k2/k2.php:52
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.41 ms After last query: 0.31 ms Query memory: 0.017 MB Memory before query: 5.728 MB
UPDATE `j3_extensions`
SET `params` = '{\"mediaversion\":\"966205b92078637dbe77eb3062aa87b1\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | j3_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 364 | const,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.1 ms |
updating | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:230
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/k2/k2.php:52
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.29 ms After last query: 3.51 ms Query memory: 0.022 MB Memory before query: 6.105 MB Rows returned: 1
SELECT *
FROM j3_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j3_languages | NULL | system | NULL | NO INDEX KEY COULD BE USED | NULL | 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 |
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/libraries/joomla/language/helper.php:166
JROOT/libraries/cms/application/site.php:336
JROOT/components/com_k2/helpers/utilities.php:315
JROOT/administrator/components/com_k2/helpers/html.php:56
JROOT/plugins/system/k2/k2.php:55
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.37 ms After last query: 0.25 ms Query memory: 0.024 MB Memory before query: 6.144 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
WHERE `type` = 'component'
AND `element` = 'com_menus'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j3_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.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 |
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.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:363
JROOT/components/com_k2/helpers/utilities.php:315
JROOT/administrator/components/com_k2/helpers/html.php:56
JROOT/plugins/system/k2/k2.php:55
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.43 ms After last query: 2.72 ms Query memory: 0.027 MB Memory before query: 6.412 MB Rows returned: 2
SELECT id, home, template, s.params
FROM j3_template_styles as s
LEFT JOIN j3_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 = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 33.33 | Using where |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | gator_joomla3.s.template,const | 1 | 5.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.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.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/cms/application/site.php:486
JROOT/libraries/cms/html/html.php:336
JROOT/libraries/cms/html/html.php:682
JROOT/libraries/cms/html/html.php:238
JROOT/libraries/cms/html/html.php:140
JROOT/libraries/cms/html/behavior.php:63
JROOT/libraries/cms/html/html.php:238
JROOT/libraries/cms/html/html.php:140
JROOT/administrator/components/com_k2/helpers/html.php:76
JROOT/plugins/system/k2/k2.php:55
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.35 ms After last query: 5.73 ms Query memory: 0.015 MB Memory before query: 6.665 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
WHERE `type` = 'component'
AND `element` = 'com_acymailing'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j3_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.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 |
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.0 ms |
cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:328
JROOT/libraries/cms/application/site.php:135
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.55 ms After last query: 11.22 ms Query memory: 0.020 MB Memory before query: 7.567 MB Rows returned: 203
SELECT *
FROM j3_acymailing_config
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j3_acymailing_config | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 203 | 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.3 ms |
end | 0.0 ms |
query end | 0.0 ms |
closing tables | 0.0 ms |
freeing items | 0.0 ms |
cleaning up | 0.0 ms |
JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
JROOT/administrator/components/com_acymailing/helpers/helper.php:402
JROOT/administrator/components/com_acymailing/helpers/helper.php:862
JROOT/components/com_acymailing/acymailing.php:14
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 13.90 ms After last query: 8.83 ms Query memory: 0.023 MB Memory before query: 8.461 MB Rows returned: 5
SELECT a.*,b.mailid
FROM j3_acymailing_list as a
LEFT JOIN j3_acymailing_listmail as b
on a.listid = b.listid
AND b.mailid = 2119
WHERE a.type = 'list'
ORDER BY b.mailid DESC, a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | typeorderingindex,typeuseridindex | typeorderingindex | 1 | const | 4 | 100.00 | Using temporary; Using filesort |
1 | SIMPLE | b | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 10043 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
Status | Duration |
---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
optimizing | 0.0 ms |
statistics | 0.0 ms |
preparing | 0.0 ms |
Creating tmp table | 0.0 ms |
Sorting result | 0.0 ms |
executing | 0.0 ms |
Sending data | 13.4 ms |
Creating sort index | 0.1 ms |
end | 0.0 ms |
query end | 0.0 ms |
removing tmp table | 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_acymailing/classes/listmail.php:17
JROOT/components/com_acymailing/views/archive/view.html.php:451
JROOT/components/com_acymailing/views/archive/view.html.php:18
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_acymailing/controllers/archive.php:35
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_acymailing/acymailing.php:56
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.44 ms After last query: 22.68 ms Query memory: 0.048 MB Memory before query: 10.918 MB Rows returned: 1
SELECT a.*
FROM j3_acymailing_mail as a
WHERE a.mailid = '2119'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 3 | 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.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_acymailing/classes/mail.php:29
JROOT/administrator/components/com_acymailing/helpers/acymailer.php:255
JROOT/components/com_acymailing/views/archive/view.html.php:468
JROOT/components/com_acymailing/views/archive/view.html.php:18
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_acymailing/controllers/archive.php:35
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_acymailing/acymailing.php:56
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.30 ms After last query: 0.15 ms Query memory: 0.020 MB Memory before query: 10.985 MB Rows returned: 1
SELECT b.username,b.name,b.email
FROM j3_users as b
WHERE b.id = 63
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | b | NULL | const | PRIMARY | PRIMARY | 4 | 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.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.0 ms |
cleaning up | 0.0 ms |
JROOT/administrator/components/com_acymailing/classes/mail.php:33
JROOT/administrator/components/com_acymailing/helpers/acymailer.php:255
JROOT/components/com_acymailing/views/archive/view.html.php:468
JROOT/components/com_acymailing/views/archive/view.html.php:18
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_acymailing/controllers/archive.php:35
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_acymailing/acymailing.php:56
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.59 ms After last query: 1.83 ms Query memory: 0.025 MB Memory before query: 11.210 MB Rows returned: 1
SELECT *
FROM j3_acymailing_template
WHERE tempid = '3'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | j3_acymailing_template | NULL | const | PRIMARY | PRIMARY | 2 | 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.1 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_acymailing/classes/template.php:26
JROOT/administrator/components/com_acymailing/helpers/acymailer.php:280
JROOT/components/com_acymailing/views/archive/view.html.php:468
JROOT/components/com_acymailing/views/archive/view.html.php:18
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_acymailing/controllers/archive.php:35
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_acymailing/acymailing.php:56
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:45
Query Time: 0.32 ms After last query: 88.78 ms Query memory: 0.004 MB Memory before query: 12.298 MB
UPDATE `j3_session`
SET `data` = '8gbX5b3yDoKaOjDSBZDMCE6mGZKtkw1SE5pltxn3kWvm6ML4b-vUh9MJDp-zfgQCNZd1y9Jky392fmisp4Py2ghC4mOKIsyqPTQKliRDIxRsJWmQtsx6aDME8nI170AFhJBwKpeG9VzGpyYrC3Ygtg32C5FST8UGJ1XFE3FUQUo4_TXv9AvMVWsAXziCIhEEsMTagVIuWWzyyDPgcvZLlsGLHP7yLXaK0YVsQyHFsF-HlfUad_Fm6pDQkuUKO_tsq_q4o9rQgIJlZ-fs2sEGH4CGVyPpdCiOwGm2BW9oIG5xC6kvV1RhpZxnE1XpTVm3RaXrCdU8sWPr2JbwCzvgUPxseEcLEdWVMOc3k6jvDpvJVVDqaPNXqBCnDSukaemrSTp9X9B6rYaoTj3p54Nk20ug9PmUuXRukJCIJKJyh4P3URCd5u161FPpUKmvzm2jffbNI9ZDF5mVupIHIpFaGMesZenq1UAif6eGl9wIf3XpfgpG9xflcUayJCY_Uc7eKMMAIy4chKfdhG_hZxz-06fZ0ywhDWJmNESCp-Z6Y685Ng2VivXjBoJGVkt7mZDb3RWeAEgHkcu-tgXbO_IdEFV6TafE4PT6MZ6kuNLEdLA1ls_TRTNp9rhS2MVYcggNGh1G1bovMqU4ZRMySguFxCr5H-kqT8aja-RI_YHzoNzsSEaFJVF2gciVHB-cslH9RHPegNKTPkAQWnM7TnnamImz_y3veggBy4OzhSlhRBf73HSA6GwcbnjDAOg0iW5AQl5jvtQDQfhyZWbdBLXEjjnCQW0WeDFGJzifDL9mH9XcfRn9FlSzcfWk-QjHfysHrUk7VmRvSyPmQXmRzva4jMaT8IOgc1N8j-H0OcXpfvdlM8gi49G73tz_bzQXIKHKTK7hyF24J3CccFAxnc4pg7wH9heKIYnDYlG31OZ0C1Adh0IWrqDasiIpZYgW2V1CZp_YNegkHlrXmSKPGB1F-Aql4xrGPKGluz_CNqmL5HCcwvBo3oYouQN2WzrzCL_YIy85B_hxGrt3-9aa1udTebQmPWk6_egd9PCzu7tPgAYVLD0xgIK_t725_lqelemjW0oBp3O8ybTTBZAphhmkclFgLWKhrdIL4nlY4Fpt_Sy2S0qiz2fKVG2HvTepEi0cs_hWb7fPGNIDfVJDIHZetBY5J5eAr2ONO_CzjQGU__xduX2q9dUgfv1pEybgELGJcbpmwVmeGmJk3tdO94kjWAIxLRlqgKFOPDglQuxRZ7eExg99w3xbcjR7B8QIy7QR1jJP4wZR5e8StfZj3RN9t3kcBT6PDnD6Mfjghu5zIyI-QFCdxrhXnpB2T5esrauBzKTLglskoLia0W2Bi7tZ6YfoWJZH6NZ6QOdX8pI9XEyxBqWf4mERW1jw_xfmA1oZ6KmUdgoACurG5bvDdVS_Kf0cm5Pi7IdMl3NSwn7mT23pMrpx4CIPH-Xx25KUkJgJK6JiUi5V2gSykVJxKDp4CSZzyaDLklh-mVvhMG_ENNkOA8U77t5Onx31YlMqF9LQ9FtBWWwPJQMlV8LEnItGuGLqraMAkcE1YkrA2Cghtd9CHay3kgml72Gk7PWScYnfB7Al0dcdTEAMiC5t8b6N-tRBIaN9wcdzO-L7toVT5X2cI5AT1_NaPiccFRaLgSp18Dwsp-Nt_0rKHY3GsX7-8kHTZxQPPsYse6rMcNstaEt3fD91o7wJZv2NVufPQ86G6_uJFSHQR7RaotERFVYkWA..'
, `time` = '1614972146'
WHERE `session_id` = '22lc48j4mecuhb64tgqpt072v7'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | j3_session | NULL | range | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
init | 0.0 ms |
System lock | 0.0 ms |
updating | 0.1 ms |
end | 0.0 ms |
query end | 0.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
JROOT/libraries/joomla/session/session.php:830
6 × SELECT extension_id AS id, element AS "option", params, enabled
FROM j3_extensions
1 × SELECT a.*,b.mailid
FROM j3_acymailing_list as a
LEFT JOIN j3_acymailing_listmail as b
on a.listid = b.listid
AND b.mailid = 2119
1 × SELECT *
FROM j3_acymailing_confi
1 × SELECT a.*
FROM j3_acymailing_mail as a
1 × SELECT b.username,b.name,b.email
FROM j3_users as b
1 × SELECT *
FROM j3_acymailing_template
1 × SELECT id, home, template, s.params
FROM j3_template_styles as s
LEFT JOIN j3_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
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 j3_menu AS m
LEFT JOIN j3_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT b.id
FROM j3_usergroups AS a
LEFT JOIN j3_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `j3_session`
1 × SELECT id, rules
FROM `j3_viewlevels
1 × SELECT folder AS type, element AS name, params
FROM j3_extensions
1 × SELECT `data`
FROM `j3_session`
1 × SELECT *
FROM j3_languages