Цепные пилы, косы, газонокосилки бензиновые

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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1600773241,
                "last": 1600773241,
                "now": 1600773241
            },
            "token": "JtqdnFinDFezdS3hZeUVxoqFu5jZIcWZ"
        },
        "registry": {
            "com_virtuemart": {
                "customfields": "",
                "category": {
                    "limit": "24"
                },
                "categoryc15m0": {
                    "limitstart": 0
                }
            }
        },
        "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
        },
        "afterburner2-edd88cc045b4eae83b92f2f708be37d0-name": null,
        "afterburner2-edd88cc045b4eae83b92f2f708be37d0-headerstyle": null,
        "afterburner2-edd88cc045b4eae83b92f2f708be37d0-menustyle": null,
        "afterburner2-edd88cc045b4eae83b92f2f708be37d0-footerstyle": null,
        "afterburner2-edd88cc045b4eae83b92f2f708be37d0-layout-mode": null
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedItemid": 188,
        "vmlastvisitedcategoryid": 15,
        "vmlastvisitedmanuid": -1
    }
}

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

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

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN не доступен для запроса: INSERT INTO `rc29b_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3630373837333966323466393433366161316536376362316139636161386530', 1, 1600773241, 0, '', 0)

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

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
update	0.11 ms
end	0.00 ms
query end	0.09 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Время запроса: 0.99 ms После последнего запроса: 2.01 ms Память запроса: 0.036 MB Память до запроса: 1.345 MB Выбрано строк: 42

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

  FROM `rc29b_extensions`

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rc29b_extensions	NULL	ref	extension	extension	82	const	44	1.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Так же, как вызов в строке ниже.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.37 ms После последнего запроса: 1.72 ms Память запроса: 0.022 MB Память до запроса: 1.387 MB Выбрано строк: 3

SELECT id, rules

  FROM `rc29b_viewlevels`

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.30 ms После последнего запроса: 0.12 ms Память запроса: 0.022 MB Память до запроса: 1.398 MB Выбрано строк: 1

SELECT b.id

  FROM rc29b_usergroups AS a

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

  WHERE a.id = 1

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

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

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

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.00 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.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.59 ms После последнего запроса: 0.67 ms Память запроса: 0.034 MB Память до запроса: 1.424 MB Выбрано строк: 112

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

  FROM rc29b_extensions

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

  ORDER BY ordering

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

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

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

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.35 ms После последнего запроса: 15.25 ms Память запроса: 0.022 MB Память до запроса: 2.077 MB Выбрано строк: 1

SELECT `lastupdate`

  FROM `rc29b_ak_storage`

  WHERE `tag` = 'akeebaupdatecheck_lastrun'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/akeebaupdatecheck/akeebaupdatecheck.php:79
8	plgSystemAkeebaupdatecheck->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.03 ms После последнего запроса: 1.97 ms Память запроса: 0.122 MB Память до запроса: 2.186 MB Выбрано строк: 5

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

  LEFT JOIN rc29b_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	45	3.33	Using index condition; Using where; Используется filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	maikl_centr.m.component_id	1	100.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Так же, как вызов в строке ниже.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.10 ms После последнего запроса: 5.65 ms Память запроса: 0.024 MB Память до запроса: 2.529 MB Выбрано строк: 1

SHOW TABLES LIKE "rc29b_virtuemart_configs"

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

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

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

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 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
checking permissions	0.84 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:722
14	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:563
13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:774
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.33 ms После последнего запроса: 0.19 ms Память запроса: 0.024 MB Память до запроса: 2.537 MB Выбрано строк: 1

SELECT `config` 
  FROM `rc29b_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 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.03 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:814
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.51 ms После последнего запроса: 0.87 ms Память запроса: 0.029 MB Память до запроса: 2.590 MB Выбрано строк: 2

SELECT *

  FROM rc29b_languages

  WHERE published=1

  ORDER BY ordering ASC

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

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

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

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.15 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
15	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:90
14	vmLanguage::setLanguageByTag()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:56
13	vmLanguage::initialise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:835
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.08 ms После последнего запроса: 0.68 ms Память запроса: 0.032 MB Память до запроса: 2.609 MB Выбрано строк: 42

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

  FROM `rc29b_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_cmsupdate','com_config','com_contactus','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry','com_installer','com_jaextmanager','com_jmap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper')

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

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

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

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.23 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.33 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1173
14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.71 ms После последнего запроса: 1.66 ms Память запроса: 0.025 MB Память до запроса: 2.692 MB Выбрано строк: 4

Повторяющиеся запросы: #52

SELECT id, home, template, s.params

  FROM rc29b_template_styles as s

  LEFT JOIN rc29b_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template,idx_client_id,idx_client_id_home	Индекс не используется	NULL	NULL	7	57.14	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	maikl_centr.s.template,const	1	4.57	Using index condition; Using where

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

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.11 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
13	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_virtuemart/router.php:842
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:889
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.41 ms После последнего запроса: 0.66 ms Память запроса: 0.023 MB Память до запроса: 2.712 MB Выбрано строк: 1

SELECT `id` 
  FROM `rc29b_menu` 
  WHERE `home`="1" 
  and (language="*" or language = "ru-RU" ) 
  ORDER BY `language` DESC

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

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

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

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.13 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:853
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:889
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.82 ms После последнего запроса: 0.07 ms Память запроса: 0.090 MB Память до запроса: 2.720 MB Выбрано строк: 3

SELECT * 
  FROM `rc29b_menu` 
  WHERE `link` like "index.php?option=com_virtuemart%" 
  and client_id=0 
  and published=1 
  and (language="*" or language = "ru-RU" ) 
  AND ( access="1" )  
  ORDER BY `language` DESC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rc29b_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	46	1.12	Using index condition; Using where; Используется filesort

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

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.47 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1274
13	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:860
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:889
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.49 ms После последнего запроса: 0.28 ms Память запроса: 0.024 MB Память до запроса: 2.732 MB Выбрано строк: 1

SELECT l.virtuemart_category_id  
  FROM `rc29b_virtuemart_categories_ru_ru` as l  
  WHERE l.slug = "2014-03-16-18-42-21_"

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	l	NULL	const	slug	slug	578	const	1	100.00	NULL

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

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 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.03 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1209
12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1042
11	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:738
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.65 ms После последнего запроса: 1.48 ms Память запроса: 0.036 MB Память до запроса: 2.787 MB Выбрано строк: 1

SELECT `rc29b_virtuemart_categories`.* ,`rc29b_virtuemart_categories_ru_ru`.*  
  FROM `rc29b_virtuemart_categories` 
  INNER JOIN `rc29b_virtuemart_categories_ru_ru` using (`virtuemart_category_id`) 
  WHERE `rc29b_virtuemart_categories`.`virtuemart_category_id` = "15"

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

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

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

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.06 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.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:89
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:922
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:742
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.31 ms После последнего запроса: 0.60 ms Память запроса: 0.024 MB Память до запроса: 2.881 MB Выбрано строк: 1

SELECT `virtuemart_media_id` 
  FROM `rc29b_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "15" 
  ORDER BY `ordering`

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rc29b_virtuemart_category_medias	NULL	ref	virtuemart_category_id,ordering	ordering	4	const	1	100.00	Using index condition

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:92
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:922
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:742
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.25 ms После последнего запроса: 0.08 ms Память запроса: 0.024 MB Память до запроса: 2.889 MB Выбрано строк: 3

SELECT `category_child_id`
			
  FROM `rc29b_virtuemart_category_categories`
			
  WHERE `category_parent_id` = 15

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rc29b_virtuemart_category_categories	NULL	ref	category_parent_id	category_parent_id	4	const	2	100.00	Using index

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 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.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_virtuemart/models/category.php:676
13	VirtueMartModelCategory->hasChildren()	JROOT/administrator/components/com_virtuemart/models/category.php:109
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:922
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:742
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.65 ms После последнего запроса: 0.81 ms Память запроса: 0.028 MB Память до запроса: 2.919 MB Выбрано строк: 3

SELECT c.virtuemart_category_id, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug 
  FROM rc29b_virtuemart_categories as c  
  LEFT JOIN `rc29b_virtuemart_categories_ru_ru` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  LEFT JOIN `rc29b_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 15  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY category_name DESC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cx	NULL	ref	category_parent_id,category_child_id	category_parent_id	4	const	2	100.00	Using where; Using index; Using temporary; Используется filesort
1	SIMPLE	c	NULL	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	maikl_centr.cx.category_child_id	1	86.24	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	maikl_centr.cx.category_child_id	1	100.00	NULL

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

Status	Duration
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
Creating tmp table	0.08 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.13 ms
Creating sort index	0.07 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.01 ms
query end	0.00 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/category.php:228
17	VirtueMartModelCategory::getChildCategoryListObject()	Так же, как вызов в строке ниже.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/category.php:184
13	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:114
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:922
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:742
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.29 ms После последнего запроса: 0.13 ms Память запроса: 0.026 MB Память до запроса: 2.935 MB Выбрано строк: 1

SELECT `virtuemart_media_id` 
  FROM `rc29b_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "16" 
  ORDER BY `ordering`

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rc29b_virtuemart_category_medias	NULL	ref	virtuemart_category_id,ordering	ordering	4	const	1	100.00	Using index condition

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
18	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:232
17	VirtueMartModelCategory::getChildCategoryListObject()	Так же, как вызов в строке ниже.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/category.php:184
13	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:114
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:922
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:742
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.23 ms После последнего запроса: 0.11 ms Память запроса: 0.026 MB Память до запроса: 2.944 MB Выбрано строк: 1

SELECT `virtuemart_media_id` 
  FROM `rc29b_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "50" 
  ORDER BY `ordering`

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rc29b_virtuemart_category_medias	NULL	ref	virtuemart_category_id,ordering	ordering	4	const	1	100.00	Using index condition

Профилирование 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
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
18	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:232
17	VirtueMartModelCategory::getChildCategoryListObject()	Так же, как вызов в строке ниже.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/category.php:184
13	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:114
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:922
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:742
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.24 ms После последнего запроса: 0.13 ms Память запроса: 0.026 MB Память до запроса: 2.954 MB Выбрано строк: 1

SELECT `virtuemart_media_id` 
  FROM `rc29b_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "17" 
  ORDER BY `ordering`

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rc29b_virtuemart_category_medias	NULL	ref	virtuemart_category_id,ordering	ordering	4	const	1	100.00	Using index condition

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

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 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.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
18	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:232
17	VirtueMartModelCategory::getChildCategoryListObject()	Так же, как вызов в строке ниже.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
14	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/category.php:184
13	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:114
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:922
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:742
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.66 ms После последнего запроса: 0.26 ms Память запроса: 0.024 MB Память до запроса: 2.941 MB Выбрано строк: 1

SELECT count(`p`.virtuemart_product_id) AS total	
  
  FROM `rc29b_virtuemart_product_categories` as `pc`
  
  LEFT JOIN `rc29b_virtuemart_products` as `p` 
  ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id
  
  WHERE `pc`.`virtuemart_category_id` = "15"
  
  AND `p`.`virtuemart_vendor_id` = "1"
  
  AND `p`.`published` = "1"

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pc	NULL	index	virtuemart_product_id	virtuemart_product_id	8	NULL	257	10.00	Using where; Using index
1	SIMPLE	p	NULL	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	maikl_centr.pc.virtuemart_product_id	1	95.86	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:406
13	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:118
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:922
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:742
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.21 ms После последнего запроса: 0.08 ms Память запроса: 0.025 MB Память до запроса: 2.948 MB Выбрано строк: 1

Повторяющиеся запросы: #45

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  rc29b_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 15

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	NULL	ref	category_child_id	category_child_id	4	const	1	100.00	NULL

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

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 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.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:763
14	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:705
13	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:121
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:922
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:742
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.25 ms После последнего запроса: 0.05 ms Память запроса: 0.026 MB Память до запроса: 2.956 MB Выбрано строк: 1

Повторяющиеся запросы: #46

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  rc29b_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 14

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	NULL	ref	category_child_id	category_child_id	4	const	1	100.00	NULL

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 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.07 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:763
15	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:770
14	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:705
13	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:121
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:922
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:742
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.32 ms После последнего запроса: 0.11 ms Память запроса: 0.025 MB Память до запроса: 2.965 MB Выбрано строк: 1

SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `rc29b_virtuemart_categories` as c  
  LEFT JOIN `rc29b_virtuemart_categories_ru_ru` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  WHERE l.virtuemart_category_id = 14

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

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

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

Status	Duration
starting	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.01 ms
optimizing	0.01 ms
statistics	0.10 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.02 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:724
13	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:121
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:922
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:742
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.28 ms После последнего запроса: 0.08 ms Память запроса: 0.025 MB Память до запроса: 2.973 MB Выбрано строк: 1

SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `rc29b_virtuemart_categories` as c  
  LEFT JOIN `rc29b_virtuemart_categories_ru_ru` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  WHERE l.virtuemart_category_id = 15

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

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

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

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 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.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:724
13	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:121
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:922
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:742
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.36 ms После последнего запроса: 1.37 ms Память запроса: 0.027 MB Память до запроса: 3.012 MB Выбрано строк: 1

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

  FROM `rc29b_extensions`

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Так же, как вызов в строке ниже.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jatypo/jatypo.php:55
8	plgSystemJATypo->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.36 ms После последнего запроса: 1.34 ms Память запроса: 0.006 MB Память до запроса: 3.003 MB

UPDATE `rc29b_extensions`

  SET `params` = '{\"mediaversion\":\"0f67e793bcab99e10f808f80d5f08395\"}'

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jatypo/jatypo.php:55
8	plgSystemJATypo->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.59 ms После последнего запроса: 15.62 ms Память запроса: 0.030 MB Память до запроса: 3.552 MB Выбрано строк: 1

SELECT * 
  FROM `rc29b_virtuemart_shoppergroups` 
  WHERE `default` = "2" 
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")  
  AND `published`="1"

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rc29b_virtuemart_shoppergroups	NULL	ref	virtuemart_vendor_id,shared,published	published	1	const	2	33.33	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:100
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:177
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:111
11	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:488
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:256
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.17 ms После последнего запроса: 0.22 ms Память запроса: 0.033 MB Память до запроса: 3.589 MB Выбрано строк: 1

SELECT `rc29b_virtuemart_shoppergroups`.*  
  FROM `rc29b_virtuemart_shoppergroups`  
  WHERE `rc29b_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 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
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1028
16	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
15	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:105
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:177
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:111
11	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:488
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:256
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.70 ms После последнего запроса: 1.44 ms Память запроса: 0.024 MB Память до запроса: 3.622 MB Выбрано строк: 0

Повторяющиеся запросы: #36

SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id`, l.product_name 
		
  FROM `rc29b_virtuemart_products` as p   
 
  LEFT JOIN `rc29b_virtuemart_products_ru_ru` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
 
  LEFT JOIN `rc29b_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
 
  LEFT JOIN `rc29b_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
 
  LEFT JOIN `rc29b_virtuemart_categories` as c 
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` 
 
  WHERE ( `pc`.`virtuemart_category_id` = 15 
  AND  `c`.`published` = 1  
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
 
  group by p.`virtuemart_product_id` 
 
  ORDER BY `pc`.`ordering` DESC, `product_name` DESC 
  LIMIT 0, 24

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	Using temporary; Используется filesort
1	SIMPLE	pc	NULL	ALL	virtuemart_product_id	Индекс не используется	NULL	NULL	257	10.00	Using where
1	SIMPLE	p	NULL	eq_ref	PRIMARY,published	PRIMARY	4	maikl_centr.pc.virtuemart_product_id	1	96.59	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	maikl_centr.pc.virtuemart_product_id	1	100.00	NULL
1	SIMPLE	ps	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	maikl_centr.pc.virtuemart_product_id	6	19.00	Using where; Using index

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:852
11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:789
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:256
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.09 ms После последнего запроса: 0.08 ms Память запроса: 0.023 MB Память до запроса: 3.628 MB Выбрано строк: 1

SELECT FOUND_ROWS()

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

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

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

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
init	0.01 ms
optimizing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:865
11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:789
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:256
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.37 ms После последнего запроса: 0.07 ms Память запроса: 0.024 MB Память до запроса: 3.635 MB Выбрано строк: 0

Повторяющиеся запросы: #34

SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id`, l.product_name 
		
  FROM `rc29b_virtuemart_products` as p   
 
  LEFT JOIN `rc29b_virtuemart_products_ru_ru` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id` 
 
  LEFT JOIN `rc29b_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
 
  LEFT JOIN `rc29b_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
 
  LEFT JOIN `rc29b_virtuemart_categories` as c 
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` 
 
  WHERE ( `pc`.`virtuemart_category_id` = 15 
  AND  `c`.`published` = 1  
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
 
  group by p.`virtuemart_product_id` 
 
  ORDER BY `pc`.`ordering` DESC, `product_name` DESC 
  LIMIT 0, 24

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	Using temporary; Используется filesort
1	SIMPLE	pc	NULL	ALL	virtuemart_product_id	Индекс не используется	NULL	NULL	257	10.00	Using where
1	SIMPLE	p	NULL	eq_ref	PRIMARY,published	PRIMARY	4	maikl_centr.pc.virtuemart_product_id	1	96.59	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	maikl_centr.pc.virtuemart_product_id	1	100.00	NULL
1	SIMPLE	ps	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	maikl_centr.pc.virtuemart_product_id	6	19.00	Using where; Using index

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

Status	Duration
starting	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.01 ms
end	0.00 ms
query end	0.00 ms
removing tmp table	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:878
11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:789
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:256
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.62 ms После последнего запроса: 1.49 ms Память запроса: 0.037 MB Память до запроса: 3.747 MB Выбрано строк: 1

SELECT *  
  FROM `rc29b_virtuemart_currencies` AS c
			
  LEFT JOIN `rc29b_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency
			
  WHERE v.virtuemart_vendor_id = "1"

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v	NULL	system	PRIMARY,vendor_currency	Индекс не используется	NULL	NULL	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

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

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:287
12	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
11	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106
10	CurrencyDisplay::getInstance()	JROOT/components/com_virtuemart/views/category/view.html.php:280
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.27 ms После последнего запроса: 0.69 ms Память запроса: 0.031 MB Память до запроса: 3.797 MB Выбрано строк: 1

SELECT `rc29b_virtuemart_currencies`.*  
  FROM `rc29b_virtuemart_currencies`  
  WHERE `rc29b_virtuemart_currencies`.`virtuemart_currency_id` = "131"

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

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

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

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 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.05 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1028
11	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122
10	CurrencyDisplay::getInstance()	JROOT/components/com_virtuemart/views/category/view.html.php:280
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.40 ms После последнего запроса: 0.74 ms Память запроса: 0.032 MB Память до запроса: 3.819 MB Выбрано строк: 1

SELECT `rc29b_virtuemart_medias`.*  
  FROM `rc29b_virtuemart_medias`  
  WHERE `rc29b_virtuemart_medias`.`virtuemart_media_id` = "25"

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 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.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:437
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1192
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/category/view.html.php:337
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.25 ms После последнего запроса: 0.80 ms Память запроса: 0.032 MB Память до запроса: 3.839 MB Выбрано строк: 1

SELECT `rc29b_virtuemart_medias`.*  
  FROM `rc29b_virtuemart_medias`  
  WHERE `rc29b_virtuemart_medias`.`virtuemart_media_id` = "38"

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

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

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

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 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.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:437
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1192
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/category/view.html.php:342
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.23 ms После последнего запроса: 0.27 ms Память запроса: 0.032 MB Память до запроса: 3.851 MB Выбрано строк: 1

SELECT `rc29b_virtuemart_medias`.*  
  FROM `rc29b_virtuemart_medias`  
  WHERE `rc29b_virtuemart_medias`.`virtuemart_media_id` = "365"

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 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.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:437
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1192
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/category/view.html.php:342
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.23 ms После последнего запроса: 0.25 ms Память запроса: 0.032 MB Память до запроса: 3.864 MB Выбрано строк: 1

SELECT `rc29b_virtuemart_medias`.*  
  FROM `rc29b_virtuemart_medias`  
  WHERE `rc29b_virtuemart_medias`.`virtuemart_media_id` = "41"

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 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.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:437
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1192
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/category/view.html.php:342
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.75 ms После последнего запроса: 2.43 ms Память запроса: 0.037 MB Память до запроса: 3.920 MB Выбрано строк: 0

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

  FROM rc29b_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_virtuemart.category' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

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

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

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

Status	Duration
starting	0.23 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.32 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.22 ms
preparing	0.05 ms
Creating tmp table	0.10 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.09 ms
removing tmp table	0.06 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:1054
10	shopFunctionsF::triggerContentPlugin()	JROOT/components/com_virtuemart/views/category/view.html.php:348
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.26 ms После последнего запроса: 1.54 ms Память запроса: 0.030 MB Память до запроса: 4.031 MB Выбрано строк: 1

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  rc29b_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 16

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	NULL	ref	category_child_id	category_child_id	4	const	1	100.00	NULL

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 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.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:763
25	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:967
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:942
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/sublayouts/categories.php:70
14	include JROOT/components/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:489
13	shopFunctionsF::renderVmSubLayout()	JROOT/components/com_virtuemart/views/category/tmpl/default.php:73
12	include JROOT/components/com_virtuemart/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:493
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.22 ms После последнего запроса: 0.08 ms Память запроса: 0.031 MB Память до запроса: 4.044 MB Выбрано строк: 1

Повторяющиеся запросы: #26

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  rc29b_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 15

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	NULL	ref	category_child_id	category_child_id	4	const	1	100.00	NULL

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 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
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
27	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:763
26	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:770
25	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:967
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:942
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/sublayouts/categories.php:70
14	include JROOT/components/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:489
13	shopFunctionsF::renderVmSubLayout()	JROOT/components/com_virtuemart/views/category/tmpl/default.php:73
12	include JROOT/components/com_virtuemart/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:493
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.17 ms После последнего запроса: 0.08 ms Память запроса: 0.031 MB Память до запроса: 4.058 MB Выбрано строк: 1

Повторяющиеся запросы: #27

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  rc29b_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 14

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	NULL	ref	category_child_id	category_child_id	4	const	1	100.00	NULL

Профилирование 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
optimizing	0.01 ms
statistics	0.02 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.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
28	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:763
27	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:770
26	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:770
25	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:967
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:942
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/sublayouts/categories.php:70
14	include JROOT/components/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:489
13	shopFunctionsF::renderVmSubLayout()	JROOT/components/com_virtuemart/views/category/tmpl/default.php:73
12	include JROOT/components/com_virtuemart/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:493
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.37 ms После последнего запроса: 0.27 ms Память запроса: 0.043 MB Память до запроса: 4.089 MB Выбрано строк: 1

SELECT `rc29b_virtuemart_categories`.* ,`rc29b_virtuemart_categories_ru_ru`.*  
  FROM `rc29b_virtuemart_categories` 
  INNER JOIN `rc29b_virtuemart_categories_ru_ru` using (`virtuemart_category_id`) 
  WHERE `rc29b_virtuemart_categories`.`virtuemart_category_id` = "14"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
28	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
27	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:89
26	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:1013
25	vmrouterHelper->getCategoryNames()	JROOT/components/com_virtuemart/router.php:982
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:942
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/sublayouts/categories.php:70
14	include JROOT/components/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:489
13	shopFunctionsF::renderVmSubLayout()	JROOT/components/com_virtuemart/views/category/tmpl/default.php:73
12	include JROOT/components/com_virtuemart/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:493
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.20 ms После последнего запроса: 0.26 ms Память запроса: 0.031 MB Память до запроса: 4.105 MB Выбрано строк: 0

SELECT `virtuemart_media_id` 
  FROM `rc29b_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "14" 
  ORDER BY `ordering`

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rc29b_virtuemart_category_medias	NULL	ref	virtuemart_category_id,ordering	ordering	4	const	1	100.00	Using index condition

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

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 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.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
28	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
27	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:92
26	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:1013
25	vmrouterHelper->getCategoryNames()	JROOT/components/com_virtuemart/router.php:982
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:942
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/sublayouts/categories.php:70
14	include JROOT/components/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:489
13	shopFunctionsF::renderVmSubLayout()	JROOT/components/com_virtuemart/views/category/tmpl/default.php:73
12	include JROOT/components/com_virtuemart/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:493
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.31 ms После последнего запроса: 0.19 ms Память запроса: 0.043 MB Память до запроса: 4.141 MB Выбрано строк: 1

SELECT `rc29b_virtuemart_categories`.* ,`rc29b_virtuemart_categories_ru_ru`.*  
  FROM `rc29b_virtuemart_categories` 
  INNER JOIN `rc29b_virtuemart_categories_ru_ru` using (`virtuemart_category_id`) 
  WHERE `rc29b_virtuemart_categories`.`virtuemart_category_id` = "16"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
28	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
27	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:89
26	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:1013
25	vmrouterHelper->getCategoryNames()	JROOT/components/com_virtuemart/router.php:982
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:942
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/sublayouts/categories.php:70
14	include JROOT/components/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:489
13	shopFunctionsF::renderVmSubLayout()	JROOT/components/com_virtuemart/views/category/tmpl/default.php:73
12	include JROOT/components/com_virtuemart/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:493
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.38 ms После последнего запроса: 2.50 ms Память запроса: 0.030 MB Память до запроса: 4.158 MB Выбрано строк: 1

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  rc29b_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 50

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	NULL	ref	category_child_id	category_child_id	4	const	1	100.00	NULL

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:763
25	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:967
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:942
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/sublayouts/categories.php:70
14	include JROOT/components/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:489
13	shopFunctionsF::renderVmSubLayout()	JROOT/components/com_virtuemart/views/category/tmpl/default.php:73
12	include JROOT/components/com_virtuemart/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:493
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.31 ms После последнего запроса: 0.22 ms Память запроса: 0.043 MB Память до запроса: 4.189 MB Выбрано строк: 1

SELECT `rc29b_virtuemart_categories`.* ,`rc29b_virtuemart_categories_ru_ru`.*  
  FROM `rc29b_virtuemart_categories` 
  INNER JOIN `rc29b_virtuemart_categories_ru_ru` using (`virtuemart_category_id`) 
  WHERE `rc29b_virtuemart_categories`.`virtuemart_category_id` = "50"

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

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

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

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 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.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
28	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
27	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:89
26	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:1013
25	vmrouterHelper->getCategoryNames()	JROOT/components/com_virtuemart/router.php:982
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:942
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/sublayouts/categories.php:70
14	include JROOT/components/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:489
13	shopFunctionsF::renderVmSubLayout()	JROOT/components/com_virtuemart/views/category/tmpl/default.php:73
12	include JROOT/components/com_virtuemart/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:493
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.52 ms После последнего запроса: 10.93 ms Память запроса: 0.027 MB Память до запроса: 4.844 MB Выбрано строк: 4

Повторяющиеся запросы: #14

SELECT id, home, template, s.params

  FROM rc29b_template_styles as s

  LEFT JOIN rc29b_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template,idx_client_id,idx_client_id_home	Индекс не используется	NULL	NULL	7	57.14	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	maikl_centr.s.template,const	1	4.57	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
15	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:65
14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
13	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
12	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
11	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_afterburner2/lib/gantry/gantry.php:21
8	require_once JROOT/templates/rt_afterburner2/lib/gantry/gantry.php	JROOT/templates/rt_afterburner2/index.php:17
7	require JROOT/templates/rt_afterburner2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.37 ms После последнего запроса: 9.63 ms Память запроса: 0.040 MB Память до запроса: 5.075 MB Выбрано строк: 38

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM rc29b_modules AS m

  LEFT JOIN rc29b_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN rc29b_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 <= '2020-09-22 11:14:01') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-09-22 11:14:01') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 188 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	published	1	const	13	2.56	Using index condition; Using where; Используется filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	maikl_centr.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	maikl_centr.m.id	3	40.00	Using where; Using index

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

Status	Duration
starting	0.20 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.51 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	Так же, как вызов в строке ниже.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
8	Gantry->countModules()	JROOT/templates/rt_afterburner2/index.php:56
7	require JROOT/templates/rt_afterburner2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.40 ms После последнего запроса: 5.07 ms Память запроса: 0.026 MB Память до запроса: 5.209 MB Выбрано строк: 1

SELECT ts.template

  FROM rc29b_template_styles AS ts

  INNER JOIN rc29b_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 188 
  AND m.template_style_id != 0

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_afterburner2/features/dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/rt_afterburner2/index.php:80
7	require JROOT/templates/rt_afterburner2/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.73 ms После последнего запроса: 7.55 ms Память запроса: 0.030 MB Память до запроса: 5.307 MB Выбрано строк: 6

SHOW FULL COLUMNS 
  FROM `rc29b_template_styles`

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.23 ms После последнего запроса: 0.15 ms Память запроса: 0.026 MB Память до запроса: 5.330 MB Выбрано строк: 1

SELECT *

  FROM rc29b_template_styles

  WHERE `id` = '14'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.35 ms После последнего запроса: 0.13 ms Память запроса: 0.026 MB Память до запроса: 5.332 MB Выбрано строк: 0

SELECT *
 
  FROM rc29b_jmap_metainfo
 
  WHERE `linkurl` = 'https://centrzashita.ru/15/facilitiesofthenotification/2014-03-16-18-42-21_'
 
  AND `published` = 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rc29b_jmap_metainfo	NULL	ref	linkurl,published	linkurl	1802	const	1	100.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:276
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

6 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`     
  FROM  rc29b_virtuemart_category_categories AS `xref`

5 × SELECT `virtuemart_media_id` 
  FROM `rc29b_virtuemart_category_medias`

4 × SELECT `rc29b_virtuemart_categories`.* ,`rc29b_virtuemart_categories_ru_ru`.*  
  FROM `rc29b_virtuemart_categories` 
  INNER JOIN `rc29b_virtuemart_categories_ru_ru` using (`virtuemart_category_id`)

4 × SELECT `rc29b_virtuemart_medias`.*  
  FROM `rc29b_virtuemart_medias`

2 × SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `rc29b_virtuemart_categories` as c  
  LEFT JOIN `rc29b_virtuemart_categories_ru_ru` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id`

2 × SELECT id, home, template, s.params 
  FROM rc29b_template_styles as s 
  LEFT JOIN rc29b_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

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

2 × SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id`, l.product_name    
  FROM `rc29b_virtuemart_products` as p     
  LEFT JOIN `rc29b_virtuemart_products_ru_ru` as l 
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id`   
  LEFT JOIN `rc29b_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`    
  LEFT JOIN `rc29b_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`    
  LEFT JOIN `rc29b_virtuemart_categories` as c 
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`

1 × SELECT * 
  FROM `rc29b_virtuemart_shoppergroups`

1 × SELECT `rc29b_virtuemart_shoppergroups`.*  
  FROM `rc29b_virtuemart_shoppergroups`

1 × SELECT `data` 
  FROM `rc29b_session`

```
1 × SELECT FOUND_ROWS(
```

1 × SELECT `rc29b_virtuemart_currencies`.*  
  FROM `rc29b_virtuemart_currencies`

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user