Астана қаласы әкімдігінің №32 «Балдәурен» балабақшасы МҚКК

Жаңалықтар

Балаларды үлкендердің еңбегін құрметтей білуге тәрбиелеуде мазмұнды - рөлді ойын "Дәрігер"

: Жаңалықтар; 19 Июнь 2024

Астана қаласы әкімдігінің №32 «Балдәурен» балабақшасы МҚКК, Қазақстан Республикасы

Дизайн және сайтты әзірлеу: Webmarka

Біз туралы

Жаңалықтарға жазылу

Консоль отладки Joomla!

Сессия

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1770195610,
                "last": 1770195610,
                "now": 1770195620
            }
        },
        "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
        },
        "com_mailto": {
            "links": {
                "82be8b246d0cdf3f73a6422cf2d9440de6144b71": {
                    "link": "https:\/\/ys32baldauren.edu.kz\/kz\/component\/content\/article\/125-bzhzq\/257-bzhz-any-tamasy-endi-egov-portalynda-olzhetimdi?Itemid=629",
                    "expiry": 1770195610
                },
                "237213576810cd59eafa6b76b5cf27b522988690": {
                    "link": "https:\/\/ys32baldauren.edu.kz\/kz\/zhanalyqtar\/531-balalardy-lkenderdi-e-begin-rmettej-biluge-t-rbieleude-mazm-ndy-r-ldi-ojyn-d-riger",
                    "expiry": 1770195620
                }
            }
        }
    }
}

Результаты профилирования

Time

Memory

Time: 18.18 ms / 18.18 ms Memory: 0.049 MB / 0.38 MB Application: afterLoad

Time: 90.55 ms / 108.73 ms Memory: 1.357 MB / 1.74 MB Application: afterInitialise

Time: 16.94 ms / 125.67 ms Memory: 0.120 MB / 1.86 MB Application: Before JAccess::preloadComponents (all components)

Time: 0.66 ms / 126.33 ms Memory: 0.059 MB / 1.92 MB Application: After JAccess::preloadComponents (all components)

Time: 0.05 ms / 126.38 ms Memory: 0.000 MB / 1.92 MB Application: Before JAccess::getAssetRules (id:16 name:com_menus)

Time: 0.78 ms / 127.16 ms Memory: 0.007 MB / 1.92 MB Application: After JAccess::getAssetRules (id:16 name:com_menus)

Time: 1.03 ms / 128.20 ms Memory: 0.000 MB / 1.92 MB Application: afterRoute

Time: 42.76 ms / 170.95 ms Memory: 0.269 MB / 2.19 MB Application: beforeRenderComponent com_content

Time: 7.96 ms / 178.91 ms Memory: 0.053 MB / 2.24 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Time: 0.12 ms / 179.03 ms Memory: 0.007 MB / 2.25 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Time: 49.45 ms / 228.48 ms Memory: 0.306 MB / 2.56 MB Application: Before JAccess::preloadPermissions (com_content)

Time: 2.66 ms / 231.14 ms Memory: 0.564 MB / 3.12 MB Application: After JAccess::preloadPermissions (com_content)

Time: 0.13 ms / 231.27 ms Memory: 0.000 MB / 3.09 MB Application: Before JAccess::getAssetRules (id:886 name:com_content.article.531)

Time: 0.16 ms / 231.43 ms Memory: 0.007 MB / 3.09 MB Application: After JAccess::getAssetRules (id:886 name:com_content.article.531)

Time: 72.80 ms / 304.23 ms Memory: 0.115 MB / 3.21 MB Application: afterRenderComponent com_content

Time: 12.56 ms / 316.79 ms Memory: 0.033 MB / 3.24 MB Application: afterDispatch

Time: 393.69 ms / 710.48 ms Memory: 0.644 MB / 3.88 MB Application: beforeRenderModule mod_menu (Off Canvas Menu (2))

Time: 1.60 ms / 712.09 ms Memory: 0.011 MB / 3.90 MB Application: afterRenderModule mod_menu (Off Canvas Menu (2))

Time: 0.05 ms / 712.13 ms Memory: 0.000 MB / 3.89 MB Application: beforeRenderModule mod_search (Поиск (2))

Time: 1.80 ms / 713.93 ms Memory: 0.015 MB / 3.91 MB Application: afterRenderModule mod_search (Поиск (2))

Time: 0.09 ms / 714.03 ms Memory: 0.000 MB / 3.91 MB Application: beforeRenderModule mod_acymailing (Жаңалықтарға жазылу)

Time: 9.50 ms / 723.52 ms Memory: 0.379 MB / 4.29 MB Application: afterRenderModule mod_acymailing (Жаңалықтарға жазылу)

Time: 0.10 ms / 723.62 ms Memory: 0.000 MB / 4.27 MB Application: beforeRenderModule mod_menu (Біз туралы)

Time: 4.70 ms / 728.32 ms Memory: 0.030 MB / 4.30 MB Application: afterRenderModule mod_menu (Біз туралы)

Time: 0.07 ms / 728.39 ms Memory: 0.000 MB / 4.29 MB Application: beforeRenderModule mod_custom (Bottom-1 (2))

Time: 1.61 ms / 730.00 ms Memory: 0.006 MB / 4.30 MB Application: afterRenderModule mod_custom (Bottom-1 (2))

Time: 0.08 ms / 730.08 ms Memory: 0.000 MB / 4.30 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs (2))

Time: 2.31 ms / 732.40 ms Memory: 0.011 MB / 4.31 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs (2))

Time: 0.13 ms / 732.52 ms Memory: 0.000 MB / 4.31 MB Application: beforeRenderModule mod_languages (Language Switcher)

Time: 13.50 ms / 746.03 ms Memory: 0.170 MB / 4.48 MB Application: afterRenderModule mod_languages (Language Switcher)

Time: 0.09 ms / 746.12 ms Memory: 0.000 MB / 4.47 MB Application: beforeRenderModule mod_custom (Хидер (копия) (2))

Time: 0.67 ms / 746.80 ms Memory: 0.003 MB / 4.48 MB Application: afterRenderModule mod_custom (Хидер (копия) (2))

Time: 3.96 ms / 750.76 ms Memory: 0.057 MB / 4.53 MB Application: afterRender

Database queries total: 85.86 ms

Использование памяти

Запросы к базе данных

38 SQL-запросов зафиксировано 85.86 ms

6 duplicate found!

2 duplicates: #16 #32

4 duplicates: #22 #23 #24 #27

Query Time: 1.70 ms Query memory: 0.024 MB Memory before query: 0.691 MB Rows returned: 43

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

  FROM `x0xmp_extensions`

  WHERE `type` = 'component'

Explain

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

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.10 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.09 ms
Optimizing	0.05 ms
Statistics	0.15 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.57 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.06 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.35 ms After last query: 2.83 ms Query memory: 0.021 MB Memory before query: 0.720 MB Rows returned: 0

SELECT b.id

  FROM x0xmp_usergroups AS a

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

  WHERE a.id = 13

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	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.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
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:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.36 ms After last query: 0.44 ms Query memory: 0.021 MB Memory before query: 0.724 MB Rows returned: 5

SELECT id, rules

  FROM `x0xmp_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x0xmp_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.04 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
Sending cached result to clien	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
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:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.45 ms After last query: 0.25 ms Query memory: 0.030 MB Memory before query: 0.751 MB Rows returned: 98

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

  FROM x0xmp_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x0xmp_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	255	49.02	Using where; Using filesort

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.14 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.09 ms
Optimizing	0.13 ms
Statistics	0.15 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.20 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.05 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
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:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.40 ms After last query: 31.51 ms Query memory: 0.021 MB Memory before query: 1.274 MB Rows returned: 2

SELECT *

  FROM x0xmp_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x0xmp_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	Using where; Using filesort

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:98
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:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.26 ms After last query: 0.28 ms Query memory: 0.021 MB Memory before query: 1.284 MB Rows returned: 6

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `x0xmp_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.11 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.07 ms
Optimizing	0.07 ms
Statistics	0.16 ms
Preparing	0.08 ms
Executing	0.01 ms
Sending data	0.21 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.04 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.05 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:207
8	JLanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:109
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:682
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.22 ms After last query: 11.69 ms Query memory: 0.023 MB Memory before query: 1.350 MB Rows returned: 1

SELECT COUNT(`extension_id`)

  FROM `x0xmp_extensions`

  WHERE `element` = 'com_advancedmodules' 
  AND `type` = 'component'

Explain

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

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.11 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.20 ms
Preparing	0.07 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.04 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/cms/component/helper.php:95
14	JComponentHelper::isInstalled()	JROOT/libraries/regularlabs/src/Parameters.php:136
13	RegularLabs\Library\Parameters->getComponentParams()	JROOT/plugins/system/advancedmodules/src/Params.php:29
12	RegularLabs\Plugin\System\AdvancedModules\Params::get()	JROOT/plugins/system/advancedmodules/src/Helper.php:22
11	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterInitialise()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:59
8	PlgSystemAdvancedModules->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.86 ms After last query: 3.41 ms Query memory: 0.140 MB Memory before query: 1.392 MB Rows returned: 61

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

  LEFT JOIN x0xmp_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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	116	61.21	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	baldauren32_db.m.component_id	1	100.00	Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.21 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.09 ms
Optimizing	0.07 ms
Statistics	0.16 ms
Preparing	0.08 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
Creating sort index	0.54 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.20 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.23 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.16 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.17 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.20 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.06 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
20	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
19	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
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:129
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:548
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.68 ms After last query: 17.75 ms Query memory: 0.022 MB Memory before query: 1.848 MB Rows returned: 0

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

  FROM x0xmp_categories as c

  LEFT JOIN x0xmp_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('kz-KZ','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

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

  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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.36 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.09 ms
init	0.23 ms
Optimizing	0.12 ms
Statistics	0.16 ms
Preparing	0.02 ms
Executing	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.08 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
12	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
11	JCategories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/cms/component/router/view.php:263
9	JComponentRouterView->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.87 ms After last query: 0.18 ms Query memory: 0.021 MB Memory before query: 1.853 MB Rows returned: 1

SELECT `alias`,`catid`

  FROM `x0xmp_content`

  WHERE `id` = 531

Explain

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

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.06 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/cms/component/router/view.php:263
9	JComponentRouterView->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.34 ms After last query: 0.60 ms Query memory: 0.028 MB Memory before query: 1.864 MB Rows returned: 42

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

  FROM `x0xmp_assets`

  WHERE `name` IN ('com_acymailing','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_authorlist','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_unitegallery','com_uniterevolution2','com_users','com_wrapper') OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x0xmp_assets	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	152,4	NULL	43	100.00	Using sort_union(idx_asset_name,idx_parent_id); Using where

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	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.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
15	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
14	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
13	JUser->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
12	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
11	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Same as call in the line below.
10	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
9	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:64
8	PlgSystemAdvancedModules->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.18 ms After last query: 2.37 ms Query memory: 0.022 MB Memory before query: 2.003 MB Rows returned: 1

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

  FROM `x0xmp_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.22 ms
Preparing	0.07 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.05 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
12	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
10	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 32.75 ms After last query: 0.28 ms Query memory: 0.005 MB Memory before query: 1.993 MB

UPDATE `x0xmp_extensions`

  SET `params` = '{\"mediaversion\":\"eb6dd3e7407c54ba1dedfe44282d2761\"}'

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

Explain

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

Profile

Status	Duration
Starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
checking permissions	0.01 ms
After opening tables	0.01 ms
init for update	0.01 ms
init	0.04 ms
Updating main table	0.02 ms
init	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
init for update	0.16 ms
Updating	0.19 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	31.52 ms
Query end	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1022
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.63 ms After last query: 2.32 ms Query memory: 0.050 MB Memory before query: 2.032 MB Rows returned: 6

SELECT id, home, template, s.params

  FROM x0xmp_template_styles as s

  LEFT JOIN x0xmp_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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	62	const	5	100.00	Using index condition; Using where
1	SIMPLE	s	ref	idx_template	idx_template	152	baldauren32_db.e.element	1	100.00	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.16 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.05 ms
init	0.09 ms
Optimizing	0.09 ms
Statistics	0.21 ms
Preparing	0.10 ms
Executing	0.01 ms
Sending data	0.27 ms
Waiting for query cache lock	0.01 ms
Sending data	0.12 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.03 ms
Waiting for query cache lock	0.02 ms
Updating status	0.01 ms
Storing result in query cache	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.46 ms After last query: 13.17 ms Query memory: 0.031 MB Memory before query: 2.253 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `x0xmp_content`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `x0xmp_content`

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.80 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
checking permissions	0.35 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.17 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.28 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:33
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:311
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:250
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.14 ms After last query: 5.05 ms Query memory: 0.022 MB Memory before query: 2.301 MB Rows returned: 1

Duplicate queries: #32

SELECT *

  FROM x0xmp_content

  WHERE `id` = '531'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.09 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.08 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.05 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
10	JTable->load()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 7.23 ms After last query: 0.30 ms Query memory: 0.006 MB Memory before query: 2.310 MB

UPDATE x0xmp_content

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

  WHERE `id` = '531'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x0xmp_content	range	PRIMARY	PRIMARY	4	NULL	1	100.00	Using where

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
checking permissions	0.01 ms
After opening tables	0.01 ms
init for update	0.01 ms
init	0.03 ms
Updating main table	0.06 ms
init	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
init for update	0.11 ms
Updating	0.20 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	6.04 ms
Query end	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
10	JTable->hit()	JROOT/components/com_content/models/article.php:252
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.18 ms After last query: 3.53 ms Query memory: 0.023 MB Memory before query: 2.398 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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

  FROM x0xmp_content AS a

  INNER JOIN x0xmp_categories AS c 
  on c.id = a.catid

  LEFT JOIN x0xmp_users AS u 
  on u.id = a.created_by

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

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

  WHERE a.id = 531 
  AND c.published > 0 
  AND a.language in ('kz-KZ','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-02-04 09:00:20') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-02-04 09:00:20') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1	100.00
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	1	100.00	Unique row not found

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.38 ms
checking permissions	0.06 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.07 ms
init	0.19 ms
Optimizing	0.13 ms
Statistics	0.28 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.15 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.08 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.44 ms After last query: 2.56 ms Query memory: 0.027 MB Memory before query: 2.430 MB Rows returned: 3

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

  FROM x0xmp_categories as c

  LEFT JOIN x0xmp_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('kz-KZ','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

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

  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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	99	59.60	Using where; Using filesort

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.03 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
19	JCategories->get()	JROOT/components/com_content/router.php:70
18	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
17	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
16	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
15	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
14	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
13	JRouter->build()	JROOT/libraries/cms/router/site.php:149
12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
11	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.75 ms After last query: 0.94 ms Query memory: 0.022 MB Memory before query: 2.454 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `x0xmp_contentitem_tag_map` AS m 

  INNER JOIN `x0xmp_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 531 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	5	const,const	6	100.00
1	SIMPLE	m	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	54	18.52	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.15 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.04 ms
init	0.17 ms
Optimizing	0.09 ms
Statistics	0.21 ms
Preparing	0.13 ms
Executing	0.01 ms
Sending data	0.29 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.04 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:180
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.42 ms After last query: 2.95 ms Query memory: 0.023 MB Memory before query: 2.465 MB Rows returned: 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `x0xmp_content` AS `c`

  INNER JOIN `x0xmp_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

  INNER JOIN `x0xmp_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `x0xmp_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `x0xmp_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 531

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.21 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.05 ms
init	0.10 ms
Optimizing	0.10 ms
Statistics	0.29 ms
Preparing	0.02 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.04 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
13	JLanguageAssociations::getAssociations()	JROOT/components/com_content/helpers/association.php:43
12	ContentHelperAssociation::getAssociations()	JROOT/components/com_content/helpers/association.php:77
11	ContentHelperAssociation::displayAssociations()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.37 ms After last query: 8.53 ms Query memory: 0.009 MB Memory before query: 2.515 MB

Duplicate queries: #23 #24 #27

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

  FROM x0xmp_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (115,0,108)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','kz-KZ')

  GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state

  ORDER BY a.ordering DESC

Explain

Error
Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb3_unicode_ci,IMPLICIT) for operation '='

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.36 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.08 ms
init	0.23 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
Storing result in query cache	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Rollback	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
17	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
16	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
15	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.32 ms After last query: 2.19 ms Query memory: 0.009 MB Memory before query: 2.535 MB

Duplicate queries: #22 #24 #27

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

  FROM x0xmp_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (115,0,108)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','kz-KZ')

  GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state

  ORDER BY a.ordering DESC

Explain

Error
Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb3_unicode_ci,IMPLICIT) for operation '='

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.40 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.08 ms
init	0.16 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
Storing result in query cache	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Rollback	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
18	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:326
14	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:255
13	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.24 ms After last query: 1.33 ms Query memory: 0.009 MB Memory before query: 2.546 MB

Duplicate queries: #22 #23 #27

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

  FROM x0xmp_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (115,0,108)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','kz-KZ')

  GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state

  ORDER BY a.ordering DESC

Explain

Error
Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb3_unicode_ci,IMPLICIT) for operation '='

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.34 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.05 ms
Waiting for query cache lock	0.07 ms
init	0.15 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
Storing result in query cache	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Rollback	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
18	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:326
14	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:272
13	PlgSystemFields->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:196
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.70 ms After last query: 0.86 ms Query memory: 0.150 MB Memory before query: 2.559 MB Rows returned: 555

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

  FROM `x0xmp_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x0xmp_assets	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	750	100.00	Using where

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
Sending cached result to clien	0.18 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
14	JUser->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:196
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 6.80 ms After last query: 2.39 ms Query memory: 0.076 MB Memory before query: 3.103 MB Rows returned: 175

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM x0xmp_content AS a

  LEFT JOIN x0xmp_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 115 
  AND a.state = 1 
  AND a.access IN (1,1)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-02-04 09:00:20') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-02-04 09:00:20') 
  AND a.language in ('kz-KZ','*')

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	idx_access,idx_state,idx_catid,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	392	36.04	Using where; Using filesort
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	100.00

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.36 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.06 ms
init	0.17 ms
Optimizing	0.14 ms
Statistics	0.26 ms
Preparing	0.09 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
Creating sort index	2.75 ms
Waiting for query cache lock	0.02 ms
Creating sort index	1.23 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.91 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.08 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:152
13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:196
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.37 ms After last query: 3.34 ms Query memory: 0.009 MB Memory before query: 3.101 MB

Duplicate queries: #22 #23 #24

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

  FROM x0xmp_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (115,0,108)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','kz-KZ')

  GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state

  ORDER BY a.ordering DESC

Explain

Error
Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb3_unicode_ci,IMPLICIT) for operation '='

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.41 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
Waiting for query cache lock	0.08 ms
init	0.17 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
Storing result in query cache	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Rollback	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
18	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:326
14	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:289
13	PlgSystemFields->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.34 ms After last query: 61.34 ms Query memory: 0.021 MB Memory before query: 3.212 MB Rows returned: 3

SELECT language,id

  FROM `x0xmp_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x0xmp_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	116	62.07	Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	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.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:106
8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:709
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.93 ms After last query: 0.40 ms Query memory: 0.024 MB Memory before query: 3.221 MB Rows returned: 1

SELECT `alias`

  FROM `x0xmp_content`

  WHERE id = '531'

Explain

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

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.09 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.04 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:123
15	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/languagefilter/languagefilter.php:721
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.80 ms After last query: 0.21 ms Query memory: 0.023 MB Memory before query: 3.229 MB Rows returned: 1

SELECT alias

  FROM x0xmp_content

  WHERE id=531

Explain

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

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.04 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
14	ContentRouterRulesLegacy->build()	JROOT/libraries/cms/component/router/view.php:241
13	JComponentRouterView->build()	JROOT/libraries/cms/router/site.php:519
12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/languagefilter/languagefilter.php:721
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
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:265
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.33 ms After last query: 67.56 ms Query memory: 0.060 MB Memory before query: 3.605 MB Rows returned: 17

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM x0xmp_modules AS m

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

  LEFT JOIN x0xmp_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND m.language IN ('kz-KZ','*')

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	published,newsfeeds,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	57	39.61	Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	baldauren32_db.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	baldauren32_db.m.id	1	100.00	Using where

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.18 ms
checking permissions	0.06 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.12 ms
Optimizing	0.07 ms
Statistics	0.21 ms
Preparing	0.09 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.65 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.40 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:406
17	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:123
16	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
15	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
14	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:355
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:512
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:459
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:268
8	Helix3::generatelayout()	JROOT/templates/shaper_kidzy/index.php:184
7	require JROOT/templates/shaper_kidzy/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.14 ms After last query: 11.79 ms Query memory: 0.027 MB Memory before query: 3.864 MB Rows returned: 1

Duplicate queries: #16

SELECT *

  FROM x0xmp_content

  WHERE `id` = '531'

Explain

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

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.13 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.09 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.05 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
21	JTable->load()	JROOT/libraries/regularlabs/src/Condition/ContentCategory.php:135
20	RegularLabs\Library\Condition\ContentCategory->getCategoryIds()	JROOT/libraries/regularlabs/src/Condition/ContentCategory.php:88
19	RegularLabs\Library\Condition\ContentCategory->pass()	JROOT/libraries/regularlabs/src/Conditions.php:230
18	RegularLabs\Library\Conditions::passByType()	JROOT/libraries/regularlabs/src/Conditions.php:65
17	RegularLabs\Library\Conditions::pass()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:172
16	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
15	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
14	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:355
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:512
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:459
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:268
8	Helix3::generatelayout()	JROOT/templates/shaper_kidzy/index.php:184
7	require JROOT/templates/shaper_kidzy/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.30 ms After last query: 0.21 ms Query memory: 0.027 MB Memory before query: 3.882 MB Rows returned: 1

SELECT t.parent_id

  FROM x0xmp_categories as t

  WHERE t.id = 115

Explain

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

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
Sending cached result to clien	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
22	JDatabaseDriver->loadResult()	JROOT/libraries/regularlabs/src/Condition.php:300
21	RegularLabs\Library\Condition->getParentIds()	JROOT/libraries/regularlabs/src/Condition/ContentCategory.php:158
20	RegularLabs\Library\Condition\ContentCategory->getCatParentIds()	JROOT/libraries/regularlabs/src/Condition/ContentCategory.php:107
19	RegularLabs\Library\Condition\ContentCategory->pass()	JROOT/libraries/regularlabs/src/Conditions.php:230
18	RegularLabs\Library\Conditions::passByType()	JROOT/libraries/regularlabs/src/Conditions.php:65
17	RegularLabs\Library\Conditions::pass()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:172
16	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
15	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
14	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:355
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:512
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:459
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:268
8	Helix3::generatelayout()	JROOT/templates/shaper_kidzy/index.php:184
7	require JROOT/templates/shaper_kidzy/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.29 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 3.894 MB Rows returned: 1

SELECT t.parent_id

  FROM x0xmp_categories as t

  WHERE t.id = 108

Explain

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

Profile

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
22	JDatabaseDriver->loadResult()	JROOT/libraries/regularlabs/src/Condition.php:300
21	RegularLabs\Library\Condition->getParentIds()	JROOT/libraries/regularlabs/src/Condition/ContentCategory.php:158
20	RegularLabs\Library\Condition\ContentCategory->getCatParentIds()	JROOT/libraries/regularlabs/src/Condition/ContentCategory.php:107
19	RegularLabs\Library\Condition\ContentCategory->pass()	JROOT/libraries/regularlabs/src/Conditions.php:230
18	RegularLabs\Library\Conditions::passByType()	JROOT/libraries/regularlabs/src/Conditions.php:65
17	RegularLabs\Library\Conditions::pass()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:172
16	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
15	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
14	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:355
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:512
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:459
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:268
8	Helix3::generatelayout()	JROOT/templates/shaper_kidzy/index.php:184
7	require JROOT/templates/shaper_kidzy/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.25 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 3.904 MB Rows returned: 1

SELECT t.parent_id

  FROM x0xmp_categories as t

  WHERE t.id = 1

Explain

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

Profile

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.05 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
22	JDatabaseDriver->loadResult()	JROOT/libraries/regularlabs/src/Condition.php:300
21	RegularLabs\Library\Condition->getParentIds()	JROOT/libraries/regularlabs/src/Condition/ContentCategory.php:158
20	RegularLabs\Library\Condition\ContentCategory->getCatParentIds()	JROOT/libraries/regularlabs/src/Condition/ContentCategory.php:107
19	RegularLabs\Library\Condition\ContentCategory->pass()	JROOT/libraries/regularlabs/src/Conditions.php:230
18	RegularLabs\Library\Conditions::passByType()	JROOT/libraries/regularlabs/src/Conditions.php:65
17	RegularLabs\Library\Conditions::pass()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:172
16	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
15	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
14	JApplicationBase->triggerEvent()	JROOT/libraries/cms/module/helper.php:355
13	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
11	JDocumentHtml->countModules()	JROOT/plugins/system/helix3/core/helix3.php:512
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:459
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:268
8	Helix3::generatelayout()	JROOT/templates/shaper_kidzy/index.php:184
7	require JROOT/templates/shaper_kidzy/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.34 ms After last query: 325.16 ms Query memory: 0.029 MB Memory before query: 4.015 MB Rows returned: 87

SELECT * 
  FROM x0xmp_acymailing_config

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x0xmp_acymailing_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	87	100.00

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:474
15	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
14	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
13	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:815
12	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
11	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:13
10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.33 ms After last query: 5.68 ms Query memory: 0.023 MB Memory before query: 4.292 MB Rows returned: 1

SELECT * 
  FROM x0xmp_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	x0xmp_acymailing_list	ref	typeorderingindex,typeuseridindex	typeorderingindex	1	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
Sending cached result to clien	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:474
12	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
11	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:148
10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.34 ms After last query: 11.50 ms Query memory: 0.023 MB Memory before query: 4.343 MB Rows returned: 2

SELECT `c2`.`language`,`c2`.`id`

  FROM `x0xmp_menu` AS `c`

  INNER JOIN `x0xmp_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `x0xmp_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `x0xmp_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 714

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	156	const,const	1	100.00
1	SIMPLE	a2	ref	idx_key	idx_key	96	const	2	100.00	Using index
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	baldauren32_db.a2.id	1	100.00

Profile

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.03 ms
Sending cached result to clien	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
13	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:314
12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:61
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

29 типов SQL-запросов зафиксировано, отсортировано по вхождениям

Запросы типа SELECT:

4 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
  FROM x0xmp_fields AS a 
  LEFT JOIN `x0xmp_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN x0xmp_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN x0xmp_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN x0xmp_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN x0xmp_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `x0xmp_fields_categories` AS fc 
  ON fc.field_id = a.id

3 × SELECT t.parent_id 
  FROM x0xmp_categories as t

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

2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM x0xmp_categories as c 
  LEFT JOIN x0xmp_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('kz-KZ','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `x0xmp_assets`

```
2 × SELECT * 
  FROM x0xmp_content
```

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `x0xmp_content` AS `c` 
  INNER JOIN `x0xmp_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `x0xmp_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `x0xmp_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `x0xmp_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

1 × SELECT * 
  FROM x0xmp_acymailing_list

1 × SELECT * 
  FROM x0xmp_acymailing_confi

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM x0xmp_modules AS m 
  LEFT JOIN x0xmp_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN x0xmp_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT alias 
  FROM x0xmp_content

1 × SELECT `alias` 
  FROM `x0xmp_content`

1 × SELECT language,id 
  FROM `x0xmp_menu`

1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM x0xmp_content AS a 
  LEFT JOIN x0xmp_categories AS cc 
  ON cc.id = a.catid

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,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 
  FROM x0xmp_content AS a 
  INNER JOIN x0xmp_categories AS c 
  on c.id = a.catid 
  LEFT JOIN x0xmp_users AS u 
  on u.id = a.created_by 
  LEFT JOIN x0xmp_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN x0xmp_content_rating AS v 
  ON a.id = v.content_id

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

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

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

1 × SELECT `alias`,`catid` 
  FROM `x0xmp_content`

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 x0xmp_menu AS m 
  LEFT JOIN x0xmp_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT COUNT(`extension_id`) 
  FROM `x0xmp_extensions`

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `x0xmp_extensions`

```
1 × SELECT * 
  FROM x0xmp_languages
```

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM x0xmp_extensions

1 × SELECT id, rules 
  FROM `x0xmp_viewlevels

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `x0xmp_menu` AS `c` 
  INNER JOIN `x0xmp_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `x0xmp_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `x0xmp_menu` AS `c2` 
  ON a2.id = c2.`id`

Прочие SQL-запросы:

1 × UPDATE `x0xmp_extensions` 
  SET `params` = '{\"mediaversion\":\"eb6dd3e7407c54ba1dedfe44282d2761\"}'

1 × SHOW FULL COLUMNS 
  FROM `x0xmp_content

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