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

Siłowniki liniowe

Obszary zastosowań:

ExMax-..+LIN, ExRun-..............siłowniki stosowane w strefach 1, 2, 21, 22
RedMax-..+LIN, RedRun-.........siłowniki stosowane w strefach 2, 22
InMax-..+LIN, InRun-.................siłowniki stosowane w strefach bezpiecznych

Właściwości siłowników elektrycznych:

Kompaktowe, proste w istalacji, wysoka klasa ochrony
Uniwersalne zasilanie 24 to 240 V AC/DC, z samoadaptacją
Bez lub ze sprężyną powrotną (sprężyna powrotna tylko dla serii ..Max + LIN)
Obudowa aluminiowa, stopień ochrony IP66
Zintegrowana grzałka do pracy w niższych temperaturach
Konfigurowalny czas pracy siłownika
Zintegrowane ręczne sterowanie
Dostępny model do zastosowań morskich
Przydatne akcesoria, na przykład wyłączniki krańcowe

ExRun...

ExRun...
Siłowniki liniowe do zaworów
Strefy: 1, 2, 21, 22

Więcej...

RedRun...

RedRun...
Siłowniki liniowe do zaworów
Strefy: 2, 22

Więcej...

InRun...

InRun...
Siłowniki liniowe do zaworów
Dla obszarów bezpiecznych (nie Ex)

Więcej...

Konsola diagnostyczna Joomla!

Sesja

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685412495,
                "last": 1685412495,
                "now": 1685412495
            },
            "token": "qZ8ipCCQOt8aXDFJXzrHtYRv8ZT0Ekeb"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Informacje o wydajności

Użycie pamięci

Zapytania do bazy danych

37 zapytań zarejestrowanych 27.84 ms

5 znalezionych duplikatów!

3 duplikatów: #9 #22 #27

2 duplikatów: #14 #25

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

DELETE 

  FROM `saf6i_session`

  WHERE `time` < '1685411595'

Objaśnienie

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

Profile

Status	Duration
Starting	0.15 ms
Checking permissions	0.02 ms
Opening tables	0.35 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Init for update	0.05 ms
Updating	0.09 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
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.29 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` = 'd2a5f01a828d7b99394154c203ffa2d4'

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.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.02 ms
Optimizing	0.02 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.02 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.24 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 1.472 MB Zwróconych wierszy: 0

SELECT `session_id`

  FROM `saf6i_session`

  WHERE `session_id` = 'd2a5f01a828d7b99394154c203ffa2d4' 
  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.44 ms Po ostatnim zapytaniu: 0.04 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 
('d2a5f01a828d7b99394154c203ffa2d4', 1, '1685412495', 0, '', 0)

Objaśnienie

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

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 for update	0.01 ms
Update	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.17 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.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.72 ms Po ostatnim zapytaniu: 8.41 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.09 ms
Checking permissions	0.01 ms
Opening tables	0.23 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Init	0.01 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 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.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: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.76 ms Po ostatnim zapytaniu: 0.04 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.19 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	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
Executing	0.07 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.02 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/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: 0.58 ms Po ostatnim zapytaniu: 38.60 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 2.594 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.17 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.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/router.php:271
10	DJCatalog2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1147
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.91 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.066 MB Pamięć przed zapytaniem: 2.600 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.05 ms
Checking permissions	0.01 ms
Opening tables	0.28 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 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.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.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
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/router.php:271
10	DJCatalog2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1147
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: 1.14 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 2.682 MB Zwróconych wierszy: 11

Duplikaty zapytań: #22 #27

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.06 ms
Checking permissions	0.01 ms
Opening tables	0.13 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 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
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.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.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.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
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/router.php:271
10	DJCatalog2ParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1147
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.85 ms Po ostatnim zapytaniu: 0.54 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 2.768 MB

UPDATE `saf6i_extensions`

  SET `params` = '{\"mediaversion\":\"1cf8c05ca235df28bb244ef4a8b23ff9\"}'

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

Objaśnienie

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

Profile

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.17 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Init for update	0.06 ms
Updating	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.27 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/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: 34.42 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 3.506 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.06 ms
Checking permissions	0.01 ms
Opening tables	0.24 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Init	0.02 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.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: 0.77 ms Po ostatnim zapytaniu: 9.59 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 3.633 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.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
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.13 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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
21	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
20	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
19	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
18	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
17	Joomla\CMS\User\User->authorise()	JROOT/components/com_djcatalog2/models/items.php:716
16	DJCatalog2ModelItems->_buildContentWhere()	JROOT/components/com_djcatalog2/models/items.php:268
15	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:235
14	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:215
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:118
11	DJCatalog2ViewItems->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.64 ms Po ostatnim zapytaniu: 0.71 ms Pamięć zapytania: 0.031 MB Pamięć przed zapytaniem: 3.695 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.07 ms
Checking permissions	0.01 ms
Opening tables	0.13 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 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.04 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:877
16	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:270
15	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:235
14	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:215
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:118
11	DJCatalog2ViewItems->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: 0.02 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 3.706 MB Zwróconych wierszy: 0

Duplikaty zapytań: #25

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.04 ms
Checking permissions	0.01 ms
Opening tables	0.17 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	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.03 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:887
16	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:270
15	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:235
14	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:215
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:118
11	DJCatalog2ViewItems->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: 3.01 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.119 MB Pamięć przed zapytaniem: 3.715 MB Zwróconych wierszy: 3

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

  INNER JOIN (SELECT ic.item_id 
  FROM saf6i_djc2_items_categories AS ic 
  INNER JOIN saf6i_djc2_categories AS c 
  ON c.id=ic.category_id 
  WHERE c.published = 1 
  AND c.access IN (1,1,5)  
  AND ic.category_id =15) as category_filter 
  ON i.id = category_filter.item_id

  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 (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-05-30 02:08:15') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 02:08:15') 
  AND i.published = 1 
  AND i.access IN (1,1,5) 
  AND i.parent_id=0

  ORDER BY  i.ordering asc, c.ordering asc 
  LIMIT 10

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_published,idx_published_parent_ordering,idx_access	PRIMARY	4	const	1	Using temporary; Uruchomiono metodę filesort
1	SIMPLE	ic	ref	PRIMARY,item_category	PRIMARY	4	const	6	Using index
1	SIMPLE	i	eq_ref	PRIMARY,idx_parent_id,idx_published,idx_access	PRIMARY	4	bil2013_sch.ic.item_id	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.i.cat_id	1
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	states	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.i.state	1	Using where

Profile

Status	Duration
Starting	0.12 ms
Checking permissions	0.01 ms
Opening tables	0.81 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.10 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.15 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.86 ms
Creating sort index	0.33 ms
Removing tmp table	0.11 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
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.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/components/com_djcatalog2/models/items.php:199
13	DJCatalog2ModelItems->_getList()	JROOT/components/com_djcatalog2/models/items.php:217
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:118
11	DJCatalog2ViewItems->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.72 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 3.842 MB Zwróconych wierszy: 0

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 IN (49,50,51)  
  AND (fields.visibility = 2 OR fields.visibility = 3)  
  AND fields.published = 1

  ORDER BY fieldvalues.field_id asc, fields.ordering asc, fieldoptions.ordering asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fieldvalues	ALL	idx_item_field	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	Using where; Using temporary; Uruchomiono metodę filesort
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
1	SIMPLE	items	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.fieldvalues.item_id	1	Using index

Profile

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.16 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 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.04 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/components/com_djcatalog2/models/items.php:968
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:229
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:118
11	DJCatalog2ViewItems->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.02 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 3.851 MB Zwróconych wierszy: 0

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 IN (49,50,51)  
  AND (fields.visibility = 2 OR fields.visibility = 3)  
  AND fields.published = 1

  ORDER BY fieldvalues.field_id asc, fields.ordering asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fieldvalues	ALL	idx_item_field	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	Using where; Uruchomiono metodę filesort
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	bil2013_sch.fieldvalues.field_id	1	Using where
1	SIMPLE	items	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.fieldvalues.item_id	1	Using index

Profile

Status	Duration
Starting	0.07 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
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:971
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:229
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:118
11	DJCatalog2ViewItems->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.59 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 3.859 MB Zwróconych wierszy: 0

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 IN (49,50,51)  
  AND (fields.visibility = 2 OR fields.visibility = 3)  
  AND fields.published = 1

  ORDER BY fieldvalues.field_id asc, fields.ordering asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fieldvalues	ALL	item_field	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	Using where; Uruchomiono metodę filesort
1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	bil2013_sch.fieldvalues.field_id	1	Using where
1	SIMPLE	items	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.fieldvalues.item_id	1	Using index

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.14 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 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.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.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/components/com_djcatalog2/models/items.php:974
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:229
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:118
11	DJCatalog2ViewItems->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.53 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 3.869 MB Zwróconych wierszy: 3

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_items as i

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

  WHERE i.id IN (49,50,51)

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	i	index	PRIMARY	idx_cat_id	4	NULL	23	Using where; 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.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	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.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.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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1004
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:229
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:118
11	DJCatalog2ViewItems->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.64 ms Po ostatnim zapytaniu: 1.81 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 3.983 MB Zwróconych wierszy: 1

SELECT COUNT(distinct (i.id))

  FROM saf6i_djc2_items as i

  INNER JOIN (SELECT ic.item_id 
  FROM saf6i_djc2_items_categories AS ic 
  INNER JOIN saf6i_djc2_categories AS c 
  ON c.id=ic.category_id 
  WHERE c.published = 1 
  AND c.access IN (1,1,5)  
  AND ic.category_id =15) as category_filter 
  ON i.id = category_filter.item_id

  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 (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-05-30 02:08:15') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 02:08:15') 
  AND i.published = 1 
  AND i.access IN (1,1,5) 
  AND i.parent_id=0 
  LIMIT 10

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_published,idx_published_parent_ordering,idx_access	PRIMARY	4	const	1
1	SIMPLE	ic	ref	PRIMARY,item_category	PRIMARY	4	const	6	Using index
1	SIMPLE	i	eq_ref	PRIMARY,idx_parent_id,idx_published,idx_access	PRIMARY	4	bil2013_sch.ic.item_id	1	Using where

Profile

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.04 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/items.php:248
14	DJCatalog2ModelItems->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_djcatalog2/views/items/view.html.php:120
11	DJCatalog2ViewItems->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.43 ms Po ostatnim zapytaniu: 2.29 ms Pamięć zapytania: 0.056 MB Pamięć przed zapytaniem: 4.052 MB Zwróconych wierszy: 8

SELECT c.*  
  FROM saf6i_djc2_categories AS c  
  WHERE c.published=1 
  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_published_parent_ordering	4	const	8	Using where

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.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.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/administrator/components/com_djcatalog2/lib/categories.php:298
15	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
14	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
13	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/items.php:1039
12	DJCatalog2ModelItems->getProducers()	JROOT/components/com_djcatalog2/views/items/view.html.php:168
11	DJCatalog2ViewItems->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.87 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 4.124 MB Zwróconych wierszy: 11

Duplikaty zapytań: #9 #27

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.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.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	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.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.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.01 ms
Starting cleanup	0.02 ms
Freeing items	0.04 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/administrator/components/com_djcatalog2/lib/categories.php:305
15	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
14	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
13	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/items.php:1039
12	DJCatalog2ModelItems->getProducers()	JROOT/components/com_djcatalog2/views/items/view.html.php:168
11	DJCatalog2ViewItems->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.50 ms Po ostatnim zapytaniu: 0.11 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 4.145 MB Zwróconych wierszy: 0

SELECT DISTINCT a.id, a.name as text  
  FROM saf6i_djc2_producers as a  
  INNER JOIN saf6i_djc2_items AS i 
  ON a.id = i.producer_id 
  AND i.published = 1 
  INNER JOIN saf6i_djc2_items_categories AS c 
  ON c.item_id = i.id  
  WHERE c.category_id IN (15) 
  AND a.published=1  
  GROUP BY a.id, a.name 
  ORDER BY a.name asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	PRIMARY,item_category	PRIMARY	4	const	6	Using index; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	i	eq_ref	PRIMARY,idx_producer_id,idx_published	PRIMARY	4	bil2013_sch.c.item_id	1	Using where
1	SIMPLE	a	ALL	PRIMARY,idx_published	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.05 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.04 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/models/items.php:1058
12	DJCatalog2ModelItems->getProducers()	JROOT/components/com_djcatalog2/views/items/view.html.php:168
11	DJCatalog2ViewItems->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: 10.91 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 4.196 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.visibility = 2 or f.visibility = 3) 
  and 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 where; Using temporary; Uruchomiono metodę filesort
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.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.03 ms
Preparing	0.02 ms
Creating tmp table	0.02 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.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/items.php:877
12	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/views/items/view.html.php:210
11	DJCatalog2ViewItems->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.32 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 4.205 MB Zwróconych wierszy: 0

Duplikaty zapytań: #14

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.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.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.03 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/items.php:887
12	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/views/items/view.html.php:210
11	DJCatalog2ViewItems->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.45 ms Po ostatnim zapytaniu: 0.10 ms Pamięć zapytania: 0.057 MB Pamięć przed zapytaniem: 4.210 MB Zwróconych wierszy: 8

SELECT c.*  
  FROM saf6i_djc2_categories AS c  
  WHERE c.published=1 
  AND c.access IN (1,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.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.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.13 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:298
17	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
16	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
15	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/items.php:731
14	DJCatalog2ModelItems->_buildContentWhere()	JROOT/components/com_djcatalog2/models/items.php:268
13	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:1265
12	DJCatalog2ModelItems->getFieldGroups()	JROOT/components/com_djcatalog2/views/items/view.html.php:211
11	DJCatalog2ViewItems->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: 0.04 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 4.283 MB Zwróconych wierszy: 11

Duplikaty zapytań: #9 #22

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.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	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.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.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.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
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.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/administrator/components/com_djcatalog2/lib/categories.php:305
17	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
16	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
15	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/items.php:731
14	DJCatalog2ModelItems->_buildContentWhere()	JROOT/components/com_djcatalog2/models/items.php:268
13	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:1265
12	DJCatalog2ModelItems->getFieldGroups()	JROOT/components/com_djcatalog2/views/items/view.html.php:211
11	DJCatalog2ViewItems->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.11 ms Po ostatnim zapytaniu: 0.14 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 4.315 MB Zwróconych wierszy: 0

SELECT f.*

  FROM saf6i_djc2_items_extra_fields as f

  INNER JOIN saf6i_djc2_items_groups as i 
  on i.group_id = f.group_id

  INNER JOIN (
SELECT distinct i.id

  FROM saf6i_djc2_items as i

  INNER JOIN (SELECT ic.item_id 
  FROM saf6i_djc2_items_categories AS ic 
  INNER JOIN saf6i_djc2_categories AS c 
  ON c.id=ic.category_id 
  WHERE c.published = 1 
  AND c.access IN (1,1,5)  
  AND ic.category_id IN (15)) as category_filter 
  ON i.id = category_filter.item_id

  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 (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-05-30 02:08:15') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 02:08:15') 
  AND i.published = 1 
  AND i.access IN (1,1,5) 
  AND i.parent_id=0

  ORDER BY  i.id asc , i.ordering, c.ordering ) as iq 
  on iq.id = i.item_id

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

  GROUP BY f.name, f.alias, f.id, f.group_id

  ORDER BY f.group_id asc, f.ordering asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	f	ref	idx_published,idx_separate_column,idx_group_id	idx_published	4	const	1	Using where; Using temporary; Uruchomiono metodę filesort
1	PRIMARY	i	ref	PRIMARY,item_group	PRIMARY	4	bil2013_sch.f.group_id	9	Using index
1	PRIMARY	<derived2>	ref	key0	key0	4	bil2013_sch.i.item_id	1
2	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering,idx_access	PRIMARY	4	const	1	Using temporary; Uruchomiono metodę filesort
2	DERIVED	ic	ref	PRIMARY,item_category	PRIMARY	4	const	6	Using index
2	DERIVED	i	eq_ref	PRIMARY,idx_parent_id,idx_published,idx_access	PRIMARY	4	bil2013_sch.ic.item_id	1	Using where
2	DERIVED	c	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.i.cat_id	1

Profile

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.20 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Init	0.06 ms
Optimizing	0.03 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Statistics	0.05 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.03 ms
Removing tmp table	0.01 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
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.04 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:1691
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1277
12	DJCatalog2ModelItems->getFieldGroups()	JROOT/components/com_djcatalog2/views/items/view.html.php:211
11	DJCatalog2ViewItems->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.77 ms Po ostatnim zapytaniu: 0.19 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 4.323 MB Zwróconych wierszy: 0

SELECT f.*

  FROM saf6i_djc2_items_extra_fields as f

  INNER JOIN saf6i_djc2_items_groups as i 
  on i.group_id = f.group_id

  INNER JOIN (
SELECT distinct i.id

  FROM saf6i_djc2_items as i

  INNER JOIN (SELECT ic.item_id 
  FROM saf6i_djc2_items_categories AS ic 
  INNER JOIN saf6i_djc2_categories AS c 
  ON c.id=ic.category_id 
  WHERE c.published = 1 
  AND c.access IN (1,1,5)  
  AND ic.category_id IN (15)) as category_filter 
  ON i.id = category_filter.item_id

  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 (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-05-30 02:08:15') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 02:08:15') 
  AND i.published = 1 
  AND i.access IN (1,1,5) 
  AND i.parent_id=0

  ORDER BY  i.id asc , i.ordering, c.ordering ) as iq 
  on iq.id = i.item_id

  WHERE f.published = 1 
  and f.sortable = 1 
  and (f.type = 'text' OR f.type = 'radio' OR f.type = 'select' OR f.type = 'calendar')

  GROUP BY f.name, f.alias, f.id, f.group_id

  ORDER BY f.group_id asc, f.ordering asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	f	ref	idx_published,idx_type,idx_group_id	idx_published	4	const	1	Using where; Using temporary; Uruchomiono metodę filesort
1	PRIMARY	i	ref	PRIMARY,item_group	PRIMARY	4	bil2013_sch.f.group_id	9	Using index
1	PRIMARY	<derived2>	ref	key0	key0	4	bil2013_sch.i.item_id	1
2	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering,idx_access	PRIMARY	4	const	1	Using temporary; Uruchomiono metodę filesort
2	DERIVED	ic	ref	PRIMARY,item_category	PRIMARY	4	const	6	Using index
2	DERIVED	i	eq_ref	PRIMARY,idx_parent_id,idx_published,idx_access	PRIMARY	4	bil2013_sch.ic.item_id	1	Using where
2	DERIVED	c	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.i.cat_id	1

Profile

Status	Duration
Starting	0.11 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.06 ms
Optimizing	0.02 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Statistics	0.03 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
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
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.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/items.php:1317
12	DJCatalog2ModelItems->getSortables()	JROOT/components/com_djcatalog2/views/items/view.html.php:212
11	DJCatalog2ViewItems->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.60 ms Po ostatnim zapytaniu: 3.12 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 4.391 MB Zwróconych wierszy: 1

SELECT *  
  FROM saf6i_djc2_images  
  WHERE item_id=15 	
  AND type='category' 
  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.16 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.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.02 ms
Reset for next command	0.04 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/items/view.html.php:396
12	DJCatalog2ViewItems->_prepareDocument()	JROOT/components/com_djcatalog2/views/items/view.html.php:213
11	DJCatalog2ViewItems->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.53 ms Po ostatnim zapytaniu: 4.21 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 4.507 MB Zwróconych wierszy: 0

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

  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 
  and f.filterable = 1 
  and (f.type = 'checkbox' or f.type = 'radio' or f.type = 'select' or f.type = 'text')  
  and (g.id in (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	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.14 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djc2filters/helper.php:179
18	DJC2FiltersModuleHelper::getAttributes()	JROOT/modules/mod_djc2filters/helper.php:42
17	DJC2FiltersModuleHelper::getData()	JROOT/modules/mod_djc2filters/mod_djc2filters.php:64
16	include JROOT/modules/mod_djc2filters/mod_djc2filters.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_djcatalog2/views/items/tmpl/default.php:35
14	include JROOT/components/com_djcatalog2/views/items/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/items/view.html.php:215
11	DJCatalog2ViewItems->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.03 ms Po ostatnim zapytaniu: 0.19 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 4.548 MB Zwróconych wierszy: 0

SELECT ef.id as field_id, ef.name as field_name, opt.id as option_id, opt.value as option_value, count(fv.item_id) as item_count

  FROM saf6i_djc2_items_extra_fields_values_int as fv

  INNER JOIN saf6i_djc2_items_extra_fields as ef 
  on ef.id=fv.field_id

  INNER JOIN saf6i_djc2_items_extra_fields_options as opt 
  on opt.field_id=ef.id 
  and opt.id=fv.value

  INNER JOIN (
SELECT distinct i.id

  FROM saf6i_djc2_items as i

  INNER JOIN (SELECT ic.item_id 
  FROM saf6i_djc2_items_categories AS ic 
  INNER JOIN saf6i_djc2_categories AS c 
  ON c.id=ic.category_id 
  WHERE c.published = 1 
  AND c.access IN (1,1,5)  
  AND ic.category_id IN (15)) as category_filter 
  ON i.id = category_filter.item_id

  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 (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-05-30 02:08:15') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 02:08:15') 
  AND i.published = 1 
  AND i.access IN (1,1,5) 
  AND i.parent_id=0

  ORDER BY  i.id asc , i.ordering, c.ordering ) as item_ids 
  on fv.item_id = item_ids.id

  GROUP BY ef.id, opt.value

  ORDER BY ef.name asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	fv	ALL	idx_item_field,idx_value	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	Using temporary; Uruchomiono metodę filesort
1	PRIMARY	ef	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.fv.field_id	1
1	PRIMARY	opt	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	bil2013_sch.fv.value	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	4	bil2013_sch.fv.item_id	1
2	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering,idx_access	PRIMARY	4	const	1	Using temporary; Uruchomiono metodę filesort
2	DERIVED	ic	ref	PRIMARY,item_category	PRIMARY	4	const	6	Using index
2	DERIVED	i	eq_ref	PRIMARY,idx_parent_id,idx_published,idx_access	PRIMARY	4	bil2013_sch.ic.item_id	1	Using where
2	DERIVED	c	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.i.cat_id	1

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.02 ms
Table lock	0.01 ms
Init	0.08 ms
Optimizing	0.02 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.04 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Statistics	0.04 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.02 ms
Removing tmp table	0.01 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
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.06 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djc2filters/helper.php:357
18	DJC2FiltersModuleHelper::getCountersApprox()	JROOT/modules/mod_djc2filters/helper.php:43
17	DJC2FiltersModuleHelper::getData()	JROOT/modules/mod_djc2filters/mod_djc2filters.php:64
16	include JROOT/modules/mod_djc2filters/mod_djc2filters.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_djcatalog2/views/items/tmpl/default.php:35
14	include JROOT/components/com_djcatalog2/views/items/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/items/view.html.php:215
11	DJCatalog2ViewItems->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.03 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 4.566 MB Zwróconych wierszy: 0

SELECT ef.id as field_id, ef.name as field_name, "" as option_id, "" as option_value, count(fv.item_id) as item_count

  FROM saf6i_djc2_items_extra_fields_values_text as fv

  INNER JOIN saf6i_djc2_items_extra_fields as ef 
  on ef.id=fv.field_id 
  AND ef.filterable = 1

  INNER JOIN (
SELECT distinct i.id

  FROM saf6i_djc2_items as i

  INNER JOIN (SELECT ic.item_id 
  FROM saf6i_djc2_items_categories AS ic 
  INNER JOIN saf6i_djc2_categories AS c 
  ON c.id=ic.category_id 
  WHERE c.published = 1 
  AND c.access IN (1,1,5)  
  AND ic.category_id IN (15)) as category_filter 
  ON i.id = category_filter.item_id

  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 (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-05-30 02:08:15') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-05-30 02:08:15') 
  AND i.published = 1 
  AND i.access IN (1,1,5) 
  AND i.parent_id=0

  ORDER BY  i.id asc , i.ordering, c.ordering ) as item_ids 
  on fv.item_id = item_ids.id

  GROUP BY ef.id

  ORDER BY ef.name asc

Objaśnienie

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	fv	index	idx_item_field	idx_item_field	8	NULL	1	Using index; Using temporary; Uruchomiono metodę filesort
1	PRIMARY	ef	eq_ref	PRIMARY,idx_filterable	PRIMARY	4	bil2013_sch.fv.field_id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	4	bil2013_sch.fv.item_id	1
2	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering,idx_access	PRIMARY	4	const	1	Using temporary; Uruchomiono metodę filesort
2	DERIVED	ic	ref	PRIMARY,item_category	PRIMARY	4	const	6	Using index
2	DERIVED	i	eq_ref	PRIMARY,idx_parent_id,idx_published,idx_access	PRIMARY	4	bil2013_sch.ic.item_id	1	Using where
2	DERIVED	c	eq_ref	PRIMARY	PRIMARY	4	bil2013_sch.i.cat_id	1

Profile

Status	Duration
Starting	0.12 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.05 ms
Optimizing	0.02 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.01 ms
Removing tmp table	0.01 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
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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djc2filters/helper.php:368
18	DJC2FiltersModuleHelper::getCountersApprox()	JROOT/modules/mod_djc2filters/helper.php:43
17	DJC2FiltersModuleHelper::getData()	JROOT/modules/mod_djc2filters/mod_djc2filters.php:64
16	include JROOT/modules/mod_djc2filters/mod_djc2filters.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_djcatalog2/views/items/tmpl/default.php:35
14	include JROOT/components/com_djcatalog2/views/items/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/items/view.html.php:215
11	DJCatalog2ViewItems->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.33 ms Po ostatnim zapytaniu: 3.18 ms Pamięć zapytania: 0.040 MB Pamięć przed zapytaniem: 4.543 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.category.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.10 ms
Checking permissions	0.01 ms
Opening tables	0.68 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.07 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 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.04 ms
Updating status	0.02 ms
Reset for next command	0.01 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/items/tmpl/default.php:119
14	include JROOT/components/com_djcatalog2/views/items/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/items/view.html.php:215
11	DJCatalog2ViewItems->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.44 ms Po ostatnim zapytaniu: 2.00 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 4.573 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.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	0.01 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
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.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/helpers/route.php:77
17	DJCatalogHelperRoute::getItemRoute()	JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php:42
16	include JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_djcatalog2/views/items/tmpl/default.php:204
14	include JROOT/components/com_djcatalog2/views/items/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/items/view.html.php:215
11	DJCatalog2ViewItems->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.38 ms Pamięć zapytania: 0.041 MB Pamięć przed zapytaniem: 4.587 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.items.intro_desc' 
  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.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.05 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.04 ms
Sorting result	0.02 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.04 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
26	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
25	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
24	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
23	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
21	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
20	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
18	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
17	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php:272
16	include JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_djcatalog2/views/items/tmpl/default.php:204
14	include JROOT/components/com_djcatalog2/views/items/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/items/view.html.php:215
11	DJCatalog2ViewItems->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: 5.56 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 4.676 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.06 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
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.04 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/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]

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

WYBRANE tabele:

3 × 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

3 × SELECT c.*  
  FROM saf6i_djc2_categories AS c

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.*, 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

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

2 × SELECT f.* 
  FROM saf6i_djc2_items_extra_fields as f 
  INNER JOIN saf6i_djc2_items_groups as i 
  on i.group_id = f.group_id 
  INNER JOIN ( SELECT distinct i.id 
  FROM saf6i_djc2_items as i 
  INNER JOIN (SELECT ic.item_id 
  FROM saf6i_djc2_items_categories AS ic 
  INNER JOIN saf6i_djc2_categories AS c 
  ON c.id=ic.category_id

1 × SELECT `data` 
  FROM `saf6i_session`

1 × SELECT COUNT(distinct (i.id)) 
  FROM saf6i_djc2_items as i 
  INNER JOIN (SELECT ic.item_id 
  FROM saf6i_djc2_items_categories AS ic 
  INNER JOIN saf6i_djc2_categories AS c 
  ON c.id=ic.category_id

1 × select id, producer_id 
  from saf6i_djc2_items

1 × SELECT ef.id as field_id, ef.name as field_name, "" as option_id, "" as option_value, count(fv.item_id) as item_count 
  FROM saf6i_djc2_items_extra_fields_values_text as fv 
  INNER JOIN saf6i_djc2_items_extra_fields as ef 
  on ef.id=fv.field_id 
  AND ef.filterable = 1 
  INNER JOIN ( SELECT distinct i.id 
  FROM saf6i_djc2_items as i 
  INNER JOIN (SELECT ic.item_id 
  FROM saf6i_djc2_items_categories AS ic 
  INNER JOIN saf6i_djc2_categories AS c 
  ON c.id=ic.category_id

1 × SELECT ef.id as field_id, ef.name as field_name, opt.id as option_id, opt.value as option_value, count(fv.item_id) as item_count 
  FROM saf6i_djc2_items_extra_fields_values_int as fv 
  INNER JOIN saf6i_djc2_items_extra_fields as ef 
  on ef.id=fv.field_id 
  INNER JOIN saf6i_djc2_items_extra_fields_options as opt 
  on opt.field_id=ef.id 
  and opt.id=fv.value 
  INNER JOIN ( SELECT distinct i.id 
  FROM saf6i_djc2_items as i 
  INNER JOIN (SELECT ic.item_id 
  FROM saf6i_djc2_items_categories AS ic 
  INNER JOIN saf6i_djc2_categories AS c 
  ON c.id=ic.category_id

1 × SELECT f.*, g.name as group_name, g.label as group_label 
  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 *  
  FROM saf6i_djc2_images

1 × SELECT DISTINCT a.id, a.name as text  
  FROM saf6i_djc2_producers as a  
  INNER JOIN saf6i_djc2_items AS i 
  ON a.id = i.producer_id 
  AND i.published = 1 
  INNER JOIN saf6i_djc2_items_categories AS c 
  ON c.item_id = i.id

1 × 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

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_items as i 
  INNER JOIN saf6i_djc2_images as img 
  on img.id=(select id 
  from saf6i_djc2_images

1 × 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 `session_id` 
  FROM `saf6i_session`

1 × 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

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 
  INNER JOIN (SELECT ic.item_id 
  FROM saf6i_djc2_items_categories AS ic 
  INNER JOIN saf6i_djc2_categories AS c 
  ON c.id=ic.category_id

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

1 × select alias 
  from saf6i_djc2_items_extra_fields

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 id 
  FROM saf6i_template_styles

INNE tabele:

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

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

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

Main Menu

Siłowniki liniowe

ExRun...

RedRun...

InRun...

Katalog produktów

Klasyfikacja Ex

Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Czas

Pamięć

Użycie pamięci

Zapytania do bazy danych

37 zapytań zarejestrowanych 27.84 ms

5 znalezionych duplikatów!

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

WYBRANE tabele:

INNE tabele: