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

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713859043,
                "last": 1713859043,
                "now": 1713859043
            }
        },
        "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": {
                "81e582dbab6d6026d2a24d729a1149df6b493b62": {
                    "link": "http:\/\/rvm-p.ru\/index.php\/blog\/8-projects\/20-dufner-heighes-redesigns-noho-model",
                    "expiry": 1713859043
                },
                "5f118b298fb25c94cb728c4c65d618eaf0f0fe46": {
                    "link": "http:\/\/rvm-p.ru\/index.php\/blog\/8-projects\/21-museum-in-the-sky",
                    "expiry": 1713859043
                }
            }
        }
    }
}

Время

Память

40 SQL-запросов зафиксировано 30.93 ms

1. Время запроса: 0.36 ms Память запроса: 0.003 MB Память до запроса: 0.724 MB

   DELETE 
   
     FROM `pjk6p_session`
   
     WHERE `time` < '1713855443'

   План SQL-запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	DELETE	pjk6p_session	NULL	range	time	time	45	const	1	100.00	Using where

   Профилирование SQL-запросов

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.10 ms
   updating	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.02 ms
   cleaning up	0.02 ms

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

2. Время запроса: 0.38 ms После последнего запроса: 0.33 ms Память запроса: 0.024 MB Память до запроса: 0.733 MB Выбрано строк: 0

   SELECT `data`
   
     FROM `pjk6p_session`
   
     WHERE `session_id` = '772cdf51c17f9f1476b3b8a693fd5395'

   План SQL-запросов (Explain)

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

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Так же, как вызов в строке ниже.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
   10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
   9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
   8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
   7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
   6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

3. Время запроса: 0.27 ms После последнего запроса: 0.49 ms Память запроса: 0.021 MB Память до запроса: 0.748 MB Выбрано строк: 0

   SELECT `session_id`
   
     FROM `pjk6p_session`
   
     WHERE `session_id` = '772cdf51c17f9f1476b3b8a693fd5395' 
     LIMIT 1

   План SQL-запросов (Explain)

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

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

4. Время запроса: 0.26 ms После последнего запроса: 0.12 ms Память запроса: 0.003 MB Память до запроса: 0.753 MB

   INSERT INTO `pjk6p_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('772cdf51c17f9f1476b3b8a693fd5395', 1, '1713859043', 0, '', 0)

   План SQL-запросов (Explain)

   EXPLAIN не доступен для запроса: INSERT INTO `pjk6p_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('772cdf51c17f9f1476b3b8a693fd5395', 1, '1713859043', 0, '', 0)

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

5. Время запроса: 0.74 ms После последнего запроса: 0.65 ms Память запроса: 0.029 MB Память до запроса: 0.778 MB Выбрано строк: 38

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

   План SQL-запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	pjk6p_extensions	NULL	ref	extension	extension	62	const	38	100.00	NULL

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
   8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
   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

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

6. Время запроса: 0.37 ms После последнего запроса: 0.93 ms Память запроса: 0.023 MB Память до запроса: 0.812 MB Выбрано строк: 5

   SELECT id, rules
   
     FROM `pjk6p_viewlevels`

   План SQL-запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	pjk6p_viewlevels	NULL	ALL	NULL	Индекс не используется	NULL	NULL	5	100.00	NULL

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
   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

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

7. Время запроса: 0.60 ms После последнего запроса: 0.17 ms Память запроса: 0.022 MB Память до запроса: 0.824 MB Выбрано строк: 2

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

   План SQL-запросов (Explain)

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

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   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:1093
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
   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

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

8. Время запроса: 0.97 ms После последнего запроса: 0.37 ms Память запроса: 0.034 MB Память до запроса: 0.908 MB Выбрано строк: 98

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

   План SQL-запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	pjk6p_extensions	NULL	ref	extension	extension	62	const	133	0.60	Using index condition; Using where; Используется filesort

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
   8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
   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

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

9. Время запроса: 0.45 ms После последнего запроса: 8.62 ms Память запроса: 0.031 MB Память до запроса: 1.578 MB Выбрано строк: 75

   SELECT *
   
     FROM pjk6p_j2store_configurations

   План SQL-запросов (Explain)

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	pjk6p_j2store_configurations	NULL	ALL	NULL	Индекс не используется	NULL	NULL	75	100.00	NULL

   Профилирование SQL-запросов

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

   Стек вызовов

   #	Вызывающий объект	Файл и номер строки
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/helpers/config.php:20
   12	J2Config->__construct()	JROOT/administrator/components/com_j2store/helpers/config.php:28
   11	J2Config::getInstance()	JROOT/administrator/components/com_j2store/helpers/j2store.php:71
   10	J2Store::config()	JROOT/plugins/system/j2store/j2store.php:146
   9	plgSystemJ2Store->onJ2StoreCronTask()	JROOT/plugins/system/j2store/j2store.php:126
   8	plgSystemJ2Store->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:684
   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

   [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

   ---

10. Время запроса: 0.93 ms После последнего запроса: 0.81 ms Память запроса: 0.044 MB Память до запроса: 1.662 MB Выбрано строк: 18

    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 pjk6p_menu AS m
    
      LEFT JOIN pjk6p_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

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	Индекс не используется	NULL	NULL	105	5.62	Using where; Используется filesort
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.m.component_id	1	100.00	Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
    16	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
    15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
    14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
    11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
    10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
    8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
    7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
    6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
    5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1145
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

11. Время запроса: 0.93 ms После последнего запроса: 3.20 ms Память запроса: 0.035 MB Память до запроса: 1.893 MB Выбрано строк: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM pjk6p_categories as c
    
      LEFT JOIN pjk6p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=8
    
      ORDER BY c.lft

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Используется filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	Индекс не используется	NULL	NULL	14	47.62	Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    12	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    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:1146
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

12. Время запроса: 0.60 ms После последнего запроса: 0.23 ms Память запроса: 0.024 MB Память до запроса: 1.909 MB Выбрано строк: 8

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

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ALL	idx_template	Индекс не используется	NULL	NULL	10	10.00	Using where
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	u0402124_default.s.template,const	1	4.58	Using index condition; Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
    10	JApplicationSite->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
    9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
    8	plgSystemT3->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:1155
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

13. Время запроса: 0.28 ms После последнего запроса: 2.80 ms Память запроса: 0.026 MB Память до запроса: 2.077 MB Выбрано строк: 1

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

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pjk6p_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    17	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
    16	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
    15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
    14	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
    13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
    12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
    11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    9	JFactory::getDocument()	JROOT/plugins/system/j2store/j2store.php:65
    8	plgSystemJ2Store->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:1155
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

14. Время запроса: 0.35 ms После последнего запроса: 0.15 ms Память запроса: 0.006 MB Память до запроса: 2.070 MB

    UPDATE `pjk6p_extensions`
    
      SET `params` = '{\"mediaversion\":\"6b1d58f0a4812bff7331f8eeef1e3534\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	pjk6p_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
    13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
    12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
    11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    9	JFactory::getDocument()	JROOT/plugins/system/j2store/j2store.php:65
    8	plgSystemJ2Store->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:1155
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

15. Время запроса: 0.41 ms После последнего запроса: 1.79 ms Память запроса: 0.025 MB Память до запроса: 2.135 MB Выбрано строк: 1

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

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pjk6p_languages	NULL	ALL	NULL	Индекс не используется	NULL	NULL	2	50.00	Using where; Используется filesort

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

16. Время запроса: 0.83 ms После последнего запроса: 2.57 ms Память запроса: 0.031 MB Память до запроса: 2.320 MB Выбрано строк: 38

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `pjk6p_assets`
    
      WHERE `name` IN ('root.1','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_j2store','com_jaextmanager','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper')

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pjk6p_assets	NULL	ALL	idx_asset_name	Индекс не используется	NULL	NULL	199	19.60	Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
    18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    14	JUser->authorise()	JROOT/components/com_content/models/category.php:142
    13	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:434
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/category.php:115
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php: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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

17. Время запроса: 0.52 ms После последнего запроса: 0.32 ms Память запроса: 0.034 MB Память до запроса: 2.373 MB Выбрано строк: 61

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `pjk6p_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pjk6p_assets	NULL	ALL	idx_asset_name,idx_parent_id	Индекс не используется	NULL	NULL	199	24.44	Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    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/components/com_content/models/category.php:142
    13	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:434
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/category.php:115
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php: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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

18. Время запроса: 1.54 ms После последнего запроса: 0.62 ms Память запроса: 0.037 MB Память до запроса: 2.449 MB Выбрано строк: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
    
      FROM pjk6p_categories as c
    
      LEFT JOIN pjk6p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      LEFT JOIN `pjk6p_content` AS i 
      ON i.`catid` = c.id 
      AND i.state = 1
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.published = 1 
      AND s.id=8
    
      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

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Используется filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_left_right	Индекс не используется	NULL	NULL	14	39.68	Using where
    1	SIMPLE	i	NULL	ref	idx_state,idx_catid	idx_catid	4	u0402124_default.c.id	6	100.00	Using where

    Профилирование SQL-запросов

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    starting	0.00 ms
    checking query cache for query	0.13 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.11 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.03 ms
    Creating tmp table	0.09 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.60 ms
    Creating sort index	0.06 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.06 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    storing result in query cache	0.00 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    14	JCategories->get()	JROOT/components/com_content/models/category.php:355
    13	ContentModelCategory->getCategory()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:121
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

19. Время запроса: 2.47 ms После последнего запроса: 0.91 ms Память запроса: 0.045 MB Память до запроса: 2.486 MB Выбрано строк: 2

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM pjk6p_content AS a
    
      LEFT JOIN pjk6p_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN pjk6p_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN pjk6p_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN pjk6p_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN pjk6p_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.catid = 8 OR a.catid IN (
    SELECT sub.id
    
      FROM pjk6p_categories as sub
    
      INNER JOIN pjk6p_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt
    
      WHERE this.id = 8)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-23 07:57:23') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-23 07:57:23')
    
      ORDER BY  c.lft,   
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
      LIMIT 9

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	NULL	ALL	PRIMARY,idx_access	Индекс не используется	NULL	NULL	14	10.00	Using where; Using temporary; Используется filesort
    1	PRIMARY	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	u0402124_default.c.id	6	13.12	Using index condition; Using where
    1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.created_by	1	100.00	Using where
    1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.modified_by	1	100.00	Using where
    1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.c.parent_id	1	100.00	Using where
    1	PRIMARY	v	NULL	ALL	PRIMARY	Индекс не используется	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    2	SUBQUERY	this	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
    2	SUBQUERY	sub	NULL	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	7	33.33	Using where; Using index

    Профилирование SQL-запросов

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    starting	0.00 ms
    checking query cache for query	0.19 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.35 ms
    init	0.16 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.04 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.07 ms
    Creating tmp table	0.12 ms
    Sorting result	0.01 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.10 ms
    executing	0.00 ms
    Sending data	0.67 ms
    Creating sort index	0.08 ms
    end	0.01 ms
    query end	0.03 ms
    removing tmp table	0.04 ms
    query end	0.01 ms
    closing tables	0.05 ms
    freeing items	0.01 ms
    removing tmp table	0.00 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.03 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

20. Время запроса: 1.06 ms После последнего запроса: 0.66 ms Память запроса: 0.037 MB Память до запроса: 2.638 MB Выбрано строк: 1

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

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	Индекс не используется	NULL	NULL	17	5.88	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	u0402124_default.m.tag_id	1	100.00	Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
    15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

21. Время запроса: 0.43 ms После последнего запроса: 0.34 ms Память запроса: 0.037 MB Память до запроса: 2.667 MB Выбрано строк: 2

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

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	Индекс не используется	NULL	NULL	17	5.88	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	u0402124_default.m.tag_id	1	100.00	Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
    15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

22. Время запроса: 0.98 ms После последнего запроса: 0.37 ms Память запроса: 0.026 MB Память до запроса: 2.687 MB Выбрано строк: 1

    SELECT COUNT(*)
    
      FROM pjk6p_content AS a
    
      LEFT JOIN pjk6p_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN pjk6p_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN pjk6p_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN pjk6p_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN pjk6p_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.catid = 8 OR a.catid IN (
    SELECT sub.id
    
      FROM pjk6p_categories as sub
    
      INNER JOIN pjk6p_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt
    
      WHERE this.id = 8)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-23 07:57:23') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-23 07:57:23')

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	NULL	ALL	PRIMARY,idx_access	Индекс не используется	NULL	NULL	14	10.00	Using where
    1	PRIMARY	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	u0402124_default.c.id	6	13.12	Using index condition; Using where
    1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.created_by	1	100.00	Using where; Using index
    1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.modified_by	1	100.00	Using where; Using index
    1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.c.parent_id	1	100.00	Using where; Using index
    1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.id	1	100.00	Using where; Using index
    2	SUBQUERY	this	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
    2	SUBQUERY	sub	NULL	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	7	33.33	Using where; Using index

    Профилирование SQL-запросов

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    starting	0.00 ms
    checking query cache for query	0.09 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.13 ms
    executing	0.00 ms
    Sending data	0.23 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.01 ms
    removing tmp table	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
    16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
    15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
    14	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
    13	ContentModelCategory->getItems()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

23. Время запроса: 0.45 ms После последнего запроса: 0.34 ms Память запроса: 0.035 MB Память до запроса: 2.694 MB Выбрано строк: 0

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

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_tag_type	Индекс не используется	NULL	NULL	17	5.88	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	u0402124_default.m.tag_id	1	100.00	Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
    12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:225
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

24. Время запроса: 1.15 ms После последнего запроса: 11.74 ms Память запроса: 0.037 MB Память до запроса: 3.040 MB Выбрано строк: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM pjk6p_fields AS a
    
      LEFT JOIN `pjk6p_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN pjk6p_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN pjk6p_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN pjk6p_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN pjk6p_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `pjk6p_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 (8,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Используется filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	21	u0402124_default.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	u0402124_default.a.id	1	100.00	Using where; Using index

    Профилирование SQL-запросов

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    starting	0.01 ms
    checking query cache for query	0.14 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.32 ms
    init	0.08 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.04 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.06 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.01 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.06 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    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:326
    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/category/view.html.php:108
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

25. Время запроса: 1.44 ms После последнего запроса: 4.74 ms Память запроса: 0.038 MB Память до запроса: 3.283 MB Выбрано строк: 212

    SHOW TABLES

    План SQL-запросов (Explain)

    EXPLAIN не доступен для запроса: SHOW TABLES

    Профилирование SQL-запросов

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    checking permissions	1.04 ms
    Sending data	0.09 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    removing tmp table	0.01 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    21	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
    20	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/f0f/database/driver/joomla.php:251
    19	F0FDatabaseDriverJoomla->getTableList()	JROOT/libraries/f0f/table/table.php:2070
    18	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
    17	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:63
    16	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
    15	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:82
    14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
    13	plgContentJ2Store->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/category/view.html.php:108
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

26. Время запроса: 0.87 ms После последнего запроса: 0.25 ms Память запроса: 0.033 MB Память до запроса: 3.316 MB Выбрано строк: 20

    SHOW FULL COLUMNS 
      FROM `pjk6p_j2store_products`

    План SQL-запросов (Explain)

    EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `pjk6p_j2store_products`

    Профилирование SQL-запросов

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.21 ms
    init	0.03 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.02 ms
    Opening tables	0.22 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.04 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
    19	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2155
    18	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
    17	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:63
    16	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
    15	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:82
    14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
    13	plgContentJ2Store->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/category/view.html.php:108
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

27. Время запроса: 0.61 ms После последнего запроса: 0.31 ms Память запроса: 0.031 MB Память до запроса: 3.371 MB Выбрано строк: 5

    SHOW FULL COLUMNS 
      FROM `pjk6p_j2store_productimages`

    План SQL-запросов (Explain)

    EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `pjk6p_j2store_productimages`

    Профилирование SQL-запросов

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.12 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    Opening tables	0.20 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.03 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
    20	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2155
    19	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2353
    18	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
    17	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:63
    16	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
    15	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:82
    14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
    13	plgContentJ2Store->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/category/view.html.php:108
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

28. Время запроса: 0.59 ms После последнего запроса: 0.08 ms Память запроса: 0.031 MB Память до запроса: 3.390 MB Выбрано строк: 5

    SHOW FULL COLUMNS 
      FROM `pjk6p_j2store_manufacturers`

    План SQL-запросов (Explain)

    EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `pjk6p_j2store_manufacturers`

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
    20	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2155
    19	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2353
    18	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
    17	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:63
    16	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
    15	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:82
    14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
    13	plgContentJ2Store->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/category/view.html.php:108
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

29. Время запроса: 0.53 ms После последнего запроса: 0.12 ms Память запроса: 0.031 MB Память до запроса: 3.409 MB Выбрано строк: 5

    SHOW FULL COLUMNS 
      FROM `pjk6p_j2store_vendors`

    План SQL-запросов (Explain)

    EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `pjk6p_j2store_vendors`

    Профилирование SQL-запросов

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.18 ms
    checking permissions	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.03 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
    20	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2155
    19	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2353
    18	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
    17	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:63
    16	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
    15	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:82
    14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
    13	plgContentJ2Store->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/category/view.html.php:108
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

30. Время запроса: 0.85 ms После последнего запроса: 0.08 ms Память запроса: 0.033 MB Память до запроса: 3.428 MB Выбрано строк: 17

    SHOW FULL COLUMNS 
      FROM `pjk6p_j2store_addresses`

    План SQL-запросов (Explain)

    EXPLAIN не доступен для запроса: SHOW FULL COLUMNS FROM `pjk6p_j2store_addresses`

    Профилирование SQL-запросов

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.11 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    Opening tables	0.32 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.03 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.05 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
    20	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2155
    19	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:2353
    18	F0FTable->getQueryJoinFields()	JROOT/libraries/f0f/table/table.php:539
    17	F0FTable->__construct()	JROOT/administrator/components/com_j2store/tables/product.php:63
    16	J2StoreTableProduct->__construct()	JROOT/libraries/f0f/table/table.php:433
    15	F0FTable::getAnInstance()	JROOT/plugins/content/j2store/j2store.php:82
    14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
    13	plgContentJ2Store->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/category/view.html.php:108
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

31. Время запроса: 0.46 ms После последнего запроса: 1.64 ms Память запроса: 0.039 MB Память до запроса: 3.495 MB Выбрано строк: 0

    SELECT pjk6p_j2store_products.*,`pjk6p_j2store_productimages`.`j2store_productimage_id`,`pjk6p_j2store_productimages`.`main_image`,`pjk6p_j2store_productimages`.`thumb_image`,`pjk6p_j2store_productimages`.`additional_images`,`pjk6p_j2store_manufacturers`.`brand_desc_id`,`pjk6p_j2store_addresses`.`first_name` AS manufacturer_first_name,`pjk6p_j2store_addresses`.`last_name` AS manufacturer_last_name,`pjk6p_j2store_addresses`.`company` AS manufacturer
    
      FROM pjk6p_j2store_products
    
      LEFT JOIN `pjk6p_j2store_productimages` 
      ON `pjk6p_j2store_products`.`j2store_product_id` = `pjk6p_j2store_productimages`.`product_id`
    
      LEFT JOIN `pjk6p_j2store_manufacturers` 
      ON `pjk6p_j2store_products`.`manufacturer_id` = `pjk6p_j2store_manufacturers`.`j2store_manufacturer_id`
    
      LEFT JOIN `pjk6p_j2store_vendors` 
      ON `pjk6p_j2store_products`.`vendor_id` = `pjk6p_j2store_vendors`.`j2store_vendor_id`
    
      LEFT JOIN `pjk6p_j2store_addresses` 
      ON `pjk6p_j2store_manufacturers`.`address_id` = `pjk6p_j2store_addresses`.`j2store_address_id`
    
      WHERE `pjk6p_j2store_products`.`product_source` = 'com_content' 
      AND `pjk6p_j2store_products`.`product_source_id` = '20' 
      AND `pjk6p_j2store_products`.`enabled` = '1' 
      AND `pjk6p_j2store_products`.`visibility` = '1'

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    19	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
    18	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
    17	F0FTable->load()	JROOT/administrator/components/com_j2store/tables/product.php:91
    16	J2StoreTableProduct->load()	JROOT/administrator/components/com_j2store/tables/product.php:193
    15	J2StoreTableProduct->get_product_by_source()	JROOT/plugins/content/j2store/j2store.php:84
    14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
    13	plgContentJ2Store->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/category/view.html.php:108
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

32. Время запроса: 0.81 ms После последнего запроса: 0.17 ms Память запроса: 0.025 MB Память до запроса: 3.491 MB Выбрано строк: 1

    SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid
    
      FROM `pjk6p_contact_details` AS `contact`
    
      WHERE contact.published = 1 
      AND contact.user_id = 42

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	contact	NULL	ref	idx_state	idx_state	1	const	1	100.00	Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
    15	JDatabaseDriver->loadObject()	JROOT/plugins/content/contact/contact.php:108
    14	PlgContentContact->getContactId()	JROOT/plugins/content/contact/contact.php:60
    13	PlgContentContact->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/category/view.html.php:108
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

33. Время запроса: 0.37 ms После последнего запроса: 1.05 ms Память запроса: 0.040 MB Память до запроса: 3.522 MB Выбрано строк: 0

    SELECT pjk6p_j2store_products.*,`pjk6p_j2store_productimages`.`j2store_productimage_id`,`pjk6p_j2store_productimages`.`main_image`,`pjk6p_j2store_productimages`.`thumb_image`,`pjk6p_j2store_productimages`.`additional_images`,`pjk6p_j2store_manufacturers`.`brand_desc_id`,`pjk6p_j2store_addresses`.`first_name` AS manufacturer_first_name,`pjk6p_j2store_addresses`.`last_name` AS manufacturer_last_name,`pjk6p_j2store_addresses`.`company` AS manufacturer
    
      FROM pjk6p_j2store_products
    
      LEFT JOIN `pjk6p_j2store_productimages` 
      ON `pjk6p_j2store_products`.`j2store_product_id` = `pjk6p_j2store_productimages`.`product_id`
    
      LEFT JOIN `pjk6p_j2store_manufacturers` 
      ON `pjk6p_j2store_products`.`manufacturer_id` = `pjk6p_j2store_manufacturers`.`j2store_manufacturer_id`
    
      LEFT JOIN `pjk6p_j2store_vendors` 
      ON `pjk6p_j2store_products`.`vendor_id` = `pjk6p_j2store_vendors`.`j2store_vendor_id`
    
      LEFT JOIN `pjk6p_j2store_addresses` 
      ON `pjk6p_j2store_manufacturers`.`address_id` = `pjk6p_j2store_addresses`.`j2store_address_id`
    
      WHERE `pjk6p_j2store_products`.`product_source` = 'com_content' 
      AND `pjk6p_j2store_products`.`product_source_id` = '21' 
      AND `pjk6p_j2store_products`.`enabled` = '1' 
      AND `pjk6p_j2store_products`.`visibility` = '1'

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	NULL	no matching row in const table

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    19	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
    18	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
    17	F0FTable->load()	JROOT/administrator/components/com_j2store/tables/product.php:91
    16	J2StoreTableProduct->load()	JROOT/administrator/components/com_j2store/tables/product.php:193
    15	J2StoreTableProduct->get_product_by_source()	JROOT/plugins/content/j2store/j2store.php:84
    14	plgContentJ2Store->defaultPosition()	JROOT/plugins/content/j2store/j2store.php:60
    13	plgContentJ2Store->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/category/view.html.php:108
    10	ContentViewCategory->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:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

34. Время запроса: 1.26 ms После последнего запроса: 13.48 ms Память запроса: 0.029 MB Память до запроса: 3.767 MB Выбрано строк: 9

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM pjk6p_modules AS m
    
      LEFT JOIN pjk6p_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN pjk6p_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-23 07:57:23') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-23 07:57:23') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 126 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	Индекс не используется	NULL	NULL	85	1.18	Using where; Используется filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	u0402124_default.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	u0402124_default.m.id	2	40.00	Using where; Using index

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
    15	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:446
    14	JModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:382
    13	JModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:84
    12	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
    11	JDocumentHtml->countModules()	JROOT/plugins/system/t3/includes/core/template.php:645
    10	T3Template->countModules()	JROOT/templates/ja_elicyon/tpls/default.php:18
    9	include JROOT/templates/ja_elicyon/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:221
    8	T3Template->loadLayout()	JROOT/templates/ja_elicyon/index.php:34
    7	require JROOT/templates/ja_elicyon/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:1102
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

35. Время запроса: 1.31 ms После последнего запроса: 7.16 ms Память запроса: 0.045 MB Память до запроса: 3.858 MB Выбрано строк: 5

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM pjk6p_content AS a
    
      LEFT JOIN pjk6p_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN pjk6p_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN pjk6p_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN pjk6p_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN pjk6p_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (0,8,9) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-23 07:57:23') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-23 07:57:23')
    
      ORDER BY a.created DESC 
      LIMIT 5

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_state	1	const	41	5.76	Using index condition; Using where; Используется filesort
    1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	u0402124_default.a.catid	1	10.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.modified_by	1	100.00	Using where
    1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.c.parent_id	1	100.00	Using where
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.id	1	100.00	Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
    13	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:116
    11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
    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:1116
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

36. Время запроса: 0.61 ms После последнего запроса: 0.79 ms Память запроса: 0.039 MB Память до запроса: 4.009 MB Выбрано строк: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM pjk6p_categories as c
    
      LEFT JOIN pjk6p_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=9
    
      ORDER BY c.lft

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Используется filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	Индекс не используется	NULL	NULL	14	47.62	Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    21	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    20	JCategories->get()	JROOT/components/com_content/router.php:72
    19	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
    18	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    17	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    16	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    15	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    12	JRoute::_()	JROOT/modules/mod_articles_latest/helper.php:128
    11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
    10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
    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:1116
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

37. Время запроса: 1.12 ms После последнего запроса: 2.12 ms Память запроса: 0.046 MB Память до запроса: 4.004 MB Выбрано строк: 5

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM pjk6p_content AS a
    
      LEFT JOIN pjk6p_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN pjk6p_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN pjk6p_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN pjk6p_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN pjk6p_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (0,8,9) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-23 07:57:23') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-23 07:57:23')
    
      ORDER BY a.title ASC 
      LIMIT 5

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_state	1	const	41	5.76	Using index condition; Using where; Используется filesort
    1	SIMPLE	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	u0402124_default.a.catid	1	10.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.modified_by	1	100.00	Using where
    1	SIMPLE	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.c.parent_id	1	100.00	Using where
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.id	1	100.00	Using where

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
    14	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:228
    13	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:169
    12	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:572
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
    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:1116
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

38. Время запроса: 0.67 ms После последнего запроса: 1.16 ms Память запроса: 0.039 MB Память до запроса: 4.156 MB Выбрано строк: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM pjk6p_fields AS a
    
      LEFT JOIN `pjk6p_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN pjk6p_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN pjk6p_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN pjk6p_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN pjk6p_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `pjk6p_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_articles_category.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (8,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Используется filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	21	u0402124_default.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	u0402124_default.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	u0402124_default.a.id	1	100.00	Using where; Using index

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    23	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
    22	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    21	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    19	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    16	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
    15	JHtml::call()	JROOT/libraries/cms/html/html.php:140
    14	JHtml::_()	JROOT/modules/mod_articles_category/helper.php:308
    13	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:169
    12	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:572
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
    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:1116
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

39. Время запроса: 1.65 ms После последнего запроса: 2.68 ms Память запроса: 0.026 MB Память до запроса: 4.030 MB Выбрано строк: 3

    SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
    
      FROM `pjk6p_contentitem_tag_map` AS `m`
    
      INNER JOIN `pjk6p_tags` AS `t` 
      ON `tag_id` = t.id
    
      INNER JOIN `pjk6p_ucm_content` AS `c` 
      ON `m`.`core_content_id` = `c`.`core_content_id`
    
      WHERE `t`.`access` IN (1,1,5) 
      AND `t`.`published` = 1  
      AND `m`.`type_alias` = `c`.`core_type_alias` 
      AND `c`.`core_state` = 1 
      AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2024-04-23 07:57:23') 
      AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR  `c`.`core_publish_down` >= '2024-04-23 07:57:23')
    
      GROUP BY `tag_id`,`title`,`access`,`alias`
    
      ORDER BY `count` DESC 
      LIMIT 10

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ref	PRIMARY,tag_idx,idx_content_type	tag_idx	1	const	2	16.60	Using where; Using temporary; Используется filesort
    1	SIMPLE	m	NULL	ref	idx_tag_type,idx_core_content_id	idx_core_content_id	4	u0402124_default.c.core_content_id	1	10.00	Using where
    1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	u0402124_default.m.tag_id	1	100.00	Using where

    Профилирование SQL-запросов

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    starting	0.00 ms
    checking query cache for query	0.09 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.61 ms
    init	0.06 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.02 ms
    Creating tmp table	0.07 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.33 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.03 ms
    query end	0.00 ms
    closing tables	0.06 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.01 ms
    freeing items	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tags_popular/helper.php:127
    13	ModTagsPopularHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:169
    12	JCacheControllerCallback->get()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:602
    11	JModuleHelper::moduleCache()	JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
    10	include JROOT/modules/mod_tags_popular/mod_tags_popular.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:203
    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:1116
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---

40. Время запроса: 0.45 ms После последнего запроса: 15.37 ms Память запроса: 0.029 MB Память до запроса: 4.369 MB Выбрано строк: 81

    SELECT * 
      FROM pjk6p_acymailing_config

    План SQL-запросов (Explain)

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pjk6p_acymailing_config	NULL	ALL	NULL	Индекс не используется	NULL	NULL	81	100.00	NULL

    Профилирование SQL-запросов

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

    Стек вызовов

    #	Вызывающий объект	Файл и номер строки
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    10	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:468
    9	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1236
    8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:139
    7	plgSystemRegacymailing->onAfterRender()	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/cms.php:1122
    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

    [Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]

    ---