Czas zapytania: 1.95 ms Pamięć zapytania: 0.016 MB Pamięć przed zapytaniem: 4.780 MB Zwróconych wierszy: 0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = 'e4b2988ea568583a466abe35d58cbe9d'
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT `data`
FROM `jos_session`
WHERE `session_id` = 'e4b2988ea568583a466abe35d58cbe9d'
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: 0.70 ms Po ostatnim zapytaniu: 3.85 ms Pamięć zapytania: 0.008 MB Pamięć przed zapytaniem: 5.082 MB
DELETE
FROM `jos_session`
WHERE `time` < '1582982643'
Polecenie EXPLAIN niemożliwe w zapytaniu: DELETE
FROM `jos_session`
WHERE `time` < '1582982643'
Brak SHOW PROFILE (może dlatego, że istnieje ponad 100 zapytań)
JROOT/libraries/cms/application/cms.php:756
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.02 ms Po ostatnim zapytaniu: 0.17 ms Pamięć zapytania: 0.013 MB Pamięć przed zapytaniem: 5.097 MB Zwróconych wierszy: 0
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = 'e4b2988ea568583a466abe35d58cbe9d'
LIMIT 0, 1
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = 'e4b2988ea568583a466abe35d58cbe9d' 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.46 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 5.108 MB
INSERT INTO `jos_session`
(`session_id`, `client_id`, `time`)
VALUES
('e4b2988ea568583a466abe35d58cbe9d', 0, '1582983543')
Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `jos_session`
(`session_id`, `client_id`, `time`) VALUES
('e4b2988ea568583a466abe35d58cbe9d', 0, '1582983543')
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: 7.39 ms Po ostatnim zapytaniu: 9.04 ms Pamięć zapytania: 0.015 MB Pamięć przed zapytaniem: 5.927 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: 18.96 ms Po ostatnim zapytaniu: 1.18 ms Pamięć zapytania: 0.014 MB Pamięć przed zapytaniem: 6.017 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: 6.26 ms Po ostatnim zapytaniu: 128.44 ms Pamięć zapytania: 0.062 MB Pamięć przed zapytaniem: 10.611 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: 0.77 ms Po ostatnim zapytaniu: 20.30 ms Pamięć zapytania: 0.018 MB Pamięć przed zapytaniem: 12.795 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"e2af7697d7a7476f14775c7c19cd6b5f\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"e2af7697d7a7476f14775c7c19cd6b5f\"}'
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: 24.15 ms Po ostatnim zapytaniu: 39.59 ms Pamięć zapytania: 0.051 MB Pamięć przed zapytaniem: 16.844 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: 1.21 ms Po ostatnim zapytaniu: 30.40 ms Pamięć zapytania: 0.031 MB Pamięć przed zapytaniem: 20.146 MB Zwróconych wierszy: 1
SELECT *
FROM jos_menu
WHERE id = '319'
LIMIT 1
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT * FROM jos_menu WHERE id = '319' 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: 0.76 ms Po ostatnim zapytaniu: 3.81 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 20.627 MB Zwróconych wierszy: 1
SELECT *
FROM jos_hikashop_category
WHERE category_id = '317'
LIMIT 1
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT * FROM jos_hikashop_category WHERE category_id = '317' 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: 1.87 ms Po ostatnim zapytaniu: 8.40 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 21.754 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 ('317')
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 ('317')
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: 4.98 ms Po ostatnim zapytaniu: 8.67 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 23.069 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.14 ms Po ostatnim zapytaniu: 0.26 ms Pamięć zapytania: 0.031 MB Pamięć przed zapytaniem: 23.100 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=317
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=317 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: 6.86 ms Po ostatnim zapytaniu: 0.55 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 23.143 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 = 317
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 = 317 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: 0.99 ms Po ostatnim zapytaniu: 0.37 ms Pamięć zapytania: 0.031 MB Pamięć przed zapytaniem: 23.175 MB Zwróconych wierszy: 1
SELECT *
FROM jos_hikashop_category
WHERE category_id = '317'
LIMIT 1
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT * FROM jos_hikashop_category WHERE category_id = '317' 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: 9.17 ms Po ostatnim zapytaniu: 51.15 ms Pamięć zapytania: 0.043 MB Pamięć przed zapytaniem: 29.133 MB Zwróconych wierszy: 32
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 (317)
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 (317) 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: 2.11 ms Po ostatnim zapytaniu: 9.54 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 29.614 MB Zwróconych wierszy: 32
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (1066,1064,1067,1068,1065,1069,2879,2880,2881,2882,2883,2884,2886,2887,2908,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2896,2878,2877,2876,2875,2909)
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 (1066,1064,1067,1068,1065,1069,2879,2880,2881,2882,2883,2884,2886,2887,2908,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2896,2878,2877,2876,2875,2909) 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.94 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 29.727 MB Zwróconych wierszy: 0
SELECT variant_product_id
FROM jos_hikashop_variant
WHERE variant_product_id IN (1066,1064,1067,1068,1065,1069,2879,2880,2881,2882,2883,2884,2886,2887,2908,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2896,2878,2877,2876,2875,2909)
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT variant_product_id FROM jos_hikashop_variant WHERE variant_product_id IN (1066,1064,1067,1068,1065,1069,2879,2880,2881,2882,2883,2884,2886,2887,2908,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2896,2878,2877,2876,2875,2909)
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: 5.70 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 29.747 MB Zwróconych wierszy: 0
SELECT product_id
FROM jos_hikashop_product_related
WHERE product_related_type = 'options'
AND product_id IN (1066,1064,1067,1068,1065,1069,2879,2880,2881,2882,2883,2884,2886,2887,2908,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2896,2878,2877,2876,2875,2909)
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT product_id FROM jos_hikashop_product_related WHERE product_related_type = 'options' AND product_id IN (1066,1064,1067,1068,1065,1069,2879,2880,2881,2882,2883,2884,2886,2887,2908,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2896,2878,2877,2876,2875,2909)
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.07 ms Po ostatnim zapytaniu: 0.48 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 29.794 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 < 1582983544
AND ( discount_end > 1582983544 OR discount_end = 0 )
AND ( discount_product_id='0' OR discount_product_id='' OR discount_product_id LIKE '%,1066,%' OR discount_product_id = '1066' OR discount_product_id LIKE '%,1064,%' OR discount_product_id = '1064' OR discount_product_id LIKE '%,1067,%' OR discount_product_id = '1067' OR discount_product_id LIKE '%,1068,%' OR discount_product_id = '1068' OR discount_product_id LIKE '%,1065,%' OR discount_product_id = '1065' OR discount_product_id LIKE '%,1069,%' OR discount_product_id = '1069' OR discount_product_id LIKE '%,2879,%' OR discount_product_id = '2879' OR discount_product_id LIKE '%,2880,%' OR discount_product_id = '2880' OR discount_product_id LIKE '%,2881,%' OR discount_product_id = '2881' OR discount_product_id LIKE '%,2882,%' OR discount_product_id = '2882' OR discount_product_id LIKE '%,2883,%' OR discount_product_id = '2883' OR discount_product_id LIKE '%,2884,%' OR discount_product_id = '2884' OR discount_product_id LIKE '%,2886,%' OR discount_product_id = '2886' OR discount_product_id LIKE '%,2887,%' OR discount_product_id = '2887' OR discount_product_id LIKE '%,2908,%' OR discount_product_id = '2908' OR discount_product_id LIKE '%,2907,%' OR discount_product_id = '2907' OR discount_product_id LIKE '%,2906,%' OR discount_product_id = '2906' OR discount_product_id LIKE '%,2905,%' OR discount_product_id = '2905' OR discount_product_id LIKE '%,2904,%' OR discount_product_id = '2904' OR discount_product_id LIKE '%,2903,%' OR discount_product_id = '2903' OR discount_product_id LIKE '%,2902,%' OR discount_product_id = '2902' OR discount_product_id LIKE '%,2901,%' OR discount_product_id = '2901' OR discount_product_id LIKE '%,2900,%' OR discount_product_id = '2900' OR discount_product_id LIKE '%,2899,%' OR discount_product_id = '2899' OR discount_product_id LIKE '%,2898,%' OR discount_product_id = '2898' OR discount_product_id LIKE '%,2897,%' OR discount_product_id = '2897' OR discount_product_id LIKE '%,2896,%' OR discount_product_id = '2896' OR discount_product_id LIKE '%,2878,%' OR discount_product_id = '2878' OR discount_product_id LIKE '%,2877,%' OR discount_product_id = '2877' OR discount_product_id LIKE '%,2876,%' OR discount_product_id = '2876' OR discount_product_id LIKE '%,2875,%' OR discount_product_id = '2875' OR discount_product_id LIKE '%,2909,%' OR discount_product_id = '2909' )
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 < 1582983544 AND ( discount_end > 1582983544 OR discount_end = 0 ) AND ( discount_product_id='0' OR discount_product_id='' OR discount_product_id LIKE '%,1066,%' OR discount_product_id = '1066' OR discount_product_id LIKE '%,1064,%' OR discount_product_id = '1064' OR discount_product_id LIKE '%,1067,%' OR discount_product_id = '1067' OR discount_product_id LIKE '%,1068,%' OR discount_product_id = '1068' OR discount_product_id LIKE '%,1065,%' OR discount_product_id = '1065' OR discount_product_id LIKE '%,1069,%' OR discount_product_id = '1069' OR discount_product_id LIKE '%,2879,%' OR discount_product_id = '2879' OR discount_product_id LIKE '%,2880,%' OR discount_product_id = '2880' OR discount_product_id LIKE '%,2881,%' OR discount_product_id = '2881' OR discount_product_id LIKE '%,2882,%' OR discount_product_id = '2882' OR discount_product_id LIKE '%,2883,%' OR discount_product_id = '2883' OR discount_product_id LIKE '%,2884,%' OR discount_product_id = '2884' OR discount_product_id LIKE '%,2886,%' OR discount_product_id = '2886' OR discount_product_id LIKE '%,2887,%' OR discount_product_id = '2887' OR discount_product_id LIKE '%,2908,%' OR discount_product_id = '2908' OR discount_product_id LIKE '%,2907,%' OR discount_product_id = '2907' OR discount_product_id LIKE '%,2906,%' OR discount_product_id = '2906' OR discount_product_id LIKE '%,2905,%' OR discount_product_id = '2905' OR discount_product_id LIKE '%,2904,%' OR discount_product_id = '2904' OR discount_product_id LIKE '%,2903,%' OR discount_product_id = '2903' OR discount_product_id LIKE '%,2902,%' OR discount_product_id = '2902' OR discount_product_id LIKE '%,2901,%' OR discount_product_id = '2901' OR discount_product_id LIKE '%,2900,%' OR discount_product_id = '2900' OR discount_product_id LIKE '%,2899,%' OR discount_product_id = '2899' OR discount_product_id LIKE '%,2898,%' OR discount_product_id = '2898' OR discount_product_id LIKE '%,2897,%' OR discount_product_id = '2897' OR discount_product_id LIKE '%,2896,%' OR discount_product_id = '2896' OR discount_product_id LIKE '%,2878,%' OR discount_product_id = '2878' OR discount_product_id LIKE '%,2877,%' OR discount_product_id = '2877' OR discount_product_id LIKE '%,2876,%' OR discount_product_id = '2876' OR discount_product_id LIKE '%,2875,%' OR discount_product_id = '2875' OR discount_product_id LIKE '%,2909,%' OR discount_product_id = '2909' ) 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: 9.23 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 29.815 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: 22.90 ms Po ostatnim zapytaniu: 0.36 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 29.832 MB Zwróconych wierszy: 32
SELECT a.*
FROM jos_hikashop_price AS a
WHERE a.price_product_id IN (1066,1064,1067,1068,1065,1069,2879,2880,2881,2882,2883,2884,2886,2887,2908,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2896,2878,2877,2876,2875,2909)
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 (1066,1064,1067,1068,1065,1069,2879,2880,2881,2882,2883,2884,2886,2887,2908,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2896,2878,2877,2876,2875,2909) 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: 10.18 ms Po ostatnim zapytaniu: 0.71 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 29.908 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 <= 1582983544
AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1582983544)
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 <= 1582983544 AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1582983544) 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: 10.67 ms Po ostatnim zapytaniu: 0.34 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 29.934 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: 5.72 ms Po ostatnim zapytaniu: 2.68 ms Pamięć zapytania: 0.035 MB Pamięć przed zapytaniem: 30.055 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 (1066,1064,1067,1068,1065,1069,2879,2880,2881,2882,2883,2884,2886,2887,2908,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2896,2878,2877,2876,2875,2909)
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 (1066,1064,1067,1068,1065,1069,2879,2880,2881,2882,2883,2884,2886,2887,2908,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2896,2878,2877,2876,2875,2909) 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.84 ms Po ostatnim zapytaniu: 0.52 ms Pamięć zapytania: 0.035 MB Pamięć przed zapytaniem: 30.049 MB Zwróconych wierszy: 32
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 (1066,1064,1067,1068,1065,1069,2879,2880,2881,2882,2883,2884,2886,2887,2908,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2896,2878,2877,2876,2875,2909);
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 (1066,1064,1067,1068,1065,1069,2879,2880,2881,2882,2883,2884,2886,2887,2908,2907,2906,2905,2904,2903,2902,2901,2900,2899,2898,2897,2896,2878,2877,2876,2875,2909);
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: 4.81 ms Po ostatnim zapytaniu: 1.03 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 30.248 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 (317)
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 (317) 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: 3.55 ms Po ostatnim zapytaniu: 1.61 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 30.329 MB Zwróconych wierszy: 1
SELECT category_id
FROM jos_hikashop_product_category
WHERE product_id IN (1066)
ORDER BY ordering ASC
Polecenie EXPLAIN niemożliwe w zapytaniu: SELECT category_id FROM jos_hikashop_product_category WHERE product_id IN (1066) 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: 2.39 ms Po ostatnim zapytaniu: 0.21 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 30.353 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 (317)
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 (317) 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: 2.51 ms Po ostatnim zapytaniu: 0.48 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 30.398 MB Zwróconych wierszy: 0
