Wyposażenie domu

Cała Polska

Wyjątkowy prezent

Dostawa 6 dni w tygodniu

Strona główna

Wyposażenie domu

Schowaj

Cena minimalna

Cena maksymalna

Podaj zakres cenowy

Sortowanie

Designerski Zestaw 4 szt. Portugalia Ceramika LUX

1 750,00 zł

Zobacz

Designerski Zestaw Ekskluzywna Ceramika Portugalia

950,00 zł

Zobacz

Dywan Modern Marmur Jasny Szary Marble Carrara 200x300

690,00 zł

Zobacz

Najczęściej kupowane produkty

Gąbka morska - HONEYCOMB PREMIUM

Gąbki morskie są odnawialnym zasobem naturalnym ciepłych mórz i oceanów. Używane były już w czasach starożytnych, głównie ze względu na swoje wyjątkowe zdolności do wchłaniania płynów. Potrafią wchłonąć do 50 razy więcej, niż same ważą. Istnieją na ziemi już od pięciuset milionów lat i przez ten okres wytworzyły w sobie substancje biologiczne, które mają przeciwwirusowe i przeciwnowotworowe działanie. Zawierają ...

70,00 zł

Zobacz więcej

Gąbka Morska Silk do demakijażu i pielęgnacji twarzy

Gąbki Silk mają drobne pory a ich wyjątkowa, miękka powierzchnia sprawia, że są one idealne do makijażu oraz do demakijażu. Przeznaczone sa głównie do pielęgnacji twarzy. Gąbki Silk wyróżniają się tym, że jest najbardziej luksusowe i najdelikatniejsze ze wszystkich gąbek. Ten rodzaj gąbki można znaleźć na Morzu Egejskim i sporadycznie w innych częściach Morza Śródziemnego na głębokościach od 15 do 40 ...

12,00 zł

Zobacz więcej

Szczotka z masażerem

Masażer do ciała – drewno bukowe. Kołki / włosie. Kołki drewniane , włosie naturalne – szczecina dzika. Systematyczne stosowanie pomaga w walce z cellulitem, poprawia krążenie krwi i obniża napięcie mięśni. Szczotkowanie na sucho skóry pozwala zniwelowac takie dolegliwości jak wrastające włoski czy szorstkość a oprócz usunięcia martwego naskórka pozbywamy się w ten sposób również toksyn. Efekt wygładzenia skóry jest ...

15,00 zł

Zobacz więcej

Tropical Sponge

Gąbka Naturalna Morska typu GRASS. 3 rozmiary mała, średnia, duża. Gąbki morskie są odnawialnym zasobem naturalnym ciepłych mórz i oceanów. Używane były już w czasach starożytnych, głównie ze względu na swoje wyjątkowe zdolności do wchłaniania płynów. Potrafią wchłonąć do 50 razy więcej, niż same ważą. Istnieją na ziemi już od pięciuset milionów lat i przez ten okres wytworzyły w sobie ...

42,00 zł

Zobacz więcej

Gąbka naturalna morska DEKORACYJNA

220,00 zł

Zobacz więcej

Szczotka z jasnego drewna bukowego

Szczotka do włosów z jasnego drewna bukowego. Posiada drewniane igły z zaokrąglonymi końcówkami umieszczonymi na gumowej poduszce. Delikatnie masują skórę głowy poprawiając jej ukrwienie, nie szarpią i nie elektryzują włosów. Szczotkę dobrze trzyma się w dłoni, na rączce sznureczek do powieszenia. Ma niepowtarzalny, nowoczesny kształt. Wymiary (duża / prostokątny kształt): długość szczotki z rączką - 22 cm szerokość główki - 5 cm długośc ...

20,00 zł

Zobacz więcej

Informacje o plikach cookie

Ta strona używa plików Cookies. Dowiedz się więcej o celu ich używania i możliwości zmiany ustawień Cookies w przeglądarce. Czytaj więcej...

Konsola diagnostyczna Joomla!

Sesja

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701579303,
                "last": 1701579303,
                "now": 1701579303
            },
            "token": "eDbRVvgRqIScItp6X3ZV5QnbkJqDt3f2"
        },
        "registry": {
            "rs_hikashop_ajax": {
                "itemid": "994",
                "search": ""
            },
            "rs_opc_params": {
                "search_wordlimit": "3",
                "sort_name": [
                    "1"
                ],
                "sort_price": [
                    "1"
                ],
                "sort_create": "3",
                "rs_opc_cat_id": "101",
                "listowanie": "6",
                "menu-anchor_title": "",
                "menu-anchor_css": "",
                "menu_image": "",
                "menu_image_css": "",
                "menu_text": 1,
                "menu_show": 1,
                "page_title": "",
                "show_page_heading": "",
                "page_heading": "",
                "pageclass_sfx": "",
                "menu-meta_description": "",
                "menu-meta_keywords": "",
                "robots": "",
                "secure": 0,
                "menulayout": "{\"width\":600,\"menuItem\":1,\"menuAlign\":\"right\",\"layout\":[{\"type\":\"row\",\"attr\":[{\"type\":\"column\",\"colGrid\":12,\"menuParentId\":\"994\",\"moduleId\":\"\"}]}]}",
                "megamenu": "0",
                "showmenutitle": "1",
                "icon": "",
                "class": "",
                "enable_page_title": "0",
                "page_title_alt": "",
                "page_subtitle": "",
                "page_title_bg_color": "",
                "page_title_bg_image": ""
            },
            "rs_opc_cat_id": "101",
            "com_hikashop": {
                "user_id": 0,
                "zone_id": "170"
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "pl-PL"
        }
    }
}

Informacje o wydajności

Czas

Pamięć

Czas: 32.42 ms / 32.42 ms Pamięć: 0.699 MB / 1.07 MB Application: afterLoad

Czas: 263.82 ms / 296.24 ms Pamięć: 2.964 MB / 4.04 MB Application: afterInitialise

Czas: 27.43 ms / 323.67 ms Pamięć: 0.214 MB / 4.25 MB Application: Before Access::preloadComponents (all components)

Czas: 1.86 ms / 325.53 ms Pamięć: 0.068 MB / 4.32 MB Application: After Access::preloadComponents (all components)

Czas: 0.04 ms / 325.57 ms Pamięć: 0.000 MB / 4.32 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Czas: 1.61 ms / 327.17 ms Pamięć: 0.014 MB / 4.33 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Czas: 50.28 ms / 377.46 ms Pamięć: 0.426 MB / 4.76 MB Application: afterRoute

Czas: 1.17 ms / 378.63 ms Pamięć: 0.110 MB / 4.87 MB Application: beforeRenderComponent com_rs_hikashop_opc

Czas: 98.83 ms / 477.45 ms Pamięć: 1.541 MB / 6.41 MB Application: afterRenderComponent com_rs_hikashop_opc

Czas: 13.70 ms / 491.15 ms Pamięć: 0.214 MB / 6.62 MB Application: afterDispatch

Czas: 25.28 ms / 516.43 ms Pamięć: 0.428 MB / 7.05 MB Application: beforeRenderModule mod_custom (MENU - Produkty naturalne)

Czas: 70.51 ms / 586.95 ms Pamięć: 1.931 MB / 8.98 MB Application: afterRenderModule mod_custom (MENU - Produkty naturalne)

Czas: 9.64 ms / 596.59 ms Pamięć: 0.036 MB / 9.02 MB Application: beforeRenderModule mod_gototop (Go to TOP)

Czas: 0.33 ms / 596.92 ms Pamięć: 0.006 MB / 9.02 MB Application: afterRenderModule mod_gototop (Go to TOP)

Czas: 1.37 ms / 598.29 ms Pamięć: 0.029 MB / 9.05 MB Application: beforeRenderModule mod_hikashop (Najczęściej kupowane produkty)

Czas: 218.72 ms / 817.02 ms Pamięć: 1.727 MB / 10.78 MB Application: afterRenderModule mod_hikashop (Najczęściej kupowane produkty)

Czas: 0.67 ms / 817.68 ms Pamięć: 0.002 MB / 10.78 MB Application: beforeRenderModule mod_googlecrumbs (Generator BREADCRUMBS)

Czas: 3.94 ms / 821.62 ms Pamięć: 0.015 MB / 10.80 MB Application: afterRenderModule mod_googlecrumbs (Generator BREADCRUMBS)

Czas: 0.92 ms / 822.55 ms Pamięć: 0.000 MB / 10.79 MB Application: beforeRenderModule mod_helixmenu (Helix Menu SHOP)

Czas: 2.33 ms / 824.87 ms Pamięć: 0.065 MB / 10.86 MB Application: beforeRenderModule mod_custom (MENU - Produkty naturalne)

Czas: 0.66 ms / 825.53 ms Pamięć: 0.003 MB / 10.86 MB Application: afterRenderModule mod_custom (MENU - Produkty naturalne)

Czas: 0.45 ms / 825.98 ms Pamięć: 0.000 MB / 10.83 MB Application: afterRenderModule mod_helixmenu (Helix Menu SHOP)

Czas: 0.92 ms / 826.90 ms Pamięć: 0.012 MB / 10.85 MB Application: beforeRenderModule mod_rs_opc_search (Wyszukiwarka AJAX)

Czas: 1.56 ms / 828.46 ms Pamięć: 0.009 MB / 10.86 MB Application: afterRenderModule mod_rs_opc_search (Wyszukiwarka AJAX)

Czas: 30.58 ms / 859.04 ms Pamięć: 0.594 MB / 11.45 MB Application: afterRender

Ogółem zapytań do bazy danych: 101.94 ms

Użycie pamięci

Zapytania do bazy danych

91 zapytań zarejestrowanych 101.94 ms

10 znalezionych duplikatów!

2 duplikatów: #6 #7

2 duplikatów: #11 #13

2 duplikatów: #40 #82

2 duplikatów: #41 #83

2 duplikatów: #45 #90

Czas zapytania: 0.50 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 1.477 MB Zwróconych wierszy: 0

SELECT `data`

  FROM `oaiey_session`

  WHERE `session_id` = X'6635643037326234623432613761373438663666663063386536376332663465'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_session	const	PRIMARY	PRIMARY	194	const	1

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Identyczny z wywołaniem linii niżej.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:44

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.43 ms Po ostatnim zapytaniu: 2.40 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 1.555 MB Zwróconych wierszy: 0

SELECT `session_id`

  FROM `oaiey_session`

  WHERE `session_id` = X'6635643037326234623432613761373438663666663063386536376332663465' 
  LIMIT 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:44

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 28.55 ms Po ostatnim zapytaniu: 0.11 ms Pamięć zapytania: 0.004 MB Pamięć przed zapytaniem: 1.560 MB

INSERT INTO `oaiey_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6635643037326234623432613761373438663666663063386536376332663465', 1, 1701579303, 0, '', 0)

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `oaiey_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6635643037326234623432613761373438663666663063386536376332663465', 1, 1701579303, 0, '', 0)

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.02 ms
Update	0.14 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	28.05 ms
Closing tables	0.05 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:44

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.50 ms Po ostatnim zapytaniu: 19.16 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 1.744 MB Zwróconych wierszy: 6

SELECT id, rules

  FROM `oaiey_viewlevels`

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_viewlevels	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	6

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.55 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 1.757 MB Zwróconych wierszy: 2

SELECT b.id

  FROM oaiey_usergroups AS a

  LEFT JOIN oaiey_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	4	Using where; Using index

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.50 ms Po ostatnim zapytaniu: 32.41 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 2.522 MB Zwróconych wierszy: 1

Duplikaty zapytań: #7

SELECT template

  FROM oaiey_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3	Using where

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.38 ms Po ostatnim zapytaniu: 0.10 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 2.529 MB Zwróconych wierszy: 1

Duplikaty zapytań: #6

SELECT template

  FROM oaiey_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3	Using where

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.53 ms Po ostatnim zapytaniu: 7.37 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.643 MB Zwróconych wierszy: 2

SELECT extension, file, type

  FROM oaiey_rokcommon_configs

  ORDER BY priority

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_rokcommon_configs	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	2	Uruchomiono metodę filesort

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 1.18 ms Po ostatnim zapytaniu: 89.06 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 3.331 MB Zwróconych wierszy: 18

SHOW FULL COLUMNS 
  FROM `oaiey_extensions`

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: SHOW FULL COLUMNS FROM `oaiey_extensions`

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.28 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
Checking permissions	0.14 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.09 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.51 ms Po ostatnim zapytaniu: 1.10 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 3.450 MB Zwróconych wierszy: 1

SELECT `extension_id`

  FROM `oaiey_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.40 ms Po ostatnim zapytaniu: 0.10 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 3.457 MB Zwróconych wierszy: 1

Duplikaty zapytań: #13

SELECT *

  FROM oaiey_extensions

  WHERE `extension_id` = '10124'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_extensions	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.49 ms Po ostatnim zapytaniu: 0.12 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 3.461 MB Zwróconych wierszy: 1

SELECT `extension_id`

  FROM `oaiey_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.38 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 3.467 MB Zwróconych wierszy: 1

Duplikaty zapytań: #11

SELECT *

  FROM oaiey_extensions

  WHERE `extension_id` = '10124'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_extensions	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.62 ms Po ostatnim zapytaniu: 21.32 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 3.628 MB Zwróconych wierszy: 1

SELECT extension_id AS id, element AS "option", params, enabled

  FROM oaiey_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_advancedmodules'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:92
15	RokSprocket_Addon_AdvancedModuleManager->isComponentEnabled()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:17
14	RokSprocket_Addon_AdvancedModuleManager->__construct()	Identyczny z wywołaniem linii niżej.
13	ReflectionClass->newInstanceArgs()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:248
12	RokCommon_Service_Container_Builder->createService()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:86
11	RokCommon_Service_Container_Builder->getService()	JROOT/libraries/rokcommon/RokCommon/Service/ContainerImpl.php:377
10	RokCommon_Service_ContainerImpl->__get()	JROOT/plugins/system/roksprocket/roksprocket.php:225
9	plgSystemRokSprocket->loadAddons()	JROOT/plugins/system/roksprocket/roksprocket.php:91
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.41 ms Po ostatnim zapytaniu: 0.25 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 3.634 MB Zwróconych wierszy: 0

select email 
  from oaiey_users 
  where id=-1 
  LIMIT 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/bfstop/helpers/db.php:246
12	BFStopDBHelper->getUserEmailWhere()	JROOT/plugins/system/bfstop/helpers/db.php:253
11	BFStopDBHelper->getUserEmailByID()	JROOT/plugins/system/bfstop/helpers/notify.php:23
10	BFStopNotifier->__construct()	JROOT/plugins/system/bfstop/bfstop.php:197
9	plgSystembfstop->init()	JROOT/plugins/system/bfstop/bfstop.php:367
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.41 ms Po ostatnim zapytaniu: 0.13 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 3.641 MB Zwróconych wierszy: 0

SELECT id, ipaddress 
  from oaiey_bfstop_whitelist 
  WHERE (ipaddress='3.80.4.147' 
  AND LOCATE('/', ipaddress) = 0)

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_bfstop_whitelist	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	Using where

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:189
9	BFStopDBHelper->isIPWhiteListed()	JROOT/plugins/system/bfstop/bfstop.php:386
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.52 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.649 MB Zwróconych wierszy: 0

SELECT id, ipaddress 
  from oaiey_bfstop_whitelist 
  WHERE ((LOCATE('/', ipaddress) != 0 
  AND LOCATE('.', ipaddress) != 0 
  AND (INET_ATON('3.80.4.147') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_bfstop_whitelist	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	Using where

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:190
9	BFStopDBHelper->isIPWhiteListed()	JROOT/plugins/system/bfstop/bfstop.php:386
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.65 ms Po ostatnim zapytaniu: 0.10 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.656 MB Zwróconych wierszy: 0

SELECT id, ipaddress, crdate, duration 
  FROM oaiey_bfstop_bannedip b 
  WHERE (ipaddress='3.80.4.147' 
  AND LOCATE('/', ipaddress) = 0) 
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2023-12-03 05:55:03') 
  AND NOT EXISTS (SELECT 1 
  FROM oaiey_bfstop_unblock u 
  WHERE b.id = u.block_id)

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	b	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	19	Using where
2	MATERIALIZED	u	index	PRIMARY	PRIMARY	4	NULL	1	Using index

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.02 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:179
9	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:390
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.72 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.662 MB Zwróconych wierszy: 0

SELECT id, ipaddress, crdate, duration 
  FROM oaiey_bfstop_bannedip b 
  WHERE ((LOCATE('/', ipaddress) != 0 
  AND LOCATE('.', ipaddress) != 0 
  AND (INET_ATON('3.80.4.147') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)))) 
  AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2023-12-03 05:55:03') 
  AND NOT EXISTS (SELECT 1 
  FROM oaiey_bfstop_unblock u 
  WHERE b.id = u.block_id)

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	b	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	19	Using where
2	MATERIALIZED	u	index	PRIMARY	PRIMARY	4	NULL	1	Using index

Profile

Status	Duration
Starting	0.12 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.02 ms
Preparing	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Removing tmp table	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/bfstop/helpers/db.php:159
10	BFStopDBHelper->checkForEntries()	JROOT/plugins/system/bfstop/helpers/db.php:180
9	BFStopDBHelper->isIPBlocked()	JROOT/plugins/system/bfstop/bfstop.php:390
8	plgSystembfstop->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 1.48 ms Po ostatnim zapytaniu: 40.78 ms Pamięć zapytania: 0.031 MB Pamięć przed zapytaniem: 4.256 MB Zwróconych wierszy: 48

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `oaiey_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_acysms','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_bfstop','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_content','com_contenthistory','com_cpanel','com_djmediatools','com_eyesite','com_fields','com_finder','com_hikashop','com_installer','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_roksprocket','com_rs_hikashop_opc','com_search','com_seokomponent','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper')

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_assets	ALL	idx_asset_name	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	181	Using where

Profile

Status	Duration
Starting	0.17 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.11 ms
Optimizing	0.02 ms
Statistics	0.26 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.59 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
12	RegularLabs\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
11	RegularLabs\AdvancedModules\Helper->onAfterRoute()	Identyczny z wywołaniem linii niżej.
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:110
9	RegularLabs\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/src/Plugin.php:54
8	RegularLabs\AdvancedModules\Plugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.97 ms Po ostatnim zapytaniu: 4.85 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 4.353 MB

UPDATE `oaiey_extensions`

  SET `params` = '{\"mediaversion\":\"9c8aed33d6da8d122e3d1df45f60c551\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE `oaiey_extensions` SET `params` = '{\"mediaversion\":\"9c8aed33d6da8d122e3d1df45f60c551\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.11 ms
Updating	0.10 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.44 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:388
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.65 ms Po ostatnim zapytaniu: 23.65 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 4.587 MB Zwróconych wierszy: 1

SELECT `id`

  FROM `oaiey_users`

  WHERE `block` = 0 
  AND `activation` = 0 
  AND (`params` LIKE '%_key\":\"\"%')

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_users	ALL	idx_block	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	10	Using where

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/plugins/system/iplogin/helper.php:295
12	PlgSystemIPLoginHelper->getUserIds()	JROOT/plugins/system/iplogin/helper.php:249
11	PlgSystemIPLoginHelper->findUser()	JROOT/plugins/system/iplogin/helper.php:143
10	PlgSystemIPLoginHelper->logInUser()	JROOT/plugins/system/iplogin/helper.php:47
9	PlgSystemIPLoginHelper->logIn()	JROOT/plugins/system/iplogin/iplogin.php:36
8	PlgSystemIPLogin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 1.03 ms Po ostatnim zapytaniu: 2.07 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 4.597 MB Zwróconych wierszy: 16

SHOW FULL COLUMNS 
  FROM `oaiey_users`

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: SHOW FULL COLUMNS FROM `oaiey_users`

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.28 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
Checking permissions	0.14 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.09 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
18	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
17	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
16	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:880
15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
12	Joomla\CMS\Factory::getUser()	JROOT/plugins/system/iplogin/helper.php:258
11	PlgSystemIPLoginHelper->findUser()	JROOT/plugins/system/iplogin/helper.php:143
10	PlgSystemIPLoginHelper->logInUser()	JROOT/plugins/system/iplogin/helper.php:47
9	PlgSystemIPLoginHelper->logIn()	JROOT/plugins/system/iplogin/iplogin.php:36
8	PlgSystemIPLogin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.45 ms Po ostatnim zapytaniu: 0.18 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 4.636 MB Zwróconych wierszy: 1

SELECT *

  FROM `oaiey_users`

  WHERE `id` = 1112

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_users	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
12	Joomla\CMS\Factory::getUser()	JROOT/plugins/system/iplogin/helper.php:258
11	PlgSystemIPLoginHelper->findUser()	JROOT/plugins/system/iplogin/helper.php:143
10	PlgSystemIPLoginHelper->logInUser()	JROOT/plugins/system/iplogin/helper.php:47
9	PlgSystemIPLoginHelper->logIn()	JROOT/plugins/system/iplogin/iplogin.php:36
8	PlgSystemIPLogin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.72 ms Po ostatnim zapytaniu: 10.79 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 4.651 MB Zwróconych wierszy: 1

SELECT `g`.`id`,`g`.`title`

  FROM `oaiey_usergroups` AS g

  INNER JOIN `oaiey_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 1112

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	almallur_baza.m.group_id	1

Profile

Status	Duration
Starting	0.12 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
17	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:111
16	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
15	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
14	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
13	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
12	Joomla\CMS\Factory::getUser()	JROOT/plugins/system/iplogin/helper.php:258
11	PlgSystemIPLoginHelper->findUser()	JROOT/plugins/system/iplogin/helper.php:143
10	PlgSystemIPLoginHelper->logInUser()	JROOT/plugins/system/iplogin/helper.php:47
9	PlgSystemIPLoginHelper->logIn()	JROOT/plugins/system/iplogin/iplogin.php:36
8	PlgSystemIPLogin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 1.01 ms Po ostatnim zapytaniu: 51.88 ms Pamięć zapytania: 0.154 MB Pamięć przed zapytaniem: 5.655 MB Zwróconych wierszy: 486

SELECT * 
  FROM oaiey_hikashop_config

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_hikashop_config	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	486

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.58 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:16
9	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1094
8	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3804
7	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:21
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.56 ms Po ostatnim zapytaniu: 9.59 ms Pamięć zapytania: 0.031 MB Pamięć przed zapytaniem: 6.056 MB Zwróconych wierszy: 1

SELECT c.*

  FROM oaiey_hikashop_category c

  WHERE category_id LIKE 101

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	39	Using where

Profile

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_rs_hikashop_opc/models.php:120
11	Rs_hikashop_opcModelOpc_listings->getCategory()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:68
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 1.21 ms Po ostatnim zapytaniu: 0.21 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 6.068 MB Zwróconych wierszy: 0

SELECT c.category_id
			
  FROM oaiey_hikashop_category c 
			
  WHERE c.category_parent_id = 101 
  AND c.category_id != "" 
  AND   c.category_type = "product" 
		UNION ALL 
			SELECT c2.category_id
				
  FROM oaiey_hikashop_category c
				
  LEFT JOIN oaiey_hikashop_category AS c2 
  ON c.category_id = c2.category_parent_id 
  AND c2.category_type = "product" 
				
  WHERE c.category_parent_id = 101 
  AND c2.category_id != ""
		UNION ALL
			SELECT c3.category_id
				
  FROM oaiey_hikashop_category c 
				
  LEFT JOIN oaiey_hikashop_category AS c2 
  ON c.category_id = c2.category_parent_id 
  AND c2.category_type = "product" 
				
  LEFT JOIN oaiey_hikashop_category AS c3 
  ON c2.category_id = c3.category_parent_id 
  AND c3.category_type = "product"  
				
  WHERE c3.category_id <> "" 
  AND c.category_parent_id = 101

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	39	Using where
2	UNION	c2	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	39	Using where
2	UNION	c	eq_ref	PRIMARY	PRIMARY	4	almallur_baza.c2.category_parent_id	1	Using where
3	UNION	c3	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	39	Using where
3	UNION	c2	eq_ref	PRIMARY	PRIMARY	4	almallur_baza.c3.category_parent_id	1	Using where
3	UNION	c	eq_ref	PRIMARY	PRIMARY	4	almallur_baza.c2.category_parent_id	1	Using where

Profile

Status	Duration
Starting	0.11 ms
Checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.08 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.14 ms
Executing	0.01 ms
Sending data	0.16 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_rs_hikashop_opc/models.php:209
12	Rs_hikashop_opcModelOpc_listings->filtrCategory()	JROOT/components/com_rs_hikashop_opc/models.php:141
11	Rs_hikashop_opcModelOpc_listings->getItems()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:73
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 6.65 ms Po ostatnim zapytaniu: 0.17 ms Pamięć zapytania: 0.052 MB Pamięć przed zapytaniem: 6.147 MB Zwróconych wierszy: 6

SELECT DISTINCT p.*,variantsPrice.*,price_main.price_value as main_price

  FROM oaiey_hikashop_product p

  LEFT JOIN (select parentcategory.category_id , parentcategory.product_id 
  FROM oaiey_hikashop_product_category parentcategory 
  where parentcategory.category_id IN (101,101)) as parentcategory 
  on parentcategory.product_id = p.product_parent_id  

  LEFT JOIN (select productcategory.category_id  , productcategory.product_id 
  FROM oaiey_hikashop_product_category productcategory 
  where productcategory.category_id IN (101,101)) as productcategory 
  on productcategory.product_id = p.product_id 

  LEFT JOIN 
			(
			   select DISTINCT product.product_id as main_product_id, minprice.price as lowestVariantPrice , maxprice.price as highestVariantPrice 
			   
  FROM oaiey_hikashop_product product 
			   
  LEFT JOIN (
			   select 
			   variant.product_parent_id as product_id, 
			   min(hikashoppPrice.price_value) as price
			   
  from oaiey_hikashop_product as variant 
			   
  inner JOIN oaiey_hikashop_price AS hikashoppPrice
			   
  where hikashoppPrice.price_value IS NOT NULL 
			   
  AND hikashoppPrice.price_product_id = variant.product_id
			   
  AND variant.product_published = 1
			   
  group by variant.product_parent_id 
  order by hikashoppPrice.price_value
			   ) as minprice 
  ON minprice.product_id = product.product_id
			   
  LEFT JOIN (
			   select 
			   variant.product_parent_id as product_id, 
			   max(hikashoppPrice.price_value) as price
			   
  from oaiey_hikashop_product as variant 
			   
  inner JOIN oaiey_hikashop_price AS hikashoppPrice
			   
  where hikashoppPrice.price_value IS NOT NULL 
			   
  AND hikashoppPrice.price_product_id = variant.product_id
			   
  AND variant.product_published = 1
			   
  group by variant.product_parent_id 
  order by hikashoppPrice.price_value
			   ) as maxprice 
  ON maxprice.product_id = product.product_id
			   
  where  product.product_parent_id = 0 
  And minprice.price IS NOT NULL 
  And maxprice.price IS NOT NULL 
			   ) as variantsPrice 
  on variantsPrice.main_product_id = p.product_id
			   

  LEFT JOIN oaiey_hikashop_price AS price_main 
  ON p.product_id = price_main.price_product_id

  LEFT JOIN oaiey_hikashop_variant AS v 
  ON p.product_id = v.variant_product_id

  LEFT JOIN oaiey_hikashop_characteristic AS c 
  ON v.variant_characteristic_id=c.characteristic_id 

  LEFT JOIN (select variants.product_parent_id 
  FROM oaiey_hikashop_product variants ) as variants 
  on variants.product_parent_id = p.product_id

  LEFT JOIN oaiey_hikashop_product AS pm 
  ON p.product_parent_id = pm.product_id 

  WHERE (productcategory.product_id > 0 OR parentcategory.product_id > 0) 
  AND p.product_published = 1 
  AND (p.product_parent_id = 0) 
  AND p.product_id = p.product_id  
			
  AND ((price_main.price_value >= 0 
  AND price_main.price_value <= 50000 ) 
			OR (variantsPrice.lowestVariantPrice >= 0 
  AND variantsPrice.highestVariantPrice <= 50000))

  ORDER BY p.product_name ASC 
  LIMIT 6

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	p	ref	product_parent_id	product_parent_id	4	const	68	Using where; Using temporary; Uruchomiono metodę filesort
1	PRIMARY	parentcategory	ref	category_id,product_id	product_id	4	const	1	Using where
1	PRIMARY	productcategory	ref	category_id,product_id	product_id	4	almallur_baza.p.product_id	3	Using where
1	PRIMARY	<derived4>	ref	key0	key0	5	almallur_baza.p.product_id	10
1	PRIMARY	price_main	ref	price_product_id	price_product_id	4	almallur_baza.p.product_id	1	Using where
1	PRIMARY	v	ref	variant_product_id	variant_product_id	4	almallur_baza.p.product_id	1	Distinct
1	PRIMARY	variants	ref	product_parent_id	product_parent_id	4	almallur_baza.p.product_id	12	Using index; Distinct
4	DERIVED	<derived5>	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	82	Using where; Using temporary
4	DERIVED	product	eq_ref	PRIMARY,product_parent_id	PRIMARY	4	minprice.product_id	1	Using where
4	DERIVED	<derived6>	ref	key0	key0	5	minprice.product_id	8	Using where
6	DERIVED	hikashoppPrice	ALL	price_product_id	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	82	Using where; Using temporary; Uruchomiono metodę filesort
6	DERIVED	variant	eq_ref	PRIMARY,product_parent_id	PRIMARY	4	almallur_baza.hikashoppPrice.price_product_id	1	Using where
5	DERIVED	hikashoppPrice	ALL	price_product_id	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	82	Using where; Using temporary; Uruchomiono metodę filesort
5	DERIVED	variant	eq_ref	PRIMARY,product_parent_id	PRIMARY	4	almallur_baza.hikashoppPrice.price_product_id	1	Using where

Profile

Status	Duration
Starting	0.31 ms
Checking permissions	0.02 ms
Opening tables	0.12 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.03 ms
Init	0.28 ms
Optimizing	0.09 ms
Optimizing	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Statistics	0.29 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.09 ms
Creating tmp table	0.10 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.38 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.76 ms
Creating sort index	0.03 ms
Removing tmp table	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.71 ms
Creating sort index	0.03 ms
Removing tmp table	0.01 ms
Creating sort index	0.08 ms
Removing tmp table	0.01 ms
Creating sort index	1.88 ms
Creating sort index	0.26 ms
Removing tmp table	0.11 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_rs_hikashop_opc/models.php:690
12	Rs_hikashop_opcModelOpc_listings->loadObjectlist()	JROOT/components/com_rs_hikashop_opc/models.php:148
11	Rs_hikashop_opcModelOpc_listings->getItems()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:73
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 5.10 ms Po ostatnim zapytaniu: 0.28 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 6.218 MB Zwróconych wierszy: 16

SELECT p.product_id

  FROM oaiey_hikashop_product p

  LEFT JOIN (select parentcategory.category_id , parentcategory.product_id 
  FROM oaiey_hikashop_product_category parentcategory 
  where parentcategory.category_id IN (101,101)) as parentcategory 
  on parentcategory.product_id = p.product_parent_id  

  LEFT JOIN (select productcategory.category_id  , productcategory.product_id 
  FROM oaiey_hikashop_product_category productcategory 
  where productcategory.category_id IN (101,101)) as productcategory 
  on productcategory.product_id = p.product_id 

  LEFT JOIN 
			(
			   select DISTINCT product.product_id as main_product_id, minprice.price as lowestVariantPrice , maxprice.price as highestVariantPrice 
			   
  FROM oaiey_hikashop_product product 
			   
  LEFT JOIN (
			   select 
			   variant.product_parent_id as product_id, 
			   min(hikashoppPrice.price_value) as price
			   
  from oaiey_hikashop_product as variant 
			   
  inner JOIN oaiey_hikashop_price AS hikashoppPrice
			   
  where hikashoppPrice.price_value IS NOT NULL 
			   
  AND hikashoppPrice.price_product_id = variant.product_id
			   
  AND variant.product_published = 1
			   
  group by variant.product_parent_id 
  order by hikashoppPrice.price_value
			   ) as minprice 
  ON minprice.product_id = product.product_id
			   
  LEFT JOIN (
			   select 
			   variant.product_parent_id as product_id, 
			   max(hikashoppPrice.price_value) as price
			   
  from oaiey_hikashop_product as variant 
			   
  inner JOIN oaiey_hikashop_price AS hikashoppPrice
			   
  where hikashoppPrice.price_value IS NOT NULL 
			   
  AND hikashoppPrice.price_product_id = variant.product_id
			   
  AND variant.product_published = 1
			   
  group by variant.product_parent_id 
  order by hikashoppPrice.price_value
			   ) as maxprice 
  ON maxprice.product_id = product.product_id
			   
  where  product.product_parent_id = 0 
  And minprice.price IS NOT NULL 
  And maxprice.price IS NOT NULL 
			   ) as variantsPrice 
  on variantsPrice.main_product_id = p.product_id
			   

  LEFT JOIN oaiey_hikashop_price AS price_main 
  ON p.product_id = price_main.price_product_id

  LEFT JOIN oaiey_hikashop_variant AS v 
  ON p.product_id = v.variant_product_id

  LEFT JOIN oaiey_hikashop_characteristic AS c 
  ON v.variant_characteristic_id=c.characteristic_id 

  LEFT JOIN (select variants.product_parent_id 
  FROM oaiey_hikashop_product variants ) as variants 
  on variants.product_parent_id = p.product_id

  LEFT JOIN oaiey_hikashop_product AS pm 
  ON p.product_parent_id = pm.product_id 

  WHERE (productcategory.product_id > 0 OR parentcategory.product_id > 0) 
  AND p.product_published = 1 
  AND (p.product_parent_id = 0) 
  AND p.product_id = p.product_id  
			
  AND ((price_main.price_value >= 0 
  AND price_main.price_value <= 50000 ) 
			OR (variantsPrice.lowestVariantPrice >= 0 
  AND variantsPrice.highestVariantPrice <= 50000))

  ORDER BY p.product_name ASC

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	p	ref	product_parent_id	product_parent_id	4	const	68	Using where; Uruchomiono metodę filesort
1	PRIMARY	parentcategory	ref	category_id,product_id	product_id	4	const	1	Using where
1	PRIMARY	productcategory	ref	category_id,product_id	product_id	4	almallur_baza.p.product_id	3	Using where
1	PRIMARY	<derived4>	ref	key0	key0	5	almallur_baza.p.product_id	10
1	PRIMARY	price_main	ref	price_product_id	price_product_id	4	almallur_baza.p.product_id	1	Using where
1	PRIMARY	v	ref	variant_product_id	variant_product_id	4	almallur_baza.p.product_id	1
1	PRIMARY	variants	ref	product_parent_id	product_parent_id	4	almallur_baza.p.product_id	12	Using index
4	DERIVED	<derived5>	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	82	Using where; Using temporary
4	DERIVED	product	eq_ref	PRIMARY,product_parent_id	PRIMARY	4	minprice.product_id	1	Using where
4	DERIVED	<derived6>	ref	key0	key0	5	minprice.product_id	8	Using where
6	DERIVED	hikashoppPrice	ALL	price_product_id	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	82	Using where; Using temporary; Uruchomiono metodę filesort
6	DERIVED	variant	eq_ref	PRIMARY,product_parent_id	PRIMARY	4	almallur_baza.hikashoppPrice.price_product_id	1	Using where
5	DERIVED	hikashoppPrice	ALL	price_product_id	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	82	Using where; Using temporary; Uruchomiono metodę filesort
5	DERIVED	variant	eq_ref	PRIMARY,product_parent_id	PRIMARY	4	almallur_baza.hikashoppPrice.price_product_id	1	Using where

Profile

Status	Duration
Starting	0.29 ms
Checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.17 ms
Optimizing	0.07 ms
Optimizing	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Statistics	0.12 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.61 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.73 ms
Creating sort index	0.03 ms
Removing tmp table	0.01 ms
Creating sort index	0.04 ms
Executing	0.01 ms
Sending data	0.71 ms
Creating sort index	0.03 ms
Removing tmp table	0.01 ms
Creating sort index	0.09 ms
Removing tmp table	0.01 ms
Creating sort index	1.08 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.02 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_rs_hikashop_opc/models.php:690
12	Rs_hikashop_opcModelOpc_listings->loadObjectlist()	JROOT/components/com_rs_hikashop_opc/models.php:149
11	Rs_hikashop_opcModelOpc_listings->getItems()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:73
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 4.67 ms Po ostatnim zapytaniu: 0.26 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 6.234 MB Zwróconych wierszy: 1

SELECT COUNT(DISTINCT p.product_id) as count

  FROM oaiey_hikashop_product p

  LEFT JOIN (select parentcategory.category_id , parentcategory.product_id 
  FROM oaiey_hikashop_product_category parentcategory 
  where parentcategory.category_id IN (101,101)) as parentcategory 
  on parentcategory.product_id = p.product_parent_id  

  LEFT JOIN (select productcategory.category_id  , productcategory.product_id 
  FROM oaiey_hikashop_product_category productcategory 
  where productcategory.category_id IN (101,101)) as productcategory 
  on productcategory.product_id = p.product_id 

  LEFT JOIN 
			(
			   select DISTINCT product.product_id as main_product_id, minprice.price as lowestVariantPrice , maxprice.price as highestVariantPrice 
			   
  FROM oaiey_hikashop_product product 
			   
  LEFT JOIN (
			   select 
			   variant.product_parent_id as product_id, 
			   min(hikashoppPrice.price_value) as price
			   
  from oaiey_hikashop_product as variant 
			   
  inner JOIN oaiey_hikashop_price AS hikashoppPrice
			   
  where hikashoppPrice.price_value IS NOT NULL 
			   
  AND hikashoppPrice.price_product_id = variant.product_id
			   
  AND variant.product_published = 1
			   
  group by variant.product_parent_id 
  order by hikashoppPrice.price_value
			   ) as minprice 
  ON minprice.product_id = product.product_id
			   
  LEFT JOIN (
			   select 
			   variant.product_parent_id as product_id, 
			   max(hikashoppPrice.price_value) as price
			   
  from oaiey_hikashop_product as variant 
			   
  inner JOIN oaiey_hikashop_price AS hikashoppPrice
			   
  where hikashoppPrice.price_value IS NOT NULL 
			   
  AND hikashoppPrice.price_product_id = variant.product_id
			   
  AND variant.product_published = 1
			   
  group by variant.product_parent_id 
  order by hikashoppPrice.price_value
			   ) as maxprice 
  ON maxprice.product_id = product.product_id
			   
  where  product.product_parent_id = 0 
  And minprice.price IS NOT NULL 
  And maxprice.price IS NOT NULL 
			   ) as variantsPrice 
  on variantsPrice.main_product_id = p.product_id
			   

  LEFT JOIN oaiey_hikashop_price AS price_main 
  ON p.product_id = price_main.price_product_id

  LEFT JOIN oaiey_hikashop_variant AS v 
  ON p.product_id = v.variant_product_id

  LEFT JOIN oaiey_hikashop_characteristic AS c 
  ON v.variant_characteristic_id=c.characteristic_id 

  LEFT JOIN (select variants.product_parent_id 
  FROM oaiey_hikashop_product variants ) as variants 
  on variants.product_parent_id = p.product_id

  LEFT JOIN oaiey_hikashop_product AS pm 
  ON p.product_parent_id = pm.product_id 

  WHERE (productcategory.product_id > 0 OR parentcategory.product_id > 0) 
  AND p.product_published = 1 
  AND (p.product_parent_id = 0) 
  AND p.product_id = p.product_id  
			
  AND ((price_main.price_value >= 0 
  AND price_main.price_value <= 50000 ) 
			OR (variantsPrice.lowestVariantPrice >= 0 
  AND variantsPrice.highestVariantPrice <= 50000))

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	p	ref	product_parent_id	product_parent_id	4	const	68	Using where
1	PRIMARY	parentcategory	ref	category_id,product_id	product_id	4	const	1	Using where
1	PRIMARY	productcategory	ref	category_id,product_id	product_id	4	almallur_baza.p.product_id	3	Using where
1	PRIMARY	<derived4>	ref	key0	key0	5	almallur_baza.p.product_id	10
1	PRIMARY	price_main	ref	price_product_id	price_product_id	4	almallur_baza.p.product_id	1	Using where
1	PRIMARY	v	ref	variant_product_id	variant_product_id	4	almallur_baza.p.product_id	1
1	PRIMARY	variants	ref	product_parent_id	product_parent_id	4	almallur_baza.p.product_id	12	Using index
4	DERIVED	<derived5>	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	82	Using where; Using temporary
4	DERIVED	product	eq_ref	PRIMARY,product_parent_id	PRIMARY	4	minprice.product_id	1	Using where
4	DERIVED	<derived6>	ref	key0	key0	5	minprice.product_id	8	Using where
6	DERIVED	hikashoppPrice	ALL	price_product_id	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	82	Using where; Using temporary; Uruchomiono metodę filesort
6	DERIVED	variant	eq_ref	PRIMARY,product_parent_id	PRIMARY	4	almallur_baza.hikashoppPrice.price_product_id	1	Using where
5	DERIVED	hikashoppPrice	ALL	price_product_id	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	82	Using where; Using temporary; Uruchomiono metodę filesort
5	DERIVED	variant	eq_ref	PRIMARY,product_parent_id	PRIMARY	4	almallur_baza.hikashoppPrice.price_product_id	1	Using where

Profile

Status	Duration
Starting	0.28 ms
Checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
Init	0.17 ms
Optimizing	0.07 ms
Optimizing	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Statistics	0.08 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Statistics	0.12 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.10 ms
Executing	0.01 ms
Sending data	0.33 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.74 ms
Creating sort index	0.03 ms
Removing tmp table	0.01 ms
Creating sort index	0.03 ms
Executing	0.01 ms
Sending data	0.72 ms
Creating sort index	0.03 ms
Removing tmp table	0.02 ms
Creating sort index	0.08 ms
Removing tmp table	0.01 ms
Creating sort index	0.93 ms
End of update loop	0.02 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.02 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_rs_hikashop_opc/models.php:728
13	Rs_hikashop_opcModelOpc_listings->loadResult()	JROOT/components/com_rs_hikashop_opc/models.php:594
12	Rs_hikashop_opcModelOpc_listings->getPaggination()	JROOT/components/com_rs_hikashop_opc/models.php:150
11	Rs_hikashop_opcModelOpc_listings->getItems()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:73
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.49 ms Po ostatnim zapytaniu: 0.17 ms Pamięć zapytania: 0.043 MB Pamięć przed zapytaniem: 6.237 MB Zwróconych wierszy: 0

SELECT p.* 

  FROM oaiey_hikashop_product p

  WHERE p.product_id IN (0,0,0,0,0,0)

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	range	PRIMARY	PRIMARY	4	NULL	1	Using index condition

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_rs_hikashop_opc/models.php:690
12	Rs_hikashop_opcModelOpc_listings->loadObjectlist()	JROOT/components/com_rs_hikashop_opc/models.php:153
11	Rs_hikashop_opcModelOpc_listings->getItems()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:73
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.51 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 6.251 MB Zwróconych wierszy: 1

SELECT MAX(pc.price_value)

  FROM oaiey_hikashop_price pc 

  WHERE pc.price_product_id IN (144,105,157,158,121,159,141,137,163,145,132,161,160,162,166,119)

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	ALL	price_product_id	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	82	Using where

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_rs_hikashop_opc/models.php:183
12	Rs_hikashop_opcModelOpc_listings->getProductMaxPrice()	JROOT/components/com_rs_hikashop_opc/models.php:156
11	Rs_hikashop_opcModelOpc_listings->getItems()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:73
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.71 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 6.259 MB Zwróconych wierszy: 6

SELECT f.*

  FROM oaiey_hikashop_file f 

  WHERE  f.file_type = 'product' 
  AND f.file_ordering = 0 
  AND f.file_ref_id IN (144,105,157,158,121,159)

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ALL	file_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	343	Using where

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.20 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_rs_hikashop_opc/models.php:520
12	Rs_hikashop_opcModelOpc_listings->getProductImage()	JROOT/components/com_rs_hikashop_opc/models.php:160
11	Rs_hikashop_opcModelOpc_listings->getItems()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:73
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.41 ms Po ostatnim zapytaniu: 0.15 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 6.275 MB Zwróconych wierszy: 6

SELECT pc.*

  FROM oaiey_hikashop_price pc 

  WHERE pc.price_product_id IN (144,105,157,158,121,159)

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	range	price_product_id	price_product_id	4	NULL	6	Using index condition

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_rs_hikashop_opc/models.php:534
12	Rs_hikashop_opcModelOpc_listings->getProductPrice()	JROOT/components/com_rs_hikashop_opc/models.php:161
11	Rs_hikashop_opcModelOpc_listings->getItems()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:73
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.36 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 6.288 MB Zwróconych wierszy: 11

SELECT pc.category_id,pc.product_id,pc.ordering

  FROM oaiey_hikashop_product_category pc 

  WHERE pc.product_id IN (144,105,157,158,121,159)

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc	range	product_id	product_id	4	NULL	8	Using index condition

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_rs_hikashop_opc/models.php:501
12	Rs_hikashop_opcModelOpc_listings->getProductCategory()	JROOT/components/com_rs_hikashop_opc/models.php:162
11	Rs_hikashop_opcModelOpc_listings->getItems()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:73
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.36 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 6.302 MB Zwróconych wierszy: 0

SELECT hd.discount_product_id,hd.discount_flat_amount,hd.discount_percent_amount

  FROM oaiey_hikashop_discount hd 

  WHERE hd.discount_product_id LIKE '%144%' OR hd.discount_product_id LIKE '%105%' OR hd.discount_product_id LIKE '%157%' OR hd.discount_product_id LIKE '%158%' OR hd.discount_product_id LIKE '%121%' OR hd.discount_product_id LIKE '%159%'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_rs_hikashop_opc/models.php:372
13	Rs_hikashop_opcModelOpc_listings->productDiscount()	JROOT/components/com_rs_hikashop_opc/models.php:350
12	Rs_hikashop_opcModelOpc_listings->findDiscount()	JROOT/components/com_rs_hikashop_opc/models.php:163
11	Rs_hikashop_opcModelOpc_listings->getItems()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:73
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.29 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 6.309 MB Zwróconych wierszy: 0

SELECT hd.discount_category_id,hd.discount_flat_amount,hd.discount_percent_amount

  FROM oaiey_hikashop_discount hd 

  WHERE hd.discount_category_id LIKE '%101%'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_rs_hikashop_opc/models.php:410
13	Rs_hikashop_opcModelOpc_listings->categoryDiscount()	JROOT/components/com_rs_hikashop_opc/models.php:351
12	Rs_hikashop_opcModelOpc_listings->findDiscount()	JROOT/components/com_rs_hikashop_opc/models.php:163
11	Rs_hikashop_opcModelOpc_listings->getItems()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:73
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.51 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.031 MB Pamięć przed zapytaniem: 6.313 MB Zwróconych wierszy: 8

SELECT f.*

  FROM oaiey_hikashop_field f 

  WHERE f.field_table = 'product' 
  AND f.field_published = 1 
  AND f.field_frontcomp = 1

  ORDER BY f.field_ordering ASC

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	58	Using where; Uruchomiono metodę filesort

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_rs_hikashop_opc/models.php:653
11	Rs_hikashop_opcModelOpc_listings->getProductsFields()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:87
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.92 ms Po ostatnim zapytaniu: 1.52 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 6.396 MB Zwróconych wierszy: 1

Duplikaty zapytań: #82

SELECT * 
  FROM oaiey_extensions 
  WHERE name = 'com_rs_hikashop_opc'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_extensions	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	500	Using where

Profile

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.59 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/templates/rekinysukcesu-sklep/html/com_rs_hikashop_opc/default_single.php:8
15	include JROOT/templates/rekinysukcesu-sklep/html/com_rs_hikashop_opc/default_single.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/rekinysukcesu-sklep/html/com_rs_hikashop_opc/default.php:22
13	include JROOT/templates/rekinysukcesu-sklep/html/com_rs_hikashop_opc/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:138
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.52 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.051 MB Pamięć przed zapytaniem: 6.409 MB Zwróconych wierszy: 27

Duplikaty zapytań: #83

SELECT * 
  FROM oaiey_menu 
  WHERE component_id = '10569' 
  AND `published` = 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	oaiey_menu	ref	idx_componentid	idx_componentid	4	const	32	Using index condition

Profile

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.19 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/templates/rekinysukcesu-sklep/html/com_rs_hikashop_opc/default_single.php:11
15	include JROOT/templates/rekinysukcesu-sklep/html/com_rs_hikashop_opc/default_single.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/rekinysukcesu-sklep/html/com_rs_hikashop_opc/default.php:22
13	include JROOT/templates/rekinysukcesu-sklep/html/com_rs_hikashop_opc/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_rs_hikashop_opc/views/view.html.php:138
10	Rs_hikashop_opcViewOpc_listings->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_rs_hikashop_opc/controller.php:38
8	Rs_hikashop_opcController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php:24
6	require_once JROOT/components/com_rs_hikashop_opc/rs_hikashop_opc.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:341

[Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

Czas zapytania: 0.58 ms Po ostatnim zapytaniu: 16.09 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 6.540 MB Zwróconych wierszy: 1

Wyposażenie domu

Lustro do makijażu kryształ

Bambusowa mydelniczka

Designerski Zestaw 4 szt. Portugalia Ceramika LUX

Designerski Zestaw Ekskluzywna Ceramika Portugalia

Duży kufer kosmetyczny

Dywan Modern Marmur Jasny Szary Marble Carrara 200x300

Najczęściej kupowane produkty

Gąbka morska - HONEYCOMB PREMIUM

Gąbka Morska Silk do demakijażu i pielęgnacji twarzy

Szczotka z masażerem

Tropical Sponge

Gąbka naturalna morska DEKORACYJNA

Szczotka z jasnego drewna bukowego

Kategorie

Informacje

Szybki kontakt

Informacje o plikach cookie

Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Czas

Pamięć

Użycie pamięci

Zapytania do bazy danych

91 zapytań zarejestrowanych 101.94 ms

10 znalezionych duplikatów!

Panel klienta

Egipska gąbka LOOFAH

15 zł

Wyposażenie domu

Lustro do makijażu kryształ

Bambusowa mydelniczka

Designerski Zestaw 4 szt. Portugalia Ceramika LUX

Designerski Zestaw Ekskluzywna Ceramika Portugalia

Duży kufer kosmetyczny

Dywan Modern Marmur Jasny Szary Marble Carrara 200x300

Najczęściej kupowane produkty

Gąbka morska - HONEYCOMB PREMIUM

Gąbka Morska Silk do demakijażu i pielęgnacji twarzy

Szczotka z masażerem

Tropical Sponge

Gąbka naturalna morska DEKORACYJNA

Szczotka z jasnego drewna bukowego

Kategorie

Informacje

Szybki kontakt

Informacje o plikach cookie

Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Czas

Pamięć

Użycie pamięci

Zapytania do bazy danych

91 zapytań zarejestrowanych 101.94 ms

10 znalezionych duplikatów!