Register

Registracija korisnika

* Obavezno polje

Ime *

Korisničko ime *

Lozinka *

Potvrda lozinke *

E-mail adresa *

Potvrda e-mail adrese *

Captcha *

User Profile

Želite li se predbilježiti za naše mjesečne novosti? (opcionalno)

Gdje/kako ste čuli za nas? (opcionalno)

If you are a BTO Garden BirdWatch contributor, please give your GBW number here so that we can link your contributions to the two projects. You can find your GBW number where you enter counts online, or on any paper GBW mailings. Please note, the MammalWeb website is not managed by BTO. (opcionalno)

Slažete li se s uvjetima naše Politike privatnosti? (Zbog zakonodavstva - GDPR, potrebna nam je izričita suglasnost za našu politiku o privatnosti da bismo mogli koristiti podatke koje šaljete. Ako imate bilo kakvih pitanja o ovim pravilima, pošaljite e-mail na adresu info@mammalweb.org). *

Odustani

Joomla! Debug konzola

Sesija

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1725761222,
                "last": 1725761222,
                "now": 1725761222
            },
            "token": "yxDkoAOPYXjcAYxvYM91vjcuh4Uezpec"
        },
        "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
        }
    }
}

Informacije profila

Korištenje Memorije

Upiti baze podataka

20 Upita zapisano 160.62 ms

2 duplikata pronađeno!

2 duplikata: #16 #17

Vrijeme upita: 0.67 ms Memorija upita: 0.023 MB memorija prije upita: 0.827 MB Redaka vraćeno: 0

SELECT `data`

  FROM `faokq_session`

  WHERE `session_id` = X'74306739757073376d316d393968676f31656d6a6b3162386e72'

Objašnjenje

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

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.13 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
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Isto kao i poziv u donjem retku.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.55 ms Nakon posljednjeg upita: 0.29 ms Memorija upita: 0.020 MB memorija prije upita: 0.838 MB Redaka vraćeno: 0

SELECT `session_id`

  FROM `faokq_session`

  WHERE `session_id` = X'74306739757073376d316d393968676f31656d6a6b3162386e72' 
  LIMIT 1

Objašnjenje

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

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 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.03 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 4.11 ms Nakon posljednjeg upita: 0.12 ms Memorija upita: 0.004 MB memorija prije upita: 0.844 MB

INSERT INTO `faokq_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'74306739757073376d316d393968676f31656d6a6b3162386e72', 1, 1725761222, 0, '', 0)

Objašnjenje

OBJAŠNJENJE što je nemoguće kod upita: INSERT INTO `faokq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'74306739757073376d316d393968676f31656d6a6b3162386e72', 1, 1725761222, 0, '', 0)

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
update	0.10 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	3.04 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 3.01 ms Nakon posljednjeg upita: 0.39 ms Memorija upita: 0.022 MB memorija prije upita: 0.872 MB Redaka vraćeno: 43

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

  FROM `faokq_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	faokq_extensions	NULL	ref	extension	extension	82	const	45	1.00	Using where

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.98 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	1.60 ms
end	0.02 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Isto kao i poziv u donjem retku.
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:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
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:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.02 ms Nakon posljednjeg upita: 0.39 ms Memorija upita: 0.021 MB memorija prije upita: 0.888 MB Redaka vraćeno: 14

SELECT id, rules

  FROM `faokq_viewlevels`

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	faokq_viewlevels	NULL	ALL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	11	100.00	NULL

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 14.62 ms Nakon posljednjeg upita: 0.10 ms Memorija upita: 0.021 MB memorija prije upita: 0.904 MB Redaka vraćeno: 2

SELECT b.id

  FROM faokq_usergroups AS a

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

  WHERE a.id = 9

Objašnjenje

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

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	11.61 ms
freeing items	1.92 ms
cleaning up	0.03 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 8.65 ms Nakon posljednjeg upita: 0.22 ms Memorija upita: 0.022 MB memorija prije upita: 0.925 MB Redaka vraćeno: 85

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

  FROM faokq_extensions

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

  ORDER BY ordering

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	faokq_extensions	NULL	ref	extension	extension	82	const	126	0.60	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
executing	7.91 ms
end	0.17 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Isto kao i poziv u donjem retku.
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:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 13.21 ms Nakon posljednjeg upita: 2.00 ms Memorija upita: 0.021 MB memorija prije upita: 1.217 MB Redaka vraćeno: 7

SELECT *

  FROM faokq_languages

  WHERE published=1

  ORDER BY ordering ASC

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	faokq_languages	NULL	ALL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	8	12.50	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.89 ms Nakon posljednjeg upita: 0.21 ms Memorija upita: 0.021 MB memorija prije upita: 1.231 MB Redaka vraćeno: 16

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `faokq_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	faokq_extensions	NULL	ref	extension	extension	82	const	16	1.00	Using where

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.30 ms
preparing	0.02 ms
executing	0.12 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 3.98 ms Nakon posljednjeg upita: 4.99 ms Memorija upita: 0.155 MB memorija prije upita: 1.295 MB Redaka vraćeno: 196

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 faokq_menu AS m

  LEFT JOIN faokq_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šnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	298	8.69	Using where; Korištenje sortiranja datoteka
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.68 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
executing	1.28 ms
end	1.57 ms
query end	0.01 ms
waiting for handler commit	0.04 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Isto kao i poziv u donjem retku.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.29 ms Nakon posljednjeg upita: 4.79 ms Memorija upita: 0.068 MB memorija prije upita: 2.044 MB Redaka vraćeno: 29

SELECT id, home, template, s.params

  FROM faokq_template_styles as s

  LEFT JOIN faokq_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šnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	30	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	Xdbl0zz14_joomla33.e.element	1	93.55	Using index condition; Using where

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.45 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:353
9	T3::detect()	JROOT/plugins/system/t3/t3.php:87
8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 0.53 ms Nakon posljednjeg upita: 2.05 ms Memorija upita: 0.022 MB memorija prije upita: 2.090 MB Redaka vraćeno: 1

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

  FROM `faokq_extensions`

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

Objašnjenje

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

Profil

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Isto kao i poziv u donjem retku.
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:1137
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 12.15 ms Nakon posljednjeg upita: 0.15 ms Memorija upita: 0.005 MB memorija prije upita: 2.080 MB

UPDATE `faokq_extensions`

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

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

Objašnjenje

OBJAŠNJENJE što je nemoguće kod upita: UPDATE `faokq_extensions` SET `params` = '{\"mediaversion\":\"bc6cf0b3b5137fdef3a09c7c04bb0725\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.06 ms
updating	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	11.74 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
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:1137
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 7.27 ms Nakon posljednjeg upita: 2.44 ms Memorija upita: 0.026 MB memorija prije upita: 2.187 MB Redaka vraćeno: 1

SELECT id, home, template, s.params

  FROM faokq_template_styles as s

  LEFT JOIN faokq_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 s.home = '1' 
  AND e.enabled = 1

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id_home	29	const,const	1	100.00	NULL
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	Xdbl0zz14_joomla33.s.template,const	1	4.51	Using index condition; Using where

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/core/t3.php:391
22	T3::getDefaultTemplate()	JROOT/plugins/system/t3/t3.php:282
21	plgSystemT3->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:235
12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 39.97 ms Nakon posljednjeg upita: 0.44 ms Memorija upita: 0.028 MB memorija prije upita: 2.210 MB Redaka vraćeno: 0

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

  FROM faokq_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_users.user' 
  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šnjenje

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 where; Using temporary; Korištenje sortiranja datoteka
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	Xdbl0zz14_joomla33.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	24.36 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	2.30 ms
preparing	0.04 ms
Creating tmp table	0.10 ms
executing	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	10.59 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
25	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
23	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
22	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
21	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:235
12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 18.11 ms Nakon posljednjeg upita: 2.72 ms Memorija upita: 0.025 MB memorija prije upita: 2.228 MB Redaka vraćeno: 0

Duplicirani upiti: #17

SELECT profile_key, profile_value 
  FROM faokq_user_profiles 
  WHERE user_id = 0 
  AND profile_key LIKE 'profileMW.%' 
  ORDER BY ordering

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	faokq_user_profiles	NULL	range	idx_user_id_profile_key	idx_user_id_profile_key	406	NULL	1	100.00	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	6.77 ms
init	0.01 ms
System lock	0.72 ms
optimizing	0.01 ms
statistics	9.18 ms
preparing	0.04 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
18	JDatabaseDriver->loadRowList()	JROOT/plugins/user/profileMW/profileMW.php:54
17	plgUserProfileMW->onContentPrepareData()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_users/models/registration.php:302
14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:235
12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 6.47 ms Nakon posljednjeg upita: 0.45 ms Memorija upita: 0.025 MB memorija prije upita: 2.245 MB Redaka vraćeno: 0

Duplicirani upiti: #16

SELECT profile_key, profile_value 
  FROM faokq_user_profiles 
  WHERE user_id = 0 
  AND profile_key LIKE 'profileMW.%' 
  ORDER BY ordering

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	faokq_user_profiles	NULL	range	idx_user_id_profile_key	idx_user_id_profile_key	406	NULL	1	100.00	Using where; Korištenje sortiranja datoteka

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.05 ms
preparing	0.02 ms
executing	5.43 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
18	JDatabaseDriver->loadRowList()	JROOT/plugins/user/profileMW/profileMW.php:54
17	plgUserProfileMW->onContentPrepareData()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:292
14	Joomla\CMS\MVC\Model\FormModel->preprocessData()	JROOT/components/com_users/models/registration.php:363
13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:235
12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 5.41 ms Nakon posljednjeg upita: 12.01 ms Memorija upita: 0.021 MB memorija prije upita: 2.386 MB Redaka vraćeno: 7

SELECT language,id

  FROM `faokq_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	faokq_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	260	1.00	Using where

Profil

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	4.85 ms
end	0.02 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 16.75 ms Nakon posljednjeg upita: 0.45 ms Memorija upita: 0.021 MB memorija prije upita: 2.399 MB Redaka vraćeno: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `faokq_menu` AS `c`

  INNER JOIN `faokq_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `faokq_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `faokq_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 837

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	9.57 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	5.17 ms
executing	0.05 ms
end	0.00 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.68 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

Vrijeme upita: 1.99 ms Nakon posljednjeg upita: 1.08 ms Memorija upita: 0.023 MB memorija prije upita: 2.448 MB Redaka vraćeno: 7

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

  FROM faokq_modules AS m

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

  LEFT JOIN faokq_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 <= '2024-09-08 02:07:02') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-08 02:07:02') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 837 OR mm.menuid <= 0) 
  AND m.language IN ('hr-HR','*')

  ORDER BY m.position, m.ordering

Objašnjenje

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds,idx_language	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	64	1.56	Using where; Korištenje sortiranja datoteka
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	Xdbl0zz14_joomla33.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	Xdbl0zz14_joomla33.m.id	3	40.00	Using where; Using index

Profil

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.05 ms
executing	0.98 ms
end	0.02 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Slijed poziva funkcija

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	Isto kao i poziv u donjem retku.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/ja_simpli_uae/helper.php:112
8	SimpliHelper->init()	JROOT/templates/ja_simpli_uae/index.php:10
7	require JROOT/templates/ja_simpli_uae/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dodaj xdebug.file_link_format naredbu u tvoju php.ini datoteku kako bi imao linkove za datoteke]

17 Tipova upita zapisano, razvrstani su prema broju pojavljivanja.

ODABERI tablice:

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

2 × SELECT id, home, template, s.params 
  FROM faokq_template_styles as s 
  LEFT JOIN faokq_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

2 × SELECT profile_key, profile_value 
  FROM faokq_user_profiles

1 × SELECT `data` 
  FROM `faokq_session`

1 × SELECT `session_id` 
  FROM `faokq_session`

1 × SELECT id, rules 
  FROM `faokq_viewlevels

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

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

```
1 × SELECT * 
  FROM faokq_languages
```

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `faokq_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 faokq_menu AS m 
  LEFT JOIN faokq_extensions AS e 
  ON m.component_id = e.extension_id

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

1 × SELECT language,id 
  FROM `faokq_menu`

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `faokq_menu` AS `c` 
  INNER JOIN `faokq_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `faokq_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `faokq_menu` AS `c2` 
  ON a2.id = c2.`id`

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

OSTALE tablice:

1 × INSERT INTO `faokq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'74306739757073376d316d393968676f31656d6a6b3162386e72', 1, 1725761222, 0, '', 0

1 × UPDATE `faokq_extensions` 
  SET `params` = '{\"mediaversion\":\"bc6cf0b3b5137fdef3a09c7c04bb0725\"}'