Budujemy najfajniejsze place zabaw

Ixo

Name: Educarium spółka z o.o.
Address: Grunwaldzka 207, Bydgoszcz, kujawsko-pomorskie, 85-451
Telephone: 523200640

Seria IXO została zaprojektowana dla dzieci w wieku 6 do 14 lat. Pozwala ona na sprawdzenie swoich możliwości fizycznych, konkurowanie ze sobą, prezentację swoich umiejętności i ustalenie swoich własnych zasad zabawy zarówno chłopcom, jak i dziewczynkom.

Tradycyjne zjeżdżalnie zostały zastąpione zjeżdżalniami ekspresowymi, a w miejscu tradycyjnych huśtawek znajdziemy wirujące huśtawki "Gyro".

W konstrukcji wykorzystano stal nierdzewną i słupy z drewna klejonego warstwowo, których zadaniem jest zapewnienie stabilności. Dzięki połączeniu tych dwóch elementów otrzymaliśmy urządzenia, które są trwałe i wytrzymałe, nawet przy intensywnym użytkowaniu. Aby urządzenia wielofunkcyjne IXO jeszcze lepiej mogły wkomponować się w miejskie, lub bardziej naturalne, otoczenie, umożliwiliśmy wybór jednego z dwóch wariantów słupów: drewniane lub metalowe.

Filtruj

Szukaj

Plac zabaw Ixo J2521

Szerokość	5,14
Długość	4,81
Wysokość upadku	1,95

Plac zabaw Ixo J2521M

Szerokość	5,14
Długość	4,81
Wysokość upadku	1.95

Plac zabaw Ixo J2523

Szerokość	7,92
Długość	4,98
Wysokość upadku	2,4

Plac zabaw Ixo J2523M

Szerokość	7,92
Długość	4,98
Wysokość upadku	2,4

Plac zabaw Ixo J2524

Szerokość	6,6
Długość	3,9
Wysokość upadku	2,5

Plac zabaw Ixo J2524M

Szerokość	6,6
Długość	3,9
Wysokość upadku	2,5

Plac zabaw Ixo J2534

Szerokość	4,1
Długość	3,5
Wysokość upadku	2,5

Plac zabaw Ixo J2534M

Szerokość	4,1
Długość	3,5
Wysokość upadku	2,5

Plac zabaw Ixo J2562

Szerokość	8,89
Długość	3,54
Wysokość upadku	2,4

Plac zabaw Ixo J2562M

Szerokość	8,89
Długość	3,54
Wysokość upadku	2,4

Plac zabaw Ixo J2568

Szerokość	15,0
Długość	9,41
Wysokość upadku	2,9

Plac zabaw Ixo J2568M

Szerokość	13,0
Długość	9,8
Wysokość upadku	2,9

Plac zabaw Ixo J2530

Szerokość	11,56
Długość	5,66
Wysokość upadku	2,4

Plac zabaw Ixo J2530M

Szerokość	11,56
Długość	5,66
Wysokość upadku	2,4

Plac zabaw Ixo J2531

Szerokość	8,72
Długość	6,94
Wysokość upadku	2,9

Plac zabaw Ixo J2531M

Szerokość	8,72
Długość	6,94
Wysokość upadku	2,4

Plac zabaw Ixo J2532

Szerokość	8,05
Długość	7,36
Wysokość upadku	3,0

Plac zabaw Ixo J2532M

Szerokość	8,05
Długość	7,36
Wysokość upadku	3

Konsola diagnostyczna Joomla!

Sesja

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1656681447,
                "last": 1656681447,
                "now": 1656681447
            },
            "client": {
                "forwarded": "44.192.65.228"
            },
            "token": "uJh37HzbyQYavzdVLeuP567PWvxsA78L"
        },
        "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

Czas

Pamięć

Czas: 10.89 ms / 10.89 ms Pamięć: 1.993 MB / 2.41 MB Application: afterLoad

Czas: 58.52 ms / 69.41 ms Pamięć: 7.616 MB / 10.03 MB Application: afterInitialise

Czas: 18.83 ms / 88.23 ms Pamięć: 3.947 MB / 13.98 MB Application: afterRoute

Czas: 0.46 ms / 88.70 ms Pamięć: 0.109 MB / 14.08 MB Application: beforeRenderComponent com_djcatalog2

Czas: 23.52 ms / 112.22 ms Pamięć: 3.945 MB / 18.03 MB Application: Before Access::preloadComponents (all components)

Czas: 1.15 ms / 113.37 ms Pamięć: 0.066 MB / 18.09 MB Application: After Access::preloadComponents (all components)

Czas: 0.02 ms / 113.39 ms Pamięć: -0.003 MB / 18.09 MB Application: Before Access::getAssetRules (id:200 name:com_djcatalog2)

Czas: 0.28 ms / 113.67 ms Pamięć: 0.029 MB / 18.12 MB Application: After Access::getAssetRules (id:200 name:com_djcatalog2)

Czas: 0.88 ms / 114.55 ms Pamięć: 0.142 MB / 18.26 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Czas: 0.03 ms / 114.58 ms Pamięć: 0.007 MB / 18.27 MB Application: After Access::getAssetRules (id:1 name:root.1)

Czas: 153.03 ms / 267.61 ms Pamięć: 4.756 MB / 23.03 MB Application: afterRenderComponent com_djcatalog2

Czas: 1.16 ms / 268.77 ms Pamięć: 0.086 MB / 23.11 MB Application: afterDispatch

Czas: 11.11 ms / 279.87 ms Pamięć: 1.092 MB / 24.20 MB Application: beforeRenderModule mod_menu (Nasze witryny)

Czas: 1.94 ms / 281.81 ms Pamięć: 0.097 MB / 24.30 MB Application: afterRenderModule mod_menu (Nasze witryny)

Czas: 0.27 ms / 282.08 ms Pamięć: -0.003 MB / 24.30 MB Application: beforeRenderModule mod_menu (Pozostałe)

Czas: 0.91 ms / 282.99 ms Pamięć: 0.027 MB / 24.32 MB Application: afterRenderModule mod_menu (Pozostałe)

Czas: 3.73 ms / 286.71 ms Pamięć: 1.031 MB / 25.36 MB Application: beforeRenderModule mod_breadcrumbs (breadcrumbs)

Czas: 1.31 ms / 288.02 ms Pamięć: 0.031 MB / 25.39 MB Application: afterRenderModule mod_breadcrumbs (breadcrumbs)

Czas: 0.17 ms / 288.19 ms Pamięć: 0.027 MB / 25.41 MB Application: beforeRenderModule mod_djmediatools (Ixo)

Czas: 221.47 ms / 509.66 ms Pamięć: 0.297 MB / 25.71 MB Application: afterRenderModule mod_djmediatools (Ixo)

Czas: 0.48 ms / 510.14 ms Pamięć: -0.040 MB / 25.67 MB Application: beforeRenderModule mod_djmegamenu (DJ-Megamenu)

Czas: 86.70 ms / 596.85 ms Pamięć: 0.373 MB / 26.04 MB Application: afterRenderModule mod_djmegamenu (DJ-Megamenu)

Czas: 0.45 ms / 597.30 ms Pamięć: -0.048 MB / 26.00 MB Application: beforeRenderModule mod_menu (Top menu)

Czas: 1.00 ms / 598.30 ms Pamięć: 0.012 MB / 26.01 MB Application: afterRenderModule mod_menu (Top menu)

Czas: 0.25 ms / 598.55 ms Pamięć: -0.000 MB / 26.01 MB Application: beforeRenderModule mod_search (Search)

Czas: 1.10 ms / 599.66 ms Pamięć: 0.018 MB / 26.03 MB Application: afterRenderModule mod_search (Search)

Czas: 0.14 ms / 599.80 ms Pamięć: -0.025 MB / 26.00 MB Application: beforeRenderModule mod_djc2cart (Koszyk)

Czas: 0.65 ms / 600.45 ms Pamięć: 0.007 MB / 26.01 MB Application: afterRenderModule mod_djc2cart (Koszyk)

Czas: 0.15 ms / 600.59 ms Pamięć: -0.000 MB / 26.01 MB Application: beforeRenderModule mod_djmegamenu_button (Main Menu - Mobile Button)

Czas: 0.11 ms / 600.70 ms Pamięć: 0.006 MB / 26.01 MB Application: afterRenderModule mod_djmegamenu_button (Main Menu - Mobile Button)

Czas: 480.91 ms / 1081.61 ms Pamięć: 1.847 MB / 27.86 MB Application: afterRender

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

Użycie pamięci

Zapytania do bazy danych

59 zapytań zarejestrowanych 76.69 ms

6 znalezionych duplikatów!

4 duplikatów: #18 #27 #37 #41

2 duplikatów: #26 #36

Czas zapytania: 0.47 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 4.213 MB Zwróconych wierszy: 0

SELECT `session_id`

  FROM `j25_session`

  WHERE `session_id` = X'3230373636306165633733373763633837313136323763353537303635393537' 
  LIMIT 1

Objaśnienie

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
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.41 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.004 MB Pamięć przed zapytaniem: 4.218 MB

INSERT INTO `j25_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3230373636306165633733373763633837313136323763353537303635393537', 1, 1656681447, 0, '', 0)

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
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.48 ms Po ostatnim zapytaniu: 3.89 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.841 MB Zwróconych wierszy: 5

SELECT id, rules

  FROM `j25_viewlevels`

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.38 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.853 MB Zwróconych wierszy: 2

SELECT b.id

  FROM j25_usergroups AS a

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

  WHERE a.id = 9

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.30 ms Po ostatnim zapytaniu: 4.71 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 5.669 MB Zwróconych wierszy: 0

SELECT `path`

  FROM j25_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.27 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 5.675 MB Zwróconych wierszy: 0

SELECT `file`

  FROM j25_rsfirewall_hashes

  WHERE `type`='protect'

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.47 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 5.680 MB Zwróconych wierszy: 65

SELECT *

  FROM j25_rsfirewall_configuration

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:27
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.55 ms Po ostatnim zapytaniu: 3.08 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 6.243 MB Zwróconych wierszy: 10

SHOW FULL COLUMNS 
  FROM `j25_rsfirewall_logs`

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
11	RsfirewallTableLogs->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:77
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:47
7	plgSystemRsfirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.46 ms Po ostatnim zapytaniu: 17.89 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 8.962 MB Zwróconych wierszy: 1

SELECT `params`

  FROM `j25_extensions`

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

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/fof40/Params/Params.php:55
12	FOF40\Params\Params->reload()	JROOT/libraries/fof40/Params/Params.php:40
11	FOF40\Params\Params->__construct()	JROOT/libraries/fof40/Container/Container.php:281
10	FOF40\Container\Container->FOF40\Container\{closure}()	JROOT/libraries/fof40/Pimple/Container.php:115
9	FOF40\Pimple\Container->offsetGet()	JROOT/libraries/fof40/Container/ContainerBase.php:27
8	FOF40\Container\ContainerBase->__get()	JROOT/plugins/system/jchoptimize/jchoptimize.php:123
7	plgSystemJchoptimize->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.29 ms Po ostatnim zapytaniu: 4.85 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 9.844 MB Zwróconych wierszy: 31

SELECT *

  FROM j25_rsform_config

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:26
8	plgSystemRsformdeletesubmissions->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.37 ms Po ostatnim zapytaniu: 9.74 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 12.433 MB Zwróconych wierszy: 0

SELECT *

  FROM j25_rsfirewall_hashes

  WHERE (`type`='3.10.10' OR `type`='protect') 
  AND `flag`!='C'

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1049
8	plgSystemRsfirewall->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:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.24 ms Po ostatnim zapytaniu: 0.29 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.469 MB Zwróconych wierszy: 0

SELECT *

  FROM j25_rsfirewall_snapshots

  WHERE `type`='protect'

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
9	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1072
8	plgSystemRsfirewall->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:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.29 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.475 MB Zwróconych wierszy: 0

SELECT `ip`,`reason`

  FROM j25_rsfirewall_lists

  WHERE (`ip`='44.192.65.228' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_rsfirewall_lists	NULL	ref	published,type,ip	published	1	const	1	100.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:144
9	plgSystemRsfirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1108
8	plgSystemRsfirewall->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:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.21 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.481 MB Zwróconych wierszy: 0

SELECT `ip`,`reason`

  FROM j25_rsfirewall_lists

  WHERE (`ip`='44.192.65.228' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_rsfirewall_lists	NULL	ref	published,type,ip	published	1	const	1	100.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:165
10	plgSystemRsfirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:134
9	plgSystemRsfirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1112
8	plgSystemRsfirewall->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:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.22 ms Po ostatnim zapytaniu: 0.48 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.531 MB Zwróconych wierszy: 0

SELECT *

  FROM j25_rsfirewall_exceptions

  WHERE `published`='1'

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:700
9	plgSystemRsfirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1243
8	plgSystemRsfirewall->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:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.36 ms Po ostatnim zapytaniu: 5.53 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 13.449 MB

UPDATE `j25_extensions`

  SET `params` = '{\"mediaversion\":\"833cdb212ab888f10922e6a7fe0fe803\"}'

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

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
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/ef4_jmframework/ef4_jmframework.php:294
8	plgSystemEF4_JMFramework->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:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.20 ms Po ostatnim zapytaniu: 14.65 ms Pamięć zapytania: 0.380 MB Pamięć przed zapytaniem: 16.246 MB Zwróconych wierszy: 81

SELECT c.*  
  FROM j25_djc2_categories AS c  
  WHERE c.published=1 
  AND c.access IN (1,4)  
  AND (c.language = 'pl-PL' OR c.language = '*') 
  ORDER BY c.parent_id ASC, c.ordering ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	idx_published,idx_access,idx_published_parent_ordering	idx_published_parent_ordering	4	const	81	19.00	Using index condition; Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:343
12	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:204
11	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:242
10	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:65
9	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/controller.php:36
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.42 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 16.717 MB Zwróconych wierszy: 100

Duplikaty zapytań: #27 #37 #41

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

  FROM j25_djc2_categories as i

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

  WHERE (i.language = 'pl-PL' OR i.language = '*')

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	i	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	97	19.00	Using where
1	PRIMARY	img	NULL	eq_ref	PRIMARY	PRIMARY	4	func	1	100.00	Using where
2	DEPENDENT SUBQUERY	j25_djc2_images	NULL	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_item_type_ordering	262	01158718_educarium18.i.id,const	3	100.00	Using where; Using index; Uruchomiono metodę filesort

Profile

Status	Duration
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.00 ms
logging slow query	0.18 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:356
12	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:204
11	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:242
10	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:65
9	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/controller.php:36
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 3.96 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 17.470 MB Zwróconych wierszy: 3

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

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/controller.php:127
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.01 ms Po ostatnim zapytaniu: 3.61 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 18.036 MB Zwróconych wierszy: 45

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

  FROM `j25_assets`

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

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
23	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
22	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/components/com_djcatalog2/helpers/user.php:302
18	Djcatalog2HelperUser::getUserProfile()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:134
17	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:253
16	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/items.php:66
15	DJCatalog2ModelItems->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_djcatalog2/models/items.php:224
13	DJCatalog2ModelItems->getStoreId()	JROOT/components/com_djcatalog2/models/items.php:293
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.27 ms Po ostatnim zapytaniu: 1.73 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 18.269 MB Zwróconych wierszy: 0

SELECT id

  FROM j25_djc2_customer_groups

  WHERE (user_group IN (1,9) OR is_default=1)

  ORDER BY ordering DESC 
  LIMIT 1

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/helpers/user.php:356
18	Djcatalog2HelperUser::getUserProfile()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:134
17	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:253
16	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/items.php:66
15	DJCatalog2ModelItems->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_djcatalog2/models/items.php:224
13	DJCatalog2ModelItems->getStoreId()	JROOT/components/com_djcatalog2/models/items.php:293
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.31 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 18.278 MB Zwróconych wierszy: 0

select * 
  from j25_djc2_countries 
  where is_default=1

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/helpers/user.php:416
18	Djcatalog2HelperUser::getUserProfile()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:134
17	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:253
16	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/items.php:66
15	DJCatalog2ModelItems->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_djcatalog2/models/items.php:224
13	DJCatalog2ModelItems->getStoreId()	JROOT/components/com_djcatalog2/models/items.php:293
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.02 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 18.291 MB Zwróconych wierszy: 0

SELECT vrul.id as rule_id, vrul.name, vrat.*

  FROM j25_djc2_vat_rules AS vrul

  INNER JOIN j25_djc2_vat_rules_xref AS vx 
  ON vx.rule_id = vrul.id

  INNER JOIN j25_djc2_vat_rates AS vrat 
  ON vx.rate_id = vrat.id

  WHERE vrat.country_id=0 
  AND vrat.state_id=0 
  AND (vrat.client_type='A' OR vrat.client_type='R')

  ORDER BY vrat.client_type ASC, vrat.country_id ASC, vrat.state_id ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vrul	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using temporary; Uruchomiono metodę filesort
1	SIMPLE	vx	NULL	ref	idx_rule_rate	idx_rule_rate	4	01158718_educarium18.vrul.id	1	100.00	Using index
1	SIMPLE	vrat	NULL	eq_ref	PRIMARY,idx_country_client	PRIMARY	4	01158718_educarium18.vx.rate_id	1	100.00	Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
logging slow query	0.17 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/user.php:488
18	Djcatalog2HelperUser::getUserProfile()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:134
17	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:253
16	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/items.php:66
15	DJCatalog2ModelItems->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_djcatalog2/models/items.php:224
13	DJCatalog2ModelItems->getStoreId()	JROOT/components/com_djcatalog2/models/items.php:293
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.36 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.033 MB Pamięć przed zapytaniem: 18.298 MB Zwróconych wierszy: 11

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

  FROM j25_djc2_items_extra_fields as f

  LEFT JOIN j25_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	NULL	ALL	idx_published	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	11	100.00	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	g	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.09 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.46 ms
Creating sort index	0.17 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.05 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
logging slow query	0.00 ms
logging slow query	0.14 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1100
16	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:108
15	DJCatalog2ModelItems->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_djcatalog2/models/items.php:224
13	DJCatalog2ModelItems->getStoreId()	JROOT/components/com_djcatalog2/models/items.php:293
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 0.04 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 18.326 MB Zwróconych wierszy: 23

SELECT o.id, o.field_id

  FROM j25_djc2_items_extra_fields_options AS o

  ORDER BY o.field_id asc, o.ordering asc

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1110
16	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:108
15	DJCatalog2ModelItems->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_djcatalog2/models/items.php:224
13	DJCatalog2ModelItems->getStoreId()	JROOT/components/com_djcatalog2/models/items.php:293
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.60 ms Po ostatnim zapytaniu: 0.10 ms Pamięć zapytania: 0.382 MB Pamięć przed zapytaniem: 18.336 MB Zwróconych wierszy: 81

Duplikaty zapytań: #36

SELECT c.*  
  FROM j25_djc2_categories AS c  
  WHERE c.published=1 
  AND c.access IN (1,1,4)  
  AND (c.language = 'pl-PL' OR c.language = '*') 
  ORDER BY c.parent_id ASC, c.ordering ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	idx_published,idx_access,idx_published_parent_ordering	idx_published_parent_ordering	4	const	81	19.00	Using index condition; Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:343
19	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:204
18	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:242
17	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/items.php:904
16	DJCatalog2ModelItems->_buildContentWhere()	JROOT/components/com_djcatalog2/models/items.php:354
15	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:321
14	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:301
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 5.63 ms Po ostatnim zapytaniu: 0.14 ms Pamięć zapytania: 0.035 MB Pamięć przed zapytaniem: 18.810 MB Zwróconych wierszy: 100

Duplikaty zapytań: #18 #37 #41

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

  FROM j25_djc2_categories as i

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

  WHERE (i.language = 'pl-PL' OR i.language = '*')

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	i	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	97	19.00	Using where
1	PRIMARY	img	NULL	eq_ref	PRIMARY	PRIMARY	4	func	1	100.00	Using where
2	DEPENDENT SUBQUERY	j25_djc2_images	NULL	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_item_type_ordering	262	01158718_educarium18.i.id,const	3	100.00	Using where; Using index; Uruchomiono metodę filesort

Profile

Status	Duration
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
logging slow query	0.00 ms
logging slow query	0.39 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:356
19	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:204
18	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:242
17	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/items.php:904
16	DJCatalog2ModelItems->_buildContentWhere()	JROOT/components/com_djcatalog2/models/items.php:354
15	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:321
14	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:301
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 14.41 ms Po ostatnim zapytaniu: 0.47 ms Pamięć zapytania: 0.099 MB Pamięć przed zapytaniem: 18.978 MB Zwróconych wierszy: 18

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,gc.price as group_price, gc.available as group_available,countries.country_name, countries.id as item_country_id,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count,states.name as state_name,combinations.combo_count

  FROM j25_djc2_items as i

  INNER JOIN (SELECT ic.item_id 
  FROM j25_djc2_items_categories AS ic 
  INNER JOIN j25_djc2_categories AS c 
  ON c.id=ic.category_id 
  WHERE c.published = 1  
  AND c.access IN (1,1,4)  
  AND ic.category_id IN (75)) as category_filter 
  ON i.id = category_filter.item_id

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

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

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

  LEFT JOIN j25_djc2_prices AS gc 
  ON gc.item_id = i.id 
  AND gc.group_id=0

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

  LEFT JOIN j25_djc2_item_rating AS v 
  ON i.id = v.item_id

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

  LEFT JOIN (SELECT item_id, COUNT(*) as combo_count 
  FROM j25_djc2_items_combinations 
  GROUP BY item_id) AS combinations 
  ON combinations.item_id = i.id

  WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-07-01 13:17:27') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-07-01 13:17:27') 
  AND i.published = 1 
  AND i.access IN (1,1,4) 
  AND i.parent_id=0 
  AND (i.language = 'pl-PL' OR i.language = '*')

  ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc 
  LIMIT 18

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	const	PRIMARY,idx_published,idx_access,idx_published_parent_ordering	PRIMARY	4	const	1	100.00	Using temporary; Uruchomiono metodę filesort
1	PRIMARY	ic	NULL	ref	PRIMARY,item_category	PRIMARY	4	const	61	100.00	Using index
1	PRIMARY	i	NULL	eq_ref	PRIMARY,idx_parent_id,idx_published,idx_access	PRIMARY	4	01158718_educarium18.ic.item_id	1	5.00	Using where
1	PRIMARY	c	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.cat_id	1	100.00	NULL
1	PRIMARY	p	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.producer_id	1	100.00	NULL
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.created_by	1	100.00	NULL
1	PRIMARY	gc	NULL	eq_ref	item_group,group_item	item_group	8	01158718_educarium18.ic.item_id,const	1	100.00	NULL
1	PRIMARY	countries	NULL	eq_ref	PRIMARY	PRIMARY	2	01158718_educarium18.i.country	1	100.00	Using where
1	PRIMARY	v	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
1	PRIMARY	states	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.state	1	100.00	NULL
1	PRIMARY	<derived3>	NULL	ref	<auto_key0>	<auto_key0>	4	01158718_educarium18.ic.item_id	2	100.00	NULL
3	DERIVED	j25_djc2_items_combinations	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using temporary; Uruchomiono metodę filesort

Profile

Status	Duration
starting	0.40 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.60 ms
init	0.27 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.05 ms
statistics	0.97 ms
preparing	0.08 ms
Creating tmp table	0.20 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	1.88 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	8.16 ms
Creating sort index	0.94 ms
end	0.01 ms
query end	0.02 ms
removing tmp table	0.12 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.11 ms
freeing items	0.10 ms
logging slow query	0.00 ms
logging slow query	0.24 ms
cleaning up	0.03 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:285
13	DJCatalog2ModelItems->_getList()	JROOT/components/com_djcatalog2/models/items.php:303
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.37 ms Po ostatnim zapytaniu: 0.22 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 19.269 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, fieldoptions.params as option_params

  FROM j25_djc2_items_extra_fields_values_int as fieldvalues

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

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

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

  WHERE fieldvalues.item_id IN (870,858,859,871,872,860,861,873,874,862,863,1277,876,864,865,877,878,866) 
  AND fields.cart_variant = 2 
  AND fields.published = 1

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

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fields	NULL	ALL	PRIMARY,idx_published	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	11	10.00	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	items	NULL	range	PRIMARY	PRIMARY	4	NULL	18	100.00	Using where; Using index; Using join buffer (Block Nested Loop)
1	SIMPLE	fieldvalues	NULL	ref	idx_item_field	idx_item_field	8	01158718_educarium18.items.id,01158718_educarium18.fields.id	6	100.00	NULL
1	SIMPLE	fieldoptions	NULL	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	01158718_educarium18.fieldvalues.value	1	100.00	Using where

Profile

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.37 ms
preparing	0.05 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.18 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.02 ms
removing tmp table	0.04 ms
query end	0.00 ms
closing tables	0.05 ms
freeing items	0.04 ms
logging slow query	0.00 ms
logging slow query	0.15 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1220
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:315
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.44 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 19.277 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, fieldoptions.params as option_params

  FROM j25_djc2_items_extra_fields_values_int as fieldvalues

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

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

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

  WHERE fieldvalues.item_id IN (870,858,859,871,872,860,861,873,874,862,863,1277,876,864,865,877,878,866)  
  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	items	NULL	range	PRIMARY	PRIMARY	4	NULL	18	100.00	Using where; Using index; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	fields	NULL	ALL	PRIMARY,idx_published	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	11	19.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	fieldvalues	NULL	ref	idx_item_field	idx_item_field	8	01158718_educarium18.items.id,01158718_educarium18.fields.id	6	100.00	NULL
1	SIMPLE	fieldoptions	NULL	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	01158718_educarium18.fieldvalues.value	1	100.00	Using where

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.30 ms
preparing	0.05 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.47 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.00 ms
logging slow query	0.11 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1223
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:315
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.03 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.031 MB Pamięć przed zapytaniem: 19.284 MB Zwróconych wierszy: 54

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 j25_djc2_items_extra_fields_values_text as fieldvalues

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

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

  WHERE fieldvalues.item_id IN (870,858,859,871,872,860,861,873,874,862,863,1277,876,864,865,877,878,866)  
  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	items	NULL	range	PRIMARY	PRIMARY	4	NULL	18	100.00	Using where; Using index; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	fields	NULL	ALL	PRIMARY,idx_published	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	11	19.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	fieldvalues	NULL	eq_ref	idx_item_field	idx_item_field	8	01158718_educarium18.items.id,01158718_educarium18.fields.id	1	100.00	NULL

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.28 ms
preparing	0.05 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.72 ms
Creating sort index	0.33 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
logging slow query	0.00 ms
logging slow query	0.14 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1226
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:315
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.09 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 19.324 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 j25_djc2_items_extra_fields_values_date as fieldvalues

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

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

  WHERE fieldvalues.item_id IN (870,858,859,871,872,860,861,873,874,862,863,1277,876,864,865,877,878,866)  
  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fieldvalues	NULL	ALL	item_field	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where; Uruchomiono metodę filesort
1	SIMPLE	fields	NULL	eq_ref	PRIMARY,idx_published	PRIMARY	4	01158718_educarium18.fieldvalues.field_id	1	19.00	Using where
1	SIMPLE	items	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.fieldvalues.item_id	1	100.00	Using index

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1229
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:315
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.02 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 19.338 MB Zwróconych wierszy: 0

SELECT l.*, li.item_id

  FROM j25_djc2_labels as l

  INNER JOIN j25_djc2_labels_items AS li 
  ON li.label_id=l.id

  WHERE li.item_id IN (870,858,859,871,872,860,861,873,874,862,863,1277,876,864,865,877,878,866) 
  AND l.published = 1

  ORDER BY l.ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	li	NULL	index	PRIMARY	PRIMARY	8	NULL	1	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.15 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
logging slow query	0.10 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1232
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:315
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.71 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 19.346 MB Zwróconych wierszy: 0

SELECT cg.*, p.item_id, p.available, p.price

  FROM j25_djc2_customer_groups AS cg

  INNER JOIN j25_djc2_prices AS p 
  ON p.group_id=cg.id

  WHERE p.item_id IN (870, 858, 859, 871, 872, 860, 861, 873, 874, 862, 863, 1277, 876, 864, 865, 877, 878, 866) 
  AND (p.available = 1 OR p.price > 0.0)

  ORDER BY cg.ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cg	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Uruchomiono metodę filesort
1	SIMPLE	p	NULL	ref	item_group,group_item	group_item	4	01158718_educarium18.cg.id	1	100.00	Using index condition; Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1235
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:315
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.05 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 19.359 MB Zwróconych wierszy: 18

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

  FROM j25_djc2_items as i

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

  WHERE i.id IN (870,858,859,871,872,860,861,873,874,862,863,1277,876,864,865,877,878,866)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	i	NULL	range	PRIMARY	PRIMARY	4	NULL	18	100.00	Using where; Using index
1	PRIMARY	img	NULL	eq_ref	PRIMARY	PRIMARY	4	func	1	100.00	Using where
2	DEPENDENT SUBQUERY	j25_djc2_images	NULL	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_item_type_ordering	262	01158718_educarium18.i.id,const	3	100.00	Using where; Using index; Uruchomiono metodę filesort

Profile

Status	Duration
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.04 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.04 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1325
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:315
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.80 ms Po ostatnim zapytaniu: 0.10 ms Pamięć zapytania: 0.381 MB Pamięć przed zapytaniem: 19.381 MB Zwróconych wierszy: 81

Duplikaty zapytań: #26

SELECT c.*  
  FROM j25_djc2_categories AS c  
  WHERE c.published=1 
  AND c.access IN (1,1,4)  
  AND (c.language = 'pl-PL' OR c.language = '*') 
  ORDER BY c.parent_id ASC, c.ordering ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	idx_published,idx_access,idx_published_parent_ordering	idx_published_parent_ordering	4	const	81	19.00	Using index condition; Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:343
16	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:204
15	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:242
14	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/items.php:1332
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:315
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 5.45 ms Po ostatnim zapytaniu: 0.17 ms Pamięć zapytania: 0.034 MB Pamięć przed zapytaniem: 19.854 MB Zwróconych wierszy: 100

Duplikaty zapytań: #18 #27 #41

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

  FROM j25_djc2_categories as i

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

  WHERE (i.language = 'pl-PL' OR i.language = '*')

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	i	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	97	19.00	Using where
1	PRIMARY	img	NULL	eq_ref	PRIMARY	PRIMARY	4	func	1	100.00	Using where
2	DEPENDENT SUBQUERY	j25_djc2_images	NULL	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_item_type_ordering	262	01158718_educarium18.i.id,const	3	100.00	Using where; Using index; Uruchomiono metodę filesort

Profile

Status	Duration
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.03 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
logging slow query	0.00 ms
logging slow query	0.37 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:356
16	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:204
15	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:242
14	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/items.php:1332
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:315
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 0.54 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 20.018 MB Zwróconych wierszy: 0

SELECT *

  FROM j25_djc2_price_rules

  WHERE published=1 
  AND (start_date = '0000-00-00 00:00:00' OR start_date <= '2022-07-01 13:17:27') 
  AND (expire_date = '0000-00-00 00:00:00' OR expire_date >= '2022-07-01 13:17:27')

  ORDER BY ordering

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/price.php:413
15	Djcatalog2HelperPrice::getPriceRules()	JROOT/components/com_djcatalog2/helpers/price.php:190
14	Djcatalog2HelperPrice::applyPriceRules()	JROOT/components/com_djcatalog2/models/items.php:1363
13	DJCatalog2ModelItems->bindAttributes()	JROOT/components/com_djcatalog2/models/items.php:315
12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/views/items/view.html.php:103
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.33 ms Po ostatnim zapytaniu: 1.02 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 20.044 MB Zwróconych wierszy: 1

SELECT COUNT(distinct (i.id))

  FROM j25_djc2_items as i

  INNER JOIN (SELECT ic.item_id 
  FROM j25_djc2_items_categories AS ic 
  INNER JOIN j25_djc2_categories AS c 
  ON c.id=ic.category_id 
  WHERE c.published = 1  
  AND c.access IN (1,1,4)  
  AND ic.category_id IN (75)) as category_filter 
  ON i.id = category_filter.item_id

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

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

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

  LEFT JOIN j25_djc2_prices AS gc 
  ON gc.item_id = i.id 
  AND gc.group_id=0

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

  LEFT JOIN j25_djc2_item_rating AS v 
  ON i.id = v.item_id

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

  LEFT JOIN (SELECT item_id, COUNT(*) as combo_count 
  FROM j25_djc2_items_combinations 
  GROUP BY item_id) AS combinations 
  ON combinations.item_id = i.id

  WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-07-01 13:17:27') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-07-01 13:17:27') 
  AND i.published = 1 
  AND i.access IN (1,1,4) 
  AND i.parent_id=0 
  AND (i.language = 'pl-PL' OR i.language = '*') 
  LIMIT 18

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	const	PRIMARY,idx_published,idx_access,idx_published_parent_ordering	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	ic	NULL	ref	PRIMARY,item_category	PRIMARY	4	const	61	100.00	Using index
1	PRIMARY	i	NULL	eq_ref	PRIMARY,idx_parent_id,idx_published,idx_access	PRIMARY	4	01158718_educarium18.ic.item_id	1	5.00	Using where
1	PRIMARY	c	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.cat_id	1	100.00	Using index
1	PRIMARY	p	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.producer_id	1	100.00	Using index
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.created_by	1	100.00	Using index
1	PRIMARY	gc	NULL	eq_ref	item_group,group_item	item_group	8	01158718_educarium18.ic.item_id,const	1	100.00	Using index
1	PRIMARY	countries	NULL	eq_ref	PRIMARY	PRIMARY	2	01158718_educarium18.i.country	1	100.00	Using where; Using index
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.ic.item_id	1	100.00	Using index
1	PRIMARY	states	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.state	1	100.00	Using index
1	PRIMARY	<derived3>	NULL	ref	<auto_key0>	<auto_key0>	4	01158718_educarium18.ic.item_id	2	100.00	NULL
3	DERIVED	j25_djc2_items_combinations	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using temporary; Uruchomiono metodę filesort

Profile

Status	Duration
starting	0.24 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.17 ms
System lock	0.01 ms
optimizing	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.05 ms
statistics	0.32 ms
preparing	0.07 ms
executing	0.01 ms
Sending data	0.11 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.84 ms
end	0.01 ms
query end	0.03 ms
removing tmp table	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.08 ms
freeing items	0.07 ms
logging slow query	0.00 ms
logging slow query	0.24 ms
cleaning up	0.04 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/items.php:334
14	DJCatalog2ModelItems->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_djcatalog2/views/items/view.html.php:105
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.94 ms Pamięć zapytania: 0.381 MB Pamięć przed zapytaniem: 20.170 MB Zwróconych wierszy: 81

SELECT c.*  
  FROM j25_djc2_categories AS c  
  WHERE c.published=1 
  AND (c.language = 'pl-PL' OR c.language = '*') 
  ORDER BY c.parent_id ASC, c.ordering ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	idx_published,idx_published_parent_ordering	idx_published_parent_ordering	4	const	81	19.00	Using index condition; Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:343
15	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:204
14	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:242
13	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/items.php:1387
12	DJCatalog2ModelItems->getProducers()	JROOT/components/com_djcatalog2/views/items/view.html.php:159
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.38 ms Po ostatnim zapytaniu: 0.14 ms Pamięć zapytania: 0.034 MB Pamięć przed zapytaniem: 20.643 MB Zwróconych wierszy: 100

Duplikaty zapytań: #18 #27 #37

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

  FROM j25_djc2_categories as i

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

  WHERE (i.language = 'pl-PL' OR i.language = '*')

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	i	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	97	19.00	Using where
1	PRIMARY	img	NULL	eq_ref	PRIMARY	PRIMARY	4	func	1	100.00	Using where
2	DEPENDENT SUBQUERY	j25_djc2_images	NULL	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_item_type_ordering	262	01158718_educarium18.i.id,const	3	100.00	Using where; Using index; Uruchomiono metodę filesort

Profile

Status	Duration
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.00 ms
logging slow query	0.21 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:356
15	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:204
14	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:242
13	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/models/items.php:1387
12	DJCatalog2ModelItems->getProducers()	JROOT/components/com_djcatalog2/views/items/view.html.php:159
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.56 ms Po ostatnim zapytaniu: 0.32 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 20.801 MB Zwróconych wierszy: 1

SELECT DISTINCT a.id, a.name as text  
  FROM j25_djc2_producers as a  
  INNER JOIN j25_djc2_items AS i 
  ON a.id = i.producer_id 
  AND i.published = 1 
  INNER JOIN j25_djc2_items_categories AS c 
  ON c.item_id = i.id  
  WHERE c.category_id IN (75) 
  AND a.published=1  
  GROUP BY a.id, a.name 
  ORDER BY a.ordering asc

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	PRIMARY,item_category	PRIMARY	4	const	61	100.00	Using index; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	i	NULL	eq_ref	PRIMARY,idx_producer_id,idx_published	PRIMARY	4	01158718_educarium18.c.item_id	1	100.00	Using where
1	SIMPLE	a	NULL	eq_ref	PRIMARY,idx_published	PRIMARY	4	01158718_educarium18.i.producer_id	1	100.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1406
12	DJCatalog2ModelItems->getProducers()	JROOT/components/com_djcatalog2/views/items/view.html.php:159
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.63 ms Po ostatnim zapytaniu: 4.82 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 21.428 MB Zwróconych wierszy: 3

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

  FROM j25_djc2_items_extra_fields as f

  LEFT JOIN j25_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	NULL	ALL	idx_published	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	11	19.00	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	g	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1100
12	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/views/items/view.html.php:260
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT f.*

  FROM j25_djc2_items_extra_fields as f

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

  INNER JOIN (
SELECT distinct i.id

  FROM j25_djc2_items as i

  INNER JOIN (SELECT ic.item_id 
  FROM j25_djc2_items_categories AS ic 
  INNER JOIN j25_djc2_categories AS c 
  ON c.id=ic.category_id 
  WHERE c.published = 1  
  AND c.access IN (1,1,4)  
  AND ic.category_id IN (75)) as category_filter 
  ON i.id = category_filter.item_id

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

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

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

  LEFT JOIN j25_djc2_prices AS gc 
  ON gc.item_id = i.id 
  AND gc.group_id=0

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

  LEFT JOIN j25_djc2_item_rating AS v 
  ON i.id = v.item_id

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

  WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-07-01 13:17:27') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-07-01 13:17:27') 
  AND i.published = 1 
  AND i.access IN (1,1,4) 
  AND i.parent_id=0 
  AND (i.language = 'pl-PL' OR i.language = '*')

  ORDER BY  i.id asc) 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	f	NULL	ref	idx_published,idx_separate_column,idx_group_id	idx_separate_column	4	const	1	19.00	Using where; Using temporary; Uruchomiono metodę filesort
1	PRIMARY	<derived2>	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	3	100.00	Using join buffer (Block Nested Loop)
1	PRIMARY	i	NULL	eq_ref	PRIMARY,item_group	PRIMARY	8	01158718_educarium18.f.group_id,iq.id	1	100.00	Using index
2	DERIVED	c	NULL	const	PRIMARY,idx_published,idx_access,idx_published_parent_ordering	PRIMARY	4	const	1	100.00	Using temporary; Uruchomiono metodę filesort
2	DERIVED	ic	NULL	ref	PRIMARY,item_category	PRIMARY	4	const	61	100.00	Using index
2	DERIVED	i	NULL	eq_ref	PRIMARY,idx_cat_id,idx_parent_id,idx_group_id,idx_producer_id,idx_published,idx_access,idx_featured,idx_ordering,idx_created_by,idx_country,idx_state,idx_latitude,idx_longitude	PRIMARY	4	01158718_educarium18.ic.item_id	1	5.00	Using where
2	DERIVED	c	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.cat_id	1	100.00	Using index; Distinct
2	DERIVED	p	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.producer_id	1	100.00	Using index; Distinct
2	DERIVED	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.created_by	1	100.00	Using index; Distinct
2	DERIVED	gc	NULL	eq_ref	item_group,group_item	item_group	8	01158718_educarium18.ic.item_id,const	1	100.00	Using index; Distinct
2	DERIVED	countries	NULL	eq_ref	PRIMARY	PRIMARY	2	01158718_educarium18.i.country	1	100.00	Using where; Using index; Distinct
2	DERIVED	v	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.ic.item_id	1	100.00	Using index; Distinct
2	DERIVED	states	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.state	1	100.00	Using index; Distinct

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1664
12	DJCatalog2ModelItems->getFieldGroups()	JROOT/components/com_djcatalog2/views/items/view.html.php:261
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.64 ms Po ostatnim zapytaniu: 0.14 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 21.461 MB Zwróconych wierszy: 0

SELECT f.*

  FROM j25_djc2_items_extra_fields as f

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

  INNER JOIN (
SELECT distinct i.id

  FROM j25_djc2_items as i

  INNER JOIN (SELECT ic.item_id 
  FROM j25_djc2_items_categories AS ic 
  INNER JOIN j25_djc2_categories AS c 
  ON c.id=ic.category_id 
  WHERE c.published = 1  
  AND c.access IN (1,1,4)  
  AND ic.category_id IN (75)) as category_filter 
  ON i.id = category_filter.item_id

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

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

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

  LEFT JOIN j25_djc2_prices AS gc 
  ON gc.item_id = i.id 
  AND gc.group_id=0

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

  LEFT JOIN j25_djc2_item_rating AS v 
  ON i.id = v.item_id

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

  WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-07-01 13:17:27') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-07-01 13:17:27') 
  AND i.published = 1 
  AND i.access IN (1,1,4) 
  AND i.parent_id=0 
  AND (i.language = 'pl-PL' OR i.language = '*')

  ORDER BY  i.id asc) 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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	<derived2>	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	3	100.00	Using temporary; Uruchomiono metodę filesort
1	PRIMARY	i	NULL	ref	PRIMARY,item_group	item_group	4	iq.id	1	100.00	Using index
1	PRIMARY	f	NULL	ALL	idx_published,idx_type,idx_group_id	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	11	10.00	Using where; Using join buffer (Block Nested Loop)
2	DERIVED	c	NULL	const	PRIMARY,idx_published,idx_access,idx_published_parent_ordering	PRIMARY	4	const	1	100.00	Using temporary; Uruchomiono metodę filesort
2	DERIVED	ic	NULL	ref	PRIMARY,item_category	PRIMARY	4	const	61	100.00	Using index
2	DERIVED	i	NULL	eq_ref	PRIMARY,idx_cat_id,idx_parent_id,idx_group_id,idx_producer_id,idx_published,idx_access,idx_featured,idx_ordering,idx_created_by,idx_country,idx_state,idx_latitude,idx_longitude	PRIMARY	4	01158718_educarium18.ic.item_id	1	5.00	Using where
2	DERIVED	c	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.cat_id	1	100.00	Using index; Distinct
2	DERIVED	p	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.producer_id	1	100.00	Using index; Distinct
2	DERIVED	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.created_by	1	100.00	Using index; Distinct
2	DERIVED	gc	NULL	eq_ref	item_group,group_item	item_group	8	01158718_educarium18.ic.item_id,const	1	100.00	Using index; Distinct
2	DERIVED	countries	NULL	eq_ref	PRIMARY	PRIMARY	2	01158718_educarium18.i.country	1	100.00	Using where; Using index; Distinct
2	DERIVED	v	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.ic.item_id	1	100.00	Using index; Distinct
2	DERIVED	states	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.state	1	100.00	Using index; Distinct

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.00 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
executing	0.00 ms
Sending data	0.64 ms
Creating sort index	0.24 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.02 ms
query end	0.01 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.04 ms
freeing items	0.03 ms
logging slow query	0.00 ms
logging slow query	0.09 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:1704
12	DJCatalog2ModelItems->getSortables()	JROOT/components/com_djcatalog2/views/items/view.html.php:262
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.94 ms Po ostatnim zapytaniu: 3.02 ms Pamięć zapytania: 0.381 MB Pamięć przed zapytaniem: 21.817 MB Zwróconych wierszy: 81

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

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	idx_published,idx_access,idx_published_parent_ordering	idx_published_parent_ordering	4	const	81	100.00	Using index condition; Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:343
16	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:204
15	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:242
14	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/route.php:236
13	DJCatalogHelperRoute::getCategoryRoute()	JROOT/components/com_djcatalog2/views/items/view.html.php:392
12	DJCatalog2ViewItems->_prepareDocument()	JROOT/components/com_djcatalog2/views/items/view.html.php:263
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.23 ms Po ostatnim zapytaniu: 0.18 ms Pamięć zapytania: 0.034 MB Pamięć przed zapytaniem: 22.290 MB Zwróconych wierszy: 100

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

  FROM j25_djc2_categories as i

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

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	i	NULL	index	NULL	idx_parent_id	4	NULL	97	100.00	Using index
1	PRIMARY	img	NULL	eq_ref	PRIMARY	PRIMARY	4	func	1	100.00	Using where
2	DEPENDENT SUBQUERY	j25_djc2_images	NULL	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_item_type_ordering	262	01158718_educarium18.i.id,const	3	100.00	Using where; Using index; Uruchomiono metodę filesort

Profile

Status	Duration
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.00 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:356
16	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:204
15	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:242
14	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/route.php:236
13	DJCatalogHelperRoute::getCategoryRoute()	JROOT/components/com_djcatalog2/views/items/view.html.php:392
12	DJCatalog2ViewItems->_prepareDocument()	JROOT/components/com_djcatalog2/views/items/view.html.php:263
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.31 ms Po ostatnim zapytaniu: 1.48 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 22.517 MB Zwróconych wierszy: 1

SELECT *  
  FROM j25_djc2_images  
  WHERE item_id=75 	
  AND type='category' 
  AND exclude=0 
  ORDER BY ordering ASC, name ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_djc2_images	NULL	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	262	const,const	1	10.00	Using index condition; Using where; Uruchomiono metodę filesort

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/helpers/image.php:77
13	DJCatalog2ImageHelper::getImages()	JROOT/components/com_djcatalog2/views/items/view.html.php:450
12	DJCatalog2ViewItems->_prepareDocument()	JROOT/components/com_djcatalog2/views/items/view.html.php:263
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.21 ms Po ostatnim zapytaniu: 22.17 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 22.719 MB Zwróconych wierszy: 19

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

  FROM j25_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-07-01 13:17:27') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-07-01 13:17:27') 
  AND m.access IN (1,1,4) 
  AND m.client_id = 0 
  AND (mm.menuid = 168 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	108	0.93	Using where; Uruchomiono metodę filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	01158718_educarium18.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	01158718_educarium18.m.id	4	40.00	Using where; Using index

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
15	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_djcatalog2/views/items/tmpl/default.php:13
14	include JROOT/components/com_djcatalog2/views/items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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:266
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.02 ms Po ostatnim zapytaniu: 9.80 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 22.951 MB Zwróconych wierszy: 0

SELECT DISTINCT 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, g.note as group_note

  FROM j25_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	01158718_educarium18.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.a.group_id	1	100.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
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:495
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:110
14	include JROOT/components/com_djcatalog2/views/items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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:266
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 4.10 ms Po ostatnim zapytaniu: 1.28 ms Pamięć zapytania: 0.135 MB Pamięć przed zapytaniem: 23.083 MB Zwróconych wierszy: 1935

select id, producer_id 
  from j25_djc2_items 
  where published=1

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_djc2_items	NULL	ref	idx_published	idx_published	4	const	1935	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/route.php:73
17	DJCatalogHelperRoute::getItemRoute()	JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php:27
16	include JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_djcatalog2/views/items/tmpl/default.php:228
14	include JROOT/components/com_djcatalog2/views/items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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:266
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 3.03 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 23.214 MB Zwróconych wierszy: 0

SELECT DISTINCT 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, g.note as group_note

  FROM j25_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_djcatalog2.items.extra_fields' 
  AND a.access IN (1,1,4) 
  AND (a.group_id = 0 OR g.access IN (1,1,4)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	01158718_educarium18.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.a.group_id	1	100.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
29	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
28	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
27	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
26	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
25	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
24	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
23	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
22	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
21	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
20	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
19	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_djcatalog2/layouts/com_djcatalog2/attributestable.php:45
18	include JROOT/components/com_djcatalog2/layouts/com_djcatalog2/attributestable.php	JROOT/libraries/src/Layout/FileLayout.php:125
17	Joomla\CMS\Layout\FileLayout->render()	JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php:333
16	include JROOT/components/com_djcatalog2/views/items/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_djcatalog2/views/items/tmpl/default.php:228
14	include JROOT/components/com_djcatalog2/views/items/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
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:266
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:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:137
8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:57
6	require_once JROOT/components/com_djcatalog2/djcatalog2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.38 ms Po ostatnim zapytaniu: 39.19 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 23.105 MB Zwróconych wierszy: 0

SELECT `id`

  FROM `j25_rstbox`

  WHERE `published` = 1 
  AND `testmode` = 0

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rstbox/EngageBox/Boxes.php:41
8	EngageBox\Boxes::render()	JROOT/plugins/system/rstbox/rstbox.php:68
7	PlgSystemRstBox->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.33 ms Po ostatnim zapytaniu: 3.54 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 23.275 MB Zwróconych wierszy: 8