Joomla! Debug konzola

Sesija

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

Informacije profila

Vrijeme

Memorija

Vrijeme: 29.95 ms / 29.95 ms Memorija: 1.095 MB / 1.20 MB Application: afterLoad

Vrijeme: 154.31 ms / 184.26 ms Memorija: 3.983 MB / 5.19 MB Application: afterInitialise

Vrijeme: 80.98 ms / 265.25 ms Memorija: 1.332 MB / 6.52 MB Application: afterRoute

Vrijeme: 2.05 ms / 267.30 ms Memorija: 0.041 MB / 6.56 MB Application: beforeRenderComponent com_tags

Vrijeme: 104.62 ms / 371.92 ms Memorija: 1.967 MB / 8.52 MB Application: Before Access::preloadComponents (all components)

Vrijeme: 1.32 ms / 373.24 ms Memorija: 0.063 MB / 8.59 MB Application: After Access::preloadComponents (all components)

Vrijeme: 0.08 ms / 373.32 ms Memorija: 0.000 MB / 8.58 MB Application: Before Access::getAssetRules (id:35 name:com_tags)

Vrijeme: 1.20 ms / 374.53 ms Memorija: 0.028 MB / 8.61 MB Application: After Access::getAssetRules (id:35 name:com_tags)

Vrijeme: 13.59 ms / 388.12 ms Memorija: 0.206 MB / 8.82 MB Application: afterRenderComponent com_tags

Vrijeme: 4.11 ms / 392.23 ms Memorija: 0.108 MB / 8.93 MB Application: afterDispatch

Vrijeme: 37.97 ms / 430.20 ms Memorija: 1.318 MB / 10.24 MB Application: beforeRenderModule mod_custom (footer)

Vrijeme: 2.71 ms / 432.91 ms Memorija: 0.025 MB / 10.27 MB Application: afterRenderModule mod_custom (footer)

Vrijeme: 0.27 ms / 433.18 ms Memorija: 0.000 MB / 10.27 MB Application: beforeRenderModule mod_articles_popular (Najčitanije)

Vrijeme: 4.81 ms / 437.98 ms Memorija: 0.136 MB / 10.40 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Vrijeme: 0.25 ms / 438.23 ms Memorija: 0.005 MB / 10.41 MB Application: After Access::getAssetRules (id:8 name:com_content)

Vrijeme: 23.53 ms / 461.76 ms Memorija: 0.046 MB / 10.46 MB Application: afterRenderModule mod_articles_popular (Najčitanije)

Vrijeme: 0.20 ms / 461.96 ms Memorija: 0.000 MB / 10.40 MB Application: beforeRenderModule mod_articles_latest (Najnovije)

Vrijeme: 26.50 ms / 488.46 ms Memorija: 0.103 MB / 10.51 MB Application: afterRenderModule mod_articles_latest (Najnovije)

Vrijeme: 0.21 ms / 488.67 ms Memorija: 0.000 MB / 10.46 MB Application: beforeRenderModule mod_custom (Udruženje građana Bosona)

Vrijeme: 1.26 ms / 489.93 ms Memorija: 0.004 MB / 10.47 MB Application: afterRenderModule mod_custom (Udruženje građana Bosona)

Vrijeme: 0.14 ms / 490.07 ms Memorija: 0.000 MB / 10.46 MB Application: beforeRenderModule mod_st_related_items (Povezane vijesti)

Vrijeme: 2.81 ms / 492.88 ms Memorija: 0.026 MB / 10.49 MB Application: afterRenderModule mod_st_related_items (Povezane vijesti)

Vrijeme: 0.17 ms / 493.05 ms Memorija: 0.000 MB / 10.49 MB Application: beforeRenderModule mod_menu (Main Menu)

Vrijeme: 24.57 ms / 517.62 ms Memorija: 0.261 MB / 10.75 MB Application: afterRenderModule mod_menu (Main Menu)

