Цеглинка

E-mail:
zastavva@ukr.net

Адреса:
м.Червоноград, вул.Радехівська 10

+38 (066) 466 17 29
+38 (093) 883 47 82

Застава Червоноград

Адреса:
м. Червоноград, вул. Радехівська 10

E-mail:
zastavva@ukr.net

Контактні телефони:
+38 (066) 466 17 29 Viber
+38 (093) 883 47 82
+38 (067) 374 95 27
+38 (032) 494 64 95

Останні новини

ЯК ПІДГОТУВАТИ НАДІЙНУ ОСНОВУ.

09 червня 2020

30 ФАКТІВ, ЗАВДЯКИ ЯКИМ ВИ ЗМОЖЕТЕ ЗНАТИ ПРО ТРОТУАРНУ ПЛИТКУ ВСЕ

12 лютого 2020

Доріжки з тротуарної плитки своїми руками. Поради від фахівців!

01 лютого 2020

Замовлення зворотного дзвінка

Дякуємо! Ми з Вами зв'яжемось.

Час дзвінка

Замовлення зворотного дзвінка

Дякуємо! Запит відправлено.

вгору

Консоль налагодження Joomla

Сесія

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1734080067,
                "last": 1734080067,
                "now": 1734080067
            },
            "client": {
                "forwarded": "18.97.14.84"
            },
            "token": "pRe8Xr6t2JIAtxdcH6bkUxp75yefR6VP"
        },
        "registry": {
            "com_virtuemart": {
                "category": {
                    "filter_order": "`p`.created_on",
                    "limit": "12"
                },
                "categoryc13m0": {
                    "limitstart": 0
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "uk-UA"
        }
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedItemid": 131,
        "vmlastvisitedcategoryid": 13,
        "vmlastvisitedmanuid": 0
    }
}

Інформація облікового запису

Час

Пам'ять

Час: 37.39 ms / 37.39 ms Пам'ять: 2.140 MB / 2.39 MB Application: afterLoad

Час: 109.11 ms / 146.50 ms Пам'ять: 6.421 MB / 8.81 MB Application: afterInitialise

Час: 48.34 ms / 194.84 ms Пам'ять: 2.550 MB / 11.36 MB Application: Before Access::preloadComponents (all components)

Час: 0.98 ms / 195.82 ms Пам'ять: 0.108 MB / 11.47 MB Application: After Access::preloadComponents (all components)

Час: 0.03 ms / 195.86 ms Пам'ять: 0.000 MB / 11.46 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Час: 1.36 ms / 197.22 ms Пам'ять: 0.048 MB / 11.51 MB Application: After Access::getAssetRules (id:1 name:root.1)

Час: 0.04 ms / 197.26 ms Пам'ять: 0.001 MB / 11.51 MB Application: Before Access::getAssetRules (id:88 name:com_virtuemart)

Час: 0.02 ms / 197.27 ms Пам'ять: 0.003 MB / 11.51 MB Application: After Access::getAssetRules (id:88 name:com_virtuemart)

Час: 23.41 ms / 220.68 ms Пам'ять: 1.382 MB / 12.89 MB Application: afterRoute

Час: 1.77 ms / 222.45 ms Пам'ять: 0.103 MB / 13.00 MB Application: beforeRenderComponent com_virtuemart

Час: 122.84 ms / 345.28 ms Пам'ять: 8.695 MB / 21.69 MB Application: afterRenderComponent com_virtuemart

Час: 9.92 ms / 355.20 ms Пам'ять: 0.179 MB / 21.87 MB Application: afterDispatch

Час: 272.70 ms / 627.90 ms Пам'ять: 1.301 MB / 23.17 MB Application: beforeRenderModule mod_joomly_callback (Зворотній зв'язок)

Час: 7.49 ms / 635.39 ms Пам'ять: 0.173 MB / 23.35 MB Application: afterRenderModule mod_joomly_callback (Зворотній зв'язок)

Час: 0.15 ms / 635.54 ms Пам'ять: 0.000 MB / 23.32 MB Application: beforeRenderModule mod_menu (Моб. Меню)

Час: 10.18 ms / 645.72 ms Пам'ять: 0.108 MB / 23.43 MB Application: afterRenderModule mod_menu (Моб. Меню)

Час: 0.06 ms / 645.78 ms Пам'ять: 0.000 MB / 23.42 MB Application: beforeRenderModule mod_custom (Контакти шапка (моб.))

Час: 1.75 ms / 647.53 ms Пам'ять: 0.013 MB / 23.43 MB Application: afterRenderModule mod_custom (Контакти шапка (моб.))

Час: 0.08 ms / 647.62 ms Пам'ять: 0.000 MB / 23.43 MB Application: beforeRenderModule mod_custom (Розробка сайту - Фабрика Сайтів)

Час: 0.85 ms / 648.47 ms Пам'ять: 0.007 MB / 23.43 MB Application: afterRenderModule mod_custom (Розробка сайту - Фабрика Сайтів)

Час: 0.09 ms / 648.56 ms Пам'ять: 0.000 MB / 23.43 MB Application: beforeRenderModule mod_articles_latest (Останні новини)

Час: 7.54 ms / 656.10 ms Пам'ять: 0.612 MB / 24.05 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Час: 0.13 ms / 656.23 ms Пам'ять: 0.010 MB / 24.05 MB Application: After Access::getAssetRules (id:8 name:com_content)

Час: 12.38 ms / 668.61 ms Пам'ять: 0.270 MB / 24.32 MB Application: afterRenderModule mod_articles_latest (Останні новини)

Час: 0.18 ms / 668.79 ms Пам'ять: 0.000 MB / 24.25 MB Application: beforeRenderModule mod_custom (Застава Червоноград)

Час: 1.27 ms / 670.07 ms Пам'ять: 0.007 MB / 24.26 MB Application: afterRenderModule mod_custom (Застава Червоноград)

Час: 0.15 ms / 670.22 ms Пам'ять: 0.000 MB / 24.26 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Час: 7.12 ms / 677.34 ms Пам'ять: 0.040 MB / 24.30 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Час: 0.21 ms / 677.56 ms Пам'ять: 0.000 MB / 24.29 MB Application: beforeRenderModule mod_custom (Контакти шапка)

Час: 1.23 ms / 678.78 ms Пам'ять: 0.007 MB / 24.29 MB Application: afterRenderModule mod_custom (Контакти шапка)

Час: 7.64 ms / 686.43 ms Пам'ять: 0.179 MB / 24.47 MB Application: afterRender

Загальна кількість запитів до бази даних: 25.82 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_session	const	PRIMARY	PRIMARY	194	const	1

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

#	Виклик	Номер файлу і рядка
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN не можливий для запиту: INSERT INTO `z2ca3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3036336233373839343365343939303339663431303935626234373835333730', 1, 1734080067, 0, '', 0)

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Витрачений час на запит: 0.66 ms Після останнього запиту: 7.48 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 5.187 MB Повернуто рядків: 45

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

  FROM `z2ca3_extensions`

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

Роз'яснення

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

Профіль

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

Стек викликів

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

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

Витрачений час на запит: 0.51 ms Після останнього запиту: 5.88 ms Запит пам'яті: 0.015 MB пам'ять до запиту: 5.530 MB Повернуто рядків: 5

SELECT id, rules

  FROM `z2ca3_viewlevels`

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_viewlevels	ALL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	5

Профіль

Status	Duration
Starting	0.08 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
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Logging slow query	0.06 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.38 ms Після останнього запиту: 0.23 ms Запит пам'яті: 0.016 MB пам'ять до запиту: 5.555 MB Повернуто рядків: 2

SELECT b.id

  FROM z2ca3_usergroups AS a

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

  WHERE a.id = 9

Роз'яснення

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

Профіль

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

Стек викликів

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

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

Витрачений час на запит: 0.98 ms Після останнього запиту: 1.35 ms Запит пам'яті: 0.022 MB пам'ять до запиту: 5.662 MB Повернуто рядків: 103

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

  FROM z2ca3_extensions

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

  ORDER BY ordering

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_extensions	ALL	extension	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	266	Using where; Використовуючи filesort

Профіль

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.45 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Logging slow query	0.02 ms
Reset for next command	0.00 ms

Стек викликів

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

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

Витрачений час на запит: 0.64 ms Після останнього запиту: 29.02 ms Запит пам'яті: 0.018 MB пам'ять до запиту: 7.730 MB Повернуто рядків: 2

SELECT *

  FROM z2ca3_languages

  WHERE published=1

  ORDER BY ordering ASC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_languages	ALL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	2	Using where; Використовуючи filesort

Профіль

Status	Duration
Starting	0.10 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
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.07 ms
Logging slow query	0.06 ms
Reset for next command	0.01 ms

Стек викликів

#	Виклик	Номер файлу і рядка
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.50 ms Після останнього запиту: 0.30 ms Запит пам'яті: 0.015 MB пам'ять до запиту: 7.752 MB Повернуто рядків: 4

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `z2ca3_extensions`

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

Роз'яснення

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

Профіль

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	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.24 ms Після останнього запиту: 19.44 ms Запит пам'яті: 0.036 MB пам'ять до запиту: 8.523 MB Повернуто рядків: 16

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

  LEFT JOIN z2ca3_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

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	17	Using index condition; Using where; Використовуючи filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	zastavabrukivka.m.component_id	1	Using where

Профіль

Status	Duration
Starting	0.13 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.05 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.24 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
22	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Такий самий, як і виклик у нижньому рядку.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
19	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
18	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
17	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
16	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
15	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
14	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
13	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
12	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
11	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
10	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
9	PlgSystemLanguageFilter->onAfterInitialise()	Такий самий, як і виклик у нижньому рядку.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.94 ms Після останнього запиту: 46.70 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 11.036 MB Повернуто рядків: 1

SHOW TABLES LIKE "z2ca3_virtuemart_configs"

Роз'яснення

EXPLAIN не можливий для запиту: SHOW TABLES LIKE "z2ca3_virtuemart_configs"

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:723
14	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:574
13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:406
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:898
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:380
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.39 ms Після останнього запиту: 0.83 ms Запит пам'яті: 0.025 MB пам'ять до запиту: 11.130 MB Повернуто рядків: 1

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

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_virtuemart_configs	system	PRIMARY	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	1

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:446
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:898
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:380
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.57 ms Після останнього запиту: 2.56 ms Запит пам'яті: 0.030 MB пам'ять до запиту: 11.371 MB Повернуто рядків: 43

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

  FROM `z2ca3_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_contactus','com_content','com_contenthistory','com_cpanel','com_csvi','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_joomlycallback','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_smartslider3','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper','com_xmap')

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_assets	ALL	idx_asset_name	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	110	Using where

Профіль

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.01 ms
Statistics	0.11 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.17 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Logging slow query	0.05 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/vmaccess.php:145
14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:85
13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:468
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:898
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:380
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.43 ms Після останнього запиту: 2.95 ms Запит пам'яті: 0.033 MB пам'ять до запиту: 11.533 MB Повернуто рядків: 1

SELECT id, home, template, s.params

  FROM z2ca3_template_styles as s

  LEFT JOIN z2ca3_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

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	zastavabrukivka.s.template,const	1	Using index condition; Using where

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
13	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_virtuemart/router.php:855
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:903
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:380
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.33 ms Після останнього запиту: 0.72 ms Запит пам'яті: 0.019 MB пам'ять до запиту: 11.594 MB Повернуто рядків: 2

SELECT `id` 
  FROM `z2ca3_menu` 
  WHERE `home`="1" 
  and (language="*" or language = "uk-UA" ) 
  ORDER BY `language` DESC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_menu	ALL	idx_language	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	71	Using where; Використовуючи filesort

Профіль

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Logging slow query	0.02 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:866
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:903
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:380
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.40 ms Після останнього запиту: 0.15 ms Запит пам'яті: 0.027 MB пам'ять до запиту: 11.615 MB Повернуто рядків: 9

SELECT * 
  FROM `z2ca3_menu` 
  WHERE `link` like "index.php?option=com_virtuemart%" 
  and client_id=0 
  and published=1 
  and (language="*" or language = "uk-UA" ) 
  AND ( access="1" OR access="5" )  
  ORDER BY `language` DESC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	71	Using where; Використовуючи filesort

Профіль

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.12 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Logging slow query	0.02 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1334
13	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:889
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:903
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:380
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.55 ms Після останнього запиту: 0.32 ms Запит пам'яті: 0.019 MB пам'ять до запиту: 11.644 MB Повернуто рядків: 1

SELECT l.virtuemart_category_id  
  FROM `z2ca3_virtuemart_categories_uk_ua` as l  
  WHERE l.slug = "ceglynka"

Роз'яснення

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

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.26 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.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1256
12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1064
11	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:751
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.43 ms Після останнього запиту: 4.26 ms Запит пам'яті: 0.028 MB пам'ять до запиту: 12.006 MB Повернуто рядків: 1

SELECT `z2ca3_virtuemart_categories`.* ,`z2ca3_virtuemart_categories_uk_ua`.*  
  FROM `z2ca3_virtuemart_categories` 
  INNER JOIN `z2ca3_virtuemart_categories_uk_ua` using (`virtuemart_category_id`) 
  WHERE `z2ca3_virtuemart_categories`.`virtuemart_category_id` = "13"

Роз'яснення

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

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1044
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:89
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:942
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:755
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.32 ms Після останнього запиту: 1.26 ms Запит пам'яті: 0.020 MB пам'ять до запиту: 12.172 MB Повернуто рядків: 2

SELECT `virtuemart_media_id` 
  FROM `z2ca3_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "13" 
  ORDER BY `ordering`

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	2	Using where

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
13	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:92
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:942
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:755
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.31 ms Після останнього запиту: 0.09 ms Запит пам'яті: 0.019 MB пам'ять до запиту: 12.192 MB Повернуто рядків: 2

SELECT `category_child_id`
			
  FROM `z2ca3_virtuemart_category_categories`
			
  WHERE `category_parent_id` = 13

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_virtuemart_category_categories	ref	category_parent_id	category_parent_id	4	const	2	Using index

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Стек викликів

#	Виклик	Номер файлу і рядка
14	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_virtuemart/models/category.php:680
13	VirtueMartModelCategory->hasChildren()	JROOT/administrator/components/com_virtuemart/models/category.php:109
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:942
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:755
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.89 ms Після останнього запиту: 3.28 ms Запит пам'яті: 0.026 MB пам'ять до запиту: 12.416 MB Повернуто рядків: 2

SELECT c.virtuemart_category_id, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug 
  FROM z2ca3_virtuemart_categories as c  
  LEFT JOIN `z2ca3_virtuemart_categories_uk_ua` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  LEFT JOIN `z2ca3_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 13  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY c.ordering,category_name ASC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cx	ref	category_parent_id,category_child_id	category_parent_id	4	const	2	Using index; Using temporary; Використовуючи filesort
1	SIMPLE	c	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	zastavabrukivka.cx.category_child_id	1	Using where
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	zastavabrukivka.cx.category_child_id	1

Профіль

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Creating tmp table	0.10 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.45 ms
Creating sort index	0.03 ms
Removing tmp table	0.01 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек викликів

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

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

Витрачений час на запит: 0.20 ms Після останнього запиту: 0.15 ms Запит пам'яті: 0.026 MB пам'ять до запиту: 12.451 MB Повернуто рядків: 1

SELECT `virtuemart_media_id` 
  FROM `z2ca3_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "30" 
  ORDER BY `ordering`

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек викликів

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

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

Витрачений час на запит: 0.18 ms Після останнього запиту: 0.11 ms Запит пам'яті: 0.026 MB пам'ять до запиту: 12.476 MB Повернуто рядків: 1

SELECT `virtuemart_media_id` 
  FROM `z2ca3_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "31" 
  ORDER BY `ordering`

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек викликів

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

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

Витрачений час на запит: 0.70 ms Після останнього запиту: 0.55 ms Запит пам'яті: 0.020 MB пам'ять до запиту: 12.471 MB Повернуто рядків: 1

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

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ALL	PRIMARY,virtuemart_vendor_id,published	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	135	Using where
1	SIMPLE	pc	eq_ref	virtuemart_product_id	virtuemart_product_id	8	zastavabrukivka.p.virtuemart_product_id,const	1	Using index

Профіль

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.25 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Logging slow query	0.02 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:406
13	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:118
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:942
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:755
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.19 ms Після останнього запиту: 0.11 ms Запит пам'яті: 0.022 MB пам'ять до запиту: 12.492 MB Повернуто рядків: 1

Дублюючі запити: #29

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  z2ca3_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 13

Роз'яснення

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

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:772
14	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:712
13	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:121
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:942
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:755
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.20 ms Після останнього запиту: 0.12 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 12.514 MB Повернуто рядків: 1

SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `z2ca3_virtuemart_categories` as c  
  LEFT JOIN `z2ca3_virtuemart_categories_uk_ua` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  WHERE l.virtuemart_category_id = 13

Роз'яснення

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

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:733
13	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:121
12	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:942
11	vmrouterHelper::getLimitByCategory()	JROOT/components/com_virtuemart/router.php:755
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.29 ms Після останнього запиту: 1.12 ms Запит пам'яті: 0.026 MB пам'ять до запиту: 12.580 MB Повернуто рядків: 1

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

  FROM `z2ca3_extensions`

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

Роз'яснення

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

Профіль

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

Стек викликів

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

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

Витрачений час на запит: 0.26 ms Після останнього запиту: 0.24 ms Запит пам'яті: 0.018 MB пам'ять до запиту: 12.588 MB

UPDATE `z2ca3_extensions`

  SET `params` = '{\"mediaversion\":\"5502095255c8cd3c2fe4d903d7b4f1aa\"}'

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

Роз'яснення

EXPLAIN не можливий для запиту: UPDATE `z2ca3_extensions` SET `params` = '{\"mediaversion\":\"5502095255c8cd3c2fe4d903d7b4f1aa\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helixultimate/helixultimate.php:134
9	plgSystemHelixultimate->onAfterRoute()	Такий самий, як і виклик у нижньому рядку.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.46 ms Після останнього запиту: 35.54 ms Запит пам'яті: 0.030 MB пам'ять до запиту: 14.823 MB Повернуто рядків: 1

Дублюючі запити: #25

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  z2ca3_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 13

Роз'яснення

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

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:772
21	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:988
20	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:962
19	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/category/view.html.php:562
10	VirtuemartViewCategory->setCanonicalLink()	JROOT/components/com_virtuemart/views/category/view.html.php:128
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.17 ms Після останнього запиту: 0.09 ms Запит пам'яті: 0.031 MB пам'ять до запиту: 14.853 MB Повернуто рядків: 1

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  z2ca3_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 1

Роз'яснення

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

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
23	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:772
22	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:779
21	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:988
20	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:962
19	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_virtuemart/views/category/view.html.php:562
10	VirtuemartViewCategory->setCanonicalLink()	JROOT/components/com_virtuemart/views/category/view.html.php:128
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.63 ms Після останнього запиту: 12.90 ms Запит пам'яті: 0.028 MB пам'ять до запиту: 16.553 MB Повернуто рядків: 1

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

Роз'яснення

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

Профіль

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

Стек викликів

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

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

Витрачений час на запит: 0.20 ms Після останнього запиту: 0.17 ms Запит пам'яті: 0.031 MB пам'ять до запиту: 16.624 MB Повернуто рядків: 1

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

Роз'яснення

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

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек викликів

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

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

Витрачений час на запит: 0.54 ms Після останнього запиту: 1.86 ms Запит пам'яті: 0.019 MB пам'ять до запиту: 16.685 MB Повернуто рядків: 0

Дублюючі запити: #35

SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id` 
		
  FROM `z2ca3_virtuemart_products` as p   
 
  LEFT JOIN `z2ca3_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
 
  LEFT JOIN `z2ca3_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` 
 
  WHERE ( `pc`.`virtuemart_category_id` = 13 
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
 
  group by p.`virtuemart_product_id` 
 
  ORDER BY p.`created_on` ASC, p.`virtuemart_product_id` ASC 
  LIMIT 0, 12

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ps	system	virtuemart_product_id	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	0	Const row not found; Using temporary; Використовуючи filesort
1	SIMPLE	pc	index	virtuemart_product_id	virtuemart_product_id	8	NULL	139	Using where; Using index
1	SIMPLE	p	eq_ref	PRIMARY,published	PRIMARY	4	zastavabrukivka.pc.virtuemart_product_id	1	Using where

Профіль

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting for group	0.00 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Logging slow query	0.03 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:857
11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:803
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:269
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.13 ms Після останнього запиту: 0.11 ms Запит пам'яті: 0.018 MB пам'ять до запиту: 16.703 MB Повернуто рядків: 1

SELECT FOUND_ROWS()

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	NULL	No tables used

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.00 ms
After opening tables	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:870
11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:803
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:269
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.40 ms Після останнього запиту: 0.07 ms Запит пам'яті: 0.018 MB пам'ять до запиту: 16.721 MB Повернуто рядків: 0

Дублюючі запити: #33

SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id` 
		
  FROM `z2ca3_virtuemart_products` as p   
 
  LEFT JOIN `z2ca3_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`  
 
  LEFT JOIN `z2ca3_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` 
 
  WHERE ( `pc`.`virtuemart_category_id` = 13 
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  )  
  AND  p.`published`="1" ) 
 
  group by p.`virtuemart_product_id` 
 
  ORDER BY p.`created_on` ASC, p.`virtuemart_product_id` ASC 
  LIMIT 0, 12

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ps	system	virtuemart_product_id	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	0	Const row not found; Using temporary; Використовуючи filesort
1	SIMPLE	pc	index	virtuemart_product_id	virtuemart_product_id	8	NULL	139	Using where; Using index
1	SIMPLE	p	eq_ref	PRIMARY,published	PRIMARY	4	zastavabrukivka.pc.virtuemart_product_id	1	Using where

Профіль

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting for group	0.00 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.06 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Logging slow query	0.01 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:883
11	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/product.php:803
10	VirtueMartModelProduct->sortSearchListQuery()	JROOT/components/com_virtuemart/views/category/view.html.php:269
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.71 ms Після останнього запиту: 5.81 ms Запит пам'яті: 0.028 MB пам'ять до запиту: 17.334 MB Повернуто рядків: 1

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

Роз'яснення

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

Профіль

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

Стек викликів

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

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

Витрачений час на запит: 0.23 ms Після останнього запиту: 2.38 ms Запит пам'яті: 0.025 MB пам'ять до запиту: 17.506 MB Повернуто рядків: 1

SELECT `z2ca3_virtuemart_currencies`.*  
  FROM `z2ca3_virtuemart_currencies`  
  WHERE `z2ca3_virtuemart_currencies`.`virtuemart_currency_id` = "199"

Роз'яснення

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

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек викликів

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

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

Витрачений час на запит: 0.76 ms Після останнього запиту: 0.47 ms Запит пам'яті: 0.027 MB пам'ять до запиту: 17.550 MB Повернуто рядків: 1

SELECT `z2ca3_virtuemart_medias`.*  
  FROM `z2ca3_virtuemart_medias`  
  WHERE `z2ca3_virtuemart_medias`.`virtuemart_media_id` = "123"

Роз'яснення

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

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.45 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек викликів

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

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

Витрачений час на запит: 0.30 ms Після останнього запиту: 3.62 ms Запит пам'яті: 0.027 MB пам'ять до запиту: 17.941 MB Повернуто рядків: 1

SELECT `z2ca3_virtuemart_medias`.*  
  FROM `z2ca3_virtuemart_medias`  
  WHERE `z2ca3_virtuemart_medias`.`virtuemart_media_id` = "136"

Роз'яснення

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

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1044
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:480
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1197
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/category/view.html.php:347
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.20 ms Після останнього запиту: 0.44 ms Запит пам'яті: 0.027 MB пам'ять до запиту: 17.971 MB Повернуто рядків: 1

SELECT `z2ca3_virtuemart_medias`.*  
  FROM `z2ca3_virtuemart_medias`  
  WHERE `z2ca3_virtuemart_medias`.`virtuemart_media_id` = "137"

Роз'яснення

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

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1044
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:480
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1197
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/category/view.html.php:347
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.42 ms Після останнього запиту: 1.32 ms Запит пам'яті: 0.027 MB пам'ять до запиту: 18.085 MB Повернуто рядків: 1

SELECT `z2ca3_virtuemart_vendors`.* ,`z2ca3_virtuemart_vendors_uk_ua`.*  
  FROM `z2ca3_virtuemart_vendors` 
  INNER JOIN `z2ca3_virtuemart_vendors_uk_ua` using (`virtuemart_vendor_id`) 
  WHERE `z2ca3_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_virtuemart_vendors	system	PRIMARY	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	1
1	SIMPLE	z2ca3_virtuemart_vendors_uk_ua	system	PRIMARY	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	1

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1044
11	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:82
10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/category/view.html.php:395
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.31 ms Після останнього запиту: 1.21 ms Запит пам'яті: 0.018 MB пам'ять до запиту: 18.168 MB Повернуто рядків: 0

SELECT `virtuemart_media_id` 
  FROM `z2ca3_virtuemart_vendor_medias` 
  WHERE `virtuemart_vendor_id` = "1" 
  ORDER BY `ordering`

Роз'яснення

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

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:93
10	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/category/view.html.php:395
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.25 ms Після останнього запиту: 3.20 ms Запит пам'яті: 0.035 MB пам'ять до запиту: 18.260 MB Повернуто рядків: 1

Дублюючі запити: #44

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  z2ca3_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 30

Роз'яснення

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

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:772
25	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:988
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:962
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/templates/zastava/html/com_virtuemart/sublayouts/categories.php:36
14	include JROOT/templates/zastava/html/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:481
13	shopFunctionsF::renderVmSubLayout()	JROOT/templates/zastava/html/com_virtuemart/category/default.php:73
12	include JROOT/templates/zastava/html/com_virtuemart/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:514
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.18 ms Після останнього запиту: 0.11 ms Запит пам'яті: 0.037 MB пам'ять до запиту: 18.295 MB Повернуто рядків: 1

Дублюючі запити: #43

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  z2ca3_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 30

Роз'яснення

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

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
27	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:772
26	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:1024
25	vmrouterHelper->getCategoryNames()	JROOT/components/com_virtuemart/router.php:1003
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:962
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/templates/zastava/html/com_virtuemart/sublayouts/categories.php:36
14	include JROOT/templates/zastava/html/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:481
13	shopFunctionsF::renderVmSubLayout()	JROOT/templates/zastava/html/com_virtuemart/category/default.php:73
12	include JROOT/templates/zastava/html/com_virtuemart/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:514
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.30 ms Після останнього запиту: 0.21 ms Запит пам'яті: 0.045 MB пам'ять до запиту: 18.360 MB Повернуто рядків: 1

SELECT `z2ca3_virtuemart_categories`.* ,`z2ca3_virtuemart_categories_uk_ua`.*  
  FROM `z2ca3_virtuemart_categories` 
  INNER JOIN `z2ca3_virtuemart_categories_uk_ua` using (`virtuemart_category_id`) 
  WHERE `z2ca3_virtuemart_categories`.`virtuemart_category_id` = "30"

Роз'яснення

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

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
28	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1044
27	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:89
26	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:1035
25	vmrouterHelper->getCategoryNames()	JROOT/components/com_virtuemart/router.php:1003
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:962
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/templates/zastava/html/com_virtuemart/sublayouts/categories.php:36
14	include JROOT/templates/zastava/html/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:481
13	shopFunctionsF::renderVmSubLayout()	JROOT/templates/zastava/html/com_virtuemart/category/default.php:73
12	include JROOT/templates/zastava/html/com_virtuemart/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:514
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.24 ms Після останнього запиту: 2.09 ms Запит пам'яті: 0.035 MB пам'ять до запиту: 18.406 MB Повернуто рядків: 1

Дублюючі запити: #47

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  z2ca3_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 31

Роз'яснення

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

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
26	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:772
25	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:988
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:962
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/templates/zastava/html/com_virtuemart/sublayouts/categories.php:36
14	include JROOT/templates/zastava/html/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:481
13	shopFunctionsF::renderVmSubLayout()	JROOT/templates/zastava/html/com_virtuemart/category/default.php:73
12	include JROOT/templates/zastava/html/com_virtuemart/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:514
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.18 ms Після останнього запиту: 0.12 ms Запит пам'яті: 0.037 MB пам'ять до запиту: 18.441 MB Повернуто рядків: 1

Дублюючі запити: #46

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  z2ca3_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 31

Роз'яснення

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

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
27	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:772
26	VirtueMartModelCategory->getCategoryRecurse()	JROOT/components/com_virtuemart/router.php:1024
25	vmrouterHelper->getCategoryNames()	JROOT/components/com_virtuemart/router.php:1003
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:962
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/templates/zastava/html/com_virtuemart/sublayouts/categories.php:36
14	include JROOT/templates/zastava/html/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:481
13	shopFunctionsF::renderVmSubLayout()	JROOT/templates/zastava/html/com_virtuemart/category/default.php:73
12	include JROOT/templates/zastava/html/com_virtuemart/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:514
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.25 ms Після останнього запиту: 0.27 ms Запит пам'яті: 0.045 MB пам'ять до запиту: 18.506 MB Повернуто рядків: 1

SELECT `z2ca3_virtuemart_categories`.* ,`z2ca3_virtuemart_categories_uk_ua`.*  
  FROM `z2ca3_virtuemart_categories` 
  INNER JOIN `z2ca3_virtuemart_categories_uk_ua` using (`virtuemart_category_id`) 
  WHERE `z2ca3_virtuemart_categories`.`virtuemart_category_id` = "31"

Роз'яснення

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

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
28	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1044
27	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/category.php:89
26	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/router.php:1035
25	vmrouterHelper->getCategoryNames()	JROOT/components/com_virtuemart/router.php:1003
24	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:962
23	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:74
22	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/templates/zastava/html/com_virtuemart/sublayouts/categories.php:36
14	include JROOT/templates/zastava/html/com_virtuemart/sublayouts/categories.php	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:481
13	shopFunctionsF::renderVmSubLayout()	JROOT/templates/zastava/html/com_virtuemart/category/default.php:73
12	include JROOT/templates/zastava/html/com_virtuemart/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:46
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:514
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.95 ms Після останнього запиту: 6.66 ms Запит пам'яті: 0.034 MB пам'ять до запиту: 19.257 MB Повернуто рядків: 31

SHOW FULL COLUMNS  
  FROM `z2ca3_virtuemart_userfields`

Роз'яснення

EXPLAIN не можливий для запиту: SHOW FULL COLUMNS FROM `z2ca3_virtuemart_userfields`

Профіль

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

Стек викликів

#	Виклик	Номер файлу і рядка
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
22	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:684
21	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
20	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:210
19	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:432
18	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:394
17	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:600
16	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
15	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:552
14	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:296
13	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:185
12	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/helpers/vmview.php:63
11	VmView->withKeepAlive()	JROOT/components/com_virtuemart/helpers/vmview.php:53
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:514
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.42 ms Після останнього запиту: 0.32 ms Запит пам'яті: 0.037 MB пам'ять до запиту: 19.351 MB Повернуто рядків: 21

SELECT * 
  FROM `z2ca3_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `account`="1" 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type') = 0  
  ORDER BY ordering

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_virtuemart_userfields	ALL	published,account	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	28	Using where; Використовуючи filesort

Профіль

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.13 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Logging slow query	0.04 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497
16	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:601
15	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:486
14	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:337
13	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:185
12	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/helpers/vmview.php:63
11	VmView->withKeepAlive()	JROOT/components/com_virtuemart/helpers/vmview.php:53
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:514
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.59 ms Після останнього запиту: 39.30 ms Запит пам'яті: 0.036 MB пам'ять до запиту: 21.609 MB Повернуто рядків: 14

SELECT * 
  FROM `z2ca3_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

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_virtuemart_userfields	ALL	published,shipment	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	28	Using where; Використовуючи filesort

Профіль

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.12 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Logging slow query	0.03 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497
16	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:601
15	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:492
14	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:337
13	VirtueMartCart->setupAddressFieldsForCart()	JROOT/components/com_virtuemart/helpers/cart.php:185
12	VirtueMartCart::getCart()	JROOT/components/com_virtuemart/helpers/vmview.php:63
11	VmView->withKeepAlive()	JROOT/components/com_virtuemart/helpers/vmview.php:53
10	VmView->display()	JROOT/components/com_virtuemart/views/category/view.html.php:514
9	VirtuemartViewCategory->display()	JROOT/components/com_virtuemart/controllers/category.php:54
8	VirtueMartControllerCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.33 ms Після останнього запиту: 1.68 ms Запит пам'яті: 0.015 MB пам'ять до запиту: 21.701 MB Повернуто рядків: 2

SELECT language,id

  FROM `z2ca3_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2ca3_menu	ALL	idx_client_id_parent_id_alias_language	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	71	Using where

Профіль

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Logging slow query	0.02 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
9	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
8	PlgSystemLanguageFilter->onAfterDispatch()	Такий самий, як і виклик у нижньому рядку.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.06 ms Після останнього запиту: 35.59 ms Запит пам'яті: 0.027 MB пам'ять до запиту: 23.172 MB Повернуто рядків: 10

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

  FROM z2ca3_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-12-13 08:54:27') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-13 08:54:27') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 131 OR mm.menuid <= 0) 
  AND m.language IN ('uk-UA','*')

  ORDER BY m.position, m.ordering

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	17	Using index condition; Using where; Використовуючи filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	zastavabrukivka.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	zastavabrukivka.m.module,const	1	Using index condition; Using where

Профіль

Status	Duration
Starting	0.14 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.07 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.29 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	Такий самий, як і виклик у нижньому рядку.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helixultimate/core/helixultimate.php:570
11	HelixUltimate->count_modules()	JROOT/plugins/system/helixultimate/core/helixultimate.php:374
10	HelixUltimate->get_current_row()	JROOT/plugins/system/helixultimate/core/helixultimate.php:306
9	HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/core/helixultimate.php:274
8	HelixUltimate->render_layout()	JROOT/templates/zastava/index.php:151
7	require JROOT/templates/zastava/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.61 ms Після останнього запиту: 248.29 ms Запит пам'яті: 0.018 MB пам'ять до запиту: 23.282 MB Повернуто рядків: 1

SELECT params

  FROM z2ca3_modules

  WHERE id=93

Роз'яснення

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

Профіль

Status	Duration
Starting	0.10 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
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.11 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/modules/mod_joomly_callback/helper.php:37
11	ModJoomlyCallbackHelper::getFields()	JROOT/modules/mod_joomly_callback/mod_joomly_callback.php:18
10	include JROOT/modules/mod_joomly_callback/mod_joomly_callback.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.95 ms Після останнього запиту: 25.02 ms Запит пам'яті: 0.032 MB пам'ять до запиту: 24.055 MB Повернуто рядків: 3

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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

  FROM z2ca3_content AS a

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (8) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-12-13 08:54:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-13 08:54:27') 
  AND a.language IN ('uk-UA','*')

  ORDER BY a.publish_up DESC 
  LIMIT 3

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	7	Using where; Використовуючи filesort
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	zastavabrukivka.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	zastavabrukivka.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where

Профіль

Status	Duration
Starting	0.18 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.00 ms
init	0.09 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.17 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:123
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/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.48 ms Після останнього запиту: 3.07 ms Запит пам'яті: 0.039 MB пам'ять до запиту: 24.243 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 `z2ca3_categories` AS `s`

  INNER JOIN `z2ca3_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('uk-UA','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

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

  ORDER BY c.lft

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	7	Using where; Використовуючи filesort

Профіль

Status	Duration
Starting	0.09 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Logging slow query	0.06 ms
Reset for next command	0.00 ms

Стек викликів

#	Виклик	Номер файлу і рядка
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Такий самий, як і виклик у нижньому рядку.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:135
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/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

41 типи запитів: зареєстрований, відсортований за знайденим

Вибірка таблиць:

7 &#215; SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`     
  FROM  z2ca3_virtuemart_category_categories AS `xref`

3 &#215; SELECT `z2ca3_virtuemart_medias`.*  
  FROM `z2ca3_virtuemart_medias`

3 &#215; SELECT `z2ca3_virtuemart_categories`.* ,`z2ca3_virtuemart_categories_uk_ua`.*  
  FROM `z2ca3_virtuemart_categories` 
  INNER JOIN `z2ca3_virtuemart_categories_uk_ua` using (`virtuemart_category_id`)

3 &#215; SELECT `virtuemart_media_id` 
  FROM `z2ca3_virtuemart_category_medias`

2 &#215; SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `z2ca3_extensions`

2 &#215; SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id`    
  FROM `z2ca3_virtuemart_products` as p     
  LEFT JOIN `z2ca3_virtuemart_product_shoppergroups` as ps 
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`    
  LEFT JOIN `z2ca3_virtuemart_product_categories` as pc 
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`

2 &#215; SELECT * 
  FROM `z2ca3_virtuemart_userfields`

```
1 &#215; SELECT FOUND_ROWS(
```

1 &#215; SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `z2ca3_virtuemart_categories` as c  
  LEFT JOIN `z2ca3_virtuemart_categories_uk_ua` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id`

1 &#215; SELECT *  
  FROM `z2ca3_virtuemart_currencies` AS c    
  LEFT JOIN `z2ca3_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency

1 &#215; SELECT * 
  FROM `z2ca3_virtuemart_shoppergroups`

1 &#215; SELECT `z2ca3_virtuemart_shoppergroups`.*  
  FROM `z2ca3_virtuemart_shoppergroups`

1 &#215; SELECT `z2ca3_virtuemart_vendors`.* ,`z2ca3_virtuemart_vendors_uk_ua`.*  
  FROM `z2ca3_virtuemart_vendors` 
  INNER JOIN `z2ca3_virtuemart_vendors_uk_ua` using (`virtuemart_vendor_id`)

1 &#215; SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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 
  FROM z2ca3_content AS a 
  LEFT JOIN z2ca3_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN z2ca3_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN z2ca3_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN z2ca3_categories as parent 
  ON parent.id = c.parent_id

1 &#215; 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 `z2ca3_categories` AS `s` 
  INNER JOIN `z2ca3_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('uk-UA','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

1 &#215; SELECT params 
  FROM z2ca3_modules

1 &#215; SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM z2ca3_modules AS m 
  LEFT JOIN z2ca3_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN z2ca3_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 &#215; SELECT `virtuemart_media_id` 
  FROM `z2ca3_virtuemart_vendor_medias`

1 &#215; SELECT language,id 
  FROM `z2ca3_menu`

1 &#215; SELECT `z2ca3_virtuemart_currencies`.*  
  FROM `z2ca3_virtuemart_currencies`

1 &#215; SELECT c.virtuemart_category_id, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug 
  FROM z2ca3_virtuemart_categories as c  
  LEFT JOIN `z2ca3_virtuemart_categories_uk_ua` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  LEFT JOIN `z2ca3_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`

1 &#215; SELECT * 
  FROM z2ca3_languages

1 &#215; SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `z2ca3_extensions`

1 &#215; 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 z2ca3_menu AS m 
  LEFT JOIN z2ca3_extensions AS e 
  ON m.component_id = e.extension_id

1 &#215; SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM z2ca3_extensions

1 &#215; SELECT b.id 
  FROM z2ca3_usergroups AS a 
  LEFT JOIN z2ca3_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 &#215; SELECT `session_id` 
  FROM `z2ca3_session`

1 &#215; SELECT id, rules 
  FROM `z2ca3_viewlevels

1 &#215; SELECT `config` 
  FROM `z2ca3_virtuemart_configs`

1 &#215; SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `z2ca3_assets`

1 &#215; SELECT `category_child_id`    
  FROM `z2ca3_virtuemart_category_categories`

1 &#215; SELECT `data` 
  FROM `z2ca3_session`

1 &#215; SELECT l.virtuemart_category_id  
  FROM `z2ca3_virtuemart_categories_uk_ua` as l

```
1 &#215; SELECT * 
  FROM `z2ca3_menu`
```

1 &#215; SELECT id, home, template, s.params 
  FROM z2ca3_template_styles as s 
  LEFT JOIN z2ca3_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 &#215; SELECT `id` 
  FROM `z2ca3_menu`

1 &#215; SELECT count(`p`.virtuemart_product_id) AS total    
  FROM `z2ca3_virtuemart_product_categories` as `pc`   
  LEFT JOIN `z2ca3_virtuemart_products` as `p` 
  ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id

Інші таблиці:

1 &#215; SHOW FULL COLUMNS  
  FROM `z2ca3_virtuemart_userfields

1 &#215; UPDATE `z2ca3_extensions` 
  SET `params` = '{\"mediaversion\":\"5502095255c8cd3c2fe4d903d7b4f1aa\"}'

1 &#215; SHOW TABLES LIKE "z2ca3_virtuemart_configs

1 &#215; INSERT INTO `z2ca3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3036336233373839343365343939303339663431303935626234373835333730', 1, 1734080067, 0, '', 0

Застава Червоноград

Останні новини

Замовлення зворотного дзвінка

Замовлення зворотного дзвінка

Консоль налагодження Joomla

Сесія

Інформація облікового запису

Час

Пам'ять

Використання пам'яті

Запити до бази даних

56 запитів для зареєстрованих користувачів 25.82 ms

8 дублікат(-ів) знайдено!

41 типи запитів: зареєстрований, відсортований за знайденим

Вибірка таблиць:

Інші таблиці: