Вет. препараты - Товары

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

Сессия

{
    "__default": {
        "session": {
            "counter": 59,
            "timer": {
                "start": 1794127711,
                "last": 1794127802,
                "now": 1794127804
            },
            "client": {
                "forwarded": "216.73.216.231"
            },
            "token": "5F6U8zvHpGhms1beJ2WzE97wKHVszhkS"
        },
        "registry": {
            "com_jbusinessdirectory": {
                "offers": {
                    "ordercol": null
                },
                "listing": {
                    "search": {
                        "ordercol": null
                    }
                }
            }
        },
        "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
        },
        "menuId": "631",
        "of-categorySearch": 2595,
        "offersMenuItemId": "631",
        "of-categoryId": 2595,
        "of-countrySearch": "",
        "of-citySearch": "",
        "of-regionSearch": "",
        "of-provinceSearch": "",
        "customAtrributes": "",
        "location": "",
        "geo-latitude": "",
        "geo-longitude": "",
        "geo-country": "",
        "geolocation": "",
        "of-filter-by-fav": "",
        "of-filterParams": "",
        "of-categories": "",
        "of-zipcode": "",
        "of-radius": "",
        "of-minprice": 0,
        "of-maxprice": 0,
        "of-typeSearch": "",
        "of-price-range": "",
        "of-itemType": 1,
        "categorySearch": "1474",
        "searchkeyword": "",
        "searchkeywordLocation": "",
        "typeSearch": "",
        "citySearch": "",
        "starRating": "",
        "regionSearch": "",
        "countrySearch": 0,
        "zipcode": "",
        "letter": "",
        "radius": 100,
        "provinceSearch": "",
        "areaSearch": "",
        "filter-by-fav": "",
        "filterParams": "",
        "categories": "",
        "onlyLocal": 0,
        "categoryId": 1474,
        "listing-search": true,
        "menuItemId": "201",
        "showCustomMarkers": 1,
        "moreFilters": null,
        "lSearchType": 1
    }
}

Профилирование

Время

Память

Время: 5.65 ms / 5.65 ms Память: 0.345 MB / 0.68 MB Application: afterLoad

Время: 144.45 ms / 150.10 ms Память: 2.702 MB / 3.38 MB Application: afterInitialise

Время: 9.28 ms / 159.38 ms Память: 0.198 MB / 3.58 MB Application: Before Access::preloadComponents (all components)

Время: 6.66 ms / 166.04 ms Память: 0.056 MB / 3.63 MB Application: After Access::preloadComponents (all components)

Время: 0.04 ms / 166.08 ms Память: 0.000 MB / 3.63 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Время: 0.16 ms / 166.24 ms Память: 0.007 MB / 3.64 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Время: 15.42 ms / 181.66 ms Память: 0.172 MB / 3.81 MB Application: afterRoute

Время: 12.64 ms / 194.30 ms Память: 0.057 MB / 3.87 MB Application: beforeRenderComponent com_jbusinessdirectory

Время: 390.28 ms / 584.58 ms Память: 2.505 MB / 6.37 MB Application: afterRenderComponent com_jbusinessdirectory

Время: 5.43 ms / 590.01 ms Память: 0.029 MB / 6.40 MB Application: afterDispatch

Время: 16.53 ms / 606.54 ms Память: 0.089 MB / 6.49 MB Application: beforeRenderModule mod_menu (Offcanvas)

Время: 11.67 ms / 618.21 ms Память: 0.036 MB / 6.53 MB Application: afterRenderModule mod_menu (Offcanvas)

Время: 0.05 ms / 618.26 ms Память: -0.000 MB / 6.53 MB Application: beforeRenderModule mod_tiptopuser (MOD_TIPTOPUSER (2))

Время: 0.20 ms / 618.45 ms Память: 0.019 MB / 6.55 MB Application: afterRenderModule mod_tiptopuser (MOD_TIPTOPUSER (2))

Время: 0.08 ms / 618.54 ms Память: -0.015 MB / 6.53 MB Application: beforeRenderModule mod_random_image (изо)

Время: 0.94 ms / 619.48 ms Память: 0.009 MB / 6.54 MB Application: afterRenderModule mod_random_image (изо)

Время: 0.07 ms / 619.56 ms Память: -0.002 MB / 6.54 MB Application: beforeRenderModule mod_menu (Company)

Время: 8.39 ms / 627.95 ms Память: 0.029 MB / 6.57 MB Application: afterRenderModule mod_menu (Company)

Время: 0.12 ms / 628.07 ms Память: -0.002 MB / 6.57 MB Application: beforeRenderModule mod_menu (Меню1)

Время: 0.41 ms / 628.48 ms Память: 0.027 MB / 6.59 MB Application: afterRenderModule mod_menu (Меню1)

Время: 0.05 ms / 628.53 ms Память: -0.003 MB / 6.59 MB Application: beforeRenderModule mod_custom (999)

Время: 3.30 ms / 631.83 ms Память: 0.006 MB / 6.60 MB Application: afterRenderModule mod_custom (999)

Время: 7.15 ms / 638.98 ms Память: -0.002 MB / 6.59 MB Application: beforeRenderModule mod_custom (цитата)

Время: 0.15 ms / 639.12 ms Память: 0.003 MB / 6.60 MB Application: afterRenderModule mod_custom (цитата)

Время: 0.06 ms / 639.19 ms Память: -0.001 MB / 6.60 MB Application: beforeRenderModule mod_breadcrumbs (крошки)

Время: 2.24 ms / 641.43 ms Память: 0.011 MB / 6.61 MB Application: afterRenderModule mod_breadcrumbs (крошки)

Время: 0.10 ms / 641.53 ms Память: 0.001 MB / 6.61 MB Application: beforeRenderModule mod_tiptopuser (MOD_TIPTOPUSER)

Время: 0.19 ms / 641.72 ms Память: 0.015 MB / 6.62 MB Application: afterRenderModule mod_tiptopuser (MOD_TIPTOPUSER)

Время: 41.31 ms / 683.02 ms Память: 0.488 MB / 7.11 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Время: 0.22 ms / 683.24 ms Память: 0.006 MB / 7.12 MB Application: After Access::getAssetRules (id:1 name:root.1)

Время: 841.74 ms / 1524.98 ms Память: 0.863 MB / 7.98 MB Application: afterRender

Всего запросов к базе данных: 340.91 ms

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

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 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:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Такой же, как вызов в строке ниже
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

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

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

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_extensions	NULL	ref	extension	extension	82	const	208	0.60	Using where; Используется сортировка файлов

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.50 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

#	Вызывающий объект	Файл и номер строки
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Такой же, как вызов в строке ниже
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	INDEX KEY не используется	NULL	NULL	227	6.56	Using where; Используется сортировка файлов
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.m.component_id	1	100.00	Using where

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.00 ms
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.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.43 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

#	Вызывающий объект	Файл и номер строки
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
23	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Такой же, как вызов в строке ниже
22	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
21	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
20	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
19	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
18	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
17	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
16	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
15	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
14	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
13	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
12	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
11	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Router/Route.php:134
10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
9	Joomla\CMS\Router\Route::_()	JROOT/components/com_j_sms_registration/helpers/J_sms_registrationHelper.php:44
8	Jsmsregistration\Component\J_sms_registration\Site\Helper\J_sms_registrationHelper->__construct()	JROOT/plugins/system/j_sms_registration/j_sms_registration.php:67
7	plgSystemJ_Sms_Registration->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_nextend2_section_storage	NULL	ref	application,application_2	application	284	const,const	1	100.00	Using where

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182
12	Nextend\Framework\Database\Joomla\JoomlaConnectorTable->setQuery()	JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:56
11	Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findByAttributes()	JROOT/libraries/smartslider3/src/Framework/Model/ApplicationSection.php:44
10	Nextend\Framework\Model\ApplicationSection->get()	JROOT/libraries/smartslider3/src/SmartSlider3/Settings.php:17
9	Nextend\SmartSlider3\Settings::getAll()	JROOT/libraries/smartslider3/src/SmartSlider3/Settings.php:25
8	Nextend\SmartSlider3\Settings::get()	JROOT/plugins/system/smartslider3/smartslider3.php:16
7	require_once JROOT/plugins/system/smartslider3/smartslider3.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
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:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	4	20.00	Using where

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

EXPLAIN недоступен для: INSERT INTO `mwfjp_honeysuckle_logs` (`ip`,`published`,`url`,`log`,`created`) VALUES ('216.73.216.231','1','https://oftopplata.ru/predloheniya?offerCategoryId=2595','Array\n(\n [offerCategoryId] => 2595\n)\n','2026-11-08 08:50:04')

Профиль

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
update	0.08 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.48 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1421
11	JDatabaseDriver->insertObject()	JROOT/plugins/system/honeysuckle/libs/main.php:100
10	HoneysuckleMain->setLog()	JROOT/plugins/system/honeysuckle/honeysuckle.php:245
9	plgSystemHoneysuckle->addSpamopronaLog()	JROOT/plugins/system/honeysuckle/honeysuckle.php:104
8	plgSystemHoneysuckle->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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.34 ms После последнего запроса: 0.15 ms Память запроса: 0.005 MB. Память перед запросом: 3.313 MB

DELETE 

  FROM `mwfjp_honeysuckle_logs`

  WHERE `created` < '2026-11-08 07:50:04'

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

EXPLAIN недоступен для: DELETE FROM `mwfjp_honeysuckle_logs` WHERE `created` < '2026-11-08 07:50:04'

Профиль

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.04 ms
updating	0.84 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/honeysuckle/libs/main.php:127
11	HoneysuckleMain->deleteLogs()	JROOT/plugins/system/honeysuckle/libs/main.php:102
10	HoneysuckleMain->setLog()	JROOT/plugins/system/honeysuckle/honeysuckle.php:245
9	plgSystemHoneysuckle->addSpamopronaLog()	JROOT/plugins/system/honeysuckle/honeysuckle.php:104
8	plgSystemHoneysuckle->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:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 6.45 ms После последнего запроса: 20.10 ms Память запроса: 0.023 MB. Память перед запросом: 3.582 MB Возвращено строк: 44

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

  FROM `mwfjp_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_honeysuckle','com_installer','com_j_sms_registration','com_jbusinessdirectory','com_jchoptimize','com_jmap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_smartslider3','com_speasyimagegallery','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_assets	NULL	ALL	idx_asset_name	INDEX KEY не используется	NULL	NULL	239	18.83	Using where

Профиль

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.16 ms
preparing	0.02 ms
executing	0.29 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:192
8	RegularLabs\Library\SystemPlugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.52 ms После последнего запроса: 0.48 ms Память запроса: 0.060 MB. Память перед запросом: 3.640 MB Возвращено строк: 410

SELECT fas.*
	                  
  FROM mwfjp_jbusinessdirectory_application_settings fas

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fas	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	410	100.00	NULL

Профиль

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.56 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:67
11	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:50
10	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/jbdrouter.php:58
9	JBDRouter->getRouteParams()	JROOT/plugins/system/urltranslator/urltranslator.php:83
8	plgSystemUrlTranslator->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.47 ms После последнего запроса: 0.29 ms Память запроса: 0.021 MB. Память перед запросом: 3.921 MB Возвращено строк: 1

SELECT fas.*
	                  
  FROM mwfjp_jbusinessdirectory_date_formats fas
	                
  WHERE fas.id ='2'

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

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

Профиль

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	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:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:78
11	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:50
10	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/jbdrouter.php:58
9	JBDRouter->getRouteParams()	JROOT/plugins/system/urltranslator/urltranslator.php:83
8	plgSystemUrlTranslator->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 4.77 ms После последнего запроса: 0.05 ms Память запроса: 0.021 MB. Память перед запросом: 3.927 MB Возвращено строк: 1

SELECT fas.*
	                  
  FROM mwfjp_jbusinessdirectory_currencies fas
	                
  WHERE fas.currency_id ='116'

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

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

Профиль

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:87
11	JBusinessUtil::getAppSettings()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:50
10	JBusinessUtil::getApplicationSettings()	JROOT/plugins/system/urltranslator/jbdrouter.php:58
9	JBDRouter->getRouteParams()	JROOT/plugins/system/urltranslator/urltranslator.php:83
8	plgSystemUrlTranslator->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.32 ms После последнего запроса: 0.29 ms Память запроса: 0.084 MB. Память перед запросом: 3.707 MB Возвращено строк: 4

SELECT id, home, template, s.params

  FROM mwfjp_template_styles as s

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	oftopplata_r.e.element	1	80.00	Using index condition; Using where

Профиль

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
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.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.15 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:273
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:278
9	PlgSystemHelixultimate->attachWebAsset()	JROOT/plugins/system/helixultimate/helixultimate.php:307
8	PlgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 5.36 ms После последнего запроса: 0.60 ms Память запроса: 0.084 MB. Память перед запросом: 3.762 MB Возвращено строк: 1

SELECT *

  FROM `mwfjp_template_styles`

  WHERE `id` = 10

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

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

Профиль

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:59
11	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:343
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:278
9	PlgSystemHelixultimate->attachWebAsset()	JROOT/plugins/system/helixultimate/helixultimate.php:307
8	PlgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 3.67 ms После последнего запроса: 0.74 ms Память запроса: 0.022 MB. Память перед запросом: 3.833 MB Возвращено строк: 1

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

  FROM `mwfjp_extensions`

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

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

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

Профиль

Status	Duration
starting	0.36 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.35 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Такой же, как вызов в строке ниже
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 6.34 ms После последнего запроса: 0.16 ms Память запроса: 0.004 MB. Память перед запросом: 3.823 MB

UPDATE `mwfjp_extensions`

  SET `params` = '{\"mediaversion\":\"44714c4d1d36e036b3ba4f2f57e7fc94\"}'

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

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

EXPLAIN недоступен для: UPDATE `mwfjp_extensions` SET `params` = '{\"mediaversion\":\"44714c4d1d36e036b3ba4f2f57e7fc94\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Профиль

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.07 ms
updating	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	1.84 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.56 ms После последнего запроса: 0.39 ms Память запроса: 0.019 MB. Память перед запросом: 3.831 MB Возвращено строк: 1

SELECT *

  FROM mwfjp_languages

  WHERE published=1

  ORDER BY ordering ASC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_languages	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	2	50.00	Using where; Используется сортировка файлов

Профиль

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.09 ms
executing	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.84 ms После последнего запроса: 75.20 ms Память запроса: 0.024 MB. Память перед запросом: 5.080 MB Возвращено строк: 62

SELECT *
	                  
  FROM mwfjp_jbusinessdirectory_mobile_app_config

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_jbusinessdirectory_mobile_app_config	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	62	100.00	NULL

Профиль

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.63 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:9475
16	JBusinessUtil::getMobileAppConfig()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:9494
15	JBusinessUtil::getMobileAppSettings()	JROOT/components/com_jbusinessdirectory/models/offers.php:20
14	JBusinessDirectoryModelOffers->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
13	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
12	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
11	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
10	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 7.12 ms После последнего запроса: 0.47 ms Память запроса: 0.024 MB. Память перед запросом: 5.097 MB Возвращено строк: 5

SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_default_attributes`

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

EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `mwfjp_jbusinessdirectory_default_attributes`

Профиль

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.47 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.08 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:19
13	TableDefaultAttributes->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:5830
11	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:57
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.78 ms После последнего запроса: 0.27 ms Память запроса: 0.023 MB. Память перед запросом: 5.131 MB Возвращено строк: 70

SELECT id, name, offer_config as config 
  FROM mwfjp_jbusinessdirectory_default_attributes

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_jbusinessdirectory_default_attributes	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	70	100.00	NULL

Профиль

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/defaultattributes.php:43
12	TableDefaultAttributes->getAttributesConfiguration()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:5831
11	JBusinessUtil::getAttributeConfiguration()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:57
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 218.34 ms После последнего запроса: 0.31 ms Память запроса: 0.029 MB. Память перед запросом: 5.153 MB Возвращено строк: 346

SELECT a.id AS value, a.name AS text, a.level, a.published, a.parent_id

  FROM mwfjp_jbusinessdirectory_categories AS a

  LEFT JOIN `mwfjp_jbusinessdirectory_categories` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

  WHERE a.published = 1 
  AND (a.type IN (0,2)) 
  AND a.id >1

  GROUP BY a.id, a.name, a.level, a.lft, a.rgt, a.parent_id, a.published

  ORDER BY a.lft ASC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	PRIMARY,idx_state,idx_type	PRIMARY	4	NULL	691	20.00	Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	b	NULL	ALL	idx_lft,idx_rgt	INDEX KEY не используется	NULL	NULL	692	100.00	Range checked for each record (index map: 0xC0)

Профиль

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 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.01 ms
statistics	0.12 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	217.68 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.03 ms
closing tables	0.01 ms
freeing items	0.39 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:3655
11	JBusinessUtil::getCategoriesOptions()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:75
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.39 ms После последнего запроса: 0.26 ms Память запроса: 0.022 MB. Память перед запросом: 5.352 MB Возвращено строк: 0

SELECT t.*
					
  from  mwfjp_jbusinessdirectory_categories c
					
  inner join  mwfjp_jbusinessdirectory_language_translations t 
  on c.id=t.object_id 
  where t.type=3 
  and language_tag='ru-RU'

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	ref	idx_object,ids_langauge,ids_type	ids_langauge	33	const	1	100.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.t.object_id	1	100.00	Using index

Профиль

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 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:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jbusinessdirectory/helpers/translations.php:68
13	JBusinessDirectoryTranslations::getCategoriesTranslationsObjects()	JROOT/components/com_jbusinessdirectory/helpers/translations.php:44
12	JBusinessDirectoryTranslations::getCategoriesTranslations()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:3657
11	JBusinessUtil::getCategoriesOptions()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:75
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.36 ms После последнего запроса: 0.54 ms Память запроса: 0.025 MB. Память перед запросом: 5.372 MB Возвращено строк: 18

SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_attributes`

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

EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `mwfjp_jbusinessdirectory_attributes`

Профиль

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.43 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
executing	0.09 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/attribute.php:19
17	JTableAttribute->__construct()	JROOT/libraries/src/Table/Table.php:328
16	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:110
15	Joomla\CMS\MVC\Factory\LegacyFactory->createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:392
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:485
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable()	JROOT/components/com_jbusinessdirectory/models/offers.php:1114
12	JBusinessDirectoryModelOffers->getCustomAttributeValues()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:108
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.33 ms После последнего запроса: 0.44 ms Память запроса: 0.025 MB. Память перед запросом: 5.403 MB Возвращено строк: 22

SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_categories`

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

EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `mwfjp_jbusinessdirectory_categories`

Профиль

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.41 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.07 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:28
17	JBusinessTableCategory->__construct()	JROOT/libraries/src/Table/Table.php:328
16	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:110
15	Joomla\CMS\MVC\Factory\LegacyFactory->createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:392
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:485
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable()	JROOT/components/com_jbusinessdirectory/models/offers.php:1190
12	JBusinessDirectoryModelOffers->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:113
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.25 ms После последнего запроса: 0.15 ms Память запроса: 0.022 MB. Память перед запросом: 5.436 MB Возвращено строк: 1

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

select * 
  from mwfjp_jbusinessdirectory_categories c
				 
  where c.id=2595

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

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	NULL

Профиль

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.17 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:50
13	JBusinessTableCategory->getCategoryById()	JROOT/components/com_jbusinessdirectory/models/offers.php:1191
12	JBusinessDirectoryModelOffers->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:113
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.22 ms После последнего запроса: 0.11 ms Память запроса: 0.024 MB. Память перед запросом: 5.444 MB Возвращено строк: 1

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

select * 
  from mwfjp_jbusinessdirectory_categories c
				 
  where c.id=2595

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

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	NULL

Профиль

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.11 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:50
16	JBusinessTableCategory->getCategoryById()	JROOT/components/com_jbusinessdirectory/helpers/category_lib.php:107
15	JBusinessDirectorCategoryLib->getCompleteCategoryById()	JROOT/components/com_jbusinessdirectory/helpers/category_lib.php:304
14	JBusinessDirectorCategoryLib->getCategoryLeafs()	JROOT/components/com_jbusinessdirectory/models/offers.php:379
13	JBusinessDirectoryModelOffers->getSearchParameters()	JROOT/components/com_jbusinessdirectory/models/offers.php:743
12	JBusinessDirectoryModelOffers->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:117
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.69 ms После последнего запроса: 0.06 ms Память запроса: 0.078 MB. Память перед запросом: 5.454 MB Возвращено строк: 346

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

select * 
  from mwfjp_jbusinessdirectory_categories 
  where published=1 
  and type = 2 
  order by lft, parent_id, name

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_jbusinessdirectory_categories	NULL	ref	idx_state,idx_type	idx_type	1	const	346	100.00	Using where; Используется сортировка файлов

Профиль

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	1.38 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:63
16	JBusinessTableCategory->getAllCategories()	JROOT/components/com_jbusinessdirectory/helpers/category_lib.php:111
15	JBusinessDirectorCategoryLib->getCompleteCategoryById()	JROOT/components/com_jbusinessdirectory/helpers/category_lib.php:304
14	JBusinessDirectorCategoryLib->getCategoryLeafs()	JROOT/components/com_jbusinessdirectory/models/offers.php:379
13	JBusinessDirectoryModelOffers->getSearchParameters()	JROOT/components/com_jbusinessdirectory/models/offers.php:743
12	JBusinessDirectoryModelOffers->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:117
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.05 ms После последнего запроса: 9.11 ms Память запроса: 0.025 MB. Память перед запросом: 5.458 MB Возвращено строк: 61

SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_company_offers`

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

EXPLAIN недоступен для: SHOW FULL COLUMNS FROM `mwfjp_jbusinessdirectory_company_offers`

Профиль

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.43 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
executing	0.09 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/offer.php:20
14	JTableOffer->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/offers.php:750
12	JBusinessDirectoryModelOffers->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:117
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.28 ms После последнего запроса: 0.25 ms Память запроса: 0.023 MB. Память перед запросом: 5.537 MB Возвращено строк: 1

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

select * 
  from mwfjp_jbusinessdirectory_categories c
				 
  where c.id=2595

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

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	NULL

Профиль

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 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:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:50
14	JBusinessTableCategory->getCategoryById()	JROOT/components/com_jbusinessdirectory/helpers/category_lib.php:107
13	JBusinessDirectorCategoryLib->getCompleteCategoryById()	JROOT/components/com_jbusinessdirectory/models/offers.php:761
12	JBusinessDirectoryModelOffers->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:117
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.54 ms После последнего запроса: 0.07 ms Память запроса: 0.078 MB. Память перед запросом: 5.548 MB Возвращено строк: 346

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

select * 
  from mwfjp_jbusinessdirectory_categories 
  where published=1 
  and type = 2 
  order by lft, parent_id, name

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_jbusinessdirectory_categories	NULL	ref	idx_state,idx_type	idx_type	1	const	346	100.00	Using where; Используется сортировка файлов

Профиль

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	1.21 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:63
14	JBusinessTableCategory->getAllCategories()	JROOT/components/com_jbusinessdirectory/helpers/category_lib.php:111
13	JBusinessDirectorCategoryLib->getCompleteCategoryById()	JROOT/components/com_jbusinessdirectory/models/offers.php:761
12	JBusinessDirectoryModelOffers->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:117
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.17 ms После последнего запроса: 9.26 ms Память запроса: 0.006 MB. Память перед запросом: 5.552 MB


  SET SESSION group_concat_max_len = 10000

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

EXPLAIN недоступен для: SET SESSION group_concat_max_len = 10000

Профиль

Status	Duration
starting	0.05 ms
Opening tables	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:6923
14	JBusinessUtil::setGroupConcatLenght()	JROOT/administrator/components/com_jbusinessdirectory/tables/offer.php:763
13	JTableOffer->getTotalOffersByObject()	JROOT/components/com_jbusinessdirectory/models/offers.php:774
12	JBusinessDirectoryModelOffers->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:117
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.63 ms После последнего запроса: 0.12 ms Память запроса: 0.022 MB. Память перед запросом: 5.563 MB Возвращено строк: 5

select count(distinct co.id) as nr_offers, 
                         co.featured as featured  , cg1.name, cg1.id   
					
  from
					mwfjp_jbusinessdirectory_company_offers co
                    
  left join mwfjp_jbusinessdirectory_company_offer_category cc 
  on co.id=cc.offerId 
					
  left join mwfjp_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1
					
  left join mwfjp_jbusinessdirectory_categories cg1 
  ON cg1.id = cg.parent_id or cg1.id=cg.id
					
					
  left join  mwfjp_jbusinessdirectory_company_offer_types et 
  on co.offer_type=et.id  
  where co.state=1 
  and co.approved !=-1 
					         
  and ((co.publish_start_date<=DATE(now()) or co.publish_start_date='0000-00-00' or co.publish_start_date is null) 
  and ((co.publish_start_date=DATE(now()) 
  and time(co.publish_start_time)<=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_start_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_start_time='00:00:00' or co.publish_start_time is null))
		      
  and ((co.publish_end_date>=DATE(now()) or co.publish_end_date='0000-00-00' or co.publish_end_date is null ) 
  and ((co.publish_end_date=DATE(now()) 
  and time(co.publish_end_time)>=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_end_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_end_time='00:00:00' or co.publish_end_time is null) )  
  and cg1.parent_id = 2579    
					  
					
  group by cg1.id
					
  having 1
					
  order by cg1.name

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	co	NULL	ref	PRIMARY,idx_approved,idx_search,idx_publish_time	idx_search	1	const	60	21.16	Using index condition; Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	et	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.co.offer_type	1	100.00	Using index
1	SIMPLE	cc	NULL	ref	PRIMARY	PRIMARY	4	oftopplata_r.co.id	2	100.00	Using index
1	SIMPLE	cg	NULL	eq_ref	PRIMARY,idx_parent,idx_state	PRIMARY	4	oftopplata_r.cc.categoryId	1	100.00	Using where
1	SIMPLE	cg1	NULL	ref	PRIMARY,idx_alias,idx_parent,idx_name,idx_state,idx_type,idx_lft,idx_rgt,idx_level	idx_parent	4	const	19	0.29	Using index condition

Профиль

Status	Duration
starting	0.14 ms
Executing hook on transaction	0.00 ms
starting	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
Opening tables	0.09 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.18 ms
preparing	0.04 ms
Creating tmp table	0.04 ms
Creating tmp table	0.05 ms
executing	0.86 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/offer.php:771
13	JTableOffer->getTotalOffersByObject()	JROOT/components/com_jbusinessdirectory/models/offers.php:774
12	JBusinessDirectoryModelOffers->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:117
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.28 ms После последнего запроса: 0.14 ms Память запроса: 0.023 MB. Память перед запросом: 5.573 MB Возвращено строк: 1

select * 
  from mwfjp_jbusinessdirectory_categories c
				 
  where c.id=2579

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

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	NULL

Профиль

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 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:1662
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:50
14	JBusinessTableCategory->getCategoryById()	JROOT/components/com_jbusinessdirectory/helpers/category_lib.php:107
13	JBusinessDirectorCategoryLib->getCompleteCategoryById()	JROOT/components/com_jbusinessdirectory/models/offers.php:818
12	JBusinessDirectoryModelOffers->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:117
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.67 ms После последнего запроса: 0.07 ms Память запроса: 0.077 MB. Память перед запросом: 5.581 MB Возвращено строк: 346

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

select * 
  from mwfjp_jbusinessdirectory_categories 
  where published=1 
  and type = 2 
  order by lft, parent_id, name

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_jbusinessdirectory_categories	NULL	ref	idx_state,idx_type	idx_type	1	const	346	100.00	Using where; Используется сортировка файлов

Профиль

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	1.30 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:63
14	JBusinessTableCategory->getAllCategories()	JROOT/components/com_jbusinessdirectory/helpers/category_lib.php:111
13	JBusinessDirectorCategoryLib->getCompleteCategoryById()	JROOT/components/com_jbusinessdirectory/models/offers.php:818
12	JBusinessDirectoryModelOffers->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:117
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.21 ms После последнего запроса: 13.96 ms Память запроса: 0.022 MB. Память перед запросом: 5.636 MB Возвращено строк: 0

select count(distinct co.id) as nr_offers, 
                         co.featured as featured  , et.name as typeName, co.offer_type as typeId   
					
  from
					mwfjp_jbusinessdirectory_company_offers co
                    
  left join mwfjp_jbusinessdirectory_company_offer_category cc 
  on co.id=cc.offerId 
					
  left join mwfjp_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1
					
  left join mwfjp_jbusinessdirectory_categories cg1 
  ON cg1.id = cg.parent_id or cg1.id=cg.id
					
					
  left join  mwfjp_jbusinessdirectory_company_offer_types et 
  on co.offer_type=et.id  
  where co.state=1 
  and co.approved !=-1 
					         
  and ((co.publish_start_date<=DATE(now()) or co.publish_start_date='0000-00-00' or co.publish_start_date is null) 
  and ((co.publish_start_date=DATE(now()) 
  and time(co.publish_start_time)<=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_start_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_start_time='00:00:00' or co.publish_start_time is null))
		      
  and ((co.publish_end_date>=DATE(now()) or co.publish_end_date='0000-00-00' or co.publish_end_date is null ) 
  and ((co.publish_end_date=DATE(now()) 
  and time(co.publish_end_time)>=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_end_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_end_time='00:00:00' or co.publish_end_time is null) )  
  and cc.categoryId in (2595,2595)   
					  
					
  group by et.id
					
  having 1
					
  order by et.ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	co	NULL	ref	PRIMARY,idx_approved,idx_search,idx_publish_time	idx_search	1	const	60	21.16	Using index condition; Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	cc	NULL	ref	PRIMARY	PRIMARY	4	oftopplata_r.co.id	2	20.00	Using where; Using index
1	SIMPLE	cg	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	oftopplata_r.cc.categoryId	1	100.00	Using where
1	SIMPLE	cg1	NULL	ALL	PRIMARY	INDEX KEY не используется	NULL	NULL	692	100.00	Range checked for each record (index map: 0x1)
1	SIMPLE	et	NULL	eq_ref	PRIMARY,idx_name	PRIMARY	4	oftopplata_r.co.offer_type	1	100.00	NULL

Профиль

Status	Duration
starting	0.19 ms
Executing hook on transaction	0.01 ms
starting	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
Opening tables	0.10 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.04 ms
Creating tmp table	0.05 ms
Creating tmp table	0.05 ms
executing	0.36 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/offer.php:771
13	JTableOffer->getTotalOffersByObject()	JROOT/components/com_jbusinessdirectory/models/offers.php:945
12	JBusinessDirectoryModelOffers->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:117
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.48 ms После последнего запроса: 0.15 ms Память запроса: 0.023 MB. Память перед запросом: 5.641 MB Возвращено строк: 59

select id, name 
  from mwfjp_jbusinessdirectory_attributes 
  where status = 1 
  and attribute_type = 2  
  order by name

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_jbusinessdirectory_attributes	NULL	ref	idx_status,idx_attribute_type	idx_attribute_type	1	const	59	99.16	Using where; Используется сортировка файлов

Профиль

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.15 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/attribute.php:100
13	JTableAttribute->getSearchAttributeValues()	JROOT/components/com_jbusinessdirectory/models/offers.php:967
12	JBusinessDirectoryModelOffers->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:117
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.20 ms После последнего запроса: 0.19 ms Память запроса: 0.022 MB. Память перед запросом: 5.687 MB Возвращено строк: 0

select count(distinct co.id) as nr_offers, 
                         co.featured as featured  , a2.name, a2.id, ao2.name as optionName, ca2.value   
					
  from
					mwfjp_jbusinessdirectory_company_offers co
                    
  left join mwfjp_jbusinessdirectory_company_offer_category cc 
  on co.id=cc.offerId 
					
  left join mwfjp_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1
					
  left join mwfjp_jbusinessdirectory_categories cg1 
  ON cg1.id = cg.parent_id or cg1.id=cg.id
					
					
  left join  mwfjp_jbusinessdirectory_company_offer_types et 
  on co.offer_type=et.id 
					
  left join mwfjp_jbusinessdirectory_offer_attributes AS ca 
  on ca.offer_id=co.id
					
  left join mwfjp_jbusinessdirectory_attributes a 
  on ca.attribute_id = a.id
					
  left join mwfjp_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id 
  and ca.value = ao.id
					
					
  left join mwfjp_jbusinessdirectory_offer_attributes AS ca2 
  on ca2.offer_id=co.id
					
  left join mwfjp_jbusinessdirectory_attributes a2 
  on ca2.attribute_id = a2.id
					
  left join mwfjp_jbusinessdirectory_attribute_options as ao2 
  on ao2.attribute_id = a2.id 
  and ca2.value = ao2.id
					 
  where co.state=1 
  and co.approved !=-1 
					         
  and ((co.publish_start_date<=DATE(now()) or co.publish_start_date='0000-00-00' or co.publish_start_date is null) 
  and ((co.publish_start_date=DATE(now()) 
  and time(co.publish_start_time)<=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_start_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_start_time='00:00:00' or co.publish_start_time is null))
		      
  and ((co.publish_end_date>=DATE(now()) or co.publish_end_date='0000-00-00' or co.publish_end_date is null ) 
  and ((co.publish_end_date=DATE(now()) 
  and time(co.publish_end_time)>=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_end_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_end_time='00:00:00' or co.publish_end_time is null) )  
  and cc.categoryId in (2595,2595)   
					  
  and (ca2.value!="" or ca2.option_id > 0)
					
  group by a2.id, ca2.value, ao2.name
					
  having 1
					
  order by a2.ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ca2	NULL	ALL	event_UNIQUE,idx_option	INDEX KEY не используется	NULL	NULL	398	93.33	Using where; Using temporary; Используется сортировка файлов
1	SIMPLE	co	NULL	eq_ref	PRIMARY,idx_approved,idx_search,idx_publish_time	PRIMARY	4	oftopplata_r.ca2.offer_id	1	20.48	Using where
1	SIMPLE	cc	NULL	ref	PRIMARY	PRIMARY	4	oftopplata_r.ca2.offer_id	2	20.00	Using where; Using index
1	SIMPLE	a2	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.ca2.attribute_id	1	100.00	NULL
1	SIMPLE	cg	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	oftopplata_r.cc.categoryId	1	100.00	Using where
1	SIMPLE	ao2	NULL	eq_ref	PRIMARY,idx_attribute_id	PRIMARY	4	oftopplata_r.ca2.value	1	100.00	Using where
1	SIMPLE	cg1	NULL	ALL	PRIMARY	INDEX KEY не используется	NULL	NULL	692	100.00	Range checked for each record (index map: 0x1)
1	SIMPLE	et	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.co.offer_type	1	100.00	Using index
1	SIMPLE	ca	NULL	ref	event_UNIQUE	event_UNIQUE	4	oftopplata_r.ca2.offer_id	7	100.00	Using index
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.ca.attribute_id	1	100.00	Using index
1	SIMPLE	ao	NULL	eq_ref	PRIMARY,idx_attribute_id	PRIMARY	4	oftopplata_r.ca.value	1	100.00	Using where

Профиль

Status	Duration
starting	0.18 ms
Executing hook on transaction	0.00 ms
starting	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
Opening tables	0.12 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.05 ms
statistics	0.17 ms
preparing	0.04 ms
Creating tmp table	0.04 ms
Creating tmp table	0.05 ms
executing	1.27 ms
end	0.06 ms
query end	0.00 ms
waiting for handler commit	0.03 ms
closing tables	0.02 ms
freeing items	0.62 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/offer.php:771
13	JTableOffer->getTotalOffersByObject()	JROOT/components/com_jbusinessdirectory/models/offers.php:974
12	JBusinessDirectoryModelOffers->getSeachFilter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:117
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.48 ms После последнего запроса: 0.42 ms Память запроса: 0.024 MB. Память перед запросом: 5.638 MB Возвращено строк: 1

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

select * 
  from mwfjp_jbusinessdirectory_categories c
				 
  where c.id=2595

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

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	NULL

Профиль

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:50
17	JBusinessTableCategory->getCategoryById()	JROOT/components/com_jbusinessdirectory/helpers/category_lib.php:107
16	JBusinessDirectorCategoryLib->getCompleteCategoryById()	JROOT/components/com_jbusinessdirectory/helpers/category_lib.php:304
15	JBusinessDirectorCategoryLib->getCategoryLeafs()	JROOT/components/com_jbusinessdirectory/models/offers.php:379
14	JBusinessDirectoryModelOffers->getSearchParameters()	JROOT/components/com_jbusinessdirectory/models/offers.php:619
13	JBusinessDirectoryModelOffers->getTotal()	JROOT/components/com_jbusinessdirectory/models/offers.php:670
12	JBusinessDirectoryModelOffers->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:124
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.64 ms После последнего запроса: 0.12 ms Память запроса: 0.079 MB. Память перед запросом: 5.649 MB Возвращено строк: 346

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

select * 
  from mwfjp_jbusinessdirectory_categories 
  where published=1 
  and type = 2 
  order by lft, parent_id, name

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_jbusinessdirectory_categories	NULL	ref	idx_state,idx_type	idx_type	1	const	346	100.00	Using where; Используется сортировка файлов

Профиль

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	2.24 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.40 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/category.php:63
17	JBusinessTableCategory->getAllCategories()	JROOT/components/com_jbusinessdirectory/helpers/category_lib.php:111
16	JBusinessDirectorCategoryLib->getCompleteCategoryById()	JROOT/components/com_jbusinessdirectory/helpers/category_lib.php:304
15	JBusinessDirectorCategoryLib->getCategoryLeafs()	JROOT/components/com_jbusinessdirectory/models/offers.php:379
14	JBusinessDirectoryModelOffers->getSearchParameters()	JROOT/components/com_jbusinessdirectory/models/offers.php:619
13	JBusinessDirectoryModelOffers->getTotal()	JROOT/components/com_jbusinessdirectory/models/offers.php:670
12	JBusinessDirectoryModelOffers->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:124
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.74 ms После последнего запроса: 17.66 ms Память запроса: 0.022 MB. Память перед запросом: 5.667 MB Возвращено строк: 0

select co.id, co.subject, co.short_description, co.description, co.address, co.main_subcategory, co.city, co.county, co.province, co.area, co.street_number, co.postalCode, co.latitude, 
                    co.longitude, co.startDate, co.endDate, co.alias, co.view_type, co.article_id, co.url, co.show_time, co.created, co.type, co.companyId, co.time_zone,
				    co.price, co.specialPrice, co.currencyId, co.countryId, co.price_text, co.packages,
					co.quantity, co.enable_offer_selling,co.review_score, count(distinct cr.id) as nr_reviews,
				    et.name as offerType, et.id as typeId, bcm.markerLocation as categoryMaker,
					op.picture_info, op.picture_path, op.picture_title,GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color  
  ORDER BY cg.name separator '#|') as categories,
					 co.featured as featured   
					,cp.phone, cp.name as company_name, cp.id as company_id, cp.alias as company_alias, cp.logoLocation
					
					
  from
					mwfjp_jbusinessdirectory_company_offers co
					
  left join mwfjp_jbusinessdirectory_company_reviews cr 
  on cr.itemId = co.id  
  and cr.review_type = 2 
  and cr.approved=2 
					
  left join  mwfjp_jbusinessdirectory_company_offer_pictures op 
  on co.id=op.offerId
					
  and
						(op.id in (
								select  min(op1.id) as min 
  from mwfjp_jbusinessdirectory_company_offers co1
								
  left join  mwfjp_jbusinessdirectory_company_offer_pictures op1 
  on co1.id=op1.offerId
								
  where op1.picture_enable=1
								
  group by co1.id
							)
						)
                    
					
  left join mwfjp_jbusinessdirectory_company_offer_category cc 
  on co.id=cc.offerId
					
  left join mwfjp_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1
                    
  left join  mwfjp_jbusinessdirectory_company_offer_types et 
  on co.offer_type=et.id 
  left join mwfjp_jbusinessdirectory_categories bcm 
  on bcm.id=co.main_subcategory 
  and bcm.published=1 
					
  left join mwfjp_jbusinessdirectory_companies cp 
  on co.companyId = cp.id   
  where co.state=1 
  and co.approved !=-1 
					     
  and ((co.publish_start_date<=DATE(now()) or co.publish_start_date='0000-00-00' or co.publish_start_date is null) 
  and ((co.publish_start_date=DATE(now()) 
  and time(co.publish_start_time)<=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_start_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_start_time='00:00:00' or co.publish_start_time is null))
		      
  and ((co.publish_end_date>=DATE(now()) or co.publish_end_date='0000-00-00' or co.publish_end_date is null ) 
  and ((co.publish_end_date=DATE(now()) 
  and time(co.publish_end_time)>=time(convert_tz(now(),@@session.time_zone,co.time_zone)) or IFNULL(UNIX_TIMESTAMP(co.publish_end_date),0)!=UNIX_TIMESTAMP(DATE(now()))) or co.publish_end_time='00:00:00' or co.publish_end_time is null) )  
  and cc.categoryId in (2595,2595)   
  and (co.approved = 0 or co.approved = 1) 
					  
  and co.item_type = 1       
					 
					
  group by co.id
					
  having 1
					
  order by featured desc, co.id desc

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	co	NULL	ref	PRIMARY,idx_alias,idx_company,idx_country,idx_approved,idx_type,idx_featured,idx_latitude,idx_longitude,idx_price,idx_specialPrice,idx_subject,idx_city,idx_county,idx_area,idx_province,idx_short_description,idx_address,idx_user_id,idx_expiration_email_date,idx_search,idx_publish_time,idx_offer_type,idx_packages	idx_search	1	const	60	2.12	Using index condition; Using where; Using temporary; Используется сортировка файлов
1	PRIMARY	cc	NULL	ref	PRIMARY	PRIMARY	4	oftopplata_r.co.id	2	20.00	Using where; Using index
1	PRIMARY	cg	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	oftopplata_r.cc.categoryId	1	100.00	Using where
1	PRIMARY	et	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.co.offer_type	1	100.00	NULL
1	PRIMARY	bcm	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	oftopplata_r.co.main_subcategory	1	100.00	Using where
1	PRIMARY	cp	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.co.companyId	1	100.00	NULL
1	PRIMARY	cr	NULL	ref	idx_approved,idx_review_type,idx_item_id	idx_item_id	4	oftopplata_r.co.id	2	100.00	Using where
1	PRIMARY	op	NULL	ref	idx_offer	idx_offer	4	oftopplata_r.co.id	7	100.00	Using where
2	SUBQUERY	op1	NULL	ALL	idx_offer,idx_status	INDEX KEY не используется	NULL	NULL	376	100.00	Using where; Using temporary
2	SUBQUERY	co1	NULL	eq_ref	PRIMARY,idx_alias,idx_company,idx_country,idx_approved,idx_type,idx_featured,idx_latitude,idx_longitude,idx_price,idx_specialPrice,idx_subject,idx_city,idx_county,idx_area,idx_province,idx_short_description,idx_address,idx_user_id,idx_expiration_email_date,idx_search,idx_publish_time,idx_offer_type,idx_packages	PRIMARY	4	oftopplata_r.op1.offerId	1	100.00	Using index

Профиль

Status	Duration
starting	0.28 ms
Executing hook on transaction	0.01 ms
starting	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
Opening tables	0.23 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.07 ms
statistics	0.30 ms
preparing	0.08 ms
Creating tmp table	0.13 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
Creating tmp table	0.06 ms
executing	1.08 ms
end	0.04 ms
query end	0.01 ms
waiting for handler commit	0.03 ms
closing tables	0.03 ms
freeing items	0.95 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_jbusinessdirectory/tables/offer.php:804
14	JTableOffer->getTotalOffersByCategories()	JROOT/components/com_jbusinessdirectory/models/offers.php:640
13	JBusinessDirectoryModelOffers->getTotal()	JROOT/components/com_jbusinessdirectory/models/offers.php:670
12	JBusinessDirectoryModelOffers->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:124
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.86 ms После последнего запроса: 0.62 ms Память запроса: 0.150 MB. Память перед запросом: 5.703 MB Возвращено строк: 50

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down

  FROM mwfjp_modules AS m

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

  LEFT JOIN mwfjp_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	published,newsfeeds	INDEX KEY не используется	NULL	NULL	133	4.06	Using where; Используется сортировка файлов
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	oftopplata_r.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.m.id	1	100.00	Using where

Профиль

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.20 ms
preparing	0.04 ms
executing	1.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278
19	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
18	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_jbusinessdirectory/views/offers/tmpl/default.php:147
13	include JROOT/components/com_jbusinessdirectory/views/offers/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jbusinessdirectory/views/offers/view.html.php:127
10	JBusinessDirectoryViewOffers->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jbusinessdirectory/controller.php:23
8	JBusinessDirectoryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php:82
6	require_once JROOT/components/com_jbusinessdirectory/jbusinessdirectory.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.68 ms После последнего запроса: 72.28 ms Память запроса: 0.021 MB. Память перед запросом: 6.606 MB Возвращено строк: 0

SELECT *
 
  FROM mwfjp_jmap_metainfo
 
  WHERE `linkurl` = 'https://oftopplata.ru/predloheniya?offerCategoryId=2595'
 
  AND `published` = 1

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

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

Профиль

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:708
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 2.43 ms После последнего запроса: 0.12 ms Память запроса: 0.021 MB. Память перед запросом: 6.612 MB Возвращено строк: 0

SELECT *
 
  FROM mwfjp_jmap_canonicals
 
  WHERE `linkurl` = 'https://oftopplata.ru/predloheniya?offerCategoryId=2595'

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

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

Профиль

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 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:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:808
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.53 ms После последнего запроса: 0.42 ms Память запроса: 0.023 MB. Память перед запросом: 6.631 MB Возвращено строк: 1

SELECT *

  FROM `mwfjp_extensions`

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

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

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

Профиль

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.10 ms
preparing	0.05 ms
executing	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:124
17	NRFramework\Extension::get()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:176
16	NRFramework\Extension::isEnabled()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:159
15	NRFramework\Extension::componentIsEnabled()	JROOT/plugins/system/gsd/gsd.php:510
14	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:553
13	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:56
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 0.30 ms После последнего запроса: 24.02 ms Память запроса: 0.020 MB. Память перед запросом: 7.098 MB Возвращено строк: 0

SELECT *

  FROM `mwfjp_users`

  WHERE `password` = '' 
  AND `logged` = 1 
  AND `username` = ''

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

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

Профиль

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 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:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/j_sms_registration/j_sms_registration.php:344
9	plgSystemJ_Sms_Registration->getUser()	JROOT/plugins/system/j_sms_registration/j_sms_registration.php:391
8	plgSystemJ_Sms_Registration->checkForCookiesAvtorization()	JROOT/plugins/system/j_sms_registration/j_sms_registration.php:175
7	plgSystemJ_Sms_Registration->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:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 3.38 ms После последнего запроса: 9.53 ms Память запроса: 0.020 MB. Память перед запросом: 7.120 MB Возвращено строк: 0

SELECT *
 
  FROM mwfjp_jmap_headings
 
  WHERE `linkurl` = 'https://oftopplata.ru/predloheniya?offerCategoryId=2595'

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

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

Профиль

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
8	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:1124
7	plgSystemJMap->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:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Время запроса: 1.74 ms После последнего запроса: 1.69 ms Память запроса: 0.020 MB. Память перед запросом: 7.124 MB Возвращено строк: 0

SELECT
 `original_text`,
 `target_text`,
 `original_text_regex`,
 `target_text_regex`
 
  FROM
 `mwfjp_jmap_text_replacements`
 
  WHERE
`published` = 1

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

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

Профиль

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jmap/jmap.php:357
8	plgSystemJMap->patternReplacements()	JROOT/plugins/system/jmap/jmap.php:1201
7	plgSystemJMap->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:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

42 типов запросов зарегистрировано (отсортировано по вхождениям)

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

5 × select * 
  from mwfjp_jbusinessdirectory_categories c

4 × select * 
  from mwfjp_jbusinessdirectory_categories

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

1 × SELECT `data` 
  FROM `mwfjp_session`

1 × SELECT id, rules 
  FROM `mwfjp_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM mwfjp_extensions

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