Vrijeme: 0.19 ms / 517.81 ms Memorija: 0.000 MB / 10.74 MB Application: beforeRenderModule mod_custom (Logo)

Vrijeme: 0.62 ms / 518.42 ms Memorija: 0.004 MB / 10.75 MB Application: afterRenderModule mod_custom (Logo)

Vrijeme: 78.48 ms / 596.91 ms Memorija: 0.715 MB / 11.46 MB Application: afterRender

Ukupno upita na bazi : 123.24 ms

Iskorištenost memorije

Upiti baze podataka

32 upita evidentirano 123.24 ms

2 duplikata pronađeno!

2 duplikata: #19 #22

Vrijeme upita: 2.93 ms Memorija za upit: 0.005 MB memorije prije upita: 2.546 MB

DELETE 

  FROM `bosona_session`

  WHERE `time` < '1524557123'

Objašnjenje

OBJAŠNJENJE nije moguće u upitu: DELETE FROM `bosona_session` WHERE `time` < '1524557123'

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
System lock	0.01 ms
init	0.49 ms
updating	1.89 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	0.14 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Application/CMSApplication.php:824
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 0.56 ms Nakon posljednjeg upita: 0.68 ms Memorija za upit: 0.011 MB memorije prije upita: 2.565 MB Vraćeno zapisa: 0

SELECT `data`

  FROM `bosona_session`

  WHERE `session_id` = 'qbsr45mhq6454ani443q5chu16'

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bosona_session	const	PRIMARY	PRIMARY	766	const	1

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.04 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Isto kao poziv u liniji niže.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:831
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 0.51 ms Nakon posljednjeg upita: 2.59 ms Memorija za upit: 0.006 MB memorije prije upita: 2.658 MB Vraćeno zapisa: 0

SELECT `session_id`

  FROM `bosona_session`

  WHERE `session_id` = 'qbsr45mhq6454ani443q5chu16' 
  LIMIT 1

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bosona_session	const	PRIMARY	PRIMARY	766	const	1	Using index

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.07 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
7	JDatabaseDriver->loadResult()	JROOT/libraries/src/Application/CMSApplication.php:178
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 1.99 ms Nakon posljednjeg upita: 0.36 ms Memorija za upit: 0.005 MB memorije prije upita: 2.667 MB

INSERT INTO `bosona_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('qbsr45mhq6454ani443q5chu16', 1, '1524558023', 0, '', 0)

Objašnjenje

OBJAŠNJENJE nije moguće u upitu: INSERT INTO `bosona_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('qbsr45mhq6454ani443q5chu16', 1, '1524558023', 0, '', 0)

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
init	0.01 ms
update	1.36 ms
Waiting for query cache lock	0.00 ms
update	0.03 ms
end	0.00 ms
query end	0.05 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Application/CMSApplication.php:218
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:415
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 5.89 ms Nakon posljednjeg upita: 5.97 ms Memorija za upit: 0.008 MB memorije prije upita: 2.866 MB Vraćeno zapisa: 46

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

  FROM `bosona_extensions`

  WHERE `type` = 'component'

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bosona_extensions	ref	extension	extension	82	const	46	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.04 ms
init	0.01 ms
optimizing	0.12 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.13 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	2.09 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.13 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.10 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	1.25 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:422
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Isto kao poziv u liniji niže.
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:430
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:496
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 0.29 ms Nakon posljednjeg upita: 5.41 ms Memorija za upit: 0.007 MB memorije prije upita: 3.069 MB Vraćeno zapisa: 4

SELECT id, rules

  FROM `bosona_viewlevels`

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bosona_viewlevels	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	4

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 0.32 ms Nakon posljednjeg upita: 0.35 ms Memorija za upit: 0.008 MB memorije prije upita: 3.083 MB Vraćeno zapisa: 2

SELECT b.id

  FROM bosona_usergroups AS a

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

  WHERE a.id = 9

Objašnjenje

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

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

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 11.35 ms Nakon posljednjeg upita: 1.45 ms Memorija za upit: 0.008 MB memorije prije upita: 3.147 MB Vraćeno zapisa: 108

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

  FROM bosona_extensions

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

  ORDER BY ordering

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bosona_extensions	ref	extension	extension	82	const	142	Using where; Korištenje filesort-a

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	1.43 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	7.49 ms
Sending data	0.45 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
Sending data	0.23 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	1.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.05 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Isto kao poziv u liniji niže.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:348
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 14.27 ms Nakon posljednjeg upita: 81.18 ms Memorija za upit: 0.013 MB memorije prije upita: 5.365 MB Vraćeno zapisa: 51

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

  LEFT JOIN bosona_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	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	66	Using where; Korištenje filesort-a
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	bosona.m.component_id	1

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.04 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.26 ms
Sending data	0.19 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.25 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.31 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.19 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Isto kao poziv u liniji niže.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:446
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:551
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1146
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 4.78 ms Nakon posljednjeg upita: 23.68 ms Memorija za upit: 0.009 MB memorije prije upita: 6.029 MB Vraćeno zapisa: 1

SELECT id

  FROM `bosona_tags`

  WHERE `alias` = 'muzej'

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bosona_tags	ref	idx_alias	idx_alias	402	const	1	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
init	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
11	JDatabaseDriver->loadResult()	JROOT/components/com_tags/router.php:179
10	TagsRouter->fixSegment()	JROOT/components/com_tags/router.php:147
9	TagsRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1147
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 2.45 ms Nakon posljednjeg upita: 1.10 ms Memorija za upit: 0.013 MB memorije prije upita: 6.075 MB Vraćeno zapisa: 1

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

  FROM `bosona_extensions`

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

Objašnjenje

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Isto kao poziv u liniji niže.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:460
9	plgSystemK2->onAfterRoute()	Isto kao poziv u liniji niže.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1156
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 3.78 ms Nakon posljednjeg upita: 0.40 ms Memorija za upit: 0.010 MB memorije prije upita: 6.073 MB

UPDATE `bosona_extensions`

  SET `params` = '{\"mediaversion\":\"42e280458576a78b439f2a73f26f390f\"}'

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

Objašnjenje

OBJAŠNJENJE nije moguće u upitu: UPDATE `bosona_extensions` SET `params` = '{\"mediaversion\":\"42e280458576a78b439f2a73f26f390f\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	1.17 ms
System lock	0.01 ms
init	0.09 ms
Updating	0.12 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.19 ms
query end	0.06 ms
closing tables	0.16 ms
freeing items	0.04 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:460
9	plgSystemK2->onAfterRoute()	Isto kao poziv u liniji niže.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1156
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 1.63 ms Nakon posljednjeg upita: 8.79 ms Memorija za upit: 0.010 MB memorije prije upita: 6.362 MB Vraćeno zapisa: 1

SELECT *

  FROM bosona_languages

  WHERE published=1

  ORDER BY ordering ASC

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bosona_languages	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	1	Using where; Korištenje filesort-a

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
13	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
12	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:274
11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:55
10	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:478
9	plgSystemK2->onAfterRoute()	Isto kao poziv u liniji niže.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1156
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 5.12 ms Nakon posljednjeg upita: 2.63 ms Memorija za upit: 0.014 MB memorije prije upita: 6.455 MB Vraćeno zapisa: 3

SELECT id, home, template, s.params

  FROM bosona_template_styles as s

  LEFT JOIN bosona_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	Extra
1	SIMPLE	s	ALL	idx_template	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	5	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	bosona.s.template,const	1	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.66 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.05 ms
init	0.02 ms
optimizing	0.90 ms
statistics	1.21 ms
preparing	0.04 ms
executing	0.00 ms
Sending data	0.82 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.48 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.14 ms
logging slow query	0.00 ms
cleaning up	0.03 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
20	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
19	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
18	Joomla\CMS\HTML\HTMLHelper::script()	Isto kao poziv u liniji niže.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
14	JHtmlJquery::framework()	Isto kao poziv u liniji niže.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:82
10	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:478
9	plgSystemK2->onAfterRoute()	Isto kao poziv u liniji niže.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1156
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 2.36 ms Nakon posljednjeg upita: 2.81 ms Memorija za upit: 0.008 MB memorije prije upita: 6.476 MB Vraćeno zapisa: 1

