Query Time: 0.47 ms Query memory: 0.015 MB Memory before query: 0.748 MB Rows returned: 0
SELECT `data`
FROM `mua3d_session`
WHERE `session_id` = 'u43q2d0t64bmam5p8a4n1719i1'
| 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.23 ms After last query: 0.91 ms Query memory: 0.012 MB Memory before query: 0.795 MB Rows returned: 0
SELECT `session_id`
FROM `mua3d_session`
WHERE `session_id` = 'u43q2d0t64bmam5p8a4n1719i1'
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.80 ms After last query: 0.23 ms Query memory: 0.009 MB Memory before query: 0.807 MB
INSERT INTO `mua3d_session`
(`session_id`, `client_id`, `time`)
VALUES
('u43q2d0t64bmam5p8a4n1719i1', 0, '1618677266')
EXPLAIN not possible on query: INSERT INTO `mua3d_session`
(`session_id`, `client_id`, `time`) VALUES
('u43q2d0t64bmam5p8a4n1719i1', 0, '1618677266')
| 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.2 ms |
| end | 0.0 ms |
| query end | 0.4 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.65 ms After last query: 1.39 ms Query memory: 0.015 MB Memory before query: 0.887 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM mua3d_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 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/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.63 ms After last query: 0.71 ms Query memory: 0.014 MB Memory before query: 0.904 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.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.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.38 ms After last query: 0.31 ms Query memory: 0.013 MB Memory before query: 0.924 MB Rows returned: 5
SELECT id, rules
FROM `mua3d_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.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/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: 1.03 ms After last query: 0.30 ms Query memory: 0.014 MB Memory before query: 0.943 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.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.6 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.44 ms After last query: 0.82 ms Query memory: 0.014 MB Memory before query: 1.031 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.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/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.40 ms After last query: 4.65 ms Query memory: 0.013 MB Memory before query: 1.319 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.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/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.13 ms After last query: 7.35 ms Query memory: 0.029 MB Memory before query: 1.698 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.52 ms After last query: 3.57 ms Query memory: 0.027 MB Memory before query: 2.050 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM mua3d_extensions
WHERE `type` = 'component'
AND `element` = 'com_djcatalog2'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/components/com_djcatalog2/router.php:153
JROOT/libraries/cms/component/router/legacy.php:106
JROOT/libraries/cms/router/site.php:369
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.69 ms After last query: 1.61 ms Query memory: 0.018 MB Memory before query: 2.138 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.54 | Using index condition; 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 |
| executing | 0.0 ms |
| Sending data | 0.2 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/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.41 ms After last query: 3.54 ms Query memory: 0.024 MB Memory before query: 2.278 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.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/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.64 ms After last query: 0.37 ms Query memory: 0.018 MB Memory before query: 2.285 MB
UPDATE `mua3d_extensions`
SET `params` = '{\"mediaversion\":\"5c8e9700b1a66435fec3c80978cd806a\"}'
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.3 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.52 ms After last query: 3.47 ms Query memory: 0.014 MB Memory before query: 2.414 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.1 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: 3.03 ms After last query: 7.23 ms Query memory: 0.028 MB Memory before query: 2.691 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 | 22 | 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.1 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.1 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.45 ms After last query: 4.14 ms Query memory: 0.015 MB Memory before query: 2.979 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.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/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: 2.67 ms After last query: 1.90 ms Query memory: 0.028 MB Memory before query: 3.113 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.1 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/item/view.html.php:53
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.09 ms After last query: 1.45 ms Query memory: 0.025 MB Memory before query: 3.336 MB Rows returned: 8
SELECT f.*, group_concat(fo.id 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 = 1 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 | index | PRIMARY,idx_published,idx_filterable,idx_searchable,idx_separate_column,idx_type,idx_group_id | PRIMARY | 4 | NULL | 8 | 23.44 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | fo | NULL | ref | idx_field_id | idx_field_id | 4 | fortest_choppers.f.id | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.1 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.1 ms |
| Sorting for group | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.3 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 |
| removing tmp table | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_djcatalog2/models/item.php:232
JROOT/components/com_djcatalog2/models/item.php:126
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_djcatalog2/views/item/view.html.php:58
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.86 ms After last query: 0.46 ms Query memory: 0.028 MB Memory before query: 3.382 MB Rows returned: 1
SELECT 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
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.id =171
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-04-17 16:34:26')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-04-17 16:34:26')
GROUP BY i.id
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | c | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | p | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | ua | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| 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.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/item.php:152
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_djcatalog2/views/item/view.html.php:58
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.70 ms After last query: 0.33 ms Query memory: 0.022 MB Memory before query: 3.425 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=171
AND (fields.visibility = 1 OR fields.visibility = 3)
AND fields.published = 1
ORDER BY fields.ordering asc, fieldoptions.ordering asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | items | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | fieldvalues | NULL | ref | idx_item_field | idx_item_field | 4 | const | 1 | 100.00 | NULL |
| 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 |
| 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 |
| Creating tmp table | 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 |
| 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/item.php:267
JROOT/components/com_djcatalog2/models/item.php:171
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_djcatalog2/views/item/view.html.php:58
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.63 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 3.446 MB Rows returned: 4
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=171
AND (fields.visibility = 1 OR fields.visibility = 3)
AND fields.published = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | items | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| 1 | SIMPLE | fields | NULL | ALL | PRIMARY,idx_published | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 23.44 | Using where |
| 1 | SIMPLE | fieldvalues | NULL | eq_ref | idx_item_field | idx_item_field | 8 | const,fortest_choppers.fields.id | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| 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/components/com_djcatalog2/models/item.php:269
JROOT/components/com_djcatalog2/models/item.php:171
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_djcatalog2/views/item/view.html.php:58
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.54 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 3.473 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=171
AND (fields.visibility = 1 OR fields.visibility = 3)
AND fields.published = 1
ORDER BY fields.ordering asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | items | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | fieldvalues | NULL | ref | item_field | item_field | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | fields | NULL | eq_ref | PRIMARY,idx_published | PRIMARY | 4 | fortest_choppers.fieldvalues.field_id | 1 | 23.44 | Using where |
| Status | Duration |
|---|
| starting | 0.1 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 |
| Creating tmp table | 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 |
| 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/item.php:271
JROOT/components/com_djcatalog2/models/item.php:171
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_djcatalog2/views/item/view.html.php:58
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.61 ms After last query: 1.98 ms Query memory: 0.023 MB Memory before query: 3.512 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=171
AND (fields.visibility = 1 OR fields.visibility = 3)
AND fields.published = 1
ORDER BY fields.ordering asc, fieldoptions.ordering asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | items | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | fieldvalues | NULL | ref | idx_item_field | idx_item_field | 4 | const | 1 | 100.00 | NULL |
| 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 |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 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 |
| 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/item.php:267
JROOT/components/com_djcatalog2/models/item.php:171
JROOT/components/com_djcatalog2/models/item.php:72
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_djcatalog2/views/item/view.html.php:59
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.56 ms After last query: 0.15 ms Query memory: 0.024 MB Memory before query: 3.534 MB Rows returned: 4
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=171
AND (fields.visibility = 1 OR fields.visibility = 3)
AND fields.published = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | items | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| 1 | SIMPLE | fields | NULL | ALL | PRIMARY,idx_published | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 23.44 | Using where |
| 1 | SIMPLE | fieldvalues | NULL | eq_ref | idx_item_field | idx_item_field | 8 | const,fortest_choppers.fields.id | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.1 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/components/com_djcatalog2/models/item.php:269
JROOT/components/com_djcatalog2/models/item.php:171
JROOT/components/com_djcatalog2/models/item.php:72
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_djcatalog2/views/item/view.html.php:59
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.45 ms After last query: 0.23 ms Query memory: 0.023 MB Memory before query: 3.563 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=171
AND (fields.visibility = 1 OR fields.visibility = 3)
AND fields.published = 1
ORDER BY fields.ordering asc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | items | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | fieldvalues | NULL | ref | item_field | item_field | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | fields | NULL | eq_ref | PRIMARY,idx_published | PRIMARY | 4 | fortest_choppers.fieldvalues.field_id | 1 | 23.44 | Using where |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 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 |
| 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/item.php:271
JROOT/components/com_djcatalog2/models/item.php:171
JROOT/components/com_djcatalog2/models/item.php:72
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_djcatalog2/views/item/view.html.php:59
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.65 ms After last query: 0.36 ms Query memory: 0.023 MB Memory before query: 3.563 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 | 206 | 98.54 | 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.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/item/view.html.php:91
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.17 ms After last query: 4.24 ms Query memory: 0.026 MB Memory before query: 3.634 MB Rows returned: 0
SELECT 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 ccategory_id, c.alias as category_alias, p.id AS pproducer_id, p.alias as producer_alias, c.name AS category, p.name AS producer, p.published as publish_producer
FROM mua3d_djc2_items AS i
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
WHERE i.published = 1
AND i.id IN (SELECT related_item
FROM mua3d_djc2_items_related
WHERE item_id=171)
ORDER BY i.ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | mua3d_djc2_items_related | NULL | ref | PRIMARY,item_related | item_related | 4 | const | 1 | 100.00 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | i | NULL | eq_ref | PRIMARY,idx_published | PRIMARY | 4 | fortest_choppers.mua3d_djc2_items_related.related_item | 1 | 98.54 | 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 |
| 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.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.1 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/item.php:188
JROOT/components/com_djcatalog2/views/item/view.html.php:129
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.51 ms After last query: 0.24 ms Query memory: 0.018 MB Memory before query: 3.656 MB Rows returned: 1
SELECT subq.position
FROM (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, @num := @num + 1 AS position,
CASE WHEN (i.special_price > 0.0
AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price
FROM (SELECT @num := 0) AS n, mua3d_djc2_items AS i
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
WHERE i.published = 1
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-04-17 16:34:26')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-04-17 16:34:26')
AND c.published = 1
AND i.cat_id=4
ORDER BY i.featured DESC, final_price desc , i.ordering, c.ordering ) as subq
WHERE subq.id = 171
ORDER BY subq.position DESC
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | <derived2> | NULL | ref | <auto_key0> | <auto_key0> | 4 | const | 1 | 100.00 | Using where; Using filesort |
| 2 | DERIVED | <derived3> | NULL | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using temporary; Using filesort |
| 2 | DERIVED | c | NULL | const | PRIMARY,idx_published | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 2 | DERIVED | i | NULL | ref | idx_cat_id,idx_published | idx_cat_id | 4 | const | 41 | 15.76 | Using index condition; Using where |
| 2 | DERIVED | p | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.producer_id | 1 | 100.00 | Using index |
| 3 | DERIVED | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | No tables used |
| 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 |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| executing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 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.6 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 |
| closing tables | 0.0 ms |
| removing tmp table | 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/item.php:370
JROOT/components/com_djcatalog2/views/item/view.html.php:131
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.32 ms After last query: 0.13 ms Query memory: 0.019 MB Memory before query: 3.675 MB Rows returned: 1
SELECT subq.*
FROM (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, @num := @num + 1 AS position,
CASE WHEN (i.special_price > 0.0
AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price
FROM (SELECT @num := 0) AS n, mua3d_djc2_items AS i
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
WHERE i.published = 1
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-04-17 16:34:26')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-04-17 16:34:26')
AND c.published = 1
AND i.cat_id=4
ORDER BY i.featured DESC, final_price desc , i.ordering, c.ordering ) as subq
WHERE subq.position < 9
ORDER BY subq.position DESC
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | <derived2> | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | 33.33 | Using where; Using filesort |
| 2 | DERIVED | <derived3> | NULL | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using temporary; Using filesort |
| 2 | DERIVED | c | NULL | const | PRIMARY,idx_published | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 2 | DERIVED | i | NULL | ref | idx_cat_id,idx_published | idx_cat_id | 4 | const | 41 | 15.76 | Using index condition; Using where |
| 2 | DERIVED | p | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.producer_id | 1 | 100.00 | Using index |
| 3 | DERIVED | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | No tables used |
| 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 |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| executing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 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.5 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 |
| closing tables | 0.0 ms |
| removing tmp table | 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/item.php:379
JROOT/components/com_djcatalog2/views/item/view.html.php:131
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.32 ms After last query: 0.15 ms Query memory: 0.020 MB Memory before query: 3.695 MB Rows returned: 1
SELECT subq.*
FROM (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, @num := @num + 1 AS position,
CASE WHEN (i.special_price > 0.0
AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price
FROM (SELECT @num := 0) AS n, mua3d_djc2_items AS i
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
WHERE i.published = 1
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-04-17 16:34:26')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-04-17 16:34:26')
AND c.published = 1
AND i.cat_id=4
ORDER BY i.featured DESC, final_price desc , i.ordering, c.ordering ) as subq
WHERE subq.position > 9
ORDER BY subq.position ASC
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | <derived2> | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | 33.33 | Using where; Using filesort |
| 2 | DERIVED | <derived3> | NULL | system | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using temporary; Using filesort |
| 2 | DERIVED | c | NULL | const | PRIMARY,idx_published | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 2 | DERIVED | i | NULL | ref | idx_cat_id,idx_published | idx_cat_id | 4 | const | 41 | 15.76 | Using index condition; Using where |
| 2 | DERIVED | p | NULL | eq_ref | PRIMARY | PRIMARY | 4 | fortest_choppers.i.producer_id | 1 | 100.00 | Using index |
| 3 | DERIVED | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | No tables used |
| 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 |
| optimizing | 0.0 ms |
| optimizing | 0.0 ms |
| executing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Creating tmp table | 0.0 ms |
| Sorting result | 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.5 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 |
| closing tables | 0.0 ms |
| removing tmp table | 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/item.php:387
JROOT/components/com_djcatalog2/views/item/view.html.php:131
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.69 ms Query memory: 0.022 MB Memory before query: 3.727 MB Rows returned: 1
SELECT *
FROM mua3d_djc2_images
WHERE item_id=171
AND type='item'
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.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| Creating sort index | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/administrator/components/com_djcatalog2/helpers/image.php:91
JROOT/components/com_djcatalog2/views/item/view.html.php:241
JROOT/components/com_djcatalog2/views/item/view.html.php:145
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.57 ms After last query: 0.31 ms Query memory: 0.017 MB Memory before query: 3.750 MB
UPDATE mua3d_djc2_items
SET hits = hits + 1
WHERE id = 171
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | mua3d_djc2_items | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| updating | 0.1 ms |
| end | 0.0 ms |
| query end | 0.3 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/components/com_djcatalog2/models/item.php:430
JROOT/components/com_djcatalog2/views/item/view.html.php:147
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.37 ms After last query: 0.46 ms Query memory: 0.023 MB Memory before query: 3.792 MB Rows returned: 1
SELECT a.rules
FROM mua3d_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.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:248
JROOT/libraries/joomla/user/user.php:364
JROOT/components/com_djcatalog2/views/item/tmpl/default.php:29
JROOT/libraries/legacy/view/legacy.php:663
JROOT/libraries/legacy/view/legacy.php:211
JROOT/components/com_djcatalog2/views/item/view.html.php:149
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.73 ms After last query: 0.61 ms Query memory: 0.024 MB Memory before query: 3.824 MB Rows returned: 2
SELECT b.rules
FROM mua3d_assets AS a
LEFT JOIN mua3d_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_djcatalog2')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | idx_asset_name | idx_asset_name | 152 | const | 1 | 100.00 | Using temporary; Using filesort |
| 1 | SIMPLE | b | NULL | ALL | idx_lft_rgt | NO INDEX KEY COULD BE USED | NULL | NULL | 208 | 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 |
| 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/libraries/joomla/access/access.php:248
JROOT/libraries/joomla/access/access.php:109
JROOT/libraries/joomla/user/user.php:373
JROOT/components/com_djcatalog2/views/item/tmpl/default.php:29
JROOT/libraries/legacy/view/legacy.php:663
JROOT/libraries/legacy/view/legacy.php:211
JROOT/components/com_djcatalog2/views/item/view.html.php:149
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.75 ms After last query: 8.57 ms Query memory: 0.024 MB Memory before query: 3.983 MB Rows returned: 0
SELECT *
FROM mua3d_djc2_files
WHERE item_id=171
AND type='item'
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_files | NULL | ref | idx_type_item,idx_item_type,idx_item_type_ordering | idx_type_item | 198 | const,const | 1 | 100.00 | Using index condition; Using filesort |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.2 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.2 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/administrator/components/com_djcatalog2/helpers/file.php:81
JROOT/components/com_djcatalog2/views/item/tmpl/default.php:235
JROOT/libraries/legacy/view/legacy.php:663
JROOT/libraries/legacy/view/legacy.php:211
JROOT/components/com_djcatalog2/views/item/view.html.php:149
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.81 ms After last query: 18.10 ms Query memory: 0.023 MB Memory before query: 4.274 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 <= '2021-04-17 16:34:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-17 16:34:26')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 735 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.1 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 | 1.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/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.59 ms After last query: 4.77 ms Query memory: 0.026 MB Memory before query: 4.504 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 <= '2021-04-17 16:34:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-17 16:34:26')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 735 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.9 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/cms/module/helper.php:376
JROOT/libraries/cms/module/helper.php:84
JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:49
JROOT/templates/jm-car-dealer/tpl/blocks/footer-mod.php:21
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/templates/jm-car-dealer/tpl/default.php:60
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/plugins/system/jmframework/includes/libraries/template.php:211
JROOT/templates/jm-car-dealer/index.php:40
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.90 ms After last query: 3.99 ms Query memory: 0.061 MB Memory before query: 4.678 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.3 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: 1.03 ms After last query: 2.35 ms Query memory: 0.063 MB Memory before query: 4.763 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 <= '2021-04-17 16:34:26')
AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2021-04-17 16:34:26')
ORDER BY h.title
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.3 ms |
| init | 0.1 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| executing | 0.1 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_zhgooglemap/helpers/mod_zhgooglemap.php:222
JROOT/modules/mod_zhgooglemap/tmpl/default.php:55
JROOT/modules/mod_zhgooglemap/mod_zhgooglemap.php:16
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/plugins/system/jmframework/includes/libraries/modulehelper.php:67
JROOT/templates/jm-car-dealer/tpl/blocks/footer-mod.php:21
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/templates/jm-car-dealer/tpl/default.php:60
JROOT/plugins/system/jmframework/includes/libraries/template.php:204
JROOT/plugins/system/jmframework/includes/libraries/template.php:211
JROOT/templates/jm-car-dealer/index.php:40
JROOT/libraries/joomla/document/html/html.php:576
JROOT/libraries/joomla/document/html/html.php:634
JROOT/libraries/joomla/document/html/html.php:452
JROOT/libraries/cms/application/cms.php:974
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.54 ms After last query: 0.22 ms Query memory: 0.038 MB Memory before query: 4.786 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.1 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 |
| 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.36 ms After last query: 0.20 ms Query memory: 0.033 MB Memory before query: 4.813 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.37 ms After last query: 0.16 ms Query memory: 0.032 MB Memory before query: 4.840 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.40 ms After last query: 0.28 ms Query memory: 0.030 MB Memory before query: 4.868 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 <= '2021-04-17 16:34:26')
AND (h.publish_down = '0000-00-00 00:00:00' OR h.publish_down >= '2021-04-17 16:34:26')
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 |
| 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.41 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 4.895 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 <= '2021-04-17 16:34:26')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-17 16:34:26'))
ORDER BY h.title
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| 2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.1 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.34 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 4.923 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 <= '2021-04-17 16:34:26')
and (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-17 16:34:26'))
ORDER BY h.title
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| 2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.1 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.0 ms |
| executing | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/modules/mod_zhgooglemap/helpers/mod_zhgooglemap.php: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.39 ms After last query: 0.30 ms Query memory: 0.033 MB Memory before query: 4.966 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.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/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.40 ms After last query: 12.20 ms Query memory: 0.032 MB Memory before query: 5.059 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.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/components/com_content/router.php:37
JROOT/libraries/cms/router/site.php:463
JROOT/libraries/cms/router/site.php:426
JROOT/libraries/cms/router/router.php:231
JROOT/libraries/cms/router/site.php:106
JROOT/libraries/joomla/application/route.php:64
JROOT/modules/mod_menu/helper.php:125
JROOT/modules/mod_djmegamenu/helper.php:58
JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:41
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:105
JROOT/libraries/joomla/document/html/renderer/modules.php:46
JROOT/libraries/joomla/document/html/html.php:408
JROOT/libraries/joomla/document/html/html.php:696
JROOT/libraries/joomla/document/html/html.php:474
JROOT/libraries/cms/application/cms.php:988
JROOT/libraries/cms/application/site.php:731
JROOT/libraries/cms/application/cms.php:257
JROOT/index.php:40
Query Time: 0.39 ms After last query: 6.74 ms Query memory: 0.033 MB Memory before query: 5.121 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.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| init | 0.0 ms |
| System lock | 0.0 ms |
| optimizing | 0.0 ms |
| statistics | 0.1 ms |
| preparing | 0.0 ms |
| executing | 0.0 ms |
| Sending data | 0.0 ms |
| end | 0.0 ms |
| query end | 0.0 ms |
| closing tables | 0.0 ms |
| freeing items | 0.0 ms |
| cleaning up | 0.0 ms |
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/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: 0.86 ms After last query: 24.05 ms Query memory: 0.003 MB Memory before query: 5.232 MB
UPDATE `mua3d_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1618677266;s:18:\"session.timer.last\";i:1618677266;s:17:\"session.timer.now\";i:1618677266;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"c14e21fb3889193395468616af69e9dc\";}'
, `time` = '1618677267'
WHERE `session_id` = 'u43q2d0t64bmam5p8a4n1719i1'
| 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.0 ms |
| updating | 0.2 ms |
| end | 0.0 ms |
| query end | 0.3 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
2 × 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
2 × 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
2 × SELECT subq.*
FROM (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, @num := @num + 1 AS position,
CASE WHEN (i.special_price > 0.0
AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price
FROM (SELECT @num := 0) AS n, mua3d_djc2_items AS i
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
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
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 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 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 h.*, c.title as category
FROM mua3d_zhgooglemaps_maps as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
1 × SELECT *
FROM mua3d_djc2_files
1 × SELECT b.rules
FROM mua3d_assets AS a
LEFT JOIN mua3d_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT a.rules
FROM mua3d_assets AS a
1 × SELECT 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 h.*, c.title as category
FROM mua3d_zhgooglemaps_paths as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
1 × SELECT `session_id`
FROM `mua3d_session`
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_maptypes as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
1 × SELECT h.*, c.title as category
FROM mua3d_zhgooglemaps_routers as h
LEFT JOIN mua3d_categories as c
ON h.catid=c.id
1 × SELECT *
FROM mua3d_djc2_images
1 × SELECT id, rules
FROM `mua3d_viewlevels
1 × SELECT f.*, group_concat(fo.id 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
1 × SELECT 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
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
1 × select alias
from mua3d_djc2_items_extra_fields
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 *
FROM mua3d_languages
1 × SELECT `enabled`
FROM `mua3d_extensions`
1 × SELECT folder AS type, element AS name, params
FROM mua3d_extensions
1 × SELECT subq.position
FROM (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, @num := @num + 1 AS position,
CASE WHEN (i.special_price > 0.0
AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price
FROM (SELECT @num := 0) AS n, mua3d_djc2_items AS i
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
1 × SELECT 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 ccategory_id, c.alias as category_alias, p.id AS pproducer_id, p.alias as producer_alias, c.name AS category, p.name AS producer, p.published as publish_producer
FROM mua3d_djc2_items AS i
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
1 × select id, producer_id
from mua3d_djc2_items
1 × SELECT `data`
FROM `mua3d_session`
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
