Ta strona używa plików cookie w celu usprawnienia i ułatwienia dostępu do serwisu oraz prowadzenia danych statystycznych. Dalsze korzystanie z tej witryny oznacza akceptację tego stanu rzeczy.
Jak wyłączyć cookies? AKCEPTUJĘ

Main Menu

Aplikacje Ex

Przepustnice bezpieczeństwa, regulacyjne, p.poż, oddymiające

Kategoria: Aplikacje Ex

Przepustnice powietrzne

Siłowniki firmy Schischek są dopuszczone do bezpośredniej instalacji i eksploatacji w strefach zagrożonych wybuchem, gdyż charakteryzują się one najwyższą grupą wybuchowości i klasy temperatur oraz są odpowiednie dla wszystkich gazów, oparów
i pyłów. Podłączenie elektryczne odbywa się przez specjalną puszkę przyłączeniową typu ExBox-... Podczas instalacji należy zachować szczególną ostrożność, czy wszystkie przewody są odpowiednio połączone i zabezpieczone przed uszkodzeniami
mechanicznymi.

Automatyczne przepustnice powietrzne

System automatycznego sterowania przepustnicą składa się z napędu elektrycznego oraz przetwornika ExCos-D z sondą ExPro-CT… Tak zbudowany system może pracować w strefie Ex. Przetwornik przekształca sygnał sondy pomiarowej na standardowy sygnał analogowy (0...10 VDC lub 4...20 mA), co umożliwia podłączenie np. ze sterownikiem PLC. Wyjście sterownika jest bezpośrednio doprowadzone do siłownika. Między czujnikiem a sterownikiem nie ma konieczności wykorzystywania specjalnych modułów lub obwodów iskrobezpiecznych. Podczas doboru siłownika i przetwornika należy brać pod uwagę maksymalną, dopuszczalną temperaturę ich powierzchni.

Sterowanie przepustnicami p.poż/oddymiającymi

W aplikacjach z przepustnicami p.poż/oddymiającymi siłownik musi ustawić przepustnicę z powrotem do bezpiecznej pozycji, dzięki użyciu zewnętrznego przełącznika. Jest to możliwe dzięki wbudowanej w siłownik sprężynie powrotnej. Napęd wyzwala czujka temperatury typu ExPro-TT-.., która jest połączona bezpośrednio do siłownika.

Konsola diagnostyczna Joomla!

Sesja

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685405779,
                "last": 1685405779,
                "now": 1685405779
            },
            "token": "4Mj8IrqoUJZ1MMJ7U5jaoZZ5ysTeeHNi"
        },
        "registry": {
            "com_djcatalog2": {
                "items": {
                    "recent": [
                        39
                    ]
                }
            }
        },
        "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
        }
    }
}

Informacje o wydajności

Czas

Pamięć

Czas: 17.35 ms / 17.35 ms Pamięć: 0.610 MB / 0.99 MB Application: afterLoad

Czas: 58.11 ms / 75.46 ms Pamięć: 1.229 MB / 2.22 MB Application: afterInitialise

Czas: 33.81 ms / 109.27 ms Pamięć: 0.655 MB / 2.87 MB Application: afterRoute

Czas: 0.30 ms / 109.57 ms Pamięć: 0.061 MB / 2.93 MB Application: beforeRenderComponent com_djcatalog2

Czas: 78.04 ms / 187.61 ms Pamięć: 1.011 MB / 3.94 MB Application: Before Access::preloadComponents (all components)

Czas: 0.99 ms / 188.59 ms Pamięć: 0.057 MB / 4.00 MB Application: After Access::preloadComponents (all components)

Czas: 0.02 ms / 188.61 ms Pamięć: 0.000 MB / 4.00 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Czas: 0.58 ms / 189.19 ms Pamięć: 0.009 MB / 4.01 MB Application: After Access::getAssetRules (id:1 name:root.1)

Czas: 7.26 ms / 196.44 ms Pamięć: 0.072 MB / 4.08 MB Application: Before Access::getAssetRules (id:448 name:com_djcatalog2)

Czas: 0.03 ms / 196.48 ms Pamięć: 0.007 MB / 4.09 MB Application: After Access::getAssetRules (id:448 name:com_djcatalog2)

Czas: 3.94 ms / 200.42 ms Pamięć: 0.061 MB / 4.15 MB Application: afterRenderComponent com_djcatalog2

Czas: 0.23 ms / 200.64 ms Pamięć: 0.006 MB / 4.15 MB Application: afterDispatch

Czas: 25.50 ms / 226.14 ms Pamięć: 0.318 MB / 4.47 MB Application: beforeRenderModule mod_custom (Kontakt stopka)

Czas: 0.83 ms / 226.98 ms Pamięć: 0.085 MB / 4.56 MB Application: afterRenderModule mod_custom (Kontakt stopka)

Czas: 0.27 ms / 227.25 ms Pamięć: 0.002 MB / 4.56 MB Application: beforeRenderModule mod_custom (Katalog produktów)

Czas: 0.10 ms / 227.35 ms Pamięć: 0.003 MB / 4.56 MB Application: afterRenderModule mod_custom (Katalog produktów)

Czas: 0.24 ms / 227.59 ms Pamięć: 0.000 MB / 4.56 MB Application: beforeRenderModule mod_custom (Klasyfikacja Ex)

Czas: 0.75 ms / 228.34 ms Pamięć: 0.018 MB / 4.58 MB Application: afterRenderModule mod_custom (Klasyfikacja Ex)

Czas: 2.11 ms / 230.45 ms Pamięć: 0.054 MB / 4.63 MB Application: beforeRenderModule mod_djmegamenu (DJ-MegaMenu)

Czas: 5.58 ms / 236.03 ms Pamięć: 0.094 MB / 4.73 MB Application: afterRenderModule mod_djmegamenu (DJ-MegaMenu)

Czas: 0.33 ms / 236.35 ms Pamięć: 0.000 MB / 4.70 MB Application: beforeRenderModule mod_menu (Main Menu)

Czas: 1.05 ms / 237.40 ms Pamięć: 0.011 MB / 4.71 MB Application: afterRenderModule mod_menu (Main Menu)

Czas: 4.73 ms / 242.13 ms Pamięć: 0.112 MB / 4.82 MB Application: afterRender

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

Użycie pamięci

Zapytania do bazy danych

37 zapytań zarejestrowanych 25.13 ms

8 znalezionych duplikatów!

2 duplikatów: #12 #22

2 duplikatów: #14 #17

2 duplikatów: #15 #18

2 duplikatów: #16 #19

Czas zapytania: 0.48 ms Pamięć zapytania: 0.003 MB Pamięć przed zapytaniem: 1.449 MB

DELETE 

  FROM `saf6i_session`

  WHERE `time` < '1685404879'

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: DELETE FROM `saf6i_session` WHERE `time` < '1685404879'

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Application/CMSApplication.php:824
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
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:415
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.28 ms Po ostatnim zapytaniu: 0.26 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 1.457 MB Zwróconych wierszy: 0

SELECT `data`

  FROM `saf6i_session`

  WHERE `session_id` = 'a9dae4c985f0e61cf458415872e6bd5b'

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	saf6i_session	const	PRIMARY	PRIMARY	766	const	1

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
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:831
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
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:415
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.26 ms Po ostatnim zapytaniu: 1.25 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 1.471 MB Zwróconych wierszy: 0

SELECT `session_id`

  FROM `saf6i_session`

  WHERE `session_id` = 'a9dae4c985f0e61cf458415872e6bd5b' 
  LIMIT 1

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
7	JDatabaseDriver->loadResult()	JROOT/libraries/src/Application/CMSApplication.php:178
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
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:415
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.54 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.003 MB Pamięć przed zapytaniem: 1.476 MB

INSERT INTO `saf6i_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('a9dae4c985f0e61cf458415872e6bd5b', 1, '1685405779', 0, '', 0)

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `saf6i_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('a9dae4c985f0e61cf458415872e6bd5b', 1, '1685405779', 0, '', 0)

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Application/CMSApplication.php:218
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
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:415
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.39 ms Po ostatnim zapytaniu: 8.68 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 1.697 MB Zwróconych wierszy: 5

SELECT id, rules

  FROM `saf6i_viewlevels`

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
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:310
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:606
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:267
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.42 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 1.709 MB Zwróconych wierszy: 2

SELECT b.id

  FROM saf6i_usergroups AS a

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

  WHERE a.id = 9

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
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:310
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:606
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:267
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.01 ms Po ostatnim zapytaniu: 40.27 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 2.658 MB

UPDATE `saf6i_extensions`

  SET `params` = '{\"mediaversion\":\"a2d30132c9c176af3f9f070b3714a808\"}'

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

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/djjquerymonster/djjquerymonster.php:58
8	plgSystemDJjQueryMonster->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:1156
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:267
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.69 ms Po ostatnim zapytaniu: 44.55 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.312 MB Zwróconych wierszy: 5

SELECT a.id

  FROM saf6i_viewlevels AS a

  ORDER BY a.ordering ASC, a.id ASC

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:53
13	Djc2CategoryNode->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:168
12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:70
10	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/helpers/theme.php:39
9	DJCatalog2ThemeHelper::setThemeAssets()	JROOT/components/com_djcatalog2/controller.php:59
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.067 MB Pamięć przed zapytaniem: 3.319 MB Zwróconych wierszy: 8

SELECT c.*  
  FROM saf6i_djc2_categories AS c  
  WHERE c.published=1 
  AND c.access IN (1,5)  
  ORDER BY c.parent_id ASC, c.ordering ASC

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	idx_published,idx_published_parent_ordering,idx_access	idx_published_parent_ordering	4	const	8	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:298
13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:70
10	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/helpers/theme.php:39
9	DJCatalog2ThemeHelper::setThemeAssets()	JROOT/components/com_djcatalog2/controller.php:59
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.11 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 3.401 MB Zwróconych wierszy: 11

SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath

  FROM saf6i_djc2_categories as i

  INNER JOIN saf6i_djc2_images as img 
  on img.id=(select id 
  from saf6i_djc2_images 
  where type='category' 
  and item_id=i.id 
  order by ordering asc 
  limit 1)

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	i	index	NULL	idx_parent_id	4	NULL	14	Using index
1	PRIMARY	img	eq_ref	PRIMARY	PRIMARY	4	func	1	Using where
2	DEPENDENT SUBQUERY	saf6i_djc2_images	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_item_type_ordering	198	bil2013_sch.i.id,const	1	Using where; Using index

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:305
13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:70
10	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/helpers/theme.php:39
9	DJCatalog2ThemeHelper::setThemeAssets()	JROOT/components/com_djcatalog2/controller.php:59
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.68 ms Po ostatnim zapytaniu: 6.77 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 3.507 MB Zwróconych wierszy: 0

select alias 
  from saf6i_djc2_items_extra_fields 
  where type='checkbox' or type='radio' or type='select'

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
9	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/controller.php:98
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.36 ms Po ostatnim zapytaniu: 7.35 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 3.629 MB Zwróconych wierszy: 0

Duplikaty zapytań: #22

SELECT f.*, group_concat(fo.id separator '|') as options, g.name as group_name, g.label as group_label, g.id as fgroup_id

  FROM saf6i_djc2_items_extra_fields as f

  LEFT JOIN saf6i_djc2_items_extra_fields_options as fo 
  ON fo.field_id=f.id

  LEFT JOIN saf6i_djc2_items_extra_fields_groups as g 
  ON g.id=f.group_id

  WHERE (f.visibility = 1 or f.visibility = 3) 
  and f.published = 1

  GROUP BY f.id

  ORDER BY IFNULL(g.ordering,0) asc , g.ordering asc, f.ordering asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ref	idx_published	idx_published	4	const	1	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	fo	ref	idx_field_id	idx_field_id	4	bil2013_sch.f.id	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.f.group_id	1

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:254
14	DJCatalog2ModelItem->getAttributes()	JROOT/components/com_djcatalog2/models/item.php:137
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:59
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.08 ms Pamięć zapytania: 0.039 MB Pamięć przed zapytaniem: 3.639 MB Zwróconych wierszy: 1

SELECT i.*, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,countries.country_name 

  FROM saf6i_djc2_items as i

  LEFT JOIN saf6i_djc2_categories AS c 
  ON c.id = i.cat_id

  LEFT JOIN saf6i_djc2_producers AS p 
  ON p.id = i.producer_id

  LEFT JOIN saf6i_users AS ua 
  ON ua.id = i.created_by

  LEFT JOIN saf6i_djc2_countries AS countries 
  ON countries.id = i.country

  WHERE i.id =39 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-05-30 00:16:19') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 00:16:19')

  GROUP BY i.id

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	countries	const	PRIMARY	PRIMARY	2	const	0	Unique row not found

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:166
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:59
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.05 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 3.673 MB Zwróconych wierszy: 0

Duplikaty zapytań: #17

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value

  FROM saf6i_djc2_items_extra_fields_values_int as fieldvalues

  INNER JOIN saf6i_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN saf6i_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  LEFT JOIN saf6i_djc2_items_extra_fields_options as fieldoptions 
  ON fieldoptions.id = fieldvalues.value 
  AND fieldoptions.field_id = fields.id

  WHERE fieldvalues.item_id=39 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fields.ordering asc, fieldoptions.ordering asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	bil2013_sch.fieldvalues.field_id	1	Using where
1	SIMPLE	fieldoptions	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	bil2013_sch.fieldvalues.value	1	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:290
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:185
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:59
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.46 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 3.680 MB Zwróconych wierszy: 0

Duplikaty zapytań: #18

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value

  FROM saf6i_djc2_items_extra_fields_values_text as fieldvalues

  INNER JOIN saf6i_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN saf6i_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  WHERE fieldvalues.item_id=39 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	bil2013_sch.fieldvalues.field_id	1	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:292
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:185
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:59
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.48 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 3.688 MB Zwróconych wierszy: 0

Duplikaty zapytań: #19

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value

  FROM saf6i_djc2_items_extra_fields_values_date as fieldvalues

  INNER JOIN saf6i_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN saf6i_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  WHERE fieldvalues.item_id=39 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fields.ordering asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	fields	ref	PRIMARY,idx_published	idx_published	4	const	1	Using where; Uruchomiono metodę filesort
1	SIMPLE	fieldvalues	eq_ref	item_field	item_field	8	const,bil2013_sch.fields.id	1

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:294
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:185
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:59
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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: 4.11 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 3.698 MB Zwróconych wierszy: 0

Duplikaty zapytań: #14

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value

  FROM saf6i_djc2_items_extra_fields_values_int as fieldvalues

  INNER JOIN saf6i_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN saf6i_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  LEFT JOIN saf6i_djc2_items_extra_fields_options as fieldoptions 
  ON fieldoptions.id = fieldvalues.value 
  AND fieldoptions.field_id = fields.id

  WHERE fieldvalues.item_id=39 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fields.ordering asc, fieldoptions.ordering asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	bil2013_sch.fieldvalues.field_id	1	Using where
1	SIMPLE	fieldoptions	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	bil2013_sch.fieldvalues.value	1	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:290
15	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:185
14	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:73
13	DJCatalog2ModelItem->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.37 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 3.707 MB Zwróconych wierszy: 0

Duplikaty zapytań: #15

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value

  FROM saf6i_djc2_items_extra_fields_values_text as fieldvalues

  INNER JOIN saf6i_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN saf6i_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  WHERE fieldvalues.item_id=39 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	bil2013_sch.fieldvalues.field_id	1	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:292
15	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:185
14	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:73
13	DJCatalog2ModelItem->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.39 ms Po ostatnim zapytaniu: 0.01 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 3.716 MB Zwróconych wierszy: 0

Duplikaty zapytań: #16

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value

  FROM saf6i_djc2_items_extra_fields_values_date as fieldvalues

  INNER JOIN saf6i_djc2_items as items 
  on items.id=fieldvalues.item_id

  INNER JOIN saf6i_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

  WHERE fieldvalues.item_id=39 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fields.ordering asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	fields	ref	PRIMARY,idx_published	idx_published	4	const	1	Using where; Uruchomiono metodę filesort
1	SIMPLE	fieldvalues	eq_ref	item_field	item_field	8	const,bil2013_sch.fields.id	1

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:294
15	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:185
14	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:73
13	DJCatalog2ModelItem->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.34 ms Po ostatnim zapytaniu: 0.94 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 3.779 MB Zwróconych wierszy: 18

select id, producer_id 
  from saf6i_djc2_items 
  where published=1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	saf6i_djc2_items	ref	idx_published	idx_published	4	const	18

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/route.php:77
12	DJCatalogHelperRoute::getItemRoute()	JROOT/components/com_djcatalog2/views/item/view.html.php:100
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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: 10.95 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.832 MB Zwróconych wierszy: 0

SELECT related_item

  FROM saf6i_djc2_items_related

  WHERE item_id=39

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	saf6i_djc2_items_related	ref	item_related	item_related	4	const	1	Using index

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
13	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/models/item.php:213
12	DJCatalog2ModelItem->getRelatedItems()	JROOT/components/com_djcatalog2/views/item/view.html.php:165
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.97 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 3.842 MB Zwróconych wierszy: 0

Duplikaty zapytań: #12

SELECT f.*, group_concat(fo.id separator '|') as options, g.name as group_name, g.label as group_label, g.id as fgroup_id

  FROM saf6i_djc2_items_extra_fields as f

  LEFT JOIN saf6i_djc2_items_extra_fields_options as fo 
  ON fo.field_id=f.id

  LEFT JOIN saf6i_djc2_items_extra_fields_groups as g 
  ON g.id=f.group_id

  WHERE (f.visibility = 1 or f.visibility = 3) 
  and f.published = 1

  GROUP BY f.id

  ORDER BY IFNULL(g.ordering,0) asc , g.ordering asc, f.ordering asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ref	idx_published	idx_published	4	const	1	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	fo	ref	idx_field_id	idx_field_id	4	bil2013_sch.f.id	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.f.group_id	1

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:254
12	DJCatalog2ModelItem->getAttributes()	JROOT/components/com_djcatalog2/views/item/view.html.php:166
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.95 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.847 MB Zwróconych wierszy: 1

SELECT subq.position 
  FROM (SELECT k.*, @num := @num + 1 AS position 
  FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
  FROM saf6i_djc2_items AS i  
  LEFT JOIN saf6i_djc2_categories as c 
  ON c.id = i.cat_id  
  LEFT JOIN saf6i_djc2_producers as p 
  ON p.id = i.producer_id  
  WHERE i.parent_id = 0 
  AND i.published = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-05-30 00:16:19') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 00:16:19') 
  AND c.published = 1  
  AND i.cat_id=13 
  ORDER BY  i.name asc , i.ordering, c.ordering ) as k) as subq 
  WHERE subq.id = 39 
  ORDER BY subq.position DESC 
  LIMIT 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4	Using where; Uruchomiono metodę filesort
2	DERIVED	<derived3>	system	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1
2	DERIVED	<derived4>	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4
4	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1
4	DERIVED	i	ref	idx_cat_id,idx_parent_id,idx_published	idx_cat_id	4	const	4	Using where; Uruchomiono metodę filesort
3	DERIVED	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	No tables used

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:416
12	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:167
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.82 ms Po ostatnim zapytaniu: 0.01 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 3.855 MB Zwróconych wierszy: 1

SELECT subq.* 
  FROM (SELECT k.*, @num := @num + 1 AS position 
  FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
  FROM saf6i_djc2_items AS i  
  LEFT JOIN saf6i_djc2_categories as c 
  ON c.id = i.cat_id  
  LEFT JOIN saf6i_djc2_producers as p 
  ON p.id = i.producer_id  
  WHERE i.parent_id = 0 
  AND i.published = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-05-30 00:16:19') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 00:16:19') 
  AND c.published = 1  
  AND i.cat_id=13 
  ORDER BY  i.name asc , i.ordering, c.ordering ) as k) as subq 
  WHERE subq.position < 2 
  ORDER BY subq.position DESC 
  LIMIT 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4	Using where; Uruchomiono metodę filesort
2	DERIVED	<derived3>	system	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1
2	DERIVED	<derived4>	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4
4	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1
4	DERIVED	i	ref	idx_cat_id,idx_parent_id,idx_published	idx_cat_id	4	const	4	Using where; Uruchomiono metodę filesort
3	DERIVED	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	No tables used

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:428
12	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:167
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.80 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 3.864 MB Zwróconych wierszy: 1

SELECT subq.* 
  FROM (SELECT k.*, @num := @num + 1 AS position 
  FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
  FROM saf6i_djc2_items AS i  
  LEFT JOIN saf6i_djc2_categories as c 
  ON c.id = i.cat_id  
  LEFT JOIN saf6i_djc2_producers as p 
  ON p.id = i.producer_id  
  WHERE i.parent_id = 0 
  AND i.published = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-05-30 00:16:19') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 00:16:19') 
  AND c.published = 1  
  AND i.cat_id=13 
  ORDER BY  i.name asc , i.ordering, c.ordering ) as k) as subq 
  WHERE subq.position > 2 
  ORDER BY subq.position ASC 
  LIMIT 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4	Using where; Uruchomiono metodę filesort
2	DERIVED	<derived3>	system	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1
2	DERIVED	<derived4>	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4
4	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1
4	DERIVED	i	ref	idx_cat_id,idx_parent_id,idx_published	idx_cat_id	4	const	4	Using where; Uruchomiono metodę filesort
3	DERIVED	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	No tables used

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:436
12	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:167
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.88 ms Po ostatnim zapytaniu: 4.33 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 3.949 MB Zwróconych wierszy: 35

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

  FROM `saf6i_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djcatalog2','com_djmediatools','com_djtabs','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
22	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
21	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/components/com_djcatalog2/models/items.php:716
17	DJCatalog2ModelItems->_buildContentWhere()	JROOT/components/com_djcatalog2/models/items.php:268
16	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:235
15	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:215
13	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:489
12	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:169
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.54 ms Po ostatnim zapytaniu: 0.70 ms Pamięć zapytania: 0.031 MB Pamięć przed zapytaniem: 4.008 MB Zwróconych wierszy: 0

SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id

  FROM saf6i_djc2_items_extra_fields as f

  LEFT JOIN saf6i_djc2_items_extra_fields_groups as g 
  ON g.id=f.group_id

  WHERE f.published = 1

  ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ref	idx_published	idx_published	4	const	1	Using temporary; Uruchomiono metodę filesort
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.f.group_id	1

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:877
17	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:270
16	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:235
15	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:215
13	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:489
12	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:169
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.36 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 4.020 MB Zwróconych wierszy: 0

SELECT o.id, o.field_id

  FROM saf6i_djc2_items_extra_fields_options AS o

  ORDER BY o.field_id asc, o.ordering asc

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:887
17	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:270
16	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:235
15	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:215
13	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:489
12	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:169
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.61 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.038 MB Pamięć przed zapytaniem: 4.029 MB Zwróconych wierszy: 0

SELECT distinct i.*, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,countries.country_name,states.name as state_name

  FROM saf6i_djc2_items as i

  LEFT JOIN saf6i_djc2_categories AS c 
  ON c.id = i.cat_id

  LEFT JOIN saf6i_djc2_producers AS p 
  ON p.id = i.producer_id

  LEFT JOIN saf6i_users AS ua 
  ON ua.id = i.created_by

  LEFT JOIN saf6i_djc2_countries AS countries 
  ON countries.id = i.country

  LEFT JOIN saf6i_djc2_countries_states AS states 
  ON states.id = i.state

  WHERE c.published = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-05-30 00:16:19') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 00:16:19') 
  AND i.published = 1 
  AND i.access IN (1,1,5) 
  AND i.parent_id=39

  ORDER BY  i.ordering asc, c.ordering asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	idx_cat_id,idx_parent_id,idx_published,idx_access	idx_parent_id	4	const	1	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.i.producer_id	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.i.created_by	1
1	SIMPLE	countries	eq_ref	PRIMARY	PRIMARY	2	bil2013_sch.i.country	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	bil2013_sch.i.cat_id	1	Using where
1	SIMPLE	states	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.i.state	1	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:199
14	DJCatalog2ModelItems->_getList()	JROOT/components/com_djcatalog2/models/items.php:217
13	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:489
12	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:169
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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: 1.92 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 4.043 MB Zwróconych wierszy: 0

SELECT *  
  FROM saf6i_djc2_images  
  WHERE item_id=39 	
  AND type='item' 
  AND exclude=0 
  ORDER BY ordering ASC, name ASC

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	saf6i_djc2_images	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	198	const,const	1	Using index condition; Using where; Uruchomiono metodę filesort

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/helpers/image.php:93
13	DJCatalog2ImageHelper::getImages()	JROOT/components/com_djcatalog2/views/item/view.html.php:316
12	DJCatalog2ViewItem->_prepareDocument()	JROOT/components/com_djcatalog2/views/item/view.html.php:188
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.81 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 4.052 MB

UPDATE saf6i_djc2_items 
  SET hits = hits + 1 
  WHERE id = 39

Objaśnienie

Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE saf6i_djc2_items SET hits = hits + 1 WHERE id = 39

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
13	JDatabase->query()	JROOT/components/com_djcatalog2/models/item.php:500
12	DJCatalog2ModelItem->hit()	JROOT/components/com_djcatalog2/views/item/view.html.php:190
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.83 ms Po ostatnim zapytaniu: 3.41 ms Pamięć zapytania: 0.040 MB Pamięć przed zapytaniem: 4.167 MB Zwróconych wierszy: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM saf6i_fields AS a

  LEFT JOIN `saf6i_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN saf6i_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN saf6i_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN saf6i_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN saf6i_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_djcatalog2.item.description' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Uruchomiono metodę filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	bil2013_sch.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.a.group_id	1	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
21	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:238
14	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:192
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.12 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 4.183 MB Zwróconych wierszy: 0

SELECT *  
  FROM saf6i_djc2_files  
  WHERE item_id=39 	
  AND type='item' 
  AND access IN (1,1,5)  
  ORDER BY ordering ASC, name ASC

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	saf6i_djc2_files	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	198	const,const	1	Using index condition; Using where; Uruchomiono metodę filesort

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/helpers/file.php:88
15	DJCatalog2FileHelper::getFiles()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:308
14	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:192
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:392
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:367
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:267
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.42 ms Po ostatnim zapytaniu: 4.73 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 4.221 MB Zwróconych wierszy: 8

SELECT id 
  FROM saf6i_template_styles 
  ORDER BY id

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	saf6i_template_styles	index	NULL	PRIMARY	4	NULL	8	Using index

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:314
9	JMFTemplate->setup()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:126
8	JMFTemplate->__construct()	JROOT/templates/jm-apartments/index.php:18
7	require JROOT/templates/jm-apartments/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.44 ms Po ostatnim zapytaniu: 15.79 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 4.429 MB Zwróconych wierszy: 24

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM saf6i_modules AS m

  LEFT JOIN saf6i_modules_menu AS mm 
  ON mm.moduleid = m.id

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-05-30 00:16:19') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-30 00:16:19') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 960 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	78	Using index condition; Using where; Uruchomiono metodę filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	bil2013_sch.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	bil2013_sch.m.id	3	Using where; Using index

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	Identyczny z wywołaniem linii niżej.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
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:581
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:461
11	JMFTemplate->countModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:454
10	JMFTemplate->checkModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:1685
9	JMFTemplate->getAllColumnsClasses()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:191
8	JMFTemplate->__construct()	JROOT/templates/jm-apartments/index.php:18
7	require JROOT/templates/jm-apartments/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.53 ms Po ostatnim zapytaniu: 5.19 ms Pamięć zapytania: 0.044 MB Pamięć przed zapytaniem: 4.580 MB Zwróconych wierszy: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM saf6i_fields AS a

  LEFT JOIN `saf6i_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN saf6i_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN saf6i_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN saf6i_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN saf6i_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Uruchomiono metodę filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	bil2013_sch.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.a.group_id	1	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
31	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
30	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
29	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
28	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
27	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
26	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
25	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
24	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
23	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
22	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
21	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
20	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
19	Joomla\CMS\Helper\ModuleHelper::renderModule()	Identyczny z wywołaniem linii niżej.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:599
16	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
15	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:754
14	JMFTemplate->renderModules()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:909
13	JMFTemplate->renderFlexiblock()	JROOT/templates/jm-apartments/tpl/blocks/footer-mod.php:14
12	include JROOT/templates/jm-apartments/tpl/blocks/footer-mod.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:674
11	JMFTemplate->renderBlock()	JROOT/templates/jm-apartments/tpl/contact.php:63
10	include JROOT/templates/jm-apartments/tpl/contact.php	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:674
9	JMFTemplate->renderBlock()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:688
8	JMFTemplate->renderScheme()	JROOT/templates/jm-apartments/index.php:19
7	require JROOT/templates/jm-apartments/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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.33 ms Po ostatnim zapytaniu: 5.78 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 4.709 MB Zwróconych wierszy: 1

SELECT manifest_cache 
  FROM saf6i_extensions 
  WHERE element='mod_djmegamenu' 
  LIMIT 1

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	saf6i_extensions	ref	element_clientid,element_folder_clientid	element_clientid	302	const	1	Using index condition

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/modules/mod_djmegamenu/helper.php:313
14	modDJMMHelper::getVersion()	JROOT/modules/mod_djmegamenu/mod_djmegamenu.php:80
13	include JROOT/modules/mod_djmegamenu/mod_djmegamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Identyczny z wywołaniem linii niżej.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:621
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
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]

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

WYBRANE tabele:

2 × SELECT subq.* 
  FROM (SELECT k.*, @num := @num + 1 AS position 
  FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
  FROM saf6i_djc2_items AS i  
  LEFT JOIN saf6i_djc2_categories as c 
  ON c.id = i.cat_id  
  LEFT JOIN saf6i_djc2_producers as p 
  ON p.id = i.producer_id

2 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM saf6i_fields AS a 
  LEFT JOIN `saf6i_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN saf6i_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN saf6i_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN saf6i_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN saf6i_fields_groups AS g 
  ON g.id = a.group_id

2 × SELECT f.*, group_concat(fo.id separator '|') as options, g.name as group_name, g.label as group_label, g.id as fgroup_id 
  FROM saf6i_djc2_items_extra_fields as f 
  LEFT JOIN saf6i_djc2_items_extra_fields_options as fo 
  ON fo.field_id=f.id 
  LEFT JOIN saf6i_djc2_items_extra_fields_groups as g 
  ON g.id=f.group_id

2 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value 
  FROM saf6i_djc2_items_extra_fields_values_int as fieldvalues 
  INNER JOIN saf6i_djc2_items as items 
  on items.id=fieldvalues.item_id 
  INNER JOIN saf6i_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id 
  LEFT JOIN saf6i_djc2_items_extra_fields_options as fieldoptions 
  ON fieldoptions.id = fieldvalues.value 
  AND fieldoptions.field_id = fields.id

2 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value 
  FROM saf6i_djc2_items_extra_fields_values_text as fieldvalues 
  INNER JOIN saf6i_djc2_items as items 
  on items.id=fieldvalues.item_id 
  INNER JOIN saf6i_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

2 × SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value 
  FROM saf6i_djc2_items_extra_fields_values_date as fieldvalues 
  INNER JOIN saf6i_djc2_items as items 
  on items.id=fieldvalues.item_id 
  INNER JOIN saf6i_djc2_items_extra_fields as fields 
  ON fields.id = fieldvalues.field_id

1 × SELECT `data` 
  FROM `saf6i_session`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM saf6i_modules AS m 
  LEFT JOIN saf6i_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN saf6i_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT id 
  FROM saf6i_template_styles

1 × SELECT *  
  FROM saf6i_djc2_files

1 × SELECT *  
  FROM saf6i_djc2_images

1 × SELECT distinct i.*, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,countries.country_name,states.name as state_name 
  FROM saf6i_djc2_items as i 
  LEFT JOIN saf6i_djc2_categories AS c 
  ON c.id = i.cat_id 
  LEFT JOIN saf6i_djc2_producers AS p 
  ON p.id = i.producer_id 
  LEFT JOIN saf6i_users AS ua 
  ON ua.id = i.created_by 
  LEFT JOIN saf6i_djc2_countries AS countries 
  ON countries.id = i.country 
  LEFT JOIN saf6i_djc2_countries_states AS states 
  ON states.id = i.state

1 × SELECT o.id, o.field_id 
  FROM saf6i_djc2_items_extra_fields_options AS o

1 × SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id 
  FROM saf6i_djc2_items_extra_fields as f 
  LEFT JOIN saf6i_djc2_items_extra_fields_groups as g 
  ON g.id=f.group_id

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

1 × select id, producer_id 
  from saf6i_djc2_items

1 × SELECT subq.position 
  FROM (SELECT k.*, @num := @num + 1 AS position 
  FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
  FROM saf6i_djc2_items AS i  
  LEFT JOIN saf6i_djc2_categories as c 
  ON c.id = i.cat_id  
  LEFT JOIN saf6i_djc2_producers as p 
  ON p.id = i.producer_id

1 × SELECT related_item 
  FROM saf6i_djc2_items_related

1 × SELECT `session_id` 
  FROM `saf6i_session`

1 × SELECT i.*, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,countries.country_name  
  FROM saf6i_djc2_items as i 
  LEFT JOIN saf6i_djc2_categories AS c 
  ON c.id = i.cat_id 
  LEFT JOIN saf6i_djc2_producers AS p 
  ON p.id = i.producer_id 
  LEFT JOIN saf6i_users AS ua 
  ON ua.id = i.created_by 
  LEFT JOIN saf6i_djc2_countries AS countries 
  ON countries.id = i.country

1 × select alias 
  from saf6i_djc2_items_extra_fields

1 × SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath 
  FROM saf6i_djc2_categories as i 
  INNER JOIN saf6i_djc2_images as img 
  on img.id=(select id 
  from saf6i_djc2_images

1 × SELECT c.*  
  FROM saf6i_djc2_categories AS c

1 × SELECT a.id 
  FROM saf6i_viewlevels AS a

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

1 × SELECT id, rules 
  FROM `saf6i_viewlevels

1 × SELECT manifest_cache 
  FROM saf6i_extensions

INNE tabele:

```
1 × DELETE  
  FROM `saf6i_session`
```

1 × INSERT INTO `saf6i_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('a9dae4c985f0e61cf458415872e6bd5b', 1, '1685405779', 0, '', 0

1 × UPDATE `saf6i_extensions` 
  SET `params` = '{\"mediaversion\":\"a2d30132c9c176af3f9f070b3714a808\"}'

1 × UPDATE saf6i_djc2_items 
  SET hits = hits + 1