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

{"__default":{"session":{"counter":1,"timer":{"start":1529584124,"last":1529584124,"now":1529584124},"token":"JLlFarPidHYQ7osW6MNH03vbfDGuaeU3"},"registry":{"separator":"."},"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}}}

Время

Память

51 SQL-запросов зафиксировано 210.06 ms

1. Время запроса: 0.39 ms Память запроса: 0.019 MB Память до запроса: 1.688 MB Выбрано строк: 0

   SELECT `data`
   
     FROM `jpcxt_session`
   
     WHERE `session_id` = '232238ab828f02f1f2d5027c29a0cf43'

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

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jpcxt_session	const	PRIMARY	PRIMARY	575	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
   init	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 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.01 ms
   statistics	0.04 ms
   executing	0.00 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.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.19 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Same as call in the line below.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

2. Время запроса: 0.74 ms После последнего запроса: 1.22 ms Память запроса: 0.012 MB Память до запроса: 1.841 MB Выбрано строк: 0

   SELECT `session_id`
   
     FROM `jpcxt_session`
   
     WHERE `session_id` = '232238ab828f02f1f2d5027c29a0cf43' 
     LIMIT 1

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

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jpcxt_session	const	PRIMARY	PRIMARY	575	const	1	100.00	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
   init	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 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.04 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   executing	0.01 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.50 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.00 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Время запроса: 0.23 ms После последнего запроса: 0.20 ms Память запроса: 0.009 MB Память до запроса: 1.855 MB

   INSERT INTO `jpcxt_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('232238ab828f02f1f2d5027c29a0cf43', 0, 1, '1529584124', 0, '')

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

   EXPLAIN не доступен для запроса: INSERT INTO `jpcxt_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('232238ab828f02f1f2d5027c29a0cf43', 0, 1, '1529584124', 0, '')

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

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

   Стек вызовов

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

4. Время запроса: 0.47 ms После последнего запроса: 0.91 ms Память запроса: 0.022 MB Память до запроса: 2.042 MB Выбрано строк: 43

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

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

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

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

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   init	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 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.10 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   Sending data	0.12 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.11 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

5. Время запроса: 0.11 ms После последнего запроса: 0.67 ms Память запроса: 0.016 MB Память до запроса: 2.105 MB Выбрано строк: 2

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

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

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

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

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

   Стек вызовов

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

6. Время запроса: 0.06 ms После последнего запроса: 0.23 ms Память запроса: 0.015 MB Память до запроса: 2.125 MB Выбрано строк: 5

   SELECT id, rules
   
     FROM `jpcxt_viewlevels`

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

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

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

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

   Стек вызовов

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Время запроса: 0.70 ms После последнего запроса: 0.17 ms Память запроса: 0.015 MB Память до запроса: 2.144 MB Выбрано строк: 74

   SELECT folder AS type, element AS name, params
   
     FROM jpcxt_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jpcxt_extensions	ref	extension	extension	62	const	93	100.00	Using index condition; Using where; Используется filesort

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

   Status	Duration
   starting	0.00 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   init	0.00 ms
   checking query cache for query	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.03 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.03 ms
   preparing	0.02 ms
   Sorting result	0.00 ms
   executing	0.00 ms
   Sending data	0.00 ms
   Creating sort index	0.33 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.02 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. Время запроса: 0.16 ms После последнего запроса: 9.91 ms Память запроса: 0.020 MB Память до запроса: 2.944 MB Выбрано строк: 1
   Повторяющиеся запросы: #9

   SELECT template
   
     FROM jpcxt_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

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

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	ALL	idx_home	Индекс не используется	NULL	NULL	12	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
   init	0.00 ms
   checking query cache for query	0.00 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.01 ms
   cleaning up	0.00 ms

   Стек вызовов

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
   7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. Время запроса: 0.05 ms После последнего запроса: 0.13 ms Память запроса: 0.021 MB Память до запроса: 2.963 MB Выбрано строк: 1
   Повторяющиеся запросы: #8

   SELECT template
   
     FROM jpcxt_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

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

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	ALL	idx_home	Индекс не используется	NULL	NULL	12	100.00	Using where

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

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

   Стек вызовов

   #	Caller	File and line number
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
   7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Время запроса: 0.17 ms После последнего запроса: 2.51 ms Память запроса: 0.015 MB Память до запроса: 3.069 MB Выбрано строк: 4

    SELECT extension, file, type
    
      FROM jpcxt_rokcommon_configs
    
      ORDER BY priority

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

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

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

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

    Стек вызовов

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
    8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
    7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. Время запроса: 0.35 ms После последнего запроса: 4.51 ms Память запроса: 0.014 MB Память до запроса: 3.488 MB Выбрано строк: 1

    SELECT `enabled`
    
      FROM `jpcxt_extensions`
    
      WHERE `element` = 'com_akeeba' 
      AND `type` = 'component'

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpcxt_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; 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
    init	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 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.10 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.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.00 ms

    Стек вызовов

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:50
    7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Время запроса: 0.50 ms После последнего запроса: 4.10 ms Память запроса: 0.024 MB Память до запроса: 3.872 MB Выбрано строк: 17

    SHOW FULL COLUMNS 
      FROM `jpcxt_extensions`

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

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

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

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.13 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.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.00 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    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.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    12	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
    11	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:308
    10	JTable::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
    9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Время запроса: 0.27 ms После последнего запроса: 0.80 ms Память запроса: 0.016 MB Память до запроса: 3.947 MB Выбрано строк: 1

    SELECT `extension_id`
    
      FROM `jpcxt_extensions`
    
      WHERE type = 'component' 
      AND element = 'com_roksprocket'

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpcxt_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; 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
    init	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 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.08 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 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.00 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
    10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:49
    9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. Время запроса: 0.18 ms После последнего запроса: 0.19 ms Память запроса: 0.020 MB Память до запроса: 3.964 MB Выбрано строк: 1
    Повторяющиеся запросы: #16

    SELECT *
    
      FROM jpcxt_extensions
    
      WHERE `extension_id` = '10035'

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

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

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

    Status	Duration
    starting	0.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	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.00 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 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.00 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15. Время запроса: 0.21 ms После последнего запроса: 0.17 ms Память запроса: 0.016 MB Память до запроса: 3.977 MB Выбрано строк: 1

    SELECT `extension_id`
    
      FROM `jpcxt_extensions`
    
      WHERE type = 'module' 
      AND element = 'mod_roksprocket'

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpcxt_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	100.00	Using index condition; 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
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 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.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 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.00 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    11	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
    10	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:72
    9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. Время запроса: 0.05 ms После последнего запроса: 0.17 ms Память запроса: 0.020 MB Память до запроса: 3.993 MB Выбрано строк: 1
    Повторяющиеся запросы: #14

    SELECT *
    
      FROM jpcxt_extensions
    
      WHERE `extension_id` = '10035'

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpcxt_extensions	const	PRIMARY	PRIMARY	4	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
    init	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    10	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Время запроса: 2.02 ms После последнего запроса: 17.87 ms Память запроса: 0.035 MB Память до запроса: 4.348 MB Выбрано строк: 58

    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 jpcxt_menu AS m
    
      LEFT JOIN jpcxt_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	74	100.00	Using index condition; Using where; Используется filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.m.component_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
    init	0.00 ms
    checking query cache for query	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    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.04 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.28 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.07 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.20 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.65 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.03 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.15 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.11 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.17 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.00 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
    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:145
    11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
    10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
    8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
    7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
    6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
    5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Время запроса: 0.38 ms После последнего запроса: 14.95 ms Память запроса: 0.019 MB Память до запроса: 5.916 MB Выбрано строк: 1

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

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

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

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

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    executing	0.00 ms
    Sending data	0.03 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.00 ms

    Стек вызовов

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Время запроса: 0.73 ms После последнего запроса: 0.29 ms Память запроса: 0.012 MB Память до запроса: 5.893 MB

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

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpcxt_extensions	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.01 ms
    init	0.01 ms
    System lock	0.05 ms
    updating	0.05 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.31 ms
    query end	0.10 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Время запроса: 0.09 ms После последнего запроса: 1.02 ms Память запроса: 0.014 MB Память до запроса: 6.075 MB Выбрано строк: 2

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

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpcxt_languages	ALL	NULL	Индекс не используется	NULL	NULL	2	100.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
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    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:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Время запроса: 0.44 ms После последнего запроса: 0.54 ms Память запроса: 0.011 MB Память до запроса: 6.098 MB Выбрано строк: 10

    SELECT id, home, template, s.params
    
      FROM jpcxt_template_styles as s
    
      LEFT JOIN jpcxt_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ALL	idx_template	Индекс не используется	NULL	NULL	12	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	shahcks_shahcks.s.template,const	1	100.00	Using index condition; 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
    init	0.00 ms
    checking query cache for query	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    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.00 ms
    Sending data	0.12 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.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. Время запроса: 2.38 ms После последнего запроса: 5.46 ms Память запроса: 0.029 MB Память до запроса: 6.594 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 jpcxt_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM jpcxt_categories AS cat JOIN jpcxt_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN jpcxt_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 `jpcxt_content` AS i 
      ON i.`catid` = c.id 
      AND i.state = 1
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=18
    
      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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Используется filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	Индекс не используется	NULL	NULL	63	57.14	Using where
    1	PRIMARY	i	ref	idx_state,idx_catid	idx_catid	4	shahcks_shahcks.c.id	2	100.00	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	shahcks_shahcks.c.id	10	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	10	100.00	Using index condition; Using temporary; Используется filesort
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	63	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

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

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.16 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.07 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.00 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    Sorting result	0.00 ms
    executing	0.01 ms
    Sending data	0.04 ms
    executing	0.00 ms
    Sending data	0.17 ms
    Creating sort index	0.03 ms
    removing tmp table	0.00 ms
    Creating sort index	1.07 ms
    Creating sort index	0.06 ms
    end	0.00 ms
    removing tmp table	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.08 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.00 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    13	JCategories->get()	JROOT/components/com_content/models/categories.php:115
    12	ContentModelCategories->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/libraries/legacy/view/categories.php:55
    10	JViewCategories->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Время запроса: 0.94 ms После последнего запроса: 9.54 ms Память запроса: 0.023 MB Память до запроса: 7.096 MB Выбрано строк: 9

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jpcxt_modules AS m
    
      LEFT JOIN jpcxt_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jpcxt_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2018-06-21 12:28:44') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-06-21 12:28:44') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 131 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	15	100.00	Using index condition; Using where; Используется filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	shahcks_shahcks.m.id	1	100.00	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	shahcks_shahcks.m.module,const	1	100.00	Using index condition; 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
    init	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.03 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.03 ms
    optimizing	0.03 ms
    statistics	0.12 ms
    preparing	0.03 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.27 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.06 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    13	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    12	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    9	JDocumentHtml->countModules()	JROOT/templates/dd_musicpassion_30/library/Artx/Page.php:43
    8	ArtxPage->containsModules()	JROOT/templates/dd_musicpassion_30/index.php:107
    7	require JROOT/templates/dd_musicpassion_30/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Время запроса: 0.50 ms После последнего запроса: 16.09 ms Память запроса: 0.040 MB Память до запроса: 8.036 MB Выбрано строк: 8

    SHOW FULL COLUMNS 
      FROM `jpcxt_assets`

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

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

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

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.15 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.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.02 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.00 ms

    Стек вызовов

    #	Caller	File and line number
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    29	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    28	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    27	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    26	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    25	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    24	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    23	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    22	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    21	JUser->authorise()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:48
    20	RokSprocket_Provider_Joomla_Filter->setAccessWhere()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:112
    19	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Same as call in the line below.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25. Время запроса: 0.11 ms После последнего запроса: 0.31 ms Память запроса: 0.035 MB Память до запроса: 8.095 MB Выбрано строк: 1

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

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpcxt_assets	const	PRIMARY	PRIMARY	4	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.01 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    25	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    24	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    23	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    22	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    21	JUser->authorise()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:48
    20	RokSprocket_Provider_Joomla_Filter->setAccessWhere()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:112
    19	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Same as call in the line below.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

26. Время запроса: 0.06 ms После последнего запроса: 0.23 ms Память запроса: 0.031 MB Память до запроса: 8.123 MB Выбрано строк: 1

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

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

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

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

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

    Стек вызовов

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    23	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    22	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    21	JUser->authorise()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:48
    20	RokSprocket_Provider_Joomla_Filter->setAccessWhere()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:112
    19	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Same as call in the line below.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

27. Время запроса: 0.72 ms После последнего запроса: 0.74 ms Память запроса: 0.034 MB Память до запроса: 8.166 MB Выбрано строк: 43

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

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpcxt_extensions	ref	extension	extension	62	const	43	100.00	Using index condition; 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
    init	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 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.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.20 ms
    end	0.02 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.21 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.00 ms

    Стек вызовов

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    25	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    24	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    23	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    22	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    21	JUser->authorise()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:48
    20	RokSprocket_Provider_Joomla_Filter->setAccessWhere()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:112
    19	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Same as call in the line below.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

28. Время запроса: 0.10 ms После последнего запроса: 0.31 ms Память запроса: 0.034 MB Память до запроса: 8.207 MB Выбрано строк: 43

    SELECT a.name, a.rules
    
      FROM jpcxt_assets AS a
    
      WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_finder','com_installer','com_jce','com_jevents','com_joomgallery','com_joomlaupdate','com_jsecure','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_rokgallery','com_roksprocket','com_search','com_sexypolling','com_sigpro','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap') OR a.name = 'root.1')

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ALL	idx_asset_name	Индекс не используется	NULL	NULL	335	13.13	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
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    25	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    24	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    23	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    22	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    21	JUser->authorise()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:48
    20	RokSprocket_Provider_Joomla_Filter->setAccessWhere()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:112
    19	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Same as call in the line below.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

29. Время запроса: 1.89 ms После последнего запроса: 3.06 ms Память запроса: 0.037 MB Память до запроса: 8.700 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 jpcxt_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM jpcxt_categories AS cat JOIN jpcxt_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN jpcxt_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 badcats.id is null 
      AND s.id=18
    
      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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Используется filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	Индекс не используется	NULL	NULL	63	57.14	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	shahcks_shahcks.c.id	10	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	10	100.00	Using index condition; Using temporary; Используется filesort
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	63	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

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

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 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.00 ms
    Opening tables	0.09 ms
    init	0.10 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.00 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.03 ms
    Creating tmp table	0.02 ms
    Sorting result	0.02 ms
    statistics	0.15 ms
    preparing	0.05 ms
    Creating tmp table	0.07 ms
    Sorting result	0.00 ms
    executing	0.01 ms
    Sending data	0.03 ms
    executing	0.00 ms
    Sending data	0.22 ms
    Creating sort index	0.03 ms
    removing tmp table	0.00 ms
    Creating sort index	0.42 ms
    Creating sort index	0.05 ms
    end	0.00 ms
    removing tmp table	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	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.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.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    21	JCategories->get()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:134
    20	RokSprocket_Provider_Joomla_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
    19	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Same as call in the line below.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

30. Время запроса: 2.20 ms После последнего запроса: 0.35 ms Память запроса: 0.044 MB Память до запроса: 8.737 MB Выбрано строк: 16

    SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
    
      FROM jpcxt_content as a
    
      LEFT JOIN jpcxt_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jpcxt_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jpcxt_users AS um 
      ON um.id = a.modified_by
    
      LEFT JOIN jpcxt_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT JOIN jpcxt_viewlevels AS vl 
      ON a.access = vl.id
    
      LEFT JOIN jpcxt_languages AS l 
      ON a.language = l.lang_code
    
      LEFT JOIN jpcxt_contentitem_tag_map AS ct 
      ON ct.content_item_id = a.id
    
      LEFT JOIN jpcxt_tags AS t 
      ON t.id = ct.tag_id
    
      LEFT 
      OUTER JOIN (select rsi.provider_id, rsi.
      order 
      from jpcxt_roksprocket_items as rsi 
      where module_id = 132) rsi 
      on a.id = rsi.provider_id
    
      WHERE ((a.access IN(1,1,5) 
      AND (a.state = 1 or a.state = 2) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-21 12:28:44') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-21 12:28:44') 
      AND (a.state != -2)) 
      AND a.catid IN (18))
    
      GROUP BY id
    
      ORDER BY IF(ISNULL(rsi.
      order),1,0),rsi.
      order

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	ref	PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference	idx_catid	4	const	16	100.00	Using where; Using temporary; Используется filesort
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.a.created_by	1	100.00	Using where
    1	PRIMARY	um	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.a.modified_by	1	100.00	Using where
    1	PRIMARY	v	ALL	PRIMARY	Индекс не используется	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	PRIMARY	vl	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.a.access	1	100.00	NULL
    1	PRIMARY	l	ALL	idx_langcode	Индекс не используется	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
    1	PRIMARY	ct	index	NULL	idx_core_content_id	4	NULL	1	100.00	Using where; Using index; Using join buffer (Block Nested Loop)
    1	PRIMARY	t	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.ct.tag_id	1	100.00	Using index
    1	PRIMARY	<derived2>	ALL	NULL	Индекс не используется	NULL	NULL	40	100.00	Using where; Using join buffer (Block Nested Loop)
    2	DERIVED	rsi	ALL	idx_module,idx_module_order	Индекс не используется	NULL	NULL	40	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
    init	0.00 ms
    checking query cache for query	0.13 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.09 ms
    System lock	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.05 ms
    optimizing	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.03 ms
    statistics	0.13 ms
    preparing	0.06 ms
    Creating tmp table	0.05 ms
    Sorting result	0.00 ms
    executing	0.01 ms
    Sending data	0.24 ms
    executing	0.00 ms
    Sending data	0.48 ms
    Creating sort index	0.07 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.33 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.06 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Creating sort index	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.06 ms
    Creating sort index	0.03 ms
    end	0.01 ms
    removing tmp table	0.05 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 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.03 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Same as call in the line below.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

