Query Time: 0.84 ms
SELECT `data`
FROM `wev0w_session`
WHERE `session_id` = '6378d23ad4fb06f6bb52a384c620180b'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_session | const | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/session/storage/database.php:44
JROOT/libraries/joomla/session/session.php:665
JROOT/libraries/joomla/session/session.php:603
JROOT/libraries/cms/application/cms.php:739
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:37
Query Time: 0.64 ms After last query: 2.69 ms
SELECT `session_id`
FROM `wev0w_session`
WHERE `session_id` = '6378d23ad4fb06f6bb52a384c620180b'
LIMIT 0, 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_session | const | PRIMARY | PRIMARY | 602 | const | 1 | 100.00 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:176
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:37
Query Time: 0.99 ms After last query: 0.12 ms
INSERT INTO `wev0w_session`
(`session_id`, `client_id`, `time`)
VALUES
('6378d23ad4fb06f6bb52a384c620180b', 0, '1715822300')
EXPLAIN not possible on query: INSERT INTO `wev0w_session`
(`session_id`, `client_id`, `time`) VALUES
('6378d23ad4fb06f6bb52a384c620180b', 0, '1715822300')
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/cms.php:208
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:37
Query Time: 1.39 ms After last query: 5.19 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM wev0w_extensions
WHERE `type` = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_extensions | ref | extension | extension | 62 | const | 41 | 100.00 | Using index condition |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/component/helper.php:434
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:119
JROOT/libraries/cms/application/site.php:568
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.73 ms After last query: 1.93 ms
SELECT b.id
FROM wev0w_usergroups AS a
LEFT JOIN wev0w_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:332
JROOT/libraries/joomla/access/access.php:401
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:573
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.53 ms After last query: 0.23 ms
SELECT id, rules
FROM `wev0w_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:418
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:573
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.26 ms After last query: 1.24 ms
SELECT folder AS type, element AS name, params
FROM wev0w_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 237 | 47.68 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/plugin/helper.php:310
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:573
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.59 ms After last query: 5.36 ms
SELECT `path`
FROM wev0w_rsfirewall_ignored
WHERE `type`='ignore_folder' OR `type`='ignore_file'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_rsfirewall/helpers/config.php:52
JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
JROOT/administrator/components/com_rsfirewall/helpers/config.php:160
JROOT/plugins/system/rsfirewall/rsfirewall.php:25
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:647
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.68 ms After last query: 0.14 ms
SELECT `file`
FROM wev0w_rsfirewall_hashes
WHERE `type`='protect'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_rsfirewall_hashes | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 188 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_rsfirewall/helpers/config.php:59
JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
JROOT/administrator/components/com_rsfirewall/helpers/config.php:160
JROOT/plugins/system/rsfirewall/rsfirewall.php:25
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:647
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.54 ms After last query: 0.09 ms
SELECT *
FROM wev0w_rsfirewall_configuration
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_rsfirewall_configuration | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 48 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_rsfirewall/helpers/config.php:67
JROOT/administrator/components/com_rsfirewall/helpers/config.php:18
JROOT/administrator/components/com_rsfirewall/helpers/config.php:160
JROOT/plugins/system/rsfirewall/rsfirewall.php:25
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:647
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.21 ms After last query: 6.85 ms
SHOW FULL COLUMNS
FROM `wev0w_rsfirewall_logs`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `wev0w_rsfirewall_logs`
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/administrator/components/com_rsfirewall/tables/logs.php:35
JROOT/libraries/joomla/table/table.php:305
JROOT/administrator/components/com_rsfirewall/helpers/log.php:22
JROOT/administrator/components/com_rsfirewall/helpers/log.php:56
JROOT/plugins/system/rsfirewall/rsfirewall.php:46
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:647
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.75 ms After last query: 9.75 ms
SELECT `enabled`
FROM `wev0w_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 100.00 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/backuponupdate/backuponupdate.php:44
JROOT/libraries/cms/plugin/helper.php:230
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:647
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.41 ms After last query: 12.90 ms
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM wev0w_menu AS m
LEFT JOIN wev0w_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 | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 105 | 58.99 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | procsddj_procleanonline.m.component_id | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:424
JROOT/libraries/cms/application/site.php:272
JROOT/libraries/cms/router/site.php:57
JROOT/libraries/cms/router/router.php:196
JROOT/libraries/cms/application/cms.php:520
JROOT/libraries/cms/application/site.php:407
JROOT/libraries/cms/application/cms.php:1088
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.64 ms After last query: 6.01 ms
SELECT a.rules
FROM wev0w_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/user/user.php:384
JROOT/administrator/components/com_virtuemart/helpers/config.php:527
JROOT/administrator/components/com_virtuemart/helpers/config.php:505
JROOT/administrator/components/com_virtuemart/helpers/config.php:785
JROOT/components/com_virtuemart/router.php:706
JROOT/components/com_virtuemart/router.php:300
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.45 ms After last query: 1.08 ms
SELECT b.rules
FROM wev0w_assets AS a
LEFT JOIN wev0w_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_virtuemart')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | const | idx_asset_name | idx_asset_name | 152 | const | 1 | 100.00 | Using temporary; Using filesort |
1 | SIMPLE | b | ALL | idx_lft_rgt | NO INDEX KEY COULD BE USED | NULL | NULL | 112 | 91.07 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/administrator/components/com_virtuemart/helpers/config.php:527
JROOT/administrator/components/com_virtuemart/helpers/config.php:505
JROOT/administrator/components/com_virtuemart/helpers/config.php:785
JROOT/components/com_virtuemart/router.php:706
JROOT/components/com_virtuemart/router.php:300
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.10 ms After last query: 0.58 ms
SHOW TABLES LIKE "wev0w_virtuemart_configs"
EXPLAIN not possible on query: SHOW TABLES LIKE "wev0w_virtuemart_configs"
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/models/config.php:485
JROOT/administrator/components/com_virtuemart/helpers/config.php:788
JROOT/components/com_virtuemart/router.php:706
JROOT/components/com_virtuemart/router.php:300
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.55 ms After last query: 0.12 ms
SELECT `config`
FROM `wev0w_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_configs | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/config.php:840
JROOT/components/com_virtuemart/router.php:706
JROOT/components/com_virtuemart/router.php:300
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.15 ms After last query: 1.39 ms
SELECT *
FROM `wev0w_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language = "en-GB" )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_menu | ALL | idx_client_id_parent_id_alias_language,idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 178 | 46.50 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_virtuemart/router.php:994
JROOT/components/com_virtuemart/router.php:688
JROOT/components/com_virtuemart/router.php:708
JROOT/components/com_virtuemart/router.php:300
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.23 ms After last query: 0.30 ms
SELECT p.`virtuemart_product_id`
FROM `wev0w_virtuemart_products_en_gb` AS `p`
WHERE `slug` = "pedal-bin-green-lid-80-litre-7466-7467"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | p | const | slug | slug | 576 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_virtuemart/router.php:929
JROOT/components/com_virtuemart/router.php:600
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.63 ms After last query: 0.13 ms
SELECT `virtuemart_category_id`
FROM `wev0w_virtuemart_categories_en_gb`
WHERE `slug` = 'pedal-bins'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_categories_en_gb | const | slug | slug | 576 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_virtuemart/router.php:832
JROOT/components/com_virtuemart/router.php:930
JROOT/components/com_virtuemart/router.php:600
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.49 ms After last query: 0.37 ms
SELECT `id`
FROM `wev0w_usergroups`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_usergroups | index | NULL | idx_usergroup_adjacency_lookup | 4 | NULL | 9 | 100.00 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_rsfirewall/helpers/users.php:24
JROOT/administrator/components/com_rsfirewall/helpers/users.php:42
JROOT/plugins/system/rsfirewall/rsfirewall.php:800
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.50 ms After last query: 0.15 ms
SELECT a.rules
FROM wev0w_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:246
JROOT/administrator/components/com_rsfirewall/helpers/users.php:25
JROOT/administrator/components/com_rsfirewall/helpers/users.php:42
JROOT/plugins/system/rsfirewall/rsfirewall.php:800
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.10 ms After last query: 0.20 ms
SELECT DISTINCT(user_id)
FROM wev0w_usergroups as ug1
INNER JOIN wev0w_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN wev0w_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id='6'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ug1 | const | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | const | 1 | 100.00 | Using temporary |
1 | SIMPLE | m | index | NULL | PRIMARY | 8 | NULL | 1145 | 100.00 | Using index |
1 | SIMPLE | ug2 | eq_ref | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | procsddj_procleanonline.m.group_id | 1 | 77.78 | Using where; Distinct |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:381
JROOT/administrator/components/com_rsfirewall/helpers/users.php:45
JROOT/plugins/system/rsfirewall/rsfirewall.php:800
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.00 ms After last query: 0.11 ms
SELECT DISTINCT(user_id)
FROM wev0w_usergroups as ug1
INNER JOIN wev0w_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN wev0w_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id='8'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | ug1 | const | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | const | 1 | 100.00 | Using temporary |
1 | SIMPLE | ug2 | range | PRIMARY,idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | 100.00 | Using where; Using index |
1 | SIMPLE | m | index | NULL | PRIMARY | 8 | NULL | 1145 | 100.00 | Using where; Using index; Using join buffer (flat, BNL join) |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/access/access.php:381
JROOT/administrator/components/com_rsfirewall/helpers/users.php:45
JROOT/plugins/system/rsfirewall/rsfirewall.php:800
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.68 ms After last query: 0.14 ms
SELECT u.*
FROM wev0w_users u
WHERE u.id IN (63,71,644,654)
ORDER BY u.username ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | u | range | PRIMARY | PRIMARY | 4 | NULL | 4 | 100.00 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_rsfirewall/helpers/users.php:57
JROOT/plugins/system/rsfirewall/rsfirewall.php:800
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.56 ms After last query: 0.25 ms
SELECT *
FROM wev0w_rsfirewall_hashes
WHERE (`type`='3.4.1' OR `type`='protect')
AND `flag`!='C'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_rsfirewall_hashes | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 188 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/rsfirewall/rsfirewall.php:856
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.58 ms After last query: 1.33 ms
SELECT *
FROM wev0w_rsfirewall_snapshots
WHERE `type`='protect'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_rsfirewall_snapshots | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:46
JROOT/plugins/system/rsfirewall/rsfirewall.php:879
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.53 ms After last query: 0.26 ms
SELECT *
FROM `wev0w_users`
WHERE `id` = '644'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_users | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/rsfirewall/rsfirewall.php:894
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.51 ms After last query: 0.10 ms
SELECT *
FROM `wev0w_users`
WHERE `id` = '654'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_users | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/rsfirewall/rsfirewall.php:894
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.48 ms After last query: 0.13 ms
SELECT *
FROM `wev0w_users`
WHERE `id` = '63'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_users | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/rsfirewall/rsfirewall.php:894
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.96 ms After last query: 0.17 ms
SELECT `ip`,`reason`
FROM wev0w_rsfirewall_lists
WHERE (`ip`='3.15.143.207' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='1'
AND `published`='1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_rsfirewall_lists | ref | published,type | type | 1 | const | 79 | 99.75 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/rsfirewall/rsfirewall.php:164
JROOT/plugins/system/rsfirewall/rsfirewall.php:143
JROOT/plugins/system/rsfirewall/rsfirewall.php:907
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.17 ms After last query: 0.53 ms
SELECT `ip`,`reason`
FROM wev0w_rsfirewall_lists
WHERE (`ip`='3.15.143.207' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%')
AND `type`='0'
AND `published`='1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_rsfirewall_lists | ALL | published,type | NO INDEX KEY COULD BE USED | NULL | NULL | 789 | 89.63 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/rsfirewall/rsfirewall.php:164
JROOT/plugins/system/rsfirewall/rsfirewall.php:133
JROOT/plugins/system/rsfirewall/rsfirewall.php:911
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.47 ms After last query: 1.50 ms
SELECT *
FROM wev0w_rsfirewall_exceptions
WHERE `published`='1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/plugins/system/rsfirewall/rsfirewall.php:549
JROOT/plugins/system/rsfirewall/rsfirewall.php:946
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.63 ms After last query: 2.12 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM wev0w_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | Using index condition |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/joomla/cache/controller/callback.php:157
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:177
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/sef/sef.php:28
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.10 ms After last query: 0.71 ms
UPDATE `wev0w_extensions`
SET `params` = '{\"mediaversion\":\"5f4ce831d9ab0e6cc482213a4adbdeef\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_extensions | range | element_clientid,element_folder_clientid,extension | extension | 364 | NULL | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:228
JROOT/libraries/cms/version/version.php:187
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/sef/sef.php:28
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.86 ms After last query: 6.48 ms
SELECT *
FROM `wev0w_virtuemart_shoppergroups`
WHERE `default` = "2"
AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")
AND `published`="1"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_shoppergroups | ALL | virtuemart_vendor_id,shared,published | NO INDEX KEY COULD BE USED | NULL | NULL | 18 | 88.89 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:119
JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:153
JROOT/administrator/components/com_virtuemart/models/user.php:165
JROOT/administrator/components/com_virtuemart/models/user.php:116
JROOT/administrator/components/com_virtuemart/models/product.php:1076
JROOT/administrator/components/com_virtuemart/models/product.php:800
JROOT/components/com_virtuemart/router.php:849
JROOT/components/com_virtuemart/router.php:160
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:45
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.57 ms After last query: 0.26 ms
SELECT `wev0w_virtuemart_shoppergroups`.*
FROM `wev0w_virtuemart_shoppergroups`
WHERE `wev0w_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "87"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_shoppergroups | const | PRIMARY | PRIMARY | 2 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1019
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:902
JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:124
JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:153
JROOT/administrator/components/com_virtuemart/models/user.php:165
JROOT/administrator/components/com_virtuemart/models/user.php:116
JROOT/administrator/components/com_virtuemart/models/product.php:1076
JROOT/administrator/components/com_virtuemart/models/product.php:800
JROOT/components/com_virtuemart/router.php:849
JROOT/components/com_virtuemart/router.php:160
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:45
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.90 ms After last query: 2.31 ms
SELECT `wev0w_virtuemart_products`.* ,`wev0w_virtuemart_products_en_gb`.*
FROM `wev0w_virtuemart_products`
INNER JOIN `wev0w_virtuemart_products_en_gb` using (`virtuemart_product_id`)
WHERE `wev0w_virtuemart_products`.`virtuemart_product_id` = "7468"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_products | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
1 | SIMPLE | wev0w_virtuemart_products_en_gb | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1019
JROOT/administrator/components/com_virtuemart/models/product.php:1101
JROOT/administrator/components/com_virtuemart/models/product.php:800
JROOT/components/com_virtuemart/router.php:849
JROOT/components/com_virtuemart/router.php:160
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:45
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.72 ms After last query: 1.16 ms
SELECT `virtuemart_media_id`
FROM `wev0w_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "7468"
ORDER BY `ordering`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_product_medias | ref | virtuemart_product_id | virtuemart_product_id | 4 | const | 1 | 100.00 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1106
JROOT/administrator/components/com_virtuemart/models/product.php:800
JROOT/components/com_virtuemart/router.php:849
JROOT/components/com_virtuemart/router.php:160
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:45
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.51 ms After last query: 0.66 ms
SELECT `virtuemart_shoppergroup_id`
FROM `wev0w_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "7468"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1109
JROOT/administrator/components/com_virtuemart/models/product.php:800
JROOT/components/com_virtuemart/router.php:849
JROOT/components/com_virtuemart/router.php:160
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:45
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.53 ms After last query: 0.18 ms
SELECT *
FROM `wev0w_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "7468"
AND ( `virtuemart_shoppergroup_id` ="87" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")
AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-05-16 01:18:20" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-05-16 01:18:20" ) )
ORDER BY `product_price` DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_product_prices | ref | virtuemart_product_id,product_price,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down | virtuemart_product_id | 4 | const | 8 | 4.38 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/models/product.php:967
JROOT/administrator/components/com_virtuemart/models/product.php:986
JROOT/administrator/components/com_virtuemart/models/product.php:1121
JROOT/administrator/components/com_virtuemart/models/product.php:800
JROOT/components/com_virtuemart/router.php:849
JROOT/components/com_virtuemart/router.php:160
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:45
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.58 ms After last query: 0.79 ms
SELECT `virtuemart_manufacturer_id`
FROM `wev0w_virtuemart_product_manufacturers`
WHERE `virtuemart_product_id` = "7468"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_product_manufacturers | ref | virtuemart_product_id | virtuemart_product_id | 5 | const | 2 | 100.00 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/product.php:1124
JROOT/administrator/components/com_virtuemart/models/product.php:800
JROOT/components/com_virtuemart/router.php:849
JROOT/components/com_virtuemart/router.php:160
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:45
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.66 ms After last query: 0.68 ms
SELECT `wev0w_virtuemart_manufacturers`.* ,`wev0w_virtuemart_manufacturers_en_gb`.*
FROM `wev0w_virtuemart_manufacturers`
INNER JOIN `wev0w_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)
WHERE `wev0w_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_manufacturers | system | PRIMARY,virtuemart_manufacturercategories_id | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | |
1 | SIMPLE | wev0w_virtuemart_manufacturers_en_gb | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1019
JROOT/administrator/components/com_virtuemart/models/product.php:1129
JROOT/administrator/components/com_virtuemart/models/product.php:800
JROOT/components/com_virtuemart/router.php:849
JROOT/components/com_virtuemart/router.php:160
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:45
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.54 ms After last query: 0.27 ms
SELECT *
FROM `wev0w_virtuemart_product_categories`
WHERE `virtuemart_product_id` = 7468
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_product_categories | ref | virtuemart_product_id | virtuemart_product_id | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/models/product.php:1329
JROOT/administrator/components/com_virtuemart/models/product.php:1140
JROOT/administrator/components/com_virtuemart/models/product.php:800
JROOT/components/com_virtuemart/router.php:849
JROOT/components/com_virtuemart/router.php:160
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:45
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.72 ms After last query: 0.67 ms
SELECT `wev0w_virtuemart_categories`.* ,`wev0w_virtuemart_categories_en_gb`.*
FROM `wev0w_virtuemart_categories`
INNER JOIN `wev0w_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
WHERE `wev0w_virtuemart_categories`.`virtuemart_category_id` = "141"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_categories | const | PRIMARY | PRIMARY | 3 | const | 1 | 100.00 | |
1 | SIMPLE | wev0w_virtuemart_categories_en_gb | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1019
JROOT/administrator/components/com_virtuemart/models/product.php:1334
JROOT/administrator/components/com_virtuemart/models/product.php:1140
JROOT/administrator/components/com_virtuemart/models/product.php:800
JROOT/components/com_virtuemart/router.php:849
JROOT/components/com_virtuemart/router.php:160
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:45
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:747
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 2.64 ms After last query: 3.42 ms
SELECT id, home, template, s.params
FROM wev0w_template_styles as s
LEFT JOIN wev0w_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 | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 7 | 100.00 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | procsddj_procleanonline.s.template,const | 1 | 2.95 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/libraries/cms/application/site.php:484
JROOT/libraries/cms/application/site.php:165
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.92 ms After last query: 16.36 ms
SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `wev0w_virtuemart_customs` AS c
LEFT JOIN `wev0w_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
WHERE `virtuemart_product_id` IN (7468)
AND c.`published` = "1"
ORDER BY field.`ordering`,`virtuemart_custom_id` ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/models/customfields.php:146
JROOT/administrator/components/com_virtuemart/models/product.php:2137
JROOT/administrator/components/com_virtuemart/models/product.php:868
JROOT/components/com_virtuemart/views/productdetails/view.html.php:84
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.74 ms After last query: 1.66 ms
SELECT *
FROM `wev0w_virtuemart_currencies` AS c
, `wev0w_virtuemart_vendors` AS v
WHERE v.virtuemart_vendor_id = 1
AND v.vendor_currency = c.virtuemart_currency_id
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | v | system | PRIMARY,vendor_currency | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 2 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/models/vendor.php:256
JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:49
JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:98
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2144
JROOT/administrator/components/com_virtuemart/models/product.php:868
JROOT/components/com_virtuemart/views/productdetails/view.html.php:84
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.56 ms After last query: 1.62 ms
SELECT `wev0w_virtuemart_currencies`.*
FROM `wev0w_virtuemart_currencies`
WHERE `wev0w_virtuemart_currencies`.`virtuemart_currency_id` = "9"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_currencies | const | PRIMARY | PRIMARY | 2 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1019
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:902
JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:114
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2144
JROOT/administrator/components/com_virtuemart/models/product.php:868
JROOT/components/com_virtuemart/views/productdetails/view.html.php:84
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.30 ms After last query: 1.72 ms
SHOW FULL COLUMNS
FROM `wev0w_virtuemart_userfields`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `wev0w_virtuemart_userfields`
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:649
JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:206
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:425
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:387
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:593
JROOT/administrator/components/com_virtuemart/models/userfields.php:51
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:545
JROOT/components/com_virtuemart/helpers/cart.php:244
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:255
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2144
JROOT/administrator/components/com_virtuemart/models/product.php:868
JROOT/components/com_virtuemart/views/productdetails/view.html.php:84
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.99 ms After last query: 1.93 ms
SELECT *
FROM `wev0w_virtuemart_userfields`
WHERE 1 = 1
AND `account`=1
AND published = 1
AND FIND_IN_SET(name, 'address_type') = 0
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_userfields | ALL | published,account | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 75.00 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
JROOT/administrator/components/com_virtuemart/models/userfields.php:573
JROOT/administrator/components/com_virtuemart/models/userfields.php:475
JROOT/components/com_virtuemart/helpers/cart.php:255
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:255
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2144
JROOT/administrator/components/com_virtuemart/models/product.php:868
JROOT/components/com_virtuemart/views/productdetails/view.html.php:84
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.59 ms After last query: 0.62 ms
SELECT fieldtitle, fieldvalue
FROM wev0w_virtuemart_userfield_values
WHERE virtuemart_userfield_id = 23
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_userfield_values | ref | virtuemart_userfield_id | virtuemart_userfield_id | 2 | const | 2 | 100.00 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
JROOT/administrator/components/com_virtuemart/models/userfields.php:981
JROOT/components/com_virtuemart/helpers/cart.php:260
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:255
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2144
JROOT/administrator/components/com_virtuemart/models/product.php:868
JROOT/components/com_virtuemart/views/productdetails/view.html.php:84
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.64 ms After last query: 1.72 ms
SELECT *
FROM `wev0w_virtuemart_countries`
WHERE `published` = 1
ORDER BY country_name ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_countries | ref | published | published | 1 | const | 1 | 100.00 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:838
JROOT/administrator/components/com_virtuemart/models/country.php:113
JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:173
JROOT/administrator/components/com_virtuemart/models/userfields.php:800
JROOT/components/com_virtuemart/helpers/cart.php:260
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:255
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2144
JROOT/administrator/components/com_virtuemart/models/product.php:868
JROOT/components/com_virtuemart/views/productdetails/view.html.php:84
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.52 ms After last query: 2.24 ms
SELECT *
FROM `wev0w_virtuemart_countries`
WHERE virtuemart_country_id = "13"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_countries | const | PRIMARY | PRIMARY | 2 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/models/userfields.php:808
JROOT/components/com_virtuemart/helpers/cart.php:260
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:255
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2144
JROOT/administrator/components/com_virtuemart/models/product.php:868
JROOT/components/com_virtuemart/views/productdetails/view.html.php:84
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.85 ms After last query: 0.25 ms
SELECT *
FROM `wev0w_virtuemart_userfields`
WHERE 1 = 1
AND `shipment`=1
AND published = 1
AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_userfields | ALL | published,shipment | NO INDEX KEY COULD BE USED | NULL | NULL | 30 | 39.00 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
JROOT/administrator/components/com_virtuemart/models/userfields.php:573
JROOT/administrator/components/com_virtuemart/models/userfields.php:481
JROOT/components/com_virtuemart/helpers/cart.php:255
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:255
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2144
JROOT/administrator/components/com_virtuemart/models/product.php:868
JROOT/components/com_virtuemart/views/productdetails/view.html.php:84
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.61 ms After last query: 2.05 ms
SELECT *
FROM `wev0w_virtuemart_countries`
WHERE virtuemart_country_id = "13"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_countries | const | PRIMARY | PRIMARY | 2 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/models/userfields.php:808
JROOT/components/com_virtuemart/helpers/cart.php:260
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:255
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2144
JROOT/administrator/components/com_virtuemart/models/product.php:868
JROOT/components/com_virtuemart/views/productdetails/view.html.php:84
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.72 ms After last query: 1.15 ms
SELECT *
FROM wev0w_virtuemart_calcs
LEFT JOIN wev0w_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-05-16 01:18:20" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-16 01:18:20" )
AND ( virtuemart_shoppergroup_id = 87 OR (virtuemart_shoppergroup_id) IS NULL)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_calcs | system | virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | |
1 | SIMPLE | wev0w_virtuemart_calc_shoppergroups | system | virtuemart_calc_id | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | 0.00 | Const row not found |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:179
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
JROOT/administrator/components/com_virtuemart/models/product.php:2144
JROOT/administrator/components/com_virtuemart/models/product.php:868
JROOT/components/com_virtuemart/views/productdetails/view.html.php:84
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.00 ms After last query: 5.85 ms
SELECT `wev0w_virtuemart_medias`.*
FROM `wev0w_virtuemart_medias`
WHERE `wev0w_virtuemart_medias`.`virtuemart_media_id` = "7834"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_medias | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1019
JROOT/administrator/components/com_virtuemart/models/media.php:99
JROOT/administrator/components/com_virtuemart/models/media.php:400
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1063
JROOT/components/com_virtuemart/views/productdetails/view.html.php:144
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.66 ms After last query: 2.85 ms
SELECT `virtuemart_media_id`
FROM `wev0w_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "141"
ORDER BY `ordering`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_category_medias | ref | virtuemart_category_id | virtuemart_category_id | 3 | const | 1 | 100.00 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
JROOT/administrator/components/com_virtuemart/models/category.php:73
JROOT/components/com_virtuemart/views/productdetails/view.html.php:185
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.51 ms After last query: 0.11 ms
SELECT `category_child_id`
FROM `wev0w_virtuemart_category_categories`
WHERE `category_parent_id` = 141
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_category_categories | ref | category_parent_id | category_parent_id | 4 | const | 1 | 100.00 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/administrator/components/com_virtuemart/models/category.php:626
JROOT/administrator/components/com_virtuemart/models/category.php:84
JROOT/components/com_virtuemart/views/productdetails/view.html.php:185
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.91 ms After last query: 0.08 ms
SELECT count(wev0w_virtuemart_products.virtuemart_product_id) AS total
FROM `wev0w_virtuemart_products`, `wev0w_virtuemart_product_categories`
WHERE `wev0w_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `wev0w_virtuemart_product_categories`.`virtuemart_category_id` = 141
AND `wev0w_virtuemart_products`.`virtuemart_product_id` = `wev0w_virtuemart_product_categories`.`virtuemart_product_id`
AND `wev0w_virtuemart_products`.`published` = "1"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_product_categories | index | virtuemart_product_id | virtuemart_product_id | 7 | NULL | 6730 | 100.00 | Using where; Using index |
1 | SIMPLE | wev0w_virtuemart_products | eq_ref | PRIMARY,virtuemart_vendor_id,published | PRIMARY | 4 | procsddj_procleanonline.wev0w_virtuemart_product_categories.virtuemart_product_id | 1 | 98.55 | Using where |
Status | Duration |
---|
Starting | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 1.3 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/administrator/components/com_virtuemart/models/category.php:368
JROOT/administrator/components/com_virtuemart/models/category.php:91
JROOT/components/com_virtuemart/views/productdetails/view.html.php:185
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.51 ms After last query: 0.11 ms
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM wev0w_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 141
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | xref | ref | category_child_id | category_child_id | 4 | const | 1 | 100.00 | |
Status | Duration |
---|
Starting | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 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 of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/administrator/components/com_virtuemart/models/category.php:699
JROOT/administrator/components/com_virtuemart/models/category.php:655
JROOT/administrator/components/com_virtuemart/models/category.php:94
JROOT/components/com_virtuemart/views/productdetails/view.html.php:185
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.49 ms After last query: 0.11 ms
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM wev0w_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 8
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | xref | ref | category_child_id | category_child_id | 4 | const | 1 | 100.00 | |
Status | Duration |
---|
Starting | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/administrator/components/com_virtuemart/models/category.php:699
JROOT/administrator/components/com_virtuemart/models/category.php:706
JROOT/administrator/components/com_virtuemart/models/category.php:655
JROOT/administrator/components/com_virtuemart/models/category.php:94
JROOT/components/com_virtuemart/views/productdetails/view.html.php:185
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.55 ms After last query: 0.10 ms
SELECT `category_name`,`virtuemart_category_id`
FROM `wev0w_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=8
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_categories_en_gb | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
Status | Duration |
---|
Starting | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/administrator/components/com_virtuemart/models/category.php:670
JROOT/administrator/components/com_virtuemart/models/category.php:94
JROOT/components/com_virtuemart/views/productdetails/view.html.php:185
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.53 ms After last query: 0.10 ms
SELECT `category_name`,`virtuemart_category_id`
FROM `wev0w_virtuemart_categories_en_gb`
WHERE `virtuemart_category_id`=141
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_categories_en_gb | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
Status | Duration |
---|
Starting | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/administrator/components/com_virtuemart/models/category.php:670
JROOT/administrator/components/com_virtuemart/models/category.php:94
JROOT/components/com_virtuemart/views/productdetails/view.html.php:185
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.56 ms After last query: 0.16 ms
SELECT `wev0w_virtuemart_medias`.*
FROM `wev0w_virtuemart_medias`
WHERE `wev0w_virtuemart_medias`.`virtuemart_media_id` = "114"
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_virtuemart_medias | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
Status | Duration |
---|
Starting | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1019
JROOT/administrator/components/com_virtuemart/models/media.php:99
JROOT/administrator/components/com_virtuemart/models/media.php:400
JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1063
JROOT/components/com_virtuemart/views/productdetails/view.html.php:187
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.95 ms After last query: 4.03 ms
SELECT L.*
FROM `wev0w_virtuemart_categories_en_gb` as L
INNER JOIN `wev0w_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `wev0w_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
WHERE cx.`category_parent_id` = 141
AND c.`virtuemart_vendor_id` = 1
AND c.`published` = 1
ORDER BY c.ordering,category_name ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | cx | ref | category_parent_id,category_child_id | category_parent_id | 4 | const | 1 | 100.00 | Using index; Using temporary; Using filesort |
1 | SIMPLE | c | eq_ref | PRIMARY,virtuemart_vendor_id,published | PRIMARY | 3 | procsddj_procleanonline.cx.category_child_id | 1 | 91.68 | Using index condition; Using where |
1 | SIMPLE | L | eq_ref | PRIMARY | PRIMARY | 4 | procsddj_procleanonline.c.virtuemart_category_id | 1 | 100.00 | Using index condition |
Status | Duration |
---|
Starting | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 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.0 ms |
Creating sort index | 0.0 ms |
Removing tmp table | 0.0 ms |
Creating sort index | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/administrator/components/com_virtuemart/models/category.php:211
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/joomla/cache/controller/callback.php:41
JROOT/administrator/components/com_virtuemart/models/category.php:155
JROOT/components/com_virtuemart/views/productdetails/view.html.php:201
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 7.13 ms After last query: 28.86 ms
SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `wev0w_virtuemart_shipmentmethods_en_gb` as l JOIN `wev0w_virtuemart_shipmentmethods` AS v USING (`virtuemart_shipmentmethod_id`)
LEFT JOIN `wev0w_extensions` as j
ON j.`extension_id` = v.`shipment_jplugin_id`
LEFT
OUTER JOIN `wev0w_virtuemart_shipmentmethod_shoppergroups` AS s
ON v.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`
WHERE v.`published` = "1"
AND j.`element` = "weight_countries"
AND (v.`virtuemart_vendor_id` = "1" OR v.`virtuemart_vendor_id` = "0" OR v.`shared` = "1")
AND ( s.`virtuemart_shoppergroup_id`= "87" OR (s.`virtuemart_shoppergroup_id`) IS NULL )
GROUP BY v.`virtuemart_shipmentmethod_id`
ORDER BY v.`ordering`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | system | virtuemart_shipmentmethod_id | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | 0.00 | Const row not found; Using temporary; Using filesort |
1 | SIMPLE | j | ref | PRIMARY,element_clientid,element_folder_clientid | element_clientid | 302 | const | 1 | 100.00 | Using index condition |
1 | SIMPLE | l | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 22 | 100.00 | Using join buffer (flat, BNL join) |
1 | SIMPLE | v | eq_ref | PRIMARY,shipment_jplugin_id | PRIMARY | 3 | procsddj_procleanonline.l.virtuemart_shipmentmethod_id | 1 | 100.00 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.2 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 4.1 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.2 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
init | 0.1 ms |
Optimizing | 0.0 ms |
Statistics | 0.2 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Creating tmp table | 0.3 ms |
Sorting result | 0.1 ms |
Executing | 0.0 ms |
Sending data | 0.9 ms |
Creating sort index | 0.1 ms |
Removing tmp table | 0.2 ms |
Creating sort index | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:500
JROOT/plugins/vmshipment/weight_countries/weight_countries.php:395
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_virtuemart/views/productdetails/view.html.php:306
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.71 ms After last query: 0.42 ms
SELECT *
FROM wev0w_virtuemart_calcs
LEFT JOIN wev0w_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE
`calc_kind`="DBTaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-05-16 01:18:20" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-16 01:18:20" )
AND ( virtuemart_shoppergroup_id = 87 OR (virtuemart_shoppergroup_id) IS NULL)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
Starting | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.1 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1260
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:706
JROOT/components/com_virtuemart/helpers/cart.php:1471
JROOT/components/com_virtuemart/helpers/cart.php:1566
JROOT/plugins/vmshipment/weight_countries/weight_countries.php:412
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_virtuemart/views/productdetails/view.html.php:306
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.67 ms After last query: 0.09 ms
SELECT *
FROM wev0w_virtuemart_calcs
LEFT JOIN wev0w_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE
`calc_kind`="TaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-05-16 01:18:20" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-16 01:18:20" )
AND ( virtuemart_shoppergroup_id = 87 OR (virtuemart_shoppergroup_id) IS NULL)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
Starting | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.1 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1260
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:707
JROOT/components/com_virtuemart/helpers/cart.php:1471
JROOT/components/com_virtuemart/helpers/cart.php:1566
JROOT/plugins/vmshipment/weight_countries/weight_countries.php:412
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_virtuemart/views/productdetails/view.html.php:306
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.61 ms After last query: 0.13 ms
SELECT *
FROM wev0w_virtuemart_calcs
LEFT JOIN wev0w_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
WHERE
`calc_kind`="DATaxBill"
AND `published`="1"
AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-05-16 01:18:20" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-16 01:18:20" )
AND ( virtuemart_shoppergroup_id = 87 OR (virtuemart_shoppergroup_id) IS NULL)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
Starting | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1260
JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:708
JROOT/components/com_virtuemart/helpers/cart.php:1471
JROOT/components/com_virtuemart/helpers/cart.php:1566
JROOT/plugins/vmshipment/weight_countries/weight_countries.php:412
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_virtuemart/views/productdetails/view.html.php:306
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.08 ms After last query: 17.36 ms
SELECT *
FROM wev0w_vm_favorites
WHERE product_id = '7468'
AND user_id='0'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_vm_favorites | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1123 | 100.00 | Using where |
Status | Duration |
---|
Starting | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.4 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/components/com_virtuemart/sublayouts/addtocartbar.php:100
JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:512
JROOT/components/com_virtuemart/sublayouts/addtocart.php:51
JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:512
JROOT/components/com_virtuemart/views/productdetails/tmpl/default.php:269
JROOT/libraries/legacy/view/legacy.php:670
JROOT/components/com_virtuemart/helpers/vmview.php:37
JROOT/components/com_virtuemart/views/productdetails/view.html.php:337
JROOT/components/com_virtuemart/controllers/productdetails.php:51
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_virtuemart/virtuemart.php:125
JROOT/libraries/cms/component/helper.php:391
JROOT/libraries/cms/component/helper.php:371
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 0.76 ms After last query: 23.75 ms
SELECT *
FROM wev0w_rsform_config
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_rsform_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 16 | 100.00 | |
Status | Duration |
---|
Starting | 0.1 ms |
Waiting for query cache lock | 0.0 ms |
starting | 0.0 ms |
Checking query cache for query | 0.0 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 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 of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.1 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/administrator/components/com_rsform/helpers/config.php:50
JROOT/administrator/components/com_rsform/helpers/config.php:17
JROOT/administrator/components/com_rsform/helpers/config.php:97
JROOT/administrator/components/com_rsform/helpers/rsform.php:391
JROOT/plugins/system/rsfpregistration/rsfpregistration.php:25
JROOT/plugins/system/rsfpregistration/rsfpregistration.php:993
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:83
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
Query Time: 1.25 ms After last query: 17.93 ms
UPDATE `wev0w_session`
SET `data` = 'CyZ6J8HE5wtQPoGulsgUonxh1g8qeyWIvUG8QW7oMzWEumYwbNUGlZuuAm8zH01-aakK5QxKpw35zt0ceUK4VYyRKsYJycavEA_V3HvUaPo4S5cOrnz5VwwqD3CT3z_nH_0Cd90RmRC-hB2YgeHBWwK0N7cVd1ym2k-3yN_KFoXotxA0-uCPAfNQSunI2UNxz-kh2VoCinrb3C-tKhqZlFpWx_AGGZZeW7NPTxh68-d-zzOPD7OMKjaatguMk1Q4Eab-Y-EweMlidipeWDs-09X3H4pO9gS6m6icBRYve7w6zihu8Bv128W2zLC6NsEpPEKy78LLYESGDtDrOtkjSBM3_IR9rQRkwcqIMQjUDzwLLAYieB9n15sUhZDWWXqfgFj-7NTzIl6omST-rY4bjKFrZG_NCyUYzdEpv2Iime9suySuBALpFfAB6sSZV37svu9PB3GslOIcA9SAeFKA-9z-WH9PwL2gfs0Tl-qJJkpHcZNOppC-2GgBFXzQkDw8oV8Wp2BoEqfYcPs0GGFxTqJLs9Onqd3-EnHidUrzBDf3h_RLC3K40ROESsn3vrjxeqXgrSVdy3yf5ToSa4gv2zaZKrMMkfXGXNwW7_U8zXr851JRTTZmVUGjkoJSEDmLTxULuoFxVFZOiZ0IXM7bCs_jel5cAFrywmaFbpD1aPstR2oj8UAJCrQ14uA59VFFYFtX7NTN2iKCJYJqVk1QxtjGM97LKruqMNSUPDNGCRBXMeMmYXYkPzlExaev1-UpHW6_jwgG_scrHz8jLz8nDvT58qMIx2AP6fmCLDpsbjJ864Z_yYMxVcBw88qB9mm3lqlKqlkCHGHMynUvW8vshKf5H90UPQ_WYFhAOh6oaQnavJ3FaV87FwfgQuyiWhhTIz8HPwVBzRMbGOxkaM_1oZxp14TnmW2txlT9j0tS6shjCj8QmJi2SWKu-UNb05xgY0M-GCSjVyBhR4dQTgdIrf0PIlpFplwgAAN5A08cSbbHnoFGRtLX7i4agcLrA3LIvdR09vln7Xf-mLAyyhxx5YT3aCI8sJf8JanSpzRfOqrxuolTiM_NoVGqrIi1D9INz0aMFQi8lTLcgGhET11qlTtLyx0SYhDlwgUo1c4a1vr7oscsYIrW22Di938iUE_WmseKwYIz-erkbN1F9eMMs10qcjM7MbPtROe1p6g7ZiMl2mzqLf0_oQpLkModuYk5Eul19ZgNubuYDZDT5gi8PQXW_0iE_8pdVtDROhSHnBif29IBqTZljZFi_1SW3OQ6ZlDKBnKPCEafv17_pyb6Rq7p4Lc3Io-ZKzlaYD4k5bbOHf7SxkyXbBD06PGXi5Hs_MgWLnJkWPci1qyFkFS-JuDm5kTcZtdYQNBazlppt6Bg983_S9rG5_vHiLfqw3YZ43LRBx4785tQlAXUwoyFyqmMgwNFJoULb2h5eKR6xACd_viBFTRBD59eHMMzYD-XrtAk-RUKmzG91PVMXE_itKY9SfwSt1Pai1AqfLWPqSrIhFr0fLp_dRFa2ceWfomOKMtgXkkYAGNH4YxoUylo72Hj2LERGTQWM7zOk6APuh2e38cGaWFB9d_ub-GhcUFVoz-t2QA9Fr3JUfiQYAStY4lsu6kDdWydkvXZJ5tnsCcSXoGh-4O56OesNHcsik3Wd7WKmbshYY3OIlvmLFeRtVEa3UJGF0Nb61ONGi4DgQJlppUJy_eNDQ9ch61tJbWyhqBokyqr6I_zzY5KLiVXj1XzeZp7qA-gSlNWw1iavsXRbncWu62Ixx11nK4sikY2TqVUd2PpWVOO1NU-bdCURvtbKcGFOFUXnsuY7sq1p3YUMCPWjIOB3hMlhoGiF-hQ'
, `time` = '1715822300'
WHERE `session_id` = '6378d23ad4fb06f6bb52a384c620180b'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | wev0w_session | range | PRIMARY | PRIMARY | 602 | NULL | 1 | 100.00 | Using where |
Status | Duration |
---|
Starting | 0.2 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init for update | 0.1 ms |
Updating | 0.1 ms |
End of update loop | 0.0 ms |
Waiting for query cache lock | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.5 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.1 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
JROOT/libraries/joomla/session/storage/database.php:84
4 × SELECT *
FROM wev0w_virtuemart_calcs
LEFT JOIN wev0w_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
3 × SELECT *
FROM `wev0w_users`
3 × SELECT *
FROM `wev0w_virtuemart_countries`
2 × SELECT `ip`,`reason`
FROM wev0w_rsfirewall_lists
2 × SELECT a.rules
FROM wev0w_assets AS a
2 × SELECT `wev0w_virtuemart_medias`.*
FROM `wev0w_virtuemart_medias`
2 × SELECT *
FROM `wev0w_virtuemart_userfields`
2 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM wev0w_virtuemart_category_categories AS `xref`
2 × SELECT DISTINCT(user_id)
FROM wev0w_usergroups as ug1
INNER JOIN wev0w_usergroups AS ug2
ON ug2.lft>=ug1.lft
AND ug1.rgt>=ug2.rgt
INNER JOIN wev0w_user_usergroup_map AS m
ON ug2.id=m.group_id
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM wev0w_extensions
2 × SELECT `category_name`,`virtuemart_category_id`
FROM `wev0w_virtuemart_categories_en_gb`
1 × SELECT *
FROM wev0w_rsform_confi
1 × SELECT id, home, template, s.params
FROM wev0w_template_styles as s
LEFT JOIN wev0w_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `wev0w_virtuemart_categories`.* ,`wev0w_virtuemart_categories_en_gb`.*
FROM `wev0w_virtuemart_categories`
INNER JOIN `wev0w_virtuemart_categories_en_gb` using (`virtuemart_category_id`)
1 × SELECT *
FROM `wev0w_virtuemart_product_prices`
1 × SELECT `virtuemart_manufacturer_id`
FROM `wev0w_virtuemart_product_manufacturers`
1 × SELECT `wev0w_virtuemart_manufacturers`.* ,`wev0w_virtuemart_manufacturers_en_gb`.*
FROM `wev0w_virtuemart_manufacturers`
INNER JOIN `wev0w_virtuemart_manufacturers_en_gb` using (`virtuemart_manufacturer_id`)
1 × SELECT *
FROM `wev0w_virtuemart_product_categories`
1 × SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
FROM `wev0w_virtuemart_customs` AS c
LEFT JOIN `wev0w_virtuemart_product_customfields` AS field
ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`
1 × SELECT fieldtitle, fieldvalue
FROM wev0w_virtuemart_userfield_values
1 × SELECT count(wev0w_virtuemart_products.virtuemart_product_id) AS total
FROM `wev0w_virtuemart_products`, `wev0w_virtuemart_product_categories`
1 × SELECT L.*
FROM `wev0w_virtuemart_categories_en_gb` as L
INNER JOIN `wev0w_virtuemart_categories` as c using (`virtuemart_category_id`)
LEFT JOIN `wev0w_virtuemart_category_categories` as cx
on c.`virtuemart_category_id` = cx.`category_child_id`
1 × SELECT l.*, v.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`, s.virtuemart_shoppergroup_id
FROM `wev0w_virtuemart_shipmentmethods_en_gb` as l JOIN `wev0w_virtuemart_shipmentmethods` AS v USING (`virtuemart_shipmentmethod_id`)
LEFT JOIN `wev0w_extensions` as j
ON j.`extension_id` = v.`shipment_jplugin_id`
LEFT
OUTER JOIN `wev0w_virtuemart_shipmentmethod_shoppergroups` AS s
ON v.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`
1 × SELECT `category_child_id`
FROM `wev0w_virtuemart_category_categories`
1 × SELECT `virtuemart_media_id`
FROM `wev0w_virtuemart_category_medias`
1 × SELECT `wev0w_virtuemart_currencies`.*
FROM `wev0w_virtuemart_currencies`
1 × SELECT *
FROM wev0w_vm_favorites
1 × SELECT `virtuemart_shoppergroup_id`
FROM `wev0w_virtuemart_product_shoppergroups`
1 × SELECT *
FROM `wev0w_virtuemart_currencies` AS c , `wev0w_virtuemart_vendors` AS v
1 × SELECT `wev0w_virtuemart_shoppergroups`.*
FROM `wev0w_virtuemart_shoppergroups`
1 × SELECT *
FROM wev0w_rsfirewall_configuratio
1 × SELECT `enabled`
FROM `wev0w_extensions`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM wev0w_menu AS m
LEFT JOIN wev0w_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT b.rules
FROM wev0w_assets AS a
LEFT JOIN wev0w_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `file`
FROM wev0w_rsfirewall_hashes
1 × SELECT `path`
FROM wev0w_rsfirewall_ignored
1 × SELECT `session_id`
FROM `wev0w_session`
1 × SELECT b.id
FROM wev0w_usergroups AS a
LEFT JOIN wev0w_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `wev0w_viewlevels
1 × SELECT folder AS type, element AS name, params
FROM wev0w_extensions
1 × SELECT `config`
FROM `wev0w_virtuemart_configs`
1 × SELECT *
FROM `wev0w_menu`
1 × SELECT *
FROM wev0w_rsfirewall_exceptions
1 × SELECT *
FROM `wev0w_virtuemart_shoppergroups`
1 × SELECT `data`
FROM `wev0w_session`
1 × SELECT `wev0w_virtuemart_products`.* ,`wev0w_virtuemart_products_en_gb`.*
FROM `wev0w_virtuemart_products`
INNER JOIN `wev0w_virtuemart_products_en_gb` using (`virtuemart_product_id`)
1 × SELECT *
FROM wev0w_rsfirewall_snapshots
1 × SELECT *
FROM wev0w_rsfirewall_hashes
1 × SELECT p.`virtuemart_product_id`
FROM `wev0w_virtuemart_products_en_gb` AS `p`
1 × SELECT `virtuemart_category_id`
FROM `wev0w_virtuemart_categories_en_gb`
1 × SELECT `id`
FROM `wev0w_usergroups
1 × SELECT u.*
FROM wev0w_users u
1 × SELECT `virtuemart_media_id`
FROM `wev0w_virtuemart_product_medias`