Budujemy najfajniejsze place zabaw

Twój koszyk jest pusty

Wieża ośmiokątna Metropolis wys.7,2m J47101

Wieża ośmiokątna Metropolis wys.7,2m J47101

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

Kategoria: Metropolia

Dane techniczne

Wymiary (szer. x dł. x wys.)	6,1 x 8,3 x 6,8
Strefa bezpieczeństwa (szer. x dł.)	9,62 x 11,73
Wysokość upadku	2,37
Wiek	od 3 lat
Ilość użytkowników	25
Certyfikat EN 1176	Tak

Opis

Ośmiokątna Wieża to urządzenie z kategorii Tematycznych Placów zabaw Metropolia.

Konstrukcja Wieży i funkcje w jakie została wyposażona wzbudzają wiele pozytywnych emocji.

Mając na placu zabaw taką wieże gwarantujemy, że dzieci będą się świetnie bawić.

Przygotowaliśmy dla dzieci dwie zjeżdżalnie – jedna została zamontowana na wysokości 2,37m, a dla trochę odważniejszych druga zjeżdżalnia umieszona jest na wysokości 4,17m.

Niezależnie, z której zjeżdżalni dzieci zjadą odczują ogromną satysfakcję i chęć zjechania jeszcze raz!

Pliki

KARTA TECHNICZNA PRODUKTU J47101
pdf | 539.87 KB | 391 pobrań
PLIK DWG 3D J47101
dwg | 29.94 MB | 44 pobrań
PLIK DWG 2D J47101
zip | 319.18 KB | 385 pobrań

Konsola diagnostyczna Joomla!

Sesja

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1660358144,
                "last": 1660358144,
                "now": 1660358144
            },
            "client": {
                "forwarded": "18.204.56.185"
            },
            "token": "SnxEXvs0CHzTI3MbeabGoAVzqIRulSW8"
        },
        "registry": {
            "com_djcatalog2": {
                "items": {
                    "recent": [
                        1794
                    ]
                }
            }
        },
        "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: 12.22 ms / 12.22 ms Pamięć: 1.808 MB / 2.23 MB Application: afterLoad

Czas: 66.06 ms / 78.28 ms Pamięć: 7.529 MB / 9.75 MB Application: afterInitialise

Czas: 30.81 ms / 109.09 ms Pamięć: 4.875 MB / 14.63 MB Application: afterRoute

Czas: 0.32 ms / 109.41 ms Pamięć: 0.059 MB / 14.69 MB Application: beforeRenderComponent com_djcatalog2

Czas: 18.87 ms / 128.28 ms Pamięć: 3.197 MB / 17.89 MB Application: Before Access::preloadComponents (all components)

Czas: 2.67 ms / 130.95 ms Pamięć: 0.066 MB / 17.95 MB Application: After Access::preloadComponents (all components)

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

Czas: 0.29 ms / 131.26 ms Pamięć: 0.029 MB / 17.98 MB Application: After Access::getAssetRules (id:200 name:com_djcatalog2)

Czas: 0.67 ms / 131.93 ms Pamięć: 0.166 MB / 18.14 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Czas: 0.02 ms / 131.95 ms Pamięć: 0.007 MB / 18.15 MB Application: After Access::getAssetRules (id:1 name:root.1)

Czas: 96.46 ms / 228.41 ms Pamięć: 3.639 MB / 21.79 MB Application: afterRenderComponent com_djcatalog2

Czas: 0.79 ms / 229.20 ms Pamięć: 0.022 MB / 21.81 MB Application: afterDispatch

Czas: 12.40 ms / 241.59 ms Pamięć: 1.201 MB / 23.01 MB Application: beforeRenderModule mod_menu (Nasze witryny)

Czas: 1.48 ms / 243.08 ms Pamięć: 0.158 MB / 23.17 MB Application: afterRenderModule mod_menu (Nasze witryny)

Czas: 0.23 ms / 243.31 ms Pamięć: -0.003 MB / 23.17 MB Application: beforeRenderModule mod_menu (Pozostałe)

Czas: 0.78 ms / 244.09 ms Pamięć: 0.027 MB / 23.19 MB Application: afterRenderModule mod_menu (Pozostałe)

Czas: 3.59 ms / 247.68 ms Pamięć: 1.037 MB / 24.23 MB Application: beforeRenderModule mod_breadcrumbs (breadcrumbs)

Czas: 1.43 ms / 249.11 ms Pamięć: 0.031 MB / 24.26 MB Application: afterRenderModule mod_breadcrumbs (breadcrumbs)

Czas: 0.18 ms / 249.29 ms Pamięć: 0.028 MB / 24.29 MB Application: beforeRenderModule mod_djmegamenu (DJ-Megamenu)

Czas: 26.55 ms / 275.84 ms Pamięć: 0.374 MB / 24.66 MB Application: afterRenderModule mod_djmegamenu (DJ-Megamenu)

Czas: 0.33 ms / 276.18 ms Pamięć: -0.046 MB / 24.62 MB Application: beforeRenderModule mod_menu (Top menu)

Czas: 0.74 ms / 276.92 ms Pamięć: 0.012 MB / 24.63 MB Application: afterRenderModule mod_menu (Top menu)

Czas: 0.19 ms / 277.11 ms Pamięć: 0.000 MB / 24.63 MB Application: beforeRenderModule mod_search (Search)

Czas: 0.71 ms / 277.82 ms Pamięć: 0.016 MB / 24.65 MB Application: afterRenderModule mod_search (Search)

Czas: 0.09 ms / 277.91 ms Pamięć: -0.025 MB / 24.62 MB Application: beforeRenderModule mod_djc2cart (Koszyk)

Czas: 0.55 ms / 278.46 ms Pamięć: 0.007 MB / 24.63 MB Application: afterRenderModule mod_djc2cart (Koszyk)

Czas: 0.11 ms / 278.57 ms Pamięć: -0.000 MB / 24.63 MB Application: beforeRenderModule mod_djmegamenu_button (Main Menu - Mobile Button)

Czas: 0.10 ms / 278.67 ms Pamięć: 0.006 MB / 24.64 MB Application: afterRenderModule mod_djmegamenu_button (Main Menu - Mobile Button)

Czas: 293.98 ms / 572.65 ms Pamięć: 3.815 MB / 28.45 MB Application: afterRender

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

Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `j25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6166303864306262356664626562396236666532326431323237333739636262', 1, 1660358144, 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.01 ms
update	0.10 ms
end	0.01 ms
query end	0.02 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
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.47 ms Po ostatnim zapytaniu: 4.33 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.636 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.04 ms
checking permissions	0.00 ms
Opening tables	0.11 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
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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.59 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 4.648 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.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	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.02 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.45 ms Po ostatnim zapytaniu: 5.60 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 5.455 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.05 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.62 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 5.460 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.04 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.18 ms
end	0.01 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
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.65 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 5.465 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.03 ms
checking permissions	0.00 ms
Opening tables	0.06 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.25 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
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.89 ms Po ostatnim zapytaniu: 3.35 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 6.025 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.20 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.07 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.06 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
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.76 ms Po ostatnim zapytaniu: 19.82 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 8.727 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.06 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_jchoptimize/lib/src/Service/ConfigurationProvider.php:25
9	JchOptimize\Service\ConfigurationProvider->JchOptimize\Service\{closure}()	JROOT/libraries/vendor/joomla/di/src/Container.php:457
8	Joomla\DI\Container->get()	JROOT/plugins/system/jchoptimize/jchoptimize.php:122
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.62 ms Po ostatnim zapytaniu: 5.16 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 9.625 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.03 ms
checking permissions	0.01 ms
Opening tables	0.11 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.14 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
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: 2.08 ms Po ostatnim zapytaniu: 11.69 ms Pamięć zapytania: 0.379 MB Pamięć przed zapytaniem: 12.484 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.09 ms
checking permissions	0.01 ms
Opening tables	0.11 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.26 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 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/administrator/components/com_djcatalog2/lib/categories.php:343
13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:204
12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:242
11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/router.php:327
10	DJCatalog2ParseRoute()	JROOT/components/com_djcatalog2/router.php:659
9	DJCatalog2Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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: 6.31 ms Po ostatnim zapytaniu: 0.26 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 12.956 MB Zwróconych wierszy: 100

Duplikaty zapytań: #26

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
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
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.03 ms
cleaning up	0.04 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/lib/categories.php:356
13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:204
12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:242
11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/router.php:327
10	DJCatalog2ParseRoute()	JROOT/components/com_djcatalog2/router.php:659
9	DJCatalog2Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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.52 ms Po ostatnim zapytaniu: 0.47 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 13.111 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.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.19 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
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.33 ms Po ostatnim zapytaniu: 0.29 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 13.147 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.03 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.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: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.45 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 13.153 MB Zwróconych wierszy: 0

SELECT `ip`,`reason`

  FROM j25_rsfirewall_lists

  WHERE (`ip`='18.204.56.185' 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.06 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 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
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.36 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 13.158 MB Zwróconych wierszy: 0

SELECT `ip`,`reason`

  FROM j25_rsfirewall_lists

  WHERE (`ip`='18.204.56.185' 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.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.40 ms Po ostatnim zapytaniu: 0.50 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 13.211 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.03 ms
checking permissions	0.00 ms
Opening tables	0.12 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Stos wywołania

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

UPDATE `j25_extensions`

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

  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.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.10 ms
updating	0.11 ms
end	0.01 ms
query end	0.03 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/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: 0.63 ms Po ostatnim zapytaniu: 18.07 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 17.418 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.07 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 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
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: 2.44 ms Po ostatnim zapytaniu: 2.92 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 17.893 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	330	13.94	Using where

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.33 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	1.46 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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
22	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
21	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/components/com_djcatalog2/helpers/user.php:302
17	Djcatalog2HelperUser::getUserProfile()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:134
16	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:253
15	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/item.php:44
14	DJCatalog2ModelItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:45
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.48 ms Po ostatnim zapytaniu: 1.64 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 18.149 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.06 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/helpers/user.php:356
17	Djcatalog2HelperUser::getUserProfile()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:134
16	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:253
15	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/item.php:44
14	DJCatalog2ModelItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:45
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.12 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 18.158 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.04 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.27 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/helpers/user.php:416
17	Djcatalog2HelperUser::getUserProfile()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:134
16	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:253
15	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/item.php:44
14	DJCatalog2ModelItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:45
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.82 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 18.172 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.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 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.01 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
cleaning up	0.02 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/user.php:488
17	Djcatalog2HelperUser::getUserProfile()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:134
16	Djcatalog2Helper::getUser()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:253
15	Djcatalog2Helper::getUserProfile()	JROOT/components/com_djcatalog2/models/item.php:44
14	DJCatalog2ModelItem->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:45
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.62 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.042 MB Pamięć przed zapytaniem: 18.181 MB Zwróconych wierszy: 1

SELECT i.*, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,gc.price as group_price, gc.available as group_available,countries.country_name, countries.id as item_country_id,states.name as state_name,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM j25_djc2_items as i

  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_countries_states AS states 
  ON states.id = i.state

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

  WHERE i.id =1794 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-08-13 02:35:44') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-08-13 02:35:44')

  GROUP BY i.id

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	p	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ua	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	gc	NULL	const	item_group,group_item	item_group	8	const,const	0	0.00	unique row not found
1	SIMPLE	countries	NULL	const	PRIMARY	PRIMARY	2	const	0	0.00	unique row not found
1	SIMPLE	states	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profile

Status	Duration
starting	0.25 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
Opening tables	0.38 ms
init	0.16 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.20 ms
preparing	0.06 ms
executing	0.00 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.06 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:200
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.04 ms Pamięć zapytania: 0.405 MB Pamięć przed zapytaniem: 18.203 MB Zwróconych wierszy: 115

SELECT c.*  
  FROM j25_djc2_categories AS c  
  WHERE (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	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	97	19.00	Using where; Uruchomiono metodę filesort

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.37 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
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/item.php:224
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.86 ms Po ostatnim zapytaniu: 0.29 ms Pamięć zapytania: 0.034 MB Pamięć przed zapytaniem: 18.744 MB Zwróconych wierszy: 100

Duplikaty zapytań: #12

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
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.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.04 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.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.04 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: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/item.php:224
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.47 ms Po ostatnim zapytaniu: 0.52 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 18.962 MB Zwróconych wierszy: 2

SELECT category_id

  FROM j25_djc2_items_categories

  WHERE item_id=1794

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_djc2_items_categories	NULL	ref	item_category	item_category	4	const	2	100.00	Using index

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/models/item.php:570
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:287
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.11 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 18.991 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=1794 
  AND fields.cart_variant=2 
  AND fields.published = 1

  ORDER BY 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	const	PRIMARY	PRIMARY	4	const	1	100.00	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	10.00	Using where
1	SIMPLE	fieldvalues	NULL	ref	idx_item_field	idx_item_field	8	const,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.11 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.04 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.18 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.02 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/components/com_djcatalog2/models/item.php:617
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:287
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.06 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 18.999 MB Zwróconych wierszy: 1

SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value, 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=1794 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fields.ordering asc, fieldoptions.ordering asc

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	items	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	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
1	SIMPLE	fieldvalues	NULL	ref	idx_item_field	idx_item_field	8	const,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.11 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.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.16 ms
preparing	0.05 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.25 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.03 ms
cleaning up	0.02 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/components/com_djcatalog2/models/item.php:619
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:287
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.80 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 19.008 MB Zwróconych wierszy: 8

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=1794 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	items	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	fields	NULL	ALL	PRIMARY,idx_published	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	11	19.00	Using where
1	SIMPLE	fieldvalues	NULL	eq_ref	idx_item_field	idx_item_field	8	const,01158718_educarium18.fields.id	1	100.00	NULL

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.15 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.02 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/components/com_djcatalog2/models/item.php:621
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:287
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.67 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 19.021 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=1794 
  AND (fields.visibility = 1 OR fields.visibility = 3) 
  AND fields.published = 1

  ORDER BY fields.ordering asc

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	items	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	fieldvalues	NULL	ref	item_field	item_field	4	const	1	100.00	NULL
1	SIMPLE	fields	NULL	eq_ref	PRIMARY,idx_published	PRIMARY	4	01158718_educarium18.fieldvalues.field_id	1	19.00	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 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.02 ms
freeing items	0.03 ms
cleaning up	0.02 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/components/com_djcatalog2/models/item.php:623
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:287
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.02 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 19.028 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=1794

  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	Uruchomiono metodę filesort
1	SIMPLE	li	NULL	eq_ref	PRIMARY	PRIMARY	8	const,01158718_educarium18.l.id	1	100.00	Using index

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:626
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:287
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.50 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 19.045 MB Zwróconych wierszy: 0

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

  FROM j25_djc2_customer_groups AS cg

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

  WHERE p.item_id = 1794 
  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	eq_ref	item_group,group_item	item_group	8	const,01158718_educarium18.cg.id	1	100.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:640
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:287
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.46 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 19.054 MB Zwróconych wierszy: 1

SELECT COUNT(*)

  FROM j25_djc2_items_combinations

  WHERE item_id =1794

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_djc2_items_combinations	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.08 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:647
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:287
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.57 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 19.065 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-08-13 02:35:44') 
  AND (expire_date = '0000-00-00 00:00:00' OR expire_date >= '2022-08-13 02:35:44')

  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.06 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.05 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.03 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/price.php:413
16	Djcatalog2HelperPrice::getPriceRules()	JROOT/components/com_djcatalog2/helpers/price.php:190
15	Djcatalog2HelperPrice::applyPriceRules()	JROOT/components/com_djcatalog2/models/item.php:724
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:287
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.40 ms Po ostatnim zapytaniu: 0.12 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 19.074 MB Zwróconych wierszy: 0

SELECT *

  FROM j25_djc2_items_price_tiers

  WHERE item_id=1794

  ORDER BY quantity ASC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_djc2_items_price_tiers	NULL	ref	idx_item_quantity	idx_item_quantity	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.06 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.02 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
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:1234
15	DJCatalog2ModelItem->getTierPrices()	JROOT/components/com_djcatalog2/models/item.php:727
14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:287
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.29 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 19.050 MB Zwróconych wierszy: 1

Duplikaty zapytań: #38 #45 #46 #49

SELECT sections

  FROM `j25_djc2_categories`

  WHERE `id` = 137

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:309
14	DJCatalog2ModelItem->getSectionByCategory()	JROOT/components/com_djcatalog2/models/item.php:291
13	DJCatalog2ModelItem->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:46
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.29 ms Po ostatnim zapytaniu: 1.90 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 19.238 MB Zwróconych wierszy: 1

Duplikaty zapytań: #37 #45 #46 #49

SELECT sections

  FROM `j25_djc2_categories`

  WHERE `id` = 137

Objaśnienie

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.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:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:309
15	DJCatalog2ModelItem->getSectionByCategory()	JROOT/components/com_djcatalog2/models/item.php:291
14	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:75
13	DJCatalog2ModelItem->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:47
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.61 ms Po ostatnim zapytaniu: 0.32 ms Pamięć zapytania: 0.381 MB Pamięć przed zapytaniem: 19.266 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.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	1.05 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
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/helpers/route.php:50
12	DJCatalogHelperRoute::getItemRoute()	JROOT/components/com_djcatalog2/views/item/view.html.php:140
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.49 ms Po ostatnim zapytaniu: 0.26 ms Pamięć zapytania: 0.034 MB Pamięć przed zapytaniem: 19.738 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.01 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
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
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
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/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/helpers/route.php:50
12	DJCatalogHelperRoute::getItemRoute()	JROOT/components/com_djcatalog2/views/item/view.html.php:140
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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: 8.88 ms Po ostatnim zapytaniu: 0.60 ms Pamięć zapytania: 0.132 MB Pamięć przed zapytaniem: 19.922 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.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	8.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/route.php:73
12	DJCatalogHelperRoute::getItemRoute()	JROOT/components/com_djcatalog2/views/item/view.html.php:140
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.62 ms Po ostatnim zapytaniu: 6.45 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 20.753 MB Zwróconych wierszy: 0

SELECT related_item

  FROM j25_djc2_items_related

  WHERE item_id=1794

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_djc2_items_related	NULL	ref	item_related	item_related	4	const	1	100.00	Using index

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/models/item.php:334
12	DJCatalog2ModelItem->getRelatedItems()	JROOT/components/com_djcatalog2/views/item/view.html.php:210
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.46 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 20.761 MB Zwróconych wierszy: 10

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 = 1 or f.visibility = 3) 
  and f.published = 1 
  AND (f.cart_variant = 0 OR f.cart_variant = 2)

  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	9.09	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.f.group_id	1	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:400
12	DJCatalog2ModelItem->getAttributes()	JROOT/components/com_djcatalog2/views/item/view.html.php:211
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.57 ms Po ostatnim zapytaniu: 0.13 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 20.783 MB Zwróconych wierszy: 2

SELECT *

  FROM j25_djc2_items_extra_fields_options

  WHERE field_id in (2,1,12,14,13,3,5,6,10,16)

  ORDER BY field_id asc, ordering asc

Objaśnienie

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

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 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/item.php:410
12	DJCatalog2ModelItem->getAttributes()	JROOT/components/com_djcatalog2/views/item/view.html.php:211
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.36 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 20.790 MB Zwróconych wierszy: 1

Duplikaty zapytań: #37 #38 #46 #49

SELECT sections

  FROM `j25_djc2_categories`

  WHERE `id` = 137

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:309
14	DJCatalog2ModelItem->getSectionByCategory()	JROOT/components/com_djcatalog2/models/item.php:291
13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:495
12	DJCatalog2ModelItem->getCartVariants()	JROOT/components/com_djcatalog2/views/item/view.html.php:213
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.36 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 20.797 MB Zwróconych wierszy: 1

Duplikaty zapytań: #37 #38 #45 #49

SELECT sections

  FROM `j25_djc2_categories`

  WHERE `id` = 137

Objaśnienie

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 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.02 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:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:309
15	DJCatalog2ModelItem->getSectionByCategory()	JROOT/components/com_djcatalog2/models/item.php:291
14	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:927
13	DJCatalog2ModelItem->getCombinations()	JROOT/components/com_djcatalog2/models/item.php:496
12	DJCatalog2ModelItem->getCartVariants()	JROOT/components/com_djcatalog2/views/item/view.html.php:213
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.53 ms Po ostatnim zapytaniu: 0.04 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 20.807 MB Zwróconych wierszy: 0

Duplikaty zapytań: #50

SELECT c.*, gc.price as group_price

  FROM j25_djc2_items_combinations AS c

  LEFT JOIN j25_djc2_combination_prices AS gc 
  ON gc.combination_id = c.id 
  AND gc.group_id=0

  WHERE item_id = 1794

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	gc	NULL	eq_ref	item_group,group_item	item_group	8	01158718_educarium18.c.id,const	1	100.00	NULL

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.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/item.php:940
13	DJCatalog2ModelItem->getCombinations()	JROOT/components/com_djcatalog2/models/item.php:496
12	DJCatalog2ModelItem->getCartVariants()	JROOT/components/com_djcatalog2/views/item/view.html.php:213
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.96 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 20.814 MB Zwróconych wierszy: 0

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.cart_variant=1 OR f.cart_variant=2) 
  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.09 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.05 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.27 ms
Creating sort index	0.05 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
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/item.php:458
13	DJCatalog2ModelItem->getCartAttributes()	JROOT/components/com_djcatalog2/models/item.php:497
12	DJCatalog2ModelItem->getCartVariants()	JROOT/components/com_djcatalog2/views/item/view.html.php:213
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.33 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 20.820 MB Zwróconych wierszy: 1

Duplikaty zapytań: #37 #38 #45 #46

SELECT sections

  FROM `j25_djc2_categories`

  WHERE `id` = 137

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:309
14	DJCatalog2ModelItem->getSectionByCategory()	JROOT/components/com_djcatalog2/models/item.php:291
13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:927
12	DJCatalog2ModelItem->getCombinations()	JROOT/components/com_djcatalog2/views/item/view.html.php:214
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.48 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 20.828 MB Zwróconych wierszy: 0

Duplikaty zapytań: #47

SELECT c.*, gc.price as group_price

  FROM j25_djc2_items_combinations AS c

  LEFT JOIN j25_djc2_combination_prices AS gc 
  ON gc.combination_id = c.id 
  AND gc.group_id=0

  WHERE item_id = 1794

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	gc	NULL	eq_ref	item_group,group_item	item_group	8	01158718_educarium18.c.id,const	1	100.00	NULL

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 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/item.php:940
12	DJCatalog2ModelItem->getCombinations()	JROOT/components/com_djcatalog2/views/item/view.html.php:214
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.89 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 20.835 MB Zwróconych wierszy: 0

SELECT ic.*, c.name, c.input_params, c.type, c.tax_rule_id, c.price_modifier

  FROM j25_djc2_items_customisations AS ic

  INNER JOIN j25_djc2_customisations AS c 
  ON c.id=ic.customisation_id

  WHERE item_id = 1794 
  AND c.type='i'

  ORDER BY c.ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ic	NULL	ref	item_id	item_id	4	const	1	100.00	Using temporary; Uruchomiono metodę filesort
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.ic.customisation_id	1	100.00	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 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.05 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 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/item.php:1075
12	DJCatalog2ModelItem->getCustomisations()	JROOT/components/com_djcatalog2/views/item/view.html.php:215
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.49 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 20.841 MB Zwróconych wierszy: 0

SELECT c.*, id as customisation_id, 0 as item_id

  FROM j25_djc2_customisations AS c

  WHERE (c.type='c' OR c.type='a')

  ORDER BY c.ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	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.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 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/item.php:1075
12	DJCatalog2ModelItem->getCustomisations()	JROOT/components/com_djcatalog2/views/item/view.html.php:216
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.12 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 20.848 MB Zwróconych wierszy: 1

SELECT subq.position 
  FROM (SELECT k.*, @num := @num + 1 AS position 
  FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
  CASE WHEN (i.special_price > 0.0 
  AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
  FROM j25_djc2_items AS i  
  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  
  WHERE i.parent_id = 0 
  AND i.published = 1 
  AND i.access IN (1,1,4) 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-08-13 02:35:44') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2022-08-13 02:35:44') 
  AND c.published = 1  
  AND i.cat_id=137 
  ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc) as k) as subq 
  WHERE subq.id = 1794 
  ORDER BY subq.position DESC 
  LIMIT 1

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	Using where; Uruchomiono metodę filesort
2	DERIVED	<derived3>	NULL	system	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	NULL
2	DERIVED	<derived4>	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	4	100.00	NULL
4	DERIVED	c	NULL	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1	100.00	Using temporary; Uruchomiono metodę filesort
4	DERIVED	i	NULL	ref	idx_cat_id,idx_parent_id,idx_published,idx_access	idx_cat_id	4	const	31	16.00	Using index condition; Using where
4	DERIVED	p	NULL	eq_ref	PRIMARY	PRIMARY	4	01158718_educarium18.i.producer_id	1	100.00	Using index
3	DERIVED	NULL	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	NULL	No tables used

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:841
12	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:222
11	DJCatalog2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php: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.94 ms Po ostatnim zapytaniu: 0.02 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 20.856 MB Zwróconych wierszy: 1

Wieża ośmiokątna Metropolis wys.7,2m J47101

Dane techniczne

Opis

Pliki

Nasze witryny

Pozostałe

Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Czas

Pamięć

Użycie pamięci

Zapytania do bazy danych

69 zapytań zarejestrowanych 79.31 ms

9 znalezionych duplikatów!

Proludic

Wieża ośmiokątna Metropolis wys.7,2m J47101

Dane techniczne

Opis

Pliki

Nasze witryny

Pozostałe

Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Czas

Pamięć

Użycie pamięci

Zapytania do bazy danych

69 zapytań zarejestrowanych 79.31 ms

9 znalezionych duplikatów!