WR61 Programowanie w języku C++ - poziom rozszerzony

Forma: Zajęcia hybrydowe

Adresat

nauczyciele wszystkich typów szkół, którzy mieli styczność z programowaniem (np. uczestniczyli w cz. 1. programowania w C++)

Cel, po zajęciach uczestnik:

potrafi czytać schematy blokowe dla zadań matematycznych;
posługiwać się środowiskiem programistycznym DevC++ i skonfigurować je do pracy;
śledzić działanie programu i usuwać błędy (debuger);
stosować właściwie operacje wejścia i wyjścia z formatowaniem danych;
stosować właściwe typy danych dla danego problemu również strukturalne;
stosować operatory działań arytmetycznych i bitowych (np. przesunięcia bitowe, logikę bitową);
stosować właściwie operacje wejścia/wyjścia z formatowaniem danych;
wykorzystywać dane z plików tekstowych i zapisywać do pliku wyniki;
stosować mechanizmy iteracyjne i rekurencyjne w realizacjach algorytmów;
zakodować algorytm szyfrowania danych;
zakodować algorytm kompresji tekstu;
sortować dane z plików;
wykorzystać mechanizmy przekazywania danych do funkcji przez referencje, wartość i wskaźnik;
stosować zaawansowane struktury danych do budowy list i stosu;
wykorzystać typy map i vector;
realizować działania w NOP i poprawnie kodować je w C++, np. kalkulator z priorytetem działań, nawiasami, potęgowaniem;
samodzielnie analizować przykładowe programy w C++;
tworzyć samodzielnie programy realizujące określone algorytmy na podstawie analizy przykładów.

Treści

Środowisko uruchomieniowe Devc++ – struktura programu w C++, praca z debugerem
Identyfikatory i zmienne, zasięg zmiennych – zmienne lokalne i globalne
Operacje wejścia i wyjścia z formatowaniem danych
Typy danych, operatory w wyrażeniach, wyrażenia obliczeniowe i operacje bitowe
Operacje na plikach danych
Własne funkcje – przekazywanie zmiennych przez wartość, referencje i wskaźnik
Zagadnienia sortowania danych z plików
Algorytmy iteracyjne i rekurencyjne porównanie w zadaniach
Operacje bitowe, zmiana wartości bitu w bajcie, przesunięcia bitowe
Kompresja tekstu
Typy structure, set, map, vector
Listy i stos
Zaawansowany kalkulator jako praktyczne wykorzystanie stosu i ONP

Zajęcia prowadzone trybem mieszanym: 20 godziny zajęć stacjonarnych i 6 godzin zajęć zdalnych.

Liczba godzin: 26

Autor programu: Grzegorz Telman

Kierownik:
Tadeusz Nowik, e-mail: Ten adres pocztowy jest chroniony przed spamowaniem. Aby go zobaczyć, konieczne jest włączenie w przeglądarce obsługi JavaScript., tel.: 618 584 745, tel. kom.: 508 381 753

Data rozpoczęcia	Data zakończenia	Grupa, termin	Rejestracja
10-10-2010	10-10-2010	Grupa rezerwowa	Zapisy na to wydarzenie są już niemożliwe.
30-06-2021 10:00	30-06-2021 12:00	Grupa 1. 30.06.2021, godz. 10:00-12:00	Zapisy na to wydarzenie są już niemożliwe.
29-07-2021 11:00	29-07-2021 17:00	Grupa 2. 29.07.2021, godz. 11:00-17:00	Zapisy na to wydarzenie są już niemożliwe.

Wstecz

Nasi partnerzy

Konsola diagnostyczna Joomla!

Sesja

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1733049443,
                "last": 1733049443,
                "now": 1733049443
            },
            "token": "ccSoUDfG5NVcgJQFS10wRiyYBMOFUQ6w"
        },
        "registry": {},
        "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
        },
        "eb_device_type": "desktop"
    }
}

Informacje o wydajności

Czas

Pamięć

Czas: 2.57 ms / 2.57 ms Pamięć: 0.505 MB / 0.88 MB Application: afterLoad

Czas: 59.57 ms / 62.14 ms Pamięć: 4.352 MB / 5.23 MB Application: afterInitialise

Czas: 6.46 ms / 68.60 ms Pamięć: 0.757 MB / 5.99 MB Application: Before Access::preloadComponents (all components)

Czas: 1.30 ms / 69.91 ms Pamięć: 0.074 MB / 6.06 MB Application: After Access::preloadComponents (all components)

Czas: 0.02 ms / 69.92 ms Pamięć: -0.002 MB / 6.06 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Czas: 0.21 ms / 70.14 ms Pamięć: 0.009 MB / 6.07 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Czas: 5.18 ms / 75.32 ms Pamięć: 0.350 MB / 6.42 MB Application: afterRoute

Czas: 0.09 ms / 75.41 ms Pamięć: 0.003 MB / 6.42 MB Application: beforeRenderComponent com_eventbooking

Czas: 38.64 ms / 114.04 ms Pamięć: 1.312 MB / 7.74 MB Application: Before Access::getAssetRules (id:350 name:com_eventbooking)

Czas: 0.06 ms / 114.10 ms Pamięć: 0.009 MB / 7.75 MB Application: After Access::getAssetRules (id:350 name:com_eventbooking)

Czas: 5.91 ms / 120.01 ms Pamięć: 0.125 MB / 7.87 MB Application: afterRenderComponent com_eventbooking

Czas: 2.34 ms / 122.35 ms Pamięć: 0.153 MB / 8.02 MB Application: afterDispatch

Czas: 20.12 ms / 142.47 ms Pamięć: 0.737 MB / 8.76 MB Application: beforeRenderModule mod_eb_events (Nadchodzące szkolenia)

Czas: 12.75 ms / 155.22 ms Pamięć: 0.124 MB / 8.88 MB Application: afterRenderModule mod_eb_events (Nadchodzące szkolenia)

Czas: 3.91 ms / 159.13 ms Pamięć: 0.300 MB / 9.18 MB Application: beforeRenderModule mod_customcss (Custom CSS (spis kategorii szkoleń))

Czas: 0.11 ms / 159.24 ms Pamięć: 0.011 MB / 9.19 MB Application: afterRenderModule mod_customcss (Custom CSS (spis kategorii szkoleń))

Czas: 0.02 ms / 159.25 ms Pamięć: -0.008 MB / 9.19 MB Application: beforeRenderModule mod_customcss (Custom CSS (spis szkoleń))

Czas: 0.05 ms / 159.30 ms Pamięć: 0.005 MB / 9.19 MB Application: afterRenderModule mod_customcss (Custom CSS (spis szkoleń))

Czas: 0.23 ms / 159.53 ms Pamięć: 0.022 MB / 9.21 MB Application: beforeRenderModule mod_customcss (Custom CSS)

Czas: 0.18 ms / 159.71 ms Pamięć: 0.042 MB / 9.26 MB Application: afterRenderModule mod_customcss (Custom CSS)

Czas: 0.04 ms / 159.75 ms Pamięć: -0.017 MB / 9.24 MB Application: beforeRenderModule mod_customcss (Custom CSS (wcag))

Czas: 0.06 ms / 159.81 ms Pamięć: 0.011 MB / 9.25 MB Application: afterRenderModule mod_customcss (Custom CSS (wcag))

Czas: 0.25 ms / 160.06 ms Pamięć: 0.023 MB / 9.27 MB Application: beforeRenderModule mod_login (Logowanie góra)

Czas: 1.51 ms / 161.57 ms Pamięć: 0.045 MB / 9.32 MB Application: afterRenderModule mod_login (Logowanie góra)

Czas: 9.96 ms / 171.53 ms Pamięć: 0.253 MB / 9.57 MB Application: afterRender

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

Użycie pamięci

Zapytania do bazy danych

55 zapytań zarejestrowanych 64.19 ms

13 znalezionych duplikatów!

2 duplikatów: #8 #9

2 duplikatów: #14 #16

3 duplikatów: #19 #25 #54

2 duplikatów: #22 #23

2 duplikatów: #33 #34

2 duplikatów: #38 #40

Czas zapytania: 0.66 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 1.245 MB Zwróconych wierszy: 0

SELECT `data`

  FROM `kgpue_session`

  WHERE `session_id` = X'3562623935653766393336346136626538343837393064366463373365373732'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	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:804
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:364
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Czas zapytania: 0.50 ms Po ostatnim zapytaniu: 0.28 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 1.261 MB Zwróconych wierszy: 0

SELECT `session_id`

  FROM `kgpue_session`

  WHERE `session_id` = X'3562623935653766393336346136626538343837393064366463373365373732' 
  LIMIT 1

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:806
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:364
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[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.06 ms Pamięć zapytania: 0.004 MB Pamięć przed zapytaniem: 1.266 MB

INSERT INTO `kgpue_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3562623935653766393336346136626538343837393064366463373365373732', 1, 1733049443, 0, '', 0)

Objaśnienie

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:806
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:364
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Czas zapytania: 0.57 ms Po ostatnim zapytaniu: 1.14 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 1.426 MB Zwróconych wierszy: 8

SELECT id, rules

  FROM `kgpue_viewlevels`

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_viewlevels	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	8	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.61 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 1.439 MB Zwróconych wierszy: 2

SELECT b.id

  FROM kgpue_usergroups AS a

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

  WHERE a.id = 9

Objaśnienie

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.85 ms Po ostatnim zapytaniu: 4.59 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.007 MB Zwróconych wierszy: 1

SELECT `value`

  FROM `kgpue_admintools_storage`

  WHERE `key` = 'cparams'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_admintools_storage	NULL	const	PRIMARY	PRIMARY	402	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	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/administrator/components/com_admintools/Helper/Storage.php:122
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__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:645
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.75 ms Po ostatnim zapytaniu: 0.19 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 2.017 MB Zwróconych wierszy: 0

SELECT *

  FROM `kgpue_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Objaśnienie

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__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:645
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.63 ms Po ostatnim zapytaniu: 8.25 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.936 MB Zwróconych wierszy: 1

Duplikaty zapytań: #9

SELECT template

  FROM kgpue_template_styles as s

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

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_client_id,idx_client_id_home	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	6	16.67	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	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:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
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:645
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.03 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.944 MB Zwróconych wierszy: 1

Duplikaty zapytań: #8

SELECT template

  FROM kgpue_template_styles as s

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

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_client_id,idx_client_id_home	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	6	16.67	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	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:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
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:645
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.76 ms Po ostatnim zapytaniu: 0.80 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 3.108 MB Zwróconych wierszy: 2

SELECT extension, file, type

  FROM kgpue_rokcommon_configs

  ORDER BY priority

Objaśnienie

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	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:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
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:645
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.73 ms Po ostatnim zapytaniu: 9.22 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.624 MB Zwróconych wierszy: 0

SELECT `source`,`keepurlparams`

  FROM `kgpue_admintools_redirects`

  WHERE ((`dest` = 'component/eventbooking/zajecia-hybrydowe/wr61-1') OR (`dest` = 'component/eventbooking/zajecia-hybrydowe/wr61-1') OR ('component/eventbooking/zajecia-hybrydowe/wr61-1' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Objaśnienie

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->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:646
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.84 ms Po ostatnim zapytaniu: 2.54 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 4.775 MB Zwróconych wierszy: 18

SHOW FULL COLUMNS 
  FROM `kgpue_extensions`

Objaśnienie

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

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.10 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.01 ms
Opening tables	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	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:448
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:646
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.60 ms Po ostatnim zapytaniu: 0.22 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.804 MB Zwróconych wierszy: 1

SELECT `extension_id`

  FROM `kgpue_extensions`

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

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	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:646
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.05 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.811 MB Zwróconych wierszy: 1

Duplikaty zapytań: #16

SELECT *

  FROM kgpue_extensions

  WHERE `extension_id` = '10125'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	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:646
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.05 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.815 MB Zwróconych wierszy: 1

SELECT `extension_id`

  FROM `kgpue_extensions`

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

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	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:646
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.03 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.821 MB Zwróconych wierszy: 1

Duplikaty zapytań: #14

SELECT *

  FROM kgpue_extensions

  WHERE `extension_id` = '10125'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 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:646
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.57 ms Po ostatnim zapytaniu: 5.80 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 4.975 MB Zwróconych wierszy: 1

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

  FROM kgpue_extensions

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

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	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:646
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.58 ms Po ostatnim zapytaniu: 1.71 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 5.128 MB Zwróconych wierszy: 27

SELECT *

  FROM kgpue_rsform_config

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_rsform_config	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	27	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	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/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
8	plgSystemRsformdeletesubmissions->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:646
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.08 ms Po ostatnim zapytaniu: 0.96 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 5.217 MB Zwróconych wierszy: 224

Duplikaty zapytań: #25 #54

SHOW TABLES

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: SHOW TABLES

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
checking permissions	0.47 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	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/joomla/database/driver/mysqli.php:505
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:78
8	plgSystemjdownloads->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:646
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.62 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 5.247 MB Zwróconych wierszy: 0

SELECT file_id 
  from kgpue_jdownloads_files 
  WHERE published = 1 
  AND use_timeframe = 1 
  AND publish_to != '0000-00-00 00:00:00' 
  AND publish_to <= '2024-12-01 11:37:23'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_jdownloads_files	NULL	ref	idx_published	idx_published	1	const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:106
8	plgSystemjdownloads->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:646
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.01 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 5.251 MB Zwróconych wierszy: 0

SELECT file_id 
  from kgpue_jdownloads_files 
  WHERE published = 0 
  AND use_timeframe = 1 
  AND publish_from != '0000-00-00 00:00:00' 
  AND publish_from <= '2024-12-01 11:37:23'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_jdownloads_files	NULL	ref	idx_published	idx_published	1	const	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:114
8	plgSystemjdownloads->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:646
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.61 ms Po ostatnim zapytaniu: 5.10 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 5.973 MB Zwróconych wierszy: 1

Duplikaty zapytań: #23

SELECT `query`

  FROM kgpue_eb_urls

  WHERE md5_key = 'f3461499c0da2cb3045dbb167376e7b7'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_eb_urls	NULL	ref	idx_md5_key	idx_md5_key	99	const	1	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	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/components/com_eventbooking/router.php:441
9	EventbookingRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1120
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.18 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 5.980 MB Zwróconych wierszy: 1

Duplikaty zapytań: #22

SELECT `query`

  FROM kgpue_eb_urls

  WHERE md5_key = 'f3461499c0da2cb3045dbb167376e7b7'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_eb_urls	NULL	ref	idx_md5_key	idx_md5_key	99	const	1	100.00	NULL

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:441
17	EventbookingRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
16	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
15	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
14	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
13	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/joomlatools/component/koowa/event/subscriber/application.php:63
12	ComKoowaEventSubscriberApplication->onAfterApplicationRoute()	JROOT/libraries/joomlatools/library/event/publisher/abstract.php:128
11	KEventPublisherAbstract->publishEvent()	JROOT/libraries/joomlatools/component/koowa/event/publisher/publisher.php:43
10	ComKoowaEventPublisher->publishEvent()	JROOT/plugins/system/joomlatools/joomlatools.php:394
9	PlgSystemJoomlatools->_proxyEvent()	JROOT/plugins/system/joomlatools/joomlatools.php:229
8	PlgSystemJoomlatools->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:1168
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.17 ms Po ostatnim zapytaniu: 0.31 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 5.995 MB Zwróconych wierszy: 54

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

  FROM `kgpue_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_attlist','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_eventbooking','com_fields','com_finder','com_govarticle','com_igallery','com_installer','com_jce','com_jdownloads','com_joomlaupdate','com_jux_timetable','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_profiles','com_pwtacl','com_redirect','com_roksprocket','com_rsform','com_search','com_smartslider3','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Objaśnienie

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.44 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	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/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:97
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/Plugin.php:94
8	RegularLabs\Library\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:1168
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.05 ms Po ostatnim zapytaniu: 0.55 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 6.148 MB Zwróconych wierszy: 224

Duplikaty zapytań: #19 #54

SHOW TABLES

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: SHOW TABLES

Profile

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
checking permissions	0.47 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	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/joomla/database/driver/mysqli.php:505
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:353
8	plgSystemjdownloads->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:1168
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.59 ms Po ostatnim zapytaniu: 0.27 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 6.158 MB

UPDATE `kgpue_extensions`

  SET `params` = '{\"mediaversion\":\"316bc4930596fff1353afef751956d35\"}'

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

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	kgpue_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.05 ms
updating	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cachecleaner/cachecleaner.php:60
9	PlgSystemCacheCleaner->getHelper()	JROOT/plugins/system/cachecleaner/cachecleaner.php:30
8	PlgSystemCacheCleaner->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:1168
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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.34 ms Po ostatnim zapytaniu: 4.49 ms Pamięć zapytania: 0.057 MB Pamięć przed zapytaniem: 6.845 MB Zwróconych wierszy: 355

SELECT `config_key`,`config_value`

  FROM kgpue_eb_configs

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_eb_configs	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	355	100.00	NULL

Profile

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.00 ms
executing	0.00 ms
Sending data	0.35 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	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_eventbooking/libraries/rad/config/config.php:39
9	RADConfig->__construct()	JROOT/components/com_eventbooking/helper/helper.php:368
8	EventbookingHelper::getConfig()	JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php:81
7	require_once JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php	JROOT/components/com_eventbooking/eventbooking.php:14
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.90 ms Po ostatnim zapytaniu: 2.24 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 7.012 MB Zwróconych wierszy: 1

SELECT *

  FROM kgpue_eb_themes

  WHERE published = 1

Objaśnienie

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_eventbooking/helper/helper.php:517
10	EventbookingHelper::getDefaultTheme()	JROOT/components/com_eventbooking/controller/display.php:49
9	EventbookingController->loadAssets()	JROOT/components/com_eventbooking/controller/controller.php:21
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.98 ms Po ostatnim zapytaniu: 7.08 ms Pamięć zapytania: 0.072 MB Pamięć przed zapytaniem: 7.078 MB Zwróconych wierszy: 1

SELECT a.*,DATEDIFF(event_date, '2024-12-01 10:37:23') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.late_fee_date, '2024-12-01 10:37:23') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, a.event_date, '2024-12-01 10:37:23') AS event_start_minutes,TIMESTAMPDIFF(SECOND, registration_start_date, '2024-12-01 10:37:23') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2024-12-01 10:37:23') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2024-12-01 10:37:23', early_bird_discount_date) AS date_diff,IFNULL(SUM(b.number_registrants), 0) AS total_registrants,`c`.`name` AS `location_name`,`c`.`alias` AS `location_alias`,c.address AS location_address

  FROM kgpue_eb_events AS a

  LEFT JOIN kgpue_eb_registrants AS b 
  ON (a.id = b.event_id 
  AND b.group_id=0 
  AND (b.published = 1 OR (b.payment_method LIKE "os_offline%" 
  AND b.published NOT IN (2,3))))

  LEFT JOIN kgpue_eb_locations AS c 
  ON a.location_id = c.id 

  WHERE a.id = 3183

  GROUP BY a.id

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	ref	idx_event_id,idx_published	idx_event_id	5	const	1	100.00	Using where
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.19 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.27 ms
preparing	0.11 ms
executing	0.00 ms
Sending data	0.29 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.03 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_eventbooking/model/event.php:68
11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:90
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.26 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 7.169 MB Zwróconych wierszy: 0

SELECT *

  FROM kgpue_eb_locations

Objaśnienie

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	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_eventbooking/helper/data.php:565
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:349
12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:78
11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:90
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.06 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 7.178 MB Zwróconych wierszy: 1

SELECT a.*, b.event_id

  FROM kgpue_eb_categories AS a

  INNER JOIN kgpue_eb_event_categories AS b 
  ON a.id = b.category_id

  WHERE b.event_id IN (3183)

  ORDER BY b.id

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b	NULL	ref	idx_event_id,idx_category_id	idx_event_id	5	const	1	100.00	Using index condition; Using where
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	01683034_0000020.b.category_id	1	100.00	NULL

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.02 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_eventbooking/helper/data.php:592
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:349
12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:78
11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:90
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.26 ms Po ostatnim zapytaniu: 0.29 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 7.206 MB Zwróconych wierszy: 0

SELECT id, link 
  from kgpue_menu 
  WHERE link LIKE 'index.php?option=com_jdownloads&view=category%' 
  AND published = 1

Objaśnienie

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.47 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
21	JDatabaseDriver->loadAssocList()	JROOT/plugins/content/jdownloads/jdownloads.php:46
20	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
19	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
18	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
17	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:624
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:349
12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:78
11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:90
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.39 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 7.223 MB Zwróconych wierszy: 1

Duplikaty zapytań: #34

SELECT id 
  FROM kgpue_menu 
  WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories'  ) 
  AND published = 1 
  AND access IN (1,1,5)

Objaśnienie

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.63 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:221
21	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:55
20	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
19	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
18	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
17	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:624
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:349
12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:78
11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:90
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.31 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 7.236 MB Zwróconych wierszy: 1

Duplikaty zapytań: #33

SELECT id 
  FROM kgpue_menu 
  WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories'  ) 
  AND published = 1 
  AND access IN (1,1,5)

Objaśnienie

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.62 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:252
21	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:55
20	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
19	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
18	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
17	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:624
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:349
12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:78
11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:90
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.19 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 7.247 MB Zwróconych wierszy: 0

SELECT id 
  FROM kgpue_menu 
  WHERE link = 'index.php?option=com_jdownloads&view=search' 
  AND published = 1 
  AND access IN (1,1,5)

Objaśnienie

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.52 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:260
21	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:55
20	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
19	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
18	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
17	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:624
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:349
12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:78
11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:90
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.15 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 7.257 MB Zwróconych wierszy: 0

SELECT id 
  FROM kgpue_menu 
  WHERE link = 'index.php?option=com_jdownloads&view=form&layout=edit' 
  AND published = 1 
  AND access IN (1,1,5)

Objaśnienie

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.49 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:265
21	JDHelper::getMenuItemids()	JROOT/plugins/content/jdownloads/jdownloads.php:55
20	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
19	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
18	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
17	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:624
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:349
12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:78
11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:90
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.12 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 7.268 MB Zwróconych wierszy: 0

SELECT id, link 
  from kgpue_menu 
  WHERE link LIKE 'index.php?option=com_jdownloads&view=category&catid%' 
  AND published = 1 
  AND access IN (1,1,5)

Objaśnienie

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.44 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
22	JDatabaseDriver->loadAssocList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:303
21	JDHelper::getAllJDCategoryMenuIDs()	JROOT/plugins/content/jdownloads/jdownloads.php:59
20	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
19	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
18	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
17	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:624
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:349
12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:78
11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:90
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.97 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.093 MB Pamięć przed zapytaniem: 7.279 MB Zwróconych wierszy: 263

Duplikaty zapytań: #40

SELECT setting_name, setting_value 
  FROM kgpue_jdownloads_config

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_jdownloads_config	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	263	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.88 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:37
22	JDHelper::buildjlistConfig()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:3608
21	JDHelper::getDateFormat()	JROOT/plugins/content/jdownloads/jdownloads.php:66
20	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
19	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
18	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
17	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:624
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:349
12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:78
11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:90
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.24 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 7.352 MB Zwróconych wierszy: 1

SELECT id 
  from kgpue_menu 
  WHERE link = 'index.php?option=com_jdownloads&view=categories' 
  and published = 1

Objaśnienie

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.49 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/plugins/content/jdownloads/jdownloads.php:1886
21	jd_CalcItemid()	JROOT/plugins/content/jdownloads/jdownloads.php:69
20	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
19	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
18	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
17	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:624
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:349
12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:78
11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:90
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.93 ms Po ostatnim zapytaniu: 0.12 ms Pamięć zapytania: 0.093 MB Pamięć przed zapytaniem: 7.363 MB Zwróconych wierszy: 263

Duplikaty zapytań: #38

SELECT setting_name, setting_value 
  FROM kgpue_jdownloads_config

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_jdownloads_config	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	263	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.86 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	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/plugins/content/jdownloads/jdownloads.php:203
21	buildjlistConfigM()	JROOT/plugins/content/jdownloads/jdownloads.php:71
20	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
19	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
18	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
17	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:624
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:349
12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:78
11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:90
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.00 ms Po ostatnim zapytaniu: 4.17 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 7.685 MB

UPDATE kgpue_eb_events

  SET hits = hits + 1

  WHERE id = 3183

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	kgpue_eb_events	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.09 ms
updating	0.21 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/components/com_eventbooking/model/event.php:164
11	EventbookingModelEvent->updateHits()	JROOT/components/com_eventbooking/view/event/html.php:119
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.85 ms Po ostatnim zapytaniu: 0.21 ms Pamięć zapytania: 0.040 MB Pamięć przed zapytaniem: 7.705 MB Zwróconych wierszy: 3

SELECT tbl.id,tbl.main_category_id,tbl.location_id,tbl.title,tbl.event_type,tbl.event_date,tbl.event_end_date,tbl.short_description,tbl.description,tbl.access,tbl.registration_access,tbl.individual_price,tbl.price_text,tbl.event_capacity,tbl.waiting_list_capacity,tbl.created_by,tbl.cut_off_date,tbl.registration_type,tbl.min_group_number,tbl.discount_type,tbl.discount,tbl.early_bird_discount_type,tbl.early_bird_discount_date,tbl.early_bird_discount_amount,tbl.enable_cancel_registration,tbl.cancel_before_date,tbl.params,tbl.published,tbl.custom_fields,tbl.discount_groups,tbl.discount_amounts,tbl.registration_start_date,tbl.registration_handle_url,tbl.fixed_group_price,tbl.attachment,tbl.late_fee_type,tbl.late_fee_date,tbl.late_fee_amount,tbl.event_password,tbl.currency_code,tbl.currency_symbol,tbl.thumb,tbl.image,tbl.language,tbl.alias,tbl.tax_rate,tbl.featured,tbl.has_multiple_ticket_types,tbl.activate_waiting_list,tbl.collect_member_information,tbl.prevent_duplicate_registration,TIMESTAMPDIFF(MINUTE, '2024-12-01 10:37:23', tbl.early_bird_discount_date) AS date_diff,TIMESTAMPDIFF(MINUTE, tbl.late_fee_date, '2024-12-01 10:37:23') AS late_fee_date_diff,DATEDIFF(tbl.event_date, '2024-12-01 10:37:23') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2024-12-01 10:37:23') AS event_start_minutes,TIMESTAMPDIFF(SECOND, tbl.registration_start_date, '2024-12-01 10:37:23') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2024-12-01 10:37:23') AS cut_off_minutes,c.name AS location_name, c.address AS location_address,IFNULL(SUM(b.number_registrants), 0) AS total_registrants

  FROM kgpue_eb_events AS tbl

  LEFT JOIN kgpue_eb_registrants AS b 
  ON (tbl.id = b.event_id 
  AND b.group_id=0 
  AND (b.published = 1 OR (b.payment_method LIKE "os_offline%" 
  AND b.published NOT IN (2,3))))

  LEFT JOIN kgpue_eb_locations AS c 
  ON tbl.location_id = c.id 

  WHERE tbl.published = 1 
  AND tbl.hidden = 0 
  AND (tbl.id = 3183 OR tbl.parent_id=3183) 
  AND tbl.access IN (1,1,5)

  GROUP BY tbl.id

  ORDER BY tbl.event_date 
  LIMIT 30

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tbl	NULL	index_merge	PRIMARY,idx_category_id,idx_location_id,idx_parent_id,idx_access,idx_published,idx_event_date,idx_event_end_date,idx_alias	PRIMARY,idx_parent_id	4,4	NULL	3	10.00	Using union(PRIMARY,idx_parent_id); Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	b	NULL	ref	idx_event_id,idx_published	idx_event_id	5	01683034_0000020.tbl.id	1	100.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	01683034_0000020.tbl.location_id	1	100.00	NULL

Profile

Status	Duration
starting	0.30 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.20 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.20 ms
preparing	0.04 ms
Creating tmp table	0.12 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.84 ms
Creating sort index	0.31 ms
end	0.01 ms
query end	0.03 ms
removing tmp table	0.05 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.03 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_eventbooking/model/event.php:126
11	EventbookingModelEvent::getAllChildrenEvents()	JROOT/components/com_eventbooking/view/event/html.php:128
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.86 ms Po ostatnim zapytaniu: 0.38 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 7.743 MB Zwróconych wierszy: 0

SELECT *

  FROM kgpue_eb_event_group_prices

  WHERE event_id=3183

  ORDER BY id

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_eb_event_group_prices	NULL	ref	kgpue_eb_event_prices_FKIndex1	kgpue_eb_event_prices_FKIndex1	5	const	1	100.00	Using index condition

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 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_eventbooking/helper/database.php:143
11	EventbookingHelperDatabase::getGroupRegistrationRates()	JROOT/components/com_eventbooking/view/event/html.php:190
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.72 ms Po ostatnim zapytaniu: 1.25 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 7.843 MB Zwróconych wierszy: 1

SELECT main_category_id

  FROM kgpue_eb_events

  WHERE id = 3183

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_eb_events	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:94
15	EventbookingHelperRoute::getEventRoute()	JROOT/components/com_eventbooking/helper/data.php:795
14	EventbookingHelperData::prepareDisplayData()	JROOT/components/com_eventbooking/themes/default/event/default.php:14
13	include JROOT/components/com_eventbooking/themes/default/event/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:247
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/event/html.php:197
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.75 ms Po ostatnim zapytaniu: 1.08 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 7.938 MB Zwróconych wierszy: 1

SELECT id

  FROM kgpue_eb_urls

  WHERE md5_key = 'e08a43d1126697b9169ef7b581e8b8b2'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_eb_urls	NULL	ref	idx_md5_key	idx_md5_key	99	const	1	100.00	Using index

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:402
21	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/helper/data.php:795
14	EventbookingHelperData::prepareDisplayData()	JROOT/components/com_eventbooking/themes/default/event/default.php:14
13	include JROOT/components/com_eventbooking/themes/default/event/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:247
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/event/html.php:197
10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:313
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:64
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:278
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:36
6	require_once JROOT/components/com_eventbooking/eventbooking.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:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.72 ms Po ostatnim zapytaniu: 9.32 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 8.074 MB Zwróconych wierszy: 6

SELECT id 
  FROM kgpue_template_styles 
  ORDER BY id

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_template_styles	NULL	index	NULL	PRIMARY	4	NULL	6	100.00	Using index

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	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/plugins/system/ef4_jmframework/includes/libraries/template.php:329
9	JMFTemplate->setup()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:126
8	JMFTemplate->__construct()	JROOT/templates/pcj-jngo-zielony/index.php:18
7	require JROOT/templates/pcj-jngo-zielony/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 3.30 ms Po ostatnim zapytaniu: 1.29 ms Pamięć zapytania: 0.201 MB Pamięć przed zapytaniem: 8.298 MB Zwróconych wierszy: 46

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM kgpue_modules AS m

  LEFT JOIN kgpue_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  LEFT JOIN kgpue_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	published,newsfeeds	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	125	3.92	Using where; Uruchomiono metodę filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	01683034_0000020.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	01683034_0000020.m.id	1	100.00	Using where

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	2.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:421
18	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:135
17	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:476
11	JMFTemplate->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:469
10	JMFTemplate->checkModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1711
9	JMFTemplate->getAllColumnsClasses()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:191
8	JMFTemplate->__construct()	JROOT/templates/pcj-jngo-zielony/index.php:18
7	require JROOT/templates/pcj-jngo-zielony/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.71 ms Po ostatnim zapytaniu: 2.43 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 8.624 MB Zwróconych wierszy: 1

SELECT a.mirror_id

  FROM kgpue_advancedmodules AS a

  WHERE a.moduleid = 221

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:471
19	PlgSystemAdvancedModuleHelper->getMirrorModuleIdById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:272
18	PlgSystemAdvancedModuleHelper->setMirrorParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:178
17	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:476
11	JMFTemplate->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:469
10	JMFTemplate->checkModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1711
9	JMFTemplate->getAllColumnsClasses()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:191
8	JMFTemplate->__construct()	JROOT/templates/pcj-jngo-zielony/index.php:18
7	require JROOT/templates/pcj-jngo-zielony/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.84 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 8.634 MB Zwróconych wierszy: 1

SELECT a.params

  FROM kgpue_advancedmodules AS a

  WHERE a.moduleid = 221

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:505
19	PlgSystemAdvancedModuleHelper->getAdvancedParamsById()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:308
18	PlgSystemAdvancedModuleHelper->setMirrorParams()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:178
17	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:476
11	JMFTemplate->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:469
10	JMFTemplate->checkModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1711
9	JMFTemplate->getAllColumnsClasses()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:191
8	JMFTemplate->__construct()	JROOT/templates/pcj-jngo-zielony/index.php:18
7	require JROOT/templates/pcj-jngo-zielony/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.77 ms Po ostatnim zapytaniu: 5.29 ms Pamięć zapytania: 0.050 MB Pamięć przed zapytaniem: 8.852 MB Zwróconych wierszy: 133

SHOW FULL COLUMNS 
  FROM `kgpue_eb_events`

Objaśnienie

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

Profile

Status	Duration
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.55 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.06 ms
closing tables	0.00 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:79
21	RADModelList->__construct()	JROOT/components/com_eventbooking/model/list.php:117
20	EventbookingModelList->__construct()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/model.php:118
19	RADModel::getInstance()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/model.php:133
18	RADModel::getTempInstance()	JROOT/modules/mod_eb_events/helper.php:32
17	modEBEventsHelper::getData()	JROOT/modules/mod_eb_events/mod_eb_events.php:59
16	include JROOT/modules/mod_eb_events/mod_eb_events.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/pcj-jngo-zielony/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-jngo-zielony/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-jngo-zielony/tpl/default.php:172
10	include JROOT/templates/pcj-jngo-zielony/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/pcj-jngo-zielony/index.php:19
7	require JROOT/templates/pcj-jngo-zielony/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 3.00 ms Po ostatnim zapytaniu: 0.50 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 8.886 MB Zwróconych wierszy: 1

SELECT COUNT(*)

  FROM kgpue_eb_events AS tbl

  WHERE tbl.parent_id = 0 
  AND tbl.published IN(1, 2) 
  AND tbl.hidden = 0 
  AND tbl.access IN (1,1,5) 
  AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2024-12-01 10:37:23') 
  AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2024-12-01 10:37:23') 
  AND (DATE(tbl.event_date) >= '2024-12-01' OR DATE(tbl.cut_off_date) >= '2024-12-01' OR DATE(tbl.max_end_date) >= '2024-12-01')

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tbl	NULL	ref	idx_parent_id,idx_access,idx_published	idx_parent_id	4	const	288	1.60	Using where

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	2.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:202
19	RADModelList->getTotal()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:164
18	RADModelList->getData()	JROOT/modules/mod_eb_events/helper.php:73
17	modEBEventsHelper::getData()	JROOT/modules/mod_eb_events/mod_eb_events.php:59
16	include JROOT/modules/mod_eb_events/mod_eb_events.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/pcj-jngo-zielony/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-jngo-zielony/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-jngo-zielony/tpl/default.php:172
10	include JROOT/templates/pcj-jngo-zielony/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/pcj-jngo-zielony/index.php:19
7	require JROOT/templates/pcj-jngo-zielony/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 5.86 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.042 MB Pamięć przed zapytaniem: 8.895 MB Zwróconych wierszy: 0

SELECT 
  CASE WHEN (tbl.event_type = 1 
  AND TIMESTAMPDIFF(MINUTE, tbl.event_date, '2024-12-01 10:37:23') > 0) THEN (SELECT MIN(event_date) AS next_event_date 
  FROM kgpue_eb_events 
  WHERE published = 1 
  AND event_date >= '2024-12-01 10:37:23' 
  AND (parent_id = tbl.id OR id = tbl.id)) ELSE tbl.event_date END AS next_event_date,tbl.id,tbl.main_category_id,tbl.location_id,tbl.title,tbl.event_type,tbl.event_date,tbl.event_end_date,tbl.short_description,tbl.description,tbl.access,tbl.registration_access,tbl.individual_price,tbl.price_text,tbl.event_capacity,tbl.waiting_list_capacity,tbl.created_by,tbl.cut_off_date,tbl.registration_type,tbl.min_group_number,tbl.discount_type,tbl.discount,tbl.early_bird_discount_type,tbl.early_bird_discount_date,tbl.early_bird_discount_amount,tbl.enable_cancel_registration,tbl.cancel_before_date,tbl.params,tbl.published,tbl.custom_fields,tbl.discount_groups,tbl.discount_amounts,tbl.registration_start_date,tbl.registration_handle_url,tbl.fixed_group_price,tbl.attachment,tbl.late_fee_type,tbl.late_fee_date,tbl.late_fee_amount,tbl.event_password,tbl.currency_code,tbl.currency_symbol,tbl.thumb,tbl.image,tbl.language,tbl.alias,tbl.tax_rate,tbl.featured,tbl.has_multiple_ticket_types,tbl.activate_waiting_list,tbl.collect_member_information,tbl.prevent_duplicate_registration,DATEDIFF(tbl.early_bird_discount_date, '2024-12-01 10:37:23') AS date_diff,DATEDIFF(tbl.event_date, '2024-12-01 10:37:23') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.late_fee_date, '2024-12-01 10:37:23') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2024-12-01 10:37:23') AS event_start_minutes,TIMESTAMPDIFF(SECOND, tbl.registration_start_date, '2024-12-01 10:37:23') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2024-12-01 10:37:23') AS cut_off_minutes,`c`.`name` AS `location_name`,`c`.`alias` AS `location_alias`,c.address AS location_address,IFNULL(SUM(b.number_registrants), 0) AS total_registrants

  FROM kgpue_eb_events AS tbl

  LEFT JOIN kgpue_eb_registrants AS b 
  ON (tbl.id = b.event_id 
  AND b.group_id=0 
  AND (b.published = 1 OR (b.payment_method LIKE "os_offline%" 
  AND b.published NOT IN (2,3))))

  LEFT JOIN kgpue_eb_locations AS c 
  ON tbl.location_id = c.id 

  WHERE tbl.parent_id = 0 
  AND tbl.published IN(1, 2) 
  AND tbl.hidden = 0 
  AND tbl.access IN (1,1,5) 
  AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2024-12-01 10:37:23') 
  AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2024-12-01 10:37:23') 
  AND (DATE(tbl.event_date) >= '2024-12-01' OR DATE(tbl.cut_off_date) >= '2024-12-01' OR DATE(tbl.max_end_date) >= '2024-12-01')

  GROUP BY tbl.id

  ORDER BY next_event_date 
  LIMIT 6

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	tbl	NULL	ref	PRIMARY,idx_category_id,idx_location_id,idx_parent_id,idx_access,idx_published,idx_event_date,idx_event_end_date,idx_alias	idx_parent_id	4	const	288	1.60	Using index condition; Using where; Using temporary; Uruchomiono metodę filesort
1	PRIMARY	b	NULL	ref	idx_event_id,idx_published	idx_event_id	5	01683034_0000020.tbl.id	1	100.00	Using where
1	PRIMARY	c	NULL	eq_ref	PRIMARY	PRIMARY	4	01683034_0000020.tbl.location_id	1	100.00	NULL
2	DEPENDENT SUBQUERY	kgpue_eb_events	NULL	range	PRIMARY,idx_parent_id,idx_published,idx_event_date	idx_event_date	5	NULL	1	19.00	Using index condition; Using where

Profile

Status	Duration
starting	0.39 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
init	0.27 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.19 ms
preparing	0.06 ms
Creating tmp table	0.09 ms
Sorting for group	0.03 ms
Sorting result	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.06 ms
executing	0.00 ms
Sending data	3.72 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:178
18	RADModelList->getData()	JROOT/modules/mod_eb_events/helper.php:73
17	modEBEventsHelper::getData()	JROOT/modules/mod_eb_events/mod_eb_events.php:59
16	include JROOT/modules/mod_eb_events/mod_eb_events.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:780
13	JMFTemplate->renderModules()	JROOT/templates/pcj-jngo-zielony/tpl/blocks/main.php:58
12	include JROOT/templates/pcj-jngo-zielony/tpl/blocks/main.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
11	JMFTemplate->renderBlock()	JROOT/templates/pcj-jngo-zielony/tpl/default.php:172
10	include JROOT/templates/pcj-jngo-zielony/tpl/default.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:699
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:714
8	JMFTemplate->renderScheme()	JROOT/templates/pcj-jngo-zielony/index.php:19
7	require JROOT/templates/pcj-jngo-zielony/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.93 ms Po ostatnim zapytaniu: 7.81 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 9.404 MB Zwróconych wierszy: 1

SELECT sleep_until < '2024-12-01 10:37:23' 
  FROM kgpue_scheduler_metadata 
  WHERE type = 'metadata' 
  LIMIT 1

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	kgpue_scheduler_metadata	NULL	const	unique_type	unique_type	98	const	1	100.00	NULL

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:128
8	PlgSystemJoomlatoolsscheduler->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:167
6	PlgSystemJoomlatoolsscheduler->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1096
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.15 ms Po ostatnim zapytaniu: 0.56 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 9.488 MB Zwróconych wierszy: 224

Duplikaty zapytań: #19 #25

SHOW TABLES

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: SHOW TABLES

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	1.32 ms
Sending data	0.13 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
8	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:253
7	plgSystemjdownloads->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1096
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.54 ms Po ostatnim zapytaniu: 1.74 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 9.589 MB Zwróconych wierszy: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `kgpue_categories` AS `s`

  INNER JOIN `kgpue_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 2

  ORDER BY c.lft

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	2	14.29	Using index condition; Using where

Profile

Status	Duration
starting	0.21 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.14 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.24 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Identyczny z wywołaniem linii niżej.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1096
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

43 typów zapytań zarejestrowanych, posortowanych według częstotliwości

WYBRANE tabele:

```
4 × SELECT id 
  FROM kgpue_menu
```

2 × SELECT `extension_id` 
  FROM `kgpue_extensions`

2 × SELECT setting_name, setting_value 
  FROM kgpue_jdownloads_confi

2 × SELECT `query` 
  FROM kgpue_eb_urls

2 × SELECT file_id 
  from kgpue_jdownloads_files

2 × SELECT id, link 
  from kgpue_menu

```
2 × SELECT * 
  FROM kgpue_extensions
```

2 × SELECT template 
  FROM kgpue_template_styles as s

1 × SELECT a.mirror_id 
  FROM kgpue_advancedmodules AS a

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM kgpue_modules AS m 
  LEFT JOIN kgpue_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN kgpue_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT a.params 
  FROM kgpue_advancedmodules AS a

1 × SELECT id 
  FROM kgpue_template_styles

```
1 × SELECT id 
  FROM kgpue_eb_urls
```

1 × SELECT COUNT(*) 
  FROM kgpue_eb_events AS tbl

1 × SELECT 
  CASE WHEN (tbl.event_type = 1 
  AND TIMESTAMPDIFF(MINUTE, tbl.event_date, '2024-12-01 10:37:23') > 0) THEN (SELECT MIN(event_date) AS next_event_date 
  FROM kgpue_eb_events

1 × SELECT main_category_id 
  FROM kgpue_eb_events

1 × SELECT * 
  FROM kgpue_eb_event_group_prices

1 × SELECT tbl.id,tbl.main_category_id,tbl.location_id,tbl.title,tbl.event_type,tbl.event_date,tbl.event_end_date,tbl.short_description,tbl.description,tbl.access,tbl.registration_access,tbl.individual_price,tbl.price_text,tbl.event_capacity,tbl.waiting_list_capacity,tbl.created_by,tbl.cut_off_date,tbl.registration_type,tbl.min_group_number,tbl.discount_type,tbl.discount,tbl.early_bird_discount_type,tbl.early_bird_discount_date,tbl.early_bird_discount_amount,tbl.enable_cancel_registration,tbl.cancel_before_date,tbl.params,tbl.published,tbl.custom_fields,tbl.discount_groups,tbl.discount_amounts,tbl.registration_start_date,tbl.registration_handle_url,tbl.fixed_group_price,tbl.attachment,tbl.late_fee_type,tbl.late_fee_date,tbl.late_fee_amount,tbl.event_password,tbl.currency_code,tbl.currency_symbol,tbl.thumb,tbl.image,tbl.language,tbl.alias,tbl.tax_rate,tbl.featured,tbl.has_multiple_ticket_types,tbl.activate_waiting_list,tbl.collect_member_information,tbl.prevent_duplicate_registration,TIMESTAMPDIFF(MINUTE, '2024-12-01 10:37:23', tbl.early_bird_discount_date) AS date_diff,TIMESTAMPDIFF(MINUTE, tbl.late_fee_date, '2024-12-01 10:37:23') AS late_fee_date_diff,DATEDIFF(tbl.event_date, '2024-12-01 10:37:23') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2024-12-01 10:37:23') AS event_start_minutes,TIMESTAMPDIFF(SECOND, tbl.registration_start_date, '2024-12-01 10:37:23') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2024-12-01 10:37:23') AS cut_off_minutes,c.name AS location_name, c.address AS location_address,IFNULL(SUM(b.number_registrants), 0) AS total_registrants 
  FROM kgpue_eb_events AS tbl 
  LEFT JOIN kgpue_eb_registrants AS b 
  ON (tbl.id = b.event_id 
  AND b.group_id=0 
  AND (b.published = 1 OR (b.payment_method LIKE "os_offline%" 
  AND b.published NOT IN (2,3)))) 
  LEFT JOIN kgpue_eb_locations AS c 
  ON tbl.location_id = c.id

```
1 × SELECT id 
  from kgpue_menu
```

1 × SELECT sleep_until < '2024-12-01 10:37:23' 
  FROM kgpue_scheduler_metadata

1 × SELECT `data` 
  FROM `kgpue_session`

1 × SELECT a.*,DATEDIFF(event_date, '2024-12-01 10:37:23') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.late_fee_date, '2024-12-01 10:37:23') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, a.event_date, '2024-12-01 10:37:23') AS event_start_minutes,TIMESTAMPDIFF(SECOND, registration_start_date, '2024-12-01 10:37:23') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2024-12-01 10:37:23') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2024-12-01 10:37:23', early_bird_discount_date) AS date_diff,IFNULL(SUM(b.number_registrants), 0) AS total_registrants,`c`.`name` AS `location_name`,`c`.`alias` AS `location_alias`,c.address AS location_address 
  FROM kgpue_eb_events AS a 
  LEFT JOIN kgpue_eb_registrants AS b 
  ON (a.id = b.event_id 
  AND b.group_id=0 
  AND (b.published = 1 OR (b.payment_method LIKE "os_offline%" 
  AND b.published NOT IN (2,3)))) 
  LEFT JOIN kgpue_eb_locations AS c 
  ON a.location_id = c.id

