Query Time: 0.37 ms Query memory: 0.015 MB Memory before query: 2.678 MB Rows returned: 0
SELECT `data`
FROM `mua3d_session`
WHERE `session_id` = 'e58f99f9a0ceb2e19448cef31fe7a6e8'
| 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.1 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: 0.15 ms After last query: 1.99 ms Query memory: 0.012 MB Memory before query: 2.854 MB Rows returned: 0
SELECT `session_id`
FROM `mua3d_session`
WHERE `session_id` = 'e58f99f9a0ceb2e19448cef31fe7a6e8'
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.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| executing | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/cms/application/cms.php:175
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
Query Time: 0.86 ms After last query: 0.15 ms Query memory: 0.009 MB Memory before query: 2.866 MB
INSERT INTO `mua3d_session`
(`session_id`, `client_id`, `time`)
VALUES
('e58f99f9a0ceb2e19448cef31fe7a6e8', 0, '1606351182')
EXPLAIN not possible on query: INSERT INTO `mua3d_session`
(`session_id`, `client_id`, `time`) VALUES
('e58f99f9a0ceb2e19448cef31fe7a6e8', 0, '1606351182')
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| update | 0.1 ms |
| end | 0.0 ms |
| query end | 0.7 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.42 ms After last query: 4.04 ms Query memory: 0.015 MB Memory before query: 3.294 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.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.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.34 ms After last query: 1.43 ms Query memory: 0.014 MB Memory before query: 3.423 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.1 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.19 ms After last query: 0.75 ms Query memory: 0.013 MB Memory before query: 3.493 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.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/access/access.php:420
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
Query Time: 0.78 ms After last query: 0.26 ms Query memory: 0.014 MB Memory before query: 3.513 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.20 ms After last query: 0.63 ms Query memory: 0.014 MB Memory before query: 3.601 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.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/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.44 ms After last query: 13.45 ms Query memory: 0.013 MB Memory before query: 5.065 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.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/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.08 ms After last query: 12.56 ms Query memory: 0.029 MB Memory before query: 6.189 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.1 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.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.43 ms After last query: 2.48 ms Query memory: 0.018 MB Memory before query: 6.499 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.1 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/cms/application/site.php:486
JROOT/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.30 ms After last query: 6.75 ms Query memory: 0.024 MB Memory before query: 7.107 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: 0.92 ms After last query: 0.28 ms Query memory: 0.018 MB Memory before query: 7.115 MB
UPDATE `mua3d_extensions`
SET `params` = '{\"mediaversion\":\"b7ef5d3a3aa77e3a3fd7cca6f7e19ea2\"}'
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 | 0.7 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.26 ms After last query: 4.68 ms Query memory: 0.034 MB Memory before query: 7.631 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.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_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/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.29 ms After last query: 3.31 ms Query memory: 0.014 MB Memory before query: 7.869 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.1 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| 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: 2.05 ms After last query: 13.42 ms Query memory: 0.028 MB Memory before query: 9.154 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/components/com_djcatalog2/controller.php:59
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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: 6.23 ms Query memory: 0.015 MB Memory before query: 9.850 MB Rows returned: 0
select alias
from mua3d_djc2_items_extra_fields
where type='checkbox' or type='radio' or type='select'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_djc2_items_extra_fields | NULL | ALL | idx_type | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 37.50 | Using where |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.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_djcatalog2/controller.php:90
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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.85 ms After last query: 7.14 ms Query memory: 0.028 MB Memory before query: 10.711 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)
WHERE c.published=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 | ref | idx_published | idx_published | 4 | const | 22 | 100.00 | Using index condition; 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/views/items/view.html.php:93
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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.72 ms After last query: 1.79 ms Query memory: 0.027 MB Memory before query: 10.964 MB Rows returned: 8
SELECT f.*, group_concat(fo.id
order by fo.ordering asc separator '|') as options
FROM mua3d_djc2_items_extra_fields as f
LEFT JOIN mua3d_djc2_items_extra_fields_options as fo
ON fo.field_id=f.id
WHERE f.published = 1
GROUP BY f.id
ORDER BY f.group_id asc, f.ordering asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | f | NULL | ALL | PRIMARY,idx_published,idx_filterable,idx_searchable,idx_separate_column,idx_type,idx_group_id | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 100.00 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fo | NULL | ALL | idx_field_id | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| 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 |
| preparing | 0.0 ms |
| Creating tmp table | 0.1 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.2 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| removing tmp table | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_djcatalog2/models/items.php:599
JROOT/components/com_djcatalog2/models/items.php:227
JROOT/components/com_djcatalog2/models/items.php:195
JROOT/libraries/legacy/model/list.php:115
JROOT/components/com_djcatalog2/models/items.php:175
JROOT/components/com_djcatalog2/views/items/view.html.php:107
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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.13 ms After last query: 0.41 ms Query memory: 0.022 MB Memory before query: 11.027 MB Rows returned: 1
SELECT COUNT(distinct (i.id))
FROM mua3d_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM mua3d_djc2_items_categories AS ic
INNER JOIN mua3d_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND ic.category_id =4) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN mua3d_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN mua3d_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN mua3d_users AS ua
ON ua.id = i.created_by
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-11-26 00:39:42')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-11-26 00:39:42')
AND i.published = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_published | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | ic | NULL | ref | PRIMARY,item_category | PRIMARY | 4 | const | 44 | 100.00 | Using index |
| 1 | SIMPLE | i | NULL | eq_ref | PRIMARY,idx_published | PRIMARY | 4 | fortest_choppers.ic.item_id | 1 | 16.00 | Using where |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.cat_id | 1 | 100.00 | Using index |
| 1 | SIMPLE | p | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.producer_id | 1 | 100.00 | Using index |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.created_by | 1 | 100.00 | 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 |
| 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.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.4 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/components/com_djcatalog2/models/items.php:211
JROOT/libraries/legacy/model/list.php:276
JROOT/libraries/legacy/model/list.php:310
JROOT/components/com_djcatalog2/models/items.php:177
JROOT/components/com_djcatalog2/views/items/view.html.php:107
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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: 2.76 ms After last query: 0.11 ms Query memory: 0.031 MB Memory before query: 11.038 MB Rows returned: 12
SELECT distinct i.*,
CASE WHEN (i.special_price > 0.0
AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email
FROM mua3d_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM mua3d_djc2_items_categories AS ic
INNER JOIN mua3d_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND ic.category_id =4) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN mua3d_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN mua3d_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN mua3d_users AS ua
ON ua.id = i.created_by
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-11-26 00:39:42')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-11-26 00:39:42')
AND i.published = 1
ORDER BY i.featured DESC, final_price desc , i.ordering, c.ordering
LIMIT 0, 12
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | const | PRIMARY,idx_published | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Using filesort |
| 1 | SIMPLE | ic | NULL | ref | PRIMARY,item_category | PRIMARY | 4 | const | 44 | 100.00 | Using index |
| 1 | SIMPLE | i | NULL | eq_ref | PRIMARY,idx_published | PRIMARY | 4 | fortest_choppers.ic.item_id | 1 | 16.00 | Using where |
| 1 | SIMPLE | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.cat_id | 1 | 100.00 | NULL |
| 1 | SIMPLE | p | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.producer_id | 1 | 100.00 | NULL |
| 1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.created_by | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| 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 |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 2.0 ms |
| Creating sort index | 0.2 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/components/com_djcatalog2/models/items.php:159
JROOT/components/com_djcatalog2/models/items.php:177
JROOT/components/com_djcatalog2/views/items/view.html.php:107
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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.38 ms After last query: 0.55 ms Query memory: 0.021 MB Memory before query: 11.169 MB Rows returned: 0
SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value
FROM mua3d_djc2_items_extra_fields_values_int as fieldvalues
INNER JOIN mua3d_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN mua3d_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
LEFT JOIN mua3d_djc2_items_extra_fields_options as fieldoptions
ON fieldoptions.id = fieldvalues.value
AND fieldoptions.field_id = fields.id
WHERE fieldvalues.item_id IN (231,232,233,48,124,139,141,146,148,152,168,171)
AND (fields.visibility = 2 OR fields.visibility = 3)
AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fieldvalues.field_id asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | fieldvalues | NULL | ALL | idx_item_field | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
| 1 | SIMPLE | fields | NULL | eq_ref | PRIMARY,idx_published | PRIMARY | 4 | fortest_choppers.fieldvalues.field_id | 1 | 23.44 | Using where |
| 1 | SIMPLE | fieldoptions | NULL | eq_ref | PRIMARY,idx_field_id | PRIMARY | 4 | fortest_choppers.fieldvalues.value | 1 | 100.00 | Using where |
| 1 | SIMPLE | items | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.fieldvalues.item_id | 1 | 100.00 | 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.1 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.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_djcatalog2/models/items.php:644
JROOT/components/com_djcatalog2/models/items.php:189
JROOT/components/com_djcatalog2/views/items/view.html.php:107
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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.67 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 11.189 MB Rows returned: 12
SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM mua3d_djc2_items_extra_fields_values_text as fieldvalues
INNER JOIN mua3d_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN mua3d_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
WHERE fieldvalues.item_id IN (231,232,233,48,124,139,141,146,148,152,168,171)
AND (fields.visibility = 2 OR fields.visibility = 3)
AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fieldvalues.field_id asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | fields | NULL | ALL | PRIMARY,idx_published | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 23.44 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | items | NULL | range | PRIMARY | PRIMARY | 4 | NULL | 12 | 100.00 | Using where; Using index; Using join buffer (Block Nested Loop) |
| 1 | SIMPLE | fieldvalues | NULL | eq_ref | idx_item_field | idx_item_field | 8 | fortest_choppers.items.id,fortest_choppers.fields.id | 1 | 100.00 | NULL |
| 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.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.2 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_djcatalog2/models/items.php:647
JROOT/components/com_djcatalog2/models/items.php:189
JROOT/components/com_djcatalog2/views/items/view.html.php:107
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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: 0.18 ms Query memory: 0.021 MB Memory before query: 11.229 MB Rows returned: 0
SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM mua3d_djc2_items_extra_fields_values_date as fieldvalues
INNER JOIN mua3d_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN mua3d_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
WHERE fieldvalues.item_id IN (231,232,233,48,124,139,141,146,148,152,168,171)
AND (fields.visibility = 2 OR fields.visibility = 3)
AND fields.published = 1
ORDER BY fieldvalues.field_id asc, fieldvalues.field_id asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | fieldvalues | NULL | ALL | item_field | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
| 1 | SIMPLE | fields | NULL | eq_ref | PRIMARY,idx_published | PRIMARY | 4 | fortest_choppers.fieldvalues.field_id | 1 | 23.44 | Using where |
| 1 | SIMPLE | items | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.fieldvalues.item_id | 1 | 100.00 | Using index |
| 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.1 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_djcatalog2/models/items.php:650
JROOT/components/com_djcatalog2/models/items.php:189
JROOT/components/com_djcatalog2/views/items/view.html.php:107
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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.04 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 11.254 MB Rows returned: 12
SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM mua3d_djc2_items as i
INNER JOIN mua3d_djc2_images as img
on img.id=(select id
from mua3d_djc2_images
where type='item'
and item_id=i.id
order by ordering asc
limit 1)
WHERE i.id IN (231,232,233,48,124,139,141,146,148,152,168,171)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | i | NULL | range | PRIMARY | PRIMARY | 4 | NULL | 12 | 100.00 | Using where; Using index |
| 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.i.id,const | 3 | 100.00 | Using where; Using index; Using filesort |
| 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 |
| preparing | 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 |
| 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/components/com_djcatalog2/models/items.php:680
JROOT/components/com_djcatalog2/models/items.php:189
JROOT/components/com_djcatalog2/views/items/view.html.php:107
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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.52 ms After last query: 3.31 ms Query memory: 0.018 MB Memory before query: 11.554 MB Rows returned: 4
SELECT DISTINCT p.id, p.name as text
FROM mua3d_djc2_producers as p
INNER JOIN mua3d_djc2_items AS i
ON p.id = i.producer_id
INNER JOIN mua3d_djc2_items_categories AS c
ON c.item_id = i.id
WHERE c.category_id IN (4)
AND p.published=1
GROUP BY p.id, p.name
ORDER BY p.name ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | NULL | ref | PRIMARY,item_category | PRIMARY | 4 | const | 44 | 100.00 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | i | NULL | eq_ref | PRIMARY,idx_producer_id | PRIMARY | 4 | fortest_choppers.c.item_id | 1 | 100.00 | NULL |
| 1 | SIMPLE | p | NULL | eq_ref | PRIMARY,idx_published | PRIMARY | 4 | fortest_choppers.i.producer_id | 1 | 100.00 | Using where |
| 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.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.2 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/components/com_djcatalog2/models/items.php:722
JROOT/components/com_djcatalog2/views/items/view.html.php:146
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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.55 ms After last query: 2.25 ms Query memory: 0.021 MB Memory before query: 11.632 MB Rows returned: 1
SELECT f.*, group_concat(fo.id
order by fo.ordering asc separator '|') as options
FROM mua3d_djc2_items_extra_fields as f
LEFT JOIN mua3d_djc2_items_extra_fields_options as fo
ON fo.field_id=f.id
WHERE (f.visibility = 2 or f.visibility = 3)
and f.published = 1
GROUP BY f.id
ORDER BY f.group_id asc, f.ordering asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | f | NULL | ALL | PRIMARY,idx_published,idx_filterable,idx_searchable,idx_separate_column,idx_type,idx_group_id | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 23.44 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fo | NULL | ALL | idx_field_id | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 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 |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| removing tmp table | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_djcatalog2/models/items.php:599
JROOT/components/com_djcatalog2/views/items/view.html.php:170
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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.47 ms After last query: 0.58 ms Query memory: 0.024 MB Memory before query: 11.660 MB Rows returned: 8
SELECT f.*, group_concat(fo.id
order by fo.ordering asc separator '|') as options
FROM mua3d_djc2_items_extra_fields as f
LEFT JOIN mua3d_djc2_items_extra_fields_options as fo
ON fo.field_id=f.id
WHERE f.published = 1
GROUP BY f.id
ORDER BY f.group_id asc, f.ordering asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | f | NULL | ALL | PRIMARY,idx_published,idx_filterable,idx_searchable,idx_separate_column,idx_type,idx_group_id | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 100.00 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fo | NULL | ALL | idx_field_id | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| 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 |
| Creating tmp table | 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.1 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| removing tmp table | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_djcatalog2/models/items.php:599
JROOT/components/com_djcatalog2/models/items.php:227
JROOT/components/com_djcatalog2/models/items.php:923
JROOT/components/com_djcatalog2/views/items/view.html.php:171
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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.28 ms After last query: 0.27 ms Query memory: 0.021 MB Memory before query: 11.710 MB Rows returned: 1
SELECT f.*
FROM mua3d_djc2_items_extra_fields as f
INNER JOIN mua3d_djc2_items as i
on i.group_id = f.group_id
INNER JOIN (
SELECT distinct i.id
FROM mua3d_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM mua3d_djc2_items_categories AS ic
INNER JOIN mua3d_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND ic.category_id =4) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN mua3d_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN mua3d_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN mua3d_users AS ua
ON ua.id = i.created_by
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-11-26 00:39:42')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-11-26 00:39:42')
AND i.published = 1
ORDER BY i.featured DESC, i.id asc , i.ordering, c.ordering ) as iq
on iq.id = i.id
WHERE (f.visibility = 2 or f.visibility = 3)
and f.published = 1
and f.separate_column = 1
GROUP BY f.name, f.alias, f.id, f.group_id
ORDER BY f.group_id asc, f.ordering asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | f | NULL | ref | idx_published,idx_separate_column,idx_group_id | idx_separate_column | 4 | const | 1 | 23.44 | Using where; Using temporary; Using filesort |
| 1 | PRIMARY | <derived2> | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | 100.00 | Using join buffer (Block Nested Loop) |
| 1 | PRIMARY | i | NULL | eq_ref | PRIMARY,idx_group_id | PRIMARY | 4 | iq.id | 1 | 20.00 | Using where |
| 2 | DERIVED | c | NULL | const | PRIMARY,idx_published | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Using filesort |
| 2 | DERIVED | ic | NULL | ref | PRIMARY,item_category | PRIMARY | 4 | const | 44 | 100.00 | Using index |
| 2 | DERIVED | i | NULL | eq_ref | PRIMARY,idx_name,idx_cat_id,idx_group_id,idx_producer_id,idx_published,idx_featured,idx_created_by | PRIMARY | 4 | fortest_choppers.ic.item_id | 1 | 16.00 | Using where |
| 2 | DERIVED | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.cat_id | 1 | 100.00 | Distinct |
| 2 | DERIVED | p | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.producer_id | 1 | 100.00 | Using index; Distinct |
| 2 | DERIVED | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.created_by | 1 | 100.00 | Using index; Distinct |
| 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 |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.4 ms |
| Creating sort index | 0.2 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 |
| removing tmp table | 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/components/com_djcatalog2/models/items.php:935
JROOT/components/com_djcatalog2/views/items/view.html.php:171
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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: 0.52 ms Query memory: 0.024 MB Memory before query: 11.701 MB Rows returned: 8
SELECT f.*, group_concat(fo.id
order by fo.ordering asc separator '|') as options
FROM mua3d_djc2_items_extra_fields as f
LEFT JOIN mua3d_djc2_items_extra_fields_options as fo
ON fo.field_id=f.id
WHERE f.published = 1
GROUP BY f.id
ORDER BY f.group_id asc, f.ordering asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | f | NULL | ALL | PRIMARY,idx_published,idx_filterable,idx_searchable,idx_separate_column,idx_type,idx_group_id | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 100.00 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fo | NULL | ALL | idx_field_id | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
| 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 |
| Creating tmp table | 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.1 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| removing tmp table | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| removing tmp table | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_djcatalog2/models/items.php:599
JROOT/components/com_djcatalog2/models/items.php:227
JROOT/components/com_djcatalog2/models/items.php:955
JROOT/components/com_djcatalog2/views/items/view.html.php:172
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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.18 ms After last query: 0.25 ms Query memory: 0.021 MB Memory before query: 11.751 MB Rows returned: 1
SELECT f.*
FROM mua3d_djc2_items_extra_fields as f
INNER JOIN mua3d_djc2_items as i
on i.group_id = f.group_id
INNER JOIN (
SELECT distinct i.id
FROM mua3d_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM mua3d_djc2_items_categories AS ic
INNER JOIN mua3d_djc2_categories AS c
ON c.id=ic.category_id
WHERE c.published = 1
AND ic.category_id =4) as category_filter
ON i.id = category_filter.item_id
LEFT JOIN mua3d_djc2_categories AS c
ON c.id = i.cat_id
LEFT JOIN mua3d_djc2_producers AS p
ON p.id = i.producer_id
LEFT JOIN mua3d_users AS ua
ON ua.id = i.created_by
WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-11-26 00:39:42')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-11-26 00:39:42')
AND i.published = 1
ORDER BY i.featured DESC, i.id asc , i.ordering, c.ordering ) as iq
on iq.id = i.id
WHERE (f.visibility = 2 or f.visibility = 3)
and f.published = 1
and f.sortable = 1
and (f.type = 'text' || f.type = 'radio' || f.type = 'select' || f.type = 'calendar')
GROUP BY f.name, f.alias, f.id, f.group_id
ORDER BY f.group_id asc, f.ordering asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | f | NULL | ALL | idx_published,idx_type,idx_group_id | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 12.50 | Using where; Using temporary; Using filesort |
| 1 | PRIMARY | <derived2> | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | 100.00 | Using join buffer (Block Nested Loop) |
| 1 | PRIMARY | i | NULL | eq_ref | PRIMARY,idx_group_id | PRIMARY | 4 | iq.id | 1 | 20.00 | Using where |
| 2 | DERIVED | c | NULL | const | PRIMARY,idx_published | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Using filesort |
| 2 | DERIVED | ic | NULL | ref | PRIMARY,item_category | PRIMARY | 4 | const | 44 | 100.00 | Using index |
| 2 | DERIVED | i | NULL | eq_ref | PRIMARY,idx_name,idx_cat_id,idx_group_id,idx_producer_id,idx_published,idx_featured,idx_created_by | PRIMARY | 4 | fortest_choppers.ic.item_id | 1 | 16.00 | Using where |
| 2 | DERIVED | c | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.cat_id | 1 | 100.00 | Distinct |
| 2 | DERIVED | p | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.producer_id | 1 | 100.00 | Using index; Distinct |
| 2 | DERIVED | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.created_by | 1 | 100.00 | Using index; Distinct |
| 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 |
| 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 |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.4 ms |
| Creating sort index | 0.2 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 |
| removing tmp table | 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/components/com_djcatalog2/models/items.php:967
JROOT/components/com_djcatalog2/views/items/view.html.php:172
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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: 2.58 ms Query memory: 0.022 MB Memory before query: 11.795 MB Rows returned: 1
SELECT *
FROM mua3d_djc2_images
WHERE item_id=4
AND type='category'
AND exclude=0
ORDER BY ordering ASC, name ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_djc2_images | NULL | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_type_item | 198 | const,const | 1 | 10.00 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.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/administrator/components/com_djcatalog2/helpers/image.php:91
JROOT/components/com_djcatalog2/views/items/view.html.php:301
JROOT/components/com_djcatalog2/views/items/view.html.php:173
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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.69 ms After last query: 17.87 ms Query memory: 0.030 MB Memory before query: 12.828 MB Rows returned: 203
select id, producer_id
from mua3d_djc2_items
where published=1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_djc2_items | NULL | ALL | idx_published | NO INDEX KEY COULD BE USED | NULL | NULL | 188 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.3 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_djcatalog2/helpers/route.php:65
JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php:72
JROOT/libraries/legacy/view/legacy.php:663
JROOT/components/com_djcatalog2/views/items/tmpl/default.php:123
JROOT/libraries/legacy/view/legacy.php:663
JROOT/libraries/legacy/view/legacy.php:211
JROOT/components/com_djcatalog2/views/items/view.html.php:175
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_djcatalog2/controller.php:100
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_djcatalog2/djcatalog2.php:58
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.68 ms After last query: 29.27 ms Query memory: 0.023 MB Memory before query: 13.173 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 00:39:42')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-26 00:39:42')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 640 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.2 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.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.35 ms After last query: 11.75 ms Query memory: 0.026 MB Memory before query: 14.228 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 00:39:42')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-26 00:39:42')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 640 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.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.8 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/cms/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.68 ms After last query: 5.44 ms Query memory: 0.061 MB Memory before query: 14.606 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.67 ms After last query: 1.99 ms Query memory: 0.063 MB Memory before query: 14.691 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 00:39:42')
AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2020-11-26 00:39:42')
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.2 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.32 ms After last query: 0.12 ms Query memory: 0.038 MB Memory before query: 14.714 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.22 ms After last query: 0.11 ms Query memory: 0.033 MB Memory before query: 14.741 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.20 ms After last query: 0.11 ms Query memory: 0.032 MB Memory before query: 14.768 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.23 ms After last query: 0.16 ms Query memory: 0.030 MB Memory before query: 14.796 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 00:39:42')
AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2020-11-26 00:39:42')
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.17 ms Query memory: 0.031 MB Memory before query: 14.823 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 00:39:42')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-26 00:39:42'))
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: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.23 ms After last query: 0.16 ms Query memory: 0.031 MB Memory before query: 14.851 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 00:39:42')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-26 00:39:42'))
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.26 ms After last query: 0.22 ms Query memory: 0.033 MB Memory before query: 14.894 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.69 ms After last query: 28.51 ms Query memory: 0.032 MB Memory before query: 15.526 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.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.2 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_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: 0.23 ms After last query: 6.42 ms Query memory: 0.032 MB Memory before query: 15.627 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/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: 1.64 ms After last query: 15.47 ms Query memory: 0.003 MB Memory before query: 15.866 MB
UPDATE `mua3d_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1606351182;s:18:\"session.timer.last\";i:1606351182;s:17:\"session.timer.now\";i:1606351182;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\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}}'
, `time` = '1606351182'
WHERE `session_id` = 'e58f99f9a0ceb2e19448cef31fe7a6e8'
| 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.1 ms |
| end | 0.0 ms |
| query end | 1.2 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/session/storage/database.php:85
7 × SELECT extension_id AS id, element AS "option", params, enabled
FROM mua3d_extensions
4 × SELECT f.*, group_concat(fo.id
order by fo.ordering asc separator '|') as options
FROM mua3d_djc2_items_extra_fields as f
LEFT JOIN mua3d_djc2_items_extra_fields_options as fo
ON fo.field_id=f.id
2 × SELECT f.*
FROM mua3d_djc2_items_extra_fields as f
INNER JOIN mua3d_djc2_items as i
on i.group_id = f.group_id
INNER JOIN ( SELECT distinct i.id
FROM mua3d_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM mua3d_djc2_items_categories AS ic
INNER JOIN mua3d_djc2_categories AS c
ON c.id=ic.category_id
2 × 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
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 id, producer_id
from mua3d_djc2_items
1 × SELECT DISTINCT p.id, p.name as text
FROM mua3d_djc2_producers as p
INNER JOIN mua3d_djc2_items AS i
ON p.id = i.producer_id
INNER JOIN mua3d_djc2_items_categories AS c
ON c.item_id = i.id
1 × SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
FROM mua3d_djc2_items as i
INNER JOIN mua3d_djc2_images as img
on img.id=(select id
from mua3d_djc2_images
1 × SELECT *
FROM mua3d_djc2_images
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_maptypes 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 h.*, c.title as category
FROM mua3d_zhgooglemaps_routers 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, 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 fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM mua3d_djc2_items_extra_fields_values_date as fieldvalues
INNER JOIN mua3d_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN mua3d_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
1 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value
FROM mua3d_djc2_items_extra_fields_values_int as fieldvalues
INNER JOIN mua3d_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN mua3d_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
LEFT JOIN mua3d_djc2_items_extra_fields_options as fieldoptions
ON fieldoptions.id = fieldvalues.value
AND fieldoptions.field_id = fields.id
1 × SELECT folder AS type, element AS name, params
FROM mua3d_extensions
1 × SELECT `enabled`
FROM `mua3d_extensions`
1 × SELECT id, rules
FROM `mua3d_viewlevels
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 `session_id`
FROM `mua3d_session`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM mua3d_menu AS m
LEFT JOIN mua3d_extensions AS e
ON m.component_id = e.extension_id
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 distinct i.*,
CASE WHEN (i.special_price > 0.0
AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email
FROM mua3d_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM mua3d_djc2_items_categories AS ic
INNER JOIN mua3d_djc2_categories AS c
ON c.id=ic.category_id
1 × SELECT `data`
FROM `mua3d_session`
1 × SELECT COUNT(distinct (i.id))
FROM mua3d_djc2_items as i
INNER JOIN (SELECT ic.item_id
FROM mua3d_djc2_items_categories AS ic
INNER JOIN mua3d_djc2_categories AS c
ON c.id=ic.category_id
1 × select alias
from mua3d_djc2_items_extra_fields
1 × SELECT *
FROM mua3d_languages
1 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
FROM mua3d_djc2_items_extra_fields_values_text as fieldvalues
INNER JOIN mua3d_djc2_items as items
on items.id=fieldvalues.item_id
INNER JOIN mua3d_djc2_items_extra_fields as fields
ON fields.id = fieldvalues.field_id
