Joomla! Debug конзола

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

Време

Меморија

31 забележани барања 95.62 ms

1. Време на барање: 1.35 ms Меморија по барање: 0.022 MB меморија по барањето: 1.987 MB Вратени редови: 0

   SELECT `data`
   
     FROM `og45h_session`
   
     WHERE `session_id` = '55jb6gnarfd1s90lbun42qsl4h'

   Објаснение

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

   Профил

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

   Call Stack

   #	Повикувач	Документ и број на линија
   14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\session\storage\database.php:44
   12	JSessionStorageDatabase->read()	Исто како повикот линија подолу.
   11	session_start()	JROOT\libraries\joomla\session\handler\native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT\libraries\joomla\session\handler\native.php:49
   9	JSessionHandlerNative->start()	JROOT\libraries\joomla\session\handler\joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT\libraries\joomla\session\session.php:636
   7	JSession->_start()	JROOT\libraries\joomla\session\session.php:596
   6	JSession->start()	JROOT\libraries\cms\application\cms.php:773
   5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
   4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
   3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:408
   2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
   1	JFactory::getApplication()	JROOT\index.php:46

   [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

   ---

2. Време на барање: 2.04 ms По последното барање: 4.14 ms Меморија по барање: 0.002 MB меморија по барањето: 2.163 MB

   DELETE 
   
     FROM `og45h_session`
   
     WHERE `time` < '1574436017'

   Објаснение

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	og45h_session	range	time	time	45	const	1	100.00	Using where

   Профил

   Status	Duration
   starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.07 ms
   updating	0.36 ms
   end	0.03 ms
   Waiting for query cache lock	0.01 ms
   end	0.13 ms
   query end	0.10 ms
   closing tables	0.51 ms
   freeing items	0.08 ms
   cleaning up	0.02 ms

   Call Stack

   #	Повикувач	Документ и број на линија
   6	JDatabaseDriverMysqli->execute()	JROOT\libraries\cms\application\cms.php:790
   5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
   4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
   3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:408
   2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
   1	JFactory::getApplication()	JROOT\index.php:46

   [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

   ---

3. Време на барање: 1.10 ms По последното барање: 0.34 ms Меморија по барање: 0.020 MB меморија по барањето: 2.167 MB Вратени редови: 0

   SELECT `session_id`
   
     FROM `og45h_session`
   
     WHERE `session_id` = '55jb6gnarfd1s90lbun42qsl4h' 
     LIMIT 1

   Објаснение

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

   Профил

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

   Call Stack

   #	Повикувач	Документ и број на линија
   8	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT\libraries\cms\application\cms.php:176
   6	JApplicationCms->checkSession()	JROOT\libraries\cms\application\cms.php:799
   5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
   4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
   3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:408
   2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
   1	JFactory::getApplication()	JROOT\index.php:46

   [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

   ---

4. Време на барање: 1.05 ms По последното барање: 0.30 ms Меморија по барање: 0.002 MB меморија по барањето: 2.170 MB

   INSERT INTO `og45h_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('55jb6gnarfd1s90lbun42qsl4h', 0, 1, '1574436917', 0, '')

   Објаснение

   Не е можно Објаснение за барањето: INSERT INTO `og45h_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('55jb6gnarfd1s90lbun42qsl4h', 0, 1, '1574436917', 0, '')

   Профил

   Status	Duration
   starting	0.08 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   update	0.10 ms
   Waiting for query cache lock	0.02 ms
   update	0.13 ms
   end	0.03 ms
   query end	0.06 ms
   closing tables	0.06 ms
   freeing items	0.04 ms
   cleaning up	0.01 ms

   Call Stack

   #	Повикувач	Документ и број на линија
   7	JDatabaseDriverMysqli->execute()	JROOT\libraries\cms\application\cms.php:212
   6	JApplicationCms->checkSession()	JROOT\libraries\cms\application\cms.php:799
   5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
   4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
   3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:408
   2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
   1	JFactory::getApplication()	JROOT\index.php:46

   [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

   ---

5. Време на барање: 3.37 ms По последното барање: 4.54 ms Меморија по барање: 0.025 MB меморија по барањето: 2.320 MB Вратени редови: 30

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `og45h_extensions`
   
     WHERE `type` = 'component'

   Објаснение

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	og45h_extensions	ref	extension	extension	62	const	30	100.00	Using index condition

   Профил

   Status	Duration
   starting	0.07 ms
   Waiting for query cache lock	0.02 ms
   init	0.01 ms
   checking query cache for query	0.06 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.04 ms
   System lock	0.02 ms
   Waiting for query cache lock	0.04 ms
   System lock	0.06 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.93 ms
   end	0.06 ms
   query end	0.02 ms
   closing tables	0.57 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.12 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.01 ms
   storing result in query cache	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Повикувач	Документ и број на линија
   9	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
   8	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\cache\controller\callback.php:152
   7	JCacheControllerCallback->get()	JROOT\libraries\cms\component\helper.php:448
   6	JComponentHelper::load()	JROOT\libraries\cms\component\helper.php:43
   5	JComponentHelper::getComponent()	JROOT\libraries\cms\component\helper.php:120
   4	JComponentHelper::getParams()	JROOT\libraries\cms\application\site.php:589
   3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
   1	JApplicationCms->execute()	JROOT\index.php:49

   [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

   ---

6. Време на барање: 1.26 ms По последното барање: 3.10 ms Меморија по барање: 0.021 MB меморија по барањето: 2.421 MB Вратени редови: 2

   SELECT b.id
   
     FROM og45h_usergroups AS a
   
     LEFT JOIN og45h_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Објаснение

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

   Профил

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

   Call Stack

   #	Повикувач	Документ и број на линија
   11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:835
   9	JAccess::getGroupsByUser()	JROOT\libraries\joomla\access\access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT\libraries\joomla\user\user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT\libraries\cms\plugin\helper.php:296
   6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
   5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
   4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:599
   3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
   1	JApplicationCms->execute()	JROOT\index.php:49

   [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

   ---

7. Време на барање: 1.00 ms По последното барање: 1.50 ms Меморија по барање: 0.021 MB меморија по барањето: 2.461 MB Вратени редови: 5

   SELECT id, rules
   
     FROM `og45h_viewlevels`

   Објаснение

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	og45h_viewlevels	ALL	NULL	НЕ МОЖЕ ДА СЕ КОРИСТИ КЛУЧ ЗА ИНДЕКСИРАЊЕ	NULL	NULL	5	100.00	NULL

   Профил

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

   Call Stack

   #	Повикувач	Документ и број на линија
   10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT\libraries\joomla\access\access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT\libraries\joomla\user\user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT\libraries\cms\plugin\helper.php:296
   6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
   5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
   4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:599
   3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
   1	JApplicationCms->execute()	JROOT\index.php:49

   [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

   ---

8. Време на барање: 8.13 ms По последното барање: 0.44 ms Меморија по барање: 0.023 MB меморија по барањето: 2.467 MB Вратени редови: 47

   SELECT folder AS type, element AS name, params
   
     FROM og45h_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Објаснение

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	og45h_extensions	ref	extension	extension	62	const	56	100.00	Using index condition; Using where; Користење сортирање на документи

   Профил

   Status	Duration
   starting	0.06 ms
   Waiting for query cache lock	0.01 ms
   init	0.01 ms
   checking query cache for query	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.05 ms
   System lock	0.02 ms
   Waiting for query cache lock	0.01 ms
   System lock	0.05 ms
   optimizing	0.05 ms
   statistics	0.09 ms
   preparing	0.04 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	6.54 ms
   end	0.04 ms
   query end	0.02 ms
   closing tables	0.23 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.08 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.01 ms
   storing result in query cache	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Повикувач	Документ и број на линија
   8	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\plugin\helper.php:310
   6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
   5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
   4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:599
   3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
   1	JApplicationCms->execute()	JROOT\index.php:49

   [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

   ---

9. Време на барање: 1.93 ms По последното барање: 21.70 ms Меморија по барање: 0.024 MB меморија по барањето: 2.955 MB Вратени редови: 2

   SELECT *
   
     FROM og45h_languages
   
     WHERE published=1
   
     ORDER BY ordering ASC

   Објаснение

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	og45h_languages	ALL	NULL	НЕ МОЖЕ ДА СЕ КОРИСТИ КЛУЧ ЗА ИНДЕКСИРАЊЕ	NULL	NULL	2	100.00	Using where; Користење сортирање на документи

   Профил

   Status	Duration
   starting	0.05 ms
   Waiting for query cache lock	0.01 ms
   init	0.01 ms
   checking query cache for query	0.05 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.05 ms
   System lock	0.04 ms
   Waiting for query cache lock	0.01 ms
   System lock	0.05 ms
   optimizing	0.02 ms
   statistics	0.02 ms
   preparing	0.02 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.03 ms
   Creating sort index	0.68 ms
   end	0.04 ms
   query end	0.02 ms
   closing tables	0.04 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.01 ms
   freeing items	0.05 ms
   storing result in query cache	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Повикувач	Документ и број на линија
   10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
   9	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\language\helper.php:164
   8	JLanguageHelper::getLanguages()	JROOT\plugins\system\languagefilter\languagefilter.php:97
   7	PlgSystemLanguageFilter->__construct()	JROOT\libraries\cms\plugin\helper.php:255
   6	JPluginHelper::import()	JROOT\libraries\cms\plugin\helper.php:170
   5	JPluginHelper::importPlugin()	JROOT\libraries\cms\application\cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:681
   3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
   1	JApplicationCms->execute()	JROOT\index.php:49

   [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

   ---

10. Време на барање: 1.13 ms По последното барање: 0.74 ms Меморија по барање: 0.020 MB меморија по барањето: 2.971 MB Вратени редови: 2

    SELECT element
    
      FROM og45h_extensions
    
      WHERE type = 'language' 
      AND client_id = 0 
      AND enabled = 1

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	og45h_extensions	ref	extension	extension	62	const	4	100.00	Using index condition; Using where

    Профил

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

    Call Stack

    #	Повикувач	Документ и број на линија
    10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
    9	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\language\multilang.php:90
    8	JLanguageMultilang::getSiteLangs()	JROOT\plugins\system\languagefilter\languagefilter.php:108
    7	PlgSystemLanguageFilter->__construct()	JROOT\libraries\cms\plugin\helper.php:255
    6	JPluginHelper::import()	JROOT\libraries\cms\plugin\helper.php:170
    5	JPluginHelper::importPlugin()	JROOT\libraries\cms\application\cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:681
    3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

11. Време на барање: 13.48 ms По последното барање: 13.09 ms Меморија по барање: 0.035 MB меморија по барањето: 3.348 MB Вратени редови: 16

    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 og45h_menu AS m
    
      LEFT JOIN og45h_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

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	16	100.00	Using index condition; Using where; Користење сортирање на документи
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	midkompj_tecneg.m.component_id	1	100.00	Using where

    Профил

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.02 ms
    init	0.01 ms
    checking query cache for query	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.06 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.06 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.06 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	11.82 ms
    end	0.09 ms
    query end	0.03 ms
    closing tables	0.12 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.07 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.02 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\menu\site.php:86
    18	JMenuSite->load()	JROOT\libraries\cms\menu\menu.php:74
    17	JMenu->__construct()	JROOT\libraries\cms\menu\site.php:57
    16	JMenuSite->__construct()	JROOT\libraries\cms\menu\menu.php:145
    15	JMenu::getInstance()	JROOT\libraries\cms\application\cms.php:439
    14	JApplicationCms->getMenu()	JROOT\libraries\cms\application\site.php:272
    13	JApplicationSite->getMenu()	JROOT\libraries\cms\router\site.php:57
    12	JRouterSite->__construct()	JROOT\libraries\cms\router\router.php:197
    11	JRouter::getInstance()	JROOT\libraries\cms\application\cms.php:535
    10	JApplicationCms::getRouter()	JROOT\libraries\cms\application\site.php:407
    9	JApplicationSite::getRouter()	JROOT\plugins\system\languagefilter\languagefilter.php:130
    8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:69
    7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:681
    3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

12. Време на барање: 1.78 ms По последното барање: 19.43 ms Меморија по барање: 0.022 MB меморија по барањето: 3.824 MB Вратени редови: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `og45h_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Објаснение

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

    Профил

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

    Call Stack

    #	Повикувач	Документ и број на линија
    13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1650
    12	JDatabaseDriver->loadObject()	JROOT\libraries\joomla\cache\controller\callback.php:152
    11	JCacheControllerCallback->get()	JROOT\libraries\cms\library\helper.php:156
    10	JLibraryHelper::_load()	JROOT\libraries\cms\library\helper.php:47
    9	JLibraryHelper::getLibrary()	JROOT\libraries\cms\library\helper.php:90
    8	JLibraryHelper::getParams()	JROOT\libraries\cms\version\version.php:274
    7	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:755
    6	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
    5	JFactory::getDocument()	JROOT\libraries\joomla\application\web.php:977
    4	JApplicationWeb->loadDocument()	JROOT\libraries\cms\application\site.php:130
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

13. Време на барање: 1.29 ms По последното барање: 0.52 ms Меморија по барање: 0.003 MB меморија по барањето: 3.813 MB

    UPDATE `og45h_extensions`
    
      SET `params` = '{\"mediaversion\":\"2b7e227f4862b1485fe310a9b5fdaed9\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Објаснение

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

    Профил

    Status	Duration
    starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.11 ms
    updating	0.19 ms
    end	0.03 ms
    Waiting for query cache lock	0.01 ms
    end	0.09 ms
    query end	0.10 ms
    closing tables	0.08 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    10	JDatabaseDriverMysqli->execute()	JROOT\libraries\cms\library\helper.php:119
    9	JLibraryHelper::saveParams()	JROOT\libraries\cms\version\version.php:325
    8	JVersion->setMediaVersion()	JROOT\libraries\cms\version\version.php:284
    7	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:755
    6	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
    5	JFactory::getDocument()	JROOT\libraries\joomla\application\web.php:977
    4	JApplicationWeb->loadDocument()	JROOT\libraries\cms\application\site.php:130
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

14. Време на барање: 3.49 ms По последното барање: 5.49 ms Меморија по барање: 0.030 MB меморија по барањето: 3.944 MB Вратени редови: 4

    SELECT id, home, template, s.params
    
      FROM og45h_template_styles as s
    
      LEFT JOIN og45h_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

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ALL	idx_template	НЕ МОЖЕ ДА СЕ КОРИСТИ КЛУЧ ЗА ИНДЕКСИРАЊЕ	NULL	NULL	6	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	midkompj_tecneg.s.template,const	1	100.00	Using index condition; Using where

    Профил

    Status	Duration
    starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.05 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.05 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	1.87 ms
    end	0.04 ms
    query end	0.02 ms
    closing tables	0.05 ms
    freeing items	0.08 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.01 ms
    storing result in query cache	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    6	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
    5	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\application\site.php:484
    4	JApplicationSite->getTemplate()	JROOT\libraries\cms\application\site.php:165
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

15. Време на барање: 5.78 ms По последното барање: 37.12 ms Меморија по барање: 0.028 MB меморија по барањето: 4.691 MB Вратени редови: 8

    SHOW FULL COLUMNS 
      FROM `og45h_assets`

    Објаснение

    Не е можно Објаснение за барањето: SHOW FULL COLUMNS FROM `og45h_assets`

    Профил

    Status	Duration
    starting	0.12 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	2.77 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.02 ms
    Opening tables	0.08 ms
    checking permissions	0.17 ms
    checking permissions	0.09 ms
    checking permissions	0.04 ms
    checking permissions	0.10 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Sending data	0.10 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	1.27 ms
    closing tables	0.06 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    24	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:241
    21	JTable->getFields()	JROOT\libraries\joomla\table\table.php:162
    20	JTable->__construct()	JROOT\libraries\joomla\table\asset.php:60
    19	JTableAsset->__construct()	JROOT\libraries\joomla\table\table.php:308
    18	JTable::getInstance()	JROOT\libraries\joomla\access\access.php:696
    17	JAccess::getExtensionNameFromAsset()	JROOT\libraries\joomla\access\access.php:555
    16	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
    15	JUser->authorise()	JROOT\components\com_content\models\category.php:142
    14	ContentModelCategory->populateState()	JROOT\libraries\legacy\model\legacy.php:435
    13	JModelLegacy->getState()	JROOT\libraries\legacy\view\legacy.php:408
    12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:114
    11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
    10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
    9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
    8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
    7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
    6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

16. Време на барање: 1.14 ms По последното барање: 4.76 ms Меморија по барање: 0.025 MB меморија по барањето: 4.723 MB Вратени редови: 1

    SELECT *
    
      FROM og45h_assets
    
      WHERE `id` = '1'

    Објаснение

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

    Профил

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

    Call Stack

    #	Повикувач	Документ и број на линија
    20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1453
    19	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:719
    18	JTable->load()	JROOT\libraries\joomla\access\access.php:697
    17	JAccess::getExtensionNameFromAsset()	JROOT\libraries\joomla\access\access.php:555
    16	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
    15	JUser->authorise()	JROOT\components\com_content\models\category.php:142
    14	ContentModelCategory->populateState()	JROOT\libraries\legacy\model\legacy.php:435
    13	JModelLegacy->getState()	JROOT\libraries\legacy\view\legacy.php:408
    12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:114
    11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
    10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
    9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
    8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
    7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
    6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

17. Време на барање: 2.00 ms По последното барање: 0.51 ms Меморија по барање: 0.024 MB меморија по барањето: 4.729 MB Вратени редови: 1

    SELECT a.rules
    
      FROM og45h_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,152	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

    Профил

    Status	Duration
    starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    checking query cache for query	0.08 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.05 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.07 ms
    executing	0.03 ms
    Sending data	0.72 ms
    end	0.05 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1538
    17	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:652
    16	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
    15	JUser->authorise()	JROOT\components\com_content\models\category.php:142
    14	ContentModelCategory->populateState()	JROOT\libraries\legacy\model\legacy.php:435
    13	JModelLegacy->getState()	JROOT\libraries\legacy\view\legacy.php:408
    12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:114
    11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
    10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
    9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
    8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
    7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
    6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

18. Време на барање: 1.37 ms По последното барање: 2.90 ms Меморија по барање: 0.025 MB меморија по барањето: 4.752 MB Вратени редови: 19

    SELECT a.id, a.parent_id
    
      FROM og45h_assets AS a
    
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	НЕ МОЖЕ ДА СЕ КОРИСТИ КЛУЧ ЗА ИНДЕКСИРАЊЕ	NULL	NULL	81	100.00	Using where

    Профил

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

    Call Stack

    #	Повикувач	Документ и број на линија
    20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\access\access.php:332
    18	JAccess::preloadPermissionsParentIdMapping()	JROOT\libraries\joomla\access\access.php:240
    17	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
    16	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
    15	JUser->authorise()	JROOT\components\com_content\models\category.php:142
    14	ContentModelCategory->populateState()	JROOT\libraries\legacy\model\legacy.php:435
    13	JModelLegacy->getState()	JROOT\libraries\legacy\view\legacy.php:408
    12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:114
    11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
    10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
    9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
    8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
    7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
    6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

19. Време на барање: 1.32 ms По последното барање: 5.32 ms Меморија по барање: 0.025 MB меморија по барањето: 4.777 MB Вратени редови: 19

    SELECT a.id, a.name, a.rules
    
      FROM og45h_assets AS a
    
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	НЕ МОЖЕ ДА СЕ КОРИСТИ КЛУЧ ЗА ИНДЕКСИРАЊЕ	NULL	NULL	81	100.00	Using where

    Профил

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.04 ms
    optimizing	0.03 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.20 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.08 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1255
    19	JDatabaseDriver->getIterator()	JROOT\libraries\joomla\access\access.php:373
    18	JAccess::preloadPermissions()	JROOT\libraries\joomla\access\access.php:243
    17	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
    16	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
    15	JUser->authorise()	JROOT\components\com_content\models\category.php:142
    14	ContentModelCategory->populateState()	JROOT\libraries\legacy\model\legacy.php:435
    13	JModelLegacy->getState()	JROOT\libraries\legacy\view\legacy.php:408
    12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:114
    11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
    10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
    9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
    8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
    7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
    6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

20. Време на барање: 11.73 ms По последното барање: 3.51 ms Меморија по барање: 0.029 MB меморија по барањето: 4.860 MB Вратени редови: 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,COUNT(i.`id`) AS numitems
    
      FROM og45h_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM og45h_categories AS cat JOIN og45h_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN og45h_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('mk-MK','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      LEFT JOIN `og45h_content` AS i 
      ON i.`catid` = c.id 
      AND i.state = 1 
      AND (i.language = '*' OR i.language = 'mk-MK')
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=10
    
      GROUP BY 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
    
      ORDER BY c.lft

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Користење сортирање на документи
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	НЕ МОЖЕ ДА СЕ КОРИСТИ КЛУЧ ЗА ИНДЕКСИРАЊЕ	NULL	NULL	9	77.78	Using where
    1	PRIMARY	i	ref	idx_state,idx_catid,idx_language	idx_catid	4	midkompj_tecneg.c.id	2	100.00	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	midkompj_tecneg.c.id	2	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Користење сортирање на документи
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	9	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Профил

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.28 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.21 ms
    init	0.20 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.34 ms
    optimizing	0.03 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.46 ms
    Creating tmp table	0.13 ms
    Sorting result	0.06 ms
    statistics	0.53 ms
    preparing	0.47 ms
    Creating tmp table	0.42 ms
    Sorting result	0.04 ms
    executing	0.03 ms
    Sending data	0.19 ms
    executing	0.03 ms
    Sending data	0.06 ms
    Creating sort index	0.51 ms
    removing tmp table	0.04 ms
    Creating sort index	4.09 ms
    Creating sort index	0.46 ms
    end	0.04 ms
    removing tmp table	1.40 ms
    end	0.04 ms
    query end	0.02 ms
    closing tables	0.01 ms
    removing tmp table	0.02 ms
    closing tables	0.37 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.26 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:309
    15	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
    14	JCategories->get()	JROOT\components\com_content\models\category.php:354
    13	ContentModelCategory->getCategory()	JROOT\libraries\legacy\view\legacy.php:408
    12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:115
    11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
    10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
    9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
    8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
    7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
    6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

21. Време на барање: 1.44 ms По последното барање: 7.43 ms Меморија по барање: 0.025 MB меморија по барањето: 4.963 MB Вратени редови: 30

    SELECT element
    
      FROM og45h_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	og45h_extensions	ref	extension	extension	62	const	30	100.00	Using index condition; Using where

    Профил

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

    Call Stack

    #	Повикувач	Документ и број на линија
    23	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1538
    22	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:413
    21	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:213
    20	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
    19	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
    18	JUser->authorise()	JROOT\components\com_content\models\articles.php:466
    17	ContentModelArticles->getListQuery()	JROOT\libraries\legacy\model\list.php:129
    16	JModelList->_getListQuery()	JROOT\libraries\legacy\model\list.php:183
    15	JModelList->getItems()	JROOT\components\com_content\models\articles.php:565
    14	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
    13	ContentModelCategory->getItems()	JROOT\libraries\legacy\view\legacy.php:408
    12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:128
    11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
    10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
    9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
    8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
    7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
    6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

22. Време на барање: 1.92 ms По последното барање: 0.56 ms Меморија по барање: 0.026 MB меморија по барањето: 4.974 MB Вратени редови: 30

    SELECT a.name, a.rules
    
      FROM og45h_assets AS a
    
      WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') OR a.name = 'root.1')

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ALL	idx_asset_name	НЕ МОЖЕ ДА СЕ КОРИСТИ КЛУЧ ЗА ИНДЕКСИРАЊЕ	NULL	NULL	81	38.27	Using where

    Профил

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.10 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.23 ms
    optimizing	0.05 ms
    statistics	0.19 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.32 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    23	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1494
    22	JDatabaseDriver->loadAssocList()	JROOT\libraries\joomla\access\access.php:441
    21	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:213
    20	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
    19	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
    18	JUser->authorise()	JROOT\components\com_content\models\articles.php:466
    17	ContentModelArticles->getListQuery()	JROOT\libraries\legacy\model\list.php:129
    16	JModelList->_getListQuery()	JROOT\libraries\legacy\model\list.php:183
    15	JModelList->getItems()	JROOT\components\com_content\models\articles.php:565
    14	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
    13	ContentModelCategory->getItems()	JROOT\libraries\legacy\view\legacy.php:408
    12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:128
    11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
    10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
    9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
    8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
    7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
    6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

23. Време на барање: 5.58 ms По последното барање: 3.07 ms Меморија по барање: 0.031 MB меморија по барањето: 5.094 MB Вратени редови: 0

    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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
    
      FROM og45h_content AS a
    
      LEFT JOIN og45h_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN og45h_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN og45h_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN og45h_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN og45h_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM og45h_categories AS cat JOIN og45h_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid = 10 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-11-22 15:35:17') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-11-22 15:35:17') 
      AND a.language in ('mk-MK','*')
    
      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   
      LIMIT 9

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Користење сортирање на документи
    1	PRIMARY	a	ref	idx_access,idx_catid,idx_language	idx_catid	4	const	1	100.00	Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	midkompj_tecneg.a.created_by	1	100.00	Using where
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	midkompj_tecneg.a.modified_by	1	100.00	Using where
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	midkompj_tecneg.a.id	1	100.00	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	Using where; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Користење сортирање на документи
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	9	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Профил

    Status	Duration
    starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.31 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.20 ms
    init	0.23 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.11 ms
    optimizing	0.01 ms
    optimizing	0.03 ms
    statistics	0.39 ms
    preparing	0.46 ms
    Creating tmp table	0.13 ms
    Sorting result	0.06 ms
    statistics	0.42 ms
    preparing	0.38 ms
    Sorting result	0.08 ms
    executing	0.03 ms
    Sending data	0.07 ms
    Creating sort index	0.75 ms
    end	0.52 ms
    removing tmp table	0.04 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    removing tmp table	0.02 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.86 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT\libraries\legacy\model\legacy.php:310
    16	JModelLegacy->_getList()	JROOT\libraries\legacy\model\list.php:183
    15	JModelList->getItems()	JROOT\components\com_content\models\articles.php:565
    14	ContentModelArticles->getItems()	JROOT\components\com_content\models\category.php:253
    13	ContentModelCategory->getItems()	JROOT\libraries\legacy\view\legacy.php:408
    12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:128
    11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
    10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
    9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
    8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
    7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
    6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

24. Време на барање: 6.51 ms По последното барање: 3.62 ms Меморија по барање: 0.023 MB меморија по барањето: 5.182 MB Вратени редови: 1

    SELECT COUNT(*)
    
      FROM og45h_content AS a
    
      LEFT JOIN og45h_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN og45h_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN og45h_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN og45h_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN og45h_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM og45h_categories AS cat JOIN og45h_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid = 10 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-11-22 15:35:17') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-11-22 15:35:17') 
      AND a.language in ('mk-MK','*')

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	a	ref	idx_access,idx_catid,idx_language	idx_catid	4	const	1	100.00	Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	midkompj_tecneg.a.created_by	1	100.00	Using where; Using index
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	midkompj_tecneg.a.modified_by	1	100.00	Using where; Using index
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	midkompj_tecneg.a.id	1	100.00	Using where; Using index
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	Using where; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Користење сортирање на документи
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	9	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Профил

    Status	Duration
    starting	0.07 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    checking query cache for query	0.18 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.18 ms
    init	0.10 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.08 ms
    optimizing	0.01 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.37 ms
    Creating tmp table	0.13 ms
    Sorting result	0.06 ms
    statistics	0.64 ms
    preparing	0.09 ms
    executing	0.03 ms
    Sending data	0.05 ms
    end	0.28 ms
    removing tmp table	0.04 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    removing tmp table	0.02 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.30 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1728
    17	JDatabaseDriver->loadResult()	JROOT\libraries\legacy\model\legacy.php:337
    16	JModelLegacy->_getListCount()	JROOT\libraries\legacy\model\list.php:278
    15	JModelList->getTotal()	JROOT\libraries\legacy\model\list.php:228
    14	JModelList->getPagination()	JROOT\components\com_content\models\category.php:265
    13	ContentModelCategory->getItems()	JROOT\libraries\legacy\view\legacy.php:408
    12	JViewLegacy->get()	JROOT\libraries\legacy\view\category.php:128
    11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
    10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
    9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
    8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
    7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
    6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

25. Време на барање: 1.48 ms По последното барање: 8.35 ms Меморија по барање: 0.027 MB меморија по барањето: 5.278 MB Вратени редови: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `og45h_contentitem_tag_map` AS m 
    
      INNER JOIN `og45h_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 10 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_tag_type	НЕ МОЖЕ ДА СЕ КОРИСТИ КЛУЧ ЗА ИНДЕКСИРАЊЕ	NULL	NULL	1	100.00	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	midkompj_tecneg.m.tag_id	1	100.00	Using where

    Профил

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

    Call Stack

    #	Повикувач	Документ и број на линија
    14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\helper\tags.php:435
    12	JHelperTags->getItemTags()	JROOT\libraries\legacy\view\category.php:217
    11	JViewCategory->commonCategoryDisplay()	JROOT\components\com_content\views\category\view.html.php:72
    10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
    9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
    8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
    7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
    6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

26. Време на барање: 2.49 ms По последното барање: 52.07 ms Меморија по барање: 0.024 MB меморија по барањето: 5.509 MB Вратени редови: 1
    Двојни барања: #27

    SELECT params
    
      FROM og45h_template_styles
    
      WHERE id = 10 
      AND client_id = 0

    Објаснение

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

    Профил

    Status	Duration
    starting	0.09 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.06 ms
    checking permissions	0.05 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.05 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.07 ms
    executing	0.02 ms
    Sending data	0.24 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1728
    17	JDatabaseDriver->loadResult()	JROOT\templates\dd_engineer_99\functions.php:883
    16	getCurrentTemplateByType()	JROOT\templates\dd_engineer_99\functions.php:900
    15	require_once JROOT\templates\dd_engineer_99\functions.php	JROOT\templates\dd_engineer_99\html\com_content\category\blog.php:6
    14	include JROOT\templates\dd_engineer_99\html\com_content\category\blog.php	JROOT\libraries\legacy\view\legacy.php:677
    13	JViewLegacy->loadTemplate()	JROOT\libraries\legacy\view\legacy.php:216
    12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
    11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
    10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
    9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
    8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
    7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
    6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

27. Време на барање: 1.60 ms По последното барање: 8.21 ms Меморија по барање: 0.023 MB меморија по барањето: 5.635 MB Вратени редови: 1
    Двојни барања: #26

    SELECT params
    
      FROM og45h_template_styles
    
      WHERE id = 10 
      AND client_id = 0

    Објаснение

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

    Профил

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.01 ms
    checking permissions	0.02 ms
    sending cached result to clien	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1728
    16	JDatabaseDriver->loadResult()	JROOT\templates\dd_engineer_99\functions.php:883
    15	getCurrentTemplateByType()	JROOT\templates\dd_engineer_99\html\com_content\category\blog.php:9
    14	include JROOT\templates\dd_engineer_99\html\com_content\category\blog.php	JROOT\libraries\legacy\view\legacy.php:677
    13	JViewLegacy->loadTemplate()	JROOT\libraries\legacy\view\legacy.php:216
    12	JViewLegacy->display()	JROOT\libraries\legacy\view\category.php:233
    11	JViewCategory->display()	JROOT\components\com_content\views\category\view.html.php:258
    10	ContentViewCategory->display()	JROOT\libraries\legacy\controller\legacy.php:664
    9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
    8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:702
    7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:38
    6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:405
    5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
    4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

28. Време на барање: 2.38 ms По последното барање: 606.86 ms Меморија по барање: 0.021 MB меморија по барањето: 5.605 MB Вратени редови: 3

    SELECT language,id
    
      FROM `og45h_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	og45h_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	17	100.00	Using where

    Профил

    Status	Duration
    starting	0.10 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.05 ms
    optimizing	0.03 ms
    statistics	0.09 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sending data	0.13 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
    9	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\language\multilang.php:121
    8	JLanguageMultilang::getSiteHomePages()	JROOT\plugins\system\languagefilter\languagefilter.php:697
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT\libraries\joomla\event\event.php:69
    6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\site.php:196
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

29. Време на барање: 1.35 ms По последното барање: 3.85 ms Меморија по барање: 0.021 MB меморија по барањето: 5.649 MB Вратени редови: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `og45h_menu` AS `c`
    
      INNER JOIN `og45h_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `og45h_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `og45h_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 110

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	НЕ МОЖЕ ДА СЕ КОРИСТИ КЛУЧ ЗА ИНДЕКСИРАЊЕ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Профил

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.05 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.06 ms
    optimizing	0.03 ms
    statistics	0.12 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
    10	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\language\associations.php:101
    9	JLanguageAssociations::getAssociations()	JROOT\administrator\components\com_menus\helpers\menus.php:284
    8	MenusHelper::getAssociations()	JROOT\plugins\system\languagefilter\languagefilter.php:714
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT\libraries\joomla\event\event.php:69
    6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\site.php:196
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

30. Време на барање: 1.65 ms По последното барање: 36.42 ms Меморија по барање: 0.021 MB меморија по барањето: 5.735 MB Вратени редови: 0

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`
    
      FROM `og45h_categories` AS `c`
    
      INNER JOIN `og45h_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_categories.item'
    
      INNER JOIN `og45h_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `og45h_categories` AS `c2` 
      ON a2.id = c2.`id` 
      AND c2.extension = 'com_content'
    
      WHERE c.id = 10 
      AND c.extension = 'com_content'

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	НЕ МОЖЕ ДА СЕ КОРИСТИ КЛУЧ ЗА ИНДЕКСИРАЊЕ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Профил

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.06 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.21 ms
    optimizing	0.05 ms
    statistics	0.15 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.04 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
    12	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\language\associations.php:101
    11	JLanguageAssociations::getAssociations()	JROOT\administrator\components\com_categories\helpers\categories.php:102
    10	CategoriesHelper::getAssociations()	JROOT\administrator\components\com_categories\helpers\association.php:43
    9	CategoryHelperAssociation::getCategoryAssociations()	JROOT\components\com_content\helpers\association.php:58
    8	ContentHelperAssociation::getAssociations()	JROOT\plugins\system\languagefilter\languagefilter.php:729
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT\libraries\joomla\event\event.php:69
    6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
    4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\site.php:196
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---

31. Време на барање: 3.47 ms По последното барање: 573.56 ms Меморија по барање: 0.026 MB меморија по барањето: 6.283 MB Вратени редови: 5

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM og45h_modules AS m
    
      LEFT JOIN og45h_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN og45h_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 <= '2019-11-22 15:35:17') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-11-22 15:35:17') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 110 OR mm.menuid <= 0) 
      AND m.language IN ('mk-MK','*')
    
      ORDER BY m.position, m.ordering

    Објаснение

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	8	100.00	Using index condition; Using where; Користење сортирање на документи
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	midkompj_tecneg.m.id	1	100.00	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	midkompj_tecneg.m.module,const	1	100.00	Using index condition; Using where

    Профил

    Status	Duration
    starting	0.11 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    checking query cache for query	0.25 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    init	0.11 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.01 ms
    System lock	0.07 ms
    optimizing	0.06 ms
    statistics	0.20 ms
    preparing	0.08 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	1.44 ms
    end	0.09 ms
    query end	0.02 ms
    closing tables	0.07 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.01 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.01 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Повикувач	Документ и број на линија
    19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\cache\controller\callback.php:152
    17	JCacheControllerCallback->get()	JROOT\libraries\cms\module\helper.php:425
    16	JModuleHelper::getModuleList()	JROOT\libraries\cms\module\helper.php:361
    15	JModuleHelper::load()	JROOT\libraries\cms\module\helper.php:84
    14	JModuleHelper::getModules()	JROOT\libraries\joomla\document\html.php:501
    13	JDocumentHtml->countModules()	JROOT\templates\dd_engineer_99\library\Designer\Page.php:89
    12	DesignerPage->containsModules()	JROOT\templates\dd_engineer_99\includes\hmenu_1.php:4
    11	hmenu_1()	JROOT\templates\dd_engineer_99\functions.php:99
    10	renderTemplateFromIncludes()	JROOT\templates\dd_engineer_99\templates\blog_5.php:197
    9	include_once JROOT\templates\dd_engineer_99\templates\blog_5.php	JROOT\templates\dd_engineer_99\library\Designer\Page.php:107
    8	DesignerPage->renderTemplate()	JROOT\templates\dd_engineer_99\index.php:24
    7	require JROOT\templates\dd_engineer_99\index.php	JROOT\libraries\joomla\document\html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT\libraries\joomla\document\html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT\libraries\joomla\document\html.php:455
    4	JDocumentHtml->parse()	JROOT\libraries\cms\application\cms.php:1072
    3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:773
    2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:267
    1	JApplicationCms->execute()	JROOT\index.php:49

    [Додадете xdebug.file_link_format линија во вашиот php.ini документ за да имате врски до документите]

    ---