Ваги з друком етикетки ВТНЕ-ПРИНТ-60Т1-2

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

Сесія

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732182957,
                "last": 1732182957,
                "now": 1732182957
            },
            "token": "tEP1uvX8Ii0S0BgyabfSjw9TRwEfrGex"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "uk-UA"
        },
        "js_id_currency_orig": "2",
        "js_id_currency": "2",
        "js_history_sel_lang": "uk-UA",
        "js_prev_user_id": 0,
        "jshop_checked_language": [
            "en-GB",
            "ru-RU",
            "uk-UA"
        ],
        "jshop_end_page_buy_product": "/uk/katehorii/vahy-z-drukom-etyketky-vtne-prynt-uk/vahy-z-drukom-etyketky-vtne-prynt-60t1-2",
        "product_back_value": []
    }
}

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

Час

Пам'ять

Час: 3.92 ms / 3.92 ms Пам'ять: 0.647 MB / 1.01 MB Application: afterLoad

Час: 53.55 ms / 57.47 ms Пам'ять: 1.372 MB / 2.38 MB Application: afterInitialise

Час: 24.95 ms / 82.43 ms Пам'ять: 1.081 MB / 3.46 MB Application: afterRoute

Час: 2.23 ms / 84.65 ms Пам'ять: 0.012 MB / 3.47 MB Application: beforeRenderComponent com_jshopping

Час: 61.89 ms / 146.54 ms Пам'ять: 1.446 MB / 4.92 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Час: 0.96 ms / 147.50 ms Пам'ять: 0.015 MB / 4.93 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Час: 0.19 ms / 147.69 ms Пам'ять: 0.010 MB / 4.94 MB Application: beforeRenderModule mod_custom (inproduct)

Час: 0.69 ms / 148.38 ms Пам'ять: 0.006 MB / 4.95 MB Application: afterRenderModule mod_custom (inproduct)

Час: 0.39 ms / 148.77 ms Пам'ять: -0.026 MB / 4.92 MB Application: afterRenderComponent com_jshopping

Час: 3.02 ms / 151.79 ms Пам'ять: 0.027 MB / 4.95 MB Application: afterDispatch

Час: 0.76 ms / 152.55 ms Пам'ять: 0.114 MB / 5.06 MB Application: beforeRenderModule mod_custom (Контакти внизу)

Час: 0.21 ms / 152.75 ms Пам'ять: 0.003 MB / 5.07 MB Application: afterRenderModule mod_custom (Контакти внизу)

Час: 1.18 ms / 153.94 ms Пам'ять: 0.032 MB / 5.10 MB Application: beforeRenderModule mod_languages (Выбор языка)

Час: 1.46 ms / 155.40 ms Пам'ять: 0.016 MB / 5.12 MB Application: afterRenderModule mod_languages (Выбор языка)

Час: 0.26 ms / 155.66 ms Пам'ять: -0.003 MB / 5.11 MB Application: beforeRenderModule mod_custom (Контакты вверху)

Час: 0.24 ms / 155.89 ms Пам'ять: 0.003 MB / 5.12 MB Application: afterRenderModule mod_custom (Контакты вверху)

Час: 0.33 ms / 156.22 ms Пам'ять: 0.001 MB / 5.12 MB Application: beforeRenderModule mod_custom (Logo (uk))

Час: 0.19 ms / 156.41 ms Пам'ять: 0.005 MB / 5.12 MB Application: afterRenderModule mod_custom (Logo (uk))

Час: 0.31 ms / 156.72 ms Пам'ять: -0.001 MB / 5.12 MB Application: beforeRenderModule mod_jshopping_cart (Cart)

Час: 1.06 ms / 157.77 ms Пам'ять: 0.008 MB / 5.13 MB Application: afterRenderModule mod_jshopping_cart (Cart)

Час: 0.05 ms / 157.82 ms Пам'ять: -0.001 MB / 5.13 MB Application: beforeRenderModule mod_jshopping_search (Поиск товаров)

Час: 0.74 ms / 158.56 ms Пам'ять: 0.007 MB / 5.13 MB Application: afterRenderModule mod_jshopping_search (Поиск товаров)

Час: 0.35 ms / 158.90 ms Пам'ять: 0.002 MB / 5.14 MB Application: beforeRenderModule mod_menu (Українське меню)

Час: 5.19 ms / 164.09 ms Пам'ять: 0.113 MB / 5.25 MB Application: afterRenderModule mod_menu (Українське меню)

Час: 4.67 ms / 168.76 ms Пам'ять: 0.014 MB / 5.26 MB Application: beforeRenderModule mod_custom (counter)

Час: 0.26 ms / 169.02 ms Пам'ять: 0.003 MB / 5.27 MB Application: afterRenderModule mod_custom (counter)

Час: 0.05 ms / 169.06 ms Пам'ять: 0.000 MB / 5.27 MB Application: beforeRenderModule mod_custom (copyright)

Час: 0.21 ms / 169.27 ms Пам'ять: 0.003 MB / 5.27 MB Application: afterRenderModule mod_custom (copyright)

Час: 0.04 ms / 169.31 ms Пам'ять: 0.000 MB / 5.27 MB Application: beforeRenderModule mod_custom (Карта сайта UA)

Час: 0.17 ms / 169.49 ms Пам'ять: 0.003 MB / 5.27 MB Application: afterRenderModule mod_custom (Карта сайта UA)

Час: 0.57 ms / 170.06 ms Пам'ять: 0.003 MB / 5.27 MB Application: beforeRenderModule mod_menu (Українське меню (2))

Час: 2.22 ms / 172.28 ms Пам'ять: 0.009 MB / 5.28 MB Application: afterRenderModule mod_menu (Українське меню (2))

Час: 14.07 ms / 186.35 ms Пам'ять: 0.261 MB / 5.54 MB Application: afterRender

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

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

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Caller	File and line number
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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Профіль

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init for update	0.02 ms
Update	0.09 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	2.32 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:414
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 для посилання файлів]

Витрачений час на запит: 1.42 ms Після останнього запиту: 0.91 ms Запит пам'яті: 0.047 MB пам'ять до запиту: 1.391 MB Повернуто рядків: 40

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

  FROM `j32_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	j32_extensions	ref	extension	extension	82	const	42	Using index condition; Using where

Профіль

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.11 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.50 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	1.02 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
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}()	Same as call in the line below.
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.66 ms Після останнього запиту: 0.72 ms Запит пам'яті: 0.023 MB пам'ять до запиту: 1.450 MB Повернуто рядків: 6

SELECT id, rules

  FROM `j32_viewlevels`

Роз'яснення

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

Профіль

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.24 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
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:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.05 ms Після останнього запиту: 0.12 ms Запит пам'яті: 0.022 MB пам'ять до запиту: 1.463 MB Повернуто рядків: 2

SELECT b.id

  FROM j32_usergroups AS a

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

  WHERE a.id = 10

Роз'яснення

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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	10	Using where; Using index

Профіль

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.43 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.32 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
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:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.83 ms Після останнього запиту: 0.21 ms Запит пам'яті: 0.092 MB пам'ять до запиту: 1.485 MB Повернуто рядків: 84

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

  FROM j32_extensions

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

  ORDER BY ordering

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j32_extensions	ref	extension	extension	82	const	139	Using index condition; Using where; Використовуючи filesort

Профіль

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.16 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	11.58 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
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:356
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM j32_languages

  WHERE published=1

  ORDER BY ordering ASC

Роз'яснення

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

Профіль

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.12 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
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:280
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:695
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 2.35 ms Після останнього запиту: 0.18 ms Запит пам'яті: 0.024 MB пам'ять до запиту: 2.125 MB Повернуто рядків: 6

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

  FROM `j32_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	j32_extensions	ref	extension	extension	82	const	6	Using index condition; Using where

Профіль

Status	Duration
Starting	1.03 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.37 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.29 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
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:280
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:695
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.85 ms Після останнього запиту: 14.28 ms Запит пам'яті: 0.048 MB пам'ять до запиту: 2.212 MB Повернуто рядків: 29

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

  LEFT JOIN j32_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	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	71	Using index condition; Using where; Використовуючи filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	vesi.m.component_id	1	Using where

Профіль

Status	Duration
Starting	0.16 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.81 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:445
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:561
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 2.85 ms Після останнього запиту: 6.11 ms Запит пам'яті: 0.052 MB пам'ять до запиту: 2.690 MB Повернуто рядків: 140

SHOW FULL COLUMNS 
  FROM `j32_jshopping_config`

Роз'яснення

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

Профіль

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	0.64 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.05 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.73 ms
Closing tables	0.03 ms
Executing	0.01 ms
Sending data	0.26 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.18 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/config.php:14
15	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1580
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.00 ms Після останнього запиту: 1.40 ms Запит пам'яті: 0.071 MB пам'ять до запиту: 2.976 MB Повернуто рядків: 1

SELECT *

  FROM j32_jshopping_config

  WHERE `id` = '1'

Роз'яснення

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

Профіль

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.10 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.13 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
15	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/lib/factory.php:30
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1580
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.70 ms Після останнього запиту: 0.51 ms Запит пам'яті: 0.031 MB пам'ять до запиту: 2.974 MB Повернуто рядків: 8

SHOW FULL COLUMNS 
  FROM `j32_jshopping_currencies`

Роз'яснення

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

Профіль

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Closing tables	0.01 ms
Opening tables	0.64 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.17 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.16 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
20	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/currency.php:14
19	jshopCurrency->__construct()	JROOT/libraries/src/Table/Table.php:328
18	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
17	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:569
16	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
15	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1580
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.78 ms Після останнього запиту: 0.16 ms Запит пам'яті: 0.027 MB пам'ять до запиту: 2.999 MB Повернуто рядків: 2

SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `j32_jshopping_currencies` 
  WHERE currency_publish = '1' 
  ORDER BY currency_ordering

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j32_jshopping_currencies	ref	currency_publish	currency_publish	1	const	1	Using where; Використовуючи filesort

Профіль

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

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

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:22
17	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:570
16	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:53
15	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:32
14	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:143
13	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:166
12	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/lib/functions.php:1580
11	initLoadJoomshoppingLanguageFile()	JROOT/components/com_jshopping/router.php:225
10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 2.09 ms Після останнього запиту: 0.90 ms Запит пам'яті: 0.036 MB пам'ять до запиту: 3.006 MB Повернуто рядків: 157

select product_id as id, `alias_uk-UA` as alias 
  from j32_jshopping_products 
  where `alias_uk-UA`!=''

Роз'яснення

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

Профіль

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	1.30 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:303
11	JSFactory::getAliasProduct()	JROOT/components/com_jshopping/router.php:286
10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1170
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.08 ms Після останнього запиту: 0.80 ms Запит пам'яті: 0.030 MB пам'ять до запиту: 3.047 MB Повернуто рядків: 157

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

SHOW TABLES

Роз'яснення

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

Профіль

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

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

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:220
8	plgSystemjdownloads->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1218
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `j32_extensions`

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

Роз'яснення

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

Профіль

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.10 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcktypography/jcktypography.php:48
8	plgSystemJCKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1218
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

UPDATE `j32_extensions`

  SET `params` = '{\"mediaversion\":\"5c8fead640acad61e4a837a732245b06\"}'

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

Роз'яснення

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

Профіль

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.02 ms
Init for update	0.09 ms
Updating	0.10 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.05 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcktypography/jcktypography.php:48
8	plgSystemJCKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1218
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.09 ms Після останнього запиту: 1.22 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 3.466 MB Повернуто рядків: 5

SELECT id, home, template, s.params

  FROM j32_template_styles as s

  LEFT JOIN j32_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	ALL	idx_template,idx_client_id,idx_client_id_home	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	7	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	vesi.s.template,const	1	Using index condition; Using where

Профіль

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.04 ms
Statistics	0.12 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.20 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.75 ms Після останнього запиту: 6.73 ms Запит пам'яті: 0.024 MB пам'ять до запиту: 3.493 MB Повернуто рядків: 3

select * 
  from j32_jshopping_languages

Роз'яснення

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

Профіль

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/functions.php:296
8	installNewLanguages()	JROOT/components/com_jshopping/loadparams.php:33
7	require JROOT/components/com_jshopping/loadparams.php	JROOT/components/com_jshopping/jshopping.php:16
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 2.57 ms Після останнього запиту: 3.97 ms Запит пам'яті: 0.041 MB пам'ять до запиту: 3.614 MB Повернуто рядків: 83

SHOW FULL COLUMNS 
  FROM `j32_jshopping_products`

Роз'яснення

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

Профіль

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	0.68 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.56 ms
Closing tables	0.03 ms
Executing	0.02 ms
Sending data	0.18 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.17 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.26 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/product.php:15
11	jshopProduct->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
9	JSFactory::getTable()	JROOT/components/com_jshopping/controllers/product.php:44
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM j32_jshopping_products

  WHERE `product_id` = '176'

Роз'яснення

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

Профіль

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.07 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.19 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/controllers/product.php:45
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.81 ms Після останнього запиту: 0.37 ms Запит пам'яті: 0.035 MB пам'ять до запиту: 3.795 MB Повернуто рядків: 32

SHOW FULL COLUMNS 
  FROM `j32_jshopping_categories`

Роз'яснення

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

Профіль

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	0.60 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.26 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.14 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/category.php:15
11	jshopCategory->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
9	JSFactory::getTable()	JROOT/components/com_jshopping/controllers/product.php:47
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM j32_jshopping_categories

  WHERE `category_id` = '12'

Роз'яснення

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

Профіль

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.15 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/controllers/product.php:48
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `j32_jshopping_products_to_categories` 
  WHERE product_id=176

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j32_jshopping_products_to_categories	ref	PRIMARY,product_id,product_id_2	product_id_2	4	const	1	Using index

Профіль

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:282
10	jshopProduct->getCategories()	JROOT/components/com_jshopping/models/productshop.php:81
9	jshopProductShop->getCategories()	JROOT/components/com_jshopping/controllers/product.php:53
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.57 ms Після останнього запиту: 0.25 ms Запит пам'яті: 0.031 MB пам'ять до запиту: 3.893 MB Повернуто рядків: 13

SHOW FULL COLUMNS 
  FROM `j32_jshopping_attr`

Роз'яснення

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

Профіль

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Closing tables	0.01 ms
Opening tables	0.56 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
Checking permissions	0.13 ms
Closing tables	0.05 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.16 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/attribut.php:14
16	jshopAttribut->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:317
13	JSFactory::getAllAttributes()	JROOT/components/com_jshopping/tables/product.php:128
12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:207
11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:235
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:94
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.39 ms Після останнього запиту: 0.14 ms Запит пам'яті: 0.028 MB пам'ять до запиту: 3.925 MB Повернуто рядків: 6

SELECT A.attr_id, A.`name_uk-UA` as name, A.`description_uk-UA` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_uk-UA` as groupname
                  
  FROM `j32_jshopping_attr` as A 
  left join `j32_jshopping_attr_groups` as G 
  on A.`
  group`=G.id
                  
  ORDER BY G.ordering, A.attr_ordering

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	A	ALL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	6	Using temporary; Використовуючи filesort
1	SIMPLE	G	eq_ref	PRIMARY	PRIMARY	4	vesi.A.group	1	Using where

Профіль

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

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

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/attribut.php:28
14	jshopAttribut->getAllAttributes()	JROOT/components/com_jshopping/lib/factory.php:318
13	JSFactory::getAllAttributes()	JROOT/components/com_jshopping/tables/product.php:128
12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:207
11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:235
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:94
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.63 ms Після останнього запиту: 0.10 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 3.956 MB Повернуто рядків: 0

SELECT * 
  FROM `j32_jshopping_products_attr` 
  WHERE product_id=176 
  ORDER BY product_attr_id

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j32_jshopping_products_attr	ref	product_id	product_id	4	const	1	Using where; Використовуючи filesort

Профіль

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.04 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:159
13	jshopProduct->getAttributes()	JROOT/components/com_jshopping/tables/product.php:133
12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:207
11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:235
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:94
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `j32_jshopping_products_attr2` 
  WHERE product_id=176 
  ORDER BY id

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j32_jshopping_products_attr2	ref	product_id	product_id	4	const	1	Using where; Використовуючи filesort

Профіль

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:168
13	jshopProduct->getAttributes2()	JROOT/components/com_jshopping/tables/product.php:144
12	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:207
11	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/tables/product.php:235
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:94
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.87 ms Після останнього запиту: 0.17 ms Запит пам'яті: 0.038 MB пам'ять до запиту: 3.977 MB Повернуто рядків: 53

SHOW FULL COLUMNS 
  FROM `j32_jshopping_users`

Роз'яснення

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

Профіль

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	0.56 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.38 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.15 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/usershopbase.php:14
14	jshopUserShopBase->__construct()	JROOT/components/com_jshopping/tables/usershop.php:15
13	jshopUserShop->__construct()	JROOT/components/com_jshopping/lib/factory.php:47
12	JSFactory::getUserShop()	JROOT/components/com_jshopping/tables/product.php:1139
11	jshopProduct->getBuildSelectAttributes()	JROOT/components/com_jshopping/tables/product.php:239
10	jshopProduct->getInitLoadAttribute()	JROOT/components/com_jshopping/models/productshop.php:94
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.49 ms Після останнього запиту: 0.46 ms Запит пам'яті: 0.032 MB пам'ять до запиту: 4.081 MB Повернуто рядків: 13

SHOW FULL COLUMNS 
  FROM `j32_jshopping_products_extra_fields`

Роз'яснення

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

Профіль

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Closing tables	0.01 ms
Opening tables	0.51 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.12 ms
Closing tables	0.02 ms
Executing	0.02 ms
Sending data	0.16 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.13 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
18	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/productfield.php:14
17	jshopProductField->__construct()	JROOT/libraries/src/Table/Table.php:328
16	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
15	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:496
14	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1121
13	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:214
12	JTableAvto->getBuildQueryListProductSimpleList()	JROOT/components/com_jshopping/tables/product.php:850
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:533
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:103
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.20 ms Після останнього запиту: 0.13 ms Запит пам'яті: 0.037 MB пам'ять до запиту: 4.114 MB Повернуто рядків: 28

SELECT F.id, F.`name_uk-UA` as name, F.`description_uk-UA` as description, F.allcats, F.type, F.cats, F.ordering, F.`
  group`, G.`name_uk-UA` as groupname, multilist 
  FROM `j32_jshopping_products_extra_fields` as F 
  left join `j32_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group 
  order by G.ordering, F.ordering

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	G	system	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	0	Const row not found
1	SIMPLE	F	ALL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	28	Використовуючи filesort

Профіль

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.49 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfield.php:48
15	jshopProductField->getList()	JROOT/components/com_jshopping/lib/factory.php:497
14	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1121
13	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:214
12	JTableAvto->getBuildQueryListProductSimpleList()	JROOT/components/com_jshopping/tables/product.php:850
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:533
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:103
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.99 ms Після останнього запиту: 0.63 ms Запит пам'яті: 0.032 MB пам'ять до запиту: 4.201 MB Повернуто рядків: 15

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

  FROM j32_modules AS m

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

  LEFT JOIN j32_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-11-21 09:55:57') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 09:55:57') 
  AND m.access IN (1,1,7) 
  AND m.client_id = 0 
  AND (mm.menuid = 339 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	38	Using index condition; Using where; Використовуючи filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	vesi.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	vesi.m.module,const	1	Using index condition; Using where

Профіль

Status	Duration
Starting	0.13 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.07 ms
Optimizing	0.06 ms
Statistics	0.14 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.98 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	Same as call in the line below.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:37
15	Joomla\CMS\Helper\ModuleHelper::getModule()	JROOT/plugins/jshoppingproducts/ultra_filters/ultra_filters.php:23
14	plgJshoppingproductsUltra_filters->onBeforeQueryGetProductList()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_jshopping/tables/product.php:853
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:533
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:103
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 2.02 ms Після останнього запиту: 0.33 ms Запит пам'яті: 0.035 MB пам'ять до запиту: 4.216 MB Повернуто рядків: 0

SELECT prod.product_id, pr_cat.category_id, prod.`name_uk-UA` as name, prod.`short_description_uk-UA` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_2` , prod.`extra_field_3` , prod.`extra_field_5` , prod.`extra_field_6` , prod.`extra_field_10` , prod.`extra_field_8` , prod.`extra_field_9` , prod.`extra_field_13`  
  FROM `j32_jshopping_products_relations` AS relation
                
  INNER JOIN `j32_jshopping_products` AS prod 
  ON relation.product_related_id = prod.product_id
                
  LEFT JOIN `j32_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = relation.product_related_id
                
  LEFT JOIN `j32_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
                
  WHERE relation.product_id=176 
  AND cat.category_publish=1 
  AND prod.product_publish=1  
  AND prod.access IN (1,1,7) 
  AND cat.access IN (1,1,7)
				
  group by prod.product_id 
  order by relation.id

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	relation	ref	product_id,product_id_2,product_related_id	product_id	4	const	1	Using where; Using temporary; Використовуючи filesort
1	SIMPLE	prod	eq_ref	PRIMARY,product_publish,access	PRIMARY	4	vesi.relation.product_related_id	1	Using where
1	SIMPLE	pr_cat	ref	PRIMARY,category_id,product_id,product_id_2	PRIMARY	4	vesi.relation.product_related_id	1	Using index
1	SIMPLE	cat	eq_ref	PRIMARY,category_publish,access,category_publish_2	PRIMARY	4	vesi.pr_cat.category_id	1	Using where

Профіль

Status	Duration
Starting	0.17 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.08 ms
Optimizing	0.04 ms
Statistics	0.15 ms
Preparing	0.05 ms
Creating tmp table	0.06 ms
Sorting for group	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.74 ms
Creating sort index	0.05 ms
Removing tmp table	0.14 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:863
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:533
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:103
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.44 ms Після останнього запиту: 0.26 ms Запит пам'яті: 0.030 MB пам'ять до запиту: 4.289 MB Повернуто рядків: 3

SHOW FULL COLUMNS 
  FROM `j32_jshopping_taxes`

Роз'яснення

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

Профіль

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.49 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.07 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.04 ms
Closing tables	0.01 ms
Removing tmp table	0.15 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/tax.php:14
16	jshopTax->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
14	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:369
13	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:663
12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:867
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:533
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:103
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT tax_id, tax_name, tax_value 
  FROM `j32_jshopping_taxes`

Роз'яснення

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

Профіль

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/tax.php:21
15	jshopTax->getAllTaxes()	JROOT/components/com_jshopping/lib/factory.php:355
14	JSFactory::getAllTaxesOriginal()	JROOT/components/com_jshopping/lib/factory.php:370
13	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:663
12	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:867
11	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:533
10	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/models/productshop.php:103
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.55 ms Після останнього запиту: 0.35 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 4.315 MB Повернуто рядків: 10

SHOW FULL COLUMNS 
  FROM `j32_jshopping_products_reviews`

Роз'яснення

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

Профіль

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	0.53 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.11 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.07 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.16 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/review.php:14
12	jshopReview->__construct()	JROOT/libraries/src/Table/Table.php:328
11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
10	JSFactory::getTable()	JROOT/components/com_jshopping/models/productshop.php:116
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.66 ms Після останнього запиту: 0.51 ms Запит пам'яті: 0.025 MB пам'ять до запиту: 4.349 MB Повернуто рядків: 2

select manufacturer_id as id, `name_uk-UA` as name, manufacturer_logo, manufacturer_url 
  from j32_jshopping_manufacturers 
  where manufacturer_publish='1'

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j32_jshopping_manufacturers	ref	manufacturer_publish	manufacturer_publish	1	const	1

Профіль

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:422
11	JSFactory::getAllManufacturer()	JROOT/components/com_jshopping/tables/product.php:439
10	jshopProduct->getManufacturerInfo()	JROOT/components/com_jshopping/models/productshop.php:132
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.47 ms Після останнього запиту: 0.22 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 4.362 MB Повернуто рядків: 6

SHOW FULL COLUMNS 
  FROM `j32_jshopping_products_extra_field_values`

Роз'яснення

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

Профіль

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.52 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.09 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.22 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/productfieldvalue.php:15
14	jshopProductFieldValue->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:621
12	JSFactory::getTable()	JROOT/components/com_jshopping/lib/factory.php:505
11	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/tables/product.php:772
10	jshopProduct->getExtraFields()	JROOT/components/com_jshopping/models/productshop.php:154
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.15 ms Після останнього запиту: 0.13 ms Запит пам'яті: 0.042 MB пам'ять до запиту: 4.382 MB Повернуто рядків: 172

SELECT id, `name_uk-UA` as name, field_id 
  FROM `j32_jshopping_products_extra_field_values` 
  order by ordering

Роз'яснення

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

Профіль

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.31 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfieldvalue.php:26
12	jshopProductFieldValue->getAllList()	JROOT/components/com_jshopping/lib/factory.php:506
11	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/tables/product.php:772
10	jshopProduct->getExtraFields()	JROOT/components/com_jshopping/models/productshop.php:154
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 2.27 ms Після останнього запиту: 3.72 ms Запит пам'яті: 0.037 MB пам'ять до запиту: 4.473 MB Повернуто рядків: 0

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

  FROM j32_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND a.access IN (1,1,7) 
  AND (a.group_id = 0 OR g.access IN (1,1,7)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Використовуючи filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	vesi.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	vesi.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	vesi.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	vesi.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	vesi.a.group_id	1	Using where

Профіль

Status	Duration
Starting	0.20 ms
Checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.08 ms
Optimizing	0.06 ms
Statistics	0.15 ms
Preparing	0.06 ms
Creating tmp table	0.07 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.86 ms
Creating sort index	0.07 ms
Removing tmp table	0.14 ms
Creating sort index	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.11 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_jshopping/lib/functions.php:935
10	changeDataUsePluginContent()	JROOT/components/com_jshopping/models/productshop.php:201
9	jshopProductShop->prepareView()	JROOT/components/com_jshopping/controllers/product.php:55
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.06 ms Після останнього запиту: 0.78 ms Запит пам'яті: 0.025 MB пам'ять до запиту: 4.558 MB Повернуто рядків: 13

select id,link 
  from j32_menu 
			          
  where `type`='component' 
  and published=1 
  and link like '%option=com_jshopping%' 
  and client_id=0 
					  
  and (language='*' or language='uk-UA') 
  and access IN (1,1,7)

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j32_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	72	Using index condition; Using where

Профіль

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.42 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:141
13	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:47
12	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:40
11	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:402
10	getShopMainPageItemid()	JROOT/components/com_jshopping/helpers/metadata.php:200
9	JshopHelpersMetadata::product()	JROOT/components/com_jshopping/controllers/product.php:66
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.61 ms Після останнього запиту: 0.62 ms Запит пам'яті: 0.005 MB пам'ять до запиту: 4.586 MB

UPDATE j32_jshopping_products

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

  WHERE `product_id` = '176'

Роз'яснення

EXPLAIN не можливий для запиту: UPDATE j32_jshopping_products SET `hits` = (`hits` + 1) WHERE `product_id` = '176'

Профіль

Status	Duration
Starting	0.05 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.02 ms
Init for update	0.05 ms
Updating	0.15 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.01 ms
Unlocking tables	0.03 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
9	Joomla\CMS\Table\Table->hit()	JROOT/components/com_jshopping/controllers/product.php:68
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.80 ms Після останнього запиту: 0.07 ms Запит пам'яті: 0.024 MB пам'ять до запиту: 4.589 MB Повернуто рядків: 2

SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `j32_jshopping_products_images` as I
				 
  left join `j32_jshopping_products` as P 
  on P.product_id=I.product_id
                 
  WHERE I.product_id=176 
  ORDER BY sort, I.ordering

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	I	ref	product_id	product_id	4	const	4	Using temporary; Використовуючи filesort
1	SIMPLE	P	const	PRIMARY	PRIMARY	4	const	1

Профіль

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.10 ms
Creating sort index	0.03 ms
Removing tmp table	0.02 ms
Creating sort index	0.02 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.02 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:371
9	jshopProduct->getImages()	JROOT/components/com_jshopping/controllers/product.php:78
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT count(review_id) 
  FROM `j32_jshopping_products_reviews` 
  WHERE product_id=176 
  and publish=1

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j32_jshopping_products_reviews	ref	product_id,publish	product_id	4	const	1	Using where

Профіль

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/product.php:1104
10	jshopProduct->getReviewsCount()	JROOT/components/com_jshopping/models/productreviewlist.php:86
9	jshopProductReviewList->load()	JROOT/components/com_jshopping/controllers/product.php:110
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.64 ms Після останнього запиту: 0.32 ms Запит пам'яті: 0.026 MB пам'ять до запиту: 4.625 MB Повернуто рядків: 0

SELECT * 
  FROM `j32_jshopping_products_reviews` 
  WHERE product_id=176 
  and publish=1 
  order by review_id desc 
  LIMIT 0, 20

Роз'яснення

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j32_jshopping_products_reviews	ref	product_id,publish	product_id	4	const	1	Using where; Використовуючи filesort

Профіль

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.02 ms
Init	0.08 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

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

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:1095
10	jshopProduct->getReviews()	JROOT/components/com_jshopping/models/productreviewlist.php:88
9	jshopProductReviewList->load()	JROOT/components/com_jshopping/controllers/product.php:110
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.60 ms Після останнього запиту: 0.29 ms Запит пам'яті: 0.028 MB пам'ять до запиту: 4.634 MB Повернуто рядків: 16

select category_id as id, `alias_uk-UA` as alias 
  from j32_jshopping_categories 
  where `alias_uk-UA`!=''

Роз'яснення

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

Профіль

Status	Duration
Starting	0.05 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.02 ms
Init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.16 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:255
19	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:82
18	jshoppingBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
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:155
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/libraries/src/Pagination/Pagination.php:787
10	Joomla\CMS\Pagination\Pagination->_buildDataObject()	JROOT/libraries/src/Pagination/Pagination.php:328
9	Joomla\CMS\Pagination\Pagination->getPagesLinks()	JROOT/components/com_jshopping/controllers/product.php:113
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:25
6	require_once JROOT/components/com_jshopping/jshopping.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.94 ms Після останнього запиту: 7.96 ms Запит пам'яті: 0.022 MB пам'ять до запиту: 4.929 MB Повернуто рядків: 2

SELECT language,id

  FROM `j32_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	j32_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	72	Using where

Профіль

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.26 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.60 ms Після останнього запиту: 0.59 ms Запит пам'яті: 0.023 MB пам'ять до запиту: 4.943 MB Повернуто рядків: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `j32_menu` AS `c`

  INNER JOIN `j32_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `j32_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `j32_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 339

Роз'яснення

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.08 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.02 ms
Executing	0.04 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
10	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
9	MenusHelper::getAssociations()	JROOT/components/com_jshopping/helpers/association.php:30
8	JshoppingHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
7	PlgSystemLanguageFilter->onAfterDispatch()	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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.15 ms Після останнього запиту: 26.94 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 5.371 MB Повернуто рядків: 157

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

SHOW TABLES

Роз'яснення

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

Профіль

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

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

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
8	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:116
7	plgSystemjdownloads->onAfterRender()	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/CMSApplication.php:1146
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `alias`

  FROM `j32_content`

  WHERE id = '23'

Роз'яснення

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

Профіль

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	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/CMSApplication.php:1146
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.90 ms Після останнього запиту: 0.38 ms Запит пам'яті: 0.038 MB пам'ять до запиту: 5.505 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 `j32_categories` AS `s`

  INNER JOIN `j32_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,7) 
  AND c.published = 1 
  AND s.id = 2

  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	11	Using where; Використовуючи filesort

Профіль

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

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

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	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/CMSApplication.php:1146
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT alias

  FROM j32_content

  WHERE id=23

Роз'яснення

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

Профіль

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	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/CMSApplication.php:1146
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `alias`

  FROM `j32_content`

  WHERE id = '6'

Роз'яснення

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

Профіль

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

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

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	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/CMSApplication.php:1146
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `alias`

  FROM `j32_content`

  WHERE id = '22'

Роз'яснення

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

Профіль

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

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

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	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/CMSApplication.php:1146
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT alias

  FROM j32_content

  WHERE id=22

Роз'яснення

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

Профіль

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

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

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	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/CMSApplication.php:1146
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

3 &#215; SELECT `alias` 
  FROM `j32_content`

2 &#215; SELECT alias 
  FROM j32_content

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

1 &#215; select id,link 
  from j32_menu

1 &#215; SELECT prod.product_id, pr_cat.category_id, prod.`name_uk-UA` as name, prod.`short_description_uk-UA` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.`extra_field_2` , prod.`extra_field_3` , prod.`extra_field_5` , prod.`extra_field_6` , prod.`extra_field_10` , prod.`extra_field_8` , prod.`extra_field_9` , prod.`extra_field_13`  
  FROM `j32_jshopping_products_relations` AS relation
                 
  INNER JOIN `j32_jshopping_products` AS prod 
  ON relation.product_related_id = prod.product_id
                 
  LEFT JOIN `j32_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = relation.product_related_id
                 
  LEFT JOIN `j32_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id

1 &#215; SELECT tax_id, tax_name, tax_value 
  FROM `j32_jshopping_taxes

1 &#215; select manufacturer_id as id, `name_uk-UA` as name, manufacturer_logo, manufacturer_url 
  from j32_jshopping_manufacturers

1 &#215; SELECT id, `name_uk-UA` as name, field_id 
  FROM `j32_jshopping_products_extra_field_values`

1 &#215; SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM j32_fields AS a 
  LEFT JOIN `j32_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN j32_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN j32_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN j32_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN j32_fields_groups AS g 
  ON g.id = a.group_id

1 &#215; SELECT count(review_id) 
  FROM `j32_jshopping_products_reviews`

1 &#215; SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `j32_jshopping_products_images` as I
      
  left join `j32_jshopping_products` as P 
  on P.product_id=I.product_id

1 &#215; SELECT F.id, F.`name_uk-UA` as name, F.`description_uk-UA` as description, F.allcats, F.type, F.cats, F.ordering, F.`
  group`, G.`name_uk-UA` as groupname, multilist 
  FROM `j32_jshopping_products_extra_fields` as F 
  left join `j32_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group

1 &#215; SELECT * 
  FROM `j32_jshopping_products_reviews`

1 &#215; select category_id as id, `alias_uk-UA` as alias 
  from j32_jshopping_categories

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

1 &#215; SELECT `c2`.`language`,`c2`.`id` 
  FROM `j32_menu` AS `c` 
  INNER JOIN `j32_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `j32_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `j32_menu` AS `c2` 
  ON a2.id = c2.`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 `j32_categories` AS `s` 
  INNER JOIN `j32_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 m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM j32_modules AS m 
  LEFT JOIN j32_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN j32_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

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

1 &#215; SELECT * 
  FROM `j32_jshopping_products_attr2`

1 &#215; SELECT * 
  FROM j32_jshopping_config

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

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

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

1 &#215; SELECT * 
  FROM j32_languages

1 &#215; SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `j32_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 j32_menu AS m 
  LEFT JOIN j32_extensions AS e 
  ON m.component_id = e.extension_id

1 &#215; SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `j32_jshopping_currencies`

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

1 &#215; select product_id as id, `alias_uk-UA` as alias 
  from j32_jshopping_products

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

1 &#215; select * 
  from j32_jshopping_language

1 &#215; SELECT * 
  FROM j32_jshopping_products

1 &#215; SELECT * 
  FROM j32_jshopping_categories

1 &#215; SELECT * 
  FROM `j32_jshopping_products_to_categories`

1 &#215; SELECT A.attr_id, A.`name_uk-UA` as name, A.`description_uk-UA` as description, A.attr_type, A.independent, A.allcats, A.cats, A.attr_ordering, G.`name_uk-UA` as groupname
                   
  FROM `j32_jshopping_attr` as A 
  left join `j32_jshopping_attr_groups` as G 
  on A.`
  group`=G.id

1 &#215; SELECT * 
  FROM `j32_jshopping_products_attr`

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

```
2 &#215; SHOW TABLE
```

1 &#215; INSERT INTO `j32_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6539356634393336646639643539366435623438356562373139306663623238', 1, 1732182957, 0, '', 0

1 &#215; SHOW FULL COLUMNS 
  FROM `j32_jshopping_config

1 &#215; SHOW FULL COLUMNS 
  FROM `j32_jshopping_currencies

1 &#215; UPDATE `j32_extensions` 
  SET `params` = '{\"mediaversion\":\"5c8fead640acad61e4a837a732245b06\"}'

1 &#215; SHOW FULL COLUMNS 
  FROM `j32_jshopping_products

1 &#215; SHOW FULL COLUMNS 
  FROM `j32_jshopping_categories

1 &#215; SHOW FULL COLUMNS 
  FROM `j32_jshopping_attr

1 &#215; SHOW FULL COLUMNS 
  FROM `j32_jshopping_users

1 &#215; SHOW FULL COLUMNS 
  FROM `j32_jshopping_products_extra_fields

1 &#215; SHOW FULL COLUMNS 
  FROM `j32_jshopping_taxes

1 &#215; SHOW FULL COLUMNS 
  FROM `j32_jshopping_products_reviews

1 &#215; SHOW FULL COLUMNS 
  FROM `j32_jshopping_products_extra_field_values

1 &#215; UPDATE j32_jshopping_products 
  SET `hits` = (`hits` + 1)

Ваги з друком етикетки ВТНЕ-ПРИНТ-60Т1-2

Швидке замовлення

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

Сесія

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

Час

Пам'ять

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

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

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

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

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

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

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