1 × SELECT a.*, b.event_id 
  FROM kgpue_eb_categories AS a 
  INNER JOIN kgpue_eb_event_categories AS b 
  ON a.id = b.category_id

1 × SELECT * 
  FROM kgpue_eb_location

1 × SELECT `session_id` 
  FROM `kgpue_session`

```
1 × SELECT * 
  FROM kgpue_eb_themes
```

1 × SELECT `config_key`,`config_value` 
  FROM kgpue_eb_config

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `kgpue_assets`

1 × SELECT * 
  FROM kgpue_rsform_confi

1 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM kgpue_extensions

1 × SELECT `source`,`keepurlparams` 
  FROM `kgpue_admintools_redirects`

1 × SELECT extension, file, type 
  FROM kgpue_rokcommon_configs

1 × SELECT * 
  FROM `kgpue_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `kgpue_admintools_storage`

1 × SELECT b.id 
  FROM kgpue_usergroups AS a 
  LEFT JOIN kgpue_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `kgpue_viewlevels

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `kgpue_categories` AS `s` 
  INNER JOIN `kgpue_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

INNE tabele:

```
3 × SHOW TABLE
```

1 × INSERT INTO `kgpue_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3562623935653766393336346136626538343837393064366463373365373732', 1, 1733049443, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `kgpue_extensions

1 × UPDATE `kgpue_extensions` 
  SET `params` = '{\"mediaversion\":\"316bc4930596fff1353afef751956d35\"}'

1 × UPDATE kgpue_eb_events 
  SET hits = hits + 1

1 × SHOW FULL COLUMNS 
  FROM `kgpue_eb_events

WR61 Programowanie w języku C++ - poziom rozszerzony

Nasi partnerzy

Kontakt

Menu prawne

Linki

Social Media

Biuletyn Informacji Publicznej Biuletyn Informacji Publicznej

Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Czas

Pamięć

Użycie pamięci

Zapytania do bazy danych

55 zapytań zarejestrowanych 64.19 ms

13 znalezionych duplikatów!

43 typów zapytań zarejestrowanych, posortowanych według częstotliwości

WYBRANE tabele:

INNE tabele: