Query Time: 0.53 ms Query memory: 0.015 MB Memory before query: 2.680 MB Rows returned: 0
SELECT `data`
FROM `mua3d_session`
WHERE `session_id` = '4fa3a581b5a74010f2e05173bbc404d9'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_session | NULL | const | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.3 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 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:658
JROOT/libraries/joomla/session/session.php:596
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:37
Query Time: 2159.40 ms After last query: 2.08 ms Query memory: 0.008 MB Memory before query: 2.855 MB
DELETE
FROM `mua3d_session`
WHERE `time` < '1606343861'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | DELETE | mua3d_session | NULL | range | time | time | 45 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.1 ms |
| updating | 0.1 ms |
| end | 0.0 ms |
| query end | 2159.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/cms/application/cms.php:685
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:37
Query Time: 0.54 ms After last query: 0.41 ms Query memory: 0.012 MB Memory before query: 2.867 MB Rows returned: 0
SELECT `session_id`
FROM `mua3d_session`
WHERE `session_id` = '4fa3a581b5a74010f2e05173bbc404d9'
LIMIT 0, 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_session | NULL | const | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | Using index |
| 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 |
| executing | 0.0 ms |
| end | 0.0 ms |
| query end | 0.1 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/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:37
Query Time: 86.77 ms After last query: 0.18 ms Query memory: 0.009 MB Memory before query: 2.880 MB
INSERT INTO `mua3d_session`
(`session_id`, `client_id`, `time`)
VALUES
('4fa3a581b5a74010f2e05173bbc404d9', 0, '1606352863')
EXPLAIN not possible on query: INSERT INTO `mua3d_session`
(`session_id`, `client_id`, `time`) VALUES
('4fa3a581b5a74010f2e05173bbc404d9', 0, '1606352863')
| 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 | 86.5 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:37
Query Time: 0.85 ms After last query: 4.58 ms Query memory: 0.015 MB Memory before query: 3.305 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM mua3d_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 | mua3d_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.3 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/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:40
Query Time: 0.43 ms After last query: 1.51 ms Query memory: 0.014 MB Memory before query: 3.434 MB Rows returned: 2
SELECT b.id
FROM mua3d_usergroups AS a
LEFT JOIN mua3d_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| 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; Using index |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.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/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:40
Query Time: 0.25 ms After last query: 0.76 ms Query memory: 0.013 MB Memory before query: 3.504 MB Rows returned: 5
SELECT id, rules
FROM `mua3d_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/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:40
Query Time: 0.77 ms After last query: 0.24 ms Query memory: 0.014 MB Memory before query: 3.524 MB Rows returned: 65
SELECT folder AS type, element AS name, params
FROM mua3d_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_extensions | NULL | ref | extension | extension | 62 | const | 84 | 3.33 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.5 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:40
Query Time: 0.21 ms After last query: 0.63 ms Query memory: 0.014 MB Memory before query: 3.612 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM mua3d_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 | mua3d_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:40
Query Time: 0.42 ms After last query: 13.61 ms Query memory: 0.013 MB Memory before query: 5.076 MB Rows returned: 1
SELECT `enabled`
FROM `mua3d_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_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/plugins/system/backuponupdate/backuponupdate.php:50
JROOT/libraries/cms/plugin/helper.php:232
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:582
JROOT/libraries/cms/application/site.php:649
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
Query Time: 1.34 ms After last query: 12.48 ms Query memory: 0.029 MB Memory before query: 6.201 MB Rows returned: 16
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 mua3d_menu AS m
LEFT JOIN mua3d_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 | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 58 | 10.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.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.3 ms |
| init | 0.1 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.5 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:40
Query Time: 0.59 ms After last query: 2.66 ms Query memory: 0.018 MB Memory before query: 6.510 MB Rows returned: 7
SELECT id, home, template, s.params
FROM mua3d_template_styles as s
LEFT JOIN mua3d_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 | 9 | 11.11 | Using where |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | fortest_choppers.s.template,const | 1 | 4.53 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.2 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.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/plugins/system/jmframework/jmframework.php:138
JROOT/plugins/system/jmframework/jmframework.php:86
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:40
Query Time: 0.29 ms After last query: 6.70 ms Query memory: 0.024 MB Memory before query: 7.120 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM mua3d_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,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.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/sef/sef.php:30
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:40
Query Time: 73.35 ms After last query: 0.26 ms Query memory: 0.018 MB Memory before query: 7.127 MB
UPDATE `mua3d_extensions`
SET `params` = '{\"mediaversion\":\"9a701f2bf1a7f3a57209ad4e45f8902d\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | mua3d_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.1 ms |
| updating | 0.1 ms |
| end | 0.0 ms |
| query end | 73.1 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/sef/sef.php:30
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:40
Query Time: 0.31 ms After last query: 3.41 ms Query memory: 0.028 MB Memory before query: 7.466 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM mua3d_extensions
WHERE `type` = 'component'
AND `element` = 'com_contact'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_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/components/com_contact/router.php:37
JROOT/libraries/cms/router/site.php:463
JROOT/libraries/cms/router/site.php:426
JROOT/libraries/cms/router/router.php:231
JROOT/libraries/cms/router/site.php:106
JROOT/libraries/joomla/application/route.php:64
JROOT/plugins/system/sef/sef.php:49
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:40
Query Time: 0.44 ms After last query: 1.09 ms Query memory: 0.014 MB Memory before query: 7.539 MB Rows returned: 1
SELECT *
FROM mua3d_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 | mua3d_languages | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/language/helper.php:166
JROOT/libraries/cms/application/site.php:336
JROOT/libraries/cms/application/site.php:135
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
Query Time: 81.21 ms After last query: 432.17 ms Query memory: 0.023 MB Memory before query: 8.713 MB Rows returned: 1
SELECT a.rules
FROM mua3d_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
| 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 |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 80.8 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/access/access.php:248
JROOT/libraries/joomla/user/user.php:364
JROOT/components/com_contact/models/contact.php:54
JROOT/libraries/legacy/model/legacy.php:415
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_contact/views/contact/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.58 ms After last query: 0.86 ms Query memory: 0.024 MB Memory before query: 8.772 MB Rows returned: 2
SELECT b.rules
FROM mua3d_assets AS a
LEFT JOIN mua3d_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_contact')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | idx_asset_name | idx_asset_name | 152 | const | 1 | 100.00 | Using temporary; Using filesort |
| 1 | SIMPLE | b | NULL | range | idx_lft_rgt | idx_lft_rgt | 4 | NULL | 7 | 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 |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| Creating sort index | 0.0 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/libraries/joomla/access/access.php:248
JROOT/libraries/joomla/access/access.php:109
JROOT/libraries/joomla/user/user.php:373
JROOT/components/com_contact/models/contact.php:54
JROOT/libraries/legacy/model/legacy.php:415
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_contact/views/contact/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.95 ms After last query: 0.39 ms Query memory: 0.031 MB Memory before query: 8.806 MB Rows returned: 1
SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM mua3d_contact_details AS a
LEFT JOIN mua3d_categories AS c
on c.id = a.catid
LEFT JOIN mua3d_categories as parent
ON parent.id = c.parent_id
WHERE a.id = 10
AND (a.published = 1 OR a.published =2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-26 01:07:44')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-26 01:07:44')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY,idx_state | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | parent | NULL | const | PRIMARY | PRIMARY | 4 | const | 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 |
| Opening tables | 0.4 ms |
| init | 0.1 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.0 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_contact/models/contact.php:171
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_contact/views/contact/view.html.php:43
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.32 ms After last query: 141.09 ms Query memory: 0.027 MB Memory before query: 9.079 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM mua3d_extensions
WHERE `type` = 'component'
AND `element` = 'com_tags'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_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/libraries/cms/helper/tags.php:392
JROOT/components/com_contact/models/contact.php:195
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_contact/views/contact/view.html.php:43
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.95 ms After last query: 0.20 ms Query memory: 0.027 MB Memory before query: 9.086 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `mua3d_contentitem_tag_map` AS m
INNER JOIN `mua3d_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.contact'
AND `m`.`content_item_id` = 10
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 50.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | fortest_choppers.m.tag_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.4 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.3 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/helper/tags.php:412
JROOT/components/com_contact/models/contact.php:195
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_contact/views/contact/view.html.php:43
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.33 ms After last query: 0.22 ms Query memory: 0.031 MB Memory before query: 9.108 MB Rows returned: 1
SELECT a.*, cc.access as category_access, cc.title as category_name,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM mua3d_contact_details AS a
INNER JOIN mua3d_categories AS cc
on cc.id = a.catid
WHERE a.id = 10
AND a.published IN (1,2)
AND cc.published IN (1,2)
AND a.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY,idx_access,idx_state,idx_catid | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | cc | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 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.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_contact/models/contact.php:292
JROOT/components/com_contact/models/contact.php:230
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_contact/views/contact/view.html.php:43
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.78 ms After last query: 0.59 ms Query memory: 0.022 MB Memory before query: 9.160 MB Rows returned: 0
SELECT a.id,a.title,a.state,a.access,a.created,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
FROM mua3d_content as a
LEFT JOIN mua3d_categories as c
on a.catid=c.id
WHERE a.created_by = 153
AND a.access IN (1,1,5)
AND a.state IN (1,2)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-26 01:07:44')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-26 01:07:44')
ORDER BY a.state DESC, a.created DESC
LIMIT 0, 10
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | idx_access,idx_state,idx_createdby | idx_createdby | 4 | const | 1 | 5.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.a.catid | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.3 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_contact/models/contact.php:360
JROOT/components/com_contact/models/contact.php:230
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_contact/views/contact/view.html.php:43
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 1.08 ms After last query: 217.09 ms Query memory: 0.033 MB Memory before query: 9.729 MB Rows returned: 16
SHOW FULL COLUMNS
FROM `mua3d_users`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `mua3d_users`
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Opening tables | 0.2 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Sending data | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| removing tmp table | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/table/table.php:237
JROOT/libraries/joomla/table/table.php:158
JROOT/libraries/joomla/table/user.php:38
JROOT/libraries/joomla/table/table.php:301
JROOT/administrator/components/com_users/models/user.php:52
JROOT/libraries/legacy/model/admin.php:832
JROOT/administrator/components/com_users/models/user.php:68
JROOT/components/com_contact/models/contact.php:366
JROOT/components/com_contact/models/contact.php:230
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_contact/views/contact/view.html.php:43
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.29 ms After last query: 148.25 ms Query memory: 0.028 MB Memory before query: 9.819 MB Rows returned: 0
SELECT *
FROM `mua3d_users`
WHERE `id` = 153
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| 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 |
| 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/table/user.php:84
JROOT/libraries/legacy/model/admin.php:837
JROOT/administrator/components/com_users/models/user.php:68
JROOT/components/com_contact/models/contact.php:366
JROOT/components/com_contact/models/contact.php:230
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_contact/views/contact/view.html.php:43
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.29 ms After last query: 0.33 ms Query memory: 0.023 MB Memory before query: 9.842 MB Rows returned: 0
SELECT `t`.`id`
FROM `mua3d_tags` AS t
INNER JOIN `mua3d_contentitem_tag_map` AS m
ON `m`.`tag_id` = `t`.`id`
AND `m`.`type_alias` = 'com_users.user'
AND `m`.`content_item_id` IN ( 153)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 50.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.m.tag_id | 1 | 100.00 | Using index |
| 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 |
| 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/cms/helper/tags.php:464
JROOT/administrator/components/com_users/models/user.php:71
JROOT/components/com_contact/models/contact.php:366
JROOT/components/com_contact/models/contact.php:230
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_contact/views/contact/view.html.php:43
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 1.03 ms After last query: 106.50 ms Query memory: 0.026 MB Memory before query: 10.074 MB Rows returned: 0
SELECT profile_key, profile_value
FROM mua3d_user_profiles
WHERE user_id = 153
AND profile_key LIKE 'profile.%'
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_user_profiles | NULL | range | idx_user_id_profile_key | idx_user_id_profile_key | 306 | NULL | 1 | 100.00 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.3 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.3 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/plugins/user/profile/profile.php:85
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/administrator/components/com_users/models/user.php:78
JROOT/components/com_contact/models/contact.php:366
JROOT/components/com_contact/models/contact.php:230
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_contact/views/contact/view.html.php:43
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 1.58 ms After last query: 137.63 ms Query memory: 0.023 MB Memory before query: 11.329 MB Rows returned: 1
SELECT COUNT(*)
FROM `mua3d_contact_details` AS a
LEFT JOIN mua3d_categories AS c
ON c.id = a.catid
LEFT JOIN mua3d_users AS ua
ON ua.id = a.created_by
LEFT JOIN mua3d_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.catid = 16
AND c.access IN (1,1,5)
AND a.published = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | a | NULL | ALL | idx_access,idx_state,idx_catid | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.a.created_by | 1 | 100.00 | Using where; Using index |
| 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.a.modified_by | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.6 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.2 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.4 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/legacy/model/legacy.php:327
JROOT/libraries/legacy/model/list.php:276
JROOT/libraries/legacy/model/list.php:310
JROOT/libraries/legacy/model/list.php:171
JROOT/components/com_contact/models/category.php:87
JROOT/components/com_contact/views/contact/view.html.php:61
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.56 ms After last query: 0.17 ms Query memory: 0.032 MB Memory before query: 11.342 MB Rows returned: 3
SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `mua3d_contact_details` AS a
LEFT JOIN mua3d_categories AS c
ON c.id = a.catid
LEFT JOIN mua3d_users AS ua
ON ua.id = a.created_by
LEFT JOIN mua3d_users AS uam
ON uam.id = a.modified_by
WHERE a.access IN (1,1,5)
AND a.catid = 16
AND c.access IN (1,1,5)
AND a.published = 1
ORDER BY a.name asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | 100.00 | Using filesort |
| 1 | SIMPLE | a | NULL | ALL | idx_access,idx_state,idx_catid | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 100.00 | Using where |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.a.created_by | 1 | 100.00 | Using where |
| 1 | SIMPLE | uam | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.a.modified_by | 1 | 100.00 | Using where; Using index |
| 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.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/legacy/model/legacy.php:301
JROOT/libraries/legacy/model/list.php:171
JROOT/components/com_contact/models/category.php:87
JROOT/components/com_contact/views/contact/view.html.php:61
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.28 ms After last query: 0.42 ms Query memory: 0.026 MB Memory before query: 11.407 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `mua3d_contentitem_tag_map` AS m
INNER JOIN `mua3d_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.contact'
AND `m`.`content_item_id` = 9
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 50.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | fortest_choppers.m.tag_id | 1 | 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.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/cms/helper/tags.php:412
JROOT/components/com_contact/models/category.php:100
JROOT/components/com_contact/views/contact/view.html.php:61
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.25 ms After last query: 0.27 ms Query memory: 0.026 MB Memory before query: 11.433 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `mua3d_contentitem_tag_map` AS m
INNER JOIN `mua3d_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.contact'
AND `m`.`content_item_id` = 1
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 50.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | fortest_choppers.m.tag_id | 1 | 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/cms/helper/tags.php:412
JROOT/components/com_contact/models/category.php:100
JROOT/components/com_contact/views/contact/view.html.php:61
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.23 ms After last query: 0.25 ms Query memory: 0.026 MB Memory before query: 11.458 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `mua3d_contentitem_tag_map` AS m
INNER JOIN `mua3d_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.contact'
AND `m`.`content_item_id` = 10
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 50.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | fortest_choppers.m.tag_id | 1 | 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/cms/helper/tags.php:412
JROOT/components/com_contact/models/category.php:100
JROOT/components/com_contact/views/contact/view.html.php:61
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.40 ms After last query: 30.04 ms Query memory: 0.025 MB Memory before query: 11.547 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `mua3d_contentitem_tag_map` AS m
INNER JOIN `mua3d_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_contact.contact'
AND `m`.`content_item_id` = 10
AND `t`.`published` = 1
AND t.access IN (1,1,5)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ALL | idx_tag_type,idx_tag | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 50.00 | Using where |
| 1 | SIMPLE | t | NULL | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | fortest_choppers.m.tag_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 |
| 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/cms/helper/tags.php:412
JROOT/components/com_contact/views/contact/view.html.php:216
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 87.58 ms After last query: 37.90 ms Query memory: 0.029 MB Memory before query: 11.617 MB Rows returned: 43
SHOW FULL COLUMNS
FROM `mua3d_contact_details`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `mua3d_contact_details`
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 86.7 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Opening tables | 0.0 ms |
| checking permissions | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Sending data | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| removing tmp table | 0.1 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/table/table.php:237
JROOT/libraries/joomla/table/table.php:158
JROOT/administrator/components/com_contact/tables/contact.php:35
JROOT/libraries/joomla/table/table.php:301
JROOT/components/com_contact/models/contact.php:408
JROOT/components/com_contact/views/contact/view.html.php:235
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.48 ms After last query: 187.39 ms Query memory: 0.030 MB Memory before query: 11.831 MB Rows returned: 1
SELECT *
FROM mua3d_contact_details
WHERE `id` = '10'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_contact_details | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 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.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/table/table.php:723
JROOT/components/com_contact/models/contact.php:409
JROOT/components/com_contact/views/contact/view.html.php:235
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 77.30 ms After last query: 0.24 ms Query memory: 0.016 MB Memory before query: 11.846 MB
UPDATE mua3d_contact_details
SET `hits` = (`hits` + 1)
WHERE `id` = '10'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | mua3d_contact_details | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| updating | 0.1 ms |
| end | 0.0 ms |
| query end | 77.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/table/table.php:1233
JROOT/components/com_contact/models/contact.php:410
JROOT/components/com_contact/views/contact/view.html.php:235
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 0.51 ms After last query: 53.98 ms Query memory: 0.027 MB Memory before query: 12.041 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM mua3d_extensions
WHERE `type` = 'component'
AND `element` = 'com_media'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_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.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/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/components/com_contact/views/contact/tmpl/default.php:12
JROOT/libraries/legacy/view/legacy.php:663
JROOT/libraries/legacy/view/legacy.php:211
JROOT/components/com_contact/views/contact/view.html.php:238
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_contact/controller.php:41
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_contact/contact.php:15
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:40
Query Time: 1.99 ms After last query: 474.84 ms Query memory: 0.023 MB Memory before query: 14.108 MB Rows returned: 20
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mua3d_modules AS m
LEFT JOIN mua3d_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mua3d_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-26 01:07:44')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-26 01:07:44')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 472 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 40 | 1.60 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 303 | fortest_choppers.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | fortest_choppers.m.id | 3 | 40.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.4 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.2 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/module/helper.php:376
JROOT/libraries/cms/module/helper.php:84
JROOT/libraries/joomla/document/html/html.php:497
JROOT/plugins/system/jmframework/includes/libraries/template.php:167
JROOT/templates/jm-car-dealer/lib/jm_template.php:20
JROOT/plugins/system/jmframework/includes/libraries/template.php:58
JROOT/templates/jm-car-dealer/index.php:18
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 1.41 ms After last query: 11.88 ms Query memory: 0.026 MB Memory before query: 15.179 MB Rows returned: 20
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mua3d_modules AS m
LEFT JOIN mua3d_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mua3d_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-26 01:07:44')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-26 01:07:44')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 472 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 40 | 1.60 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 303 | fortest_choppers.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | fortest_choppers.m.id | 3 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.1 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 |
| 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/module/helper.php:376
JROOT/libraries/cms/module/helper.php:84
JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:49
JROOT/templates/jm-car-dealer/tpl/blocks/footer-mod.php:21
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/templates/jm-car-dealer/tpl/default.php:60
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/plugins/system/jmframework/includes/libraries/template.php:211
JROOT/templates/jm-car-dealer/index.php:40
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.66 ms After last query: 5.37 ms Query memory: 0.061 MB Memory before query: 15.558 MB Rows returned: 1
SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_maps as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
WHERE h.id=1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | h | NULL | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 0 | 0.00 | unique row not found |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.2 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.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/modules/mod_zhgooglemap/helpers/mod_zhgooglemap.php:33
JROOT/modules/mod_zhgooglemap/tmpl/default.php:20
JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:16
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:67
JROOT/templates/jm-car-dealer/tpl/blocks/footer-mod.php:21
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/templates/jm-car-dealer/tpl/default.php:60
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/plugins/system/jmframework/includes/libraries/template.php:211
JROOT/templates/jm-car-dealer/index.php:40
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.74 ms After last query: 2.04 ms Query memory: 0.063 MB Memory before query: 15.642 MB Rows returned: 0
SELECT h.*, c.title as category, g.icontype as groupicontype, g.overridemarkericon as overridemarkericon, g.published as publishedgroup, g.markermanagerminzoom as markermanagerminzoom, g.markermanagermaxzoom as markermanagermaxzoom, g.activeincluster as activeincluster, bub.disableanimation, bub.shadowstyle, bub.padding, bub.borderradius, bub.borderwidth, bub.bordercolor, bub.backgroundcolor, bub.minwidth, bub.maxwidth, bub.minheight, bub.maxheight, bub.arrowsize, bub.arrowposition, bub.arrowstyle, bub.disableautopan, bub.hideclosebutton, bub.backgroundclassname, bub.published infobubblepublished
FROM mua3d_zhgooglemaps_markers as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
LEFT JOIN mua3d_zhgooglemaps_markergroups as g
ON h.markergroup=g.id
LEFT JOIN mua3d_zhgooglemaps_infobubbles as bub
ON h.tabid=bub.id
WHERE 1=1
and h.mapid=1
and h.published=1
AND (h.publish_up = '0000-00-00 00:00:00' OR h.publish_up <= '2020-11-26 01:07:44')
AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2020-11-26 01:07:44')
ORDER BY h.title
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| 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.3 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| executing | 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/modules/mod_zhgooglemap/helpers/mod_zhgooglemap.php:222
JROOT/modules/mod_zhgooglemap/tmpl/default.php:55
JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:16
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:67
JROOT/templates/jm-car-dealer/tpl/blocks/footer-mod.php:21
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/templates/jm-car-dealer/tpl/default.php:60
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/plugins/system/jmframework/includes/libraries/template.php:211
JROOT/templates/jm-car-dealer/index.php:40
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.27 ms After last query: 0.12 ms Query memory: 0.038 MB Memory before query: 15.666 MB Rows returned: 0
SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_paths as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
WHERE h.published=1
and h.mapid=1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| 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/modules/mod_zhgooglemap/helpers/mod_zhgooglemap.php:571
JROOT/modules/mod_zhgooglemap/tmpl/default.php:56
JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:16
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:67
JROOT/templates/jm-car-dealer/tpl/blocks/footer-mod.php:21
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/templates/jm-car-dealer/tpl/default.php:60
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/plugins/system/jmframework/includes/libraries/template.php:211
JROOT/templates/jm-car-dealer/index.php:40
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.24 ms After last query: 0.11 ms Query memory: 0.033 MB Memory before query: 15.692 MB Rows returned: 0
SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_routers as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
WHERE h.published=1
and h.mapid=1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| 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/modules/mod_zhgooglemap/helpers/mod_zhgooglemap.php:243
JROOT/modules/mod_zhgooglemap/tmpl/default.php:57
JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:16
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:67
JROOT/templates/jm-car-dealer/tpl/blocks/footer-mod.php:21
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/templates/jm-car-dealer/tpl/default.php:60
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/plugins/system/jmframework/includes/libraries/template.php:211
JROOT/templates/jm-car-dealer/index.php:40
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.23 ms After last query: 0.12 ms Query memory: 0.032 MB Memory before query: 15.719 MB Rows returned: 0
SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_maptypes as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
WHERE h.published=1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| 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/modules/mod_zhgooglemap/helpers/mod_zhgooglemap.php:589
JROOT/modules/mod_zhgooglemap/tmpl/default.php:58
JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:16
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:67
JROOT/templates/jm-car-dealer/tpl/blocks/footer-mod.php:21
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/templates/jm-car-dealer/tpl/default.php:60
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/plugins/system/jmframework/includes/libraries/template.php:211
JROOT/templates/jm-car-dealer/index.php:40
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.24 ms After last query: 0.14 ms Query memory: 0.030 MB Memory before query: 15.748 MB Rows returned: 0
SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_adsences as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
WHERE h.published=1
and h.mapid=1
AND (h.publish_up = '0000-00-00 00:00:00' OR h.publish_up <= '2020-11-26 01:07:44')
AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2020-11-26 01:07:44')
ORDER BY h.title
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| 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/modules/mod_zhgooglemap/helpers/mod_zhgooglemap.php:622
JROOT/modules/mod_zhgooglemap/tmpl/default.php:59
JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:16
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:67
JROOT/templates/jm-car-dealer/tpl/blocks/footer-mod.php:21
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/templates/jm-car-dealer/tpl/default.php:60
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/plugins/system/jmframework/includes/libraries/template.php:211
JROOT/templates/jm-car-dealer/index.php:40
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.22 ms After last query: 0.15 ms Query memory: 0.031 MB Memory before query: 15.775 MB Rows returned: 0
SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_markergroups as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
WHERE EXISTS (SELECT 1
FROM mua3d_zhgooglemaps_markers as m
WHERE m.markergroup=h.id
and m.mapid=1
and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-11-26 01:07:44')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-26 01:07:44'))
ORDER BY h.title
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| 2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.1 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.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/modules/mod_zhgooglemap/helpers/mod_zhgooglemap.php:367
JROOT/modules/mod_zhgooglemap/tmpl/default.php:61
JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:16
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:67
JROOT/templates/jm-car-dealer/tpl/blocks/footer-mod.php:21
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/templates/jm-car-dealer/tpl/default.php:60
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/plugins/system/jmframework/includes/libraries/template.php:211
JROOT/templates/jm-car-dealer/index.php:40
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.19 ms After last query: 0.14 ms Query memory: 0.031 MB Memory before query: 15.802 MB Rows returned: 0
SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_markergroups as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
WHERE EXISTS (SELECT 1
FROM mua3d_zhgooglemaps_markers as m
WHERE m.markergroup=h.id
and m.mapid=1
and (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-11-26 01:07:44')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-26 01:07:44'))
ORDER BY h.title
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| 2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 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.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/modules/mod_zhgooglemap/helpers/mod_zhgooglemap.php:551
JROOT/modules/mod_zhgooglemap/tmpl/default.php:62
JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:16
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:67
JROOT/templates/jm-car-dealer/tpl/blocks/footer-mod.php:21
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/templates/jm-car-dealer/tpl/default.php:60
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/plugins/system/jmframework/includes/libraries/template.php:211
JROOT/templates/jm-car-dealer/index.php:40
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.27 ms After last query: 0.25 ms Query memory: 0.033 MB Memory before query: 15.846 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM mua3d_extensions
WHERE `type` = 'component'
AND `element` = 'com_zhgooglemap'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_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/modules/mod_zhgooglemap/helpers/mod_zhgooglemap.php:655
JROOT/modules/mod_zhgooglemap/tmpl/default.php:96
JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:16
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:67
JROOT/templates/jm-car-dealer/tpl/blocks/footer-mod.php:21
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/templates/jm-car-dealer/tpl/default.php:60
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/plugins/system/jmframework/includes/libraries/template.php:211
JROOT/templates/jm-car-dealer/index.php:40
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.58 ms After last query: 24.25 ms Query memory: 0.037 MB Memory before query: 16.487 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM mua3d_extensions
WHERE `type` = 'component'
AND `element` = 'com_djcatalog2'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,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.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/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/components/com_djcatalog2/router.php:37
JROOT/libraries/cms/component/router/legacy.php:70
JROOT/libraries/cms/router/site.php:463
JROOT/libraries/cms/router/site.php:426
JROOT/libraries/cms/router/router.php:231
JROOT/libraries/cms/router/site.php:106
JROOT/libraries/joomla/application/route.php:64
JROOT/modules/mod_breadcrumbs/helper.php:51
JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.27 ms After last query: 6.32 ms Query memory: 0.032 MB Memory before query: 16.893 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM mua3d_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_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/components/com_content/router.php:37
JROOT/libraries/cms/router/site.php:463
JROOT/libraries/cms/router/site.php:426
JROOT/libraries/cms/router/router.php:231
JROOT/libraries/cms/router/site.php:106
JROOT/libraries/joomla/application/route.php:64
JROOT/modules/mod_menu/helper.php:125
JROOT/modules/mod_djmegamenu/helper.php:58
JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:41
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 83.57 ms After last query: 13.74 ms Query memory: 0.031 MB Memory before query: 17.197 MB Rows returned: 22
SELECT c.*, img.fullname AS item_image, img.caption AS image_caption, img.path as image_path, img.fullpath as image_fullpath
FROM mua3d_djc2_categories AS c
LEFT JOIN mua3d_djc2_images as img
on img.id = (select id
from mua3d_djc2_images
where type='category'
and item_id = c.id
order by ordering asc
limit 1)
ORDER BY c.parent_id ASC, c.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | c | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 21 | 100.00 | Using filesort |
| 1 | PRIMARY | img | NULL | eq_ref | PRIMARY | PRIMARY | 4 | func | 1 | 100.00 | Using where |
| 2 | DEPENDENT SUBQUERY | mua3d_djc2_images | NULL | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_item_type_ordering | 198 | fortest_choppers.c.id,const | 3 | 100.00 | Using where; Using index; Using filesort |
| Status | Duration |
|---|
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/administrator/components/com_djcatalog2/lib/categories.php:277
JROOT/administrator/components/com_djcatalog2/lib/categories.php:154
JROOT/administrator/components/com_djcatalog2/lib/categories.php:190
JROOT/components/com_djcatalog2/helpers/djcatalog2.php:64
JROOT/components/com_djcatalog2/helpers/theme.php:39
JROOT/modules/mod_djc2cart/mod_djc2cart.php:39
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 61.56 ms After last query: 10.73 ms Query memory: 0.003 MB Memory before query: 17.593 MB
UPDATE `mua3d_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1606352861;s:18:\"session.timer.last\";i:1606352861;s:17:\"session.timer.now\";i:1606352861;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"15fbf413367b8b798c8e3a8db0db9402\";}'
, `time` = '1606352866'
WHERE `session_id` = '4fa3a581b5a74010f2e05173bbc404d9'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | mua3d_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.1 ms |
| updating | 0.2 ms |
| end | 0.0 ms |
| query end | 61.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
9 × SELECT extension_id AS id, element AS "option", params, enabled
FROM mua3d_extensions
5 × SELECT `m`.`tag_id`,`t`.*
FROM `mua3d_contentitem_tag_map` AS m
INNER JOIN `mua3d_tags` AS t
ON `m`.`tag_id` = `t`.`id`
2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM mua3d_modules AS m
LEFT JOIN mua3d_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN mua3d_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
2 × SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_markergroups as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
1 × SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
FROM `mua3d_contact_details` AS a
LEFT JOIN mua3d_categories AS c
ON c.id = a.catid
LEFT JOIN mua3d_users AS ua
ON ua.id = a.created_by
LEFT JOIN mua3d_users AS uam
ON uam.id = a.modified_by
1 × SELECT *
FROM mua3d_contact_details
1 × SELECT COUNT(*)
FROM `mua3d_contact_details` AS a
LEFT JOIN mua3d_categories AS c
ON c.id = a.catid
LEFT JOIN mua3d_users AS ua
ON ua.id = a.created_by
LEFT JOIN mua3d_users AS uam
ON uam.id = a.modified_by
1 × SELECT profile_key, profile_value
FROM mua3d_user_profiles
1 × SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_maps as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
1 × SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_paths as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
1 × SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_adsences as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
1 × SELECT c.*, img.fullname AS item_image, img.caption AS image_caption, img.path as image_path, img.fullpath as image_fullpath
FROM mua3d_djc2_categories AS c
LEFT JOIN mua3d_djc2_images as img
on img.id = (select id
from mua3d_djc2_images
1 × SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_maptypes as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
1 × SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_routers as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
1 × SELECT `t`.`id`
FROM `mua3d_tags` AS t
INNER JOIN `mua3d_contentitem_tag_map` AS m
ON `m`.`tag_id` = `t`.`id`
AND `m`.`type_alias` = 'com_users.user'
AND `m`.`content_item_id` IN ( 153
1 × SELECT h.*, c.title as category, g.icontype as groupicontype, g.overridemarkericon as overridemarkericon, g.published as publishedgroup, g.markermanagerminzoom as markermanagerminzoom, g.markermanagermaxzoom as markermanagermaxzoom, g.activeincluster as activeincluster, bub.disableanimation, bub.shadowstyle, bub.padding, bub.borderradius, bub.borderwidth, bub.bordercolor, bub.backgroundcolor, bub.minwidth, bub.maxwidth, bub.minheight, bub.maxheight, bub.arrowsize, bub.arrowposition, bub.arrowstyle, bub.disableautopan, bub.hideclosebutton, bub.backgroundclassname, bub.published infobubblepublished
FROM mua3d_zhgooglemaps_markers as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
LEFT JOIN mua3d_zhgooglemaps_markergroups as g
ON h.markergroup=g.id
LEFT JOIN mua3d_zhgooglemaps_infobubbles as bub
ON h.tabid=bub.id
1 × SELECT a.id,a.title,a.state,a.access,a.created,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
FROM mua3d_content as a
LEFT JOIN mua3d_categories as c
on a.catid=c.id
1 × SELECT `enabled`
FROM `mua3d_extensions`
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 mua3d_menu AS m
LEFT JOIN mua3d_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params
FROM mua3d_extensions
1 × SELECT id, rules
FROM `mua3d_viewlevels
1 × SELECT `session_id`
FROM `mua3d_session`
1 × SELECT b.id
FROM mua3d_usergroups AS a
LEFT JOIN mua3d_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, home, template, s.params
FROM mua3d_template_styles as s
LEFT JOIN mua3d_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM mua3d_languages
1 × SELECT a.*, cc.access as category_access, cc.title as category_name,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM mua3d_contact_details AS a
INNER JOIN mua3d_categories AS cc
on cc.id = a.catid
1 × SELECT `data`
FROM `mua3d_session`
1 × SELECT a.*,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
FROM mua3d_contact_details AS a
LEFT JOIN mua3d_categories AS c
on c.id = a.catid
LEFT JOIN mua3d_categories as parent
ON parent.id = c.parent_id
1 × SELECT b.rules
FROM mua3d_assets AS a
LEFT JOIN mua3d_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT a.rules
FROM mua3d_assets AS a
1 × SELECT *
FROM `mua3d_users`
