Joomla! Debug конзола

Сесија

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

Информација за профил

Време

Меморија

Време: 39.76 ms / 39.76 ms Меморија: 0.440 MB / 0.81 MB Application: afterLoad

Време: 5889.66 ms / 5929.42 ms Меморија: 2.703 MB / 3.51 MB Application: afterInitialise

Време: 15.03 ms / 5944.45 ms Меморија: 0.282 MB / 3.79 MB Application: afterRoute

Време: 660.20 ms / 6604.65 ms Меморија: 0.179 MB / 3.97 MB Application: beforeRenderComponent com_content

Време: 273.49 ms / 6878.14 ms Меморија: 0.755 MB / 4.72 MB Application: Start JAccess::getAssetRules Old (1)

Време: 3.28 ms / 6881.42 ms Меморија: 0.026 MB / 4.75 MB Application: Finish JAccess::getAssetRules Old (1)

Време: 0.09 ms / 6881.51 ms Меморија: 0.000 MB / 4.75 MB Application: New JAccess Preloading Process(com_content.category)

Време: 1.99 ms / 6883.49 ms Меморија: 0.017 MB / 4.76 MB Application: After preloadPermissionsParentIdMapping (com_content.category)

Време: 7.26 ms / 6890.75 ms Меморија: 0.029 MB / 4.79 MB Application: After preloadPermissions (com_content.category)

Време: 0.04 ms / 6890.79 ms Меморија: 0.001 MB / 4.79 MB Application: End New JAccess Preloading Process(com_content.category)

Време: 0.04 ms / 6890.83 ms Меморија: 0.001 MB / 4.80 MB Application: Start JAccess::getAssetRules New (com_content.category.10)

Време: 0.14 ms / 6890.98 ms Меморија: 0.005 MB / 4.80 MB Application: Finish JAccess::getAssetRules New (com_content.category.10)

Време: 1251.42 ms / 8142.39 ms Меморија: 0.162 MB / 4.96 MB Application: Start JAccess::preload(components)

Време: 4.63 ms / 8147.02 ms Меморија: 0.128 MB / 5.09 MB Application: Finish JAccess::preload(components)

Време: 1142.96 ms / 9289.98 ms Меморија: 0.510 MB / 5.60 MB Application: afterRenderComponent com_content

Време: 24.15 ms / 9314.12 ms Меморија: 0.414 MB / 6.02 MB Application: afterDispatch

Време: 928.88 ms / 10243.00 ms Меморија: 0.313 MB / 6.33 MB Application: beforeRenderModule mod_menu (Main Menu)

Време: 22.12 ms / 10265.12 ms Меморија: 0.082 MB / 6.41 MB Application: afterRenderModule mod_menu (Main Menu)

Време: 5.00 ms / 10270.12 ms Меморија: 0.079 MB / 6.49 MB Application: afterRender

Вкупно барања кон база: 8567.67 ms

Искористеност на меморија

Барања до базата

30 забележани барања 8567.67 ms

2 најдени двојници!

2 двојници: #25 #26

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

SELECT `data`

  FROM `og45h_session`

  WHERE `session_id` = '4d37u7bu03g4tbmt0975vbmcr8'

Објаснение

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.11 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.06 ms
optimizing	0.02 ms
statistics	0.06 ms
executing	0.03 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.02 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 документ за да имате врски до документите]

Време на барање: 1.24 ms По последното барање: 9.40 ms Меморија по барање: 0.020 MB меморија по барањето: 2.163 MB Вратени редови: 0

SELECT `session_id`

  FROM `og45h_session`

  WHERE `session_id` = '4d37u7bu03g4tbmt0975vbmcr8' 
  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.08 ms
Waiting for query cache lock	0.02 ms
init	0.02 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.06 ms
executing	0.03 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.02 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 документ за да имате врски до документите]

Време на барање: 1.28 ms По последното барање: 0.30 ms Меморија по барање: 0.002 MB меморија по барањето: 2.167 MB

INSERT INTO `og45h_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('4d37u7bu03g4tbmt0975vbmcr8', 0, 1, '1563699510', 0, '')

Објаснение

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

Профил

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
update	0.15 ms
Waiting for query cache lock	0.02 ms
update	0.04 ms
end	0.02 ms
query end	0.08 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 1702.16 ms По последното барање: 10.29 ms Меморија по барање: 0.025 MB меморија по барањето: 2.318 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.07 ms
checking permissions	0.02 ms
Opening tables	0.04 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.09 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	1699.47 ms
end	0.11 ms
query end	0.03 ms
closing tables	0.18 ms
freeing items	0.04 ms
Waiting for query cache lock	0.02 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.02 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 0.88 ms По последното барање: 5.23 ms Меморија по барање: 0.021 MB меморија по барањето: 2.419 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.06 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 0.75 ms По последното барање: 3.02 ms Меморија по барање: 0.021 MB меморија по барањето: 2.459 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.06 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 2653.63 ms По последното барање: 0.47 ms Меморија по барање: 0.023 MB меморија по барањето: 2.465 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.02 ms
init	0.02 ms
checking query cache for query	0.13 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
init	0.08 ms
System lock	0.04 ms
Waiting for query cache lock	0.02 ms
System lock	0.07 ms
optimizing	0.06 ms
statistics	0.15 ms
preparing	0.09 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	2651.14 ms
end	0.10 ms
query end	0.02 ms
closing tables	0.18 ms
freeing items	0.05 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.02 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 документ за да имате врски до документите]

Време на барање: 0.97 ms По последното барање: 24.29 ms Меморија по барање: 0.024 MB меморија по барањето: 2.952 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.08 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.05 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 1.81 ms По последното барање: 1.31 ms Меморија по барање: 0.021 MB меморија по барањето: 2.969 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.02 ms
init	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.02 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.04 ms
statistics	0.11 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.08 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.02 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 1136.96 ms По последното барање: 23.99 ms Меморија по барање: 0.035 MB меморија по барањето: 3.346 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.10 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.13 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.07 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.07 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.06 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	1095.39 ms
end	0.10 ms
query end	0.02 ms
closing tables	39.39 ms
freeing items	0.18 ms
Waiting for query cache lock	0.06 ms
freeing items	0.13 ms
Waiting for query cache lock	0.04 ms
freeing items	0.02 ms
storing result in query cache	0.05 ms
cleaning up	0.03 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 документ за да имате врски до документите]

Време на барање: 41.27 ms По последното барање: 20.44 ms Меморија по барање: 0.022 MB меморија по барањето: 3.822 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.09 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.09 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.06 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.08 ms
optimizing	0.07 ms
statistics	0.27 ms
preparing	0.07 ms
executing	0.02 ms
Sending data	0.27 ms
end	0.04 ms
query end	0.02 ms
closing tables	38.89 ms
freeing items	0.11 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.03 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 116.67 ms По последното барање: 0.67 ms Меморија по барање: 0.003 MB меморија по барањето: 3.811 MB

UPDATE `og45h_extensions`

  SET `params` = '{\"mediaversion\":\"4be73c27661f9075fdfe97062f13481f\"}'

  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.10 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.15 ms
updating	40.38 ms
end	0.10 ms
Waiting for query cache lock	0.02 ms
end	0.49 ms
query end	0.15 ms
closing tables	74.40 ms
freeing items	0.14 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 документ за да имате врски до документите]

Време на барање: 489.46 ms По последното барање: 6.30 ms Меморија по барање: 0.030 MB меморија по барањето: 3.942 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.08 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.12 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.07 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.07 ms
optimizing	0.05 ms
statistics	0.14 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	450.23 ms
end	0.11 ms
query end	0.03 ms
closing tables	37.28 ms
freeing items	0.10 ms
Waiting for query cache lock	0.02 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.02 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 159.42 ms По последното барање: 111.80 ms Меморија по барање: 0.028 MB меморија по барањето: 4.689 MB Вратени редови: 8

SHOW FULL COLUMNS 
  FROM `og45h_assets`

Објаснение

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

Профил

Status	Duration
starting	40.28 ms
checking permissions	0.16 ms
checking permissions	0.05 ms
Opening tables	3.71 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.03 ms
Opening tables	0.07 ms
checking permissions	0.25 ms
checking permissions	0.18 ms
checking permissions	0.07 ms
checking permissions	0.12 ms
checking permissions	0.08 ms
checking permissions	0.08 ms
checking permissions	0.07 ms
checking permissions	0.09 ms
Sending data	73.54 ms
end	0.15 ms
query end	0.05 ms
closing tables	0.02 ms
removing tmp table	39.30 ms
closing tables	0.10 ms
freeing items	0.06 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 документ за да имате врски до документите]

Време на барање: 2.75 ms По последното барање: 3.72 ms Меморија по барање: 0.025 MB меморија по барањето: 4.720 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.02 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.07 ms
checking permissions	0.02 ms
sending cached result to clien	0.05 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 0.70 ms По последното барање: 0.37 ms Меморија по барање: 0.023 MB меморија по барањето: 4.726 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.05 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 1.62 ms По последното барање: 2.69 ms Меморија по барање: 0.025 MB меморија по барањето: 4.750 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.02 ms
init	0.01 ms
checking query cache for query	0.08 ms
checking permissions	0.02 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.12 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.32 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.03 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.02 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 документ за да имате врски до документите]

Време на барање: 1.50 ms По последното барање: 5.64 ms Меморија по барање: 0.025 MB меморија по барањето: 4.775 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.02 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.03 ms
statistics	0.10 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.19 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.02 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 1186.90 ms По последното барање: 6.12 ms Меморија по барање: 0.029 MB меморија по барањето: 4.858 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	1	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.08 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.37 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.25 ms
init	0.24 ms
System lock	0.04 ms
Waiting for query cache lock	0.02 ms
System lock	0.15 ms
optimizing	0.02 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.96 ms
Creating tmp table	0.14 ms
Sorting result	0.07 ms
statistics	160.68 ms
preparing	205.03 ms
Creating tmp table	0.75 ms
Sorting result	0.05 ms
executing	0.03 ms
Sending data	0.35 ms
executing	0.04 ms
Sending data	0.07 ms
Creating sort index	1.84 ms
removing tmp table	0.05 ms
Creating sort index	531.39 ms
Creating sort index	119.85 ms
end	0.10 ms
removing tmp table	162.78 ms
end	0.11 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.03 ms
closing tables	0.22 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.55 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 документ за да имате врски до документите]

Време на барање: 1.70 ms По последното барање: 59.09 ms Меморија по барање: 0.025 MB меморија по барањето: 4.961 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.09 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.06 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.06 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.22 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.04 ms
storing result in query cache	0.02 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 0.85 ms По последното барање: 0.37 ms Меморија по барање: 0.026 MB меморија по барањето: 4.971 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.02 ms
init	0.02 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.06 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 393.03 ms По последното барање: 2.24 ms Меморија по барање: 0.031 MB меморија по барањето: 5.092 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-07-21 08:58:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-07-21 08:58:38') 
  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.05 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.34 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.02 ms
Opening tables	0.30 ms
init	0.20 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.33 ms
optimizing	0.03 ms
optimizing	0.03 ms
statistics	158.44 ms
preparing	35.00 ms
Creating tmp table	0.21 ms
Sorting result	0.10 ms
statistics	0.61 ms
preparing	41.47 ms
Sorting result	0.09 ms
executing	0.03 ms
Sending data	0.09 ms
Creating sort index	153.66 ms
end	0.74 ms
removing tmp table	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.03 ms
closing tables	0.06 ms
freeing items	0.06 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	79.60 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 документ за да имате врски до документите]

Време на барање: 189.08 ms По последното барање: 3.09 ms Меморија по барање: 0.023 MB меморија по барањето: 5.180 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-07-21 08:58:38') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-07-21 08:58:38') 
  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.03 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.20 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.02 ms
Opening tables	0.31 ms
init	0.18 ms
System lock	0.04 ms
Waiting for query cache lock	0.02 ms
System lock	0.16 ms
optimizing	0.02 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	34.96 ms
Creating tmp table	0.27 ms
Sorting result	0.09 ms
statistics	0.68 ms
preparing	0.10 ms
executing	0.04 ms
Sending data	0.08 ms
end	74.54 ms
removing tmp table	0.11 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.03 ms
closing tables	0.07 ms
freeing items	0.06 ms
Waiting for query cache lock	0.02 ms
freeing items	0.06 ms
Waiting for query cache lock	0.03 ms
freeing items	0.02 ms
storing result in query cache	0.02 ms
cleaning up	0.39 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 документ за да имате врски до документите]

Време на барање: 1.67 ms По последното барање: 7.82 ms Меморија по барање: 0.027 MB меморија по барањето: 5.276 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.09 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.09 ms
System lock	0.02 ms
Waiting for query cache lock	0.02 ms
System lock	0.06 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 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.02 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 1.09 ms По последното барање: 49.00 ms Меморија по барање: 0.024 MB меморија по барањето: 5.507 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.12 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.02 ms
checking permissions	0.03 ms
sending cached result to clien	0.10 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 1.00 ms По последното барање: 19.91 ms Меморија по барање: 0.023 MB меморија по барањето: 5.633 MB Вратени редови: 1

Двојни барања: #25

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.10 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.03 ms
sending cached result to clien	0.11 ms
cleaning up	0.04 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 документ за да имате врски до документите]

Време на барање: 0.76 ms По последното барање: 476.75 ms Меморија по барање: 0.021 MB меморија по барањето: 5.603 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.11 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.02 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 1.70 ms По последното барање: 2.45 ms Меморија по барање: 0.021 MB меморија по барањето: 5.647 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.08 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.10 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.06 ms
System lock	0.03 ms
Waiting for query cache lock	0.01 ms
System lock	0.07 ms
optimizing	0.04 ms
statistics	0.17 ms
executing	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 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.02 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 1.62 ms По последното барање: 3.17 ms Меморија по барање: 0.021 MB меморија по барањето: 5.733 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.07 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
checking query cache for query	0.17 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.09 ms
System lock	0.03 ms
Waiting for query cache lock	0.01 ms
System lock	0.07 ms
optimizing	0.04 ms
statistics	0.17 ms
executing	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 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.02 ms
cleaning up	0.02 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 документ за да имате врски до документите]

Време на барање: 473.70 ms По последното барање: 421.97 ms Меморија по барање: 0.026 MB меморија по барањето: 6.281 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-07-21 08:58:38') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-07-21 08:58:38') 
  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.02 ms
init	0.02 ms
checking query cache for query	0.15 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.10 ms
System lock	0.03 ms
Waiting for query cache lock	0.02 ms
System lock	0.08 ms
optimizing	0.05 ms
statistics	0.19 ms
preparing	0.08 ms
Sorting result	0.02 ms
executing	0.02 ms
Sending data	0.03 ms
Creating sort index	471.25 ms
end	0.12 ms
query end	0.03 ms
closing tables	0.25 ms
freeing items	0.08 ms
Waiting for query cache lock	0.03 ms
freeing items	0.07 ms
Waiting for query cache lock	0.03 ms
freeing items	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.02 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 документ за да имате врски до документите]

27 забележани типови барања, подредени по зачестеност.

Табела одбрани:

2 × SELECT params
 
  FROM og45h_template_styles

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

2 × SELECT element
 
  FROM og45h_extensions

1 × SELECT `data`
 
  FROM `og45h_session`

1 × 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

1 × 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'

1 × 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`

1 × SELECT language,id
 
  FROM `og45h_menu`

1 × SELECT `m`.`tag_id`,`t`.*
 
  FROM `og45h_contentitem_tag_map` AS m 
 
  INNER JOIN `og45h_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

1 × 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

1 × SELECT a.name, a.rules
 
  FROM og45h_assets AS a

1 × SELECT a.id, a.parent_id
 
  FROM og45h_assets AS a

1 × SELECT a.id, a.name, a.rules
 
  FROM og45h_assets AS a

1 × SELECT `session_id`
 
  FROM `og45h_session`

1 × SELECT a.rules
 
  FROM og45h_assets AS a

```
1 × SELECT *
 
  FROM og45h_assets
```

1 × 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

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

```
1 × SELECT *
 
  FROM og45h_languages
```

1 × SELECT folder AS type, element AS name, params
 
  FROM og45h_extensions

1 × SELECT id, rules
 
  FROM `og45h_viewlevels

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

1 × 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

Табела други:

1 × INSERT INTO `og45h_session`
 (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
 ('4d37u7bu03g4tbmt0975vbmcr8', 0, 1, '1563699510', 0, ''

1 × UPDATE `og45h_extensions`
 
  SET `params` = '{\"mediaversion\":\"4be73c27661f9075fdfe97062f13481f\"}'

1 × SHOW FULL COLUMNS 
  FROM `og45h_assets

За нас

Joomla! Debug конзола

Сесија

Информација за профил

Време

Меморија

Искористеност на меморија

Барања до базата

30 забележани барања 8567.67 ms

2 најдени двојници!

27 забележани типови барања, подредени по зачестеност.

Табела одбрани:

Табела други: