Czas zapytania: 1.23 ms Pamięć zapytania: 0.016 MB Pamięć przed zapytaniem: 4.780 MB Zwróconych wierszy: 0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = '11142c160d287050ffda105054ea9950'
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT `data`
FROM `jos_session`
WHERE `session_id` = '11142c160d287050ffda105054ea9950'
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
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:47
Czas zapytania: 1.33 ms Po ostatnim zapytaniu: 3.72 ms Pamięć zapytania: 0.013 MB Pamięć przed zapytaniem: 5.081 MB Zwróconych wierszy: 0
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = '11142c160d287050ffda105054ea9950'
LIMIT 0, 1
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = '11142c160d287050ffda105054ea9950' LIMIT 0, 1
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
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:47
Czas zapytania: 1.22 ms Po ostatnim zapytaniu: 0.21 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 5.093 MB
INSERT INTO `jos_session`
(`session_id`, `client_id`, `time`)
VALUES
('11142c160d287050ffda105054ea9950', 0, '1582979840')
Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `jos_session`
(`session_id`, `client_id`, `time`) VALUES
('11142c160d287050ffda105054ea9950', 0, '1582979840')
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
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:47
Czas zapytania: 0.90 ms Po ostatnim zapytaniu: 9.94 ms Pamięć zapytania: 0.015 MB Pamięć przed zapytaniem: 5.918 MB Zwróconych wierszy: 2
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 9
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
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:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.43 ms Po ostatnim zapytaniu: 0.93 ms Pamięć zapytania: 0.014 MB Pamięć przed zapytaniem: 6.008 MB Zwróconych wierszy: 5
SELECT id, rules
FROM `jos_viewlevels`
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT id, rules
FROM `jos_viewlevels`
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
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:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 5.72 ms Po ostatnim zapytaniu: 66.68 ms Pamięć zapytania: 0.062 MB Pamięć przed zapytaniem: 10.602 MB Zwróconych wierszy: 232
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 jos_menu AS m
LEFT JOIN jos_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
Polecenie EXPLAIN niemożliwe w zapytaniu: 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 jos_menu AS m
LEFT JOIN jos_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
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
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:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 6.00 ms Po ostatnim zapytaniu: 17.54 ms Pamięć zapytania: 0.018 MB Pamięć przed zapytaniem: 12.786 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"ce3d11dbb964cfa2846d5d168f5ecc28\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"ce3d11dbb964cfa2846d5d168f5ecc28\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:240
JROOT/libraries/cms/version/version.php:199
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/sef/sef.php:29
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 8.68 ms Po ostatnim zapytaniu: 37.92 ms Pamięć zapytania: 0.051 MB Pamięć przed zapytaniem: 16.835 MB Zwróconych wierszy: 734
SELECT *
FROM jos_hikashop_config
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT * FROM jos_hikashop_config
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/config.php:16
JROOT/administrator/components/com_hikashop/helpers/helper.php:970
JROOT/administrator/components/com_hikashop/helpers/helper.php:3276
JROOT/components/com_hikashop/router.php:16
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:46
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 13.21 ms Po ostatnim zapytaniu: 25.46 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 20.137 MB Zwróconych wierszy: 1
SELECT *
FROM jos_menu
WHERE id = '295'
LIMIT 1
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT * FROM jos_menu WHERE id = '295' LIMIT 1
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/helpers/helper.php:1669
JROOT/administrator/components/com_hikashop/classes/menus.php:19
JROOT/administrator/components/com_hikashop/helpers/module.php:187
JROOT/administrator/components/com_hikashop/helpers/module.php:14
JROOT/components/com_hikashop/views/product/view.html.php:161
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.36 ms Po ostatnim zapytaniu: 3.78 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 20.617 MB Zwróconych wierszy: 1
SELECT *
FROM jos_hikashop_category
WHERE category_id = '379'
LIMIT 1
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT * FROM jos_hikashop_category WHERE category_id = '379' LIMIT 1
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/helpers/helper.php:1669
JROOT/administrator/components/com_hikashop/classes/category.php:35
JROOT/components/com_hikashop/views/product/view.html.php:372
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 0.95 ms Po ostatnim zapytaniu: 9.28 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 21.744 MB Zwróconych wierszy: 1
SELECT category_id
FROM jos_hikashop_category
WHERE (category_access = 'all' OR category_access LIKE '%,9,%')
AND category_id IN ('379')
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT category_id FROM jos_hikashop_category WHERE (category_access = 'all' OR category_access LIKE '%,9,%') AND category_id IN ('379')
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/components/com_hikashop/views/product/view.html.php:449
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.58 ms Po ostatnim zapytaniu: 8.44 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 23.060 MB Zwróconych wierszy: 1
SELECT *
FROM jos_hikashop_filter
WHERE filter_published = 1
AND (filter_access = 'all' OR filter_access LIKE '%,9,%')
ORDER BY filter_ordering
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT * FROM jos_hikashop_filter WHERE filter_published = 1 AND (filter_access = 'all' OR filter_access LIKE '%,9,%') ORDER BY filter_ordering
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/filter.php:279
JROOT/components/com_hikashop/views/product/view.html.php:129
JROOT/components/com_hikashop/views/product/view.html.php:471
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.48 ms Po ostatnim zapytaniu: 0.21 ms Pamięć zapytania: 0.031 MB Pamięć przed zapytaniem: 23.090 MB Zwróconych wierszy: 4
SELECT b.*
FROM jos_hikashop_category AS a
LEFT JOIN jos_hikashop_category AS b
ON a.category_left >= b.category_left
WHERE b.category_right >= a.category_right
AND a.category_id=379
GROUP BY b.category_id
ORDER BY b.category_left
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT b.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_category AS b ON a.category_left >= b.category_left WHERE b.category_right >= a.category_right AND a.category_id=379 GROUP BY b.category_id ORDER BY b.category_left
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/category.php:668
JROOT/administrator/components/com_hikashop/classes/filter.php:297
JROOT/components/com_hikashop/views/product/view.html.php:129
JROOT/components/com_hikashop/views/product/view.html.php:471
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 2.14 ms Po ostatnim zapytaniu: 0.60 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 23.133 MB Zwróconych wierszy: 1
SELECT a.*,b.*
FROM jos_hikashop_category AS a
LEFT JOIN jos_hikashop_file AS b
ON a.category_id=b.file_ref_id
AND b.file_type='category'
WHERE a.category_id = 379
LIMIT 1
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT a.*,b.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_file AS b ON a.category_id=b.file_ref_id AND b.file_type='category' WHERE a.category_id = 379 LIMIT 1
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/category.php:32
JROOT/components/com_hikashop/views/product/view.html.php:474
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 3.05 ms Po ostatnim zapytaniu: 0.27 ms Pamięć zapytania: 0.031 MB Pamięć przed zapytaniem: 23.165 MB Zwróconych wierszy: 1
SELECT *
FROM jos_hikashop_category
WHERE category_id = '379'
LIMIT 1
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT * FROM jos_hikashop_category WHERE category_id = '379' LIMIT 1
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/helpers/helper.php:1669
JROOT/administrator/components/com_hikashop/classes/category.php:35
JROOT/administrator/components/com_hikashop/classes/category.php:457
JROOT/components/com_hikashop/views/product/view.html.php:512
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 13.77 ms Po ostatnim zapytaniu: 57.77 ms Pamięć zapytania: 0.040 MB Pamięć przed zapytaniem: 29.123 MB Zwróconych wierszy: 21
SELECT DISTINCT b.*
FROM jos_hikashop_product_category AS a
LEFT JOIN jos_hikashop_product AS b
ON a.product_id=b.product_id
WHERE b.product_published=1
AND b.product_type = 'main'
AND a.category_id IN (379)
AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%')
ORDER BY a.ordering ASC
LIMIT 0, 50
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT DISTINCT b.* FROM jos_hikashop_product_category AS a LEFT JOIN jos_hikashop_product AS b ON a.product_id=b.product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (379) AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY a.ordering ASC LIMIT 0, 50
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/components/com_hikashop/views/product/view.html.php:610
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 3.94 ms Po ostatnim zapytaniu: 8.62 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 29.479 MB Zwróconych wierszy: 21
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2701,2702,2704,2714,2715,2798)
AND file_type='product'
ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT * FROM jos_hikashop_file WHERE file_ref_id IN (2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2701,2702,2704,2714,2715,2798) AND file_type='product' ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/components/com_hikashop/views/product/view.html.php:626
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 4.47 ms Po ostatnim zapytaniu: 0.51 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 29.560 MB Zwróconych wierszy: 0
SELECT variant_product_id
FROM jos_hikashop_variant
WHERE variant_product_id IN (2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2701,2702,2704,2714,2715,2798)
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT variant_product_id FROM jos_hikashop_variant WHERE variant_product_id IN (2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2701,2702,2704,2714,2715,2798)
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/components/com_hikashop/views/product/view.html.php:651
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.69 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 29.580 MB Zwróconych wierszy: 0
SELECT product_id
FROM jos_hikashop_product_related
WHERE product_related_type = 'options'
AND product_id IN (2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2701,2702,2704,2714,2715,2798)
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT product_id FROM jos_hikashop_product_related WHERE product_related_type = 'options' AND product_id IN (2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2701,2702,2704,2714,2715,2798)
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/components/com_hikashop/views/product/view.html.php:663
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.37 ms Po ostatnim zapytaniu: 0.31 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 29.619 MB Zwróconych wierszy: 0
SELECT *
FROM jos_hikashop_discount
WHERE discount_type='discount'
AND discount_published=1
AND ( discount_quota>discount_used_times OR discount_quota=0 )
AND discount_start < 1582979840
AND ( discount_end > 1582979840 OR discount_end = 0 )
AND ( discount_product_id='0' OR discount_product_id='' OR discount_product_id LIKE '%,2488,%' OR discount_product_id = '2488' OR discount_product_id LIKE '%,2489,%' OR discount_product_id = '2489' OR discount_product_id LIKE '%,2490,%' OR discount_product_id = '2490' OR discount_product_id LIKE '%,2491,%' OR discount_product_id = '2491' OR discount_product_id LIKE '%,2492,%' OR discount_product_id = '2492' OR discount_product_id LIKE '%,2493,%' OR discount_product_id = '2493' OR discount_product_id LIKE '%,2494,%' OR discount_product_id = '2494' OR discount_product_id LIKE '%,2495,%' OR discount_product_id = '2495' OR discount_product_id LIKE '%,2496,%' OR discount_product_id = '2496' OR discount_product_id LIKE '%,2497,%' OR discount_product_id = '2497' OR discount_product_id LIKE '%,2498,%' OR discount_product_id = '2498' OR discount_product_id LIKE '%,2499,%' OR discount_product_id = '2499' OR discount_product_id LIKE '%,2500,%' OR discount_product_id = '2500' OR discount_product_id LIKE '%,2501,%' OR discount_product_id = '2501' OR discount_product_id LIKE '%,2502,%' OR discount_product_id = '2502' OR discount_product_id LIKE '%,2701,%' OR discount_product_id = '2701' OR discount_product_id LIKE '%,2702,%' OR discount_product_id = '2702' OR discount_product_id LIKE '%,2704,%' OR discount_product_id = '2704' OR discount_product_id LIKE '%,2714,%' OR discount_product_id = '2714' OR discount_product_id LIKE '%,2715,%' OR discount_product_id = '2715' OR discount_product_id LIKE '%,2798,%' OR discount_product_id = '2798' )
AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
AND (discount_access = 'all' OR discount_access LIKE '%,9,%')
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT * FROM jos_hikashop_discount WHERE discount_type='discount' AND discount_published=1 AND ( discount_quota>discount_used_times OR discount_quota=0 ) AND discount_start < 1582979840 AND ( discount_end > 1582979840 OR discount_end = 0 ) AND ( discount_product_id='0' OR discount_product_id='' OR discount_product_id LIKE '%,2488,%' OR discount_product_id = '2488' OR discount_product_id LIKE '%,2489,%' OR discount_product_id = '2489' OR discount_product_id LIKE '%,2490,%' OR discount_product_id = '2490' OR discount_product_id LIKE '%,2491,%' OR discount_product_id = '2491' OR discount_product_id LIKE '%,2492,%' OR discount_product_id = '2492' OR discount_product_id LIKE '%,2493,%' OR discount_product_id = '2493' OR discount_product_id LIKE '%,2494,%' OR discount_product_id = '2494' OR discount_product_id LIKE '%,2495,%' OR discount_product_id = '2495' OR discount_product_id LIKE '%,2496,%' OR discount_product_id = '2496' OR discount_product_id LIKE '%,2497,%' OR discount_product_id = '2497' OR discount_product_id LIKE '%,2498,%' OR discount_product_id = '2498' OR discount_product_id LIKE '%,2499,%' OR discount_product_id = '2499' OR discount_product_id LIKE '%,2500,%' OR discount_product_id = '2500' OR discount_product_id LIKE '%,2501,%' OR discount_product_id = '2501' OR discount_product_id LIKE '%,2502,%' OR discount_product_id = '2502' OR discount_product_id LIKE '%,2701,%' OR discount_product_id = '2701' OR discount_product_id LIKE '%,2702,%' OR discount_product_id = '2702' OR discount_product_id LIKE '%,2704,%' OR discount_product_id = '2704' OR discount_product_id LIKE '%,2714,%' OR discount_product_id = '2714' OR discount_product_id LIKE '%,2715,%' OR discount_product_id = '2715' OR discount_product_id LIKE '%,2798,%' OR discount_product_id = '2798' ) AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 ) AND (discount_access = 'all' OR discount_access LIKE '%,9,%')
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/currency.php:463
JROOT/components/com_hikashop/views/product/view.html.php:675
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.87 ms Po ostatnim zapytaniu: 0.14 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 29.640 MB Zwróconych wierszy: 2
SELECT currency_id
FROM jos_hikashop_currency
WHERE currency_published=1 OR currency_id = 125
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT currency_id FROM jos_hikashop_currency WHERE currency_published=1 OR currency_id = 125
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/currency.php:427
JROOT/administrator/components/com_hikashop/classes/currency.php:466
JROOT/components/com_hikashop/views/product/view.html.php:675
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 6.51 ms Po ostatnim zapytaniu: 0.17 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 29.659 MB Zwróconych wierszy: 21
SELECT a.*
FROM jos_hikashop_price AS a
WHERE a.price_product_id IN (2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2701,2702,2704,2714,2715,2798)
AND a.price_currency_id IN (1,125)
AND (a.price_access = 'all' OR a.price_access LIKE '%,9,%' OR ISNULL(a.price_access))
ORDER BY a.price_site_id ASC, a.price_value DESC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT a.* FROM jos_hikashop_price AS a WHERE a.price_product_id IN (2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2701,2702,2704,2714,2715,2798) AND a.price_currency_id IN (1,125) AND (a.price_access = 'all' OR a.price_access LIKE '%,9,%' OR ISNULL(a.price_access)) ORDER BY a.price_site_id ASC, a.price_value DESC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/currency.php:472
JROOT/components/com_hikashop/views/product/view.html.php:675
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.01 ms Po ostatnim zapytaniu: 0.40 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 29.718 MB Zwróconych wierszy: 1
SELECT b.*,c.*
FROM jos_hikashop_category AS a
LEFT JOIN jos_hikashop_taxation AS b
ON a.category_namekey=b.category_namekey
LEFT JOIN jos_hikashop_tax AS c
ON b.tax_namekey=c.tax_namekey
WHERE a.category_id = 11
AND b.taxation_published=1
AND ( taxation_type = '' OR (taxation_type = 'company_with_vat_number' OR taxation_type LIKE '%company\_with\_vat\_number%') )
AND b.taxation_date_start <= 1582979840
AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1582979840)
AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,9,%')
ORDER BY b.taxation_id ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT b.*,c.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_taxation AS b ON a.category_namekey=b.category_namekey LEFT JOIN jos_hikashop_tax AS c ON b.tax_namekey=c.tax_namekey WHERE a.category_id = 11 AND b.taxation_published=1 AND ( taxation_type = '' OR (taxation_type = 'company_with_vat_number' OR taxation_type LIKE '%company\_with\_vat\_number%') ) AND b.taxation_date_start <= 1582979840 AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1582979840) AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,9,%') ORDER BY b.taxation_id ASC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/currency.php:164
JROOT/administrator/components/com_hikashop/classes/currency.php:56
JROOT/administrator/components/com_hikashop/classes/currency.php:534
JROOT/components/com_hikashop/views/product/view.html.php:675
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.85 ms Po ostatnim zapytaniu: 0.14 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 29.743 MB Zwróconych wierszy: 1
SELECT *
FROM jos_hikashop_zone
WHERE zone_id = 170
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT * FROM jos_hikashop_zone WHERE zone_id = 170
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/currency.php:185
JROOT/administrator/components/com_hikashop/classes/currency.php:56
JROOT/administrator/components/com_hikashop/classes/currency.php:534
JROOT/components/com_hikashop/views/product/view.html.php:675
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 2.06 ms Po ostatnim zapytaniu: 1.21 ms Pamięć zapytania: 0.035 MB Pamięć przed zapytaniem: 29.828 MB Zwróconych wierszy: 0
SELECT a.*,b.*
FROM jos_hikashop_product AS a
LEFT JOIN jos_hikashop_price AS b
ON a.product_id=b.price_product_id
WHERE a.product_parent_id IN (2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2701,2702,2704,2714,2715,2798)
AND a.product_published=1
AND b.price_currency_id IN (1,125)
AND (b.price_access = 'all' OR b.price_access LIKE '%,9,%' OR ISNULL(b.price_access))
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT a.*,b.* FROM jos_hikashop_product AS a LEFT JOIN jos_hikashop_price AS b ON a.product_id=b.price_product_id WHERE a.product_parent_id IN (2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2701,2702,2704,2714,2715,2798) AND a.product_published=1 AND b.price_currency_id IN (1,125) AND (b.price_access = 'all' OR b.price_access LIKE '%,9,%' OR ISNULL(b.price_access))
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/currency.php:616
JROOT/components/com_hikashop/views/product/view.html.php:675
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 2.17 ms Po ostatnim zapytaniu: 0.20 ms Pamięć zapytania: 0.033 MB Pamięć przed zapytaniem: 29.830 MB Zwróconych wierszy: 26
SELECT *
FROM jos_hikashop_category AS a
LEFT JOIN jos_hikashop_product_category AS b
ON a.category_id = b.category_id
WHERE b.product_id IN (2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2701,2702,2704,2714,2715,2798);
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT * FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_product_category AS b ON a.category_id = b.category_id WHERE b.product_id IN (2488,2489,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2701,2702,2704,2714,2715,2798);
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/components/com_hikashop/views/product/view.html.php:705
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.91 ms Po ostatnim zapytaniu: 0.72 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 29.993 MB Zwróconych wierszy: 1
SELECT count( DISTINCT b.product_id)
FROM jos_hikashop_product_category AS a
LEFT JOIN jos_hikashop_product AS b
ON a.product_id=b.product_id
WHERE b.product_published=1
AND b.product_type = 'main'
AND a.category_id IN (379)
AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%')
ORDER BY a.ordering ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT count( DISTINCT b.product_id) FROM jos_hikashop_product_category AS a LEFT JOIN jos_hikashop_product AS b ON a.product_id=b.product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (379) AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') ORDER BY a.ordering ASC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/components/com_hikashop/views/product/view.html.php:720
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.21 ms Po ostatnim zapytaniu: 1.43 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 30.073 MB Zwróconych wierszy: 1
SELECT category_id
FROM jos_hikashop_product_category
WHERE product_id IN (2488)
ORDER BY ordering ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT category_id FROM jos_hikashop_product_category WHERE product_id IN (2488) ORDER BY ordering ASC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/product.php:303
JROOT/administrator/components/com_hikashop/classes/badge.php:86
JROOT/components/com_hikashop/views/product/view.html.php:729
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.20 ms Po ostatnim zapytaniu: 0.15 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 30.097 MB Zwróconych wierszy: 4
SELECT b.*
FROM jos_hikashop_category AS a
LEFT JOIN jos_hikashop_category AS b
ON a.category_left >= b.category_left
WHERE b.category_right >= a.category_right
AND a.category_id IN (379)
GROUP BY b.category_id
ORDER BY b.category_left
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT b.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_category AS b ON a.category_left >= b.category_left WHERE b.category_right >= a.category_right AND a.category_id IN (379) GROUP BY b.category_id ORDER BY b.category_left
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/category.php:668
JROOT/administrator/components/com_hikashop/classes/badge.php:99
JROOT/components/com_hikashop/views/product/view.html.php:729
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 0.88 ms Po ostatnim zapytaniu: 0.24 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 30.142 MB Zwróconych wierszy: 0
SELECT a.*
FROM jos_hikashop_badge AS a
WHERE a.badge_start <= 1582979840
AND ( a.badge_end >= 1582979840 OR a.badge_end =0 )
AND a.badge_published=1
AND (a.badge_quantity='' OR a.badge_quantity=4)
AND (badge_discount_id=0 OR badge_discount_id LIKE '%,0,%' OR badge_discount_id='0' OR badge_discount_id='' )
AND ((badge_category_childs = 0
AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%')) OR (badge_category_childs = 1
AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%')))
ORDER BY a.badge_ordering ASC,a.badge_id ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT a.* FROM jos_hikashop_badge AS a WHERE a.badge_start <= 1582979840 AND ( a.badge_end >= 1582979840 OR a.badge_end =0 ) AND a.badge_published=1 AND (a.badge_quantity='' OR a.badge_quantity=4) AND (badge_discount_id=0 OR badge_discount_id LIKE '%,0,%' OR badge_discount_id='0' OR badge_discount_id='' ) AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/badge.php:133
JROOT/components/com_hikashop/views/product/view.html.php:729
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.46 ms Po ostatnim zapytaniu: 0.20 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 30.159 MB Zwróconych wierszy: 1
SELECT category_id
FROM jos_hikashop_product_category
WHERE product_id IN (2489)
ORDER BY ordering ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT category_id FROM jos_hikashop_product_category WHERE product_id IN (2489) ORDER BY ordering ASC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/product.php:303
JROOT/administrator/components/com_hikashop/classes/badge.php:86
JROOT/components/com_hikashop/views/product/view.html.php:729
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.35 ms Po ostatnim zapytaniu: 0.17 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 30.186 MB Zwróconych wierszy: 0
SELECT a.*
FROM jos_hikashop_badge AS a
WHERE a.badge_start <= 1582979840
AND ( a.badge_end >= 1582979840 OR a.badge_end =0 )
AND a.badge_published=1
AND (a.badge_quantity='' OR a.badge_quantity=7)
AND (badge_discount_id=0 OR badge_discount_id LIKE '%,0,%' OR badge_discount_id='0' OR badge_discount_id='' )
AND ((badge_category_childs = 0
AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%')) OR (badge_category_childs = 1
AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%')))
ORDER BY a.badge_ordering ASC,a.badge_id ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT a.* FROM jos_hikashop_badge AS a WHERE a.badge_start <= 1582979840 AND ( a.badge_end >= 1582979840 OR a.badge_end =0 ) AND a.badge_published=1 AND (a.badge_quantity='' OR a.badge_quantity=7) AND (badge_discount_id=0 OR badge_discount_id LIKE '%,0,%' OR badge_discount_id='0' OR badge_discount_id='' ) AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/badge.php:133
JROOT/components/com_hikashop/views/product/view.html.php:729
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 0.97 ms Po ostatnim zapytaniu: 0.21 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 30.204 MB Zwróconych wierszy: 1
SELECT category_id
FROM jos_hikashop_product_category
WHERE product_id IN (2490)
ORDER BY ordering ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT category_id FROM jos_hikashop_product_category WHERE product_id IN (2490) ORDER BY ordering ASC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/product.php:303
JROOT/administrator/components/com_hikashop/classes/badge.php:86
JROOT/components/com_hikashop/views/product/view.html.php:729
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 0.75 ms Po ostatnim zapytaniu: 0.17 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 30.232 MB Zwróconych wierszy: 0
SELECT a.*
FROM jos_hikashop_badge AS a
WHERE a.badge_start <= 1582979840
AND ( a.badge_end >= 1582979840 OR a.badge_end =0 )
AND a.badge_published=1
AND (a.badge_quantity='' OR a.badge_quantity=2)
AND (badge_discount_id=0 OR badge_discount_id LIKE '%,0,%' OR badge_discount_id='0' OR badge_discount_id='' )
AND ((badge_category_childs = 0
AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%')) OR (badge_category_childs = 1
AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%')))
ORDER BY a.badge_ordering ASC,a.badge_id ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT a.* FROM jos_hikashop_badge AS a WHERE a.badge_start <= 1582979840 AND ( a.badge_end >= 1582979840 OR a.badge_end =0 ) AND a.badge_published=1 AND (a.badge_quantity='' OR a.badge_quantity=2) AND (badge_discount_id=0 OR badge_discount_id LIKE '%,0,%' OR badge_discount_id='0' OR badge_discount_id='' ) AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/badge.php:133
JROOT/components/com_hikashop/views/product/view.html.php:729
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.03 ms Po ostatnim zapytaniu: 0.20 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 30.249 MB Zwróconych wierszy: 1
SELECT category_id
FROM jos_hikashop_product_category
WHERE product_id IN (2491)
ORDER BY ordering ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT category_id FROM jos_hikashop_product_category WHERE product_id IN (2491) ORDER BY ordering ASC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/product.php:303
JROOT/administrator/components/com_hikashop/classes/badge.php:86
JROOT/components/com_hikashop/views/product/view.html.php:729
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 0.80 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 30.277 MB Zwróconych wierszy: 0
SELECT a.*
FROM jos_hikashop_badge AS a
WHERE a.badge_start <= 1582979840
AND ( a.badge_end >= 1582979840 OR a.badge_end =0 )
AND a.badge_published=1
AND (a.badge_quantity='' OR a.badge_quantity=1)
AND (badge_discount_id=0 OR badge_discount_id LIKE '%,0,%' OR badge_discount_id='0' OR badge_discount_id='' )
AND ((badge_category_childs = 0
AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%')) OR (badge_category_childs = 1
AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%')))
ORDER BY a.badge_ordering ASC,a.badge_id ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT a.* FROM jos_hikashop_badge AS a WHERE a.badge_start <= 1582979840 AND ( a.badge_end >= 1582979840 OR a.badge_end =0 ) AND a.badge_published=1 AND (a.badge_quantity='' OR a.badge_quantity=1) AND (badge_discount_id=0 OR badge_discount_id LIKE '%,0,%' OR badge_discount_id='0' OR badge_discount_id='' ) AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '39' OR badge_category_id LIKE '%,39,%' OR badge_category_id = '379' OR badge_category_id LIKE '%,379,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/badge.php:133
JROOT/components/com_hikashop/views/product/view.html.php:729
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 1.07 ms Po ostatnim zapytaniu: 0.19 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 30.294 MB Zwróconych wierszy: 1
SELECT category_id
FROM jos_hikashop_product_category
WHERE product_id IN (2492)
ORDER BY ordering ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT category_id FROM jos_hikashop_product_category WHERE product_id IN (2492) ORDER BY ordering ASC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/product.php:303
JROOT/administrator/components/com_hikashop/classes/badge.php:86
JROOT/components/com_hikashop/views/product/view.html.php:729
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 5.63 ms Po ostatnim zapytaniu: 0.24 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 30.317 MB Zwróconych wierszy: 1
SELECT category_id
FROM jos_hikashop_product_category
WHERE product_id IN (2493)
ORDER BY ordering ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT category_id FROM jos_hikashop_product_category WHERE product_id IN (2493) ORDER BY ordering ASC
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/administrator/components/com_hikashop/classes/product.php:303
JROOT/administrator/components/com_hikashop/classes/badge.php:86
JROOT/components/com_hikashop/views/product/view.html.php:729
JROOT/components/com_hikashop/views/product/view.html.php:37
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/administrator/components/com_hikashop/helpers/helper.php:1506
JROOT/administrator/components/com_hikashop/helpers/helper.php:1241
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/administrator/components/com_hikashop/helpers/helper.php:1486
JROOT/components/com_hikashop/hikashop.php:77
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:50
Czas zapytania: 0.95 ms Po ostatnim zapytaniu: 0.24 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 30.340 MB Zwróconych wierszy: 1
SELECT category_id
FROM jos_hikashop_product_category
WHERE product_id IN (2494)
ORDER BY ordering ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT category_id FROM jos_hikashop_product_category WHERE product_id IN (2494) ORDER BY ord
