Konsola diagnostyczna Joomla!

Sesja

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

Informacje o wydajności

Użycie pamięci

Zapytania do bazy danych

36 zapytań zarejestrowanych 45.18 ms

Czas zapytania: 0.62 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 1.675 MB Zwróconych wierszy: 0

SELECT `data`

  FROM `rqagi_session`

  WHERE `session_id` = 'j4itoqflv9aup7hc5qlk2gsm43'

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Identyczny z wywołaniem linii niżej.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:451
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Czas zapytania: 0.21 ms Po ostatnim zapytaniu: 1.61 ms Pamięć zapytania: 0.012 MB Pamięć przed zapytaniem: 1.732 MB Zwróconych wierszy: 0

SELECT `session_id`

  FROM `rqagi_session`

  WHERE `session_id` = 'j4itoqflv9aup7hc5qlk2gsm43' 
  LIMIT 1

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
7	JDatabaseDriver->loadResult()	JROOT/libraries/src/Application/CMSApplication.php:214
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:451
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Czas zapytania: 0.51 ms Po ostatnim zapytaniu: 0.25 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 1.747 MB

INSERT INTO `rqagi_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('j4itoqflv9aup7hc5qlk2gsm43', 1, '1537861896', 0, '', 0)

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Application/CMSApplication.php:254
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:451
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Czas zapytania: 1.12 ms Po ostatnim zapytaniu: 3.21 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 1.827 MB Zwróconych wierszy: 37

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `rqagi_extensions`

  WHERE `type` = 'component'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqagi_extensions	NULL	ref	extension	extension	82	const	26	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:423
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Identyczny z wywołaniem linii niżej.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:431
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:497
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.45 ms Po ostatnim zapytaniu: 2.88 ms Pamięć zapytania: 0.015 MB Pamięć przed zapytaniem: 1.924 MB Zwróconych wierszy: 5

SELECT id, rules

  FROM `rqagi_viewlevels`

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.55 ms Po ostatnim zapytaniu: 0.24 ms Pamięć zapytania: 0.016 MB Pamięć przed zapytaniem: 1.949 MB Zwróconych wierszy: 2

SELECT b.id

  FROM rqagi_usergroups AS a

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

  WHERE a.id = 9

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.62 ms Po ostatnim zapytaniu: 0.61 ms Pamięć zapytania: 0.019 MB Pamięć przed zapytaniem: 1.988 MB Zwróconych wierszy: 83

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM rqagi_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqagi_extensions	NULL	ref	extension	extension	82	const	115	0.60	Using index condition; Using where; Uruchomiono metodę filesort

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Identyczny z wywołaniem linii niżej.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:348
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.69 ms Po ostatnim zapytaniu: 51.59 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 2.797 MB Zwróconych wierszy: 1

SELECT `params`

  FROM `rqagi_extensions`

  WHERE `type` = 'plugin' 
  AND `element` = 'perfectdashboard' 
  AND `folder` = 'system' 
  AND `client_id` = '0'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqagi_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	const,const	1	5.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/perfectdashboard/Cms/Joomla/Config.php:120
13	PerfectDashboard_Cms_Joomla_Config->loadOptions()	JROOT/plugins/system/perfectdashboard/Cms/Joomla/Config.php:46
12	PerfectDashboard_Cms_Joomla_Config->getOption()	JROOT/plugins/system/perfectdashboard/lib/src/Config.php:38
11	PerfectDashboard_Config::get()	JROOT/plugins/system/perfectdashboard/lib/src/Installer.php:87
10	PerfectDashboard_Installer->selfUpdate()	JROOT/plugins/system/perfectdashboard/perfectdashboard.php:51
9	PlgSystemPerfectdashboard->onAfterInitialise()	Identyczny z wywołaniem linii niżej.
8	call_user_func_array()	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:722
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.36 ms Po ostatnim zapytaniu: 3.20 ms Pamięć zapytania: 0.031 MB Pamięć przed zapytaniem: 2.910 MB Zwróconych wierszy: 17

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM rqagi_menu AS m

  LEFT JOIN rqagi_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	1	5.00	Using index condition; Using where; Uruchomiono metodę filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	m1399_fest8.m.component_id	1	100.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Identyczny z wywołaniem linii niżej.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:482
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:587
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1169
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.62 ms Po ostatnim zapytaniu: 14.29 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 3.259 MB Zwróconych wierszy: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `rqagi_extensions`

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

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqagi_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Identyczny z wywołaniem linii niżej.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.50 ms Po ostatnim zapytaniu: 0.53 ms Pamięć zapytania: 0.013 MB Pamięć przed zapytaniem: 3.261 MB

UPDATE `rqagi_extensions`

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

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

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.51 ms Po ostatnim zapytaniu: 2.09 ms Pamięć zapytania: 0.014 MB Pamięć przed zapytaniem: 3.345 MB Zwróconych wierszy: 2

SELECT *

  FROM rqagi_languages

  WHERE published=1

  ORDER BY ordering ASC

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.48 ms Po ostatnim zapytaniu: 0.79 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 3.378 MB Zwróconych wierszy: 8

SELECT id, home, template, s.params

  FROM rqagi_template_styles as s

  LEFT JOIN rqagi_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	10	10.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	m1399_fest8.s.template,const	1	5.00	Using index condition; Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.45 ms Po ostatnim zapytaniu: 17.73 ms Pamięć zapytania: 0.014 MB Pamięć przed zapytaniem: 3.714 MB Zwróconych wierszy: 0

SELECT `name`

  FROM `rqagi_extensions`

  WHERE `type` = 'package' 
  AND `element` = 'pkg_eventgallery_full'

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_eventgallery/version.php:24
7	include_once JROOT/administrator/components/com_eventgallery/version.php	JROOT/components/com_eventgallery/eventgallery.php:14
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.39 ms Po ostatnim zapytaniu: 220.35 ms Pamięć zapytania: 0.032 MB Pamięć przed zapytaniem: 4.194 MB Zwróconych wierszy: 3

SELECT folder.*, count(1) AS `overallCount`

  FROM `rqagi_eventgallery_folder` AS folder
 JOIN `rqagi_eventgallery_file` AS file 
  ON folder.folder = file.folder 
  and file.published=1

  WHERE (file.ismainimageonly IS NULL OR file.ismainimageonly=0) 
  AND folder.published=1

  GROUP BY folder.id

  ORDER BY ordering DESC

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	folder	NULL	index	PRIMARY,folder	PRIMARY	4	NULL	1	100.00	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	file	NULL	ref	file,index_folder	file	377	m1399_fest8.folder.folder	147	1.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_eventgallery/models/events.php:163
16	EventgalleryModelEvents->getEntriesUnCached()	Identyczny z wywołaniem linii niżej.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
13	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_eventgallery/models/events.php:85
12	EventgalleryModelEvents->getEntries()	JROOT/components/com_eventgallery/views/events/view.html.php:70
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.63 ms Po ostatnim zapytaniu: 1.01 ms Pamięć zapytania: 0.034 MB Pamięć przed zapytaniem: 4.262 MB Zwróconych wierszy: 3

SELECT f.*, ft.folderhandlerclassname

  FROM rqagi_eventgallery_folder f, rqagi_eventgallery_foldertype ft

  WHERE f.foldertypeid=ft.id

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	ft	NULL	eq_ref	PRIMARY	PRIMARY	4	m1399_fest8.f.foldertypeid	1	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventgallery/library/factory/folder.php:85
19	EventgalleryLibraryFactoryFolder->getAllFoldersFromDatabase()	JROOT/components/com_eventgallery/library/factory/folder.php:50
18	EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject()	JROOT/components/com_eventgallery/library/factory/folder.php:36
17	EventgalleryLibraryFactoryFolder->getFolder()	JROOT/components/com_eventgallery/models/events.php:174
16	EventgalleryModelEvents->getEntriesUnCached()	Identyczny z wywołaniem linii niżej.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
13	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_eventgallery/models/events.php:85
12	EventgalleryModelEvents->getEntries()	JROOT/components/com_eventgallery/views/events/view.html.php:70
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.70 ms Po ostatnim zapytaniu: 22.10 ms Pamięć zapytania: 0.034 MB Pamięć przed zapytaniem: 4.379 MB Zwróconych wierszy: 2

SELECT *

  FROM rqagi_eventgallery_imagetypeset

  ORDER BY `default` DESC,ordering

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:129
22	EventgalleryLibraryFactoryImagetypeset->getImageTypeSets()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169
21	EventgalleryLibraryFactoryImagetypeset->getImageTypeSet()	JROOT/components/com_eventgallery/library/folder.php:166
20	EventgalleryLibraryFolder->_prepareData()	JROOT/components/com_eventgallery/library/folder.php:83
19	EventgalleryLibraryFolder->__construct()	JROOT/components/com_eventgallery/library/factory/folder.php:66
18	EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject()	JROOT/components/com_eventgallery/library/factory/folder.php:36
17	EventgalleryLibraryFactoryFolder->getFolder()	JROOT/components/com_eventgallery/models/events.php:174
16	EventgalleryModelEvents->getEntriesUnCached()	Identyczny z wywołaniem linii niżej.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
13	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_eventgallery/models/events.php:85
12	EventgalleryModelEvents->getEntries()	JROOT/components/com_eventgallery/views/events/view.html.php:70
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.95 ms Po ostatnim zapytaniu: 0.75 ms Pamięć zapytania: 0.039 MB Pamięć przed zapytaniem: 4.438 MB Zwróconych wierszy: 3

SELECT t.*

  FROM rqagi_eventgallery_imagetypeset_imagetype_assignment tsta 
  left join rqagi_eventgallery_imagetype t 
  on tsta.imagetypeid=t.id

  WHERE tsta.imagetypesetid='2'

  ORDER BY tsta.ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tsta	NULL	ref	PRIMARY	PRIMARY	4	const	3	100.00	Using where; Uruchomiono metodę filesort
1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	m1399_fest8.tsta.imagetypeid	1	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:66
24	EventgalleryLibraryFactoryImagetypeset->getImagetypes()	JROOT/components/com_eventgallery/library/imagetypeset.php:59
23	EventgalleryLibraryImagetypeset->__construct()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138
22	EventgalleryLibraryFactoryImagetypeset->getImageTypeSets()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169
21	EventgalleryLibraryFactoryImagetypeset->getImageTypeSet()	JROOT/components/com_eventgallery/library/folder.php:166
20	EventgalleryLibraryFolder->_prepareData()	JROOT/components/com_eventgallery/library/folder.php:83
19	EventgalleryLibraryFolder->__construct()	JROOT/components/com_eventgallery/library/factory/folder.php:66
18	EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject()	JROOT/components/com_eventgallery/library/factory/folder.php:36
17	EventgalleryLibraryFactoryFolder->getFolder()	JROOT/components/com_eventgallery/models/events.php:174
16	EventgalleryModelEvents->getEntriesUnCached()	Identyczny z wywołaniem linii niżej.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
13	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_eventgallery/models/events.php:85
12	EventgalleryModelEvents->getEntries()	JROOT/components/com_eventgallery/views/events/view.html.php:70
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.36 ms Po ostatnim zapytaniu: 0.25 ms Pamięć zapytania: 0.043 MB Pamięć przed zapytaniem: 4.487 MB Zwróconych wierszy: 6

SELECT *

  FROM rqagi_eventgallery_imagetype

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
27	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventgallery/library/factory/imagetype.php:51
26	EventgalleryLibraryFactoryImagetype->getImageTypes()	JROOT/components/com_eventgallery/library/factory/imagetype.php:27
25	EventgalleryLibraryFactoryImagetype->getImagetypeById()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:70
24	EventgalleryLibraryFactoryImagetypeset->getImagetypes()	JROOT/components/com_eventgallery/library/imagetypeset.php:59
23	EventgalleryLibraryImagetypeset->__construct()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138
22	EventgalleryLibraryFactoryImagetypeset->getImageTypeSets()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169
21	EventgalleryLibraryFactoryImagetypeset->getImageTypeSet()	JROOT/components/com_eventgallery/library/folder.php:166
20	EventgalleryLibraryFolder->_prepareData()	JROOT/components/com_eventgallery/library/folder.php:83
19	EventgalleryLibraryFolder->__construct()	JROOT/components/com_eventgallery/library/factory/folder.php:66
18	EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject()	JROOT/components/com_eventgallery/library/factory/folder.php:36
17	EventgalleryLibraryFactoryFolder->getFolder()	JROOT/components/com_eventgallery/models/events.php:174
16	EventgalleryModelEvents->getEntriesUnCached()	Identyczny z wywołaniem linii niżej.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
13	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_eventgallery/models/events.php:85
12	EventgalleryModelEvents->getEntries()	JROOT/components/com_eventgallery/views/events/view.html.php:70
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.80 ms Po ostatnim zapytaniu: 1.40 ms Pamięć zapytania: 0.039 MB Pamięć przed zapytaniem: 4.586 MB Zwróconych wierszy: 2

SELECT t.*

  FROM rqagi_eventgallery_imagetypeset_imagetype_assignment tsta 
  left join rqagi_eventgallery_imagetype t 
  on tsta.imagetypeid=t.id

  WHERE tsta.imagetypesetid='2' 
  AND published=1

  ORDER BY tsta.ordering

Objaśnienie

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

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:66
24	EventgalleryLibraryFactoryImagetypeset->getImagetypes()	JROOT/components/com_eventgallery/library/imagetypeset.php:60
23	EventgalleryLibraryImagetypeset->__construct()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138
22	EventgalleryLibraryFactoryImagetypeset->getImageTypeSets()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169
21	EventgalleryLibraryFactoryImagetypeset->getImageTypeSet()	JROOT/components/com_eventgallery/library/folder.php:166
20	EventgalleryLibraryFolder->_prepareData()	JROOT/components/com_eventgallery/library/folder.php:83
19	EventgalleryLibraryFolder->__construct()	JROOT/components/com_eventgallery/library/factory/folder.php:66
18	EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject()	JROOT/components/com_eventgallery/library/factory/folder.php:36
17	EventgalleryLibraryFactoryFolder->getFolder()	JROOT/components/com_eventgallery/models/events.php:174
16	EventgalleryModelEvents->getEntriesUnCached()	Identyczny z wywołaniem linii niżej.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
13	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_eventgallery/models/events.php:85
12	EventgalleryModelEvents->getEntries()	JROOT/components/com_eventgallery/views/events/view.html.php:70
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.32 ms Po ostatnim zapytaniu: 0.25 ms Pamięć zapytania: 0.040 MB Pamięć przed zapytaniem: 4.619 MB Zwróconych wierszy: 3

SELECT t.*, tsta.default as defaultimagetype

  FROM rqagi_eventgallery_imagetypeset_imagetype_assignment tsta 
  left join rqagi_eventgallery_imagetype t 
  on tsta.imagetypeid=t.id

  WHERE tsta.imagetypesetid='2'

  ORDER BY tsta.ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tsta	NULL	ref	PRIMARY	PRIMARY	4	const	3	100.00	Using where; Uruchomiono metodę filesort
1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	m1399_fest8.tsta.imagetypeid	1	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:93
24	EventgalleryLibraryFactoryImagetypeset->getDefaultImagetype()	JROOT/components/com_eventgallery/library/imagetypeset.php:61
23	EventgalleryLibraryImagetypeset->__construct()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138
22	EventgalleryLibraryFactoryImagetypeset->getImageTypeSets()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169
21	EventgalleryLibraryFactoryImagetypeset->getImageTypeSet()	JROOT/components/com_eventgallery/library/folder.php:166
20	EventgalleryLibraryFolder->_prepareData()	JROOT/components/com_eventgallery/library/folder.php:83
19	EventgalleryLibraryFolder->__construct()	JROOT/components/com_eventgallery/library/factory/folder.php:66
18	EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject()	JROOT/components/com_eventgallery/library/factory/folder.php:36
17	EventgalleryLibraryFactoryFolder->getFolder()	JROOT/components/com_eventgallery/models/events.php:174
16	EventgalleryModelEvents->getEntriesUnCached()	Identyczny z wywołaniem linii niżej.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
13	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_eventgallery/models/events.php:85
12	EventgalleryModelEvents->getEntries()	JROOT/components/com_eventgallery/views/events/view.html.php:70
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.29 ms Po ostatnim zapytaniu: 0.28 ms Pamięć zapytania: 0.039 MB Pamięć przed zapytaniem: 4.652 MB Zwróconych wierszy: 4

SELECT t.*

  FROM rqagi_eventgallery_imagetypeset_imagetype_assignment tsta 
  left join rqagi_eventgallery_imagetype t 
  on tsta.imagetypeid=t.id

  WHERE tsta.imagetypesetid='1'

  ORDER BY tsta.ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tsta	NULL	ref	PRIMARY	PRIMARY	4	const	4	100.00	Using where; Uruchomiono metodę filesort
1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	m1399_fest8.tsta.imagetypeid	1	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:66
24	EventgalleryLibraryFactoryImagetypeset->getImagetypes()	JROOT/components/com_eventgallery/library/imagetypeset.php:59
23	EventgalleryLibraryImagetypeset->__construct()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138
22	EventgalleryLibraryFactoryImagetypeset->getImageTypeSets()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169
21	EventgalleryLibraryFactoryImagetypeset->getImageTypeSet()	JROOT/components/com_eventgallery/library/folder.php:166
20	EventgalleryLibraryFolder->_prepareData()	JROOT/components/com_eventgallery/library/folder.php:83
19	EventgalleryLibraryFolder->__construct()	JROOT/components/com_eventgallery/library/factory/folder.php:66
18	EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject()	JROOT/components/com_eventgallery/library/factory/folder.php:36
17	EventgalleryLibraryFactoryFolder->getFolder()	JROOT/components/com_eventgallery/models/events.php:174
16	EventgalleryModelEvents->getEntriesUnCached()	Identyczny z wywołaniem linii niżej.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
13	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_eventgallery/models/events.php:85
12	EventgalleryModelEvents->getEntries()	JROOT/components/com_eventgallery/views/events/view.html.php:70
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.52 ms Po ostatnim zapytaniu: 0.28 ms Pamięć zapytania: 0.039 MB Pamięć przed zapytaniem: 4.686 MB Zwróconych wierszy: 3

SELECT t.*

  FROM rqagi_eventgallery_imagetypeset_imagetype_assignment tsta 
  left join rqagi_eventgallery_imagetype t 
  on tsta.imagetypeid=t.id

  WHERE tsta.imagetypesetid='1' 
  AND published=1

  ORDER BY tsta.ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	6	16.67	Using where; Using temporary; Uruchomiono metodę filesort
1	SIMPLE	tsta	NULL	eq_ref	PRIMARY	PRIMARY	8	const,m1399_fest8.t.id	1	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:66
24	EventgalleryLibraryFactoryImagetypeset->getImagetypes()	JROOT/components/com_eventgallery/library/imagetypeset.php:60
23	EventgalleryLibraryImagetypeset->__construct()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138
22	EventgalleryLibraryFactoryImagetypeset->getImageTypeSets()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169
21	EventgalleryLibraryFactoryImagetypeset->getImageTypeSet()	JROOT/components/com_eventgallery/library/folder.php:166
20	EventgalleryLibraryFolder->_prepareData()	JROOT/components/com_eventgallery/library/folder.php:83
19	EventgalleryLibraryFolder->__construct()	JROOT/components/com_eventgallery/library/factory/folder.php:66
18	EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject()	JROOT/components/com_eventgallery/library/factory/folder.php:36
17	EventgalleryLibraryFactoryFolder->getFolder()	JROOT/components/com_eventgallery/models/events.php:174
16	EventgalleryModelEvents->getEntriesUnCached()	Identyczny z wywołaniem linii niżej.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
13	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_eventgallery/models/events.php:85
12	EventgalleryModelEvents->getEntries()	JROOT/components/com_eventgallery/views/events/view.html.php:70
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.31 ms Po ostatnim zapytaniu: 0.25 ms Pamięć zapytania: 0.040 MB Pamięć przed zapytaniem: 4.719 MB Zwróconych wierszy: 4

SELECT t.*, tsta.default as defaultimagetype

  FROM rqagi_eventgallery_imagetypeset_imagetype_assignment tsta 
  left join rqagi_eventgallery_imagetype t 
  on tsta.imagetypeid=t.id

  WHERE tsta.imagetypesetid='1'

  ORDER BY tsta.ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tsta	NULL	ref	PRIMARY	PRIMARY	4	const	4	100.00	Using where; Uruchomiono metodę filesort
1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	m1399_fest8.tsta.imagetypeid	1	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:93
24	EventgalleryLibraryFactoryImagetypeset->getDefaultImagetype()	JROOT/components/com_eventgallery/library/imagetypeset.php:61
23	EventgalleryLibraryImagetypeset->__construct()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:138
22	EventgalleryLibraryFactoryImagetypeset->getImageTypeSets()	JROOT/components/com_eventgallery/library/factory/imagetypeset.php:169
21	EventgalleryLibraryFactoryImagetypeset->getImageTypeSet()	JROOT/components/com_eventgallery/library/folder.php:166
20	EventgalleryLibraryFolder->_prepareData()	JROOT/components/com_eventgallery/library/folder.php:83
19	EventgalleryLibraryFolder->__construct()	JROOT/components/com_eventgallery/library/factory/folder.php:66
18	EventgalleryLibraryFactoryFolder->getFolderFromDatabaseObject()	JROOT/components/com_eventgallery/library/factory/folder.php:36
17	EventgalleryLibraryFactoryFolder->getFolder()	JROOT/components/com_eventgallery/models/events.php:174
16	EventgalleryModelEvents->getEntriesUnCached()	Identyczny z wywołaniem linii niżej.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
13	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_eventgallery/models/events.php:85
12	EventgalleryModelEvents->getEntries()	JROOT/components/com_eventgallery/views/events/view.html.php:70
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 2.45 ms Po ostatnim zapytaniu: 73.68 ms Pamięć zapytania: 0.044 MB Pamięć przed zapytaniem: 5.020 MB Zwróconych wierszy: 0

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

  FROM rqagi_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_eventgallery.event' 
  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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Uruchomiono metodę filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	m1399_fest8.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	m1399_fest8.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	m1399_fest8.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	m1399_fest8.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	m1399_fest8.a.group_id	1	100.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
27	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
26	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
25	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:427
24	PlgSystemFields->onContentPrepare()	Identyczny z wywołaniem linii niżej.
23	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
21	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
20	JHtmlContent::prepare()	Identyczny z wywołaniem linii niżej.
19	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
18	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
17	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php:15
16	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php	JROOT/components/com_eventgallery/library/common/view.php:114
15	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/events/tmpl/default.php:17
14	include JROOT/components/com_eventgallery/views/events/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_eventgallery/views/events/view.html.php:79
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.97 ms Po ostatnim zapytaniu: 2.01 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 5.083 MB Zwróconych wierszy: 1

SELECT count(1)

  FROM `rqagi_eventgallery_file` AS file

  WHERE folder='BursztynoweWybrzeeMikoszewo2018' 
  AND (file.ismainimageonly IS NULL OR file.ismainimageonly=0) 
  AND file.published=1

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	file	NULL	ref	file,index_folder	file	377	const	223	1.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
20	JDatabaseDriver->loadResult()	JROOT/components/com_eventgallery/library/folder.php:456
19	EventgalleryLibraryFolder->getFileCount()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php:22
18	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php	JROOT/components/com_eventgallery/library/common/view.php:114
17	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php:32
16	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php	JROOT/components/com_eventgallery/library/common/view.php:114
15	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/events/tmpl/default.php:17
14	include JROOT/components/com_eventgallery/views/events/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_eventgallery/views/events/view.html.php:79
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 6.78 ms Po ostatnim zapytaniu: 0.30 ms Pamięć zapytania: 0.036 MB Pamięć przed zapytaniem: 5.115 MB Zwróconych wierszy: 1

SELECT file.*, COUNT(comment.id) AS `commentCount`

  FROM `rqagi_eventgallery_file` AS file

  INNER JOIN `rqagi_eventgallery_folder` AS folder 
  ON folder.folder=file.folder 
  and folder.published=1

  LEFT JOIN `rqagi_eventgallery_comment` AS comment 
  ON file.folder=comment.folder 
  and file.file=comment.file

  WHERE file.folder='BursztynoweWybrzeeMikoszewo2018' 
  AND file.published=1

  GROUP BY file.id

  ORDER BY file.ismainimage DESC, ordering DESC, file.file 
  LIMIT 1

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	folder	NULL	const	folder	folder	377	const	1	100.00	Using temporary; Uruchomiono metodę filesort
1	SIMPLE	file	NULL	ref	PRIMARY,file,index_file,index_folder	file	377	const	223	10.00	Using index condition; Using where
1	SIMPLE	comment	NULL	ref	filefolderkey	filefolderkey	754	const,m1399_fest8.file.file	1	100.00	Using index

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventgallery/library/folder.php:524
19	EventgalleryLibraryFolder->getFiles()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php:30
18	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php	JROOT/components/com_eventgallery/library/common/view.php:114
17	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php:32
16	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php	JROOT/components/com_eventgallery/library/common/view.php:114
15	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/events/tmpl/default.php:17
14	include JROOT/components/com_eventgallery/views/events/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_eventgallery/views/events/view.html.php:79
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.39 ms Po ostatnim zapytaniu: 3.71 ms Pamięć zapytania: 0.040 MB Pamięć przed zapytaniem: 5.211 MB Zwróconych wierszy: 1

SELECT *

  FROM rqagi_eventgallery_file

  WHERE folder='BursztynoweWybrzeeMikoszewo2018' 
  AND file='DSC06977.JPG'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqagi_eventgallery_file	NULL	const	file,index_file,index_folder	file	754	const,const	1	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
23	JDatabaseDriver->loadObject()	JROOT/components/com_eventgallery/library/factory/file/local.php:47
22	EventgalleryLibraryFactoryFileLocal->getFileDBData()	JROOT/components/com_eventgallery/library/factory/file/local.php:28
21	EventgalleryLibraryFactoryFileLocal->getFile()	JROOT/components/com_eventgallery/library/factory/file.php:44
20	EventgalleryLibraryFactoryFile->getFile()	JROOT/components/com_eventgallery/library/folder.php:533
19	EventgalleryLibraryFolder->getFiles()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php:30
18	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php	JROOT/components/com_eventgallery/library/common/view.php:114
17	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php:32
16	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php	JROOT/components/com_eventgallery/library/common/view.php:114
15	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/events/tmpl/default.php:17
14	include JROOT/components/com_eventgallery/views/events/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_eventgallery/views/events/view.html.php:79
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.76 ms Po ostatnim zapytaniu: 1.32 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 5.239 MB Zwróconych wierszy: 1

SELECT count(1)

  FROM `rqagi_eventgallery_file` AS file

  WHERE folder='Mikoszewo2017' 
  AND (file.ismainimageonly IS NULL OR file.ismainimageonly=0) 
  AND file.published=1

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	file	NULL	ref	file,index_folder	file	377	const	186	1.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
20	JDatabaseDriver->loadResult()	JROOT/components/com_eventgallery/library/folder.php:456
19	EventgalleryLibraryFolder->getFileCount()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php:22
18	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php	JROOT/components/com_eventgallery/library/common/view.php:114
17	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php:32
16	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php	JROOT/components/com_eventgallery/library/common/view.php:114
15	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/events/tmpl/default.php:17
14	include JROOT/components/com_eventgallery/views/events/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_eventgallery/views/events/view.html.php:79
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 5.34 ms Po ostatnim zapytaniu: 0.28 ms Pamięć zapytania: 0.036 MB Pamięć przed zapytaniem: 5.271 MB Zwróconych wierszy: 1

SELECT file.*, COUNT(comment.id) AS `commentCount`

  FROM `rqagi_eventgallery_file` AS file

  INNER JOIN `rqagi_eventgallery_folder` AS folder 
  ON folder.folder=file.folder 
  and folder.published=1

  LEFT JOIN `rqagi_eventgallery_comment` AS comment 
  ON file.folder=comment.folder 
  and file.file=comment.file

  WHERE file.folder='Mikoszewo2017' 
  AND file.published=1

  GROUP BY file.id

  ORDER BY file.ismainimage DESC, ordering DESC, file.file 
  LIMIT 1

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	folder	NULL	const	folder	folder	377	const	1	100.00	Using temporary; Uruchomiono metodę filesort
1	SIMPLE	file	NULL	ref	PRIMARY,file,index_file,index_folder	file	377	const	186	10.00	Using index condition; Using where
1	SIMPLE	comment	NULL	ref	filefolderkey	filefolderkey	754	const,m1399_fest8.file.file	1	100.00	Using index

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventgallery/library/folder.php:524
19	EventgalleryLibraryFolder->getFiles()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php:30
18	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php	JROOT/components/com_eventgallery/library/common/view.php:114
17	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php:32
16	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php	JROOT/components/com_eventgallery/library/common/view.php:114
15	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/events/tmpl/default.php:17
14	include JROOT/components/com_eventgallery/views/events/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_eventgallery/views/events/view.html.php:79
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.59 ms Po ostatnim zapytaniu: 0.36 ms Pamięć zapytania: 0.040 MB Pamięć przed zapytaniem: 5.308 MB Zwróconych wierszy: 1

SELECT *

  FROM rqagi_eventgallery_file

  WHERE folder='Mikoszewo2017' 
  AND file='20170615_131839.jpg'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqagi_eventgallery_file	NULL	const	file,index_file,index_folder	file	754	const,const	1	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
23	JDatabaseDriver->loadObject()	JROOT/components/com_eventgallery/library/factory/file/local.php:47
22	EventgalleryLibraryFactoryFileLocal->getFileDBData()	JROOT/components/com_eventgallery/library/factory/file/local.php:28
21	EventgalleryLibraryFactoryFileLocal->getFile()	JROOT/components/com_eventgallery/library/factory/file.php:44
20	EventgalleryLibraryFactoryFile->getFile()	JROOT/components/com_eventgallery/library/folder.php:533
19	EventgalleryLibraryFolder->getFiles()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php:30
18	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php	JROOT/components/com_eventgallery/library/common/view.php:114
17	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php:32
16	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php	JROOT/components/com_eventgallery/library/common/view.php:114
15	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/events/tmpl/default.php:17
14	include JROOT/components/com_eventgallery/views/events/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_eventgallery/views/events/view.html.php:79
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.70 ms Po ostatnim zapytaniu: 1.30 ms Pamięć zapytania: 0.029 MB Pamięć przed zapytaniem: 5.336 MB Zwróconych wierszy: 1

SELECT count(1)

  FROM `rqagi_eventgallery_file` AS file

  WHERE folder='BursztynoweWybrzeeMikoszewo2016' 
  AND (file.ismainimageonly IS NULL OR file.ismainimageonly=0) 
  AND file.published=1

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	file	NULL	ref	file,index_folder	file	377	const	172	1.00	Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
20	JDatabaseDriver->loadResult()	JROOT/components/com_eventgallery/library/folder.php:456
19	EventgalleryLibraryFolder->getFileCount()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php:22
18	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php	JROOT/components/com_eventgallery/library/common/view.php:114
17	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php:32
16	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php	JROOT/components/com_eventgallery/library/common/view.php:114
15	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/events/tmpl/default.php:17
14	include JROOT/components/com_eventgallery/views/events/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_eventgallery/views/events/view.html.php:79
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 4.58 ms Po ostatnim zapytaniu: 0.27 ms Pamięć zapytania: 0.036 MB Pamięć przed zapytaniem: 5.368 MB Zwróconych wierszy: 1

SELECT file.*, COUNT(comment.id) AS `commentCount`

  FROM `rqagi_eventgallery_file` AS file

  INNER JOIN `rqagi_eventgallery_folder` AS folder 
  ON folder.folder=file.folder 
  and folder.published=1

  LEFT JOIN `rqagi_eventgallery_comment` AS comment 
  ON file.folder=comment.folder 
  and file.file=comment.file

  WHERE file.folder='BursztynoweWybrzeeMikoszewo2016' 
  AND file.published=1

  GROUP BY file.id

  ORDER BY file.ismainimage DESC, ordering DESC, file.file 
  LIMIT 1

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	folder	NULL	const	folder	folder	377	const	1	100.00	Using temporary; Uruchomiono metodę filesort
1	SIMPLE	file	NULL	ref	PRIMARY,file,index_file,index_folder	file	377	const	172	10.00	Using index condition; Using where
1	SIMPLE	comment	NULL	ref	filefolderkey	filefolderkey	754	const,m1399_fest8.file.file	1	100.00	Using index

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventgallery/library/folder.php:524
19	EventgalleryLibraryFolder->getFiles()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php:30
18	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php	JROOT/components/com_eventgallery/library/common/view.php:114
17	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php:32
16	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php	JROOT/components/com_eventgallery/library/common/view.php:114
15	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/events/tmpl/default.php:17
14	include JROOT/components/com_eventgallery/views/events/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_eventgallery/views/events/view.html.php:79
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.60 ms Po ostatnim zapytaniu: 0.34 ms Pamięć zapytania: 0.040 MB Pamięć przed zapytaniem: 5.406 MB Zwróconych wierszy: 1

SELECT *

  FROM rqagi_eventgallery_file

  WHERE folder='BursztynoweWybrzeeMikoszewo2016' 
  AND file='Bursztynowe Wybrzee Mikoszewo 2016 1.jpg'

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rqagi_eventgallery_file	NULL	const	file,index_file,index_folder	file	754	const,const	1	100.00	NULL

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
23	JDatabaseDriver->loadObject()	JROOT/components/com_eventgallery/library/factory/file/local.php:47
22	EventgalleryLibraryFactoryFileLocal->getFileDBData()	JROOT/components/com_eventgallery/library/factory/file/local.php:28
21	EventgalleryLibraryFactoryFileLocal->getFile()	JROOT/components/com_eventgallery/library/factory/file.php:44
20	EventgalleryLibraryFactoryFile->getFile()	JROOT/components/com_eventgallery/library/folder.php:533
19	EventgalleryLibraryFolder->getFiles()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php:30
18	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default_event.php	JROOT/components/com_eventgallery/library/common/view.php:114
17	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php:32
16	include JROOT/components/com_eventgallery/views/snippets/tmpl/events/default.php	JROOT/components/com_eventgallery/library/common/view.php:114
15	EventgalleryLibraryCommonView->loadSnippet()	JROOT/components/com_eventgallery/views/events/tmpl/default.php:17
14	include JROOT/components/com_eventgallery/views/events/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_eventgallery/views/events/view.html.php:79
11	EventgalleryViewEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_eventgallery/controller.php:53
9	EventgalleryController->display()	JROOT/components/com_eventgallery/controllers/Events.php:20
8	EventgalleryControllerEvents->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_eventgallery/eventgallery.php:63
6	require_once JROOT/components/com_eventgallery/eventgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 0.45 ms Po ostatnim zapytaniu: 2.91 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 5.391 MB Zwróconych wierszy: 0

SELECT folder.*

  FROM `rqagi_eventgallery_folder` AS folder

  LEFT JOIN `rqagi_eventgallery_file` AS file 
  ON folder.folder = file.folder 
  and file.published=1 
  and file.ismainimage=0

  WHERE file.file IS NULL 
  AND (folder.foldertypeid=1 OR folder.foldertypeid=2)

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	folder	NULL	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where
1	SIMPLE	file	NULL	ref	file,index_folder	file	377	m1399_fest8.folder.folder	147	10.00	Using where; Not exists

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/picasaupdater/picasaupdater.php:66
8	plgSystemPicasaupdater->onAfterDispatch()	Identyczny z wywołaniem linii niżej.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:303
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Czas zapytania: 1.58 ms Po ostatnim zapytaniu: 119.71 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 6.052 MB Zwróconych wierszy: 12

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

  FROM rqagi_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2018-09-25 07:51:36') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-09-25 07:51:36') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 373 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Objaśnienie

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	published	1	const	4	2.70	Using index condition; Using where; Uruchomiono metodę filesort
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	m1399_fest8.m.id	1	40.00	Using where; Using index
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	m1399_fest8.m.module,const	1	10.00	Using index condition; Using where

Profile

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

Stos wywołania

#	Wywołujący	Plik i numer linii
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	Identyczny z wywołaniem linii niżej.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:512
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:459
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:268
8	Helix3::generatelayout()	JROOT/templates/flex/index.php:228
7	require JROOT/templates/flex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:309
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 typów zapytań zarejestrowanych, posortowanych według częstotliwości

WYBRANE tabele:

4 × SELECT t.* 
  FROM rqagi_eventgallery_imagetypeset_imagetype_assignment tsta 
  left join rqagi_eventgallery_imagetype t 
  on tsta.imagetypeid=t.id

3 × SELECT count(1) 
  FROM `rqagi_eventgallery_file` AS file

3 × SELECT * 
  FROM rqagi_eventgallery_file

3 × SELECT file.*, COUNT(comment.id) AS `commentCount` 
  FROM `rqagi_eventgallery_file` AS file 
  INNER JOIN `rqagi_eventgallery_folder` AS folder 
  ON folder.folder=file.folder 
  and folder.published=1 
  LEFT JOIN `rqagi_eventgallery_comment` AS comment 
  ON file.folder=comment.folder 
  and file.file=comment.file

2 × SELECT t.*, tsta.default as defaultimagetype 
  FROM rqagi_eventgallery_imagetypeset_imagetype_assignment tsta 
  left join rqagi_eventgallery_imagetype t 
  on tsta.imagetypeid=t.id

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `rqagi_extensions`

1 × SELECT * 
  FROM rqagi_eventgallery_imagetypeset

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

1 × SELECT * 
  FROM rqagi_eventgallery_imagetyp

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

1 × SELECT f.*, ft.folderhandlerclassname 
  FROM rqagi_eventgallery_folder f, rqagi_eventgallery_foldertype ft

1 × SELECT folder.* 
  FROM `rqagi_eventgallery_folder` AS folder 
  LEFT JOIN `rqagi_eventgallery_file` AS file 
  ON folder.folder = file.folder 
  and file.published=1 
  and file.ismainimage=0

1 × SELECT folder.*, count(1) AS `overallCount` 
  FROM `rqagi_eventgallery_folder` AS folder  JOIN `rqagi_eventgallery_file` AS file 
  ON folder.folder = file.folder 
  and file.published=1

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM rqagi_extensions

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

1 × SELECT id, rules 
  FROM `rqagi_viewlevels

1 × SELECT `session_id` 
  FROM `rqagi_session`

1 × SELECT `params` 
  FROM `rqagi_extensions`

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM rqagi_menu AS m 
  LEFT JOIN rqagi_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `name` 
  FROM `rqagi_extensions`

1 × SELECT id, home, template, s.params 
  FROM rqagi_template_styles as s 
  LEFT JOIN rqagi_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

```
1 × SELECT * 
  FROM rqagi_languages
```

1 × SELECT `data` 
  FROM `rqagi_session`

INNE tabele:

1 × UPDATE `rqagi_extensions` 
  SET `params` = '{\"mediaversion\":\"a674c83257aae30daa5b116b496de2ac\"}'

1 × INSERT INTO `rqagi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('j4itoqflv9aup7hc5qlk2gsm43', 1, '1537861896', 0, '', 0

Cart

Konsola diagnostyczna Joomla!

Sesja

Informacje o wydajności

Czas

Pamięć

Użycie pamięci

Zapytania do bazy danych

36 zapytań zarejestrowanych 45.18 ms

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

WYBRANE tabele:

INNE tabele: