Гипс строительный Dolina Nidy 2 кг

45,00 руб

Доставка Забрать со склада для 0,00 руб

Штукатурка акриловая Kreisel 010 BR, шуба (барашек) зерно 2 мм, ведро 25 кг, цвет по каталогу OSB-3 плита 8 мм, 2500х1250х8 мм, влагостойкая ОСБ

Вернуться к: Строительство

Описание

Гипс строительный Dolina Nidy 2 кг
Польша, 2,00 кг

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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1744063500,
                "last": 1744063500,
                "now": 1744063500
            },
            "client": {
                "forwarded": "18.191.118.83"
            }
        },
        "registry": {
            "com_virtuemart": {
                "productdetails": {
                    "limit": "int",
                    "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
        }
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedItemid": 1669,
        "vmlastvisitedcategoryid": 61,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":0,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":0,\"ST\":0,\"cartfields\":null,\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"ru-RU\",\"pricesCurrency\":\"131\",\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0}",
        "vmlastvisitedproductids": [
            109
        ]
    }
}

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

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

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

86 SQL-запросов зафиксировано 201.60 ms

8 повторяющийся запрос!

2 повторов: #14 #44

2 повторов: #52 #54

2 повторов: #59 #63

2 повторов: #83 #84

Время запроса: 9.60 ms Память запроса: 0.018 MB Память до запроса: 2.990 MB Выбрано строк: 0

SELECT `data`

  FROM `mir_session`

  WHERE `session_id` = '4654c2eb38ee01657ea2f65581c5f583'

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

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

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

Status	Duration
starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.17 ms
executing	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Так же, как вызов в строке ниже.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Время запроса: 10.23 ms После последнего запроса: 5.74 ms Память запроса: 0.012 MB Память до запроса: 3.198 MB Выбрано строк: 0

SELECT `session_id`

  FROM `mir_session`

  WHERE `session_id` = '4654c2eb38ee01657ea2f65581c5f583' 
  LIMIT 1

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

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

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

Status	Duration
starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.09 ms
executing	0.04 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Стек вызовов

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

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

Время запроса: 11.99 ms После последнего запроса: 0.50 ms Память запроса: 0.009 MB Память до запроса: 3.213 MB

INSERT INTO `mir_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('4654c2eb38ee01657ea2f65581c5f583', 0, 1, '1744063500', 0, '')

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

EXPLAIN не доступен для запроса: INSERT INTO `mir_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('4654c2eb38ee01657ea2f65581c5f583', 0, 1, '1744063500', 0, '')

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

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
update	0.35 ms
end	0.01 ms
query end	11.10 ms
closing tables	0.05 ms
freeing items	0.13 ms
cleaning up	0.06 ms

Стек вызовов

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

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

Время запроса: 8.27 ms После последнего запроса: 7.25 ms Память запроса: 0.015 MB Память до запроса: 3.786 MB Выбрано строк: 2

SELECT b.id

  FROM mir_usergroups AS a

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

  WHERE a.id = 9

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.08 ms После последнего запроса: 1.60 ms Память запроса: 0.014 MB Память до запроса: 3.862 MB Выбрано строк: 5

SELECT id, rules

  FROM `mir_viewlevels`

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 6.72 ms После последнего запроса: 22.61 ms Память запроса: 0.017 MB Память до запроса: 4.809 MB Выбрано строк: 0

SELECT `path`

  FROM mir_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.69 ms После последнего запроса: 0.50 ms Память запроса: 0.016 MB Память до запроса: 4.826 MB Выбрано строк: 0

SELECT `file`

  FROM mir_rsfirewall_hashes

  WHERE `type`='protect'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.75 ms После последнего запроса: 0.28 ms Память запроса: 0.019 MB Память до запроса: 4.840 MB Выбрано строк: 52

SELECT *

  FROM mir_rsfirewall_configuration

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 10.29 ms После последнего запроса: 22.53 ms Память запроса: 0.025 MB Память до запроса: 5.423 MB Выбрано строк: 10

SHOW FULL COLUMNS 
  FROM `mir_rsfirewall_logs`

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

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

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

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.04 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.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
11	RSFirewallTableLogs->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:57
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:50
7	plgSystemRSFirewall->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 5.03 ms После последнего запроса: 91.23 ms Память запроса: 0.050 MB Память до запроса: 8.656 MB Выбрано строк: 72

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

  LEFT JOIN mir_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	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	92	10.00	Using index condition; Using where; Используется filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	stroymir39.m.component_id	1	100.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
25	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
24	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
23	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
22	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
21	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
20	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
19	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:339
18	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:684
17	JHtml::script()	Так же, как вызов в строке ниже.
16	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
15	JHtml::call()	JROOT/libraries/cms/html/html.php:139
14	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
13	JHtmlBehavior::framework()	Так же, как вызов в строке ниже.
12	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
11	JHtml::call()	JROOT/libraries/cms/html/html.php:139
10	JHtml::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
9	plgSystemJCKModal->onAfterInitialise()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 3.79 ms После последнего запроса: 5.65 ms Память запроса: 0.026 MB Память до запроса: 9.559 MB

UPDATE `mir_extensions`

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

  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	mir_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

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

Status	Duration
starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.23 ms
updating	0.20 ms
end	0.02 ms
query end	2.65 ms
closing tables	0.06 ms
freeing items	0.12 ms
cleaning up	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
22	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
21	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
20	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
19	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
18	JFactory::getDocument()	JROOT/libraries/cms/html/html.php:705
17	JHtml::script()	Так же, как вызов в строке ниже.
16	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
15	JHtml::call()	JROOT/libraries/cms/html/html.php:139
14	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
13	JHtmlBehavior::framework()	Так же, как вызов в строке ниже.
12	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
11	JHtml::call()	JROOT/libraries/cms/html/html.php:139
10	JHtml::_()	JROOT/plugins/system/jckmodal/jckmodal.php:29
9	plgSystemJCKModal->onAfterInitialise()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.42 ms После последнего запроса: 80.42 ms Память запроса: 0.033 MB Память до запроса: 13.667 MB Выбрано строк: 8

SHOW FULL COLUMNS 
  FROM `mir_assets`

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM mir_assets

  WHERE `id` = '1'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

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

SELECT a.rules

  FROM mir_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.93 ms После последнего запроса: 1.85 ms Память запроса: 0.026 MB Память до запроса: 13.799 MB Выбрано строк: 39

SELECT element

  FROM mir_extensions

  WHERE type = 'component' 
  AND enabled = '1'

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_extensions	NULL	ref	extension	extension	82	const	42	10.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.05 ms После последнего запроса: 0.28 ms Память запроса: 0.027 MB Память до запроса: 13.833 MB Выбрано строк: 38

SELECT a.name, a.rules

  FROM mir_assets AS a

  WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jce','com_jckman','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rsfirewall','com_search','com_tags','com_tcpdf','com_templates','com_uniterevolution2','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper','com_xmap') OR a.name = 'root.1')

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:807
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.66 ms После последнего запроса: 4.33 ms Память запроса: 0.020 MB Память до запроса: 14.276 MB Выбрано строк: 1

SHOW TABLES LIKE "mir_virtuemart_configs"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/config.php:511
13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:810
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `config` 
  FROM `mir_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	mir_virtuemart_configs	NULL	system	PRIMARY	Индекс не используется	NULL	NULL	1	100.00	NULL

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:862
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:784
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 2.59 ms После последнего запроса: 2.47 ms Память запроса: 0.028 MB Память до запроса: 14.419 MB Выбрано строк: 16

SELECT * 
  FROM `mir_menu`  
  where `link` like "index.php?option=com_virtuemart%" 
  and client_id=0 
  and published=1 
  and (language="*" or language = "ru-RU"  )

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	93	0.75	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1103
13	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:760
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:786
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:339
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.87 ms После последнего запроса: 0.78 ms Память запроса: 0.017 MB Память до запроса: 14.531 MB Выбрано строк: 1

SELECT p.`virtuemart_product_id`  
  FROM `mir_virtuemart_products_ru_ru` AS `p`  
  WHERE `slug` = "gips-stroitelnyj-dolina-nidy-2-kg"

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	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.06 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.31 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1027
11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:640
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.78 ms После последнего запроса: 0.31 ms Память запроса: 0.018 MB Память до запроса: 14.548 MB Выбрано строк: 0

SELECT `virtuemart_category_id`
				
  FROM  `mir_virtuemart_categories_ru_ru`
				
  WHERE `slug` = ''

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

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

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

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.16 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.08 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:918
12	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:1031
11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:640
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 2.34 ms После последнего запроса: 0.58 ms Память запроса: 0.016 MB Память до запроса: 14.564 MB Выбрано строк: 0

SELECT *

  FROM mir_rsfirewall_hashes

  WHERE (`type`='3.6.5' OR `type`='protect') 
  AND `flag`!='C'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:979
9	plgSystemRSFirewall->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.54 ms После последнего запроса: 1.07 ms Память запроса: 0.016 MB Память до запроса: 14.616 MB Выбрано строк: 0

SELECT *

  FROM mir_rsfirewall_snapshots

  WHERE `type`='protect'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
10	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1002
9	plgSystemRSFirewall->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.72 ms После последнего запроса: 0.36 ms Память запроса: 0.017 MB Память до запроса: 14.632 MB Выбрано строк: 0

SELECT `ip`,`reason`

  FROM mir_rsfirewall_lists

  WHERE (`ip`='18.191.118.83' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:148
10	plgSystemRSFirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1038
9	plgSystemRSFirewall->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.55 ms После последнего запроса: 0.33 ms Память запроса: 0.017 MB Память до запроса: 14.648 MB Выбрано строк: 0

SELECT `ip`,`reason`

  FROM mir_rsfirewall_lists

  WHERE (`ip`='18.191.118.83' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:138
10	plgSystemRSFirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1042
9	plgSystemRSFirewall->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.66 ms После последнего запроса: 1.56 ms Память запроса: 0.018 MB Память до запроса: 14.711 MB Выбрано строк: 0

SELECT *

  FROM mir_rsfirewall_exceptions

  WHERE `published`='1'

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:647
10	plgSystemRSFirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1090
9	plgSystemRSFirewall->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT params

  FROM mir_extensions

  WHERE folder ='editors' 
  AND element ='jckeditor'

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_extensions	NULL	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	10.00	Using where

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

Status	Duration
starting	0.08 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.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/jcktypography/jcktypography.php:61
9	plgSystemJCKtypography->onAfterRoute()	Так же, как вызов в строке ниже.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `mir_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	mir_virtuemart_shoppergroups	NULL	ref	virtuemart_vendor_id,shared,published	published	1	const	1	50.00	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1190
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `mir_virtuemart_shoppergroups`.*  
  FROM `mir_virtuemart_shoppergroups`  
  WHERE `mir_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	mir_virtuemart_shoppergroups	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1190
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `mir_virtuemart_products`.* ,`mir_virtuemart_products_ru_ru`.*  
  FROM `mir_virtuemart_products` 
  INNER JOIN `mir_virtuemart_products_ru_ru` using (`virtuemart_product_id`) 
  WHERE `mir_virtuemart_products`.`virtuemart_product_id` = "109"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `virtuemart_media_id` 
  FROM `mir_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "109" 
  ORDER BY `ordering`

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_product_medias	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	100.00	Using index condition; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.46 ms После последнего запроса: 0.78 ms Память запроса: 0.019 MB Память до запроса: 19.320 MB Выбрано строк: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM `mir_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "109"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `mir_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "109"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-07 22:05:00" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-07 22:05:00" ) ) 
  ORDER BY `product_price` DESC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_product_prices	NULL	ref	product_price,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down,virtuemart_product_id	product_price	4	const	1	100.00	Using index condition; Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `virtuemart_manufacturer_id` 
  FROM `mir_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "109"

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_product_manufacturers	NULL	ref	virtuemart_product_id	virtuemart_product_id	5	const	1	100.00	Using index

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.55 ms После последнего запроса: 0.20 ms Память запроса: 0.020 MB Память до запроса: 19.416 MB Выбрано строк: 2

SELECT * 
  FROM `mir_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 109

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `mir_virtuemart_categories`.* ,`mir_virtuemart_categories_ru_ru`.*  
  FROM `mir_virtuemart_categories` 
  INNER JOIN `mir_virtuemart_categories_ru_ru` using (`virtuemart_category_id`) 
  WHERE `mir_virtuemart_categories`.`virtuemart_category_id` = "61"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1449
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `mir_virtuemart_categories`.* ,`mir_virtuemart_categories_ru_ru`.*  
  FROM `mir_virtuemart_categories` 
  INNER JOIN `mir_virtuemart_categories_ru_ru` using (`virtuemart_category_id`) 
  WHERE `mir_virtuemart_categories`.`virtuemart_category_id` = "78"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1449
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
		c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
		field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
		
  FROM `mir_virtuemart_customs` AS c 
  LEFT JOIN `mir_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
  WHERE `virtuemart_product_id` IN (109) 
  AND c.`published` = "1"  
  ORDER BY field.`ordering`,`virtuemart_custom_id` ASC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	field	NULL	ref	virtuemart_product_id,virtuemart_custom_id,ordering	virtuemart_product_id	4	const	1	100.00	Using where; Using temporary; Используется filesort
1	SIMPLE	c	NULL	eq_ref	PRIMARY,published	PRIMARY	4	stroymir39.field.virtuemart_custom_id	1	93.33	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:146
12	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:2318
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT *  
  FROM `mir_virtuemart_currencies` AS c
			, `mir_virtuemart_vendors` AS v
			
  WHERE v.virtuemart_vendor_id = 1
			
  AND   v.vendor_currency = c.virtuemart_currency_id

План 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.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.09 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.16 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:265
16	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:48
15	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:97
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `mir_virtuemart_currencies`.*  
  FROM `mir_virtuemart_currencies`  
  WHERE `mir_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	mir_virtuemart_currencies	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:113
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 6.39 ms После последнего запроса: 13.29 ms Память запроса: 0.037 MB Память до запроса: 21.460 MB Выбрано строк: 31

SHOW FULL COLUMNS  
  FROM `mir_virtuemart_userfields`

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
24	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:647
23	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
22	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:204
21	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:425
20	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:387
19	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:593
18	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:51
17	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:545
16	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:248
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.19 ms После последнего запроса: 1.00 ms Память запроса: 0.035 MB Память до запроса: 21.557 MB Выбрано строк: 5

SELECT * 
  FROM `mir_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `account`=1 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
  ORDER BY ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_userfields	NULL	ref	published,account	account	1	const	11	42.86	Using index condition; Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:598
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:492
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:259
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.63 ms После последнего запроса: 0.88 ms Память запроса: 0.029 MB Память до запроса: 21.621 MB Выбрано строк: 1

SELECT id

  FROM mir_assets

  WHERE parent_id = 0

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
21	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/table/nested.php:1210
20	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:158
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1280
17	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/models/userfields.php:763
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:264
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

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

SELECT a.rules

  FROM mir_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
21	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
20	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
18	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1280
17	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/models/userfields.php:763
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:264
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.69 ms После последнего запроса: 0.61 ms Память запроса: 0.034 MB Память до запроса: 21.694 MB Выбрано строк: 0

SELECT * 
  FROM `mir_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `shipment`=1 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
  ORDER BY ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_userfields	NULL	ref	published,shipment	shipment	1	const	1	42.86	Using index condition; Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:598
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:498
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:259
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.02 ms После последнего запроса: 2.36 ms Память запроса: 0.028 MB Память до запроса: 21.859 MB Выбрано строк: 0

SELECT * 
  FROM mir_virtuemart_calcs  
  LEFT JOIN mir_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-04-07 22:05:00" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-07 22:05:00" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

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

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

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

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.15 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.15 ms
executing	0.04 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.09 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:179
14	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2325
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:958
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:81
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `mir_virtuemart_medias`.*  
  FROM `mir_virtuemart_medias`  
  WHERE `mir_virtuemart_medias`.`virtuemart_media_id` = "348"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:137
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 2.54 ms После последнего запроса: 1.28 ms Память запроса: 0.017 MB Память до запроса: 22.133 MB Выбрано строк: 1

SELECT p.`virtuemart_product_id`, `l`.`product_name`,`pc`.ordering 
  FROM `mir_virtuemart_products` as p 
  INNER JOIN `mir_virtuemart_products_ru_ru` as l using (`virtuemart_product_id`) 
  LEFT JOIN `mir_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `mir_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
  LEFT JOIN `mir_virtuemart_categories` as c 
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`  
  WHERE ( `pc`.`virtuemart_category_id` = 61 
  AND  `c`.`published` = 1  
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
  AND p.`virtuemart_product_id`!="109"  
  AND `pc`.ordering <= "0"  
  ORDER BY `pc`.`ordering` DESC, `product_name` DESC 
  LIMIT 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps	NULL	system	virtuemart_product_id	Индекс не используется	NULL	NULL	0	0.00	const row not found
1	SIMPLE	c	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	Using temporary; Используется filesort
1	SIMPLE	pc	NULL	ALL	virtuemart_product_id,ordering	Индекс не используется	NULL	NULL	88	10.00	Using where
1	SIMPLE	p	NULL	eq_ref	PRIMARY,published	PRIMARY	4	stroymir39.pc.virtuemart_product_id	1	95.45	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	stroymir39.pc.virtuemart_product_id	1	100.00	NULL

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1705
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:158
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 2.05 ms После последнего запроса: 0.34 ms Память запроса: 0.017 MB Память до запроса: 22.152 MB Выбрано строк: 1

SELECT p.`virtuemart_product_id`, `l`.`product_name`,`pc`.ordering 
  FROM `mir_virtuemart_products` as p 
  INNER JOIN `mir_virtuemart_products_ru_ru` as l using (`virtuemart_product_id`) 
  LEFT JOIN `mir_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `mir_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
  LEFT JOIN `mir_virtuemart_categories` as c 
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`  
  WHERE ( `pc`.`virtuemart_category_id` = 61 
  AND  `c`.`published` = 1  
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
  AND p.`virtuemart_product_id`!="109" 
  AND p.`virtuemart_product_id`!="65" 
  AND `pc`.ordering >= "0"  
  ORDER BY `pc`.`ordering` ASC, `product_name` ASC 
  LIMIT 1

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ps	NULL	system	virtuemart_product_id	Индекс не используется	NULL	NULL	0	0.00	const row not found
1	SIMPLE	c	NULL	const	PRIMARY,published	PRIMARY	4	const	1	100.00	Using temporary; Используется filesort
1	SIMPLE	pc	NULL	ALL	virtuemart_product_id,ordering	Индекс не используется	NULL	NULL	88	9.89	Using where
1	SIMPLE	p	NULL	eq_ref	PRIMARY,published	PRIMARY	4	stroymir39.pc.virtuemart_product_id	1	95.45	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	stroymir39.pc.virtuemart_product_id	1	100.00	NULL

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1705
10	VirtueMartModelProduct->getNeighborProducts()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:158
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 2.72 ms После последнего запроса: 3.18 ms Память запроса: 0.018 MB Память до запроса: 22.393 MB Выбрано строк: 1

SELECT `virtuemart_media_id` 
  FROM `mir_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "61" 
  ORDER BY `ordering`

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_category_medias	NULL	ref	virtuemart_category_id	virtuemart_category_id	4	const	1	100.00	Using index condition; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:73
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:182
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.65 ms После последнего запроса: 0.20 ms Память запроса: 0.017 MB Память до запроса: 22.410 MB Выбрано строк: 2

SELECT `category_child_id`
			
  FROM `mir_virtuemart_category_categories`
			
  WHERE `category_parent_id` = 61

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_virtuemart/models/category.php:667
11	VirtueMartModelCategory->hasChildren()	JROOT/administrator/components/com_virtuemart/models/category.php:87
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:182
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 6.23 ms После последнего запроса: 0.45 ms Память запроса: 0.021 MB Память до запроса: 22.434 MB Выбрано строк: 0

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

SELECT SQL_CALC_FOUND_ROWS  c.`virtuemart_category_id`, category_description, category_name, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`  
  FROM `mir_virtuemart_categories_ru_ru` l
				  JOIN `mir_virtuemart_categories` AS c using (`virtuemart_category_id`)
				  
  LEFT JOIN `mir_virtuemart_category_categories` AS cx
				  
  ON l.`virtuemart_category_id` = cx.`category_child_id` 
 
  WHERE  c.`published` = 1  
  AND  cx.`category_parent_id` = 61 
  AND  (c.`virtuemart_vendor_id` = "0" OR c.`shared` = "1") 

  GROUP BY virtuemart_category_id
 
  ORDER BY c.ordering,category_name ASC 
  LIMIT 0, 10

План 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,shared	PRIMARY	4	stroymir39.cx.category_child_id	1	17.88	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	stroymir39.cx.category_child_id	1	100.00	NULL

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:842
12	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/category.php:367
11	VirtueMartModelCategory->getCategories()	JROOT/administrator/components/com_virtuemart/models/category.php:90
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:182
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.35 ms После последнего запроса: 0.43 ms Память запроса: 0.019 MB Память до запроса: 22.452 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.06 ms
checking permissions	0.02 ms
Opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:853
12	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/category.php:367
11	VirtueMartModelCategory->getCategories()	JROOT/administrator/components/com_virtuemart/models/category.php:90
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:182
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

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

SELECT SQL_CALC_FOUND_ROWS  c.`virtuemart_category_id`, category_description, category_name, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`  
  FROM `mir_virtuemart_categories_ru_ru` l
				  JOIN `mir_virtuemart_categories` AS c using (`virtuemart_category_id`)
				  
  LEFT JOIN `mir_virtuemart_category_categories` AS cx
				  
  ON l.`virtuemart_category_id` = cx.`category_child_id` 
 
  WHERE  c.`published` = 1  
  AND  cx.`category_parent_id` = 61 
  AND  (c.`virtuemart_vendor_id` = "0" OR c.`shared` = "1") 

  GROUP BY virtuemart_category_id
 
  ORDER BY c.ordering,category_name ASC 
  LIMIT 0, 10

План 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,shared	PRIMARY	4	stroymir39.cx.category_child_id	1	17.88	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	stroymir39.cx.category_child_id	1	100.00	NULL

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:870
12	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/category.php:367
11	VirtueMartModelCategory->getCategories()	JROOT/administrator/components/com_virtuemart/models/category.php:90
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:182
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT count(mir_virtuemart_products.virtuemart_product_id) AS total
			
  FROM `mir_virtuemart_products`, `mir_virtuemart_product_categories`
			
  WHERE `mir_virtuemart_products`.`virtuemart_vendor_id` = "1"
			
  AND `mir_virtuemart_product_categories`.`virtuemart_category_id` = 61
			
  AND `mir_virtuemart_products`.`virtuemart_product_id` = `mir_virtuemart_product_categories`.`virtuemart_product_id`
			
  AND `mir_virtuemart_products`.`published` = "1"

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_product_categories	NULL	index	virtuemart_product_id	virtuemart_product_id	8	NULL	88	10.00	Using where; Using index
1	SIMPLE	mir_virtuemart_products	NULL	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	stroymir39.mir_virtuemart_product_categories.virtuemart_product_id	1	94.01	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:392
11	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:94
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:182
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `mir_virtuemart_medias`.*  
  FROM `mir_virtuemart_medias`  
  WHERE `mir_virtuemart_medias`.`virtuemart_media_id` = "322"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:185
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `mir_virtuemart_medias`.*  
  FROM `mir_virtuemart_medias`  
  WHERE `mir_virtuemart_medias`.`virtuemart_media_id` = "347"

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_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.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:200
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `mir_virtuemart_medias`.*  
  FROM `mir_virtuemart_medias`  
  WHERE `mir_virtuemart_medias`.`virtuemart_media_id` = "349"

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_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.43 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:200
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 6.84 ms После последнего запроса: 149.90 ms Память запроса: 0.030 MB Память до запроса: 25.287 MB Выбрано строк: 2

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

SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.*  
  FROM   `mir_virtuemart_shipmentmethods` as i  
  LEFT JOIN `mir_virtuemart_shipmentmethods_ru_ru` as l using (`virtuemart_shipmentmethod_id`) 
 
  LEFT JOIN `mir_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `mir_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`  
  WHERE i.`published` = "1" 
  AND j.`element` = "weight_countries"
	    						
  AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
	    						
  AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
  GROUP BY i.`virtuemart_shipmentmethod_id` 
  ORDER BY i.`ordering`

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	system	virtuemart_shipmentmethod_id	Индекс не используется	NULL	NULL	0	0.00	const row not found
1	SIMPLE	j	NULL	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index condition; Using temporary; Используется filesort
1	SIMPLE	i	NULL	ref	PRIMARY,shipment_jplugin_id	shipment_jplugin_id	4	stroymir39.j.extension_id	2	50.00	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	stroymir39.i.virtuemart_shipmentmethod_id	1	100.00	NULL

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

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.80 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.22 ms
preparing	0.04 ms
Creating tmp table	0.15 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	4.02 ms
Creating sort index	0.46 ms
end	0.02 ms
query end	0.02 ms
removing tmp table	0.08 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.13 ms
cleaning up	0.10 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:528
14	vmPSPlugin->getPluginMethods()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:425
13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Так же, как вызов в строке ниже.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:317
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM mir_virtuemart_calcs  
  LEFT JOIN mir_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DBTaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-04-07 22:05:00" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-07 22:05:00" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1315
17	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:710
16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1526
15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1623
14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:441
13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Так же, как вызов в строке ниже.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:317
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM mir_virtuemart_calcs  
  LEFT JOIN mir_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="TaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-04-07 22:05:00" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-07 22:05:00" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1315
17	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:711
16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1526
15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1623
14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:441
13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Так же, как вызов в строке ниже.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:317
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM mir_virtuemart_calcs  
  LEFT JOIN mir_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE
                `calc_kind`="DATaxBill"
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2025-04-07 22:05:00" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-04-07 22:05:00" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

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

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

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

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.07 ms
statistics	0.04 ms
executing	0.04 ms
end	0.04 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1315
17	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:712
16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1526
15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1623
14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:441
13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Так же, как вызов в строке ниже.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:317
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 2.16 ms После последнего запроса: 0.60 ms Память запроса: 0.042 MB Память до запроса: 25.432 MB Выбрано строк: 2

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

SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,
			j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.*  
  FROM   `mir_virtuemart_shipmentmethods` as i  
  LEFT JOIN `mir_virtuemart_shipmentmethods_ru_ru` as l using (`virtuemart_shipmentmethod_id`) 
 
  LEFT JOIN `mir_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`  
 
  LEFT 
  OUTER JOIN `mir_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`  
  WHERE i.`published` = "1" 
  AND j.`element` = "weight_countries"
	    						
  AND  (i.`virtuemart_vendor_id` = "1" OR i.`virtuemart_vendor_id` = "0" OR i.`shared` = "1")
	    						
  AND  ( s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) 
  GROUP BY i.`virtuemart_shipmentmethod_id` 
  ORDER BY i.`ordering`

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	system	virtuemart_shipmentmethod_id	Индекс не используется	NULL	NULL	0	0.00	const row not found
1	SIMPLE	j	NULL	ref	PRIMARY,element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index condition; Using temporary; Используется filesort
1	SIMPLE	i	NULL	ref	PRIMARY,shipment_jplugin_id	shipment_jplugin_id	4	stroymir39.j.extension_id	2	50.00	Using where
1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	stroymir39.i.virtuemart_shipmentmethod_id	1	100.00	NULL

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:528
25	vmPSPlugin->getPluginMethods()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:848
24	vmPSPlugin->getSelectable()	JROOT/administrator/components/com_virtuemart/plugins/vmpsplugin.php:203
23	vmPSPlugin->onCheckAutomaticSelected()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:539
22	plgVmShipmentWeight_countries->plgVmOnCheckAutomaticSelectedShipment()	Так же, как вызов в строке ниже.
21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
19	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/helpers/cart.php:1464
18	VirtueMartCart->checkAutomaticSelectedPlug()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1431
17	calculationHelper->calculateShipmentPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:891
16	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1526
15	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1623
14	VirtueMartCart->prepareCartData()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:441
13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Так же, как вызов в строке ниже.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:317
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 7.62 ms После последнего запроса: 2.55 ms Память запроса: 0.028 MB Память до запроса: 25.651 MB Выбрано строк: 1

SELECT `mir_virtuemart_countries`.*  
  FROM `mir_virtuemart_countries`  
  WHERE `mir_virtuemart_countries`.`virtuemart_country_id` = "176"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
16	VmModel->getData()	JROOT/plugins/vmshipment/weight_countries/tmpl/default.php:26
15	include JROOT/plugins/vmshipment/weight_countries/tmpl/default.php	JROOT/administrator/components/com_virtuemart/plugins/vmplugin.php:703
14	vmPlugin->renderByLayout()	JROOT/plugins/vmshipment/weight_countries/weight_countries.php:461
13	plgVmShipmentWeight_countries->plgVmOnProductDisplayShipment()	Так же, как вызов в строке ниже.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:317
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 13.38 ms После последнего запроса: 58.62 ms Память запроса: 0.046 MB Память до запроса: 27.935 MB Выбрано строк: 1

SELECT `mir_virtuemart_products`.* ,`mir_virtuemart_products_ru_ru`.*  
  FROM `mir_virtuemart_products` 
  INNER JOIN `mir_virtuemart_products_ru_ru` using (`virtuemart_product_id`) 
  WHERE `mir_virtuemart_products`.`virtuemart_product_id` = "65"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
24	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
23	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:160
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `virtuemart_media_id` 
  FROM `mir_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "65" 
  ORDER BY `ordering`

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_product_medias	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	100.00	Using index condition; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
23	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:160
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.43 ms После последнего запроса: 0.29 ms Память запроса: 0.032 MB Память до запроса: 28.038 MB Выбрано строк: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM `mir_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "65"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
23	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:160
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `mir_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "65"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-07 22:05:00" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-07 22:05:00" ) ) 
  ORDER BY `product_price` DESC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_product_prices	NULL	ref	product_price,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down,virtuemart_product_id	product_price	4	const	1	100.00	Using index condition; Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
25	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
24	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
23	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:160
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `virtuemart_manufacturer_id` 
  FROM `mir_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "65"

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_product_manufacturers	NULL	ref	virtuemart_product_id	virtuemart_product_id	5	const	1	100.00	Using index

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
23	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:160
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.84 ms После последнего запроса: 0.84 ms Память запроса: 0.038 MB Память до запроса: 28.186 MB Выбрано строк: 1

SELECT `mir_virtuemart_manufacturers`.* ,`mir_virtuemart_manufacturers_ru_ru`.*  
  FROM `mir_virtuemart_manufacturers` 
  INNER JOIN `mir_virtuemart_manufacturers_ru_ru` using (`virtuemart_manufacturer_id`) 
  WHERE `mir_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "10"

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_manufacturers	NULL	const	PRIMARY,virtuemart_manufacturercategories_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	mir_virtuemart_manufacturers_ru_ru	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
24	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
23	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1243
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:160
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `mir_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 65

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
24	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
23	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:160
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `mir_virtuemart_products`.* ,`mir_virtuemart_products_ru_ru`.*  
  FROM `mir_virtuemart_products` 
  INNER JOIN `mir_virtuemart_products_ru_ru` using (`virtuemart_product_id`) 
  WHERE `mir_virtuemart_products`.`virtuemart_product_id` = "62"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
24	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
23	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1215
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:165
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `virtuemart_media_id` 
  FROM `mir_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "62" 
  ORDER BY `ordering`

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_product_medias	NULL	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	100.00	Using index condition; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
23	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1220
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:165
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `virtuemart_shoppergroup_id` 
  FROM `mir_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "62"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
23	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:165
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `mir_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "62"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-04-07 22:05:00" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-04-07 22:05:00" ) ) 
  ORDER BY `product_price` DESC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_product_prices	NULL	ref	product_price,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down,virtuemart_product_id	product_price	4	const	1	100.00	Using index condition; Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
25	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1066
24	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1085
23	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1235
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:165
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `virtuemart_manufacturer_id` 
  FROM `mir_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "62"

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_product_manufacturers	NULL	ref	virtuemart_product_id	virtuemart_product_id	5	const	1	100.00	Using index

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
24	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
23	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1238
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:165
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `mir_virtuemart_manufacturers`.* ,`mir_virtuemart_manufacturers_ru_ru`.*  
  FROM `mir_virtuemart_manufacturers` 
  INNER JOIN `mir_virtuemart_manufacturers_ru_ru` using (`virtuemart_manufacturer_id`) 
  WHERE `mir_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "7"

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mir_virtuemart_manufacturers	NULL	const	PRIMARY,virtuemart_manufacturercategories_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	mir_virtuemart_manufacturers_ru_ru	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
24	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
23	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1243
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:165
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `mir_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 62

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
24	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1444
23	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1254
22	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:888
21	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/router.php:935
20	vmrouterHelper->getProductName()	JROOT/components/com_virtuemart/router.php:199
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:165
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.08 ms После последнего запроса: 0.84 ms Память запроса: 0.033 MB Память до запроса: 28.532 MB Выбрано строк: 0

SELECT * 
  FROM `mir_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=61&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0" 
  and published = "1" 
  and (`language` = "ru-RU" OR `language` = "*") 
  ORDER BY `language`

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1248
20	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:105
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:176
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `mir_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=61&virtuemart_manufacturer_id=0%" 
  and published = "1" 
  and (`language` = "ru-RU" OR `language` = "*") 
  ORDER BY `language`

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

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

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

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 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.01 ms
Sending data	0.02 ms
Creating sort index	0.30 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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1248
20	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:105
19	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
18	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
17	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
16	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
15	JRouter->build()	JROOT/libraries/cms/router/site.php:147
14	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
13	JRoute::_()	JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php:176
12	include JROOT/templates/sj_shoppystore/html/com_virtuemart/productdetails/default.php	JROOT/libraries/legacy/view/legacy.php:677
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/productdetails/view.html.php:347
9	VirtueMartViewProductdetails->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.92 ms После последнего запроса: 14.81 ms Память запроса: 0.017 MB Память до запроса: 28.749 MB Выбрано строк: 1

SELECT template_style_id 
  FROM mir_menu 
  WHERE id = 1669

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:184
10	YtFrameworkTemplate->isOverrideTemplate()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30
9	YtFrameworkTemplate->YtFrameworkTemplate()	JROOT/templates/sj_shoppystore/includes/frame_inc.php:31
8	include_once JROOT/templates/sj_shoppystore/includes/frame_inc.php	JROOT/templates/sj_shoppystore/index.php:25
7	require JROOT/templates/sj_shoppystore/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT id 
  FROM mir_template_styles 
  WHERE home = 1 
  AND client_id = 0

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:188
10	YtFrameworkTemplate->isOverrideTemplate()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30
9	YtFrameworkTemplate->YtFrameworkTemplate()	JROOT/templates/sj_shoppystore/includes/frame_inc.php:31
8	include_once JROOT/templates/sj_shoppystore/includes/frame_inc.php	JROOT/templates/sj_shoppystore/index.php:25
7	require JROOT/templates/sj_shoppystore/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 9.42 ms После последнего запроса: 8.96 ms Память запроса: 0.014 MB Память до запроса: 28.919 MB Выбрано строк: 1

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

SELECT home 
  FROM mir_menu 
  WHERE id=1669

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:172
8	YtFrameworkTemplate->isHomePage()	JROOT/templates/sj_shoppystore/index.php:78
7	require JROOT/templates/sj_shoppystore/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

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

SELECT home 
  FROM mir_menu 
  WHERE id=1669

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:173
8	YtFrameworkTemplate->isHomePage()	JROOT/templates/sj_shoppystore/index.php:78
7	require JROOT/templates/sj_shoppystore/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.65 ms После последнего запроса: 71.96 ms Память запроса: 0.019 MB Память до запроса: 29.993 MB Выбрано строк: 84

SELECT * 
  FROM mir_acymailing_config

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
11	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:462
10	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1169
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:139
8	plgSystemRegacymailing->onAfterRender()	Так же, как вызов в строке ниже.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.90 ms После последнего запроса: 10.05 ms Память запроса: 0.015 MB Память до запроса: 30.451 MB Выбрано строк: 1

SELECT template

  FROM mir_template_styles

  WHERE home = 1 
  AND client_id = 0

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/yt/yt.php:280
9	plgSystemYt->nameOfSJTemplate()	JROOT/plugins/system/yt/yt.php:161
8	plgSystemYt->onAfterRender()	Так же, как вызов в строке ниже.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

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

4 × SELECT `mir_virtuemart_medias`.*  
  FROM `mir_virtuemart_medias`

4 × SELECT * 
  FROM mir_virtuemart_calcs  
  LEFT JOIN mir_virtuemart_calc_shoppergroups using(virtuemart_calc_id)

3 × SELECT `virtuemart_media_id` 
  FROM `mir_virtuemart_product_medias`

3 × SELECT `mir_virtuemart_products`.* ,`mir_virtuemart_products_ru_ru`.*  
  FROM `mir_virtuemart_products` 
  INNER JOIN `mir_virtuemart_products_ru_ru` using (`virtuemart_product_id`)

3 × SELECT * 
  FROM `mir_virtuemart_product_prices`

3 × SELECT * 
  FROM `mir_virtuemart_product_categories`

```
3 × SELECT * 
  FROM `mir_menu`
```

3 × SELECT `virtuemart_manufacturer_id` 
  FROM `mir_virtuemart_product_manufacturers`

3 × SELECT `virtuemart_shoppergroup_id` 
  FROM `mir_virtuemart_product_shoppergroups`

2 × SELECT p.`virtuemart_product_id`, `l`.`product_name`,`pc`.ordering 
  FROM `mir_virtuemart_products` as p 
  INNER JOIN `mir_virtuemart_products_ru_ru` as l using (`virtuemart_product_id`) 
  LEFT JOIN `mir_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
  LEFT JOIN `mir_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`  
  LEFT JOIN `mir_virtuemart_categories` as c 
  ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id`

2 × SELECT * 
  FROM `mir_virtuemart_userfields`

2 × SELECT a.rules 
  FROM mir_assets AS a

2 × SELECT SQL_CALC_FOUND_ROWS  c.`virtuemart_category_id`, category_description, category_name, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`  
  FROM `mir_virtuemart_categories_ru_ru` l       JOIN `mir_virtuemart_categories` AS c using (`virtuemart_category_id`)       
  LEFT JOIN `mir_virtuemart_category_categories` AS cx       
  ON l.`virtuemart_category_id` = cx.`category_child_id`

2 × SELECT i.*, j.`extension_id`,j.`name`, j.`type`, j.`element`, j.`folder`, j.`client_id`, j.`enabled`, j.`access`, j.`protected`, j.`manifest_cache`,    j.`params`, j.`custom_data`, j.`system_data`, j.`checked_out`, j.`checked_out_time`, j.`state`,  s.virtuemart_shoppergroup_id , l.*  
  FROM   `mir_virtuemart_shipmentmethods` as i  
  LEFT JOIN `mir_virtuemart_shipmentmethods_ru_ru` as l using (`virtuemart_shipmentmethod_id`)   
  LEFT JOIN `mir_extensions` as j 
  ON j.`extension_id` =  i.`shipment_jplugin_id`    
  LEFT 
  OUTER JOIN `mir_virtuemart_shipmentmethod_shoppergroups` AS s 
  ON i.`virtuemart_shipmentmethod_id` = s.`virtuemart_shipmentmethod_id`

```
2 × SELECT home 
  FROM mir_menu
```

2 × SELECT `mir_virtuemart_manufacturers`.* ,`mir_virtuemart_manufacturers_ru_ru`.*  
  FROM `mir_virtuemart_manufacturers` 
  INNER JOIN `mir_virtuemart_manufacturers_ru_ru` using (`virtuemart_manufacturer_id`)

2 × SELECT `ip`,`reason` 
  FROM mir_rsfirewall_lists

2 × SELECT `mir_virtuemart_categories`.* ,`mir_virtuemart_categories_ru_ru`.*  
  FROM `mir_virtuemart_categories` 
  INNER JOIN `mir_virtuemart_categories_ru_ru` using (`virtuemart_category_id`)

```
1 × SELECT * 
  FROM mir_assets
```
```
1 × SELECT FOUND_ROWS(
```

1 × SELECT count(mir_virtuemart_products.virtuemart_product_id) AS total    
  FROM `mir_virtuemart_products`, `mir_virtuemart_product_categories`

1 × SELECT `category_child_id`    
  FROM `mir_virtuemart_category_categories`

1 × SELECT `virtuemart_media_id` 
  FROM `mir_virtuemart_category_medias`

1 × SELECT `session_id` 
  FROM `mir_session`

1 × SELECT p.`virtuemart_product_id`  
  FROM `mir_virtuemart_products_ru_ru` AS `p`

1 × SELECT `config` 
  FROM `mir_virtuemart_configs`

1 × SELECT `mir_virtuemart_countries`.*  
  FROM `mir_virtuemart_countries`

1 × SELECT * 
  FROM mir_acymailing_confi

1 × SELECT template 
  FROM mir_template_styles

1 × SELECT element 
  FROM mir_extensions

1 × SELECT id 
  FROM mir_template_styles

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

1 × SELECT template_style_id 
  FROM mir_menu

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

```
1 × SELECT id 
  FROM mir_assets
```

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

1 × SELECT * 
  FROM mir_rsfirewall_configuratio

1 × SELECT `data` 
  FROM `mir_session`

1 × SELECT `mir_virtuemart_shoppergroups`.*  
  FROM `mir_virtuemart_shoppergroups`

1 × SELECT * 
  FROM `mir_virtuemart_shoppergroups`

1 × SELECT * 
  FROM mir_rsfirewall_exceptions

1 × SELECT params 
  FROM mir_extensions

1 × SELECT `file` 
  FROM mir_rsfirewall_hashes

1 × SELECT `path` 
  FROM mir_rsfirewall_ignored

1 × SELECT `mir_virtuemart_currencies`.*  
  FROM `mir_virtuemart_currencies`

1 × SELECT `virtuemart_category_id`     
  FROM  `mir_virtuemart_categories_ru_ru`

1 × SELECT *  
  FROM `mir_virtuemart_currencies` AS c    , `mir_virtuemart_vendors` AS v

1 × SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,   c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,   field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`   
  FROM `mir_virtuemart_customs` AS c 
  LEFT JOIN `mir_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`

1 × SELECT id, rules 
  FROM `mir_viewlevels

1 × SELECT * 
  FROM mir_rsfirewall_hashes

1 × SELECT * 
  FROM mir_rsfirewall_snapshots

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

1 × SHOW TABLES LIKE "mir_virtuemart_configs

1 × SHOW FULL COLUMNS  
  FROM `mir_virtuemart_userfields

1 × SHOW FULL COLUMNS 
  FROM `mir_assets

1 × UPDATE `mir_extensions` 
  SET `params` = '{\"mediaversion\":\"c9ab3cce239c462ffa697398af4de97f\"}'

1 × SHOW FULL COLUMNS 
  FROM `mir_rsfirewall_logs

1 × INSERT INTO `mir_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('4654c2eb38ee01657ea2f65581c5f583', 0, 1, '1744063500', 0, ''