Transformatory separacyjne bezpieczeństwa do zasilania lamp halogenowych na basenach, fontannach i innych miejscach narażonych na bezpośrednie działanie czynników atmosferycznych.
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` = 'e3k8rb55a47r18kf0j1fguind6'
| 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` < '1679653011'
SELECT `session_id`
FROM `shop_session`
WHERE `session_id` = 'e3k8rb55a47r18kf0j1fguind6'
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 ('e3k8rb55a47r18kf0j1fguind6', 0, '1679653911')
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\":\"b561f92c35408cdf9f073b5502585896\"}'
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`= 36
| 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` = "36"
| 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` = "36"
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 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 `virtuemart_custom_id`, `custom_title`
FROM `shop_virtuemart_customs`
WHERE `field_type` ="P"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_customs | ref | field_type | field_type | 6 | const | 1 | Using index condition |
SELECT `virtuemart_custom_id`, `custom_title`
FROM `shop_virtuemart_customs`
WHERE `custom_element` ="specification"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_customs | ref | custom_element | custom_element | 150 | const | 1 | Using index condition |
SELECT `category_child_id`
FROM `shop_virtuemart_category_categories`
WHERE `category_parent_id` = 36
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_category_categories | ref | category_parent_id | category_parent_id | 4 | const | 1 | Using index |
SELECT count(shop_virtuemart_products.virtuemart_product_id) AS total
FROM `shop_virtuemart_products`, `shop_virtuemart_product_categories`
WHERE `shop_virtuemart_products`.`virtuemart_vendor_id` = "1"
AND `shop_virtuemart_product_categories`.`virtuemart_category_id` = 36
AND `shop_virtuemart_products`.`virtuemart_product_id` = `shop_virtuemart_product_categories`.`virtuemart_product_id`
AND `shop_virtuemart_products`.`published` = "1"
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | shop_virtuemart_product_categories | index | virtuemart_product_id | virtuemart_product_id | 7 | NULL | 23 | Using where; Using index |
| 1 | SIMPLE | shop_virtuemart_products | eq_ref | PRIMARY,virtuemart_vendor_id,published | PRIMARY | 4 | serwer100271_techt2.shop_virtuemart_product_categories.virtuemart_product_id | 1 | Using where |