SELECT params

  FROM bosona_extensions

  WHERE folder ='editors' 
  AND element ='jckeditor'

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bosona_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.12 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.23 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/jcktypography/jcktypography.php:61
9	plgSystemJCKtypography->onAfterRoute()	Isto kao poziv u liniji niže.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1156
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 0.96 ms Nakon posljednjeg upita: 17.55 ms Memorija za upit: 0.014 MB memorije prije upita: 6.997 MB Vraćeno zapisa: 11

SELECT *

  FROM `bosona_content_types`

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bosona_content_types	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	11

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.14 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Helper/TagsHelper.php:794
17	Joomla\CMS\Helper\TagsHelper::getTypes()	JROOT/libraries/src/Helper/TagsHelper.php:628
16	Joomla\CMS\Helper\TagsHelper->getTagItemsQuery()	JROOT/components/com_tags/models/tag.php:148
15	TagsModelTag->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:51
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 6.22 ms Nakon posljednjeg upita: 0.40 ms Memorija za upit: 0.012 MB memorije prije upita: 7.013 MB Vraćeno zapisa: 9

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM bosona_contentitem_tag_map AS m

  INNER JOIN bosona_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2018-04-24 08:20:24')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2018-04-24 08:20:24')

  INNER JOIN bosona_content_types AS ct 
  ON ct.type_alias = m.type_alias

  LEFT JOIN bosona_categories AS tc 
  ON tc.id = c.core_catid

  LEFT JOIN bosona_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (119) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_zhgooglemap.mapmarker') 
  AND c.core_access IN (0,1,5)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email

  ORDER BY MAX(`c`.`core_title`) ASC 
  LIMIT 20

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	9	Using where; Using temporary; Korištenje filesort-a
1	SIMPLE	ct	ref	idx_alias	idx_alias	402	bosona.m.type_alias	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	bosona.m.core_content_id	1	Using where
1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	bosona.c.core_catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	bosona.c.core_created_user_id	1

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.25 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.16 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.06 ms
init	0.18 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
storing result in query cache	0.05 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.15 ms
Creating tmp table	0.27 ms
executing	0.00 ms
Copying to tmp table	3.39 ms
Sorting result	0.05 ms
Sending data	0.23 ms
end	0.00 ms
removing tmp table	0.28 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.05 ms
freeing items	0.11 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:51
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 1.41 ms Nakon posljednjeg upita: 6.05 ms Memorija za upit: 0.014 MB memorije prije upita: 7.273 MB Vraćeno zapisa: 30

SHOW FULL COLUMNS 
  FROM `bosona_tags`

Objašnjenje

OBJAŠNJENJE nije moguće u upitu: SHOW FULL COLUMNS FROM `bosona_tags`

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
System lock	0.01 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.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.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Sending data	0.14 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.18 ms
closing tables	0.00 ms
freeing items	0.09 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_tags/tables/tag.php:29
14	TagsTableTag->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_tags/models/tag.php:271
12	TagsModelTag->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:52
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 0.83 ms Nakon posljednjeg upita: 9.58 ms Memorija za upit: 0.011 MB memorije prije upita: 7.380 MB Vraćeno zapisa: 1

Dupli upiti: #22

SELECT *

  FROM bosona_tags

  WHERE `id` = '119'

Objašnjenje

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
init	0.03 ms
optimizing	0.00 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:730
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_tags/models/tag.php:280
12	TagsModelTag->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:52
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 5.30 ms Nakon posljednjeg upita: 3.00 ms Memorija za upit: 0.011 MB memorije prije upita: 7.479 MB Vraćeno zapisa: 9

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM bosona_contentitem_tag_map AS m

  INNER JOIN bosona_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2018-04-24 08:20:24')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2018-04-24 08:20:24')

  INNER JOIN bosona_content_types AS ct 
  ON ct.type_alias = m.type_alias

  LEFT JOIN bosona_categories AS tc 
  ON tc.id = c.core_catid

  LEFT JOIN bosona_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (119) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_zhgooglemap.mapmarker') 
  AND c.core_access IN (0,1,5)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email

  ORDER BY MAX(`c`.`core_title`) ASC

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	9	Using where; Using temporary; Korištenje filesort-a
1	SIMPLE	ct	ref	idx_alias	idx_alias	402	bosona.m.type_alias	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	bosona.m.core_content_id	1	Using where
1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	bosona.c.core_catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	bosona.c.core_created_user_id	1

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
checking query cache for query	0.43 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.06 ms
init	0.33 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.00 ms
storing result in query cache	0.08 ms
optimizing	0.03 ms
statistics	0.18 ms
preparing	0.05 ms
Creating tmp table	0.23 ms
executing	0.00 ms
Copying to tmp table	0.84 ms
Sorting result	0.09 ms
Sending data	0.28 ms
end	0.00 ms
removing tmp table	0.26 ms
end	0.05 ms
query end	0.00 ms
closing tables	1.16 ms
freeing items	0.14 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:348
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:55
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 0.51 ms Nakon posljednjeg upita: 21.76 ms Memorija za upit: 0.014 MB memorije prije upita: 8.119 MB Vraćeno zapisa: 0

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

  FROM bosona_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_tags.tag' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Korištenje filesort-a
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	bosona.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	bosona.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	bosona.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	bosona.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	bosona.a.group_id	1	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.06 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
14	PlgSystemFields->onContentPrepare()	Isto kao poziv u liniji niže.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:99
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 0.41 ms Nakon posljednjeg upita: 19.27 ms Memorija za upit: 0.010 MB memorije prije upita: 8.239 MB Vraćeno zapisa: 1

Dupli upiti: #19

SELECT *

  FROM bosona_tags

  WHERE `id` = '119'

Objašnjenje

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.06 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:730
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_tags/models/tag.php:335
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:197
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 1.49 ms Nakon posljednjeg upita: 0.36 ms Memorija za upit: 0.009 MB memorije prije upita: 8.249 MB

UPDATE bosona_tags

  SET `hits` = (`hits` + 1)

  WHERE `id` = '119'

Objašnjenje

OBJAŠNJENJE nije moguće u upitu: UPDATE bosona_tags SET `hits` = (`hits` + 1) WHERE `id` = '119'

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.73 ms
System lock	0.01 ms
init	0.06 ms
Updating	0.12 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.07 ms
query end	0.09 ms
closing tables	0.02 ms
freeing items	0.04 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1241
12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_tags/models/tag.php:336
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:197
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 0.51 ms Nakon posljednjeg upita: 14.16 ms Memorija za upit: 0.016 MB memorije prije upita: 8.530 MB Vraćeno zapisa: 45

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

  FROM `bosona_assets`

  WHERE `name` IN ('root.1','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyjoomlabackup','com_fields','com_finder','com_flexicontact','com_focalpoint','com_icagenda','com_installer','com_jce','com_jckman','com_joomlaupdate','com_k2','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_payage','com_payage_test','com_phocagallery','com_plugins','com_redirect','com_rsform','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bosona_assets	range	idx_asset_name	idx_asset_name	202	NULL	46	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.08 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:22
15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:201
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 0.49 ms Nakon posljednjeg upita: 7.91 ms Memorija za upit: 0.020 MB memorije prije upita: 8.772 MB Vraćeno zapisa: 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 bosona_categories as c

  LEFT JOIN bosona_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Korištenje filesort-a
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	15	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	Isto kao poziv u liniji niže.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:82
15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:201
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 1.07 ms Nakon posljednjeg upita: 1.80 ms Memorija za upit: 0.020 MB memorije prije upita: 8.839 MB Vraćeno zapisa: 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 bosona_categories as c

  LEFT JOIN bosona_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Korištenje filesort-a
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	15	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.11 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.07 ms
init	0.06 ms
optimizing	0.02 ms
statistics	0.18 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.05 ms
Sending data	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	Isto kao poziv u liniji niže.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:82
15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:201
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 0.48 ms Nakon posljednjeg upita: 2.95 ms Memorija za upit: 0.020 MB memorije prije upita: 8.869 MB Vraćeno zapisa: 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 bosona_categories as c

  LEFT JOIN bosona_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Korištenje filesort-a
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	15	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.06 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	Isto kao poziv u liniji niže.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:82
15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:201
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:381
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
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:267
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 2.80 ms Nakon posljednjeg upita: 14.98 ms Memorija za upit: 0.012 MB memorije prije upita: 9.245 MB Vraćeno zapisa: 7

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

  FROM bosona_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2018-04-24 08:20:24') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-04-24 08:20:24') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	54	Using where; Korištenje filesort-a
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	bosona.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	bosona.m.module,const	1	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.82 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.12 ms
executing	0.00 ms
Sorting result	0.35 ms
Sending data	0.68 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	Isto kao poziv u liniji niže.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/st_magazine/core/layouts/default.php:23
9	require_once JROOT/templates/st_magazine/core/layouts/default.php	JROOT/templates/st_magazine/core/classes/template.php:86
8	AvatarTemplate->render()	JROOT/templates/st_magazine/index.php:20
7	require JROOT/templates/st_magazine/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 20.80 ms Nakon posljednjeg upita: 33.27 ms Memorija za upit: 0.012 MB memorije prije upita: 10.408 MB Vraćeno zapisa: 3

SELECT DISTINCT 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

  FROM bosona_content AS a

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (9,10,11,12,13) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-24 08:20:24') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-24 08:20:24')

  ORDER BY a.hits DESC 
  LIMIT 3

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	128	Using where; Using temporary; Korištenje filesort-a
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	bosona.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	bosona.a.created_by	1
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	bosona.a.modified_by	1
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	bosona.c.parent_id	1

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.26 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.07 ms
init	0.12 ms
optimizing	0.03 ms
statistics	0.24 ms
preparing	0.04 ms
Creating tmp table	0.34 ms
executing	0.00 ms
Copying to tmp table	16.86 ms
Sorting result	0.38 ms
Sending data	0.08 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.11 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.09 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.08 ms
end	0.00 ms
removing tmp table	0.17 ms
end	0.00 ms
query end	0.00 ms
closing tables	1.32 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.05 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:556
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:76
11	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
10	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 20.13 ms Nakon posljednjeg upita: 5.14 ms Memorija za upit: 0.012 MB memorije prije upita: 10.452 MB Vraćeno zapisa: 3

SELECT DISTINCT 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

  FROM bosona_content AS a

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (9,10,11,12,13) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-24 08:20:24') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-24 08:20:24')

  ORDER BY a.created DESC 
  LIMIT 3

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	128	Using where; Using temporary; Korištenje filesort-a
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	bosona.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	bosona.a.created_by	1
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	bosona.a.modified_by	1
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	bosona.c.parent_id	1

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.26 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.06 ms
init	0.11 ms
optimizing	0.02 ms
statistics	0.24 ms
preparing	0.04 ms
Creating tmp table	0.37 ms
executing	0.00 ms
Copying to tmp table	17.60 ms
Sorting result	0.33 ms
Sending data	0.07 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
Sending data	0.10 ms
end	0.00 ms
removing tmp table	0.21 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.07 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
logging slow query	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:556
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:116
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 1.13 ms Nakon posljednjeg upita: 1.54 ms Memorija za upit: 0.017 MB memorije prije upita: 10.511 MB Vraćeno zapisa: 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 bosona_categories as c

  LEFT JOIN bosona_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

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

  ORDER BY c.lft

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Korištenje filesort-a
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	15	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.06 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
20	ContentRouter->getCategorySegment()	Isto kao poziv u liniji niže.
19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:128
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

Vrijeme upita: 0.48 ms Nakon posljednjeg upita: 104.44 ms Memorija za upit: 0.010 MB memorije prije upita: 11.387 MB Vraćeno zapisa: 138

SELECT * 
  FROM bosona_acymailing_config

Objašnjenje

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bosona_acymailing_config	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	138

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.05 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Pozivatelj	Datoteka i broj linije
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
11	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1369
10	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:21
9	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:145
8	plgSystemRegacymailing->onAfterRender()	Isto kao poziv u liniji niže.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1123
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Za linkove do datoteka dodaj xdebug.file_link_format direktivu u php.ini]

25 tipova upita evidentirano, sortirano po broju pojavljivanja DESC

SELECT tabele:

4 × 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 bosona_categories as c 
  LEFT JOIN bosona_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

```
2 × SELECT * 
  FROM bosona_tags
```

2 × SELECT DISTINCT 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 
  FROM bosona_content AS a 
  LEFT JOIN bosona_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN bosona_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN bosona_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN bosona_categories as parent 
  ON parent.id = c.parent_id

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

2 × SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM bosona_contentitem_tag_map AS m 
  INNER JOIN bosona_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2018-04-24 08:20:24')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2018-04-24 08:20:24') 
  INNER JOIN bosona_content_types AS ct 
  ON ct.type_alias = m.type_alias 
  LEFT JOIN bosona_categories AS tc 
  ON tc.id = c.core_catid 
  LEFT JOIN bosona_users AS ua 
  ON ua.id = c.core_created_user_id

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

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

1 × SELECT * 
  FROM bosona_acymailing_confi

1 × SELECT * 
  FROM `bosona_content_types

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `bosona_assets`

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

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

1 × SELECT id, rules 
  FROM `bosona_viewlevels

1 × SELECT `session_id` 
  FROM `bosona_session`

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

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

1 × SELECT `data` 
  FROM `bosona_session`

```
1 × SELECT * 
  FROM bosona_languages
```
```
1 × SELECT id 
  FROM `bosona_tags`
```

1 × SELECT params 
  FROM bosona_extensions

OTHER tabele:

1 × UPDATE bosona_tags 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `bosona_tags

1 × UPDATE `bosona_extensions` 
  SET `params` = '{\"mediaversion\":\"42e280458576a78b439f2a73f26f390f\"}'

1 × INSERT INTO `bosona_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('qbsr45mhq6454ani443q5chu16', 1, '1524558023', 0, '', 0

```
1 × DELETE  
  FROM `bosona_session`
```

555. obljetnica od prvog pisanog spomena Tešnja

Fojnica – Treće Hodoljublje 2014

Muzej samostana u Fojnici kandidat za najljepši muzej u Evropi

Prva godina rada nakon otvaranja Zemaljskog muzeja Bosne i Hercegovine

Sarajevo - 129. rođendan Zemaljskog muzeja Bosne i Hercegovine

Sarajevo - Promocijom „suvenirnice“ počelo obilježavanje 70 godina od osnivanja Historijskog muzeja Bosne i Hercegovine

Sarajevo - Proslava nagrade "Europa Nostra" - Grand Prix 2016 za kulturno nasljeđe

Sarajevo - Replika autarijatskih kultnih kolica sa Galsnica uručena Zemaljskom muzeju BiH

Visoko - Predstavljen projekat "Muzej srednjovjekovne Bosne - Mili"

Udruženje građana Bosona

Najnovije

Najčitanije

Background Image

Header Color

Content Color

Joomla! Debug konzola

Sesija

Informacije profila

Vrijeme

Memorija

Iskorištenost memorije

Upiti baze podataka

32 upita evidentirano 123.24 ms

2 duplikata pronađeno!

25 tipova upita evidentirano, sortirano po broju pojavljivanja DESC

SELECT tabele:

OTHER tabele: