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` = 'deej23pebecl6mqb0vpb50sg65'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_session | const | PRIMARY | PRIMARY | 602 | const | 1 |
SELECT `session_id`
FROM `shop_session`
WHERE `session_id` = 'deej23pebecl6mqb0vpb50sg65'
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 ('deej23pebecl6mqb0vpb50sg65', 0, '1679651536')
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\":\"80c313623823af47a4741d9e66668864\"}'
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 `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM shop_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 45
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | xref | ref | category_child_id | category_child_id | 4 | const | 1 |
SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
FROM shop_virtuemart_category_categories AS `xref`
WHERE `xref`.`category_child_id`= 37
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | xref | ref | category_child_id | category_child_id | 4 | const | 1 |
SELECT `shop_virtuemart_categories`.* ,`shop_virtuemart_categories_pl_pl`.*
FROM `shop_virtuemart_categories`
INNER JOIN `shop_virtuemart_categories_pl_pl` using (`virtuemart_category_id`)
WHERE `shop_virtuemart_categories`.`virtuemart_category_id` = "37"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_categories | const | PRIMARY | PRIMARY | 3 | const | 1 | |
| 1 | SIMPLE | shop_virtuemart_categories_pl_pl | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `virtuemart_media_id`
FROM `shop_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "37"
ORDER BY `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_category_medias | ref | virtuemart_category_id | virtuemart_category_id | 3 | const | 2 | Using where; Using filesort |
SELECT `shop_virtuemart_categories`.* ,`shop_virtuemart_categories_pl_pl`.*
FROM `shop_virtuemart_categories`
INNER JOIN `shop_virtuemart_categories_pl_pl` using (`virtuemart_category_id`)
WHERE `shop_virtuemart_categories`.`virtuemart_category_id` = "45"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_categories | const | PRIMARY | PRIMARY | 3 | const | 1 | |
| 1 | SIMPLE | shop_virtuemart_categories_pl_pl | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `virtuemart_media_id`
FROM `shop_virtuemart_category_medias`
WHERE `virtuemart_category_id` = "45"
ORDER BY `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_category_medias | ref | virtuemart_category_id | virtuemart_category_id | 3 | const | 1 | Using where; Using filesort |
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 `shop_virtuemart_products`.* ,`shop_virtuemart_products_pl_pl`.*
FROM `shop_virtuemart_products`
INNER JOIN `shop_virtuemart_products_pl_pl` using (`virtuemart_product_id`)
WHERE `shop_virtuemart_products`.`virtuemart_product_id` = "84"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_products | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | shop_virtuemart_products_pl_pl | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `virtuemart_media_id`
FROM `shop_virtuemart_product_medias`
WHERE `virtuemart_product_id` = "84"
ORDER BY `ordering`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_product_medias | ref | virtuemart_product_id | virtuemart_product_id | 4 | const | 2 | Using where; Using filesort |
SELECT `virtuemart_shoppergroup_id`
FROM `shop_virtuemart_product_shoppergroups`
WHERE `virtuemart_product_id` = "84"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_product_shoppergroups | ref | virtuemart_product_id | virtuemart_product_id | 4 | const | 1 | Using index |
SELECT *
FROM `shop_virtuemart_product_prices`
WHERE `virtuemart_product_id` = "84"
AND ( `virtuemart_shoppergroup_id` ="1" 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` <= "2023-03-24 09:52:16" )
AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2023-03-24 09:52:16" ) )
ORDER BY `product_price` DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_product_prices | ref | virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down | virtuemart_product_id | 4 | const | 1 | Using where; Using filesort |
Trafo Pool 230/12V
