Ta strona używa plików Cookies. Dowiedz się więcej o celu ich używania i możliwości zmiany ustawień Cookies w przeglądarce.
SELECT `data`
FROM `shop_session`
WHERE `session_id` = 'jabhr0e5e36qepinudff2kom97'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_session | const | PRIMARY | PRIMARY | 602 | const | 1 |
DELETE
FROM `shop_session`
WHERE `time` < '1679649107'
SELECT `session_id`
FROM `shop_session`
WHERE `session_id` = 'jabhr0e5e36qepinudff2kom97'
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_session | const | PRIMARY | PRIMARY | 602 | const | 1 | Using index |
INSERT INTO `shop_session` (`session_id`, `client_id`, `time`)
VALUES ('jabhr0e5e36qepinudff2kom97', 0, '1679650007')
SELECT extension_id AS id, element AS "option", params, enabled
FROM shop_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using index condition; Using where |
SELECT b.id
FROM shop_usergroups AS a
LEFT JOIN shop_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where; Using index |
SELECT id, rules
FROM `shop_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 |
SELECT folder AS type, element AS name, params
FROM shop_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 352 | Using where; Using filesort |
SELECT *
FROM shop_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | Using where; Using filesort |
SELECT extension_id AS id, element AS "option", params, enabled
FROM shop_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using index condition; Using where |
SELECT COUNT(*)
FROM `shop_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_menu | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 219 | Using where |
SELECT extension_id AS id, element AS "option", params, enabled
FROM shop_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | Using index condition |
UPDATE `shop_extensions`
SET `params` = '{\"mediaversion\":\"b53c6b09e23aa70dde4d0c631b450456\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
SELECT extension_id AS id, element AS "option", params, enabled
FROM shop_extensions
WHERE `type` = 'component'
AND `element` = 'com_k2'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using index condition; Using where |
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 shop_menu AS m
LEFT JOIN shop_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 | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 119 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | serwer100271_techt2.m.component_id | 1 | Using where |
SELECT a.rules
FROM shop_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 | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT b.rules
FROM shop_assets AS a
LEFT JOIN shop_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 | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | const | idx_asset_name | idx_asset_name | 152 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | b | ALL | idx_lft_rgt | NO INDEX KEY COULD BE USED | NULL | NULL | 133 | Using where |
SHOW TABLES LIKE "shop_virtuemart_configs"
SELECT `config`
FROM `shop_virtuemart_configs`
WHERE `virtuemart_config_id` = "1";
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_configs | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 |
SELECT extension_id AS id, element AS "option", params, enabled
FROM shop_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using index condition; Using where |
SELECT *
FROM `shop_menu`
where `link` like "index.php?option=com_virtuemart%"
and client_id=0
and published=1
and (language="*" or language = "pl-PL" )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_menu | ALL | idx_client_id_parent_id_alias_language,idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 219 | Using where |
SELECT id, home, template, s.params
FROM shop_template_styles as s
LEFT JOIN shop_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 | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 62 | const | 9 | Using index condition; Using where |
| 1 | SIMPLE | s | ref | idx_template | idx_template | 152 | serwer100271_techt2.e.element | 1 | Using index condition; Using where |
SELECT extension_id AS id, element AS "option", params, enabled
FROM shop_extensions
WHERE `type` = 'component'
AND `element` = 'com_rokcandy'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | Using index condition; Using where |
SELECT *
FROM shop_rokcandy
WHERE published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_rokcandy | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where |
SELECT *
FROM `shop_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 | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_shoppergroups | ref | virtuemart_vendor_id,shared,published | published | 1 | const | 4 | Using where |
SELECT `shop_virtuemart_shoppergroups`.*
FROM `shop_virtuemart_shoppergroups`
WHERE `shop_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_shoppergroups | const | PRIMARY | PRIMARY | 2 | const | 1 |
SELECT *
FROM `shop_virtuemart_currencies` AS c , `shop_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 | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | v | system | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | |
| 1 | SIMPLE | c | const | PRIMARY | PRIMARY | 2 | const | 1 |
SELECT `shop_virtuemart_currencies`.*
FROM `shop_virtuemart_currencies`
WHERE `shop_virtuemart_currencies`.`virtuemart_currency_id` = "114"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_currencies | const | PRIMARY | PRIMARY | 2 | const | 1 |
SHOW FULL COLUMNS
FROM `shop_virtuemart_userfields`
SELECT *
FROM `shop_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 | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_userfields | ALL | published,account | NO INDEX KEY COULD BE USED | NULL | NULL | 28 | Using where; Using filesort |
SELECT *
FROM `shop_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 | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_userfields | ALL | published,shipment | NO INDEX KEY COULD BE USED | NULL | NULL | 28 | Using where; Using filesort |
SELECT *
FROM shop_virtuemart_calcs
LEFT JOIN shop_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 <= "2023-03-24 09:26:47" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-03-24 09:26:47" )
AND ( virtuemart_shoppergroup_id = 1 OR ISNULL(virtuemart_shoppergroup_id))
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_calcs | system | virtuemart_vendor_id,published,calc_kind,shared | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | |
| 1 | SIMPLE | shop_virtuemart_calc_shoppergroups | system | virtuemart_calc_id | NO INDEX KEY COULD BE USED | NULL | NULL | 0 | Const row not found |
SELECT *
FROM shop_virtuemart_calcs
LEFT JOIN shop_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 <= "2023-03-24 09:26:47" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-03-24 09:26:47" )
AND ( virtuemart_shoppergroup_id = 1 OR ISNULL(virtuemart_shoppergroup_id))
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
SELECT *
FROM shop_virtuemart_calcs
LEFT JOIN shop_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 <= "2023-03-24 09:26:47" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-03-24 09:26:47" )
AND ( virtuemart_shoppergroup_id = 1 OR ISNULL(virtuemart_shoppergroup_id))
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
SELECT *
FROM shop_virtuemart_calcs
LEFT JOIN shop_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 <= "2023-03-24 09:26:47" )
AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2023-03-24 09:26:47" )
AND ( virtuemart_shoppergroup_id = 1 OR ISNULL(virtuemart_shoppergroup_id))
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
