Carrito vacío

Dispensadores GILBARCO Veeder-Root abreviaturas y acrónimos

LISTA DE ACRONIMOS Y ABREVIATURAS DE GILBARCO VEEDER-ROOT

En esta sección encontrará una lista completa de abreviaturas y siglas utilizadas habitualmente en los sistemas y documentación técnica de Gilbarco Veeder-Root, tales como surtidores de combustible, interfaces de usuario, componentes electrónicos y funciones del sistema.

Por ejemplo, la sigla PPU hace referencia a “Precio por Unidad”, mientras que POS significa “Punto de Venta” “Point of Sale”. Cada abreviatura de Gilbarco va acompañada de su significado original en inglés y su correspondiente traducción al español, lo cual le facilitará la comprensión de manuales, códigos de error y especificaciones técnicas.

Es importante tener en cuenta que, al momento de efectuar reparaciones o solicitar repuestos de surtidores Gilbarco, no basta únicamente con disponer del número de referencia de la pieza. También es fundamental comprender e identificar con precisión las siglas y acrónimos técnicos vinculados a cada componente, ya que estos proporcionan información clave sobre su función y compatibilidad. Este conocimiento le permitirá seleccionar el recambio adecuado para su modelo de equipo, evitando errores y garantizando un mantenimiento eficaz.

También publicamos los códigos de error de dispensarios Gilbarco, los cuales proporcionan pistas sobre la naturaleza de una falla. Con el código de error específico, se puede consultar la documentación de Gilbarco o una guía de solución de problemas para el modelo de bomba en cuestión. Además, aquí puede descargar el Manual Ilustrado de Piezas de la Bomba y Dispensador Gilbarco Encore (numero de parte PT-1936S) download Gilbarco Encore Pump and Dispenser Parts Manual.

Puede buscar fácilmente en la tabla la abreviatura o acrónimos de bombas de gasolina Gilbarco que necesite, copiar la información relevante o descargar el archivo de significado de acronimos Gilbarco en español u ingles completo para consultarlo cuando lo desee.

LISTA DE ACRONIMOS Y ABREVIATURAS DE GILBARCO

Abreviatura	Significado (Inglés)	Traducción (Español)
ADA	Americans with Disabilities Act	Ley de Estadounidenses con Discapacidades
ATC	Automatic Temperature Compensation	Compensación Automática de Temperatura
CRIND	Card Reader in Dispenser	Lector de Tarjetas en el Surtidor
E-CIM™	Enhanced Customer Interface Module	Módulo Mejorado de Interfaz para el Cliente
EPP	Encrypting PIN Pad	Teclado encriptado para PIN
GOLD	Gilbarco Online Documentation	Documentación en Línea de Gilbarco
J-box	Junction Box	Caja de Conexiones
LCD	Liquid Crystal Display	Pantalla de Cristal Líquido
LED	Light Emitting Diode	Diodo Emisor de Luz
MPD	Multi Product Dispenser	Surtidor de Múltiples Productos
PCA	Printed Circuit Assembly	Ensamblaje de Circuito Impreso
PCB	Printed Circuit Board	Placa de Circuito Impreso
PIN	Personal Identification Number	Número de Identificación Personal
POS	Point of Sale	Punto de Venta
PPP	Programmable Pump Preset	Preajuste Programable de la Bomba
PPU	Price per Unit	Precio por Unidad
STP	Submersible Turbine Pump	Bomba Sumergible de Turbina

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

Сессия

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1747494394,
                "last": 1747494394,
                "now": 1747494394
            },
            "client": {
                "forwarded": "18.97.14.86"
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__vm": {
        "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\":null,\"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}"
    }
}

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

Время

Память

Время: 35.89 ms / 35.89 ms Память: 0.042 MB / 0.39 MB Application: afterLoad

Время: 42.62 ms / 78.51 ms Память: 1.042 MB / 1.43 MB Application: afterInitialise

Время: 42.21 ms / 120.72 ms Память: 0.668 MB / 2.10 MB Application: Start JAccess::getAssetRules Old (1)

Время: 1.23 ms / 121.95 ms Память: 0.014 MB / 2.11 MB Application: Finish JAccess::getAssetRules Old (1)

Время: 0.09 ms / 122.04 ms Память: 0.000 MB / 2.11 MB Application: Start JAccess::preload(components)

Время: 2.91 ms / 124.94 ms Память: 0.320 MB / 2.43 MB Application: Finish JAccess::preload(components)

Время: 5.26 ms / 130.20 ms Память: 0.140 MB / 2.57 MB Application: afterRoute

Время: 3.87 ms / 134.08 ms Память: 0.026 MB / 2.60 MB Application: beforeRenderComponent com_content

Время: 29.52 ms / 163.60 ms Память: 0.480 MB / 3.08 MB Application: afterRenderComponent com_content

Время: 0.53 ms / 164.13 ms Память: 0.005 MB / 3.08 MB Application: afterDispatch

Время: 11.35 ms / 175.48 ms Память: 0.200 MB / 3.28 MB Application: beforeRenderModule mod_custom (CONTACTOS)

Время: 1.62 ms / 177.10 ms Память: 0.007 MB / 3.29 MB Application: afterRenderModule mod_custom (CONTACTOS)

Время: 0.06 ms / 177.16 ms Память: 0.000 MB / 3.29 MB Application: beforeRenderModule mod_custom (NOSOTROS)

Время: 0.13 ms / 177.29 ms Память: 0.004 MB / 3.29 MB Application: afterRenderModule mod_custom (NOSOTROS)

Время: 0.03 ms / 177.32 ms Память: 0.000 MB / 3.29 MB Application: beforeRenderModule mod_custom (INFORMACIÓN)

Время: 0.10 ms / 177.42 ms Память: 0.004 MB / 3.29 MB Application: afterRenderModule mod_custom (INFORMACIÓN)

Время: 0.03 ms / 177.45 ms Память: 0.000 MB / 3.29 MB Application: beforeRenderModule mod_articles_latest (BLOG)

Время: 11.09 ms / 188.54 ms Память: 0.757 MB / 4.05 MB Application: afterRenderModule mod_articles_latest (BLOG)

Время: 0.12 ms / 188.66 ms Память: 0.000 MB / 3.39 MB Application: beforeRenderModule mod_breadcrumbs (Хлебные крошки)

Время: 4.25 ms / 192.91 ms Память: 0.075 MB / 3.47 MB Application: afterRenderModule mod_breadcrumbs (Хлебные крошки)

Время: 0.09 ms / 193.00 ms Память: 0.000 MB / 3.46 MB Application: beforeRenderModule mod_vm_cart (Корзина)

Время: 10.84 ms / 203.84 ms Память: 0.507 MB / 3.97 MB Application: Start JAccess::getAssetRules Old (1)

Время: 0.20 ms / 204.04 ms Память: 0.018 MB / 3.99 MB Application: Finish JAccess::getAssetRules Old (1)

Время: 12.32 ms / 216.36 ms Память: 0.430 MB / 4.42 MB Application: afterRenderModule mod_vm_cart (Корзина)

Время: 0.09 ms / 216.45 ms Память: 0.000 MB / 4.42 MB Application: beforeRenderModule mod_virtuemart_search (Поиск)

Время: 2.16 ms / 218.61 ms Память: 0.061 MB / 4.48 MB Application: afterRenderModule mod_virtuemart_search (Поиск)

Время: 0.07 ms / 218.68 ms Память: 0.000 MB / 4.47 MB Application: beforeRenderModule mod_menu (Верхнее правое меню)

Время: 0.61 ms / 219.29 ms Память: 0.009 MB / 4.48 MB Application: afterRenderModule mod_menu (Верхнее правое меню)

Время: 0.11 ms / 219.39 ms Память: 0.019 MB / 4.50 MB Application: beforeRenderModule mod_accordeonck (Категории (мобильная версия))

Время: 2.90 ms / 222.29 ms Память: 0.127 MB / 4.63 MB Application: afterRenderModule mod_accordeonck (Категории (мобильная версия))

Время: 0.06 ms / 222.36 ms Память: 0.000 MB / 4.58 MB Application: beforeRenderModule mod_custom (Телефон в шапке, viber, telegram)

Время: 0.15 ms / 222.50 ms Память: 0.003 MB / 4.59 MB Application: afterRenderModule mod_custom (Телефон в шапке, viber, telegram)

Время: 0.05 ms / 222.56 ms Память: 0.000 MB / 4.59 MB Application: beforeRenderModule mod_menu (Языковые версии)

Время: 0.49 ms / 223.04 ms Память: 0.012 MB / 4.60 MB Application: afterRenderModule mod_menu (Языковые версии)

Время: 0.05 ms / 223.09 ms Память: 0.000 MB / 4.60 MB Application: beforeRenderModule mod_menu (Верхнее левое меню)

Время: 0.14 ms / 223.23 ms Память: 0.004 MB / 4.60 MB Application: afterRenderModule mod_menu (Верхнее левое меню)

Время: 7.06 ms / 230.29 ms Память: 0.222 MB / 4.82 MB Application: afterRender

Всего SQL-запросов: 42.75 ms

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

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

58 SQL-запросов зафиксировано 42.75 ms

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

2 повторов: #18 #48

2 повторов: #29 #34

Время запроса: 0.81 ms Память запроса: 0.022 MB Память до запроса: 0.674 MB Выбрано строк: 0

SELECT `data`

  FROM `ru_session`

  WHERE `session_id` = 'g6cc0obb314qpaob276la40jvu'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_session	const	PRIMARY	PRIMARY	766	const	1

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

Status	Duration
Starting	0.06 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.03 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.06 ms
Updating status	1.02 ms
Waiting for query cache lock	0.03 ms
Updating status	0.01 ms
Storing result in query cache	0.36 ms
Reset for next command	0.02 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 для получения ссылок на файлы]

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

SELECT `session_id`

  FROM `ru_session`

  WHERE `session_id` = 'g6cc0obb314qpaob276la40jvu' 
  LIMIT 1

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_session	const	PRIMARY	PRIMARY	766	const	1	Using index

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

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.17 ms
Waiting for query cache lock	0.02 ms
Updating status	0.01 ms
Storing result in query cache	0.44 ms
Reset for next command	0.02 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 для получения ссылок на файлы]

Время запроса: 1.98 ms После последнего запроса: 0.10 ms Память запроса: 0.003 MB Память до запроса: 0.697 MB

INSERT INTO `ru_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('g6cc0obb314qpaob276la40jvu', 0, 1, '1747494394', 0, '')

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

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

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

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.07 ms
Waiting for query cache lock	0.01 ms
Update	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.08 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.11 ms
Reset for next command	0.02 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 для получения ссылок на файлы]

Время запроса: 0.69 ms После последнего запроса: 2.30 ms Память запроса: 0.040 MB Память до запроса: 0.721 MB Выбрано строк: 50

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

  FROM `ru_extensions`

  WHERE `type` = 'component'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_extensions	ref	extension	extension	82	const	50	Using index condition

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.15 ms После последнего запроса: 0.50 ms Память запроса: 0.021 MB Память до запроса: 0.754 MB Выбрано строк: 2

SELECT b.id

  FROM ru_usergroups AS a

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

  WHERE a.id = 9

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

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

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

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.18 ms
Updating status	0.02 ms
Reset for next command	0.01 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 для получения ссылок на файлы]

Время запроса: 0.11 ms После последнего запроса: 0.14 ms Память запроса: 0.021 MB Память до запроса: 0.759 MB Выбрано строк: 5

SELECT id, rules

  FROM `ru_viewlevels`

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

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

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

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.11 ms
Updating status	0.01 ms
Reset for next command	0.01 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 для получения ссылок на файлы]

Время запроса: 0.79 ms После последнего запроса: 0.07 ms Память запроса: 0.044 MB Память до запроса: 0.767 MB Выбрано строк: 89

SELECT folder AS type, element AS name, params

  FROM ru_extensions

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

  ORDER BY ordering

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

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

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

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

Стек вызовов

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

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

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

SELECT `enabled`

  FROM `ru_extensions`

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:80
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.26 ms После последнего запроса: 5.30 ms Память запроса: 0.051 MB Память до запроса: 1.448 MB Выбрано строк: 40

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

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

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

  ORDER BY m.lft

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.18 ms После последнего запроса: 6.98 ms Память запроса: 0.022 MB Память до запроса: 1.682 MB Выбрано строк: 0

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

  FROM ru_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM ru_categories AS cat JOIN ru_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN ru_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=285

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	17	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
11	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
10	JCategories->get()	JROOT/components/com_content/router.php:341
9	ContentRouter->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.23 ms После последнего запроса: 0.12 ms Память запроса: 0.021 MB Память до запроса: 1.686 MB Выбрано строк: 1

SELECT `alias`,`catid`

  FROM `ru_content`

  WHERE `id` = 285

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_content	const	PRIMARY	PRIMARY	4	const	1

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
10	JDatabaseDriver->loadObject()	JROOT/components/com_content/router.php:357
9	ContentRouter->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.64 ms После последнего запроса: 0.26 ms Память запроса: 0.021 MB Память до запроса: 1.687 MB Выбрано строк: 1

SELECT id, home, template, s.params

  FROM ru_template_styles as s

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

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

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

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

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

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

Стек вызовов

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

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

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

  FROM `ru_extensions`

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
17	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/templates/t3_bs3_blank/templateHook.php:29
9	include_once JROOT/templates/t3_bs3_blank/templateHook.php	JROOT/plugins/system/t3/t3.php:96
8	plgSystemT3->onAfterRoute()	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 для получения ссылок на файлы]

Время запроса: 1.73 ms После последнего запроса: 0.19 ms Память запроса: 0.007 MB Память до запроса: 1.872 MB

UPDATE `ru_extensions`

  SET `params` = '{\"mediaversion\":\"07a78a10a2e1a8db95b981d1ad96b25a\"}'

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

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

EXPLAIN не доступен для запроса: UPDATE `ru_extensions` SET `params` = '{\"mediaversion\":\"07a78a10a2e1a8db95b981d1ad96b25a\"}' WHERE `type` = 'library' AND `element` = 'joomla'

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/templates/t3_bs3_blank/templateHook.php:29
9	include_once JROOT/templates/t3_bs3_blank/templateHook.php	JROOT/plugins/system/t3/t3.php:96
8	plgSystemT3->onAfterRoute()	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.27 ms После последнего запроса: 10.30 ms Память запроса: 0.031 MB Память до запроса: 2.001 MB Выбрано строк: 91

SELECT *

  FROM `ru_jcomments_settings`

  WHERE `lang` = '' 
  AND `component` = ''

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_jcomments_settings	ref	PRIMARY	PRIMARY	214	const,const	91	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/classes/config.php:140
13	JCommentsCfg::_load()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/components/com_jcomments/classes/config.php:159
11	JCommentsCfg->load()	JROOT/components/com_jcomments/classes/config.php:47
10	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/helpers/system.php:39
9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
8	plgSystemJComments->onAfterRoute()	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 для получения ссылок на файлы]

Время запроса: 1.20 ms После последнего запроса: 3.74 ms Память запроса: 0.026 MB Память до запроса: 2.071 MB Выбрано строк: 8

SHOW FULL COLUMNS 
  FROM `ru_assets`

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
17	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
16	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
15	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
11	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
10	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:806
9	VmConfig::loadConfig()	JROOT/plugins/system/onepage_generic/onepage_generic.php:75
8	plgSystemOnepage_generic->onAfterRoute()	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.43 ms После последнего запроса: 1.86 ms Память запроса: 0.024 MB Память до запроса: 2.096 MB Выбрано строк: 1

SELECT *

  FROM ru_assets

  WHERE `id` = '1'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_assets	const	PRIMARY	PRIMARY	4	const	1

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
15	JTable->load()	JROOT/libraries/joomla/access/access.php:697
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
11	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
10	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:806
9	VmConfig::loadConfig()	JROOT/plugins/system/onepage_generic/onepage_generic.php:75
8	plgSystemOnepage_generic->onAfterRoute()	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.22 ms После последнего запроса: 0.25 ms Память запроса: 0.022 MB Память до запроса: 2.102 MB Выбрано строк: 1

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

SELECT a.rules

  FROM ru_assets AS a

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
11	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
10	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:806
9	VmConfig::loadConfig()	JROOT/plugins/system/onepage_generic/onepage_generic.php:75
8	plgSystemOnepage_generic->onAfterRoute()	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 для получения ссылок на файлы]

Время запроса: 1.06 ms После последнего запроса: 1.13 ms Память запроса: 0.025 MB Память до запроса: 2.111 MB Выбрано строк: 50

SELECT element

  FROM ru_extensions

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_extensions	ref	extension	extension	82	const	50	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
11	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
10	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:806
9	VmConfig::loadConfig()	JROOT/plugins/system/onepage_generic/onepage_generic.php:75
8	plgSystemOnepage_generic->onAfterRoute()	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.18 ms После последнего запроса: 0.15 ms Память запроса: 0.026 MB Память до запроса: 2.125 MB Выбрано строк: 50

SELECT a.name, a.rules

  FROM ru_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_banners','com_barcode','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_customfilters','com_dump','com_finder','com_installer','com_jce','com_jcomments','com_jlexreview','com_jmm','com_joomlaupdate','com_jotcache','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_priceimport','com_pricesync','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_toxml','com_uniterevolution2','com_users','com_virtuemart','com_virtuemart_allinone','com_virtuemarttoxml','com_vmcompare','com_vmeeplus','com_wrapper','com_xmap') OR a.name = 'root.1')

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	idx_asset_name	idx_asset_name	202	NULL	51	Using index condition

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:544
11	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:517
10	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:806
9	VmConfig::loadConfig()	JROOT/plugins/system/onepage_generic/onepage_generic.php:75
8	plgSystemOnepage_generic->onAfterRoute()	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 для получения ссылок на файлы]

Время запроса: 2.80 ms После последнего запроса: 2.53 ms Память запроса: 0.021 MB Память до запроса: 2.493 MB Выбрано строк: 1

SHOW TABLES LIKE "ru_virtuemart_configs"

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/config.php:511
10	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:809
9	VmConfig::loadConfig()	JROOT/plugins/system/onepage_generic/onepage_generic.php:75
8	plgSystemOnepage_generic->onAfterRoute()	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.11 ms После последнего запроса: 0.08 ms Память запроса: 0.021 MB Память до запроса: 2.498 MB Выбрано строк: 1

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:861
9	VmConfig::loadConfig()	JROOT/plugins/system/onepage_generic/onepage_generic.php:75
8	plgSystemOnepage_generic->onAfterRoute()	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.15 ms После последнего запроса: 0.41 ms Память запроса: 0.022 MB Память до запроса: 2.545 MB Выбрано строк: 1

SELECT *

  FROM ru_languages

  WHERE published=1

  ORDER BY ordering ASC

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
11	JLanguageHelper::getLanguages()	JROOT/administrator/components/com_virtuemart/helpers/config.php:946
10	VmConfig::setdbLanguageTag()	JROOT/administrator/components/com_virtuemart/helpers/config.php:883
9	VmConfig::loadConfig()	JROOT/plugins/system/onepage_generic/onepage_generic.php:75
8	plgSystemOnepage_generic->onAfterRoute()	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 для получения ссылок на файлы]

Время запроса: 1.07 ms После последнего запроса: 9.85 ms Память запроса: 0.031 MB Память до запроса: 2.647 MB Выбрано строк: 30

SHOW FULL COLUMNS 
  FROM `ru_content`

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

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

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

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.10 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.04 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 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/libraries/legacy/table/content.php:31
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.81 ms После последнего запроса: 3.75 ms Память запроса: 0.069 MB Память до запроса: 2.695 MB Выбрано строк: 1

SELECT *

  FROM ru_content

  WHERE `id` = '285'

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_content	const	PRIMARY	PRIMARY	4	const	1

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/components/com_content/models/article.php:265
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 2.90 ms После последнего запроса: 0.13 ms Память запроса: 0.005 MB Память до запроса: 2.725 MB

UPDATE ru_content

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

  WHERE `id` = '285'

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

EXPLAIN не доступен для запроса: UPDATE ru_content SET `hits` = (`hits` + 1) WHERE `id` = '285'

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
10	JTable->hit()	JROOT/components/com_content/models/article.php:266
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.61 ms После последнего запроса: 1.04 ms Память запроса: 0.070 MB Память до запроса: 2.749 MB Выбрано строк: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM ru_content AS a

  LEFT JOIN ru_categories AS c 
  on c.id = a.catid

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM ru_categories AS cat JOIN ru_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 285 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-05-17 15:06:34') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-05-17 15:06:34') 
  AND (a.state = 1 OR a.state =2)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	16	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
12	ContentModelArticle->getItem()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394
11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.17 ms После последнего запроса: 1.93 ms Память запроса: 0.023 MB Память до запроса: 2.862 MB Выбрано строк: 2

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

  FROM ru_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM ru_categories AS cat JOIN ru_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN ru_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=8

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Используется filesort
1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	7	Using index condition; Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	ektmnnkzzk.c.id	2	Using where
2	LATERAL DERIVED	cat	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	ektmnnkzzk.c.id	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	17	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.14 ms После последнего запроса: 0.46 ms Память запроса: 0.034 MB Память до запроса: 2.904 MB Выбрано строк: 24

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

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

  FROM `ru_contentitem_tag_map` AS m 

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

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 2.37 ms После последнего запроса: 15.27 ms Память запроса: 0.544 MB Память до запроса: 3.237 MB Выбрано строк: 229

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

  FROM ru_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-05-17 15:06:34') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-05-17 15:06:34') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 501 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:430
16	JModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:373
15	JModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:89
14	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:514
13	JDocumentHtml->countModules()	JROOT/plugins/system/t3/includes/core/template.php:624
12	T3Template->countModules()	JROOT/templates/t3_bs3_blank/local/tpls/blocks/header-top.php:1
11	include JROOT/templates/t3_bs3_blank/local/tpls/blocks/header-top.php	JROOT/plugins/system/t3/includes/core/template.php:195
10	T3Template->loadBlock()	JROOT/templates/t3_bs3_blank/local/tpls/airshop.php:32
9	include JROOT/templates/t3_bs3_blank/local/tpls/airshop.php	JROOT/plugins/system/t3/includes/core/template.php:221
8	T3Template->loadLayout()	JROOT/templates/t3_bs3_blank/index.php:37
7	require JROOT/templates/t3_bs3_blank/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 для получения ссылок на файлы]

Время запроса: 6.49 ms После последнего запроса: 7.07 ms Память запроса: 0.328 MB Память до запроса: 3.332 MB Выбрано строк: 8

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM ru_content AS a

  LEFT JOIN ru_categories AS c 
  ON c.id = a.catid

  LEFT JOIN ru_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN ru_users AS uam 
  ON uam.id = a.modified_by

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

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

  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM ru_categories AS cat JOIN ru_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id ) AS badcats 
  ON badcats.id = c.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.catid IN (8) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-05-17 15:06:34') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-05-17 15:06:34')

  ORDER BY a.created DESC 
  LIMIT 10

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	68	Using where; Используется filesort
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	ektmnnkzzk.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	ektmnnkzzk.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	ektmnnkzzk.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0	Using where
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	17	Using index condition; Using where

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

Status	Duration
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.04 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.52 ms
Waiting for query cache lock	0.02 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
13	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.23 ms После последнего запроса: 0.44 ms Память запроса: 0.035 MB Память до запроса: 3.652 MB Выбрано строк: 21

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

  FROM `ru_contentitem_tag_map` AS m 

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

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.12 ms После последнего запроса: 0.20 ms Память запроса: 0.040 MB Память до запроса: 3.718 MB Выбрано строк: 26

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

  FROM `ru_contentitem_tag_map` AS m 

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

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.13 ms После последнего запроса: 0.17 ms Память запроса: 0.035 MB Память до запроса: 3.789 MB Выбрано строк: 24

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

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

  FROM `ru_contentitem_tag_map` AS m 

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

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.11 ms После последнего запроса: 0.16 ms Память запроса: 0.035 MB Память до запроса: 3.855 MB Выбрано строк: 20

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

  FROM `ru_contentitem_tag_map` AS m 

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

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.13 ms После последнего запроса: 0.15 ms Память запроса: 0.031 MB Память до запроса: 3.913 MB Выбрано строк: 14

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

  FROM `ru_contentitem_tag_map` AS m 

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

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.11 ms После последнего запроса: 0.15 ms Память запроса: 0.031 MB Память до запроса: 3.959 MB Выбрано строк: 11

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

  FROM `ru_contentitem_tag_map` AS m 

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

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.10 ms После последнего запроса: 0.13 ms Память запроса: 0.031 MB Память до запроса: 3.999 MB Выбрано строк: 12

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

  FROM `ru_contentitem_tag_map` AS m 

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

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.11 ms После последнего запроса: 0.13 ms Память запроса: 0.031 MB Память до запроса: 4.041 MB Выбрано строк: 11

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

  FROM `ru_contentitem_tag_map` AS m 

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

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:113
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.19 ms После последнего запроса: 4.10 ms Память запроса: 0.050 MB Память до запроса: 3.422 MB Выбрано строк: 19

SELECT * 
  FROM `ru_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	Индекс не используется	NULL	NULL	484	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1097
21	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:757
20	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:781
19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
18	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_breadcrumbs/helper.php:63
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	2	Using where

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

Status	Duration
Starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 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/components/com_virtuemart/helpers/cart.php:132
11	VirtueMartCart::getCart()	JROOT/modules/mod_vm_cart/mod_vm_cart.php:141
10	include JROOT/modules/mod_vm_cart/mod_vm_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_virtuemart_shoppergroups	const	PRIMARY	PRIMARY	4	const	1

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

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 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/components/com_virtuemart/helpers/cart.php:132
11	VirtueMartCart::getCart()	JROOT/modules/mod_vm_cart/mod_vm_cart.php:141
10	include JROOT/modules/mod_vm_cart/mod_vm_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:265
18	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:48
17	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:97
16	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1622
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1726
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vm_cart/mod_vm_cart.php:149
10	include JROOT/modules/mod_vm_cart/mod_vm_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `ru_virtuemart_currencies`.*  
  FROM `ru_virtuemart_currencies`  
  WHERE `ru_virtuemart_currencies`.`virtuemart_currency_id` = "47"

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_virtuemart_currencies	const	PRIMARY	PRIMARY	4	const	1

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

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 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/helpers/currencydisplay.php:113
16	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1622
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1726
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vm_cart/mod_vm_cart.php:149
10	include JROOT/modules/mod_vm_cart/mod_vm_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 1.11 ms После последнего запроса: 0.40 ms Память запроса: 0.036 MB Память до запроса: 3.900 MB Выбрано строк: 31

SHOW FULL COLUMNS  
  FROM `ru_virtuemart_userfields`

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

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

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

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.25 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
checking permissions	0.10 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.06 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
26	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:647
25	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
24	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:204
23	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:425
22	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:387
21	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:593
20	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:51
19	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:545
18	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:248
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1622
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1726
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vm_cart/mod_vm_cart.php:149
10	include JROOT/modules/mod_vm_cart/mod_vm_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.17 ms После последнего запроса: 0.29 ms Память запроса: 0.027 MB Память до запроса: 3.939 MB Выбрано строк: 3

SELECT * 
  FROM `ru_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_virtuemart_userfields	ref	published,account	published	1	const	8	Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
20	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:593
19	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:484
18	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:259
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1622
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1726
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vm_cart/mod_vm_cart.php:149
10	include JROOT/modules/mod_vm_cart/mod_vm_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT id

  FROM ru_assets

  WHERE parent_id = 0

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_assets	ref	idx_parent_id	idx_parent_id	4	const	1	Using index

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
23	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/table/nested.php:1210
22	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:158
21	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
20	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1281
19	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/models/userfields.php:758
18	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:261
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1622
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1726
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vm_cart/mod_vm_cart.php:149
10	include JROOT/modules/mod_vm_cart/mod_vm_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

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

SELECT a.rules

  FROM ru_assets AS a

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
23	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
22	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
21	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
20	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1281
19	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/models/userfields.php:758
18	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:261
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1622
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1726
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vm_cart/mod_vm_cart.php:149
10	include JROOT/modules/mod_vm_cart/mod_vm_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `ru_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_virtuemart_userfields	ref	published,shipment	published	1	const	8	Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
20	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:593
19	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:490
18	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:259
17	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
16	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1622
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1726
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vm_cart/mod_vm_cart.php:149
10	include JROOT/modules/mod_vm_cart/mod_vm_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM ru_virtuemart_calcs  
  LEFT JOIN ru_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-05-17 15:06:34" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-05-17 15:06:34" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_virtuemart_calcs	system	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	Индекс не используется	NULL	NULL	1
1	SIMPLE	ru_virtuemart_calc_shoppergroups	system	virtuemart_calc_id	Индекс не используется	NULL	NULL	0	Const row not found

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
17	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:179
16	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
15	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
14	calculationHelper::getInstance()	JROOT/components/com_virtuemart/helpers/cart.php:1521
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1622
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1726
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vm_cart/mod_vm_cart.php:149
10	include JROOT/modules/mod_vm_cart/mod_vm_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM ru_virtuemart_calcs  
  LEFT JOIN ru_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-05-17 15:06:34" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-05-17 15:06:34" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1314
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:709
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1525
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1622
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1726
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vm_cart/mod_vm_cart.php:149
10	include JROOT/modules/mod_vm_cart/mod_vm_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM ru_virtuemart_calcs  
  LEFT JOIN ru_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-05-17 15:06:34" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-05-17 15:06:34" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1314
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:710
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1525
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1622
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1726
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vm_cart/mod_vm_cart.php:149
10	include JROOT/modules/mod_vm_cart/mod_vm_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM ru_virtuemart_calcs  
  LEFT JOIN ru_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-05-17 15:06:34" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2025-05-17 15:06:34" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	Индекс не используется	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1314
15	calculationHelper->gatherEffectingRulesForBill()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:711
14	calculationHelper->getCheckoutPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1525
13	VirtueMartCart->getCartPrices()	JROOT/components/com_virtuemart/helpers/cart.php:1622
12	VirtueMartCart->prepareCartData()	JROOT/components/com_virtuemart/helpers/cart.php:1726
11	VirtueMartCart->prepareAjaxData()	JROOT/modules/mod_vm_cart/mod_vm_cart.php:149
10	include JROOT/modules/mod_vm_cart/mod_vm_cart.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `ru_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=0&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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_menu	ALL	idx_language	Индекс не используется	NULL	NULL	484	Using where; Используется filesort

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1225
21	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:816
20	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:799
19	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:99
18	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/templates/t3_bs3_blank/html/mod_virtuemart_search/default.php:4
11	require JROOT/templates/t3_bs3_blank/html/mod_virtuemart_search/default.php	JROOT/modules/mod_virtuemart_search/mod_virtuemart_search.php:39
10	include JROOT/modules/mod_virtuemart_search/mod_virtuemart_search.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

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

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

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

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1225
21	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:816
20	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:799
19	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:99
18	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
14	JRouter->build()	JROOT/libraries/cms/router/site.php:147
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/templates/t3_bs3_blank/html/mod_virtuemart_search/default.php:4
11	require JROOT/templates/t3_bs3_blank/html/mod_virtuemart_search/default.php	JROOT/modules/mod_virtuemart_search/mod_virtuemart_search.php:39
10	include JROOT/modules/mod_virtuemart_search/mod_virtuemart_search.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.28 ms После последнего запроса: 1.84 ms Память запроса: 0.066 MB Память до запроса: 4.570 MB Выбрано строк: 36

SELECT *
			
  FROM ru_modules
			
  WHERE published=1
			
  ORDER BY id
			;

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ru_modules	index	published	PRIMARY	4	NULL	68	Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_accordeonck/helper.php:219
12	ModaccordeonckHelper::CreateModulesList()	JROOT/modules/mod_accordeonck/helper.php:40
11	ModaccordeonckHelper::GetItems()	JROOT/modules/mod_accordeonck/mod_accordeonck.php:21
10	include JROOT/modules/mod_accordeonck/mod_accordeonck.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Время запроса: 0.24 ms После последнего запроса: 5.30 ms Память запроса: 0.024 MB Память до запроса: 4.868 MB Выбрано строк: 2

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

  FROM ru_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM ru_categories AS cat JOIN ru_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN ru_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=27

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Используется filesort
1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	7	Using index condition; Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	ektmnnkzzk.c.id	2	Using where
2	LATERAL DERIVED	cat	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	ektmnnkzzk.c.id	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	17	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_content/router.php:151
13	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
10	JRouter->build()	JROOT/libraries/cms/router/site.php:147
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	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.17 ms После последнего запроса: 0.90 ms Память запроса: 0.024 MB Память до запроса: 4.889 MB Выбрано строк: 2

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

  FROM ru_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM ru_categories AS cat JOIN ru_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN ru_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=2

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Используется filesort
1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	7	Using index condition; Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	ektmnnkzzk.c.id	2	Using where
2	LATERAL DERIVED	cat	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	ektmnnkzzk.c.id	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	202	const	17	Using index condition; Using where

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

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_content/router.php:151
13	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
10	JRouter->build()	JROOT/libraries/cms/router/site.php:147
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	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 для получения ссылок на файлы]

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

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

9 × SELECT `m`.`tag_id`,`t`.* 
  FROM `ru_contentitem_tag_map` AS m  
  INNER JOIN `ru_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

4 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM ru_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM ru_categories AS cat JOIN ru_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

4 × SELECT * 
  FROM ru_virtuemart_calcs  
  LEFT JOIN ru_virtuemart_calc_shoppergroups using(virtuemart_calc_id)

```
3 × SELECT * 
  FROM `ru_menu`
```

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

2 × SELECT * 
  FROM `ru_virtuemart_userfields`

2 × SELECT a.rules 
  FROM ru_assets AS a

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM ru_modules AS m 
  LEFT JOIN ru_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN ru_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM ru_content AS a 
  LEFT JOIN ru_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ru_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ru_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ru_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ru_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM ru_categories AS cat JOIN ru_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `data` 
  FROM `ru_session`

1 × SELECT * 
  FROM `ru_virtuemart_shoppergroups`

1 × SELECT `ru_virtuemart_shoppergroups`.*  
  FROM `ru_virtuemart_shoppergroups`

```
1 × SELECT * 
  FROM ru_content
```

1 × SELECT *  
  FROM `ru_virtuemart_currencies` AS c    , `ru_virtuemart_vendors` AS v

1 × SELECT `ru_virtuemart_currencies`.*  
  FROM `ru_virtuemart_currencies`

```
1 × SELECT id 
  FROM ru_assets
```

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM ru_content AS a 
  LEFT JOIN ru_categories AS c 
  on c.id = a.catid 
  LEFT JOIN ru_users AS u 
  on u.id = a.created_by 
  LEFT JOIN ru_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ru_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM ru_categories AS cat JOIN ru_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `config` 
  FROM `ru_virtuemart_configs`

```
1 × SELECT * 
  FROM ru_languages
```

1 × SELECT `session_id` 
  FROM `ru_session`

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

1 × SELECT element 
  FROM ru_extensions

```
1 × SELECT * 
  FROM ru_assets
```

1 × SELECT * 
  FROM `ru_jcomments_settings`

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

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

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

1 × SELECT `enabled` 
  FROM `ru_extensions`

1 × SELECT folder AS type, element AS name, params 
  FROM ru_extensions

1 × SELECT id, rules 
  FROM `ru_viewlevels

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

```
1 × SELECT *
    
  FROM ru_modules
```

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

1 × INSERT INTO `ru_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('g6cc0obb314qpaob276la40jvu', 0, 1, '1747494394', 0, ''

1 × UPDATE `ru_extensions` 
  SET `params` = '{\"mediaversion\":\"07a78a10a2e1a8db95b981d1ad96b25a\"}'

1 × SHOW FULL COLUMNS 
  FROM `ru_assets

1 × SHOW TABLES LIKE "ru_virtuemart_configs

1 × SHOW FULL COLUMNS 
  FROM `ru_content

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

1 × SHOW FULL COLUMNS  
  FROM `ru_virtuemart_userfields