Aktualności

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

Czas

Pamięć

34 zapytań zarejestrowanych 27.06 ms

1. Czas zapytania: 0.50 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 4.109 MB Zwróconych wierszy: 1

   SELECT `data`
   
     FROM `zr6kn_session`
   
     WHERE `session_id` = X'3132623935636162393634323730393637643566366433613630336265363336'

   Objaśnienie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	zr6kn_session	const	PRIMARY	PRIMARY	194	const	1

   Profile

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.11 ms
   Optimizing	0.15 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Identyczny z wywołaniem linii niżej.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   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]

   ---

2. Czas zapytania: 0.40 ms Po ostatnim zapytaniu: 8.04 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 4.752 MB Zwróconych wierszy: 5

   SELECT id, rules
   
     FROM `zr6kn_viewlevels`

   Objaśnienie

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

   Profile

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.04 ms
   Executing	0.01 ms
   Sending data	0.05 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.00 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]

   ---

3. Czas zapytania: 0.53 ms Po ostatnim zapytaniu: 0.13 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 4.761 MB Zwróconych wierszy: 2

   SELECT b.id
   
     FROM zr6kn_usergroups AS a
   
     LEFT JOIN zr6kn_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Objaśnienie

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

   Profile

   Status	Duration
   Starting	0.13 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.01 ms
   Unlocking tables	0.00 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.00 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]

   ---

4. Czas zapytania: 0.27 ms Po ostatnim zapytaniu: 20.71 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 6.687 MB Zwróconych wierszy: 1

   SELECT `value`
   
     FROM `zr6kn_admintools_storage`
   
     WHERE `key` = 'cparams'

   Objaśnienie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	zr6kn_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

   Profile

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.00 ms
   Unlocking tables	0.00 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
   12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
   11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
   10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
   9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php: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]

   ---

5. Czas zapytania: 0.27 ms Po ostatnim zapytaniu: 2.58 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 6.879 MB Zwróconych wierszy: 0

   SELECT *
   
     FROM `zr6kn_admintools_wafexceptions`
   
     WHERE NOT(`option` LIKE 'com_%')

   Objaśnienie

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

   Profile

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.03 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
   10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
   9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php: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]

   ---

6. Czas zapytania: 0.38 ms Po ostatnim zapytaniu: 60.96 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 10.677 MB Zwróconych wierszy: 0

   SELECT *
   
     FROM `zr6kn_admintools_ipautoban`
   
     WHERE `ip` = '216.73.217.70'

   Objaśnienie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   Profile

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

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   12	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:74
   11	AtsystemFeatureAutoipfiltering->isIPBlocked()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:23
   10	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
   9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
   8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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]

   ---

7. Czas zapytania: 0.50 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 10.682 MB Zwróconych wierszy: 9

   SELECT `ip`
   
     FROM `zr6kn_admintools_ipblock`

   Objaśnienie

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

   Profile

   Status	Duration
   Starting	0.02 ms
   checking permissions	0.06 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.18 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   12	JDatabaseDriver->loadColumn()	JROOT/plugins/system/admintools/feature/ipblacklist.php:143
   11	AtsystemFeatureIpblacklist->isIPBlocked()	JROOT/plugins/system/admintools/feature/ipblacklist.php:37
   10	AtsystemFeatureIpblacklist->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
   9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
   8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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]

   ---

8. Czas zapytania: 0.44 ms Po ostatnim zapytaniu: 0.14 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 10.688 MB Zwróconych wierszy: 3
   Duplikaty zapytań: #10  #11

   SELECT *
   
     FROM `zr6kn_admintools_storage`
   
     WHERE `key` LIKE 'timestamp_%'

   Objaśnienie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	zr6kn_admintools_storage	range	PRIMARY	PRIMARY	402	NULL	3	Using where

   Profile

   Status	Duration
   Starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.03 ms
   init	0.01 ms
   Optimizing	0.02 ms
   Statistics	0.08 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.04 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.03 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.02 ms
   Reset for next command	0.00 ms

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   13	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/feature/abstract.php:277
   12	AtsystemFeatureAbstract->loadTimestamps()	JROOT/plugins/system/admintools/feature/abstract.php:356
   11	AtsystemFeatureAbstract->getTimestamp()	JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:115
   10	AtsystemFeatureDisableobsoleteadmins->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
   9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
   8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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]

   ---

9. Czas zapytania: 0.66 ms Po ostatnim zapytaniu: 1.35 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 10.698 MB Zwróconych wierszy: 0

   SELECT `source`,`keepurlparams`
   
     FROM `zr6kn_admintools_redirects`
   
     WHERE ((`dest` = 'o-szpitalu/aktualnosci/1241-otwarcie-centrum-urazowego') OR (`dest` = 'o-szpitalu/aktualnosci/1241-otwarcie-centrum-urazowego?print=1&tmpl=component') OR ('o-szpitalu/aktualnosci/1241-otwarcie-centrum-urazowego?print=1&tmpl=component' LIKE `dest`)) 
     AND `published` = '1'
   
     ORDER BY `ordering` DESC 
     LIMIT 1

   Objaśnienie

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

   Profile

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

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
   11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
   10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
   9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
   8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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]

   ---

10. Czas zapytania: 1.20 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 10.702 MB Zwróconych wierszy: 3
    Duplikaty zapytań: #8  #11

    SELECT *
    
      FROM `zr6kn_admintools_storage`
    
      WHERE `key` LIKE 'timestamp_%'

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zr6kn_admintools_storage	range	PRIMARY	PRIMARY	402	NULL	3	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    13	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/feature/abstract.php:277
    12	AtsystemFeatureAbstract->loadTimestamps()	JROOT/plugins/system/admintools/feature/abstract.php:356
    11	AtsystemFeatureAbstract->getTimestamp()	JROOT/plugins/system/admintools/feature/cachecleaner.php:37
    10	AtsystemFeatureCachecleaner->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
    8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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]

    ---

11. Czas zapytania: 0.36 ms Po ostatnim zapytaniu: 0.12 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 10.708 MB Zwróconych wierszy: 3
    Duplikaty zapytań: #8  #10

    SELECT *
    
      FROM `zr6kn_admintools_storage`
    
      WHERE `key` LIKE 'timestamp_%'

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zr6kn_admintools_storage	range	PRIMARY	PRIMARY	402	NULL	3	Using where

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    13	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/feature/abstract.php:277
    12	AtsystemFeatureAbstract->loadTimestamps()	JROOT/plugins/system/admintools/feature/abstract.php:356
    11	AtsystemFeatureAbstract->getTimestamp()	JROOT/plugins/system/admintools/feature/cacheexpire.php:36
    10	AtsystemFeatureCacheexpire->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
    8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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]

    ---

12. Czas zapytania: 0.52 ms Po ostatnim zapytaniu: 25.05 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 13.295 MB Zwróconych wierszy: 0

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

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.15 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Executing	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 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/libraries/src/Categories/Categories.php:324
    12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
    10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
    9	Joomla\CMS\Component\Router\RouterView->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]

    ---

13. Czas zapytania: 0.25 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 13.300 MB Zwróconych wierszy: 1

    SELECT `alias`,`catid`
    
      FROM `zr6kn_content`
    
      WHERE `id` = 1241

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zr6kn_content	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
    10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
    9	Joomla\CMS\Component\Router\RouterView->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]

    ---

14. Czas zapytania: 0.39 ms Po ostatnim zapytaniu: 0.18 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 13.307 MB Zwróconych wierszy: 1

    SELECT *
    
      FROM `zr6kn_admintools_wafblacklists`
    
      WHERE `verb` IN('','GET') 
      AND `option` IN('','com_content') 
      AND `view` IN('','article') 
      AND `task` IN('','article.') 
      AND `enabled` = '1'
    
      GROUP BY `query`
    
      ORDER BY `query` ASC

    Objaśnienie

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Creating tmp table	0.05 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 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/admintools/feature/wafblacklist.php:92
    10	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:154
    8	plgSystemAdmintools->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]

    ---

15. Czas zapytania: 0.30 ms Po ostatnim zapytaniu: 2.46 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 13.413 MB

    UPDATE `zr6kn_extensions`
    
      SET `params` = '{\"mediaversion\":\"637d05310354fc2a95b64a7e0576ff46\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Objaśnienie

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init for update	0.07 ms
    Updating	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/djjquerymonster/djjquerymonster.php:54
    8	plgSystemDJjQueryMonster->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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]

    ---

16. Czas zapytania: 1.17 ms Po ostatnim zapytaniu: 16.48 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 14.595 MB Zwróconych wierszy: 46

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `zr6kn_assets`
    
      WHERE `name` IN ('root.1','com_aclmanager','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_focalpoint','com_govarticle','com_installer','com_jce','com_jch_optimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_visforms','com_watchfulli','com_weblinks','com_wrapper')

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zr6kn_assets	range	idx_asset_name	idx_asset_name	202	NULL	47	Using index condition

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.01 ms
    Statistics	0.45 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.39 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 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/libraries/src/Access/Access.php:429
    16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

17. Czas zapytania: 2.74 ms Po ostatnim zapytaniu: 0.21 ms Pamięć zapytania: 0.137 MB Pamięć przed zapytaniem: 14.652 MB Zwróconych wierszy: 1173

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `zr6kn_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    Objaśnienie

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	2.10 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 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/libraries/src/Access/Access.php:359
    16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
    11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

18. Czas zapytania: 1.72 ms Po ostatnim zapytaniu: 3.33 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 15.755 MB Zwróconych wierszy: 31

    SHOW FULL COLUMNS 
      FROM `zr6kn_content`

    Objaśnienie

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    closing tables	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.54 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    checking permissions	0.12 ms
    closing tables	0.01 ms
    checking permissions	0.00 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.42 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.31 ms
    Reset for next command	0.01 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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/libraries/src/Table/Content.php:39
    11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

19. Czas zapytania: 0.81 ms Po ostatnim zapytaniu: 3.59 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 15.993 MB

    UPDATE zr6kn_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '1241'

    Objaśnienie

    Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE zr6kn_content SET `hits` = (`hits` + 1) WHERE `id` = '1241'

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init for update	0.04 ms
    Updating	0.06 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.51 ms
    Query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

20. Czas zapytania: 1.03 ms Po ostatnim zapytaniu: 2.27 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 16.155 MB Zwróconych wierszy: 1

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM zr6kn_content AS a
    
      INNER JOIN zr6kn_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN zr6kn_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN zr6kn_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN zr6kn_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 1241 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-07-15 12:16:25') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-07-15 12:16:25') 
      AND (a.state = 1 OR a.state =2)

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

    Profile

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.40 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 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_content/models/article.php:151
    13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

21. Czas zapytania: 0.77 ms Po ostatnim zapytaniu: 1.98 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 16.325 MB Zwróconych wierszy: 2

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

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	104	Using where; Uruchomiono metodę filesort

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.10 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.14 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Identyczny z wywołaniem linii niżej.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

22. Czas zapytania: 0.42 ms Po ostatnim zapytaniu: 0.87 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 16.373 MB Zwróconych wierszy: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `zr6kn_contentitem_tag_map` AS m 
    
      INNER JOIN `zr6kn_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 1241 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	spsk1szn_joom3szpt.m.tag_id	1	Using where

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 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/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

23. Czas zapytania: 0.34 ms Po ostatnim zapytaniu: 1.90 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 17.069 MB Zwróconych wierszy: 1

    SELECT `extension_id`,`name`,`enabled`,`params`
    
      FROM zr6kn_extensions
    
      WHERE `type` = 'plugin' 
      AND `element` = 'osyoutube' 
      AND `folder` = 'content'

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zr6kn_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.04 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    21	JDatabaseDriver->loadObject()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170
    20	Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:140
    19	Alledia\Framework\Joomla\Extension\Generic->__construct()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:62
    18	Alledia\Framework\Joomla\Extension\Licensed->__construct()	JROOT/libraries/allediaframework/Framework/Factory.php:63
    17	Alledia\Framework\Factory::getExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:85
    16	Alledia\Framework\Joomla\Extension\AbstractPlugin->loadExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:56
    15	Alledia\Framework\Joomla\Extension\AbstractPlugin->init()	JROOT/plugins/content/osyoutube/library/BasePlugin.php:56
    14	Alledia\OSYouTube\BasePlugin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    13	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    12	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

24. Czas zapytania: 2.79 ms Po ostatnim zapytaniu: 26.15 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 19.129 MB Zwróconych wierszy: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM zr6kn_fields AS a
    
      LEFT JOIN `zr6kn_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN zr6kn_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN zr6kn_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN zr6kn_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN zr6kn_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `zr6kn_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (399,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Objaśnienie

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

    Profile

    Status	Duration
    Starting	0.58 ms
    checking permissions	0.01 ms
    Opening tables	0.30 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.56 ms
    Optimizing	0.40 ms
    Statistics	0.14 ms
    Preparing	0.05 ms
    Creating tmp table	0.08 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.32 ms
    Creating sort index	0.04 ms
    Removing tmp table	0.07 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

25. Czas zapytania: 0.28 ms Po ostatnim zapytaniu: 14.09 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 19.975 MB Zwróconych wierszy: 1

    SELECT `folderid`, `foldertime`, `entitytag` 
      FROM `zr6kn_sigplus_folder` 
      WHERE `folderurl` = '/home/spsk1szn/public_html/spsk1.szn.pl/images/centrum_urazowe'

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zr6kn_sigplus_folder	const	folderurl	folderurl	769	const	1

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
    21	JDatabaseDriver->loadRow()	JROOT/plugins/content/sigplus/core/core.php:3099
    20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:364
    19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:271
    18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:222
    17	plgContentSigPlusNovo->{closure:plgContentSigPlusNovo::parseContent():221}()	Identyczny z wywołaniem linii niżej.
    16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:219
    15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:132
    14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

26. Czas zapytania: 0.11 ms Po ostatnim zapytaniu: 0.08 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 19.984 MB

    START TRANSACTION

    Objaśnienie

    Polecenie EXPLAIN niemożliwe w zapytaniu: START TRANSACTION

    Profile

    Status	Duration
    Starting	0.03 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:837
    22	JDatabaseDriverMysqli->transactionStart()	JROOT/plugins/content/sigplus/core/core.php:1081
    21	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3107
    20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:364
    19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:271
    18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:222
    17	plgContentSigPlusNovo->{closure:plgContentSigPlusNovo::parseContent():221}()	Identyczny z wywołaniem linii niżej.
    16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:219
    15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:132
    14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

27. Czas zapytania: 0.37 ms Po ostatnim zapytaniu: 22.26 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 19.995 MB Zwróconych wierszy: 1

    SELECT viewid
    
      FROM zr6kn_sigplus_view
    
      WHERE folderid = 709 
      AND hash = 0xb44e40101bca7296a9c18565266b086a

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zr6kn_sigplus_view	const	hash,zr6kn_FK_sigplus_view_folder	hash	16	const	1

    Profile

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

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    26	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:1229
    25	SigPlusNovoGalleryBase->getView()	JROOT/plugins/content/sigplus/core/core.php:1234
    24	SigPlusNovoGalleryBase->insertView()	JROOT/plugins/content/sigplus/core/core.php:1909
    23	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1963
    22	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1083
    21	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3107
    20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:364
    19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:271
    18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:222
    17	plgContentSigPlusNovo->{closure:plgContentSigPlusNovo::parseContent():221}()	Identyczny z wywołaniem linii niżej.
    16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:219
    15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:132
    14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

28. Czas zapytania: 0.81 ms Po ostatnim zapytaniu: 0.10 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 20.005 MB Zwróconych wierszy: 0

    SELECT
    i.`fileurl`,
    i.`imageid`
    
      FROM `zr6kn_sigplus_image` AS i
    
      INNER JOIN `zr6kn_sigplus_folder` AS f
    
      ON i.`folderid` = f.`folderid`
    
      INNER JOIN `zr6kn_sigplus_hierarchy` AS h
    
      ON f.`folderid` = h.`descendantid`
    
      WHERE h.`ancestorid` = 709 
      AND NOT EXISTS (SELECT * 
      FROM `zr6kn_sigplus_imageview` AS v 
      WHERE i.`imageid` = v.`imageid` 
      AND v.`viewid` = 101) 
      AND depthnum <= 0

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	h	ref	PRIMARY,zr6kn_FK_sigplus_hierarchy_descendant,zr6kn_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
    1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	spsk1szn_joom3szpt.h.descendantid	1	Using index
    1	PRIMARY	i	ref	zr6kn_FK_sigplus_image_folder	zr6kn_FK_sigplus_image_folder	5	spsk1szn_joom3szpt.h.descendantid	2	Using where
    2	DEPENDENT SUBQUERY	v	unique_subquery	PRIMARY,zr6kn_FK_sigplus_imageview_view	PRIMARY	8	func,const	1	Using index; Using where

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.12 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.14 ms
    Preparing	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.14 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Removing tmp table	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
    25	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:1825
    24	SigPlusNovoLocalBase->getMissingImageViews()	JROOT/plugins/content/sigplus/core/core.php:1912
    23	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1963
    22	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1083
    21	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3107
    20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:364
    19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:271
    18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:222
    17	plgContentSigPlusNovo->{closure:plgContentSigPlusNovo::parseContent():221}()	Identyczny z wywołaniem linii niżej.
    16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:219
    15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:132
    14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

29. Czas zapytania: 0.11 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 20.015 MB

    COMMIT

    Objaśnienie

    Polecenie EXPLAIN niemożliwe w zapytaniu: COMMIT

    Profile

    Status	Duration
    Starting	0.01 ms
    Commit	0.01 ms
    starting	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:777
    22	JDatabaseDriverMysqli->transactionCommit()	JROOT/plugins/content/sigplus/core/core.php:1089
    21	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3107
    20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:364
    19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:271
    18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:222
    17	plgContentSigPlusNovo->{closure:plgContentSigPlusNovo::parseContent():221}()	Identyczny z wywołaniem linii niżej.
    16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:219
    15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:132
    14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

30. Czas zapytania: 0.33 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 20.024 MB Zwróconych wierszy: 1

    SELECT
    `langid`
    
      FROM `zr6kn_sigplus_language`
    
      WHERE
    `lang` = 'pl'

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zr6kn_sigplus_language	const	lang	lang	2	const	1	Using index

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.08 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    22	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:329
    21	SigPlusNovoDatabase::getLanguageId()	JROOT/plugins/content/sigplus/core/core.php:3185
    20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:364
    19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:271
    18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:222
    17	plgContentSigPlusNovo->{closure:plgContentSigPlusNovo::parseContent():221}()	Identyczny z wywołaniem linii niżej.
    16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:219
    15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:132
    14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

31. Czas zapytania: 0.32 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 20.034 MB Zwróconych wierszy: 1

    SELECT
    `countryid`
    
      FROM `zr6kn_sigplus_country`
    
      WHERE
    `country` = 'PL'

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zr6kn_sigplus_country	const	country	country	2	const	1	Using index

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.09 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    22	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:344
    21	SigPlusNovoDatabase::getCountryId()	JROOT/plugins/content/sigplus/core/core.php:3186
    20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:364
    19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:271
    18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:222
    17	plgContentSigPlusNovo->{closure:plgContentSigPlusNovo::parseContent():221}()	Identyczny z wywołaniem linii niżej.
    16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:219
    15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:132
    14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

32. Czas zapytania: 2.63 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 20.048 MB Zwróconych wierszy: 9
    Duplikaty zapytań: #33

    SELECT
    i.`imageid`,
    i.`fileurl`,
    i.`width`,
    i.`height`,
    i.`filesize`,
    COALESCE(
    c.`title`,
    (
    SELECT  md.`textvalue`
    
      FROM `zr6kn_sigplus_property` AS mp
    
      INNER JOIN `zr6kn_sigplus_data` AS md
    
      ON mp.`propertyid` = md.`propertyid`
    
      WHERE mp.`propertyname` = 'Headline' 
      AND md.`imageid` = i.`imageid`
    
      LIMIT 1
    ),
    (
    SELECT  md.`textvalue`
    
      FROM `zr6kn_sigplus_property` AS mp
    
      INNER JOIN `zr6kn_sigplus_data` AS md
    
      ON mp.`propertyid` = md.`propertyid`
    
      WHERE mp.`propertyname` = 'Object Name' 
      AND md.`imageid` = i.`imageid`
    
      LIMIT 1
    ),
    (
    SELECT  p.`title`
    
      FROM `zr6kn_sigplus_foldercaption` AS p
    
      WHERE
    p.`langid` = 129 
      AND 
    p.`countryid` = 151 
      AND 
    i.`filename` LIKE p.`pattern` 
      AND 
    i.`folderid` = p.`folderid`
    
      ORDER BY p.`priority` 
      LIMIT 1
    )
    ) AS `title`,
    COALESCE(
    c.`summary`,
    (
    SELECT  md.`textvalue`
    
      FROM `zr6kn_sigplus_property` AS mp
    
      INNER JOIN `zr6kn_sigplus_data` AS md
    
      ON mp.`propertyid` = md.`propertyid`
    
      WHERE mp.`propertyname` = 'Caption-Abstract' 
      AND md.`imageid` = i.`imageid`
    
      LIMIT 1
    ),
    (
    SELECT  p.`summary`
    
      FROM `zr6kn_sigplus_foldercaption` AS p
    
      WHERE
    p.`langid` = 129 
      AND 
    p.`countryid` = 151 
      AND 
    i.`filename` LIKE p.`pattern` 
      AND 
    i.`folderid` = p.`folderid`
    
      ORDER BY p.`priority` 
      LIMIT 1
    )
    ) AS `summary`,
    `thumb_fileurl`,
    `thumb_width`,
    `thumb_height`,
    `preview_fileurl`,
    `preview_width`,
    `preview_height`,
    `retina_fileurl`,
    `retina_width`,
    `retina_height`,
    `watermark_fileurl`
    
      FROM `zr6kn_sigplus_image` AS i
    
      INNER JOIN `zr6kn_sigplus_folder` AS f
    
      ON i.`folderid` = f.`folderid`
    
      INNER JOIN `zr6kn_sigplus_hierarchy` AS h
    
      ON f.`folderid` = h.`descendantid`
    
      INNER JOIN `zr6kn_sigplus_folder` AS a
    
      ON a.`folderid` = h.`ancestorid`
    
      INNER JOIN `zr6kn_sigplus_imageview` AS v
    
      ON i.`imageid` = v.`imageid`
    
      LEFT JOIN `zr6kn_sigplus_caption` AS c
    
      ON
    c.`imageid` = i.`imageid` 
      AND 
    c.`langid` = 129 
      AND 
    c.`countryid` = 151
    
      WHERE
    a.`folderurl` = '/home/spsk1szn/public_html/spsk1.szn.pl/images/centrum_urazowe' 
      AND 
    `viewid` = 101
    
     
      AND `depthnum` <= 0
    
    
      ORDER BY `depthnum` ASC, `filename` ASC

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Uruchomiono metodę filesort
    1	PRIMARY	h	ref	PRIMARY,zr6kn_FK_sigplus_hierarchy_descendant,zr6kn_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
    1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	spsk1szn_joom3szpt.h.descendantid	1	Using index
    1	PRIMARY	i	ref	PRIMARY,zr6kn_FK_sigplus_image_folder	zr6kn_FK_sigplus_image_folder	5	spsk1szn_joom3szpt.h.descendantid	2
    1	PRIMARY	v	eq_ref	PRIMARY,zr6kn_FK_sigplus_imageview_view	PRIMARY	8	spsk1szn_joom3szpt.i.imageid,const	1
    1	PRIMARY	c	eq_ref	PRIMARY,zr6kn_FK_sigplus_caption_language,zr6kn_FK_sigplus_caption_country	PRIMARY	8	spsk1szn_joom3szpt.i.imageid,const,const	1
    6	DEPENDENT SUBQUERY	p	index	PRIMARY,zr6kn_FK_sigplus_foldercaption_language,zr6kn_FK_sigplus_foldercaption_country	zr6kn_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
    5	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
    5	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,zr6kn_FK_sigplus_data_property	PRIMARY	8	spsk1szn_joom3szpt.i.imageid,const	1
    4	DEPENDENT SUBQUERY	p	index	PRIMARY,zr6kn_FK_sigplus_foldercaption_language,zr6kn_FK_sigplus_foldercaption_country	zr6kn_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
    3	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
    3	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,zr6kn_FK_sigplus_data_property	PRIMARY	8	spsk1szn_joom3szpt.i.imageid,const	1
    2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
    2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,zr6kn_FK_sigplus_data_property	PRIMARY	8	spsk1szn_joom3szpt.i.imageid,const	1

    Profile

    Status	Duration
    Sending data	0.01 ms
    Removing tmp table	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.07 ms
    Removing tmp table	0.24 ms
    Creating sort index	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.03 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/content/sigplus/core/core.php:3348
    20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:364
    19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:271
    18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:222
    17	plgContentSigPlusNovo->{closure:plgContentSigPlusNovo::parseContent():221}()	Identyczny z wywołaniem linii niżej.
    16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:219
    15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:132
    14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

33. Czas zapytania: 2.93 ms Po ostatnim zapytaniu: 0.06 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 20.061 MB Zwróconych wierszy: 9
    Duplikaty zapytań: #32

    SELECT
    i.`imageid`,
    i.`fileurl`,
    i.`width`,
    i.`height`,
    i.`filesize`,
    COALESCE(
    c.`title`,
    (
    SELECT  md.`textvalue`
    
      FROM `zr6kn_sigplus_property` AS mp
    
      INNER JOIN `zr6kn_sigplus_data` AS md
    
      ON mp.`propertyid` = md.`propertyid`
    
      WHERE mp.`propertyname` = 'Headline' 
      AND md.`imageid` = i.`imageid`
    
      LIMIT 1
    ),
    (
    SELECT  md.`textvalue`
    
      FROM `zr6kn_sigplus_property` AS mp
    
      INNER JOIN `zr6kn_sigplus_data` AS md
    
      ON mp.`propertyid` = md.`propertyid`
    
      WHERE mp.`propertyname` = 'Object Name' 
      AND md.`imageid` = i.`imageid`
    
      LIMIT 1
    ),
    (
    SELECT  p.`title`
    
      FROM `zr6kn_sigplus_foldercaption` AS p
    
      WHERE
    p.`langid` = 129 
      AND 
    p.`countryid` = 151 
      AND 
    i.`filename` LIKE p.`pattern` 
      AND 
    i.`folderid` = p.`folderid`
    
      ORDER BY p.`priority` 
      LIMIT 1
    )
    ) AS `title`,
    COALESCE(
    c.`summary`,
    (
    SELECT  md.`textvalue`
    
      FROM `zr6kn_sigplus_property` AS mp
    
      INNER JOIN `zr6kn_sigplus_data` AS md
    
      ON mp.`propertyid` = md.`propertyid`
    
      WHERE mp.`propertyname` = 'Caption-Abstract' 
      AND md.`imageid` = i.`imageid`
    
      LIMIT 1
    ),
    (
    SELECT  p.`summary`
    
      FROM `zr6kn_sigplus_foldercaption` AS p
    
      WHERE
    p.`langid` = 129 
      AND 
    p.`countryid` = 151 
      AND 
    i.`filename` LIKE p.`pattern` 
      AND 
    i.`folderid` = p.`folderid`
    
      ORDER BY p.`priority` 
      LIMIT 1
    )
    ) AS `summary`,
    `thumb_fileurl`,
    `thumb_width`,
    `thumb_height`,
    `preview_fileurl`,
    `preview_width`,
    `preview_height`,
    `retina_fileurl`,
    `retina_width`,
    `retina_height`,
    `watermark_fileurl`
    
      FROM `zr6kn_sigplus_image` AS i
    
      INNER JOIN `zr6kn_sigplus_folder` AS f
    
      ON i.`folderid` = f.`folderid`
    
      INNER JOIN `zr6kn_sigplus_hierarchy` AS h
    
      ON f.`folderid` = h.`descendantid`
    
      INNER JOIN `zr6kn_sigplus_folder` AS a
    
      ON a.`folderid` = h.`ancestorid`
    
      INNER JOIN `zr6kn_sigplus_imageview` AS v
    
      ON i.`imageid` = v.`imageid`
    
      LEFT JOIN `zr6kn_sigplus_caption` AS c
    
      ON
    c.`imageid` = i.`imageid` 
      AND 
    c.`langid` = 129 
      AND 
    c.`countryid` = 151
    
      WHERE
    a.`folderurl` = '/home/spsk1szn/public_html/spsk1.szn.pl/images/centrum_urazowe' 
      AND 
    `viewid` = 101
    
     
      AND `depthnum` <= 0
    
    
      ORDER BY `depthnum` ASC, `filename` ASC

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Uruchomiono metodę filesort
    1	PRIMARY	h	ref	PRIMARY,zr6kn_FK_sigplus_hierarchy_descendant,zr6kn_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
    1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	spsk1szn_joom3szpt.h.descendantid	1	Using index
    1	PRIMARY	i	ref	PRIMARY,zr6kn_FK_sigplus_image_folder	zr6kn_FK_sigplus_image_folder	5	spsk1szn_joom3szpt.h.descendantid	2
    1	PRIMARY	v	eq_ref	PRIMARY,zr6kn_FK_sigplus_imageview_view	PRIMARY	8	spsk1szn_joom3szpt.i.imageid,const	1
    1	PRIMARY	c	eq_ref	PRIMARY,zr6kn_FK_sigplus_caption_language,zr6kn_FK_sigplus_caption_country	PRIMARY	8	spsk1szn_joom3szpt.i.imageid,const,const	1
    6	DEPENDENT SUBQUERY	p	index	PRIMARY,zr6kn_FK_sigplus_foldercaption_language,zr6kn_FK_sigplus_foldercaption_country	zr6kn_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
    5	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
    5	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,zr6kn_FK_sigplus_data_property	PRIMARY	8	spsk1szn_joom3szpt.i.imageid,const	1
    4	DEPENDENT SUBQUERY	p	index	PRIMARY,zr6kn_FK_sigplus_foldercaption_language,zr6kn_FK_sigplus_foldercaption_country	zr6kn_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
    3	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
    3	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,zr6kn_FK_sigplus_data_property	PRIMARY	8	spsk1szn_joom3szpt.i.imageid,const	1
    2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
    2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,zr6kn_FK_sigplus_data_property	PRIMARY	8	spsk1szn_joom3szpt.i.imageid,const	1

    Profile

    Status	Duration
    Sending data	0.01 ms
    Removing tmp table	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.18 ms
    Sending data	0.06 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    Executing	0.01 ms
    Sending data	0.12 ms
    Executing	0.04 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.12 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.07 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
    21	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:3355
    20	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:364
    19	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:271
    18	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:222
    17	plgContentSigPlusNovo->{closure:plgContentSigPlusNovo::parseContent():221}()	Identyczny z wywołaniem linii niżej.
    16	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:219
    15	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:132
    14	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
    11	ContentViewArticle->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_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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]

    ---

34. Czas zapytania: 0.40 ms Po ostatnim zapytaniu: 29.48 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 22.116 MB Zwróconych wierszy: 1

    SELECT `value`
    
      FROM `zr6kn_admintools_storage`
    
      WHERE `key` = 'criticalfiles'

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	zr6kn_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/plugins/system/admintools/feature/criticalfiles.php:204
    10	AtsystemFeatureCriticalfiles->load()	JROOT/plugins/system/admintools/feature/criticalfiles.php:32
    9	AtsystemFeatureCriticalfiles->onAfterRender()	JROOT/plugins/system/admintools/admintools/main.php:308
    8	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:187
    7	plgSystemAdmintools->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    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]

    ---