**KŠC Sv. Josip Sarajevo

Joomla! Debug konzola

Sesija

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1680167760,
                "last": 1680167760,
                "now": 1680167760
            },
            "token": "KRJR0FW8keN7PslnEHZtQzb5vAKpOSAY"
        },
        "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
        },
        "jsn_mobilize_profile": null
    }
}

Informacije profila

Vrijeme

Memorija

**Vrijeme**: 4.56 ms / 4.56 ms **Memorija**: 0.417 MB / 0.75 MB Application: afterLoad

**Vrijeme**: 57.94 ms / 62.50 ms **Memorija**: 1.505 MB / 2.25 MB Application: afterInitialise

**Vrijeme**: 23.20 ms / 85.70 ms **Memorija**: 0.317 MB / 2.57 MB Application: afterRoute

**Vrijeme**: 1.43 ms / 87.13 ms **Memorija**: 0.026 MB / 2.60 MB Application: beforeRenderComponent com_content

**Vrijeme**: 143.51 ms / 230.64 ms **Memorija**: 0.213 MB / 2.81 MB Application: Before Access::preloadComponents (all components)

**Vrijeme**: 2.77 ms / 233.41 ms **Memorija**: 0.071 MB / 2.88 MB Application: After Access::preloadComponents (all components)

**Vrijeme**: 0.04 ms / 233.45 ms **Memorija**: -0.004 MB / 2.88 MB Application: Before Access::getAssetRules (id:8 name:com_content)

**Vrijeme**: 0.32 ms / 233.77 ms **Memorija**: 0.008 MB / 2.88 MB Application: After Access::getAssetRules (id:8 name:com_content)

**Vrijeme**: 121.75 ms / 355.52 ms **Memorija**: 0.643 MB / 3.53 MB Application: afterRenderComponent com_content

**Vrijeme**: 3.24 ms / 358.76 ms **Memorija**: 0.010 MB / 3.54 MB Application: afterDispatch

**Vrijeme**: 71.58 ms / 430.34 ms **Memorija**: 2.940 MB / 6.48 MB Application: beforeRenderModule mod_custom (Footer)

**Vrijeme**: 7.33 ms / 437.67 ms **Memorija**: 0.032 MB / 6.51 MB Application: afterRenderModule mod_custom (Footer)

**Vrijeme**: 0.06 ms / 437.73 ms **Memorija**: -0.002 MB / 6.51 MB Application: beforeRenderModule mod_custom (Zaklada - sidebar)

**Vrijeme**: 0.14 ms / 437.88 ms **Memorija**: 0.003 MB / 6.51 MB Application: afterRenderModule mod_custom (Zaklada - sidebar)

**Vrijeme**: 0.05 ms / 437.93 ms **Memorija**: -0.001 MB / 6.51 MB Application: beforeRenderModule mod_custom (Zaklada - Banner)

**Vrijeme**: 1.18 ms / 439.10 ms **Memorija**: 0.013 MB / 6.52 MB Application: afterRenderModule mod_custom (Zaklada - Banner)

**Vrijeme**: 0.06 ms / 439.16 ms **Memorija**: -0.000 MB / 6.52 MB Application: beforeRenderModule mod_menu (Main Menu)

**Vrijeme**: 38.20 ms / 477.36 ms **Memorija**: 0.763 MB / 7.29 MB Application: afterRenderModule mod_menu (Main Menu)

**Vrijeme**: 30.39 ms / 507.75 ms **Memorija**: 2.964 MB / 10.25 MB Application: afterRender

**Ukupno upita u bazi podataka: 135.68 ms**

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

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

#	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

**OBJAŠNJENJE što je nemoguće kod upita: INSERT INTO `fnf4x_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6466623333326632373966356633623732663664376263306261336532363235', 1, 1680167760, 0, '', 0)**

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**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: 2.21 ms** **Nakon posljednjeg upita: 0.52 ms** **Memorija upita: 0.006 MB memorija prije upita: 1.037 MB** **Redaka vraćeno: 45**

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

  FROM `fnf4x_extensions`

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

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fnf4x_extensions	ref	extension	extension	82	const	47	100.00	Using index condition; Using where

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**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: 0.41 ms** **Nakon posljednjeg upita: 0.76 ms** **Memorija upita: 0.005 MB memorija prije upita: 1.068 MB** **Redaka vraćeno: 4**

SELECT id, rules

  FROM `fnf4x_viewlevels`

**Objašnjenje**

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

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**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: 0.50 ms** **Nakon posljednjeg upita: 0.11 ms** **Memorija upita: 0.005 MB memorija prije upita: 1.079 MB** **Redaka vraćeno: 1**

SELECT b.id

  FROM fnf4x_usergroups AS a

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

  WHERE a.id = 1

**Objašnjenje**

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

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**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: 1.55 ms** **Nakon posljednjeg upita: 0.15 ms** **Memorija upita: 0.005 MB memorija prije upita: 1.101 MB** **Redaka vraćeno: 127**

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

  FROM fnf4x_extensions

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

  ORDER BY ordering

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fnf4x_extensions	ref	extension	extension	82	const	158	100.00	Using index condition; Using where; Korištenje sortiranja datoteka

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**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: 2.47 ms** **Nakon posljednjeg upita: 8.47 ms** **Memorija upita: 0.005 MB memorija prije upita: 1.489 MB** **Redaka vraćeno: 349**

**Duplicirani upiti**: #11 #22 #57

SHOW TABLES

**Objašnjenje**

**OBJAŠNJENJE što je nemoguće kod upita: SHOW TABLES**

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
8	JSNConfigHelper::get()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
7	plgSystemJsnpoweradmin->__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.47 ms** **Nakon posljednjeg upita: 0.14 ms** **Memorija upita: 0.005 MB memorija prije upita: 1.533 MB** **Redaka vraćeno: 5**

SELECT name,value

  FROM fnf4x_jsn_poweradmin_config

  WHERE 1

**Objašnjenje**

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

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
8	JSNConfigHelper::get()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
7	plgSystemJsnpoweradmin->__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.87 ms** **Nakon posljednjeg upita: 0.33 ms** **Memorija upita: 0.005 MB memorija prije upita: 1.506 MB** **Redaka vraćeno: 1**

SELECT COUNT(*)

  FROM fnf4x_extensions

  WHERE element="jsnadminbar"

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fnf4x_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using where; Using index

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:910
8	plgSystemJsnpoweradmin->_removeAdminBarPlugin()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:105
7	plgSystemJsnpoweradmin->__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: 2.02 ms** **Nakon posljednjeg upita: 16.70 ms** **Memorija upita: 0.006 MB memorija prije upita: 1.711 MB** **Redaka vraćeno: 349**

**Duplicirani upiti**: #8 #22 #57

SHOW TABLES

**Objašnjenje**

**OBJAŠNJENJE što je nemoguće kod upita: SHOW TABLES**

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
9	JSNConfigHelper::get()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:114
8	PlgSystemJSNMobilize->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: 0.58 ms** **Nakon posljednjeg upita: 0.16 ms** **Memorija upita: 0.005 MB memorija prije upita: 1.755 MB** **Redaka vraćeno: 5**

SELECT name,value

  FROM fnf4x_jsn_mobilize_config

  WHERE 1

**Objašnjenje**

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

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
9	JSNConfigHelper::get()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:114
8	PlgSystemJSNMobilize->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: 0.56 ms** **Nakon posljednjeg upita: 0.22 ms** **Memorija upita: 0.006 MB memorija prije upita: 1.724 MB** **Redaka vraćeno: 1**

**Duplicirani upiti**: #19 #116

SELECT *

  FROM fnf4x_jsn_mobilize_os

  WHERE os_type = 'other'

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fnf4x_jsn_mobilize_os	ALL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	12	100.00	Using where

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:445
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144
8	PlgSystemJSNMobilize->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: 0.69 ms** **Nakon posljednjeg upita: 0.19 ms** **Memorija upita: 0.006 MB memorija prije upita: 1.733 MB** **Redaka vraćeno: 0**

**Duplicirani upiti**: #20 #117

SELECT *

  FROM fnf4x_jsn_mobilize_profiles AS p

  INNER JOIN fnf4x_jsn_mobilize_os_support AS s 
  ON s.profile_id = p.profile_id

  WHERE s.os_id = '11' 
  AND p.profile_state = 1 
  AND p.profile_device = "jsn_mobile" 
  LIMIT 1

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	ALL	PRIMARY	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	1	100.00	Using where
1	SIMPLE	s	ALL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	4	100.00	Using where; Using join buffer (Block Nested Loop)

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:512
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144
8	PlgSystemJSNMobilize->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: 0.53 ms** **Nakon posljednjeg upita: 0.06 ms** **Memorija upita: 0.006 MB memorija prije upita: 1.737 MB** **Redaka vraćeno: 0**

**Duplicirani upiti**: #21 #118

SELECT *

  FROM fnf4x_jsn_mobilize_design

  WHERE profile_id = ''

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fnf4x_jsn_mobilize_design	ALL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	22	100.00	Using where

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:519
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144
8	PlgSystemJSNMobilize->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: 2.39 ms** **Nakon posljednjeg upita: 0.66 ms** **Memorija upita: 0.010 MB memorija prije upita: 1.768 MB** **Redaka vraćeno: 90**

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

  LEFT JOIN fnf4x_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	151	100.00	Using index condition; Using where; Korištenje sortiranja datoteka
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.m.component_id	1	100.00	Using where

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**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/jsnmobilize/jsnmobilize.php:170
8	PlgSystemJSNMobilize->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.12 ms** **Nakon posljednjeg upita: 6.10 ms** **Memorija upita: 0.009 MB memorija prije upita: 2.350 MB** **Redaka vraćeno: 1**

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

  FROM `fnf4x_extensions`

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

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fnf4x_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	*Isto kao i poziv u donjem retku.*
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:390
8	plgSystemJsnpoweradmin->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.67 ms** **Nakon posljednjeg upita: 0.16 ms** **Memorija upita: 0.006 MB memorija prije upita: 2.343 MB**

UPDATE `fnf4x_extensions`

  SET `params` = '{\"mediaversion\":\"029d9b27b178a23fca1d151a6dd3f7ba\"}'

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

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fnf4x_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:390
8	plgSystemJsnpoweradmin->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.41 ms** **Nakon posljednjeg upita: 0.48 ms** **Memorija upita: 0.006 MB memorija prije upita: 2.362 MB** **Redaka vraćeno: 1**

**Duplicirani upiti**: #13 #116

SELECT *

  FROM fnf4x_jsn_mobilize_os

  WHERE os_type = 'other'

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fnf4x_jsn_mobilize_os	ALL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	12	100.00	Using where

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:445
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282
8	PlgSystemJSNMobilize->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.50 ms** **Nakon posljednjeg upita: 0.22 ms** **Memorija upita: 0.006 MB memorija prije upita: 2.370 MB** **Redaka vraćeno: 0**

**Duplicirani upiti**: #14 #117

SELECT *

  FROM fnf4x_jsn_mobilize_profiles AS p

  INNER JOIN fnf4x_jsn_mobilize_os_support AS s 
  ON s.profile_id = p.profile_id

  WHERE s.os_id = '11' 
  AND p.profile_state = 1 
  AND p.profile_device = "jsn_mobile" 
  LIMIT 1

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	ALL	PRIMARY	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	1	100.00	Using where
1	SIMPLE	s	ALL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	4	100.00	Using where; Using join buffer (Block Nested Loop)

**Profil**

**NEMA PRIKAZA PROFILA (možda zato jer je više od 100 upita)**

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:512
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282
8	PlgSystemJSNMobilize->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: 2.34 ms** **Nakon posljednjeg upita: 0.05 ms** **Memorija upita: 0.006 MB memorija prije upita: 2.374 MB** **Redaka vraćeno: 0**

**Duplicirani upiti**: #15 #118

SELECT *

  FROM fnf4x_jsn_mobilize_design

  WHERE profile_id = ''

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fnf4x_jsn_mobilize_design	ALL	NULL	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	22	100.00	Using where

**Profil**

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.15 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/templates/jsn_mobilize/helpers/mobilize.php:519
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282
8	PlgSystemJSNMobilize->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: 2.24 ms** **Nakon posljednjeg upita: 2.90 ms** **Memorija upita: 0.009 MB memorija prije upita: 2.500 MB** **Redaka vraćeno: 349**

**Duplicirani upiti**: #8 #11 #57

SHOW TABLES

**Objašnjenje**

**OBJAŠNJENJE što je nemoguće kod upita: SHOW TABLES**

**Profil**

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
checking permissions	1.52 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.02 ms
closing tables	0.01 ms
freeing items	0.11 ms
cleaning up	0.01 ms

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/chronog3_plg/chronog3/libs/joomla/database_adapter.php:91
15	G3\L\Joomla\DatabaseAdapter->loadAssocList()	JROOT/plugins/system/chronog3_plg/chronog3/libs/joomla/database_adapter.php:62
14	G3\L\Joomla\DatabaseAdapter->getTablesList()	JROOT/plugins/system/chronog3_plg/chronog3/libs/joomla/database_adapter.php:42
13	G3\L\Joomla\DatabaseAdapter->__construct()	JROOT/plugins/system/chronog3_plg/chronog3/libs/database_object.php:29
12	G3\L\DatabaseObject::getInstance()	JROOT/plugins/system/chronog3_plg/chronog3/libs/database.php:48
11	G3\L\Database::getInstance()	JROOT/plugins/system/chronog3_plg/chronog3/libs/model.php:38
10	G3\L\Model->__construct()	JROOT/plugins/system/chronog3_plg/chronog3/libs/extension.php:61
9	G3\L\Extension->settings()	JROOT/plugins/system/chronog3_plg/chronog3_plg.php:56
8	PlgSystemChronog3_Plg->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.83 ms** **Nakon posljednjeg upita: 0.84 ms** **Memorija upita: 0.006 MB memorija prije upita: 2.503 MB** **Redaka vraćeno: 1**

SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name`, `Extension`.`enabled` AS `Extension.enabled`, `Extension`.`ordering` AS `Extension.ordering`, `Extension`.`settings` AS `Extension.settings` 
  FROM `fnf4x_chronog3_extensions` AS `Extension` 
  WHERE `Extension`.`name` = 'chronoforms';

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Extension	system	name	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	1	100.00	NULL

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/chronog3_plg/chronog3/libs/joomla/database_adapter.php:80
11	G3\L\Joomla\DatabaseAdapter->loadAssoc()	JROOT/plugins/system/chronog3_plg/chronog3/libs/model.php:1007
10	G3\L\Model->select()	JROOT/plugins/system/chronog3_plg/chronog3/libs/extension.php:62
9	G3\L\Extension->settings()	JROOT/plugins/system/chronog3_plg/chronog3_plg.php:56
8	PlgSystemChronog3_Plg->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: 1.40 ms** **Nakon posljednjeg upita: 2.27 ms** **Memorija upita: 0.006 MB memorija prije upita: 2.524 MB** **Redaka vraćeno: 4**

SELECT id, home, template, s.params

  FROM fnf4x_template_styles as s

  LEFT JOIN fnf4x_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	9	66.67	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	janbog_jos27.s.template,const	1	100.00	Using index condition; Using where

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33
10	jsn_template_framework_class_loader()	*Isto kao i poziv u donjem retku.*
9	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
8	PlgSystemJSNTPLFramework->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.54 ms** **Nakon posljednjeg upita: 0.30 ms** **Memorija upita: 0.006 MB memorija prije upita: 2.537 MB** **Redaka vraćeno: 1**

SELECT manifest_cache

  FROM fnf4x_extensions

  WHERE element LIKE 'jsn_decor_free'

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fnf4x_extensions	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	11	100.00	Using index condition

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122
12	JSNTplHelper::getManifestCache()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217
11	JSNTplHelper::getTemplateVersion()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35
10	jsn_template_framework_class_loader()	*Isto kao i poziv u donjem retku.*
9	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
8	PlgSystemJSNTPLFramework->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.61 ms** **Nakon posljednjeg upita: 2.40 ms** **Memorija upita: 0.006 MB memorija prije upita: 2.565 MB** **Redaka vraćeno: 1**

SELECT COUNT(*)

  FROM fnf4x_extensions

  WHERE type = 'component' 
  AND element = 'com_sh404sef'

**Objašnjenje**

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

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1183
10	JSNTplUtils->checkSH404SEF()	JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36
9	JSNTPLFramework::initial()	JROOT/plugins/system/jsntplframework/jsntplframework.php:191
8	PlgSystemJSNTPLFramework->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.56 ms** **Nakon posljednjeg upita: 0.51 ms** **Memorija upita: 0.003 MB memorija prije upita: 2.583 MB** **Redaka vraćeno: 1**

SELECT *

  FROM fnf4x_languages

  WHERE published=1

  ORDER BY ordering ASC

**Objašnjenje**

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

**Profil**

Status	Duration
starting	0.14 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.01 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.11 ms
cleaning up	0.01 ms

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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: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: 2.39 ms** **Nakon posljednjeg upita: 144.32 ms** **Memorija upita: 0.010 MB memorija prije upita: 2.814 MB** **Redaka vraćeno: 45**

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

  FROM `fnf4x_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoforms5','com_chronoforms6','com_chronoforms7','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_easyslider','com_fields','com_finder','com_imageshow','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mobilize','com_modules','com_newsfeeds','com_pagebuilder','com_plugins','com_postinstall','com_poweradmin','com_redirect','com_search','com_sigpro','com_tags','com_templates','com_uniform','com_uniterevolution2','com_users','com_wrapper')

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fnf4x_assets	range	idx_asset_name	idx_asset_name	202	NULL	46	100.00	Using index condition

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:45
13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 40.95 ms** **Nakon posljednjeg upita: 1.15 ms** **Memorija upita: 0.008 MB memorija prije upita: 2.911 MB** **Redaka vraćeno: 6**

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM fnf4x_content AS a

  LEFT JOIN fnf4x_categories AS c 
  ON c.id = a.catid

  LEFT JOIN fnf4x_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN fnf4x_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN fnf4x_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN fnf4x_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-30 09:16:00') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-30 09:16:00') 
  AND a.catid IN (100,102,103)

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 8

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	range	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	5	NULL	6	83.33	Using index condition; Using where; Using temporary; Korištenje sortiranja datoteka
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	janbog_jos27.a.catid	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.created_by	1	100.00	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.c.parent_id	1	100.00	Using where
1	SIMPLE	v	ALL	PRIMARY	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

**Profil**

Status	Duration
starting	33.19 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.17 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.34 ms
preparing	0.07 ms
Creating tmp table	0.12 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	5.60 ms
Creating sort index	0.58 ms
end	0.02 ms
removing tmp table	0.33 ms
end	0.05 ms
query end	0.02 ms
closing tables	0.07 ms
freeing items	0.14 ms
cleaning up	0.06 ms

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
12	ContentModelFeatured->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 1.40 ms** **Nakon posljednjeg upita: 1.35 ms** **Memorija upita: 0.007 MB memorija prije upita: 3.100 MB** **Redaka vraćeno: 1**

SELECT COUNT(*)

  FROM fnf4x_content AS a

  LEFT JOIN fnf4x_categories AS c 
  ON c.id = a.catid

  LEFT JOIN fnf4x_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN fnf4x_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN fnf4x_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN fnf4x_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.featured = 1 
  AND a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-30 09:16:00') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-30 09:16:00') 
  AND a.catid IN (100,102,103)

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	range	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	5	NULL	6	83.33	Using index condition; Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	janbog_jos27.a.catid	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.c.parent_id	1	100.00	Using where; Using index
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.id	1	100.00	Using where; Using index

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:57
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 0.99 ms** **Nakon posljednjeg upita: 2.25 ms** **Memorija upita: 0.010 MB memorija prije upita: 3.224 MB** **Redaka vraćeno: 3**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `fnf4x_categories` AS `s`

  INNER JOIN `fnf4x_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 102

  ORDER BY c.lft

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Korištenje sortiranja datoteka
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	97	32.99	Using where

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 2.15 ms** **Nakon posljednjeg upita: 0.27 ms** **Memorija upita: 0.009 MB memorija prije upita: 3.258 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 fnf4x_fields AS a

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

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

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

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

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

  LEFT JOIN `fnf4x_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (102,0,14)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	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	eq_ref	idx_langcode	idx_langcode	28	janbog_jos27.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	janbog_jos27.a.id	1	100.00	Using where; Using index; Distinct

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 0.66 ms** **Nakon posljednjeg upita: 0.86 ms** **Memorija upita: 0.011 MB memorija prije upita: 3.298 MB** **Redaka vraćeno: 0**

SELECT `name`, `value`

  FROM `fnf4x_jsn_imageshow_config`

  WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fnf4x_jsn_imageshow_config	range	name	name	767	NULL	3	100.00	Using where

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81
16	JSNISParameter->getParameters()	JROOT/administrator/components/com_imageshow/imageshow.defines.php:27
15	require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16
14	include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php	JROOT/plugins/content/imageshow/imageshow.php:28
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 0.72 ms** **Nakon posljednjeg upita: 0.39 ms** **Memorija upita: 0.007 MB memorija prije upita: 3.317 MB** **Redaka vraćeno: 1**

**Duplicirani upiti**: #37 #38 #39 #40 #43 #61 #62

SELECT *

  FROM fnf4x_extensions

  WHERE element='com_imageshow' 
  AND type='component'

**Objašnjenje**

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

**Profil**

Status	Duration
starting	0.17 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.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.12 ms
cleaning up	0.01 ms

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
14	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 1.06 ms** **Nakon posljednjeg upita: 1.41 ms** **Memorija upita: 0.010 MB memorija prije upita: 3.343 MB** **Redaka vraćeno: 3**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `fnf4x_categories` AS `s`

  INNER JOIN `fnf4x_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 100

  ORDER BY c.lft

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Korištenje sortiranja datoteka
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	97	30.93	Using where

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 1.94 ms** **Nakon posljednjeg upita: 0.16 ms** **Memorija upita: 0.009 MB memorija prije upita: 3.349 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 fnf4x_fields AS a

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

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

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

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

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

  LEFT JOIN `fnf4x_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (100,0,14)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	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	eq_ref	idx_langcode	idx_langcode	28	janbog_jos27.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	janbog_jos27.a.id	1	100.00	Using where; Using index; Distinct

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 0.71 ms** **Nakon posljednjeg upita: 0.19 ms** **Memorija upita: 0.007 MB memorija prije upita: 3.360 MB** **Redaka vraćeno: 1**

**Duplicirani upiti**: #34 #38 #39 #40 #43 #61 #62

SELECT *

  FROM fnf4x_extensions

  WHERE element='com_imageshow' 
  AND type='component'

**Objašnjenje**

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

**Profil**

Status	Duration
starting	0.13 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.16 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.12 ms
cleaning up	0.01 ms

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
14	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 0.53 ms** **Nakon posljednjeg upita: 0.54 ms** **Memorija upita: 0.007 MB memorija prije upita: 3.368 MB** **Redaka vraćeno: 1**

**Duplicirani upiti**: #34 #37 #39 #40 #43 #61 #62

SELECT *

  FROM fnf4x_extensions

  WHERE element='com_imageshow' 
  AND type='component'

**Objašnjenje**

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

**Profil**

Status	Duration
starting	0.13 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.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.11 ms
cleaning up	0.01 ms

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
14	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[**Dodaj 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.52 ms** **Memorija upita: 0.007 MB memorija prije upita: 3.376 MB** **Redaka vraćeno: 1**

**Duplicirani upiti**: #34 #37 #38 #40 #43 #61 #62

SELECT *

  FROM fnf4x_extensions

  WHERE element='com_imageshow' 
  AND type='component'

**Objašnjenje**

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

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
14	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 0.73 ms** **Nakon posljednjeg upita: 0.57 ms** **Memorija upita: 0.007 MB memorija prije upita: 3.384 MB** **Redaka vraćeno: 1**

**Duplicirani upiti**: #34 #37 #38 #39 #43 #61 #62

SELECT *

  FROM fnf4x_extensions

  WHERE element='com_imageshow' 
  AND type='component'

**Objašnjenje**

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

**Profil**

Status	Duration
starting	0.14 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.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.12 ms
query end	0.01 ms
closing tables	0.06 ms
freeing items	0.12 ms
cleaning up	0.01 ms

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
14	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 0.91 ms** **Nakon posljednjeg upita: 0.55 ms** **Memorija upita: 0.010 MB memorija prije upita: 3.400 MB** **Redaka vraćeno: 2**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `fnf4x_categories` AS `s`

  INNER JOIN `fnf4x_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 103

  ORDER BY c.lft

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Korištenje sortiranja datoteka
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX KLJUČEVI SE NE MOGU KORISTITI	NULL	NULL	97	58.76	Using where

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 1.59 ms** **Nakon posljednjeg upita: 0.13 ms** **Memorija upita: 0.009 MB memorija prije upita: 3.406 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 fnf4x_fields AS a

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

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

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

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

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

  LEFT JOIN `fnf4x_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (103,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

**Objašnjenje**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	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	eq_ref	idx_langcode	idx_langcode	28	janbog_jos27.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	janbog_jos27.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	janbog_jos27.a.id	1	100.00	Using where; Using index; Distinct

**Profil**

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

**Slijed poziva funkcija**

#	Pozivatelj	Datoteka i broj linije
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Vrijeme upita: 0.63 ms** **Nakon posljednjeg upita: 0.26 ms** **Memorija upita: 0.007 MB memorija prije upita: 3.417 MB** **Redaka vraćeno: 1**

	Oglasna ploča

	REZULTATI NATJEČAJA ZA STIPENDIJE ZAKLADE 2022./2023.

	POZIVNICA ZA BOŽIĆNI KONCERT I BAZAR

	NATJEČAJ ZA DODJELU STIPENDIJA

	KALENDAR PISMENIH PROVJERA ZNANJA ZA OSNOVNU ŠKOLU

	ŠKOLSKI KALENDAR ZA 2022./2023. GODINU

	POČETAK NASTAVE U ŠKOLSKOJ 2022./2023. GODINI

#	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

Isplata II. rate stipendija

Rezultati natječaja za stipendije Zaklade za 2022./2023. godinu

N A T J E Č A J za dodjelu stipendija tijekom redovitog sveučilišnog studija

Obavijest za III. ratu stipendija

Joomla! Debug konzola

Sesija

Informacije profila

Vrijeme

Memorija

Korištenje Memorije

Upiti baze podataka

119 Upita zapisano 135.68 ms

43 duplikata pronađeno!

	ZAKLADA "ZA MUDROST I PLEMENITOSt - PRO SAPIENTIA ET CLEMENTIA"

	PRIJAVI NASILJE među učenicima i nad učenicima
		Prijavi svaki oblik nasilja

Isplata II. rate stipendija

Rezultati natječaja za stipendije Zaklade za 2022./2023. godinu

N A T J E Č A J za dodjelu stipendija tijekom redovitog sveučilišnog studija

Obavijest za III. ratu stipendija

**Joomla! Debug konzola**

**Sesija**

**Informacije profila**

**Vrijeme**

**Memorija**

**Korištenje Memorije**

**Upiti baze podataka**

**119 Upita zapisano** 135.68 ms

**43 duplikata pronađeno!**

Joomla! Debug konzola

Sesija

Informacije profila

Vrijeme

Memorija

Korištenje Memorije

Upiti baze podataka

119 Upita zapisano 135.68 ms

43 duplikata pronađeno!