Объявления торговой точки

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

Сессия

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1794128305,
                "last": 1794128305,
                "now": 1794128307
            },
            "client": {
                "forwarded": "216.73.216.231"
            },
            "token": "5JUkmoXx3IcfxROGTjpHWmC2LxwJ3SFw"
        },
        "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": "201",
        "of-categorySearch": null,
        "offersMenuItemId": "501",
        "of-categoryId": null,
        "of-countrySearch": "",
        "of-citySearch": "",
        "of-regionSearch": "",
        "of-provinceSearch": "",
        "customAtrributes": {
            "23": "84"
        },
        "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": 7,
        "of-price-range": "",
        "of-itemType": 1,
        "categorySearch": null,
        "searchkeyword": "",
        "searchkeywordLocation": "",
        "typeSearch": "",
        "citySearch": "",
        "starRating": "",
        "regionSearch": "",
        "countrySearch": 0,
        "zipcode": "",
        "letter": "",
        "radius": 100,
        "provinceSearch": "",
        "areaSearch": "",
        "filter-by-fav": "",
        "filterParams": "",
        "categories": "",
        "onlyLocal": 0,
        "categoryId": null,
        "listing-search": true,
        "menuItemId": "201",
        "showCustomMarkers": 1,
        "moreFilters": null,
        "lSearchType": 1
    }
}

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

Время

Память

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

Время: 156.16 ms / 160.28 ms Память: 2.698 MB / 3.38 MB Application: afterInitialise

Время: 10.43 ms / 170.72 ms Память: 0.198 MB / 3.57 MB Application: Before Access::preloadComponents (all components)

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

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

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

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

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

Время: 132.38 ms / 341.63 ms Память: 1.823 MB / 5.69 MB Application: beforeRenderModule mod_checknumber (Mogunya (2))

Время: 6.66 ms / 348.29 ms Память: 0.022 MB / 5.71 MB Application: afterRenderModule mod_checknumber (Mogunya (2))

Время: 0.07 ms / 348.36 ms Память: 0.013 MB / 5.72 MB Application: beforeRenderModule mod_jbusiness_listings_search (Поиск торговых точек)

Время: 91.42 ms / 439.78 ms Память: 0.585 MB / 6.31 MB Application: afterRenderModule mod_jbusiness_listings_search (Поиск торговых точек)

Время: 13.57 ms / 453.35 ms Память: 0.057 MB / 6.37 MB Application: afterRenderComponent com_jbusinessdirectory

Время: 39.68 ms / 493.03 ms Память: 0.032 MB / 6.40 MB Application: afterDispatch

Время: 38.08 ms / 531.12 ms Память: 0.082 MB / 6.48 MB Application: beforeRenderModule mod_menu (Offcanvas)

Время: 11.86 ms / 542.98 ms Память: 0.036 MB / 6.52 MB Application: afterRenderModule mod_menu (Offcanvas)

Время: 0.04 ms / 543.02 ms Память: -0.000 MB / 6.52 MB Application: beforeRenderModule mod_tiptopuser (MOD_TIPTOPUSER (2))

Время: 0.22 ms / 543.24 ms Память: 0.019 MB / 6.53 MB Application: afterRenderModule mod_tiptopuser (MOD_TIPTOPUSER (2))

Время: 0.09 ms / 543.33 ms Память: -0.015 MB / 6.52 MB Application: beforeRenderModule mod_random_image (изо)

Время: 0.92 ms / 544.25 ms Память: 0.009 MB / 6.53 MB Application: afterRenderModule mod_random_image (изо)

Время: 0.06 ms / 544.31 ms Память: -0.002 MB / 6.53 MB Application: beforeRenderModule mod_menu (Company)

Время: 6.97 ms / 551.28 ms Память: 0.028 MB / 6.56 MB Application: afterRenderModule mod_menu (Company)

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

Время: 0.38 ms / 551.74 ms Память: 0.027 MB / 6.58 MB Application: afterRenderModule mod_menu (Меню1)

Время: 0.04 ms / 551.78 ms Память: -0.003 MB / 6.58 MB Application: beforeRenderModule mod_custom (999)

Время: 0.86 ms / 552.64 ms Память: 0.006 MB / 6.58 MB Application: afterRenderModule mod_custom (999)

Время: 5.62 ms / 558.26 ms Память: -0.002 MB / 6.58 MB Application: beforeRenderModule mod_custom (цитата)

Время: 0.12 ms / 558.38 ms Память: 0.003 MB / 6.58 MB Application: afterRenderModule mod_custom (цитата)

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

Время: 1.10 ms / 559.53 ms Память: 0.011 MB / 6.60 MB Application: afterRenderModule mod_breadcrumbs (крошки)

Время: 0.08 ms / 559.61 ms Память: 0.001 MB / 6.60 MB Application: beforeRenderModule mod_tiptopuser (MOD_TIPTOPUSER)

Время: 4.03 ms / 563.63 ms Память: 0.015 MB / 6.61 MB Application: afterRenderModule mod_tiptopuser (MOD_TIPTOPUSER)

Время: 22.70 ms / 586.33 ms Память: 0.665 MB / 7.28 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Время: 0.05 ms / 586.38 ms Память: 0.007 MB / 7.28 MB Application: After Access::getAssetRules (id:1 name:root.1)

Время: 1024.62 ms / 1611.00 ms Память: 1.098 MB / 8.38 MB Application: afterRender

Всего запросов к базе данных: 180.84 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	1.46 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.06 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; Используется сортировка файлов

#	Вызывающий объект	Файл и номер строки
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

#	Вызывающий объект	Файл и номер строки
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

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.03 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.03 ms

#	Вызывающий объект	Файл и номер строки
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

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

Профиль

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.07 ms
init	0.01 ms
System lock	0.01 ms
update	1.09 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.07 ms
closing tables	0.01 ms
freeing items	0.01 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 для получения ссылок на файлы]

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

DELETE 

  FROM `mwfjp_honeysuckle_logs`

  WHERE `created` < '2026-11-08 07:58:27'

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

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

Профиль

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.04 ms
init	0.01 ms
System lock	0.04 ms
updating	0.89 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.03 ms
freeing items	0.03 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 для получения ссылок на файлы]

Время запроса: 7.93 ms После последнего запроса: 17.75 ms Память запроса: 0.023 MB. Память перед запросом: 3.578 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.11 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.27 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.03 ms
cleaning up	0.02 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 для получения ссылок на файлы]

Время запроса: 5.41 ms После последнего запроса: 0.63 ms Память запроса: 0.060 MB. Память перед запросом: 3.636 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.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.02 ms
executing	1.48 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.03 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 для получения ссылок на файлы]

Время запроса: 2.44 ms После последнего запроса: 0.49 ms Память запроса: 0.021 MB. Память перед запросом: 3.917 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.08 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.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.03 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 для получения ссылок на файлы]

Время запроса: 3.94 ms После последнего запроса: 0.07 ms Память запроса: 0.021 MB. Память перед запросом: 3.923 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.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.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.02 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.11 ms После последнего запроса: 0.38 ms Память запроса: 0.084 MB. Память перед запросом: 3.703 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.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.13 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.03 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.10 ms После последнего запроса: 0.88 ms Память запроса: 0.084 MB. Память перед запросом: 3.758 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.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.05 ms
preparing	0.01 ms
executing	0.14 ms
end	0.00 ms
query end	0.06 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.03 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 для получения ссылок на файлы]

Время запроса: 1.66 ms После последнего запроса: 1.86 ms Память запроса: 0.022 MB. Память перед запросом: 3.829 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.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.00 ms
optimizing	0.01 ms
statistics	0.15 ms
preparing	0.02 ms
executing	0.03 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: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 для получения ссылок на файлы]

Время запроса: 3.53 ms После последнего запроса: 0.20 ms Память запроса: 0.004 MB. Память перед запросом: 3.819 MB

UPDATE `mwfjp_extensions`

  SET `params` = '{\"mediaversion\":\"779767460bb1b453d5158cf9605c9ed4\"}'

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

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

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

Профиль

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.07 ms
updating	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.06 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 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 для получения ссылок на файлы]

Время запроса: 1.85 ms После последнего запроса: 0.42 ms Память запроса: 0.019 MB. Память перед запросом: 3.827 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.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.06 ms
end	0.01 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.03 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 для получения ссылок на файлы]

Время запроса: 4.15 ms После последнего запроса: 49.91 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.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.09 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.03 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/search.php:23
14	JBusinessDirectoryModelSearch->__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.79 ms После последнего запроса: 0.62 ms Память запроса: 0.024 MB. Память перед запросом: 5.100 MB Возвращено строк: 5

SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_default_attributes`

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

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

Профиль

Status	Duration
starting	0.10 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.61 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.05 ms
Creating tmp table	0.06 ms
executing	0.12 ms
checking permissions	0.10 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.03 ms
end	0.00 ms
query end	2.89 ms
waiting for handler commit	0.06 ms
closing tables	0.07 ms
freeing items	0.08 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/search/view.html.php:80
10	JBusinessDirectoryViewSearch->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.27 ms После последнего запроса: 0.26 ms Память запроса: 0.023 MB. Память перед запросом: 5.134 MB Возвращено строк: 70

SELECT id, name, listing_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.08 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.08 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.03 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/search/view.html.php:80
10	JBusinessDirectoryViewSearch->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 для получения ссылок на файлы]

Время запроса: 3.32 ms После последнего запроса: 0.36 ms Память запроса: 0.024 MB. Память перед запросом: 5.162 MB Возвращено строк: 18

SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_attributes`

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

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

Профиль

Status	Duration
starting	0.07 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.45 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.05 ms
executing	0.07 ms
checking permissions	0.07 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.03 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.03 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/attribute.php:19
15	JTableAttribute->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/search.php:48
13	JBusinessDirectoryModelSearch->getTable()	JROOT/components/com_jbusinessdirectory/models/search.php:1918
12	JBusinessDirectoryModelSearch->getCustomAttributeValues()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:120
10	JBusinessDirectoryViewSearch->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 для получения ссылок на файлы]

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

select attribute_id,name,id 
  from mwfjp_jbusinessdirectory_attribute_options 
  where id in (84)

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

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

Профиль

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 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.03 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/attribute.php:87
13	JTableAttribute->getCustomAttributeValues()	JROOT/components/com_jbusinessdirectory/models/search.php:1953
12	JBusinessDirectoryModelSearch->getCustomAttributeValues()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:120
10	JBusinessDirectoryViewSearch->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 для получения ссылок на файлы]

Время запроса: 10.94 ms После последнего запроса: 0.71 ms Память запроса: 0.026 MB. Память перед запросом: 5.201 MB Возвращено строк: 87

SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_companies`

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

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

Профиль

Status	Duration
statistics	0.10 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
executing	3.52 ms
checking permissions	0.10 ms
checking permissions	0.02 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.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 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.39 ms
checking permissions	0.01 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.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.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.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 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.10 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.06 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:27
16	JTableCompany->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jbusinessdirectory/models/search.php:48
14	JBusinessDirectoryModelSearch->getTable()	JROOT/components/com_jbusinessdirectory/models/search.php:936
13	JBusinessDirectoryModelSearch->getTotal()	JROOT/components/com_jbusinessdirectory/models/search.php:968
12	JBusinessDirectoryModelSearch->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:148
10	JBusinessDirectoryViewSearch->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.23 ms После последнего запроса: 0.37 ms Память запроса: 0.007 MB. Память перед запросом: 5.307 MB


  SET SQL_BIG_SELECTS=1

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

EXPLAIN недоступен для: SET SQL_BIG_SELECTS=1

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
16	JDatabaseDriverMysqli->execute()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:6942
15	JBusinessUtil::setBigSqlSelects()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1150
14	JTableCompany->getTotalCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:955
13	JBusinessDirectoryModelSearch->getTotal()	JROOT/components/com_jbusinessdirectory/models/search.php:968
12	JBusinessDirectoryModelSearch->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:148
10	JBusinessDirectoryViewSearch->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 для получения ссылок на файлы]

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

select * 
  from 
					(select count(distinct cp.id) as nr_listings, cp.activity_radius, GROUP_CONCAT(DISTINCT a.id 
  ORDER BY a.id) as attributeSelection, cp.featured,
					
					cp.id
					 

					
  from mwfjp_jbusinessdirectory_companies cp

					
					
  left join mwfjp_jbusinessdirectory_company_activity_city cat 
  on cat.company_id=cp.id
					
  left join mwfjp_jbusinessdirectory_cities cty 
  on cty.id=cat.city_id
					
					
					
  left join mwfjp_jbusinessdirectory_company_activity_region car 
  on car.company_id=cp.id
					
  left join mwfjp_jbusinessdirectory_regions rg 
  on rg.id=car.region_id
					
  left join mwfjp_jbusinessdirectory_company_activity_country cac 
  on cac.company_id=cp.id
					
  left join mwfjp_jbusinessdirectory_countries cntr 
  on cntr.id=cac.country_id
					
					
					
					
					
					
					
					
					
					
					
  left join mwfjp_jbusinessdirectory_company_attributes AS ca 
  on ca.company_id=cp.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_company_attributes AS ca2 
  on ca2.company_id=cp.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 1         
					     
  and ( (ca.attribute_id = 23 
  and ( (ca.value like '%84%' or ca.option_id = 84) )))   
  and cp.state=1 
  and (cp.approved = 2 or cp.approved= -1 or cp.approved= 0)   
  and (cp.publish_start_date<=DATE(now()) or cp.publish_start_date='0000-00-00' or cp.publish_start_date is null) 
  and (cp.publish_end_date>=DATE(now()) or cp.publish_end_date='0000-00-00' or cp.publish_end_date is null)  
					         
					
  group by cp.id
					
  having 1 
					) s
					
  where 1  
  and attributeSelection ='23'

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	<derived2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	42	100.00	NULL
2	DERIVED	ca	NULL	ref	company_UNIQUE,idx_company_id,idx_attribute_id,idx_option_id	idx_attribute_id	4	const	41	15.79	Using where; Using temporary; Используется сортировка файлов
2	DERIVED	cp	NULL	eq_ref	PRIMARY,idx_type,idx_user,idx_state,idx_approved,idx_country,idx_package,idx_name,idx_keywords,idx_description,idx_city,idx_county,idx_maincat,idx_zipcode,idx_phone,idx_creationDate,idx_review_score,idx_province,idx_area,idx_publish_start_date,idx_publish_end_date,idx_alis,idx_alias	PRIMARY	4	oftopplata_r.ca.company_id	1	94.44	Using where
2	DERIVED	cat	NULL	ref	IND_UNQ,idx_company	IND_UNQ	5	oftopplata_r.ca.company_id	1	100.00	Using index
2	DERIVED	cty	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.cat.city_id	1	100.00	Using index
2	DERIVED	car	NULL	ref	IND_UNQ,idx_company	IND_UNQ	5	oftopplata_r.ca.company_id	1	100.00	Using index
2	DERIVED	rg	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.car.region_id	1	100.00	Using index
2	DERIVED	cac	NULL	ref	IND_UNQ	IND_UNQ	5	oftopplata_r.ca.company_id	1	100.00	Using index
2	DERIVED	cntr	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.cac.country_id	1	100.00	Using index
2	DERIVED	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
2	DERIVED	ao	NULL	eq_ref	PRIMARY,idx_attribute_id	PRIMARY	4	oftopplata_r.ca.value	1	100.00	Using where
2	DERIVED	ca2	NULL	ref	company_UNIQUE,idx_company_id	company_UNIQUE	4	oftopplata_r.ca.company_id	6	100.00	Using index
2	DERIVED	a2	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.ca2.attribute_id	1	100.00	Using index
2	DERIVED	ao2	NULL	eq_ref	PRIMARY,idx_attribute_id	PRIMARY	4	oftopplata_r.ca2.value	1	100.00	Using where

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1157
14	JTableCompany->getTotalCompaniesByNameAndCategories()	JROOT/components/com_jbusinessdirectory/models/search.php:955
13	JBusinessDirectoryModelSearch->getTotal()	JROOT/components/com_jbusinessdirectory/models/search.php:968
12	JBusinessDirectoryModelSearch->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:148
10	JBusinessDirectoryViewSearch->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.82 ms После последнего запроса: 0.39 ms Память запроса: 0.022 MB. Память перед запросом: 5.322 MB Возвращено строк: 16

SELECT DISTINCT UPPER(
  LEFT(name, 1)) as letter 
  FROM mwfjp_jbusinessdirectory_companies 
  WHERE approved=2 
  ORDER BY letter

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_jbusinessdirectory_companies	NULL	ref	idx_approved,idx_name	idx_approved	1	const	35	100.00	Using temporary; Используется сортировка файлов

Профиль

Status	Duration
starting	0.12 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.01 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.24 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.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jbusinessdirectory/tables/company.php:1525
13	JTableCompany->getUsedLettersForActiveBusiness()	JROOT/components/com_jbusinessdirectory/models/search.php:2216
12	JBusinessDirectoryModelSearch->getUsedLetter()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jbusinessdirectory/views/search/view.html.php:150
10	JBusinessDirectoryViewSearch->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 для получения ссылок на файлы]

Время запроса: 8.38 ms После последнего запроса: 0.61 ms Память запроса: 0.150 MB. Память перед запросом: 5.359 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.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
Opening tables	0.14 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.04 ms
executing	3.27 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.03 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/search/tmpl/default.php:74
13	include JROOT/components/com_jbusinessdirectory/views/search/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/search/view.html.php:198
10	JBusinessDirectoryViewSearch->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 для получения ссылок на файлы]

Время запроса: 4.84 ms После последнего запроса: 84.98 ms Память запроса: 0.025 MB. Память перед запросом: 5.776 MB Возвращено строк: 17

SELECT * 
  FROM mwfjp_jbusinessdirectory_categories 
				  
  WHERE parent_id=1 
  AND published=1 
  AND type=1  
			      
  ORDER BY lft

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	mwfjp_jbusinessdirectory_categories	NULL	index_merge	idx_parent,idx_state,idx_type	idx_parent,idx_type	4,1	NULL	17	97.42	Using intersect(idx_parent,idx_type); 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.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.28 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.02 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:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jbusiness_listings_search/helper.php:21
17	modJBusinessDirectoryHelper::getMainCategories()	JROOT/modules/mod_jbusiness_listings_search/helper.php:241
16	modJBusinessDirectoryHelper::filterCategories()	JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php:73
15	include JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:1157
13	include JROOT/components/com_jbusinessdirectory/views/search/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/search/view.html.php:198
10	JBusinessDirectoryViewSearch->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 для получения ссылок на файлы]

Время запроса: 9.65 ms После последнего запроса: 0.14 ms Память запроса: 0.063 MB. Память перед запросом: 5.811 MB Возвращено строк: 328

SELECT c.* 
  FROM mwfjp_jbusinessdirectory_categories c
                   
  INNER JOIN  mwfjp_jbusinessdirectory_categories  cc  
  ON c.parent_id = cc.id  
                   
  WHERE c.parent_id!=1 
  AND c.published=1  
  AND c.type=1
                   
  ORDER BY c.lft 
  LIMIT 0, 1000

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	idx_parent,idx_state,idx_type	idx_type	1	const	345	94.94	Using where; Используется сортировка файлов
1	SIMPLE	cc	NULL	eq_ref	PRIMARY	PRIMARY	4	oftopplata_r.c.parent_id	1	100.00	Using index

Профиль

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.06 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	4.99 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.04 ms
freeing items	0.01 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jbusiness_listings_search/helper.php:31
17	modJBusinessDirectoryHelper::getSubCategories()	JROOT/modules/mod_jbusiness_listings_search/helper.php:242
16	modJBusinessDirectoryHelper::filterCategories()	JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php:73
15	include JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:1157
13	include JROOT/components/com_jbusinessdirectory/views/search/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/search/view.html.php:198
10	JBusinessDirectoryViewSearch->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.70 ms После последнего запроса: 22.59 ms Память запроса: 0.024 MB. Память перед запросом: 6.204 MB Возвращено строк: 2

SELECT city, county 
                      
  FROM mwfjp_jbusinessdirectory_companies
                      
  WHERE state = 1 
  AND city != ''
                        
                      union
                      select  city, county 
                        
  from mwfjp_jbusinessdirectory_company_locations 
  where city != ''
                        
                  
  ORDER BY county ASC

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	mwfjp_jbusinessdirectory_companies	NULL	range	idx_state,idx_city	idx_city	183	NULL	3	94.44	Using index condition; Using where
2	UNION	mwfjp_jbusinessdirectory_company_locations	NULL	range	idx_city	idx_city	183	NULL	2	100.00	Using index condition
3	UNION RESULT	<union1,2>	NULL	ALL	NULL	INDEX KEY не используется	NULL	NULL	NULL	NULL	Using temporary; Используется сортировка файлов

Профиль

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

Стек вызовов

#	Вызывающий объект	Файл и номер строки
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_jbusiness_listings_search/helper.php:100
16	modJBusinessDirectoryHelper::getCitiesRegions()	JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php:150
15	include JROOT/modules/mod_jbusiness_listings_search/mod_jbusiness_listings_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
14	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:1157
13	include JROOT/components/com_jbusinessdirectory/views/search/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/search/view.html.php:198
10	JBusinessDirectoryViewSearch->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.32 ms После последнего запроса: 9.14 ms Память запроса: 0.024 MB. Память перед запросом: 6.106 MB Возвращено строк: 0

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

SELECT a.id, a.alias, a.catid, a.language

  FROM mwfjp_content AS a

  WHERE a.id = 0

План запросов (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.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 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.48 ms
cleaning up	0.04 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8786
18	JBusinessUtil::getArticleUrl()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8816
17	JBusinessUtil::getTermsAndConditions()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8849
16	JBusinessUtil::getTermsUrl()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8874
15	JBusinessUtil::renderTermsAndConditions()	JROOT/components/com_jbusinessdirectory/include/listings_list_utils.php:92
14	require_once JROOT/components/com_jbusinessdirectory/include/listings_list_utils.php	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:1438
13	include JROOT/components/com_jbusinessdirectory/views/search/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/search/view.html.php:198
10	JBusinessDirectoryViewSearch->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.56 ms После последнего запроса: 0.13 ms Память запроса: 0.024 MB. Память перед запросом: 6.115 MB Возвращено строк: 0

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

SELECT a.id, a.alias, a.catid, a.language

  FROM mwfjp_content AS a

  WHERE a.id = 0

План запросов (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.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.46 ms
cleaning up	0.02 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8786
18	JBusinessUtil::getArticleUrl()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8828
17	JBusinessUtil::getTermsAndConditions()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8849
16	JBusinessUtil::getTermsUrl()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8876
15	JBusinessUtil::renderTermsAndConditions()	JROOT/components/com_jbusinessdirectory/include/listings_list_utils.php:92
14	require_once JROOT/components/com_jbusinessdirectory/include/listings_list_utils.php	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:1438
13	include JROOT/components/com_jbusinessdirectory/views/search/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/search/view.html.php:198
10	JBusinessDirectoryViewSearch->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.33 ms После последнего запроса: 0.39 ms Память запроса: 0.024 MB. Память перед запросом: 6.140 MB Возвращено строк: 0

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

SELECT a.id, a.alias, a.catid, a.language

  FROM mwfjp_content AS a

  WHERE a.id = 0

План запросов (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.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.01 ms
optimizing	0.01 ms
statistics	0.03 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	1.12 ms
cleaning up	0.03 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8786
18	JBusinessUtil::getArticleUrl()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8834
17	JBusinessUtil::getTermsAndConditions()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8849
16	JBusinessUtil::getTermsUrl()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8874
15	JBusinessUtil::renderTermsAndConditions()	JROOT/components/com_jbusinessdirectory/include/listings_list_utils.php:214
14	require_once JROOT/components/com_jbusinessdirectory/include/listings_list_utils.php	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:1438
13	include JROOT/components/com_jbusinessdirectory/views/search/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/search/view.html.php:198
10	JBusinessDirectoryViewSearch->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.10 ms Память запроса: 0.024 MB. Память перед запросом: 6.149 MB Возвращено строк: 0

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

SELECT a.id, a.alias, a.catid, a.language

  FROM mwfjp_content AS a

  WHERE a.id = 0

План запросов (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.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Стек вызовов

#	Вызывающий объект	Файл и номер строки
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8786
18	JBusinessUtil::getArticleUrl()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8828
17	JBusinessUtil::getTermsAndConditions()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8849
16	JBusinessUtil::getTermsUrl()	JROOT/components/com_jbusinessdirectory/helpers/utils.php:8876
15	JBusinessUtil::renderTermsAndConditions()	JROOT/components/com_jbusinessdirectory/include/listings_list_utils.php:214
14	require_once JROOT/components/com_jbusinessdirectory/include/listings_list_utils.php	JROOT/components/com_jbusinessdirectory/views/search/tmpl/default.php:1438
13	include JROOT/components/com_jbusinessdirectory/views/search/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/search/view.html.php:198
10	JBusinessDirectoryViewSearch->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.59 ms После последнего запроса: 110.86 ms Память запроса: 0.021 MB. Память перед запросом: 6.594 MB Возвращено строк: 0

SELECT *
 
  FROM mwfjp_jmap_metainfo
 
  WHERE `linkurl` = 'https://oftopplata.ru/tiptop-tochki?attribute_23=84'
 
  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.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.00 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.01 ms
cleaning up	0.03 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 для получения ссылок на файлы]

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

SELECT *
 
  FROM mwfjp_jmap_canonicals
 
  WHERE `linkurl` = 'https://oftopplata.ru/tiptop-tochki?attribute_23=84'

План запросов (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.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	1.27 ms
cleaning up	0.02 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.34 ms После последнего запроса: 0.22 ms Память запроса: 0.023 MB. Память перед запросом: 6.619 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.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 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.03 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 для получения ссылок на файлы]

Время запроса: 3.45 ms После последнего запроса: 13.93 ms Память запроса: 0.020 MB. Память перед запросом: 7.270 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.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 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.02 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 для получения ссылок на файлы]

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

SELECT *
 
  FROM mwfjp_jmap_headings
 
  WHERE `linkurl` = 'https://oftopplata.ru/tiptop-tochki?attribute_23=84'

План запросов (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.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.00 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.03 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 для получения ссылок на файлы]

Время запроса: 0.32 ms После последнего запроса: 0.12 ms Память запроса: 0.020 MB. Память перед запросом: 7.285 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.06 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.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.03 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.02 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 для получения ссылок на файлы]

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

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

4 × SELECT a.id, a.alias, a.catid, a.language 
  FROM mwfjp_content AS a

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, listing_config as config 
  FROM mwfjp_jbusinessdirectory_default_attribute

1 × select attribute_id,name,id 
  from mwfjp_jbusinessdirectory_attribute_options

1 × select * 
  from       (select count(distinct cp.id) as nr_listings, cp.activity_radius, GROUP_CONCAT(DISTINCT a.id 
  ORDER BY a.id) as attributeSelection, cp.featured,            cp.id              
  from mwfjp_jbusinessdirectory_companies cp             
  left join mwfjp_jbusinessdirectory_company_activity_city cat 
  on cat.company_id=cp.id      
  left join mwfjp_jbusinessdirectory_cities cty 
  on cty.id=cat.city_id                  
  left join mwfjp_jbusinessdirectory_company_activity_region car 
  on car.company_id=cp.id      
  left join mwfjp_jbusinessdirectory_regions rg 
  on rg.id=car.region_id      
  left join mwfjp_jbusinessdirectory_company_activity_country cac 
  on cac.company_id=cp.id      
  left join mwfjp_jbusinessdirectory_countries cntr 
  on cntr.id=cac.country_id                                                                  
  left join mwfjp_jbusinessdirectory_company_attributes AS ca 
  on ca.company_id=cp.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_company_attributes AS ca2 
  on ca2.company_id=cp.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 DISTINCT UPPER(
  LEFT(name, 1)) as letter 
  FROM mwfjp_jbusinessdirectory_companies

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_jbusinessdirectory_categories

1 × SELECT c.* 
  FROM mwfjp_jbusinessdirectory_categories c                    
  INNER JOIN  mwfjp_jbusinessdirectory_categories  cc  
  ON c.parent_id = cc.id

1 × SELECT city, county                        
  FROM mwfjp_jbusinessdirectory_companies

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/tiptop-tochki?attribute_23=84','Array\n(\n    [attribute_23] => 84\n)\n','2026-11-08 08:58:27'

1 × DELETE  
  FROM `mwfjp_honeysuckle_logs`

1 × UPDATE `mwfjp_extensions` 
  SET `params` = '{\"mediaversion\":\"779767460bb1b453d5158cf9605c9ed4\"}'

1 × SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_default_attributes

1 × SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_attributes

1 × SHOW FULL COLUMNS 
  FROM `mwfjp_jbusinessdirectory_companies

```
1 × 
  SET SQL_BIG_SELECTS=
```

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

Сессия

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

Время

Память

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

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

43 запросов зарегистрировано 180.84 ms

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

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

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

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

Что такое Торгуник?

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

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

Сессия

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

Время

Память

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

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

43 запросов зарегистрировано 180.84 ms

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

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

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

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