Австрійська цегла (піщаний кантрі) від торгової марки SVAN

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

Сесія

{
    "__default": {
        "session": {
            "counter": 5,
            "timer": {
                "start": 1785929123,
                "last": 1785929124,
                "now": 1785929125
            },
            "client": {
                "forwarded": "216.73.216.236"
            },
            "token": "c4nF93mNaz0y8IzOf28FIeNUJu5Lcmc6"
        },
        "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": "3",
        "js_id_currency": "3",
        "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": "\/products\/color\/mw-007-pk",
        "product_back_value": [],
        "jshop_end_page_list_product": "\/en\/products\/sup-tov\/may-be-need"
    }
}

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

Час

Пам'ять

Час: 11.36 ms / 11.36 ms Пам'ять: 1.801 MB / 2.18 MB Application: afterLoad

Час: 219.91 ms / 231.28 ms Пам'ять: 9.172 MB / 11.35 MB Application: afterInitialise

Час: 13.78 ms / 245.05 ms Пам'ять: 1.837 MB / 13.19 MB Application: afterRoute

Час: 0.90 ms / 245.95 ms Пам'ять: 0.048 MB / 13.23 MB Application: beforeRenderComponent com_jshopping

Час: 39.26 ms / 285.22 ms Пам'ять: 5.481 MB / 18.72 MB Application: afterRenderComponent com_jshopping

Час: 7.16 ms / 292.38 ms Пам'ять: 0.493 MB / 19.21 MB Application: beforeRenderModule mod_addtoany (AddToAny Buttons)

Час: 0.44 ms / 292.82 ms Пам'ять: 0.048 MB / 19.26 MB Application: afterRenderModule mod_addtoany (AddToAny Buttons)

Час: 3.89 ms / 296.70 ms Пам'ять: 0.000 MB / 19.02 MB Application: afterDispatch

Час: 30.66 ms / 327.36 ms Пам'ять: 0.850 MB / 19.87 MB Application: beforeRenderModule mod_custom (Розробка сайту INS (1024+))

Час: 0.31 ms / 327.67 ms Пам'ять: 0.007 MB / 19.88 MB Application: afterRenderModule mod_custom (Розробка сайту INS (1024+))

Час: 0.01 ms / 327.68 ms Пам'ять: 0.000 MB / 19.88 MB Application: beforeRenderModule mod_custom (Розробка сайту INS (800-1023))

Час: 0.07 ms / 327.75 ms Пам'ять: 0.003 MB / 19.88 MB Application: afterRenderModule mod_custom (Розробка сайту INS (800-1023))

Час: 0.01 ms / 327.76 ms Пам'ять: 0.000 MB / 19.88 MB Application: beforeRenderModule mod_custom (Розробка сайту INS (0-799))

Час: 0.06 ms / 327.82 ms Пам'ять: 0.003 MB / 19.88 MB Application: afterRenderModule mod_custom (Розробка сайту INS (0-799))

Час: 0.03 ms / 327.85 ms Пам'ять: 0.000 MB / 19.88 MB Application: beforeRenderModule mod_custom (4 Столбика меню внизу сайта (UA))

Час: 1.01 ms / 328.85 ms Пам'ять: 0.021 MB / 19.91 MB Application: afterRenderModule mod_custom (4 Столбика меню внизу сайта (UA))

Час: 0.03 ms / 328.88 ms Пам'ять: 0.000 MB / 19.90 MB Application: beforeRenderModule mod_custom (4 пункта меню внизу сайта (UA))

Час: 0.08 ms / 328.96 ms Пам'ять: 0.004 MB / 19.91 MB Application: afterRenderModule mod_custom (4 пункта меню внизу сайта (UA))

Час: 0.01 ms / 328.97 ms Пам'ять: 0.000 MB / 19.91 MB Application: beforeRenderModule mod_custom (Слідкуйте за нами (UA))

Час: 0.21 ms / 329.18 ms Пам'ять: 0.003 MB / 19.91 MB Application: afterRenderModule mod_custom (Слідкуйте за нами (UA))

Час: 0.01 ms / 329.19 ms Пам'ять: 0.007 MB / 19.92 MB Application: beforeRenderModule mod_custom (Замовити дзвінок (UA) )

Час: 0.24 ms / 329.43 ms Пам'ять: 0.003 MB / 19.92 MB Application: afterRenderModule mod_custom (Замовити дзвінок (UA) )

Час: 0.03 ms / 329.46 ms Пам'ять: 0.000 MB / 19.92 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs (Вы здесь) (UA))

Час: 0.59 ms / 330.05 ms Пам'ять: 0.025 MB / 19.94 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs (Вы здесь) (UA))

Час: 0.03 ms / 330.09 ms Пам'ять: 0.000 MB / 19.94 MB Application: beforeRenderModule mod_custom (Jshopping Search (pages) (540-979 та 1280+))

Час: 0.10 ms / 330.18 ms Пам'ять: 0.003 MB / 19.94 MB Application: afterRenderModule mod_custom (Jshopping Search (pages) (540-979 та 1280+))

Час: 0.03 ms / 330.21 ms Пам'ять: 0.000 MB / 19.94 MB Application: beforeRenderModule mod_languages (Переключение языков)

Час: 2.53 ms / 332.74 ms Пам'ять: 0.250 MB / 20.19 MB Application: afterRenderModule mod_languages (Переключение языков)

Час: 0.02 ms / 332.75 ms Пам'ять: 0.000 MB / 20.19 MB Application: beforeRenderModule mod_custom (Номер телефону та ел. пошта (UA))

Час: 0.08 ms / 332.83 ms Пам'ять: 0.003 MB / 20.19 MB Application: afterRenderModule mod_custom (Номер телефону та ел. пошта (UA))

Час: 14.41 ms / 347.24 ms Пам'ять: 1.033 MB / 21.22 MB Application: beforeRenderModule mod_jshopping_search (Jshopping Search)

Час: 0.40 ms / 347.64 ms Пам'ять: 0.009 MB / 21.23 MB Application: afterRenderModule mod_jshopping_search (Jshopping Search)

Час: 4.65 ms / 352.30 ms Пам'ять: 0.000 MB / 20.71 MB Application: afterRender

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

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

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

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

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

2 дублікатів: #52 #53

Витрачений час на запит: 0.54 ms Запит пам'яті: 0.025 MB пам'ять до запиту: 4.246 MB Повернуто рядків: 43

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

  FROM `vnj7t_extensions`

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

Роз'яснення

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

Профіль

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

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

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

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

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

SELECT id, rules

  FROM `vnj7t_viewlevels`

Роз'яснення

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

Профіль

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

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

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

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

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

SELECT b.id

  FROM vnj7t_usergroups AS a

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

  WHERE a.id = 1

Роз'яснення

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

Профіль

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

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

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

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

Витрачений час на запит: 0.93 ms Після останнього запиту: 0.33 ms Запит пам'яті: 0.031 MB пам'ять до запиту: 4.521 MB Повернуто рядків: 120

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

  FROM vnj7t_extensions

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

  ORDER BY ordering

Роз'яснення

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

Профіль

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

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

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

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

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

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

  FROM `vnj7t_extensions`

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

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
17	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Такий самий, як і виклик у нижньому рядку.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/ytshortcodes/ytshortcodes.php:36
7	plgSystemYtshortcodes->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

UPDATE `vnj7t_extensions`

  SET `params` = '{\"mediaversion\":\"56f05195d5739a2ba1507685b8101958\"}'

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

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/ytshortcodes/ytshortcodes.php:36
7	plgSystemYtshortcodes->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.27 ms Після останнього запиту: 6.74 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 7.252 MB Повернуто рядків: 2

SELECT *

  FROM vnj7t_languages

  WHERE published=1

  ORDER BY ordering ASC

Роз'яснення

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

Профіль

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

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

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

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

Витрачений час на запит: 0.16 ms Після останнього запиту: 0.05 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 7.260 MB Повернуто рядків: 6

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

  FROM `vnj7t_extensions`

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

Роз'яснення

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

Профіль

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

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

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

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

Витрачений час на запит: 7.76 ms Після останнього запиту: 10.95 ms Запит пам'яті: 0.678 MB пам'ять до запиту: 8.886 MB Повернуто рядків: 645

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

  LEFT JOIN vnj7t_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	7	3.33	Using index condition; Using where; Використовуючи filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	dy445040_sd.m.component_id	1	100.00	Using where

Профіль

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

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

#	Виклик	Номер файлу та рядка
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Такий самий, як і виклик у нижньому рядку.
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:76
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:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
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:64
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:491
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:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.23 ms Після останнього запиту: 11.49 ms Запит пам'яті: 0.046 MB пам'ять до запиту: 12.677 MB Повернуто рядків: 139

SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_config`

Роз'яснення

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

Профіль

Status	Duration
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.20 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

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

#	Виклик	Номер файлу та рядка
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/config.php:15
14	jshopConfig->__construct()	JROOT/components/com_jshopping/lib/factory.php:24
13	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:221
12	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:244
11	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/router.php:202
10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM vnj7t_jshopping_config

  WHERE `id` = '1'

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/lib/factory.php:27
13	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:221
12	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:244
11	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/router.php:202
10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.32 ms Після останнього запиту: 0.21 ms Запит пам'яті: 0.027 MB пам'ять до запиту: 12.913 MB Повернуто рядків: 8

SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_currencies`

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
18	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/currency.php:22
17	jshopCurrency->__construct()	JROOT/libraries/src/Table/Table.php:312
16	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:625
15	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:48
14	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:29
13	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:221
12	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:244
11	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/router.php:202
10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/currency.php:30
16	jshopCurrency->getAllCurrencies()	JROOT/components/com_jshopping/lib/factory.php:626
15	JSFactory::getAllCurrency()	JROOT/components/com_jshopping/tables/config.php:48
14	jshopConfig->loadCurrencyValue()	JROOT/components/com_jshopping/lib/factory.php:29
13	JSFactory::getConfig()	JROOT/components/com_jshopping/lib/factory.php:221
12	JSFactory::reloadConfigFieldTLF()	JROOT/components/com_jshopping/lib/factory.php:244
11	JSFactory::loadLanguageFile()	JROOT/components/com_jshopping/router.php:202
10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.24 ms Після останнього запиту: 0.81 ms Запит пам'яті: 0.022 MB пам'ять до запиту: 13.014 MB Повернуто рядків: 20

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

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:317
11	JSFactory::getAliasCategory()	JROOT/components/com_jshopping/router.php:276
10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.51 ms Після останнього запиту: 0.02 ms Запит пам'яті: 0.026 MB пам'ять до запиту: 13.022 MB Повернуто рядків: 96

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

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:351
11	JSFactory::getAliasProduct()	JROOT/components/com_jshopping/router.php:287
10	jshoppingParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.34 ms Після останнього запиту: 0.96 ms Запит пам'яті: 0.019 MB пам'ять до запиту: 13.196 MB Повернуто рядків: 5

SELECT id, home, template, s.params

  FROM vnj7t_template_styles as s

  LEFT JOIN vnj7t_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	6	16.67	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	dy445040_sd.s.template,const	1	5.00	Using index condition; Using where

Профіль

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

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

#	Виклик	Номер файлу та рядка
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.78 ms Після останнього запиту: 8.50 ms Запит пам'яті: 0.041 MB пам'ять до запиту: 14.811 MB Повернуто рядків: 104

SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_products`

Роз'яснення

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

Профіль

Status	Duration
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Sending data	0.12 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.02 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

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

#	Виклик	Номер файлу та рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/product.php:14
10	jshopProduct->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/controllers/product.php:40
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM vnj7t_jshopping_products

  WHERE `product_id` = '7'

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/controllers/product.php:41
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.21 ms Після останнього запиту: 0.04 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 14.956 MB Повернуто рядків: 2

SELECT * 
  FROM `vnj7t_jshopping_products_to_categories` 
  WHERE product_id='7'

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:236
9	jshopProduct->getCategories()	JROOT/components/com_jshopping/controllers/product.php:42
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.36 ms Після останнього запиту: 0.13 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 14.974 MB Повернуто рядків: 26

SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_attr`

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
14	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/attribut.php:16
13	jshopAttribut->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:365
11	JSFactory::getAllAttributes()	JROOT/components/com_jshopping/tables/product.php:96
10	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:173
9	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/controllers/product.php:48
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.11 ms Після останнього запиту: 0.03 ms Запит пам'яті: 0.023 MB пам'ять до запиту: 15.009 MB Повернуто рядків: 2

SELECT attr_id, `name_uk-UA` as name, `description_uk-UA` as description, attr_type, independent, allcats, cats, attr_ordering 
  FROM `vnj7t_jshopping_attr` 
  ORDER BY attr_ordering

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/attribut.php:32
12	jshopAttribut->getAllAttributes()	JROOT/components/com_jshopping/lib/factory.php:366
11	JSFactory::getAllAttributes()	JROOT/components/com_jshopping/tables/product.php:96
10	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:173
9	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/controllers/product.php:48
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM `vnj7t_jshopping_products_attr2` 
  WHERE product_id = '7' 
  ORDER BY id

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	NULL	NULL	no matching row in const table

Профіль

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

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

#	Виклик	Номер файлу та рядка
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:137
11	jshopProduct->getAttributes2()	JROOT/components/com_jshopping/tables/product.php:112
10	jshopProduct->getRequireAttribute()	JROOT/components/com_jshopping/tables/product.php:173
9	jshopProduct->getAttributesDatas()	JROOT/components/com_jshopping/controllers/product.php:48
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.45 ms Після останнього запиту: 0.50 ms Запит пам'яті: 0.032 MB пам'ять до запиту: 15.096 MB Повернуто рядків: 52

SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_users`

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/usershop.php:14
11	jshopUserShop->__construct()	JROOT/components/com_jshopping/lib/factory.php:126
10	JSFactory::getUserShop()	JROOT/components/com_jshopping/tables/product.php:1029
9	jshopProduct->getBuildSelectAttributes()	JROOT/components/com_jshopping/controllers/product.php:52
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.37 ms Після останнього запиту: 0.19 ms Запит пам'яті: 0.029 MB пам'ять до запиту: 15.233 MB Повернуто рядків: 27

SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_products_extra_fields`

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/productfield.php:16
15	jshopProductField->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:552
13	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1061
12	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:198
11	JTableAvto->getBuildQueryListProductSimpleList()	JROOT/components/com_jshopping/tables/product.php:759
10	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:479
9	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/controllers/product.php:61
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.19 ms Після останнього запиту: 0.03 ms Запит пам'яті: 0.023 MB пам'ять до запиту: 15.271 MB Повернуто рядків: 2

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 `vnj7t_jshopping_products_extra_fields` as F 
  left join `vnj7t_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group 
  order by G.ordering, F.ordering

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfield.php:50
14	jshopProductField->getList()	JROOT/components/com_jshopping/lib/factory.php:553
13	JSFactory::getAllProductExtraField()	JROOT/components/com_jshopping/lib/functions.php:1061
12	getQueryListProductsExtraFields()	JROOT/components/com_jshopping/lib/jtableauto.php:198
11	JTableAvto->getBuildQueryListProductSimpleList()	JROOT/components/com_jshopping/tables/product.php:759
10	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:479
9	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/controllers/product.php:61
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.96 ms Після останнього запиту: 0.04 ms Запит пам'яті: 0.039 MB пам'ять до запиту: 15.279 MB Повернуто рядків: 5

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.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`  
  FROM `vnj7t_jshopping_products_relations` AS relation
                
  INNER JOIN `vnj7t_jshopping_products` AS prod 
  ON relation.product_related_id = prod.product_id
                
  LEFT JOIN `vnj7t_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = relation.product_related_id
                
  LEFT JOIN `vnj7t_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id
                
                
  WHERE relation.product_id = '7' 
  AND cat.category_publish='1' 
  AND prod.product_publish = '1'  
  AND prod.access IN (1,1) 
  AND cat.access IN (1,1) 
  group by prod.product_id 
  order by relation.id

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat	NULL	ALL	PRIMARY	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	20	5.00	Using where; Using temporary; Використовуючи filesort
1	SIMPLE	relation	NULL	ALL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	480	10.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	prod	NULL	eq_ref	PRIMARY	PRIMARY	4	dy445040_sd.relation.product_related_id	1	5.00	Using where
1	SIMPLE	pr_cat	NULL	eq_ref	PRIMARY,category_id,product_id	PRIMARY	8	dy445040_sd.relation.product_related_id,dy445040_sd.cat.category_id	1	100.00	Using index

Профіль

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

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

#	Виклик	Номер файлу та рядка
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:773
10	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:479
9	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/controllers/product.php:61
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 1.59 ms Після останнього запиту: 0.05 ms Запит пам'яті: 0.052 MB пам'ять до запиту: 15.314 MB Повернуто рядків: 203

select id,link 
  from vnj7t_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)

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:125
16	shopItemMenu->getList()	JROOT/components/com_jshopping/lib/shop_item_menu.php:41
15	shopItemMenu->init()	JROOT/components/com_jshopping/lib/shop_item_menu.php:35
14	shopItemMenu::getInstance()	JROOT/components/com_jshopping/lib/functions.php:395
13	getShopMainPageItemid()	JROOT/components/com_jshopping/lib/functions.php:414
12	getDefaultItemid()	JROOT/components/com_jshopping/lib/functions.php:472
11	SEFLink()	JROOT/components/com_jshopping/tables/product.php:775
10	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:479
9	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/controllers/product.php:61
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.29 ms Після останнього запиту: 1.03 ms Запит пам'яті: 0.025 MB пам'ять до запиту: 15.613 MB Повернуто рядків: 3

SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_taxes`

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/tax.php:17
14	jshopTax->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:418
12	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:628
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:777
10	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:479
9	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/controllers/product.php:61
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT tax_id, tax_name, tax_value 
  FROM `vnj7t_jshopping_taxes`

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/tax.php:24
14	jshopTax->getAllTaxes()	JROOT/components/com_jshopping/lib/factory.php:403
13	JSFactory::getAllTaxesOriginal()	JROOT/components/com_jshopping/lib/factory.php:419
12	JSFactory::getAllTaxes()	JROOT/components/com_jshopping/lib/functions.php:628
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:777
10	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:479
9	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/controllers/product.php:61
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.15 ms Після останнього запиту: 0.02 ms Запит пам'яті: 0.022 MB пам'ять до запиту: 15.632 MB Повернуто рядків: 0

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

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Профіль

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

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

#	Виклик	Номер файлу та рядка
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/lib/factory.php:478
12	JSFactory::getAllManufacturer()	JROOT/components/com_jshopping/lib/functions.php:630
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:777
10	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:479
9	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/controllers/product.php:61
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.26 ms Після останнього запиту: 0.39 ms Запит пам'яті: 0.027 MB пам'ять до запиту: 15.647 MB Повернуто рядків: 13

SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_products_extra_field_values`

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/productfieldvalue.php:16
15	jshopProductFieldValue->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/factory.php:561
13	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/lib/functions.php:770
12	getProductExtraFieldForProduct()	JROOT/components/com_jshopping/lib/functions.php:695
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:777
10	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:479
9	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/controllers/product.php:61
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	NULL	NULL	no matching row in const table

Профіль

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

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

#	Виклик	Номер файлу та рядка
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productfieldvalue.php:27
14	jshopProductFieldValue->getAllList()	JROOT/components/com_jshopping/lib/factory.php:562
13	JSFactory::getAllProductExtraFieldValue()	JROOT/components/com_jshopping/lib/functions.php:770
12	getProductExtraFieldForProduct()	JROOT/components/com_jshopping/lib/functions.php:695
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:777
10	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:479
9	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/controllers/product.php:61
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.26 ms Після останнього запиту: 0.12 ms Запит пам'яті: 0.028 MB пам'ять до запиту: 15.693 MB Повернуто рядків: 13

SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_product_labels`

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/productlabel.php:14
14	jshopProductLabel->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/lib/functions.php:602
12	getNameImageLabel()	JROOT/components/com_jshopping/lib/functions.php:734
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:777
10	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:479
9	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/controllers/product.php:61
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.11 ms Після останнього запиту: 0.02 ms Запит пам'яті: 0.023 MB пам'ять до запиту: 15.716 MB Повернуто рядків: 3

SELECT id, image, `name_uk-UA` as name 
  FROM `vnj7t_jshopping_product_labels` 
  ORDER BY name

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/productlabel.php:22
13	jshopProductLabel->getListLabels()	JROOT/components/com_jshopping/lib/functions.php:603
12	getNameImageLabel()	JROOT/components/com_jshopping/lib/functions.php:734
11	listProductUpdateData()	JROOT/components/com_jshopping/tables/product.php:777
10	jshopProduct->getRelatedProducts()	JROOT/components/com_jshopping/tables/product.php:479
9	jshopProduct->getExtendsData()	JROOT/components/com_jshopping/controllers/product.php:61
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_categories`

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/category.php:15
10	jshopCategory->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/controllers/product.php:63
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM vnj7t_jshopping_categories

  WHERE `category_id` = '10'

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/controllers/product.php:64
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM vnj7t_jshopping_categories

  WHERE `category_id` = '1'

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_jshopping/tables/category.php:79
9	jshopCategory->getTreeChild()	JROOT/components/com_jshopping/controllers/product.php:74
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

UPDATE vnj7t_jshopping_products

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

  WHERE `product_id` = '7'

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	vnj7t_jshopping_products	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Профіль

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

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

#	Виклик	Номер файлу та рядка
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
9	Joomla\CMS\Table\Table->hit()	JROOT/components/com_jshopping/controllers/product.php:80
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.32 ms Після останнього запиту: 0.57 ms Запит пам'яті: 0.024 MB пам'ять до запиту: 15.983 MB Повернуто рядків: 10

SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_products_reviews`

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_jshopping/tables/review.php:14
10	jshopReview->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jshopping/controllers/product.php:96
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.25 ms Після останнього запиту: 0.55 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 16.082 MB Повернуто рядків: 0

SELECT FA.id, FA.required, FA.`name_uk-UA` as name, FA.`description_uk-UA` as description, FA.type 
  FROM `vnj7t_jshopping_products_free_attr` as PFA 
  left join `vnj7t_jshopping_free_attr` as FA 
  on FA.id=PFA.attr_id
                  
  WHERE PFA.product_id = '7' 
  order by FA.ordering

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Профіль

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

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

#	Виклик	Номер файлу та рядка
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:212
9	jshopProduct->getListFreeAttributes()	JROOT/components/com_jshopping/controllers/product.php:142
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.55 ms Після останнього запиту: 10.69 ms Запит пам'яті: 0.025 MB пам'ять до запиту: 18.059 MB Повернуто рядків: 0

SELECT 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 vnj7t_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	NULL	NULL	no matching row in const table

Профіль

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

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

#	Виклик	Номер файлу та рядка
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
15	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
13	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
12	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/components/com_jshopping/lib/functions.php:897
9	changeDataUsePluginContent()	JROOT/components/com_jshopping/controllers/product.php:200
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.48 ms Після останнього запиту: 2.64 ms Запит пам'яті: 0.022 MB пам'ять до запиту: 18.491 MB Повернуто рядків: 6

SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `vnj7t_jshopping_products_images` as I 
  left join `vnj7t_jshopping_products` as P 
  on P.product_id=I.product_id
                 
  WHERE I.product_id = '7' 
  ORDER BY sort, I.ordering

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	I	NULL	ALL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	277	10.00	Using where; Using temporary; Використовуючи filesort
1	SIMPLE	P	NULL	eq_ref	PRIMARY	PRIMARY	4	dy445040_sd.I.product_id	1	100.00	NULL

Профіль

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

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

#	Виклик	Номер файлу та рядка
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:322
9	jshopProduct->getImages()	JROOT/components/com_jshopping/controllers/product.php:216
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.17 ms Після останнього запиту: 0.04 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 18.502 MB Повернуто рядків: 0

SELECT  video_name, video_id, video_preview, video_code 
  FROM `vnj7t_jshopping_products_videos` 
  WHERE product_id = '7'

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	NULL	NULL	no matching row in const table

Профіль

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

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

#	Виклик	Номер файлу та рядка
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:341
9	jshopProduct->getVideos()	JROOT/components/com_jshopping/controllers/product.php:217
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.15 ms Після останнього запиту: 0.02 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 18.508 MB Повернуто рядків: 0

SELECT * 
  FROM `vnj7t_jshopping_products_files` 
  WHERE product_id = '7' 
  and demo!='' 
  order by `ordering`

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	NULL	NULL	no matching row in const table

Профіль

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

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

#	Виклик	Номер файлу та рядка
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:367
9	jshopProduct->getDemoFiles()	JROOT/components/com_jshopping/controllers/product.php:218
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT count(review_id) 
  FROM `vnj7t_jshopping_products_reviews` 
  WHERE product_id = '7' 
  and publish='1'

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/components/com_jshopping/tables/product.php:999
9	jshopProduct->getReviewsCount()	JROOT/components/com_jshopping/controllers/product.php:246
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.13 ms Після останнього запиту: 0.01 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 18.523 MB Повернуто рядків: 0

SELECT * 
  FROM `vnj7t_jshopping_products_reviews` 
  WHERE product_id = '7' 
  and publish='1' 
  order by review_id desc 
  LIMIT 0, 20

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/components/com_jshopping/tables/product.php:993
9	jshopProduct->getReviews()	JROOT/components/com_jshopping/controllers/product.php:247
8	JshoppingControllerProduct->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jshopping/jshopping.php:27
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT m.*

  FROM vnj7t_modules AS m

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

  WHERE m.client_id = 0 
  AND m.title = 'AddToAny Buttons' 
  AND m.access IN (1,1) 
  AND m.published = 1 
  AND e.enabled = 1

  ORDER BY m.ordering

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ALL	element_clientid,element_folder_clientid	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	278	1.00	Using where; Using temporary; Використовуючи filesort
1	SIMPLE	m	NULL	ref	published,newsfeeds	newsfeeds	204	dy445040_sd.e.element,const	6	0.83	Using index condition; Using where

Профіль

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

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

#	Виклик	Номер файлу та рядка
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/modulesanywhere/src/Replace.php:290
15	RegularLabs\Plugin\System\ModulesAnywhere\Replace::getModuleFromDatabase()	JROOT/plugins/system/modulesanywhere/src/Replace.php:492
14	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:444
13	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:628
12	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:610
11	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:67
10	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/src/Replace.php:122
9	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceTags()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:84
8	PlgSystemModulesAnywhere->changeDocumentBuffer()	JROOT/libraries/regularlabs/src/SystemPlugin.php:109
7	RegularLabs\Library\SystemPlugin->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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 2.56 ms Після останнього запиту: 2.12 ms Запит пам'яті: 0.021 MB пам'ять до запиту: 19.063 MB Повернуто рядків: 3

SELECT language,id

  FROM `vnj7t_menu`

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

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	vnj7t_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	586	1.00	Using where

Профіль

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

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

#	Виклик	Номер файлу та рядка
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT template_style_id 
  FROM vnj7t_menu 
  WHERE id = 1176

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:129
10	YtFrameworkTemplate->isOverrideTemplate()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30
9	YtFrameworkTemplate->__construct()	JROOT/templates/sj_megashop/includes/frame_inc.php:29
8	include_once JROOT/templates/sj_megashop/includes/frame_inc.php	JROOT/templates/sj_megashop/index.php:29
7	require JROOT/templates/sj_megashop/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:133
10	YtFrameworkTemplate->isOverrideTemplate()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30
9	YtFrameworkTemplate->__construct()	JROOT/templates/sj_megashop/includes/frame_inc.php:29
8	include_once JROOT/templates/sj_megashop/includes/frame_inc.php	JROOT/templates/sj_megashop/index.php:29
7	require JROOT/templates/sj_megashop/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 2.55 ms Після останнього запиту: 0.40 ms Запит пам'яті: 0.061 MB пам'ять до запиту: 19.142 MB Повернуто рядків: 28

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

  FROM vnj7t_modules AS m

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

  LEFT JOIN vnj7t_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 <= '2026-08-05 11:25:25') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-08-05 11:25:25') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 1176 OR mm.menuid <= 0) 
  AND m.language IN ('uk-UA','*')

  ORDER BY m.position, m.ordering

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ALL	element_clientid,element_folder_clientid	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	278	1.00	Using where; Using temporary; Використовуючи filesort
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds,idx_language	newsfeeds	204	dy445040_sd.e.element,const	6	0.83	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	dy445040_sd.m.id	2	40.00	Using where; Using index

Профіль

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

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

#	Виклик	Номер файлу та рядка
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	Такий самий, як і виклик у нижньому рядку.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:188
11	YtFrameworkRenderXML->getBlocks()	JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:115
10	YtFrameworkRenderXML->getTagBody()	JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:49
9	YtFrameworkRenderXML->__construct()	JROOT/templates/sj_megashop/includes/frame_inc.php:96
8	include_once JROOT/templates/sj_megashop/includes/frame_inc.php	JROOT/templates/sj_megashop/index.php:29
7	require JROOT/templates/sj_megashop/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Дублі запитів: #53

SELECT home 
  FROM vnj7t_menu 
  WHERE id=1176

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:117
8	YtFrameworkTemplate->isHomePage()	JROOT/templates/sj_megashop/index.php:79
7	require JROOT/templates/sj_megashop/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Дублі запитів: #52

SELECT home 
  FROM vnj7t_menu 
  WHERE id=1176

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/yt/includes/site/lib/yt_template.php:118
8	YtFrameworkTemplate->isHomePage()	JROOT/templates/sj_megashop/index.php:79
7	require JROOT/templates/sj_megashop/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT 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 vnj7t_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	NULL	NULL	no matching row in const table

Профіль

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

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

#	Виклик	Номер файлу та рядка
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Такий самий, як і виклик у нижньому рядку.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Витрачений час на запит: 0.41 ms Після останнього запиту: 2.76 ms Запит пам'яті: 0.023 MB пам'ять до запиту: 20.059 MB Повернуто рядків: 2

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

  FROM `vnj7t_menu` AS `c`

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

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

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

  WHERE c.id = 1176

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	a	NULL	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00	NULL
1	SIMPLE	a2	NULL	ref	idx_key	idx_key	128	const	2	100.00	NULL
1	SIMPLE	c2	NULL	eq_ref	PRIMARY	PRIMARY	4	dy445040_sd.a2.id	1	100.00	NULL

Профіль

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

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

#	Виклик	Номер файлу та рядка
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
13	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT template

  FROM vnj7t_template_styles

  WHERE home = 1 
  AND client_id = 0

Роз'яснення

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

Профіль

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

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

#	Виклик	Номер файлу та рядка
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/yt/yt.php:264
8	plgSystemYt->nameOfSJTemplate()	JROOT/plugins/system/yt/yt.php:189
7	plgSystemYt->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:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT m.*

  FROM vnj7t_modules AS m

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

  WHERE m.client_id = 0 
  AND m.title = 'Jshopping Search' 
  AND m.access IN (1,1) 
  AND m.published = 1 
  AND e.enabled = 1

  ORDER BY m.ordering

Роз'яснення

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ALL	element_clientid,element_folder_clientid	ВІДСУТНІЙ КЛЮЧ ІНДЕКСУ ДЛЯ ВИКОРИСТАННЯ	NULL	NULL	278	1.00	Using where; Using temporary; Використовуючи filesort
1	SIMPLE	m	NULL	ref	published,newsfeeds	newsfeeds	204	dy445040_sd.e.element,const	6	0.83	Using index condition; Using where

Профіль

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

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

#	Виклик	Номер файлу та рядка
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/modulesanywhere/src/Replace.php:290
15	RegularLabs\Plugin\System\ModulesAnywhere\Replace::getModuleFromDatabase()	JROOT/plugins/system/modulesanywhere/src/Replace.php:492
14	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:444
13	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:628
12	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:610
11	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:67
10	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/src/Replace.php:122
9	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceTags()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:98
8	PlgSystemModulesAnywhere->changeFinalHtmlOutput()	JROOT/libraries/regularlabs/src/SystemPlugin.php:440
7	RegularLabs\Library\SystemPlugin->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:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

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

2 &#215; SELECT home 
  FROM vnj7t_menu

2 &#215; SELECT * 
  FROM vnj7t_jshopping_categories

2 &#215; SELECT 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 vnj7t_fields AS a 
  LEFT JOIN `vnj7t_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN vnj7t_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN vnj7t_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN vnj7t_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN vnj7t_fields_groups AS g 
  ON g.id = a.group_id

2 &#215; SELECT m.* 
  FROM vnj7t_modules AS m 
  LEFT JOIN vnj7t_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 &#215; SELECT * 
  FROM `vnj7t_jshopping_products_files`

1 &#215; SELECT id, image, `name_uk-UA` as name 
  FROM `vnj7t_jshopping_product_labels`

1 &#215; SELECT FA.id, FA.required, FA.`name_uk-UA` as name, FA.`description_uk-UA` as description, FA.type 
  FROM `vnj7t_jshopping_products_free_attr` as PFA 
  left join `vnj7t_jshopping_free_attr` as FA 
  on FA.id=PFA.attr_id

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

1 &#215; SELECT  video_name, video_id, video_preview, video_code 
  FROM `vnj7t_jshopping_products_videos`

1 &#215; SELECT * 
  FROM `vnj7t_jshopping_products_reviews`

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

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

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

1 &#215; SELECT template_style_id 
  FROM vnj7t_menu

1 &#215; SELECT id 
  FROM vnj7t_template_styles

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

1 &#215; SELECT `c2`.`language`,`c2`.`id` 
  FROM `vnj7t_menu` AS `c` 
  INNER JOIN `vnj7t_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `vnj7t_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `vnj7t_menu` AS `c2` 
  ON a2.id = c2.`id`

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

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

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

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

1 &#215; SELECT b.id 
  FROM vnj7t_usergroups AS a 
  LEFT JOIN vnj7t_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 vnj7t_extensions

1 &#215; SELECT * 
  FROM vnj7t_languages

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

1 &#215; SELECT * 
  FROM vnj7t_jshopping_config

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

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

1 &#215; select id,link 
  from vnj7t_menu

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

1 &#215; SELECT * 
  FROM vnj7t_jshopping_products

1 &#215; SELECT * 
  FROM `vnj7t_jshopping_products_to_categories`

1 &#215; SELECT attr_id, `name_uk-UA` as name, `description_uk-UA` as description, attr_type, independent, allcats, cats, attr_ordering 
  FROM `vnj7t_jshopping_attr`

1 &#215; SELECT * 
  FROM `vnj7t_jshopping_products_attr2`

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 `vnj7t_jshopping_products_extra_fields` as F 
  left join `vnj7t_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group

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.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`  
  FROM `vnj7t_jshopping_products_relations` AS relation                 
  INNER JOIN `vnj7t_jshopping_products` AS prod 
  ON relation.product_related_id = prod.product_id                 
  LEFT JOIN `vnj7t_jshopping_products_to_categories` AS pr_cat 
  ON pr_cat.product_id = relation.product_related_id                 
  LEFT JOIN `vnj7t_jshopping_categories` AS cat 
  ON pr_cat.category_id = cat.category_id

1 &#215; SELECT template 
  FROM vnj7t_template_styles

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

1 &#215; UPDATE `vnj7t_extensions` 
  SET `params` = '{\"mediaversion\":\"56f05195d5739a2ba1507685b8101958\"}'

1 &#215; SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_config

1 &#215; SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_currencies

1 &#215; SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_products

1 &#215; SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_attr

1 &#215; SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_users

1 &#215; SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_products_extra_fields

1 &#215; SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_taxes

1 &#215; SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_products_extra_field_values

1 &#215; SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_product_labels

1 &#215; SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_categories

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

1 &#215; SHOW FULL COLUMNS 
  FROM `vnj7t_jshopping_products_reviews

Ваше Ім´я
Ваш E-mail
Текст відгуку
Ваша оцінка

Австрійська цегла (піщаний кантрі) (Код: MW 007 PK)

Слідкуйте за нами у

Ми у

Наші сторінки у

Меню сайту

Групи товарів

Як ми працюємо

Чому вибирають нас

Меню сайту

Групи товарів

Як ми працюємо

Чому вибирають нас

Меню сайту

Групи товарів

Як ми працюємо

Чому вибирають нас

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

Сесія

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

Час

Пам'ять

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

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

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

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

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

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

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