31. Время запроса: 0.26 ms После последнего запроса: 0.75 ms Память запроса: 0.029 MB Память до запроса: 8.901 MB Выбрано строк: 0

    SELECT ct.content_item_id as article_id, t.title as tag
    
      FROM jpcxt_contentitem_tag_map as ct
    
      LEFT JOIN jpcxt_tags AS t 
      ON t.id = ct.tag_id
    
      WHERE ct.content_item_id in (91,103,94,92,95,98,99,100,97,101,106,105,102,104,96,93)

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ct	index	NULL	idx_core_content_id	4	NULL	1	100.00	Using where; Using index
    1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.ct.tag_id	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
    init	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.03 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.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 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.00 ms

    Стек вызовов

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    21	JDatabaseDriver->loadAssocList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26
    20	RokSprocket_Provider_Joomla_TagMerge->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159
    19	RokSprocket_Provider_Joomla->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Same as call in the line below.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

32. Время запроса: 0.66 ms После последнего запроса: 15.65 ms Память запроса: 0.028 MB Память до запроса: 9.226 MB Выбрано строк: 16

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM jpcxt_roksprocket_items as i
    
      WHERE i.module_id = '132' 
      AND i.provider = 'joomla'

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	15	100.00	Using index condition; 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
    init	0.00 ms
    checking query cache for query	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.14 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.03 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.12 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.05 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.03 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.00 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139
    19	RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Same as call in the line below.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

33. Время запроса: 1.53 ms После последнего запроса: 34.75 ms Память запроса: 0.033 MB Память до запроса: 9.424 MB Выбрано строк: 1

    SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
    
      FROM jpcxt_content as a
    
      LEFT JOIN jpcxt_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jpcxt_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jpcxt_users AS um 
      ON um.id = a.modified_by
    
      LEFT JOIN jpcxt_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT JOIN jpcxt_viewlevels AS vl 
      ON a.access = vl.id
    
      LEFT JOIN jpcxt_languages AS l 
      ON a.language = l.lang_code
    
      LEFT JOIN jpcxt_contentitem_tag_map AS ct 
      ON ct.content_item_id = a.id
    
      LEFT JOIN jpcxt_tags AS t 
      ON t.id = ct.tag_id
    
      LEFT 
      OUTER JOIN (select rsi.provider_id, rsi.
      order 
      from jpcxt_roksprocket_items as rsi 
      where module_id = 112) rsi 
      on a.id = rsi.provider_id
    
      WHERE ((a.access IN(1,1,5) 
      AND (a.state = 1 or a.state = 2) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-06-21 12:28:44') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-06-21 12:28:44') 
      AND (a.state != -2)) 
      AND a.id IN (190,189))
    
      GROUP BY id
    
      ORDER BY IF(ISNULL(rsi.
      order),1,0),rsi.
      order,a.title ASC

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	range	PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference	PRIMARY	4	NULL	2	100.00	Using where; Using temporary; Используется filesort
    1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.a.catid	1	100.00	Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.a.created_by	1	100.00	Using where
    1	PRIMARY	um	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.a.modified_by	1	100.00	Using where
    1	PRIMARY	v	ALL	PRIMARY	Индекс не используется	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	PRIMARY	vl	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.a.access	1	100.00	NULL
    1	PRIMARY	l	ALL	idx_langcode	Индекс не используется	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
    1	PRIMARY	ct	index	NULL	idx_core_content_id	4	NULL	1	100.00	Using where; Using index; Using join buffer (Block Nested Loop)
    1	PRIMARY	t	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.ct.tag_id	1	100.00	Using index
    1	PRIMARY	<derived2>	ALL	NULL	Индекс не используется	NULL	NULL	40	100.00	Using where; Using join buffer (Block Nested Loop)
    2	DERIVED	rsi	ALL	idx_module,idx_module_order	Индекс не используется	NULL	NULL	40	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
    init	0.00 ms
    checking query cache for query	0.15 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 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.06 ms
    optimizing	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.03 ms
    statistics	0.13 ms
    preparing	0.05 ms
    Creating tmp table	0.04 ms
    Sorting result	0.00 ms
    executing	0.01 ms
    Sending data	0.13 ms
    executing	0.00 ms
    Sending data	0.17 ms
    Creating sort index	0.04 ms
    end	0.00 ms
    removing tmp table	0.03 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.00 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.21 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.00 ms

    Стек вызовов

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Same as call in the line below.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

34. Время запроса: 0.07 ms После последнего запроса: 0.45 ms Память запроса: 0.029 MB Память до запроса: 9.466 MB Выбрано строк: 0

    SELECT ct.content_item_id as article_id, t.title as tag
    
      FROM jpcxt_contentitem_tag_map as ct
    
      LEFT JOIN jpcxt_tags AS t 
      ON t.id = ct.tag_id
    
      WHERE ct.content_item_id in (190)

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ct	index	NULL	idx_core_content_id	4	NULL	1	100.00	Using where; Using index
    1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.ct.tag_id	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
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    21	JDatabaseDriver->loadAssocList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26
    20	RokSprocket_Provider_Joomla_TagMerge->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159
    19	RokSprocket_Provider_Joomla->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Same as call in the line below.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

35. Время запроса: 0.09 ms После последнего запроса: 0.63 ms Память запроса: 0.039 MB Память до запроса: 9.508 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 jpcxt_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM jpcxt_categories AS cat JOIN jpcxt_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN jpcxt_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 badcats.id is null 
      AND s.id=28
    
      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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Используется filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	Индекс не используется	NULL	NULL	63	57.14	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	shahcks_shahcks.c.id	10	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	10	100.00	Using index condition; Using temporary; Используется filesort
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	63	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

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

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

    Стек вызовов

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    23	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    22	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    21	ContentHelperRoute::getArticleRoute()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:93
    20	RokSprocket_Provider_Joomla->convertRawToItem()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:83
    19	RokSprocket_Provider_AbstarctJoomlaBasedProvider->convertRawToItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:63
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Same as call in the line below.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

36. Время запроса: 0.06 ms После последнего запроса: 0.56 ms Память запроса: 0.028 MB Память до запроса: 9.543 MB Выбрано строк: 2

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM jpcxt_roksprocket_items as i
    
      WHERE i.module_id = '112' 
      AND i.provider = 'joomla'

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	2	100.00	Using index condition; 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
    init	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139
    19	RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Same as call in the line below.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

37. Время запроса: 0.13 ms После последнего запроса: 6.16 ms Память запроса: 0.032 MB Память до запроса: 9.547 MB Выбрано строк: 3

    SELECT sp.id polling_id, sp.id_template id_template, sp.date_start date_start, sp.date_end date_end, sp.showresultsduringpoll showresultsduringpoll, sp.multiple_answers multiple_answers, sp.voting_period voting_period, sp.number_answers number_answers, sp.voting_permission voting_permission, sp.answerpermission answerpermission, sp.autopublish autopublish, sp.baranimationtype baranimationtype, sp.coloranimationtype coloranimationtype, sp.reorderinganimationtype reorderinganimationtype, sp.dateformat dateformat, sp.autoopentimeline autoopentimeline, sp.autoanimate autoanimate, sp.showresultbutton showresultbutton, sp.showvotesperiod showvotesperiod, sp.stringdateformat stringdateformat, sp.votescountformat votescountformat, sp.scaledefault scaledefault, sp.showaddanswericon showaddanswericon, sp.showscaleicon showscaleicon, sp.showbackicon showbackicon, sp.showtimelineicon showtimelineicon, sp.showtimeline showtimeline, sp.showvotescountinfo showvotescountinfo, sp.poll_width poll_width, sp.pollalign pollalign, sp.addclearboth addclearboth, sp.poll_margintop poll_margintop, sp.poll_marginbottom poll_marginbottom, sp.poll_marginleft poll_marginleft, sp.poll_marginright poll_marginright, sp.classsuffix classsuffix, sp.checktoken checktoken, sp.ipcount ipcount, sp.checkacl checkacl, sp.votechecks votechecks, st.styles styles, sp.name polling_name, sp.question polling_question, sa.id answer_id, sa.show_name show_name, sa.img_name img_name, sa.img_url img_url, sa.img_width img_width, sa.embed embed, sa.name answer_name 
      FROM `jpcxt_sexy_polls` sp JOIN `jpcxt_sexy_answers` sa 
      ON sa.id_poll = sp.id 
      AND sa.published = '1' 
      LEFT JOIN `jpcxt_sexy_templates` st 
      ON st.id = sp.id_template 
      WHERE sp.published = '1' 
      AND sp.id_category = 2 
      ORDER BY sp.ordering,sp.name,sa.ordering,sa.name

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sp	ref	PRIMARY,id_category	id_category	3	const	1	100.00	Using where; Using temporary; Используется filesort
    1	SIMPLE	st	eq_ref	PRIMARY	PRIMARY	3	shahcks_shahcks.sp.id_template	1	100.00	NULL
    1	SIMPLE	sa	ref	id_poll	id_poll	4	shahcks_shahcks.sp.id	3	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
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_sexypolling/helpers/helper.php:133
    12	SexypollingHelper->get_data()	JROOT/components/com_sexypolling/helpers/helper.php:160
    11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
    10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

38. Время запроса: 0.09 ms После последнего запроса: 1.21 ms Память запроса: 0.019 MB Память до запроса: 9.657 MB Выбрано строк: 1
    Повторяющиеся запросы: #39

    SELECT `rules` 
      FROM jpcxt_viewlevels 
      WHERE id = '6'

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpcxt_viewlevels	const	PRIMARY	PRIMARY	4	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
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_sexypolling/helpers/helper.php:241
    11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
    10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

39. Время запроса: 0.06 ms После последнего запроса: 0.09 ms Память запроса: 0.019 MB Память до запроса: 9.675 MB Выбрано строк: 1
    Повторяющиеся запросы: #38

    SELECT `rules` 
      FROM jpcxt_viewlevels 
      WHERE id = '6'

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

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

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

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

    Стек вызовов

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/components/com_sexypolling/helpers/helper.php:242
    11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
    10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

40. Время запроса: 0.06 ms После последнего запроса: 0.15 ms Память запроса: 0.019 MB Память до запроса: 9.692 MB Выбрано строк: 1
    Повторяющиеся запросы: #41

    SELECT `rules` 
      FROM jpcxt_viewlevels 
      WHERE id = '1'

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

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

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

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

    Стек вызовов

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_sexypolling/helpers/helper.php:254
    11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
    10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

41. Время запроса: 0.05 ms После последнего запроса: 0.09 ms Память запроса: 0.019 MB Память до запроса: 9.709 MB Выбрано строк: 1
    Повторяющиеся запросы: #40

    SELECT `rules` 
      FROM jpcxt_viewlevels 
      WHERE id = '1'

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

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

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

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

    Стек вызовов

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/components/com_sexypolling/helpers/helper.php:255
    11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
    10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

42. Время запроса: 0.05 ms После последнего запроса: 0.14 ms Память запроса: 0.019 MB Память до запроса: 9.726 MB Выбрано строк: 0
    Повторяющиеся запросы: #43

    SELECT sv.`ip`,sv.`date` 
      FROM jpcxt_sexy_votes sv JOIN jpcxt_sexy_answers sa 
      ON sa.id_poll = '2' 
      WHERE sv.id_answer = sa.id 
      AND sv.ip = '54.158.30.219' 
      ORDER BY sv.`date` DESC 
      LIMIT 1

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sa	ref	PRIMARY,id_poll	id_poll	4	const	2	100.00	Using temporary; Используется filesort
    1	SIMPLE	sv	ref	id_answer	id_answer	4	shahcks_shahcks.sa.id	28	100.00	Using where

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

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

    Стек вызовов

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_sexypolling/helpers/helper.php:303
    11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
    10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

43. Время запроса: 0.05 ms После последнего запроса: 0.08 ms Память запроса: 0.019 MB Память до запроса: 9.743 MB Выбрано строк: 0
    Повторяющиеся запросы: #42

    SELECT sv.`ip`,sv.`date` 
      FROM jpcxt_sexy_votes sv JOIN jpcxt_sexy_answers sa 
      ON sa.id_poll = '2' 
      WHERE sv.id_answer = sa.id 
      AND sv.ip = '54.158.30.219' 
      ORDER BY sv.`date` DESC 
      LIMIT 1

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sa	ref	PRIMARY,id_poll	id_poll	4	const	2	100.00	Using temporary; Используется filesort
    1	SIMPLE	sv	ref	id_answer	id_answer	4	shahcks_shahcks.sa.id	28	100.00	Using where

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

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

    Стек вызовов

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    12	JDatabaseDriver->loadAssoc()	JROOT/components/com_sexypolling/helpers/helper.php:305
    11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
    10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

44. Время запроса: 0.09 ms После последнего запроса: 0.59 ms Память запроса: 0.019 MB Память до запроса: 9.782 MB Выбрано строк: 1

    SELECT COUNT(sv.`id_answer`) total_count, MAX(sv.`date`) max_date,MIN(sv.`date`) min_date 
      FROM `jpcxt_sexy_votes` sv JOIN `jpcxt_sexy_answers` sa 
      ON sa.id_poll = '2' 
      WHERE sv.id_answer = sa.id

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sa	ref	PRIMARY,id_poll	id_poll	4	const	2	100.00	NULL
    1	SIMPLE	sv	ref	id_answer	id_answer	4	shahcks_shahcks.sa.id	28	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
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    12	JDatabaseDriver->loadAssoc()	JROOT/components/com_sexypolling/helpers/helper.php:444
    11	SexypollingHelper->render_html()	JROOT/modules/mod_sexypolling/mod_sexypolling.php:32
    10	include JROOT/modules/mod_sexypolling/mod_sexypolling.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

45. Время запроса: 0.60 ms После последнего запроса: 21.00 ms Память запроса: 0.037 MB Память до запроса: 10.380 MB Выбрано строк: 18

    SHOW FULL COLUMNS 
      FROM `jpcxt_jev_users`

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

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

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

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.15 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.06 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    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.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 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.00 ms

    Стек вызовов

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    23	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    22	JTable->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:69
    21	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:2173
    20	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1094
    19	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:50
    18	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:140
    17	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:198
    16	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2252
    15	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2623
    14	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:243
    13	JEventsDataModel->getCalendarData()	JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:77
    12	FlatModCalView->_displayCalendarMod()	JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:491
    11	DefaultModCalView->getCal()	JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46
    10	include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

46. Время запроса: 0.11 ms После последнего запроса: 1.86 ms Память запроса: 0.041 MB Память до запроса: 10.517 MB Выбрано строк: 10

    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 jpcxt_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM jpcxt_categories AS cat JOIN jpcxt_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_jevents' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE (c.extension='com_jevents' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND badcats.id is null
    
      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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	ALL	cat_idx,idx_access	Индекс не используется	NULL	NULL	63	19.05	Using where; Using temporary; Используется filesort
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	shahcks_shahcks.c.id	10	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Используется filesort
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	63	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

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

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

    Стек вызовов

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    23	JCategories->_load()	JROOT/components/com_jevents/helpers/category.php:47
    22	JEventsCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    21	JCategories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:90
    20	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
    19	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
    18	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:140
    17	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:198
    16	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2252
    15	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2623
    14	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:243
    13	JEventsDataModel->getCalendarData()	JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:77
    12	FlatModCalView->_displayCalendarMod()	JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:491
    11	DefaultModCalView->getCal()	JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46
    10	include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

47. Время запроса: 0.11 ms После последнего запроса: 0.69 ms Память запроса: 0.029 MB Память до запроса: 10.618 MB Выбрано строк: 9

    SELECT c.id
    
      FROM jpcxt_categories AS c
    
      WHERE c.access   IN (1,1,5)
     
      AND c.published = 1
      
      AND c.language in ('ru-RU','*')
     
      AND c.extension = 'com_jevents'
     
    
      ORDER BY c.lft asc

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	157	NULL	10	100.00	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
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    21	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:160
    20	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
    19	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
    18	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:140
    17	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:198
    16	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2252
    15	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2623
    14	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:243
    13	JEventsDataModel->getCalendarData()	JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:77
    12	FlatModCalView->_displayCalendarMod()	JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:491
    11	DefaultModCalView->getCal()	JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46
    10	include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

48. Время запроса: 0.15 ms После последнего запроса: 0.91 ms Память запроса: 0.044 MB Память до запроса: 10.657 MB Выбрано строк: 0

    SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created 
     , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
     , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
     , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
     , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
     
      FROM jpcxt_jevents_repetition as rpt
     
      LEFT JOIN jpcxt_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id
     
      LEFT JOIN jpcxt_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid 
     
      LEFT JOIN jpcxt_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN jpcxt_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid
     
      WHERE ev.catid IN(-1,54,55,56,57,58,59,60,61,62)
     
      AND rpt.endrepeat >= '2018-06-01 00:00:00' 
      AND rpt.startrepeat <= '2018-06-30 23:59:59'
     
      AND NOT (rpt.startrepeat < '2018-06-01 00:00:00' 
      AND det.multiday=0)  
      AND ev.state=1
     
      AND ev.access IN (1,1,5)  
      AND icsf.state=1 
      AND icsf.access IN (1,1,5)

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	icsf	system	PRIMARY,stateidx	Индекс не используется	NULL	NULL	1	100.00	NULL
    1	SIMPLE	rpt	range	eventid,eventstart,eventend,startrepeat,startend,endrepeat	endrepeat	8	NULL	2	100.00	Using index condition; Using where
    1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	shahcks_shahcks.rpt.eventid	1	100.00	Using where
    1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	shahcks_shahcks.rpt.eventdetail_id	1	100.00	Using where
    1	SIMPLE	rr	ref	eventid	eventid	4	shahcks_shahcks.rpt.eventid	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
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2499
    16	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2448
    15	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2623
    14	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:243
    13	JEventsDataModel->getCalendarData()	JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:77
    12	FlatModCalView->_displayCalendarMod()	JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:491
    11	DefaultModCalView->getCal()	JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:46
    10	include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php	JROOT/libraries/cms/module/helper.php:199
    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:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

49. Время запроса: 187.54 ms После последнего запроса: 64.30 ms Память запроса: 14.642 MB Память до запроса: 11.203 MB Выбрано строк: 191681

    select * 
      from jpcxt_jvcounter_logs

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

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

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

    Status	Duration
    Waiting on query cache mutex	0.00 ms
    Sending data	0.10 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.12 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.17 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.08 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.10 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.06 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.10 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.04 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.06 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.13 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.10 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.04 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.06 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.06 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.06 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.10 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.11 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.10 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.04 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.08 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.09 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.05 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.05 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.12 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.05 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.06 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.02 ms
    Sending data	0.13 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.04 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.10 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.11 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	0.12 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    Sending data	172.50 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvcounter/jvcounter.php:107
    10	plgSystemJVCounter->getDataLogs()	JROOT/plugins/system/jvcounter/jvcounter.php:48
    9	plgSystemJVCounter->saveData()	JROOT/plugins/system/jvcounter/jvcounter.php:24
    8	plgSystemJVCounter->onAfterRender()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

50. Время запроса: 0.31 ms После последнего запроса: 923.42 ms Память запроса: 0.018 MB Память до запроса: 418.406 MB Выбрано строк: 1

    select * 
      from jpcxt_session  
      where session_id = '232238ab828f02f1f2d5027c29a0cf43' 
      and client_id=0

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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jpcxt_session	const	PRIMARY	PRIMARY	575	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
    init	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 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.03 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 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.51 ms
    cleaning up	0.00 ms

    Стек вызовов

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jvcounter/jvcounter.php:123
    10	plgSystemJVCounter->getSession()	JROOT/plugins/system/jvcounter/jvcounter.php:50
    9	plgSystemJVCounter->saveData()	JROOT/plugins/system/jvcounter/jvcounter.php:24
    8	plgSystemJVCounter->onAfterRender()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

51. Время запроса: 0.77 ms После последнего запроса: 0.16 ms Память запроса: 0.013 MB Память до запроса: 418.423 MB

    INSERT INTO jpcxt_jvcounter_logs (session_id,user_id,ip,timestart,timelast,counter,browser,timezone,lasturl) 
      VALUES('232238ab828f02f1f2d5027c29a0cf43','0','54.158.30.219','1529584124','1529584124','0','CCBot/2.0 (http://commoncrawl.org/faq/)','','')

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

    EXPLAIN не доступен для запроса: INSERT INTO jpcxt_jvcounter_logs (session_id,user_id,ip,timestart,timelast,counter,browser,timezone,lasturl) VALUES('232238ab828f02f1f2d5027c29a0cf43','0','54.158.30.219','1529584124','1529584124','0','CCBot/2.0 (http://commoncrawl.org/faq/)','','')

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

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

    Стек вызовов

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    10	JDatabase->query()	JROOT/plugins/system/jvcounter/jvcounter.php:95
    9	plgSystemJVCounter->saveData()	JROOT/plugins/system/jvcounter/jvcounter.php:24
    8	plgSystemJVCounter->onAfterRender()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---