Aktuelno

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

Vrijeme

Memorija

53 upita evidentirano 206.44 ms

1. Vrijeme upita: 1.23 ms Memorija za upit: 0.011 MB memorije prije upita: 2.569 MB Vraćeno zapisa: 0

   SELECT `data`
   
     FROM `bosona_session`
   
     WHERE `session_id` = '80dp10dmvd5dptp18332nniko6'

   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.01 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.04 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.02 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.72 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.01 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.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Pozivatelj	Fajl 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:755
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Vrijeme upita: 0.66 ms Nakon posljednjeg upita: 4.02 ms Memorija za upit: 0.007 MB memorije prije upita: 2.676 MB Vraćeno zapisa: 0

   SELECT `session_id`
   
     FROM `bosona_session`
   
     WHERE `session_id` = '80dp10dmvd5dptp18332nniko6' 
     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.02 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	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.06 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   freeing items	0.01 ms
   storing result in query cache	0.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Pozivatelj	Fajl i broj linije
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Vrijeme upita: 0.98 ms Nakon posljednjeg upita: 0.31 ms Memorija za upit: 0.006 MB memorije prije upita: 2.686 MB

   INSERT INTO `bosona_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('80dp10dmvd5dptp18332nniko6', 1, '1529307285', 0, '', 0)

   Objašnjenje

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

   Profil

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.01 ms
   update	0.60 ms
   Waiting for query cache lock	0.00 ms
   update	0.02 ms
   end	0.00 ms
   query end	0.03 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	Fajl i broj linije
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Vrijeme upita: 1.85 ms Nakon posljednjeg upita: 9.49 ms Memorija za upit: 0.008 MB memorije prije upita: 2.889 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.02 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.04 ms
   executing	0.00 ms
   Sending data	0.15 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   Sending data	0.15 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   Sending data	0.15 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.01 ms
   Sending data	0.38 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
   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.01 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Pozivatelj	Fajl i broj linije
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:423
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	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:431
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:497
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Vrijeme upita: 0.39 ms Nakon posljednjeg upita: 7.98 ms Memorija za upit: 0.007 MB memorije prije upita: 3.093 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.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Pozivatelj	Fajl 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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Vrijeme upita: 0.28 ms Nakon posljednjeg upita: 0.25 ms Memorija za upit: 0.008 MB memorije prije upita: 3.106 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.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Pozivatelj	Fajl 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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Vrijeme upita: 3.14 ms Nakon posljednjeg upita: 1.85 ms Memorija za upit: 0.008 MB memorije prije upita: 3.170 MB Vraćeno zapisa: 109

   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	143	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	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.01 ms
   statistics	0.10 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sorting result	0.82 ms
   Sending data	0.20 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	1.07 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.03 ms
   freeing items	0.12 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	Fajl 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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Vrijeme upita: 5.61 ms Nakon posljednjeg upita: 152.10 ms Memorija za upit: 0.013 MB memorije prije upita: 5.408 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.02 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   checking query cache for query	0.15 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   System lock	0.02 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.06 ms
   init	0.07 ms
   optimizing	0.02 ms
   statistics	0.10 ms
   preparing	0.05 ms
   executing	0.01 ms
   Sorting result	0.78 ms
   Sending data	0.63 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.00 ms
   Sending data	0.96 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.00 ms
   Sending data	0.72 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.00 ms
   Sending data	0.48 ms
   Waiting for query cache lock	0.01 ms
   Waiting on query cache mutex	0.00 ms
   Sending data	0.53 ms
   end	0.02 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.28 ms
   Waiting for query cache lock	0.01 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.14 ms

   Call Stack

   #	Pozivatelj	Fajl 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:374
   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:488
   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:1070
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Vrijeme upita: 2.91 ms Nakon posljednjeg upita: 37.51 ms Memorija za upit: 0.013 MB memorije prije upita: 6.107 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.06 ms
   checking permissions	0.01 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.05 ms
   init	0.03 ms
   optimizing	0.02 ms
   statistics	2.15 ms
   preparing	0.03 ms
   executing	0.00 ms
   Sending data	0.12 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.01 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	Fajl 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:1080
   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:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Vrijeme upita: 1.05 ms Nakon posljednjeg upita: 0.41 ms Memorija za upit: 0.010 MB memorije prije upita: 6.105 MB

    UPDATE `bosona_extensions`
    
      SET `params` = '{\"mediaversion\":\"d4ed7d7b2d79ef19d5d7a13e5be42bc4\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Objašnjenje

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

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.10 ms
    Updating	0.14 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.13 ms
    query end	0.11 ms
    closing tables	0.02 ms
    freeing items	0.09 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl 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:1080
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Vrijeme upita: 0.33 ms Nakon posljednjeg upita: 9.59 ms Memorija za upit: 0.010 MB memorije prije upita: 6.397 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	Fajl 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:1080
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Vrijeme upita: 0.94 ms Nakon posljednjeg upita: 12.21 ms Memorija za upit: 0.014 MB memorije prije upita: 6.496 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.09 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.05 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.15 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.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	Fajl 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:1080
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Vrijeme upita: 1.23 ms Nakon posljednjeg upita: 49.45 ms Memorija za upit: 0.008 MB memorije prije upita: 6.517 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.04 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.02 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.00 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.11 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.19 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.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl 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:1080
    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:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Vrijeme upita: 6.45 ms Nakon posljednjeg upita: 25.32 ms Memorija za upit: 0.015 MB memorije prije upita: 7.014 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.09 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.12 ms
    optimizing	0.01 ms
    statistics	0.38 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	5.09 ms
    end	0.01 ms
    query end	0.01 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.08 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.06 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:113
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:44
    13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:54
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Vrijeme upita: 12.51 ms Nakon posljednjeg upita: 4.68 ms Memorija za upit: 0.012 MB memorije prije upita: 7.147 MB Vraćeno zapisa: 5

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      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.featured = 1 
      AND a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-18 07:34:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-18 07:34:45')
    
      ORDER BY c.lft,  
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
      LIMIT 6

    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_featured_catid	idx_featured_catid	1	const	5	Using where; Using temporary; Korištenje filesort-a
    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	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	bosona.a.catid	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	bosona.c.parent_id	1

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    checking query cache for query	0.17 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.01 ms
    Waiting on query cache mutex	0.05 ms
    init	0.08 ms
    optimizing	0.02 ms
    statistics	4.30 ms
    preparing	0.07 ms
    Creating tmp table	0.31 ms
    executing	0.00 ms
    Copying to tmp table	5.87 ms
    Sorting result	0.05 ms
    Sending data	0.10 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.15 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.15 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.13 ms
    end	0.01 ms
    removing tmp table	0.11 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.05 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.11 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	Fajl i broj linije
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Vrijeme upita: 11.31 ms Nakon posljednjeg upita: 15.70 ms Memorija za upit: 0.012 MB memorije prije upita: 7.406 MB Vraćeno zapisa: 4

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

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	119	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bosona.t.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.01 ms
    checking query cache for query	0.06 ms
    checking permissions	0.00 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.06 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	2.14 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	8.41 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.08 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	Fajl i broj linije
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Vrijeme upita: 2.93 ms Nakon posljednjeg upita: 0.81 ms Memorija za upit: 0.012 MB memorije prije upita: 7.443 MB Vraćeno zapisa: 1

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

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	119	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bosona.t.id	1	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    checking query cache for query	0.05 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.02 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	2.21 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.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.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Vrijeme upita: 3.09 ms Nakon posljednjeg upita: 0.71 ms Memorija za upit: 0.012 MB memorije prije upita: 7.469 MB Vraćeno zapisa: 1

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

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	119	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bosona.t.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.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.02 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.07 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	2.28 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.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.04 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Vrijeme upita: 2.07 ms Nakon posljednjeg upita: 0.71 ms Memorija za upit: 0.012 MB memorije prije upita: 7.496 MB Vraćeno zapisa: 2

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

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	119	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bosona.t.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.05 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.03 ms
    init	0.04 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	1.37 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.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	Fajl i broj linije
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Vrijeme upita: 5.65 ms Nakon posljednjeg upita: 0.72 ms Memorija za upit: 0.012 MB memorije prije upita: 7.526 MB Vraćeno zapisa: 4

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

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	119	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bosona.t.id	1	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.02 ms
    Waiting on query cache mutex	0.00 ms
    checking query cache for query	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	3.22 ms
    init	0.04 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	1.30 ms
    end	0.00 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.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.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Vrijeme upita: 1.12 ms Nakon posljednjeg upita: 2.95 ms Memorija za upit: 0.012 MB memorije prije upita: 7.615 MB Vraćeno zapisa: 1

    SELECT COUNT(*)
    
      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.featured = 1 
      AND a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-18 07:34:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-18 07:34:45')

    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_featured_catid	idx_featured_catid	1	const	5	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	bosona.a.created_by	1	Using index
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	bosona.a.modified_by	1	Using index
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	bosona.a.catid	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	bosona.c.parent_id	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.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 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.06 ms
    optimizing	0.03 ms
    statistics	0.30 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.13 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.04 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.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	Fajl i broj linije
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
    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_content/views/featured/view.html.php:56
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Vrijeme upita: 2.72 ms Nakon posljednjeg upita: 139.71 ms Memorija za upit: 0.015 MB memorije prije upita: 8.305 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 `s`
    
      INNER JOIN `bosona_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 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.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    checking query cache for query	0.17 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.01 ms
    Waiting on query cache mutex	0.03 ms
    init	0.09 ms
    optimizing	0.03 ms
    statistics	1.52 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.09 ms
    Sending data	0.10 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.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
    18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	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:479
    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_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Vrijeme upita: 3.41 ms Nakon posljednjeg upita: 1.73 ms Memorija za upit: 0.014 MB memorije prije upita: 8.360 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
    
      LEFT JOIN `bosona_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (10,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Objaš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
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	bosona.a.id	1	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.15 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.06 ms
    init	0.09 ms
    optimizing	0.03 ms
    statistics	2.26 ms
    preparing	0.07 ms
    executing	0.00 ms
    Sorting result	0.03 ms
    Sending data	0.04 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.02 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	Fajl 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:479
    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_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Vrijeme upita: 1.24 ms Nakon posljednjeg upita: 20.49 ms Memorija za upit: 0.015 MB memorije prije upita: 8.697 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 `s`
    
      INNER JOIN `bosona_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 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.14 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.03 ms
    init	0.07 ms
    optimizing	0.02 ms
    statistics	0.18 ms
    preparing	0.04 ms
    executing	0.00 ms
    Sorting result	0.08 ms
    Sending data	0.11 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 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.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	Fajl i broj linije
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
    18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	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:479
    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_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Vrijeme upita: 1.21 ms Nakon posljednjeg upita: 0.43 ms Memorija za upit: 0.014 MB memorije prije upita: 8.710 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
    
      LEFT JOIN `bosona_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (11,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Objaš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
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	bosona.a.id	1	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.15 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.05 ms
    init	0.12 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.06 ms
    executing	0.00 ms
    Sorting result	0.03 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 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.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl 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:479
    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_content/views/featured/view.html.php:98
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Vrijeme upita: 7.60 ms Nakon posljednjeg upita: 115.55 ms Memorija za upit: 0.012 MB memorije prije upita: 9.287 MB Vraćeno zapisa: 18

    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-06-18 07:34:45') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-06-18 07:34:45') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 194 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.02 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.04 ms
    init	0.05 ms
    optimizing	0.05 ms
    statistics	1.06 ms
    preparing	0.04 ms
    executing	0.00 ms
    Sorting result	3.03 ms
    Sending data	2.28 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.29 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 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.11 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	Fajl 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:1027
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Vrijeme upita: 28.36 ms Nakon posljednjeg upita: 175.73 ms Memorija za upit: 0.012 MB memorije prije upita: 10.384 MB Vraćeno zapisa: 3

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      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-06-18 07:34:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-18 07:34:45')
    
      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	130	Using where; 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.36 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.18 ms
    optimizing	1.15 ms
    statistics	0.65 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sorting result	24.15 ms
    Sending data	0.74 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.12 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.09 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.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.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl 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:559
    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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Vrijeme upita: 3.21 ms Nakon posljednjeg upita: 20.07 ms Memorija za upit: 0.012 MB memorije prije upita: 10.426 MB Vraćeno zapisa: 3

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      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-06-18 07:34:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-18 07:34:45')
    
      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	130	Using where; 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.01 ms
    checking query cache for query	0.38 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.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.05 ms
    init	0.17 ms
    optimizing	0.03 ms
    statistics	0.17 ms
    preparing	0.05 ms
    executing	0.00 ms
    Sorting result	0.85 ms
    Sending data	0.15 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.16 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.23 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.16 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.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.01 ms

    Call Stack

    #	Pozivatelj	Fajl 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:559
    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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Vrijeme upita: 6.29 ms Nakon posljednjeg upita: 104.09 ms Memorija za upit: 0.010 MB memorije prije upita: 10.850 MB Vraćeno zapisa: 9
    Dupli upiti: #35

    SELECT m.title, m.published, m.id, m.params, m.language
    
      FROM `bosona_menu` AS m
    
      WHERE (m.link = 'index.php?option=com_icagenda&view=list') 
      AND (m.published = 1)

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	171	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    checking query cache for query	0.17 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.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	1.24 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 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.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/menus/menus.php:53
    12	icagendaMenus::iClistMenuItemsInfo()	JROOT/modules/mod_iccalendar/helper.php:150
    11	modiCcalendarHelper->getStamp()	JROOT/modules/mod_iccalendar/mod_iccalendar.php:154
    10	include JROOT/modules/mod_iccalendar/mod_iccalendar.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Vrijeme upita: 20.91 ms Nakon posljednjeg upita: 1.36 ms Memorija za upit: 0.010 MB memorije prije upita: 10.896 MB Vraćeno zapisa: 7

    SELECT e.*,
    				e.place as place_name,
    				c.title as cat_title,
    				c.alias as cat_alias,
    				c.color as cat_color,
    				c.ordering as cat_order
    			,feat.count AS features,r.count AS registered, r.date AS reg_date
    
      FROM `bosona_icagenda_events` AS e
    
      LEFT JOIN `bosona_icagenda_category` AS c 
      ON `c`.`id` = `e`.`catid`
    
      LEFT JOIN (
    SELECT fx.event_id, COUNT(*) AS count
    
      FROM `bosona_icagenda_feature_xref` AS fx
    
      INNER JOIN `bosona_icagenda_feature` AS f 
      ON fx.feature_id=f.id 
      AND f.state=1 
      AND f.icon<>'-1'
    
      GROUP BY fx.event_id) AS feat 
      ON e.id=feat.event_id
    
      LEFT JOIN (
    SELECT r.eventid, sum(r.people) AS count, r.date AS date
    
      FROM `bosona_icagenda_registration` AS r
    
      WHERE r.state > 0
    
      GROUP BY r.eventid) AS r 
      ON e.id=r.eventid
    
      WHERE c.state = 1 
      AND e.state = 1 
      AND e.approval = 0 
      AND e.next>=2018-06-01 
      AND e.catid IN (1) 
      AND e.access IN (1, 1, 5)

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
    1	PRIMARY	e	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	48	Using where
    1	PRIMARY	<derived2>	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	5
    1	PRIMARY	<derived3>	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	2
    3	DERIVED	r	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	24	Using where; Using temporary; Korištenje filesort-a
    2	DERIVED	f	system	PRIMARY	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	1	Using temporary; Korištenje filesort-a
    2	DERIVED	fx	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	5	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.13 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	1.29 ms
    optimizing	0.01 ms
    statistics	0.32 ms
    preparing	0.04 ms
    Creating tmp table	0.03 ms
    executing	0.00 ms
    Copying to tmp table	0.25 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Creating tmp table	0.13 ms
    executing	0.00 ms
    Copying to tmp table	0.41 ms
    Sorting result	0.02 ms
    Sending data	0.02 ms
    removing tmp table	0.01 ms
    Sending data	0.00 ms
    removing tmp table	0.11 ms
    Sending data	0.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.06 ms
    init	0.05 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.02 ms
    statistics	0.31 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	10.67 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.25 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.03 ms
    freeing items	0.09 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_iccalendar/helper.php:262
    11	modiCcalendarHelper->getStamp()	JROOT/modules/mod_iccalendar/mod_iccalendar.php:154
    10	include JROOT/modules/mod_iccalendar/mod_iccalendar.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Vrijeme upita: 7.09 ms Nakon posljednjeg upita: 15.02 ms Memorija za upit: 0.010 MB memorije prije upita: 11.039 MB Vraćeno zapisa: 6

    SELECT r.date AS date, r.eventid AS eventid, r.people AS people
    
      FROM `bosona_icagenda_registration` AS r
    
      WHERE r.state = 1

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	r	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	24	Using where

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    checking query cache for query	0.07 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.04 ms
    init	0.02 ms
    optimizing	0.03 ms
    statistics	0.01 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.02 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.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.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/data.php:1004
    12	icagendaEventsData::registeredList()	JROOT/modules/mod_iccalendar/helper.php:264
    11	modiCcalendarHelper->getStamp()	JROOT/modules/mod_iccalendar/mod_iccalendar.php:154
    10	include JROOT/modules/mod_iccalendar/mod_iccalendar.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Vrijeme upita: 2.62 ms Nakon posljednjeg upita: 96.74 ms Memorija za upit: 0.010 MB memorije prije upita: 11.263 MB Vraćeno zapisa: 1

    SELECT DISTINCT f.icon, f.icon_alt
    
      FROM `bosona_icagenda_feature_xref` AS fx
    
      INNER JOIN `bosona_icagenda_feature` AS f 
      ON fx.feature_id=f.id 
      AND f.state=1 
      AND f.icon<>'-1'
    
      WHERE fx.event_id=47
    
      ORDER BY f.ordering DESC

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	system	PRIMARY	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	1	Using temporary
    1	SIMPLE	fx	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	5	Using where; Distinct

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    checking query cache for query	0.07 ms
    checking permissions	0.01 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.03 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.00 ms
    Copying to tmp table	0.03 ms
    Removing duplicates	0.01 ms
    Sending data	0.01 ms
    end	0.00 ms
    removing tmp table	0.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.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	Fajl i broj linije
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/events.php:80
    12	icagendaEvents::featureIcons()	JROOT/modules/mod_iccalendar/helper.php:296
    11	modiCcalendarHelper->getStamp()	JROOT/modules/mod_iccalendar/mod_iccalendar.php:154
    10	include JROOT/modules/mod_iccalendar/mod_iccalendar.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Vrijeme upita: 0.92 ms Nakon posljednjeg upita: 8.81 ms Memorija za upit: 0.010 MB memorije prije upita: 11.271 MB Vraćeno zapisa: 44

    SELECT id AS nbevt
    
      FROM `bosona_icagenda_events` AS e
    
      WHERE e.state > 0

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	48	Using where

    Profil

    Status	Duration
    starting	0.02 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.03 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.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.35 ms
    end	0.04 ms
    query end	0.00 ms
    closing tables	0.01 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.03 ms
    Waiting for query cache lock	0.01 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	Fajl i broj linije
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    12	JDatabaseDriver->loadResult()	JROOT/modules/mod_iccalendar/helper.php:898
    11	modiCcalendarHelper->getStamp()	JROOT/modules/mod_iccalendar/mod_iccalendar.php:154
    10	include JROOT/modules/mod_iccalendar/mod_iccalendar.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Vrijeme upita: 3.20 ms Nakon posljednjeg upita: 118.14 ms Memorija za upit: 0.010 MB memorije prije upita: 11.548 MB Vraćeno zapisa: 47

    SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate,
    						weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
    
      FROM `bosona_icagenda_events` AS e
    
      WHERE  e.state = 1 OR e.state = 0

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	48	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.06 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.03 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.36 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	1.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.10 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	Fajl i broj linije
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/data.php:653
    11	icagendaEventsData::getNext()	JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:123
    10	include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Vrijeme upita: 1.18 ms Nakon posljednjeg upita: 25.00 ms Memorija za upit: 0.010 MB memorije prije upita: 11.559 MB Vraćeno zapisa: 9
    Dupli upiti: #29

    SELECT m.title, m.published, m.id, m.params, m.language
    
      FROM `bosona_menu` AS m
    
      WHERE (m.link = 'index.php?option=com_icagenda&view=list') 
      AND (m.published = 1)

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	171	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.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.09 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/menus/menus.php:53
    11	icagendaMenus::iClistMenuItemsInfo()	JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:193
    10	include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Vrijeme upita: 2.66 ms Nakon posljednjeg upita: 3.17 ms Memorija za upit: 0.011 MB memorije prije upita: 11.656 MB Vraćeno zapisa: 0

    SELECT e.*,l.title AS language_title,c.title AS category, c.color AS catcolor,feat.count AS features,r.count AS registered
    
      FROM `bosona_icagenda_events` AS e
    
      LEFT JOIN `bosona_languages` AS l 
      ON l.lang_code = e.language
    
      LEFT JOIN bosona_icagenda_category AS c 
      ON c.id = e.catid
    
      LEFT JOIN (
    SELECT fx.event_id, COUNT(*) AS count
    
      FROM `bosona_icagenda_feature_xref` AS fx
    
      INNER JOIN `bosona_icagenda_feature` AS f 
      ON fx.feature_id=f.id 
      AND f.state=1 
      AND f.icon<>'-1'
    
      GROUP BY fx.event_id) AS feat 
      ON e.id=feat.event_id
    
      LEFT JOIN (
    SELECT r.state, r.date, r.eventid, sum(r.people) AS count
    
      FROM `bosona_icagenda_registration` AS r
    
      WHERE r.state > 0
    
      GROUP BY r.date, r.eventid) AS r 
      ON ((e.next = r.date OR r.date = "") 
      AND e.id = r.eventid)
    
      WHERE c.state = 1 
      AND e.state = 1 
      AND e.approval <> 1 
      AND e.access IN (1,1,5) 
      AND e.catid IN (1) 
      AND `e`.`next` >= '2018-06-18' OR (`e`.`next` < '2018-06-18 09:34:46' 
      AND `e`.`startdate` <> "0000-00-00 00:00:00" 
      AND `e`.`enddate` > '2018-06-18 09:34:46')
    
      ORDER BY e.next ASC 
      LIMIT 3

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	e	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	48	Using where; Using temporary; Korištenje filesort-a
    1	PRIMARY	l	eq_ref	idx_langcode	idx_langcode	28	func	1
    1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	bosona.e.catid	1	Using where
    1	PRIMARY	<derived2>	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	5
    1	PRIMARY	<derived3>	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	2
    3	DERIVED	r	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	24	Using where; Using temporary; Korištenje filesort-a
    2	DERIVED	f	system	PRIMARY	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	1	Using temporary; Korištenje filesort-a
    2	DERIVED	fx	ALL	NULL	NE MOŽE SE KORISTITI INDEKSNI KLJUČ	NULL	NULL	5	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.22 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    System lock	0.20 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    executing	0.00 ms
    Copying to tmp table	0.02 ms
    Sorting result	0.01 ms
    Sending data	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Creating tmp table	0.10 ms
    executing	0.00 ms
    Copying to tmp table	0.16 ms
    Sorting result	0.02 ms
    Sending data	0.02 ms
    removing tmp table	0.01 ms
    Sending data	0.00 ms
    removing tmp table	0.10 ms
    Sending data	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.05 ms
    init	0.12 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.04 ms
    Creating tmp table	0.20 ms
    executing	0.00 ms
    Copying to tmp table	0.26 ms
    Sorting result	0.01 ms
    Sending data	0.04 ms
    end	0.00 ms
    removing tmp table	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.17 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing tables	0.02 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.11 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	Fajl i broj linije
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/modules/mod_ic_event_list/helper.php:109
    11	modiCEventListHelper::getList()	JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:207
    10	include JROOT/modules/mod_ic_event_list/mod_ic_event_list.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Vrijeme upita: 15.50 ms Nakon posljednjeg upita: 48.06 ms Memorija za upit: 0.013 MB memorije prije upita: 11.719 MB Vraćeno zapisa: 5

    SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,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) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-18 07:34:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-18 07:34:45')
    
      ORDER BY rand()  
      LIMIT 5

    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	130	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	Using index
    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.22 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
    init	0.16 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.04 ms
    Creating tmp table	0.30 ms
    executing	0.00 ms
    Copying to tmp table	12.59 ms
    Sorting result	0.36 ms
    Sending data	0.43 ms
    end	0.00 ms
    removing tmp table	0.24 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.06 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
    13	ContentModelArticles->getItems()	JROOT/modules/mod_st_content_showcase/models/article/article.php:90
    12	stContentShowcaseModelArticle->_items()	JROOT/modules/mod_st_content_showcase/models/model.php:26
    11	stContentShowcaseModel->getList()	JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.php:22
    10	include JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Vrijeme upita: 2.54 ms Nakon posljednjeg upita: 0.92 ms Memorija za upit: 0.012 MB memorije prije upita: 11.797 MB Vraćeno zapisa: 3

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

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	119	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bosona.t.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.05 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.02 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	1.67 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.11 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	Fajl i broj linije
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    13	ContentModelArticles->getItems()	JROOT/modules/mod_st_content_showcase/models/article/article.php:90
    12	stContentShowcaseModelArticle->_items()	JROOT/modules/mod_st_content_showcase/models/model.php:26
    11	stContentShowcaseModel->getList()	JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.php:22
    10	include JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Vrijeme upita: 2.17 ms Nakon posljednjeg upita: 0.79 ms Memorija za upit: 0.012 MB memorije prije upita: 11.831 MB Vraćeno zapisa: 4

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

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	119	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bosona.t.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.04 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.02 ms
    init	0.04 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	1.32 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.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.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    13	ContentModelArticles->getItems()	JROOT/modules/mod_st_content_showcase/models/article/article.php:90
    12	stContentShowcaseModelArticle->_items()	JROOT/modules/mod_st_content_showcase/models/model.php:26
    11	stContentShowcaseModel->getList()	JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.php:22
    10	include JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Vrijeme upita: 2.13 ms Nakon posljednjeg upita: 0.76 ms Memorija za upit: 0.012 MB memorije prije upita: 11.868 MB Vraćeno zapisa: 2

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

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	119	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bosona.t.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.05 ms
    checking permissions	0.00 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.01 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	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.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.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    13	ContentModelArticles->getItems()	JROOT/modules/mod_st_content_showcase/models/article/article.php:90
    12	stContentShowcaseModelArticle->_items()	JROOT/modules/mod_st_content_showcase/models/model.php:26
    11	stContentShowcaseModel->getList()	JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.php:22
    10	include JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Vrijeme upita: 2.15 ms Nakon posljednjeg upita: 0.72 ms Memorija za upit: 0.012 MB memorije prije upita: 11.897 MB Vraćeno zapisa: 3

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

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	119	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bosona.t.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.06 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.02 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	1.35 ms
    end	0.01 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.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	Fajl i broj linije
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    13	ContentModelArticles->getItems()	JROOT/modules/mod_st_content_showcase/models/article/article.php:90
    12	stContentShowcaseModelArticle->_items()	JROOT/modules/mod_st_content_showcase/models/model.php:26
    11	stContentShowcaseModel->getList()	JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.php:22
    10	include JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Vrijeme upita: 2.49 ms Nakon posljednjeg upita: 0.74 ms Memorija za upit: 0.012 MB memorije prije upita: 11.930 MB Vraćeno zapisa: 2

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

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	119	Using where
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	bosona.t.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.05 ms
    checking permissions	0.02 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.02 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	1.46 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.11 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	Fajl i broj linije
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
    13	ContentModelArticles->getItems()	JROOT/modules/mod_st_content_showcase/models/article/article.php:90
    12	stContentShowcaseModelArticle->_items()	JROOT/modules/mod_st_content_showcase/models/model.php:26
    11	stContentShowcaseModel->getList()	JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.php:22
    10	include JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Vrijeme upita: 1.07 ms Nakon posljednjeg upita: 1.29 ms Memorija za upit: 0.018 MB memorije prije upita: 11.947 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
    
      LEFT JOIN `bosona_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_articles_news.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (11,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Objaš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
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	bosona.a.id	1	Using where; Using index

    Profil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    checking query cache for query	0.16 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.05 ms
    init	0.07 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 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.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.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    23	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    20	PlgSystemFields->onContentPrepare()	Isto kao poziv u liniji niže.
    19	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    16	JHtmlContent::prepare()	Isto kao poziv u liniji niže.
    15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_st_content_showcase/models/article/article.php:121
    12	stContentShowcaseModelArticle->_items()	JROOT/modules/mod_st_content_showcase/models/model.php:26
    11	stContentShowcaseModel->getList()	JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.php:22
    10	include JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Vrijeme upita: 0.54 ms Nakon posljednjeg upita: 4.27 ms Memorija za upit: 0.010 MB memorije prije upita: 11.958 MB Vraćeno zapisa: 4

    SELECT id, title
    
      FROM bosona_categories
    
      WHERE id IN (9,10,11,12) 
      AND published = 1

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	bosona_categories	range	PRIMARY	PRIMARY	4	NULL	4	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.02 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.05 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.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	Fajl i broj linije
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_st_content_showcase/models/article/article.php:29
    11	stContentShowcaseModelArticle->getCategories()	JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.php:23
    10	include JROOT/modules/mod_st_content_showcase/mod_st_content_showcase.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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Vrijeme upita: 2.99 ms Nakon posljednjeg upita: 68.32 ms Memorija za upit: 0.012 MB memorije prije upita: 11.819 MB Vraćeno zapisa: 2

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      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.featured = 0 
      AND a.catid IN (9) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-18 07:34:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-18 07:34:45')
    
      ORDER BY a.created DESC 
      LIMIT 2

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Korištenje filesort-a
    1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid,idx_featured_catid	idx_catid,idx_featured_catid,idx_state	4,5,1	NULL	6	Using intersect(idx_catid,idx_featured_catid,idx_state); 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	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.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.01 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.09 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.08 ms
    executing	0.00 ms
    Sorting result	1.38 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.13 ms
    end	0.00 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.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.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl 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:559
    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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Vrijeme upita: 0.96 ms Nakon posljednjeg upita: 1.30 ms Memorija za upit: 0.017 MB memorije prije upita: 11.876 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 `s`
    
      INNER JOIN `bosona_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 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.10 ms
    checking permissions	0.00 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.02 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.05 ms
    Sending data	0.06 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.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.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    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:670
    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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Vrijeme upita: 2.73 ms Nakon posljednjeg upita: 2.43 ms Memorija za upit: 0.012 MB memorije prije upita: 11.863 MB Vraćeno zapisa: 5

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      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 (12) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-18 07:34:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-18 07:34:45')
    
      ORDER BY a.created DESC 
      LIMIT 5

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Korištenje filesort-a
    1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	20	Using intersect(idx_catid,idx_state); 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	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.22 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.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.08 ms
    init	0.11 ms
    optimizing	0.04 ms
    statistics	0.09 ms
    preparing	0.07 ms
    executing	0.00 ms
    Sorting result	0.50 ms
    Sending data	0.14 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.30 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.07 ms
    Waiting for query cache lock	0.03 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.10 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	Fajl 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:559
    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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. Vrijeme upita: 1.58 ms Nakon posljednjeg upita: 2.35 ms Memorija za upit: 0.017 MB memorije prije upita: 11.977 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 `s`
    
      INNER JOIN `bosona_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 12
    
      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.09 ms
    checking permissions	0.00 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.07 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	0.16 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.06 ms
    Sending data	0.07 ms
    end	0.03 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.05 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    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:670
    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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

49. Vrijeme upita: 2.24 ms Nakon posljednjeg upita: 3.25 ms Memorija za upit: 0.012 MB memorije prije upita: 11.915 MB Vraćeno zapisa: 5

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      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 (13) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-18 07:34:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-18 07:34:45')
    
      ORDER BY a.created DESC 
      LIMIT 5

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Korištenje filesort-a
    1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	11	Using intersect(idx_catid,idx_state); 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	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.21 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.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.04 ms
    init	0.07 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.06 ms
    executing	0.00 ms
    Sorting result	0.33 ms
    Sending data	0.20 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.15 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.14 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.15 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    Sending data	0.10 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.03 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.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.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl 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:559
    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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

50. Vrijeme upita: 1.14 ms Nakon posljednjeg upita: 2.36 ms Memorija za upit: 0.017 MB memorije prije upita: 12.038 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 `s`
    
      INNER JOIN `bosona_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 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.13 ms
    checking permissions	0.00 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.08 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.06 ms
    Sending data	0.10 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.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.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl i broj linije
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:314
    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:670
    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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

51. Vrijeme upita: 3.21 ms Nakon posljednjeg upita: 3.31 ms Memorija za upit: 0.012 MB memorije prije upita: 11.967 MB Vraćeno zapisa: 4

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias
    
      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 (11) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-18 07:34:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-18 07:34:45')
    
      ORDER BY a.created DESC 
      LIMIT 4

    Objašnjenje

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Korištenje filesort-a
    1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	21	Using intersect(idx_catid,idx_state); 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	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.34 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.04 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.14 ms
    init	0.13 ms
    optimizing	0.04 ms
    statistics	0.24 ms
    preparing	0.10 ms
    executing	0.00 ms
    Sorting result	1.04 ms
    Sending data	0.18 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.26 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.11 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.04 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.11 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.07 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Pozivatelj	Fajl 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:559
    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:783
    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:1041
    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:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

52. Vrijeme upita: 2.89 ms Nakon posljednjeg upita: 4.48 ms Memorija za upit: 0.012 MB memorije prije upita: 11.994 MB Vraćeno zapisa: 4