1 × SELECT * 
  FROM `mwfjp_nextend2_section_storage`

1 × SELECT `template` 
  FROM `mwfjp_template_styles`

1 × SELECT * 
  FROM `mwfjp_honeysuckle_spam`

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `mwfjp_assets`

1 × SELECT fas.*                    
  FROM mwfjp_jbusinessdirectory_application_settings fa

1 × SELECT fas.*                    
  FROM mwfjp_jbusinessdirectory_date_formats fas

1 × SELECT fas.*                    
  FROM mwfjp_jbusinessdirectory_currencies fas

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

1 × SELECT * 
  FROM `mwfjp_template_styles`

```
1 × SELECT * 
  FROM mwfjp_languages
```

1 × SELECT *                    
  FROM mwfjp_jbusinessdirectory_mobile_app_confi

1 × SELECT id, name, offer_config as config 
  FROM mwfjp_jbusinessdirectory_default_attribute

1 × SELECT a.id AS value, a.name AS text, a.level, a.published, a.parent_id 
  FROM mwfjp_jbusinessdirectory_categories AS a 
  LEFT JOIN `mwfjp_jbusinessdirectory_categories` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

1 × SELECT t.*      
  from  mwfjp_jbusinessdirectory_categories c      
  inner join  mwfjp_jbusinessdirectory_language_translations t 
  on c.id=t.object_id

1 × select count(distinct co.id) as nr_offers,                           co.featured as featured  , cg1.name, cg1.id         
  from      mwfjp_jbusinessdirectory_company_offers co                     
  left join mwfjp_jbusinessdirectory_company_offer_category cc 
  on co.id=cc.offerId       
  left join mwfjp_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1      
  left join mwfjp_jbusinessdirectory_categories cg1 
  ON cg1.id = cg.parent_id or cg1.id=cg.id            
  left join  mwfjp_jbusinessdirectory_company_offer_types et 
  on co.offer_type=et.id

1 × select count(distinct co.id) as nr_offers,                           co.featured as featured  , et.name as typeName, co.offer_type as typeId         
  from      mwfjp_jbusinessdirectory_company_offers co                     
  left join mwfjp_jbusinessdirectory_company_offer_category cc 
  on co.id=cc.offerId       
  left join mwfjp_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1      
  left join mwfjp_jbusinessdirectory_categories cg1 
  ON cg1.id = cg.parent_id or cg1.id=cg.id            
  left join  mwfjp_jbusinessdirectory_company_offer_types et 
  on co.offer_type=et.id

1 × select id, name 
  from mwfjp_jbusinessdirectory_attributes

1 × select count(distinct co.id) as nr_offers,                           co.featured as featured  , a2.name, a2.id, ao2.name as optionName, ca2.value         
  from      mwfjp_jbusinessdirectory_company_offers co                     
  left join mwfjp_jbusinessdirectory_company_offer_category cc 
  on co.id=cc.offerId       
  left join mwfjp_jbusinessdirectory_categories cg 
  on cg.id=cc.categoryId 
  and cg.published=1      
  left join mwfjp_jbusinessdirectory_categories cg1 
  ON cg1.id = cg.parent_id or cg1.id=cg.id            
  left join  mwfjp_jbusinessdirectory_company_offer_types et 
  on co.offer_type=et.id       
  left join mwfjp_jbusinessdirectory_offer_attributes AS ca 
  on ca.offer_id=co.id      
  left join mwfjp_jbusinessdirectory_attributes a 
  on ca.attribute_id = a.id      
  left join mwfjp_jbusinessdirectory_attribute_options as ao 
  on ao.attribute_id = a.id 
  and ca.value = ao.id            
  left join mwfjp_jbusinessdirectory_offer_attributes AS ca2 
  on ca2.offer_id=co.id      
  left join mwfjp_jbusinessdirectory_attributes a2 
  on ca2.attribute_id = a2.id      
  left join mwfjp_jbusinessdirectory_attribute_options as ao2 
  on ao2.attribute_id = a2.id 
  and ca2.value = ao2.id

1 × select co.id, co.subject, co.short_description, co.description, co.address, co.main_subcategory, co.city, co.county, co.province, co.area, co.street_number, co.postalCode, co.latitude,                      co.longitude, co.startDate, co.endDate, co.alias, co.view_type, co.article_id, co.url, co.show_time, co.created, co.type, co.companyId, co.time_zone,         co.price, co.specialPrice, co.currencyId, co.countryId, co.price_text, co.packages,      co.quantity, co.enable_offer_selling,co.review_score, count(distinct cr.id) as nr_reviews,         et.name as offerType, et.id as typeId, bcm.markerLocation as categoryMaker,      op.picture_info, op.picture_path, op.picture_title,GROUP_CONCAT( DISTINCT cg.id,'|',cg.name,'|',cg.alias,'|',cg.icon,'|',cg.color  
  ORDER BY cg.name separator '#|') as categories,       co.featured as featured         ,cp.phone, cp.name as company_name, cp.id as company_id, cp.alias as company_alias, cp.logoLocation            
  from      mwfjp_jbusinessdirectory_company_offers co      
  left join mwfjp_jbusinessdirectory_company_reviews cr 
  on cr.itemId = co.id  
  and cr.review_type = 2 
  and cr.approved=2       
  left join  mwfjp_jbusinessdirectory_company_offer_pictures op 
  on co.id=op.offerId      
  and       (op.id in (         select  min(op1.id) as min 
  from mwfjp_jbusinessdirectory_company_offers co1         
  left join  mwfjp_jbusinessdirectory_company_offer_pictures op1 
  on co1.id=op1.offerId

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down 
  FROM mwfjp_modules AS m 
  LEFT JOIN mwfjp_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN mwfjp_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT *  
  FROM mwfjp_jmap_metainfo

1 × SELECT *  
  FROM mwfjp_jmap_canonicals

1 × SELECT * 
  FROM `mwfjp_extensions`

```
1 × SELECT * 
  FROM `mwfjp_users`
```

1 × SELECT *  
  FROM mwfjp_jmap_headings

1 × SELECT  `original_text`,  `target_text`,  `original_text_regex`,  `target_text_regex`  
  FROM  `mwfjp_jmap_text_replacements`

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

1 × INSERT INTO `mwfjp_honeysuckle_logs` (`ip`,`published`,`url`,`log`,`created`) 
  VALUES  ('216.73.216.231','1','https://oftopplata.ru/predloheniya?offerCategoryId=2595','Array\n(\n    [offerCategoryId] => 2595\n)\n','2026-11-08 08:50:04'

1 × DELETE  
  FROM `mwfjp_honeysuckle_logs`

1 × UPDATE `mwfjp_extensions` 
  SET `params` = '{\"mediaversion\":\"44714c4d1d36e036b3ba4f2f57e7fc94\"}'

1 × SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_default_attributes

1 × SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_attributes

1 × SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_categories

1 × SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_company_offers

1 × 
  SET SESSION group_concat_max_len = 1000

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

Сессия

Профилирование

Время

Память

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

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

50 запросов зарегистрировано 340.91 ms

8 повторяющихся запросов зарегистрировано

42 типов запросов зарегистрировано (отсортировано по вхождениям)

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

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

Карты обнаружены!

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

Сессия

Профилирование

Время

Память

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

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

50 запросов зарегистрировано 340.91 ms

8 повторяющихся запросов зарегистрировано

42 типов запросов зарегистрировано (отсортировано по вхождениям)

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

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